C_CntrlPurContrDistributionTP

Central PC Distribution Consumption View | view: CCNTRLPCONDSTRTP | Extraction: Not supported | Component: Contract
Tables used: EKPO_DISTR, MMPRC_CCTR_RELOR, EREV, EKPO_DISTR, EKKO, EKPO, MMSRCGPROJQTN, MMSRCGPQTNITEM, T162, T002, T161, T161T, MMPUR_BLK_RSNT, LFA1, USR21, MMPUR_C_BE_CCREG, MMPUR_C_BE_SYREG
Column Name Description
CentralPurchaseContract Purchasing Document Number
CentralPurchaseContractItem Item Number of Purchasing Document
DistributionKey Distribution Number of Central Purchasing Document
Column Name Description
💲 Currency Key (DocumentCurrency):
TargetAmount Target Value for Header Area per Distribution
CntrlPurContractGRAmount Consumed GR Amount for Central Contract
ContractNetPriceAmount Net Price in Purchasing Document (in Document Currency)
Column Name Description
📏 Purchase Order Unit of Measure (OrderQuantityUnit):
TargetQuantity Target Quantity
📏 Purchase Order Unit of Measure (ReleaseOrderItemQuantityUnit):
CntrlPurContractGRQuantity Consumed GR Quantity for Central Contract
Column Name Description
Column Name Description
PurgDocChangeRequestStatus Change Request Status Show values
PurchasingDocumentCategory Purchasing Document Category Show values
PurchasingInfoRecordUpdateCode Indicator: Update Info Record Show values
SourceListIsUpdated Checkbox Show values
ItemDistributionStatus Distribution Status Show values
IsDeleted Deletion Indicator for Item Distribution Show values
ProcmtHubPredecessorDocCat Predecessor Purchasing Document Category Show values
DistributionType Distribution Type for Central Purchase Contract Item Show values
CntrlPurContrItmDistrIsBlocked Blocked indicator for Item distribution Show values
Column Name Description Domain name
ActivePurchasingDocument Active Purchasing Document EBELN
PurchasingDocumentName Name of Purchasing Document TEXT40
PurchasingDocumentType Purchasing Document Type BSART
IsExtPurgScenario null
ProcmtHubPurchaseRequisition Purchase Requisition Number BANFN
ProcmtHubPurRequisitionItem Item number of purchase requisition BNFPO
PurchasingOrganization Purchasing organization EKORG
CompanyCode Company Code BUKRS
Plant Plant WERKS
StorageLocation Storage location LGORT
SourceListRestriction Source List Restriction Indicator
LogicalSystem Logical System LOGSYS
PurchasingGroup Purchasing Group EKGRP
PaymentTerms Terms of Payment Key ZTERM
CashDiscount1Days Cash discount days 1 ZBDXT
CashDiscount2Days Cash discount days 2 ZBDXT
NetPaymentDays Net Payment Terms Period ZBDXT
CashDiscount1Percent Cash discount percentage 1
CashDiscount2Percent Cash Discount Percentage 2
ShippingInstruction Shipping Instructions EVERS
IncotermsClassification Incoterms (Part 1) INCO1
IncotermsLocation1 Incoterms Location 1 INCO_L
Material Material Number MATNR
MaterialGroup Material Group MATKL
CntrlPurContrDistributionPct Distribution Percentage in Central Purchasing Document
ExtContractForPurg Contract of External System EBELN
ExtContractItemForPurg Contract Item of External System EBELP
ItemDistributionStatusName Short Text for Fixed Values
TextIsDeleted Boolean Variable (X = True, - = False, Space = Unknown)
OutlineAgrmtItmIsBlocked Boolean Variable (X = True, - = False, Space = Unknown)
OutlineAgrmtItmBlockedText Boolean Variable (X = True, - = False, Space = Unknown)
PurgDocItmBlkRsnCode Block Reason Code CHAR4
ExternalRefDocCategory Category of an external transaction or element VORG_TYP
ExternalReferenceDocument Document Number of External Reference Document VBELN
ExternalReferenceDocumentItem Document Item Number of External Reference Document EBELP
ProcmtHubPredecessorDocument Predecessor Purchasing Document Number EBELN
ProcmtHubPredecessorDocItem Predecessor Purchasing Document Item Number EBELP
ContractConsumptionInPct null
CntrlPurContrGRConsumptionPct null
ItemDistributionIsRelevant Link field for view query
ReferenceHeaderDistributionKey Distribution Number of Central Purchasing Document
ProcurementHubSourceSystem Logical System LOGSYS
ProcmtHubLogicalSystem Logical System LOGSYS
CntrlPurContrDistributionLevel null
ProcmtHubCompanyCodeName Name of Company Code or Company TEXT25
PurchasingDocumentTypeName Short Description of Purchasing Document Type TEXT20
PurchasingDocumentCategoryName Purchasing Document Category Name DDTEXT
PurgDocItmBlkRsnDesc Block Reason Description TEXT40
PurgDocDistributionTypeDesc Short Text for Fixed Values DDTEXT
ManualDeliveryAddressID Address Number AD_ADDRNUM
ProcmtHubDelivAddressTypeCode Source of the Delivery Address
AddressTypeDesc Short Text for Fixed Values DDTEXT
ReferenceDeliveryAddressID Number of delivery address
ProcmtHubSubcontractor Supplier to be Supplied/Who is to Receive Delivery LIFNR
ProcmtHubSuplrIsSubcontractor Subcontracting Supplier
FormOfAddress Form-of-Address Key AD_TITLE
ProcmtHubBusinessPartnerName1 Name 1
ProcmtHubBusinessPartnerName2 Name 2
ProcmtHubBusinessPartnerName3 Name 3
ProcmtHubBusinessPartnerName4 Name 4
ProcmtHubStreetName Street TEXT60
ProcmtHubHouseNumber House Number
ProcmtHubPostalCode City postal code
ProcmtHubCityName City TEXT40
ProcmtHubCountry Country/Region Key
ProcmtHubRegion Region (State, Province, County)
ProcmtHubPrdcssrDocUUID Predecessor document UUID SYSUUID
ProcmtHubPrdcssrDocItemUUID Predecessor document item UUID SYSUUID
ProcmtHubPrdcssrDocObjType SAP Business Object Type BO_OBJECT_TYPE
ProcmtHubPrdcssrDocObjNodeType SAP Business Object Node Type BO_NODE_TYPE
SourcingProjectQuotation Supplier Quotation VDM_SOURCINGPROJECTQUOTATION
FormattedItemID Formatted Item ID
SrcgProjQtnItemFrmtdTxt Formatted Sourcing Project Quotation Item
Master Data Relations Join Conditions
Currency Key
  • Currency Key
  • Client
  • C_CNTRLPURCONTRDISTRIBUTIONTP.DOCUMENTCURRENCY == TCURC.WAERS
  • C_CNTRLPURCONTRDISTRIBUTIONTP.MANDT == TCURC.MANDT
Item category in purchasing document
  • Client
  • Item category in purchasing document
  • C_CNTRLPURCONTRDISTRIBUTIONTP.MANDT == T163.MANDT
  • C_CNTRLPURCONTRDISTRIBUTIONTP.PURCHASINGDOCUMENTITEMCATEGORY == T163.PSTYP