I_CmplRqRsltLblFldData

DDL: I_CMPLRQRSLTLBLFLDDATA Type: view_entity BASIC
12 Fields 1 Data Sources 1 Associations

Label Field data

I_CmplRqRsltLblFldData is a Basic CDS View that provides data about "Label Field data" in SAP S/4HANA. It reads from 1 data source (ehlbld_crr_data) and exposes 12 fields with key field CmplRqRsltLblFieldDataUUID. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
ehlbld_crr_data ehlbld_crr_data from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_CmplRqRslt _CmplRqRslt $projection.CmplRqRsltUUID = _CmplRqRslt.CmplRqRsltUUID

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Label Field data view
VDM.viewType #BASIC view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #XXL view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY CmplRqRsltLblFieldDataUUID cmplrqrsltlblfielddatauuid
CmplRqRsltUUID cmplrqrsltuuid SDS Assessment
PCLblFieldDataVersion pclblfielddataversion
PCLblFieldDataUnpckgdProdUUID pclblfielddataunpckgdproduuid
ProdCmplncLabelFieldID prodcmplnclabelfieldid Label Field ID
ProdCmplncPhrsUUID prodcmpincphrsuuid Phrase UUID
RgtyGrphcUUID rgtygrphcuuid Graphic UUID
CreationDateTime creationutcdatetime Time Stamp
CreatedByUser createdbyuser User Name
LastChangeDateTime lastchangeutcdatetime Time Stamp
LastChangedByUser lastchangedbyuser User Name
_CmplRqRslt _CmplRqRslt

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 I_CmplRqRsltLblFldData.
-- 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.

CREATE VIEW I_CmplRqRsltLblFldData AS
SELECT
  CmplRqRsltLblFieldDataUUID,
  CmplRqRsltUUID,
  PCLblFieldDataVersion,
  PCLblFieldDataUnpckgdProdUUID,
  ProdCmplncLabelFieldID,
  prodcmpincphrsuuid AS ProdCmplncPhrsUUID,
  RgtyGrphcUUID,
  creationutcdatetime AS CreationDateTime,
  CreatedByUser,
  lastchangeutcdatetime AS LastChangeDateTime,
  LastChangedByUser
FROM ehlbld_crr_data
LEFT OUTER JOIN I_CmplRqRslt AS _CmplRqRslt ON CmplRqRsltUUID = _CmplRqRslt.CmplRqRsltUUID  -- association [1..1]
;

Learn More