P_PurContrHdrCndnValdty

DDL: P_PURCONTRHDRCNDNVALDTY SQL: PPCTRHDRCNDVAL Type: view BASIC
7 Fields 3 Data Sources

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

Data Sources (3)

SourceAliasJoin Type
konp CndnHdr inner
a019 CtrtHdr from
R_PurchaseContract R_PurchaseContract inner

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName PPCTRHDRCNDVAL 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
PurchaseContract 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_PurContrHdrCndnValdty.
-- 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: PPCTRHDRCNDVAL

CREATE VIEW P_PurContrHdrCndnValdty AS
SELECT
  CtrtHdr.knumh AS ConditionRecord,
  CtrtHdr.datbi AS ConditionValidityEndDate,
  CtrtHdr.kappl AS ConditionApplication,
  CtrtHdr.kschl AS ConditionType,
  CtrtHdr.evrtn AS PurchaseContract,
  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_PurchaseContract ON /* join condition not captured in parsed metadata */
;

Learn More