C_PurOrdRefDocPO

Reference Documents for PO Creation - Purchase Order Items | view: CPURORDREFDOCPO | Extraction: Not supported | Component: Purchase Orders

Tables used: /CPD/D_PFP_PH, FMIOI, EKKO, EKPO, EKKN, PRTE, /CPD/D_PFP_PS, /CPD/D_MP_HDR, /CPD/D_MP_HDR_S, EKKO, EKPO, BUT000, T001, TKA02, TKA01, CSKS, CSKT, KNA1, FM01, SKB1, T023T, MAKT, T001W, CMD_PRDTYPE_T, PROJ, T161T, T024, T163Y, T000, LFA1, T006A, USR21, PRPS, PRPS, PROJ, SKAT, T004, FINSC_FISC_DATE

🔑 Keys (3)
💰 Amounts (1)
∑ Quantities (1)
📅 Dates (2)
☰ Categorical (1)
Other (24)
🔗 Relations (20)

Column Name	Description
PurchaseOrder FK	Purchasing Document Number
PurchaseOrderItem	Item Number of Purchase Order
AccountAssignmentNumber	Sequential Number of Account Assignment

Column Name	Description
💲 Currency Key (Currency):
PurchaseOrderNetPriceAmount	Net Price in Purchasing Document (in Document Currency)

Column Name	Description
📏 Purchase Order Unit of Measure (PurchaseOrderQuantityUnit):
PurchaseOrderQty	Purchase Order Quantity

Column Name	Description
ValidityStartDate	Start of Validity Period
ValidityEndDate	End of Validity Period

Column Name	Description
PurchasingDocumentSubtype	Control indicator for purchasing document type	Show values

Column Name	Description	Domain name
PurchasingInfoRecord	null
PurchasingInfoRecordCategory	null
PlantName	Plant Name	TEXT30
PurchasingDocumentCategory	null
IsAdvancedPurchaseOrder	null
PurchasingDocumentDeletionCode	Deletion Indicator in Purchasing Document	ELOEK
MaterialName	Material Description	TEXT40
MaterialGroupName	Product Group Description	TEXT20
SupplierName	Name of Supplier	TEXT80
PurchasingDocumentItemText	Short Text	TEXT40
PurchaseOrderNetPriceQuantity	Price Unit	DEC5
PurchaseOrderPriceUnitName	Unit of Measurement Text (Maximum 30 Characters)	TEXT30
PurchasingGroupName	Purchasing Group Name	TEXT18
CompanyCodeName	null
PurchasingDocumentCondition	Number of the Document Condition	KNUMV
ServicePerformer	Service Performer	BU_PARTNER
ServicePerformerName	null
CustomerProjectName	Customer Project Name	/CPD/SHORT_TEXT
FunctionalArea	Functional Area	FKBER
GLAccountName	G/L Account Name	TEXT20
CostCenterName	Cost Center Name	TEXT20
ContractConsumptionInPct	null
SalesOrder	Sales and Distribution Document Number	VBELN
SalesOrderItem	Sales Document Item	POSNR

Master Data Relations	Join Conditions
Company Code Company Code Client	`C_PURORDREFDOCPO.COMPANYCODE == T001.BUKRS` `C_PURORDREFDOCPO.MANDT == T001.MANDT`
Controlling Area Controlling Area Client	`C_PURORDREFDOCPO.CONTROLLINGAREA == TKA01.KOKRS` `C_PURORDREFDOCPO.MANDT == TKA01.MANDT`
Cost Center ? Controlling Area Cost Center Client	`C_PURORDREFDOCPO.[column in domain "DATBI"] == CSKS.DATBI` `C_PURORDREFDOCPO.CONTROLLINGAREA == CSKS.KOKRS` `C_PURORDREFDOCPO.COSTCENTER == CSKS.KOSTL` `C_PURORDREFDOCPO.MANDT == CSKS.MANDT`
Currency Key Currency Key Client	`C_PURORDREFDOCPO.CURRENCY == TCURC.WAERS` `C_PURORDREFDOCPO.MANDT == TCURC.MANDT`
G/L Account Number ? Client G/L Account Number	`C_PURORDREFDOCPO.[column in domain "KTOPL"] == SKA1.KTOPL` `C_PURORDREFDOCPO.MANDT == SKA1.MANDT` `C_PURORDREFDOCPO.GLACCOUNT == SKA1.SAKNR`
Material number Material number Client	`C_PURORDREFDOCPO.MANUFACTURERMATERIAL == MARA.MATNR` `C_PURORDREFDOCPO.MANDT == MARA.MANDT`
Material Number Client Material Number	`C_PURORDREFDOCPO.MANDT == MARA.MANDT` `C_PURORDREFDOCPO.MATERIAL == MARA.MATNR`
Material Group Client Material Group	`C_PURORDREFDOCPO.MANDT == T023.MANDT` `C_PURORDREFDOCPO.MATERIALGROUP == T023.MATKL`
Material type Material type Client	`C_PURORDREFDOCPO.MATERIALTYPE == T134.MTART` `C_PURORDREFDOCPO.MANDT == T134.MANDT`
Plant Plant Client	`C_PURORDREFDOCPO.PLANT == T001W.WERKS` `C_PURORDREFDOCPO.MANDT == T001W.MANDT`
Order Price Unit (Purchasing) Client Order Price Unit (Purchasing)	`C_PURORDREFDOCPO.MANDT == T006.MANDT` `C_PURORDREFDOCPO.PURCHASEORDERPRICEUNIT == T006.MSEHI`
Purchase Order Unit of Measure Client Purchase Order Unit of Measure	`C_PURORDREFDOCPO.MANDT == T006.MANDT` `C_PURORDREFDOCPO.PURCHASEORDERQUANTITYUNIT == T006.MSEHI`
Purchase Order Type ? Client Purchase Order Type	`C_PURORDREFDOCPO.[column in domain "BSTYP"] == T161.BSTYP` `C_PURORDREFDOCPO.MANDT == T161.MANDT` `C_PURORDREFDOCPO.PURCHASINGDOCUMENTTYPE == T161.BSART`
Purchasing Group Purchasing Group Client	`C_PURORDREFDOCPO.PURCHASINGGROUP == T024.EKGRP` `C_PURORDREFDOCPO.MANDT == T024.MANDT`
Purchasing organization Client Purchasing organization	`C_PURORDREFDOCPO.MANDT == T024E.MANDT` `C_PURORDREFDOCPO.PURCHASINGORGANIZATION == T024E.EKORG`
Supplier Client Supplier	`C_PURORDREFDOCPO.MANDT == LFA1.MANDT` `C_PURORDREFDOCPO.SUPPLIER == LFA1.LIFNR`