C_PurOrdItm

My Purchasing Document Items | view: CPURGDOCITEMSPO | TRAN | Extraction: Not supported | Component: Purchase Orders
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