C_PurOrdItm

My Purchasing Document Items | view: CPURGDOCITEMSPO | TRAN | Extraction: Not supported | Component: Purchase Orders

Tables used: /CPD/D_PFP_PH, /SRMSMC/D_PUC_RT, /SRMSMC/D_PUCMG, EKKO, EKBE, EKPO, EKKN, EKBEH, EKET, MMPUR_ANA_EKET, /CPD/D_PFP_PS, /CPD/D_MP_HDR, /CPD/D_MP_HDR_S, APOC_D_OR_ITEM, NAST, T001, TKA02, TKA01, CSKS, CSKT, T001W, T163B, T161, T161T, MMPUR_ANA_CONF, T163, T163Y, T000, T001L, LFA1, ADCP, ADR2, ADR3, ADR6, ADRP, USR21, PRPS, PROJ, T161M

🔑 Keys (3)
💰 Amounts (7)
∑ Quantities (7)
📅 Dates (4)
☰ Categorical (2)
Other (27)
🔗 Relations (19)

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 (DocumentCurrency):
NetPriceAmount	Net Price in Purchasing Document (in Document Currency)
NetAmount	Net Order Value in PO Currency
GoodsReceiptAmount	null
StillToBeDeliveredValue	null
PurgDocNetAmount	Target Amount
💲 Currency Key (CompanyCodeCurrency):
InvoiceRcptAmtInCoCodeCrcy	null
StillToInvoiceValue	null

Column Name	Description
📏 Purchase Order Unit of Measure (PurchaseOrderQuantityUnit):
ScheduleLineOpenQty	null
OrderQuantity	Purchase Order Quantity
GoodsReceiptQuantity	null
InvoiceReceiptQty	null
StillToBeDeliveredQuantity	null
StillToInvoiceQuantity	null
Quantity	Quantity

Column Name	Description
DeliveryDate	Item delivery date
PurchaseOrderDate	Purchase Order Date
CreationDate	Creation Date of Purchasing Document
ScheduleLineDeliveryDate	Item delivery date

Column Name	Description
IsReturnsItem	Returns Item	Show values
ObjectType	Num1	Show values

Column Name	Description	Domain name
FormattedPurchaseOrderItem	null
MaterialDocumentItemText	Short Text
SupplyingPlantName	Plant Name	TEXT30
PurchasingDocumentTypeName	Short Description of Purchasing Document Type	TEXT20
PurchasingDocumentItemCategory	Item Category in Purchasing Document
PurgDocItemCategoryName	Text for Item Category	TEXT20
CompanyCodeName	Name of Company Code or Company	TEXT25
PlantName	Plant Name	TEXT30
StorageLocationName	Storage Location Name	TEXT16
Supplier	Supplier
PurchasingCategory	Purchasing Category ID	/SRMSMC/OBJECT_ID
PurgCatName	Name of Purchasing Category	/SRMSMC/MEDIUM_NAME
ServicePerformer	Service Performer	BU_PARTNER
ProductType	Product Type Group	CHAR2
CreatedByUser	User of person who created a purchasing document	USNAM
FullName	Full Name of Person
Status	null
PurchasingDocumentStatusName	Purchasing Document Status Name	DDTEXT
CostCenterName	Cost Center Name	TEXT20
SalesOrder	Sales and Distribution Document Number
SalesOrderItem	null
NetPriceQuantity	Price Unit	DEC5
IsBusinessPurposeCompleted	Business Purpose Completed Flag
WorkItem	Work Item ID
WBSElementExternalID	Work Breakdown Structure Element (WBS Element)
MultipleAcctAssgmtDistrPercent	null
CustProjWorkPackageFullName	null

Master Data Relations	Join Conditions
Account Assignment Category Account Assignment Category Client	`C_PURORDITM.ACCOUNTASSIGNMENTCATEGORY == T163K.KNTTP` `C_PURORDITM.MANDT == T163K.MANDT`
Company Code Company Code Client	`C_PURORDITM.COMPANYCODE == T001.BUKRS` `C_PURORDITM.MANDT == T001.MANDT`
Currency Key Currency Key Currency Key Client	`C_PURORDITM.COMPANYCODECURRENCY == TCURC.WAERS` `C_PURORDITM.DOCUMENTCURRENCY == TCURC.WAERS` `C_PURORDITM.MANDT == TCURC.MANDT`
Cost Center Creation Date of Purchasing Document ? Cost Center Client	`C_PURORDITM.CREATIONDATE == CSKS.DATBI` `C_PURORDITM.[column in domain "KOKRS"] == CSKS.KOKRS` `C_PURORDITM.COSTCENTER == CSKS.KOSTL` `C_PURORDITM.MANDT == CSKS.MANDT`
Currency Key Currency Key Currency Key Client	`C_PURORDITM.COMPANYCODECURRENCY == TCURC.WAERS` `C_PURORDITM.DOCUMENTCURRENCY == TCURC.WAERS` `C_PURORDITM.MANDT == TCURC.MANDT`
Material Number Material Number Client	`C_PURORDITM.MATERIAL == MARA.MATNR` `C_PURORDITM.MANDT == MARA.MANDT`
Material Group Material Group Client	`C_PURORDITM.MATERIALGROUP == T023.MATKL` `C_PURORDITM.MANDT == T023.MANDT`
Order Price Unit (Purchasing) Order Price Unit (Purchasing) Client	`C_PURORDITM.ORDERPRICEUNIT == T006.MSEHI` `C_PURORDITM.MANDT == T006.MANDT`
Plant Plant Client	`C_PURORDITM.PLANT == T001W.WERKS` `C_PURORDITM.MANDT == T001W.MANDT`
Purchase Order Unit of Measure Purchase Order Unit of Measure Client	`C_PURORDITM.PURCHASEORDERQUANTITYUNIT == T006.MSEHI` `C_PURORDITM.MANDT == T006.MANDT`
Purchase Order Type Purchase Order Type Purchase Order Type ? Client	`C_PURORDITM.PURCHASEORDERTYPE == T161.BSART` `C_PURORDITM.PURCHASINGDOCUMENTTYPE == T161.BSART` `C_PURORDITM.[column in domain "BSTYP"] == T161.BSTYP` `C_PURORDITM.MANDT == T161.MANDT`
Purchase Order Type Purchase Order Type Purchase Order Type ? Client	`C_PURORDITM.PURCHASEORDERTYPE == T161.BSART` `C_PURORDITM.PURCHASINGDOCUMENTTYPE == T161.BSART` `C_PURORDITM.[column in domain "BSTYP"] == T161.BSTYP` `C_PURORDITM.MANDT == T161.MANDT`
Purchasing Group Purchasing Group Client	`C_PURORDITM.PURCHASINGGROUP == T024.EKGRP` `C_PURORDITM.MANDT == T024.MANDT`
Purchasing organization Purchasing organization Client	`C_PURORDITM.PURCHASINGORGANIZATION == T024E.EKORG` `C_PURORDITM.MANDT == T024E.MANDT`
Storage Location Storage Location Plant Client	`C_PURORDITM.STORAGELOCATION == T001L.LGORT` `C_PURORDITM.PLANT == T001L.WERKS` `C_PURORDITM.MANDT == T001L.MANDT`
Supplying (issuing) plant in case of stock transport order Supplying (issuing) plant in case of stock transport order Client	`C_PURORDITM.SUPPLYINGPLANT == T001W.WERKS` `C_PURORDITM.MANDT == T001W.MANDT`