C_PurDocListPODtl

Purchase Order Details | view: CDOCLPODTL | Extraction: Not supported | Component: Purchasing
Column Name Description
PurchaseOrder FK Purchasing Document Number
PurchaseOrderItem Item Number of Purchase Order
AccountAssignmentNumber Sequential Number of Account Assignment
Column Name Description
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
LastChangeDate Creation Date of Purchasing Document
DeliveryDate null
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
postgr Goods Receipt Indicator Show values
IsEndOfPurposeBlocked Business Purpose Completed Show values
Column Name Description Domain name
SupplierAddressCity City TEXT40
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
ServicePerformerName null
WorkItem null
WBSElementInternalID null
WBSElementExternalID null
SalesOrder Sales and Distribution Document Number VBELN
SalesOrderItem Sales Document Item POSNR
WorkPackageFullName null
WBSDescription Object Name CHAR80
CostCenter null
CostCenterName Cost Center Name TEXT20
ExchangeRate null
PurchasingDocumentCategory null
CreatedByUser User of person who created a purchasing document USNAM
PaymentTerms Terms of Payment Key ZTERM
PurchaseOrderDate null
SupplyingPlantName Plant Name TEXT30
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
supplier null
SupplierName null
Master Data Relations Join Conditions
Account Assignment Category
  • Client
  • Account Assignment Category
  • C_PURDOCLISTPODTL.MANDT == T163K.MANDT
  • C_PURDOCLISTPODTL.ACCTASSIGNMENTCATEGORY == T163K.KNTTP
Base Unit of Measure
  • Client
  • Base Unit of Measure
  • C_PURDOCLISTPODTL.MANDT == T006.MANDT
  • C_PURDOCLISTPODTL.BASEUNIT == T006.MSEHI
Company Code
  • Company Code
  • Client
  • C_PURDOCLISTPODTL.COMPANYCODE == T001.BUKRS
  • C_PURDOCLISTPODTL.MANDT == T001.MANDT
Controlling Area
  • Client
  • Controlling Area
  • C_PURDOCLISTPODTL.MANDT == TKA01.MANDT
  • C_PURDOCLISTPODTL.CONTROLLINGAREA == TKA01.KOKRS
Currency Key
  • Client
  • Currency Key
  • C_PURDOCLISTPODTL.MANDT == TCURC.MANDT
  • C_PURDOCLISTPODTL.CURRENCY == TCURC.WAERS
Material number
  • Material number
  • Client
  • C_PURDOCLISTPODTL.MANUFACTURERMATERIAL == MARA.MATNR
  • C_PURDOCLISTPODTL.MANDT == MARA.MANDT
Material Number
  • Material Number
  • Client
  • C_PURDOCLISTPODTL.MATERIAL == MARA.MATNR
  • C_PURDOCLISTPODTL.MANDT == MARA.MANDT
Material Group
  • Client
  • Material Group
  • C_PURDOCLISTPODTL.MANDT == T023.MANDT
  • C_PURDOCLISTPODTL.MATERIALGROUP == T023.MATKL
Plant
  • Plant
  • Client
  • C_PURDOCLISTPODTL.PLANT == T001W.WERKS
  • C_PURDOCLISTPODTL.MANDT == T001W.MANDT
Item category in purchasing document
  • Client
  • Item category in purchasing document
  • C_PURDOCLISTPODTL.MANDT == T163.MANDT
  • C_PURDOCLISTPODTL.PURCHASEORDERITEMCATEGORY == T163.PSTYP
Order Price Unit (Purchasing)
  • Client
  • Order Price Unit (Purchasing)
  • C_PURDOCLISTPODTL.MANDT == T006.MANDT
  • C_PURDOCLISTPODTL.PURCHASEORDERPRICEUNIT == T006.MSEHI
Purchase Order Unit of Measure
  • Client
  • Purchase Order Unit of Measure
  • C_PURDOCLISTPODTL.MANDT == T006.MANDT
  • C_PURDOCLISTPODTL.PURCHASEORDERQUANTITYUNIT == T006.MSEHI
Purchase Order Type
  • Purchase Order Type
  • ?
  • Client
  • C_PURDOCLISTPODTL.PURCHASINGDOCUMENTTYPE == T161.BSART
  • C_PURDOCLISTPODTL.[column in domain "BSTYP"] == T161.BSTYP
  • C_PURDOCLISTPODTL.MANDT == T161.MANDT
Purchasing Group
  • Purchasing Group
  • Client
  • C_PURDOCLISTPODTL.PURCHASINGGROUP == T024.EKGRP
  • C_PURDOCLISTPODTL.MANDT == T024.MANDT
Purchasing organization
  • Client
  • Purchasing organization
  • C_PURDOCLISTPODTL.MANDT == T024E.MANDT
  • C_PURDOCLISTPODTL.PURCHASINGORGANIZATION == T024E.EKORG
Storage Location
  • Plant
  • Client
  • Storage Location
  • C_PURDOCLISTPODTL.PLANT == T001L.WERKS
  • C_PURDOCLISTPODTL.MANDT == T001L.MANDT
  • C_PURDOCLISTPODTL.STORAGELOCATION == T001L.LGORT
Country key
  • Country/Region Key
  • Client
  • C_PURDOCLISTPODTL.SUPPLIERADDRESSCOUNTRY == T005.LAND1
  • C_PURDOCLISTPODTL.MANDT == T005.MANDT
Supplying (issuing) plant in case of stock transport order
  • Client
  • Supplying (issuing) plant in case of stock transport order
  • C_PURDOCLISTPODTL.MANDT == T001W.MANDT
  • C_PURDOCLISTPODTL.SUPPLYINGPLANT == T001W.WERKS