P_PurContrItmCndnValPlnt

DDL: P_PURCONTRITMCNDNVALPLNT SQL: PCTRCNDNVALPLNT Type: view BASIC
9 Fields 2 Data Sources

P_PurContrItmCndnValPlnt is a Basic CDS View in SAP S/4HANA. It reads from 2 data sources (konp, a068) and exposes 9 fields with key fields ConditionRecord, ConditionValidityEndDate.

Data Sources (2)

SourceAliasJoin Type
konp CndnItem inner
a068 PurContrItmCndValdty from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PCTRCNDNVALPLNT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
VDM.private true view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY ConditionRecord a068 knumh NoCondRec.Batch
KEY ConditionValidityEndDate a068 datbi Validity period
ConditionApplication a068 kappl Application
ConditionType a068 kschl Tax Item Type
PurchaseContract a068 evrtn Purchasing Doc.
PurchaseContractItem a068 evrtp Item
ConditionValidityStartDate a068 datab Validity period
Plant a068 werks Receiving Plant
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_PurContrItmCndnValPlnt.
-- 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: PCTRCNDNVALPLNT

CREATE VIEW P_PurContrItmCndnValPlnt AS
SELECT
  PurContrItmCndValdty.knumh AS ConditionRecord,
  PurContrItmCndValdty.datbi AS ConditionValidityEndDate,
  PurContrItmCndValdty.kappl AS ConditionApplication,
  PurContrItmCndValdty.kschl AS ConditionType,
  PurContrItmCndValdty.evrtn AS PurchaseContract,
  PurContrItmCndValdty.evrtp AS PurchaseContractItem,
  PurContrItmCndValdty.datab AS ConditionValidityStartDate,
  PurContrItmCndValdty.werks AS Plant,
  CndnItem.loevm_ko AS ConditionIsDeleted
FROM a068 AS PurContrItmCndValdty
INNER JOIN konp AS CndnItem ON /* join condition not captured in parsed metadata */
;

Learn More