C_PurOrdMaintainRefDocument

PO Maintenance: Reference Document | view: CPOMAINTREFDOC | Extraction: Not supported | Component: Purchase Orders

Tables used: VBAP, /CPD/D_PFP_PH, /SRMSMC/D_PUC_RT, /SRMSMC/D_PUCMG, EKKO, EKPO, EKKN, EKET, VBKD, VEDA, VBAK, VBAK, VBAP, VBKD, VEDA, PRTE, /CPD/D_PFP_PS, /CPD/D_MP_HDR, /CPD/D_MP_HDR_S, EKKO_PO_D, EKPO, EKPO_PO_D, EKKO, EKPO, LFA1, ADCP, ADRC, ADR3, ADR2, TKA01, T005, KNA1, MARA, T134, T001W, PROJ, T024, EINA, EINE, T000, LFA1, PRPS, PRPS, PROJ

🔑 Keys (6)
💰 Amounts (1)
∑ Quantities (1)
📅 Dates
☰ Categorical
Other (11)
🔗 Relations (16)

Column Name	Description
PurchaseOrder FK	Purchasing Document Number
PurchaseOrderItem	Item Number of Purchase Order
PurchasingInfoRecord	null
PurchasingOrganization FK	Purchasing organization
PurchasingInfoRecordCategory	null
Plant FK	Plant

Column Name	Description
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

Column Name	Description

Column Name	Description	Domain name
PlantName	Plant Name	TEXT30
PurchasingDocumentCategory	null
SupplierName	Name 1	NAME
PurchasingDocumentItemText	Short Text	TEXT40
PurchaseOrderNetPriceQuantity	Price Unit	DEC5
PurchasingGroupName	Purchasing Group Name	TEXT18
IsDeleted	Deletion Indicator in Purchasing Document	ELOEK
CustomerProjectName	Customer Project Name	/CPD/SHORT_TEXT
SalesOrder	Sales and Distribution Document Number	VBELN
SalesOrderItem	Sales Document Item	POSNR
ServicePerformer	Service Performer	BU_PARTNER

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