I_ProdCmplncPhrsDraft

DDL: I_PRODCMPLNCPHRSDRAFT Type: view BASIC
16 Fields 1 Data Sources 2 Associations

Phrase Draft

I_ProdCmplncPhrsDraft is a Basic CDS View that provides data about "Phrase Draft" in SAP S/4HANA. It reads from 1 data source (ehfndw_phrs) and exposes 16 fields with key field ProdCmplncPhrsUUID. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
ehfndw_phrs ehfndw_phrs from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_DraftAdministrativeData _DraftAdministrativeData _DraftAdministrativeData.DraftUUID = $projection.DraftAdministrativeDataUUID and _DraftAdministrativeData.DraftEntityType = 'R_PRODCMPLNCPHRSENABLEDFIELDTP'
[1..1] I_ProdCmplncPhrsEnbldFldDraft _ProdCmplncPhrsEnabledField $projection.ProdCmplncPhrsEnabledFldUUID = _ProdCmplncPhrsEnabledField.ProdCmplncPhrsEnabledFldUUID

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IPCPHRSDR view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Phrase Draft view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #BASIC view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY ProdCmplncPhrsUUID prodcmplncphrsuuid Phrase UUID
ProdCmplncPhrsEnabledFldUUID prodcmplncphrsenabledflduuid Phrase-Enabled Field UUID
ContentProvider contentprovider Content Provider
ProdCmplncPhrs prodcmplncphrs Phrase ID
ProdCmplncPhrsCode prodcmplncphrscode Phrase Code
ProdCmplncPhrsNote prodcmplncphrsnote Additional Notes
ProdCmplncPhrsIsHidden prodcmplncphrsishidden Hide Phrase
ProdCmplncPhrsIsHistorical prodcmplncphrsishistorical Is Historical
ProdCmplncPhrsSyncUUID prodcmplncphrssyncuuid Phrase Synchronization UUID
CreationDateTime creationdatetime Timestamp
CreatedByUser createdbyuser User Name
LastChangeDateTime lastchangedatetime Timestamp
LastChangedByUser lastchangedbyuser User Name
DraftAdministrativeDataUUID draftadministrativedatauuid UUID
_DraftAdministrativeData _DraftAdministrativeData
_ProdCmplncPhrsEnabledField _ProdCmplncPhrsEnabledField

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_ProdCmplncPhrsDraft.
-- 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_ProdCmplncPhrsDraft AS
SELECT
  ProdCmplncPhrsUUID,
  ProdCmplncPhrsEnabledFldUUID,
  ContentProvider,
  ProdCmplncPhrs,
  ProdCmplncPhrsCode,
  ProdCmplncPhrsNote,
  ProdCmplncPhrsIsHidden,
  ProdCmplncPhrsIsHistorical,
  ProdCmplncPhrsSyncUUID,
  CreationDateTime,
  CreatedByUser,
  LastChangeDateTime,
  LastChangedByUser,
  DraftAdministrativeDataUUID
FROM ehfndw_phrs
LEFT OUTER JOIN I_DraftAdministrativeData AS _DraftAdministrativeData ON _DraftAdministrativeData.DraftUUID = DraftAdministrativeDataUUID AND _DraftAdministrativeData.DraftEntityType = 'R_PRODCMPLNCPHRSENABLEDFIELDTP'  -- association [1..1]
LEFT OUTER JOIN I_ProdCmplncPhrsEnbldFldDraft AS _ProdCmplncPhrsEnabledField ON ProdCmplncPhrsEnabledFldUUID = _ProdCmplncPhrsEnabledField.ProdCmplncPhrsEnabledFldUUID  -- association [1..1]
;

Learn More