P_CntrlPurContrHdrCndnValdty

DDL: P_CNTRLPURCONTRHDRCNDNVALDTY SQL: PCCTRHDRCNDVAL Type: view BASIC
7 Fields 3 Data Sources

P_CntrlPurContrHdrCndnValdty is a Basic CDS View in SAP S/4HANA. It reads from 3 data sources (konp, a019, R_CentralPurchaseContract) and exposes 7 fields with key fields ConditionRecord, ConditionValidityEndDate.

Data Sources (3)

SourceAliasJoin Type
konp CndnHdr inner
a019 CtrtHdr from
R_CentralPurchaseContract R_CentralPurchaseContract inner

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName PCCTRHDRCNDVAL view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.private true view
VDM.viewType #BASIC view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY ConditionRecord a019 knumh NoCondRec.Batch
KEY ConditionValidityEndDate a019 datbi Validity period
ConditionApplication a019 kappl Application
ConditionType a019 kschl Tax Item Type
CentralPurchaseContract a019 evrtn Purchasing Doc.
ConditionValidityStartDate a019 datab Validity period
ConditionIsDeleted konp loevm_ko Deletion Indic.

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_CntrlPurContrHdrCndnValdty.
-- 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: PCCTRHDRCNDVAL

CREATE VIEW P_CntrlPurContrHdrCndnValdty AS
SELECT
  CtrtHdr.knumh AS ConditionRecord,
  CtrtHdr.datbi AS ConditionValidityEndDate,
  CtrtHdr.kappl AS ConditionApplication,
  CtrtHdr.kschl AS ConditionType,
  CtrtHdr.evrtn AS CentralPurchaseContract,
  CtrtHdr.datab AS ConditionValidityStartDate,
  CndnHdr.loevm_ko AS ConditionIsDeleted
FROM a019 AS CtrtHdr
INNER JOIN konp AS CndnHdr ON /* join condition not captured in parsed metadata */
INNER JOIN R_CentralPurchaseContract ON /* join condition not captured in parsed metadata */
;

Learn More