/cfg/cds_Solution

DDL: /CFG/CDS_SOLUTION SQL: /CFG/V_SOLUTION Type: view

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)

SourceAliasJoin 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)

NameValueLevelField
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)

KeyFieldSource TableSource FieldDescription
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 */
;