/DMBE/i_cds_field_by_tab_name

DDL: /DMBE/I_CDS_FIELD_BY_TAB_NAME SQL: /DMBE/IFIELDTAB Type: view

Deal Header for dll_name

/DMBE/i_cds_field_by_tab_name is a CDS View that provides data about "Deal Header for dll_name" in SAP S/4HANA. It reads from 3 data sources (/dmbe/i_CDS_DLL_Name, /dmbe/i_CDS_Tab_Name, /dmbe/i_CDS_Field_Name) and exposes 2 fields.

Data Sources (3)

SourceAliasJoin Type
/dmbe/i_CDS_DLL_Name /dmbe/i_CDS_DLL_Name inner
/dmbe/i_CDS_Tab_Name dd26s from
/dmbe/i_CDS_Field_Name dd27s inner

Parameters (1)

NameTypeDefault
P_ddl_name ddlname

Annotations (8)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName /DMBE/IFIELDTAB view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Deal Header for dll_name view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #META view

Fields (2)

KeyFieldSource TableSource FieldDescription
viewfield /dmbe/i_CDS_Field_Name viewfield View field
tabname /dmbe/i_CDS_Tab_Name tabname Table/Constant Value

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 /DMBE/i_cds_field_by_tab_name.
-- 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: /DMBE/IFIELDTAB
-- Parameters: P_ddl_name : ddlname

CREATE VIEW /DMBE/i_cds_field_by_tab_name AS
SELECT
  dd27s.viewfield AS viewfield,
  dd26s.tabname AS tabname
FROM /dmbe/i_CDS_Tab_Name AS dd26s
INNER JOIN /dmbe/i_CDS_Field_Name AS dd27s ON /* join condition not captured in parsed metadata */
INNER JOIN /dmbe/i_CDS_DLL_Name ON /* join condition not captured in parsed metadata */
;