/cfg/cds_Solution
CDS view for Solution with Parameters
/cfg/cds_Solution is a CDS View that provides data about "CDS view for Solution with Parameters" in SAP S/4HANA. It reads from 19 data sources and exposes 42 fields with key fields solution_id, prjid, bbid, objid, objty.
Data Sources (19)
| Source | Alias | Join Type |
|---|---|---|
| /smb/bb_lib_i | actid | left_outer |
| /smb/bb_lib_i | actid | left_outer |
| /smb/bbpr_i | bbtid | left_outer |
| /smb/bbpr_i | bbtid | left_outer |
| /smb/bc_variant | bcset | left_outer |
| /smb/bc_variant | bcset | left_outer |
| dd02l | dd02l | left_outer |
| dd02l | dd02l | left_outer |
| dd25v | dd25v | left_outer |
| dd25v | dd25v | left_outer |
| dd26s | dd26s | left_outer |
| dd26s | dd26s | left_outer |
| /smb/sb_t_005 | ecatt | left_outer |
| /smb/sb_t_005 | ecatt | left_outer |
| /cfg/CDS_ECATT_VERSION | ecatt_version | left_outer |
| /smb/bb_img_sobj | objid | left_outer |
| /smb/bb_img_sobj | objid | left_outer |
| /smb/bb_prj_et01 | scoid | left_outer |
| /smb/bb_prj_et01 | scoid | left_outer |
Annotations (7)
| Name | Value | Level | Field |
|---|---|---|---|
| AbapCatalog.sqlViewName | /CFG/V_SOLUTION | view | |
| ObjectModel.usageType.serviceQuality | #C | view | |
| ObjectModel.usageType.sizeCategory | #L | view | |
| ObjectModel.usageType.dataClass | #MIXED | view | |
| AbapCatalog.compiler.compareFilter | true | view | |
| AccessControl.authorizationCheck | #CHECK | view | |
| EndUserText.label | CDS view for Solution with Parameters | view |
Fields (42)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | solution_id | solid | scope | Visibility |
| KEY | prjid | /smb/bb_prj_et01 | prjid | Scope Item |
| KEY | bbid | /smb/bbpr_i | bbid | Building Block |
| KEY | objid | /smb/bb_lib_i | objid | Work Center |
| KEY | objty | /smb/bb_lib_i | objty | Prj. Obj. Type |
| KEY | seqnum | /smb/bb_lib_i | seqnum | Sequential Number |
| KEY | tablename | /smb/bc_variant | tablename | Table/View Name |
| KEY | subobjname | /smb/bb_img_sobj | subobjname | Table/View Name |
| KEY | cust_obj | /smb/bb_img_sobj | cust_objname | Object |
| KEY | cust_typ | /smb/bb_img_sobj | cust_objtype | Type |
| KEY | filename | /smb/bb_img_sobj | filename | URL or Filenam Path |
| KEY | ecatt_id | /smb/sb_t_005 | objid | Work Center |
| KEY | param_name | /smb/sb_t_005 | pname | SNC name |
| KEY | pos | /smb/sb_t_005 | pindex | ParameterIndex |
| KEY | dom | /smb/sb_t_005 | pdom | Domain |
| KEY | datlen | /smb/sb_t_005 | pdatlen | Length |
| KEY | datatyp | /smb/sb_t_005 | pinttyp | ABAP Data Type |
| KEY | rollname | /smb/sb_t_005 | pref_name2 | Parameter Reference |
| KEY | objectname | dd26s | viewname | View Name |
| KEY | tabname | dd26s | tabname | Table/Constant Value |
| KEY | subobj_typ | dd02l | tabclass | Table Category |
| prjid | /smb/bb_prj_et01 | prjid | Scope Item | |
| bbid | /smb/bbpr_i | bbid | Building Block | |
| objid | /smb/bb_lib_i | objid | Work Center | |
| objty | /smb/bb_lib_i | objty | Prj. Obj. Type | |
| seqnum | /smb/bb_lib_i | seqnum | Sequential Number | |
| tablename | /smb/bc_variant | tablename | Table/View Name | |
| subobjname | /smb/bb_img_sobj | subobjname | Table/View Name | |
| cust_obj | /smb/bb_img_sobj | cust_objname | Object | |
| cust_typ | /smb/bb_img_sobj | cust_objtype | Type | |
| filename | /smb/bb_lib_i | filename | URL or Filenam Path | |
| ecatt_id | /smb/sb_t_005 | objid | Work Center | |
| param_name | /smb/sb_t_005 | pname | SNC name | |
| pos | /smb/sb_t_005 | pindex | ParameterIndex | |
| dom | /smb/sb_t_005 | pdom | Domain | |
| datlen | /smb/sb_t_005 | pdatlen | Length | |
| datatyp | /smb/sb_t_005 | pinttyp | ABAP Data Type | |
| rollname | /smb/sb_t_005 | pref_name2 | Parameter Reference | |
| objectname | dd26s | viewname | View Name | |
| tabname | dd26s | tabname | Table/Constant Value | |
| subobj_typ | dd02l | tabclass | Table Category | |
| viewclass | dd25v | viewclass | View Type |
Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.
-- Derived SQL interpretation of CDS view /cfg/cds_Solution.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: /CFG/V_SOLUTION
CREATE VIEW /cfg/cds_Solution AS
SELECT
solid.scope AS solution_id,
scoid.prjid AS prjid,
bbtid.bbid AS bbid,
actid.objid AS objid,
actid.objty AS objty,
actid.seqnum AS seqnum,
bcset.tablename AS tablename,
objid.subobjname AS subobjname,
objid.cust_objname AS cust_obj,
objid.cust_objtype AS cust_typ,
objid.filename AS filename,
ecatt.objid AS ecatt_id,
ecatt.pname AS param_name,
ecatt.pindex AS pos,
ecatt.pdom AS dom,
ecatt.pdatlen AS datlen,
ecatt.pinttyp AS datatyp,
ecatt.pref_name2 AS rollname,
dd26s.viewname AS objectname,
dd26s.tabname AS tabname,
dd02l.tabclass AS subobj_typ,
dd25v.viewclass AS viewclass
LEFT OUTER JOIN /smb/bb_prj_et01 AS scoid ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN /smb/bbpr_i AS bbtid ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN /smb/bb_lib_i AS actid ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN /smb/bc_variant AS bcset ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN /smb/bb_img_sobj AS objid ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN /smb/sb_t_005 AS ecatt ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN dd26s ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN dd25v ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN dd02l ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN /cfg/CDS_ECATT_VERSION AS ecatt_version ON /* join condition not captured in parsed metadata */
;
Learn More
- CDS View Annotations — A Complete Guide
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- BW Extractor to CDS View Migration Guide
- S/4HANA CDS View Deprecation: What You Need to Know
- ABAP CDS View Tutorial — From Basics to Real-World Examples
- RAP and CDS Views — Building Transactional Apps in SAP S/4HANA
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA