P_PCF_Field_Current_Version

DDL: P_PCF_FIELD_CURRENT_VERSION Type: view_entity
2 Fields 2 Associations

Predefined Fields: Current Version

P_PCF_Field_Current_Version is a CDS View that provides data about "Predefined Fields: Current Version" in SAP S/4HANA. It has 2 associations to related views.

Associations (2)

CardinalityTargetAliasCondition
[0..1] pcf_c_rep_field activeVersion activeVersion.node_name = repository.node_name and activeVersion.field_name = repository.field_name and activeVersion.version = 'A'
[0..1] pcf_c_rep_field inactiveVersion inactiveVersion.node_name = repository.node_name and inactiveVersion.field_name = repository.field_name and inactiveVersion.version = 'N'

Annotations (2)

NameValueLevelField
EndUserText.label Predefined Fields: Current Version view
AccessControl.authorizationCheck #NOT_ALLOWED view

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY node_name repository node_name Object Name
KEY field_name repository field_name VAT Declaration Fld

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 P_PCF_Field_Current_Version.
-- 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 P_PCF_Field_Current_Version AS
SELECT
  repository.node_name AS node_name,
  repository.field_name AS field_name
LEFT OUTER JOIN pcf_c_rep_field AS activeVersion ON activeVersion.node_name = repository.node_name AND activeVersion.field_name = repository.field_name AND activeVersion.version = 'A'  -- association [0..1]
LEFT OUTER JOIN pcf_c_rep_field AS inactiveVersion ON inactiveVersion.node_name = repository.node_name AND inactiveVersion.field_name = repository.field_name AND inactiveVersion.version = 'N'  -- association [0..1]
;

Learn More