P_CntrlPurContrDistribution

DDL: P_CNTRLPURCONTRDISTRIBUTION SQL: PCNTRLPCONDSTR Type: view BASIC Package: VDM_MM_PUR_CCTR
50 Fields 1 Data Sources

Basic View for Central Contract Distribution

P_CntrlPurContrDistribution is a Basic CDS View that provides data about "Basic View for Central Contract Distribution" in SAP S/4HANA. It reads from 1 data source (ekpo_distr) and exposes 50 fields with key fields CentralPurchaseContract, CentralPurchaseContractItem, DistributionKey. Part of development package VDM_MM_PUR_CCTR.

Data Sources (1)

SourceAliasJoin Type
ekpo_distr ekpo_distr from

Annotations (10)

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

Fields (50)

KeyFieldSource TableSource FieldDescription
KEY CentralPurchaseContract purchasingdocument Purchasing Document
KEY CentralPurchaseContractItem purchasingdocumentitem Purchasing Doc. Item
KEY DistributionKey ekpo_distr distributionnumber Distr. Number
PurchasingDocumentCategory ekpo_distr purchasingdocumentcategory Doc. Category
PurchasingDocumentType ekpo_distr purchasingdocumenttype RFQ Type
PurchasingOrganization ekpo_distr purchasingorganization Purchasing Organization
CompanyCode ekpo_distr companycode Receiver Company Code
Plant ekpo_distr plant Valuation Area
LogicalSystem ekpo_distr logicalsystem Logical System
DocumentCurrency ekpo_distr documentcurrency Document Currency
Currency ekpo_distr documentcurrency Document Currency
PurchasingGroup ekpo_distr purchasinggroup Purchasing Group
StorageLocation ekpo_distr storagelocation StorageLocation
PaymentTerms ekpo_distr paymentterms Pyt Terms
CashDiscount1Days ekpo_distr cashdiscount1days Days from Baseline Date for Payment
CashDiscount2Days ekpo_distr cashdiscount2days Days from Baseline Date for Payment
NetPaymentDays ekpo_distr netpaymentdays Net Pmt Terms Period
CashDiscount1Percent ekpo_distr cashdiscount1percent Disc. Percent 1
CashDiscount2Percent ekpo_distr cashdiscount2percent Disc. Percent 2
Material ekpo_distr material Vehicle Model
MaterialGroup ekpo_distr materialgroup Product Group
CntrlPurContrDistributionPct ekpo_distr purchasingdocumentdistrpct Distribution %
TargetQuantity ekpo_distr targetquantity Target Quantity
TargetAmount ekpo_distr targetvalue Target Value
ExtContractForPurg ekpo_distr extcontractforpurg Contract
ExtContractItemForPurg ekpo_distr extcontractitemforpurg Item
IsDeleted ekpo_distr isdeleted TRUE
OrderQuantityUnit ekpo_distr orderquantityunit Sales Unit
DistributionType ekpo_distr distributiontype Distribution Type
DistrResponseMessageUUID ekpo_distr responsemessageguid GUID
ItemDistributionIsRelevant ekpo_distr itemdistributionisrelevant Is Relevant
ReferenceHeaderDistributionKey ekpo_distr referencedhdrdistrnumber Distr. Number
CntrlPurContrItmDistrIsBlocked ekpo_distr isitemdistributionblocked Block Item Distr
CntrlPurContrDistributionLevel ekpo_distr distributionlevel Distr. Level
ManualDeliveryAddressID ekpo_distr manualdeliveryaddressid Address Number
AddressType ekpo_distr deliveryaddresstype Delivery Addr. Type
ExternalReferenceDocument ekpo_distr externalreferencedocument Ext. Ref. Document
ExternalReferenceDocumentItem ekpo_distr externalreferencedocumentitem Ext. Ref. Doc. Item
ExternalRefDocCategory ekpo_distr externalrefdoccategory Category
PurchasingInfoRecordUpdateCode ekpo_distr purchasinginforecordupdatecode InfoUpdate
ProcmtHubPredecessorDocument ekpo_distr procmthubpredecessordocument Prdcssr Doc Num
ProcmtHubPredecessorDocItem ekpo_distr procmthubpredecessordocitem Prdcssr Doc Itm
ProcmtHubPredecessorDocCat ekpo_distr procmthubpredecessordoccat Prdcssr Doc Categ
ProcmtHubPurchaseRequisition ekpo_distr procmthubpurchaserequisition Purchase Req.
ProcmtHubPurRequisitionItem ekpo_distr procmthubpurrequisitionitem Requisn. item
SourceListIsUpdated ekpo_distr sourcelistisupdated Sourcelist Updated
SourceListRestriction ekpo_distr sourcelistrestriction SrcListRstrcn
SrceListResponseMsgUUID ekpo_distr srcelistresponsemsguuid GUID
SourceListChangeConfStatus ekpo_distr sourcelistchangeconfstatus Src. Lst Change Sta.
ProcmtHubCompanyCodeGroupingID ekpo_distr procmthubcompanycodegroupingid Grouping ID

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_CntrlPurContrDistribution.
-- 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: PCNTRLPCONDSTR

CREATE VIEW P_CntrlPurContrDistribution AS
SELECT
  purchasingdocument AS CentralPurchaseContract,
  purchasingdocumentitem AS CentralPurchaseContractItem,
  ekpo_distr.distributionnumber AS DistributionKey,
  ekpo_distr.purchasingdocumentcategory AS PurchasingDocumentCategory,
  ekpo_distr.purchasingdocumenttype AS PurchasingDocumentType,
  ekpo_distr.purchasingorganization AS PurchasingOrganization,
  ekpo_distr.companycode AS CompanyCode,
  ekpo_distr.plant AS Plant,
  ekpo_distr.logicalsystem AS LogicalSystem,
  ekpo_distr.documentcurrency AS DocumentCurrency,
  ekpo_distr.documentcurrency AS Currency,
  ekpo_distr.purchasinggroup AS PurchasingGroup,
  ekpo_distr.storagelocation AS StorageLocation,
  ekpo_distr.paymentterms AS PaymentTerms,
  ekpo_distr.cashdiscount1days AS CashDiscount1Days,
  ekpo_distr.cashdiscount2days AS CashDiscount2Days,
  ekpo_distr.netpaymentdays AS NetPaymentDays,
  ekpo_distr.cashdiscount1percent AS CashDiscount1Percent,
  ekpo_distr.cashdiscount2percent AS CashDiscount2Percent,
  ekpo_distr.material AS Material,
  ekpo_distr.materialgroup AS MaterialGroup,
  ekpo_distr.purchasingdocumentdistrpct AS CntrlPurContrDistributionPct,
  ekpo_distr.targetquantity AS TargetQuantity,
  ekpo_distr.targetvalue AS TargetAmount,
  ekpo_distr.extcontractforpurg AS ExtContractForPurg,
  ekpo_distr.extcontractitemforpurg AS ExtContractItemForPurg,
  ekpo_distr.isdeleted AS IsDeleted,
  ekpo_distr.orderquantityunit AS OrderQuantityUnit,
  ekpo_distr.distributiontype AS DistributionType,
  ekpo_distr.responsemessageguid AS DistrResponseMessageUUID,
  ekpo_distr.itemdistributionisrelevant AS ItemDistributionIsRelevant,
  ekpo_distr.referencedhdrdistrnumber AS ReferenceHeaderDistributionKey,
  ekpo_distr.isitemdistributionblocked AS CntrlPurContrItmDistrIsBlocked,
  ekpo_distr.distributionlevel AS CntrlPurContrDistributionLevel,
  ekpo_distr.manualdeliveryaddressid AS ManualDeliveryAddressID,
  ekpo_distr.deliveryaddresstype AS AddressType,
  ekpo_distr.externalreferencedocument AS ExternalReferenceDocument,
  ekpo_distr.externalreferencedocumentitem AS ExternalReferenceDocumentItem,
  ekpo_distr.externalrefdoccategory AS ExternalRefDocCategory,
  ekpo_distr.purchasinginforecordupdatecode AS PurchasingInfoRecordUpdateCode,
  ekpo_distr.procmthubpredecessordocument AS ProcmtHubPredecessorDocument,
  ekpo_distr.procmthubpredecessordocitem AS ProcmtHubPredecessorDocItem,
  ekpo_distr.procmthubpredecessordoccat AS ProcmtHubPredecessorDocCat,
  ekpo_distr.procmthubpurchaserequisition AS ProcmtHubPurchaseRequisition,
  ekpo_distr.procmthubpurrequisitionitem AS ProcmtHubPurRequisitionItem,
  ekpo_distr.sourcelistisupdated AS SourceListIsUpdated,
  ekpo_distr.sourcelistrestriction AS SourceListRestriction,
  ekpo_distr.srcelistresponsemsguuid AS SrceListResponseMsgUUID,
  ekpo_distr.sourcelistchangeconfstatus AS SourceListChangeConfStatus,
  ekpo_distr.procmthubcompanycodegroupingid AS ProcmtHubCompanyCodeGroupingID
FROM ekpo_distr
;

Learn More