C_PurOrdRefDocPC

Reference Documents PO Creation - Purchase Contract Items | view: CPURORDREFDOCPC | Extraction: Not supported | Component: Purchase Orders
Column Name Description
PurchaseOrder FK Purchasing Contract Header
PurchaseOrderItem Item Number of Purchasing Contract
AccountAssignmentNumber Sequential Number of Account Assignment
Column Name Description
💲 Currency Key (Currency):
PurchaseOrderNetPriceAmount Net Price in Purchasing Document (in Document Currency)
Column Name Description
Column Name Description
ValidityStartDate Start of Validity Period
ValidityEndDate End of Validity Period
DeliveryDate null
PerformancePeriodStartDate null
PerformancePeriodEndDate null
Column Name Description
Column Name Description Domain name
PurchasingInfoRecord null
PurchasingInfoRecordCategory Purchasing info record category
PlantName Plant Name TEXT30
PurchasingDocumentCategory null
IsAdvancedPurchaseOrder null
PurchasingDocumentDeletionCode Deletion Indicator in Purchasing Document ELOEK
MaterialName Material Description TEXT40
MaterialType null
MaterialGroupName Product Group Description TEXT20
SupplierName Name of Supplier TEXT80
PurchasingDocumentSubtype null
PurchasingDocumentItemText Short Text TEXT40
PurchaseOrderQty null
PurchaseOrderNetPriceQuantity Price Unit DEC5
PurchaseOrderPriceUnitName Unit of Measurement Text (Maximum 30 Characters) TEXT30
PurchasingGroupName Purchasing Group Name TEXT18
CompanyCodeName null
PurchasingDocumentCondition null
PricingProcedure null
ContractConsumptionInPct null
GoodsReceiptIsExpected null
GoodsReceiptIsNonValuated null
InvoiceIsExpected null
InvoiceIsGoodsReceiptBased null
OverdelivTolrtdLmtRatioInPct null
UnlimitedOverdeliveryIsAllowed null
UnderdelivTolrtdLmtRatioInPct null
OrderItemQtyToBaseQtyNmrtr null
OrderItemQtyToBaseQtyDnmntr null
PurchaseOrderItemCategory null
IsDeleted null
ServicePerformer null
ServicePerformerName null
ProductType null
RefPurchaseOutlineAgreement null
RefPurchOutlineAgrmtItem null
SupplierMaterialNumber null
OrderPriceUnitToOrderUnitNmrtr null
OrdPriceUnitToOrderUnitDnmntr null
CustomerProjectName Customer Project Name /CPD/SHORT_TEXT
ProfitCenter Profit Center PRCTR
FunctionalArea Functional Area FKBER
GLAccountName G/L Account Name TEXT20
CostCenterName Cost Center Name TEXT20
SalesOrder Sales and Distribution Document Number VBELN
SalesOrderItem Sales Document Item POSNR
Master Data Relations Join Conditions
Company Code
  • Client
  • Company Code
  • C_PURORDREFDOCPC.MANDT == T001.MANDT
  • C_PURORDREFDOCPC.COMPANYCODE == T001.BUKRS
Controlling Area
  • Client
  • Controlling Area
  • C_PURORDREFDOCPC.MANDT == TKA01.MANDT
  • C_PURORDREFDOCPC.CONTROLLINGAREA == TKA01.KOKRS
Cost Center
  • Client
  • Cost Center
  • ?
  • Controlling Area
  • C_PURORDREFDOCPC.MANDT == CSKS.MANDT
  • C_PURORDREFDOCPC.COSTCENTER == CSKS.KOSTL
  • C_PURORDREFDOCPC.[column in domain "DATBI"] == CSKS.DATBI
  • C_PURORDREFDOCPC.CONTROLLINGAREA == CSKS.KOKRS
Currency Key
  • Client
  • Currency Key
  • C_PURORDREFDOCPC.MANDT == TCURC.MANDT
  • C_PURORDREFDOCPC.CURRENCY == TCURC.WAERS
G/L Account Number
  • Client
  • G/L Account Number
  • ?
  • C_PURORDREFDOCPC.MANDT == SKA1.MANDT
  • C_PURORDREFDOCPC.GLACCOUNT == SKA1.SAKNR
  • C_PURORDREFDOCPC.[column in domain "KTOPL"] == SKA1.KTOPL
Material number
  • Client
  • Material number
  • C_PURORDREFDOCPC.MANDT == MARA.MANDT
  • C_PURORDREFDOCPC.MANUFACTURERMATERIAL == MARA.MATNR
Material Number
  • Client
  • Material Number
  • C_PURORDREFDOCPC.MANDT == MARA.MANDT
  • C_PURORDREFDOCPC.MATERIAL == MARA.MATNR
Material Group
  • Client
  • Material Group
  • C_PURORDREFDOCPC.MANDT == T023.MANDT
  • C_PURORDREFDOCPC.MATERIALGROUP == T023.MATKL
Plant
  • Client
  • Plant
  • C_PURORDREFDOCPC.MANDT == T001W.MANDT
  • C_PURORDREFDOCPC.PLANT == T001W.WERKS
Order Price Unit (Purchasing)
  • Client
  • Order Price Unit (Purchasing)
  • C_PURORDREFDOCPC.MANDT == T006.MANDT
  • C_PURORDREFDOCPC.PURCHASEORDERPRICEUNIT == T006.MSEHI
Purchase Order Unit of Measure
  • Client
  • Purchase Order Unit of Measure
  • C_PURORDREFDOCPC.MANDT == T006.MANDT
  • C_PURORDREFDOCPC.PURCHASEORDERQUANTITYUNIT == T006.MSEHI
Purchasing Document Type
  • ?
  • Client
  • Purchasing Document Type
  • C_PURORDREFDOCPC.[column in domain "BSTYP"] == T161.BSTYP
  • C_PURORDREFDOCPC.MANDT == T161.MANDT
  • C_PURORDREFDOCPC.PURCHASINGDOCUMENTTYPE == T161.BSART
Purchasing Group
  • Client
  • Purchasing Group
  • C_PURORDREFDOCPC.MANDT == T024.MANDT
  • C_PURORDREFDOCPC.PURCHASINGGROUP == T024.EKGRP
Purchasing organization
  • Purchasing organization
  • Client
  • C_PURORDREFDOCPC.PURCHASINGORGANIZATION == T024E.EKORG
  • C_PURORDREFDOCPC.MANDT == T024E.MANDT
Storage Location
  • Client
  • Storage Location
  • Plant
  • C_PURORDREFDOCPC.MANDT == T001L.MANDT
  • C_PURORDREFDOCPC.STORAGELOCATION == T001L.LGORT
  • C_PURORDREFDOCPC.PLANT == T001L.WERKS
Supplier
  • Client
  • Supplier
  • C_PURORDREFDOCPC.MANDT == LFA1.MANDT
  • C_PURORDREFDOCPC.SUPPLIER == LFA1.LIFNR