C_PurDocListPOAll

Purchase Order : Header + Item | view: CDOCLPOALL | Extraction: Not supported | Component: Purchasing

Tables used: EKKN, EKES, EKPO, EKPO, APOC_D_OR_ITEM, EKET, /CPD/D_PFP_PH, EKKO, EKPO, EKET, PRTE, /CPD/D_PFP_PS, /CPD/D_MP_HDR, /CPD/D_MP_HDR_S, EKBE, EKBEH, LFA1, T001, TKA02, T001W, PROJ, T163B, T024, T024E, PRPS, PROJ

🔑 Keys (3)
💰 Amounts (5)
∑ Quantities (5)
📅 Dates (2)
☰ Categorical (8)
Other (35)
🔗 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)
PurchaseOrderNetAmount	Net Order Value in PO Currency
GoodsReceiptValue	null
InvoiceReceiptValue	null
releasevalue	null

Column Name	Description
📏 Purchase Order Unit of Measure (PurchaseOrderQuantityUnit):
PurchaseOrderQty	Purchase Order Quantity
GoodsReceiptQuantity	null
InvoiceReceiptQuantity	null
wesbs	null
releasequantity	null

Column Name	Description
DeliveryDate	null
LastChangeDate	Creation Date of Purchasing Document

Column Name	Description
ItemIsStatistical	Item is statistical	Show values
IsReturnsItem	Returns Item	Show values
IsCompletelyDelivered	"Delivery Completed" Indicator	Show values
IsFinallyInvoiced	Final Invoice Indicator	Show values
GoodsReceiptIsExpected	Goods Receipt Indicator	Show values
InvoiceIsGoodsReceiptBased	Indicator: GR-Based Invoice Verification	Show values
InvoiceIsExpected	Invoice receipt indicator	Show values
IsEndOfPurposeBlocked	Business Purpose Completed	Show values

Column Name	Description	Domain name
PurchaseOrderItemText	Short Text	TEXT40
IsDeletedItem	Deletion Indicator in Purchasing Document	ELOEK
MfrPartNumber	Manufacturer Part Number	CHAR40
PurchaseOrderNetPriceQuantity	Price Unit	DEC5
OrderItemQtyToBaseQtyDnmntr	Denominator for Conversion of Order Unit to Base Unit	UMBSN
OrderItemQtyToBaseQtyNmrtr	Numerator for Conversion of Order Unit to Base Unit	UMBSZ
ServicePerformer	Service Performer	BU_PARTNER
WBSElementInternalID	null
WBSElementExternalID	null
SalesOrder	Sales and Distribution Document Number	VBELN
SalesOrderItem	Sales Document Item	POSNR
WorkPackageFullName	null
WBSDescription	Object Name	CHAR80
CostCenter	null
ExchangeRate	null
PurchasingDocumentCategory	null
CreatedByUser	User of person who created a purchasing document	USNAM
PaymentTerms	Terms of Payment Key	ZTERM
PurchaseOrderDate	null
IsDeletedHeader	Deletion Indicator in Purchasing Document	ELOEK
SupplyingVendorName	Name 1	NAME
PurchasingGroupName	Purchasing Group Name	TEXT18
PurchasingOrganizationName	Purchasing Organization Name	TEXT20
CompanyCodeName	Name of Company Code or Company	TEXT25
PlantName	Plant Name	TEXT30
status	null
valuemismatch	null
qtymismatch	null
confmiss	null
cntf	null
cntk	null
cntl	null
contractitemusage	null
sosid	null
sosname	null

Master Data Relations	Join Conditions
Account Assignment Category Account Assignment Category Client	`C_PURDOCLISTPOALL.ACCTASSIGNMENTCATEGORY == T163K.KNTTP` `C_PURDOCLISTPOALL.MANDT == T163K.MANDT`
Base Unit of Measure Base Unit of Measure Client	`C_PURDOCLISTPOALL.BASEUNIT == T006.MSEHI` `C_PURDOCLISTPOALL.MANDT == T006.MANDT`
Company Code Company Code Client	`C_PURDOCLISTPOALL.COMPANYCODE == T001.BUKRS` `C_PURDOCLISTPOALL.MANDT == T001.MANDT`
Controlling Area Controlling Area Client	`C_PURDOCLISTPOALL.CONTROLLINGAREA == TKA01.KOKRS` `C_PURDOCLISTPOALL.MANDT == TKA01.MANDT`
Currency Key Currency Key Client	`C_PURDOCLISTPOALL.CURRENCY == TCURC.WAERS` `C_PURDOCLISTPOALL.MANDT == TCURC.MANDT`
Material number Material number Client	`C_PURDOCLISTPOALL.MANUFACTURERMATERIAL == MARA.MATNR` `C_PURDOCLISTPOALL.MANDT == MARA.MANDT`
Material Number Material Number Client	`C_PURDOCLISTPOALL.MATERIAL == MARA.MATNR` `C_PURDOCLISTPOALL.MANDT == MARA.MANDT`
Material Group Material Group Client	`C_PURDOCLISTPOALL.MATERIALGROUP == T023.MATKL` `C_PURDOCLISTPOALL.MANDT == T023.MANDT`
Supplying (issuing) plant in case of stock transport order Client Supplying (issuing) plant in case of stock transport order Supplying (issuing) plant in case of stock transport order	`C_PURDOCLISTPOALL.MANDT == T001W.MANDT` `C_PURDOCLISTPOALL.NAME1_SP == T001W.WERKS` `C_PURDOCLISTPOALL.SUPPLYINGPLANT == T001W.WERKS`
Plant Client Plant	`C_PURDOCLISTPOALL.MANDT == T001W.MANDT` `C_PURDOCLISTPOALL.PLANT == T001W.WERKS`
Item category in purchasing document Client Item category in purchasing document	`C_PURDOCLISTPOALL.MANDT == T163.MANDT` `C_PURDOCLISTPOALL.PURCHASEORDERITEMCATEGORY == T163.PSTYP`
Order Price Unit (Purchasing) Order Price Unit (Purchasing) Client	`C_PURDOCLISTPOALL.PURCHASEORDERPRICEUNIT == T006.MSEHI` `C_PURDOCLISTPOALL.MANDT == T006.MANDT`
Purchase Order Unit of Measure Client Purchase Order Unit of Measure	`C_PURDOCLISTPOALL.MANDT == T006.MANDT` `C_PURDOCLISTPOALL.PURCHASEORDERQUANTITYUNIT == T006.MSEHI`
Purchase Order Type Purchase Order Type Client ?	`C_PURDOCLISTPOALL.PURCHASINGDOCUMENTTYPE == T161.BSART` `C_PURDOCLISTPOALL.MANDT == T161.MANDT` `C_PURDOCLISTPOALL.[column in domain "BSTYP"] == T161.BSTYP`
Purchasing Group Purchasing Group Client	`C_PURDOCLISTPOALL.PURCHASINGGROUP == T024.EKGRP` `C_PURDOCLISTPOALL.MANDT == T024.MANDT`
Purchasing organization Purchasing organization Client	`C_PURDOCLISTPOALL.PURCHASINGORGANIZATION == T024E.EKORG` `C_PURDOCLISTPOALL.MANDT == T024E.MANDT`
Storage Location Client Storage Location Plant	`C_PURDOCLISTPOALL.MANDT == T001L.MANDT` `C_PURDOCLISTPOALL.STORAGELOCATION == T001L.LGORT` `C_PURDOCLISTPOALL.PLANT == T001L.WERKS`
Supplier Supplier Client	`C_PURDOCLISTPOALL.SUPPLIER == LFA1.LIFNR` `C_PURDOCLISTPOALL.MANDT == LFA1.MANDT`
Supplying (issuing) plant in case of stock transport order Client Supplying (issuing) plant in case of stock transport order Supplying (issuing) plant in case of stock transport order	`C_PURDOCLISTPOALL.MANDT == T001W.MANDT` `C_PURDOCLISTPOALL.NAME1_SP == T001W.WERKS` `C_PURDOCLISTPOALL.SUPPLYINGPLANT == T001W.WERKS`