P_CntrlPurContrItmCndValPlnt

DDL: P_CNTRLPURCONTRITMCNDVALPLNT SQL: PCCTRITMCNDPLNT Type: view BASIC Package: VDM_MM_PUR_CCTR
9 Fields 2 Data Sources

Central Contract Item plant dependent Condition Validity

P_CntrlPurContrItmCndValPlnt is a Basic CDS View that provides data about "Central Contract Item plant dependent Condition Validity" in SAP S/4HANA. It reads from 2 data sources (konp, a4ma) and exposes 9 fields with key fields ConditionRecord, ConditionValidityEndDate. Part of development package VDM_MM_PUR_CCTR.

Data Sources (2)

SourceAliasJoin Type
konp CndnItem inner
a4ma CntrlPurContrItmCndValdty from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName PCCTRITMCNDPLNT 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 a4ma knumh NoCondRec.Batch
KEY ConditionValidityEndDate a4ma datbi Validity period
ConditionApplication a4ma kappl Application
ConditionType a4ma kschl Tax Item Type
CentralPurchaseContract a4ma evrtn Purchasing Doc.
CentralPurchaseContractItem a4ma evrtp Item
ConditionValidityStartDate a4ma datab Validity period
ProcmtHubPlantUniqueID a4ma be_plant_unique_id Plant Unique ID
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_CntrlPurContrItmCndValPlnt.
-- 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: PCCTRITMCNDPLNT

CREATE VIEW P_CntrlPurContrItmCndValPlnt AS
SELECT
  CntrlPurContrItmCndValdty.knumh AS ConditionRecord,
  CntrlPurContrItmCndValdty.datbi AS ConditionValidityEndDate,
  CntrlPurContrItmCndValdty.kappl AS ConditionApplication,
  CntrlPurContrItmCndValdty.kschl AS ConditionType,
  CntrlPurContrItmCndValdty.evrtn AS CentralPurchaseContract,
  CntrlPurContrItmCndValdty.evrtp AS CentralPurchaseContractItem,
  CntrlPurContrItmCndValdty.datab AS ConditionValidityStartDate,
  CntrlPurContrItmCndValdty.be_plant_unique_id AS ProcmtHubPlantUniqueID,
  CndnItem.loevm_ko AS ConditionIsDeleted
FROM a4ma AS CntrlPurContrItmCndValdty
INNER JOIN konp AS CndnItem ON /* join condition not captured in parsed metadata */
;

Learn More