C_PurDocListOverview

Monitor Puchasing Documents: Overview | view: CPDOCLOVERVIEW | Extraction: Not supported | Component: Purchasing
Column Name Description
key_field null
Column Name Description
Column Name Description
GoodsMovementQuantity null
📏 Purchase requisition unit of measure (QuantityUnit):
PurchasingDocumentItemQuantity Purchase requisition quantity
Column Name Description
DeliveryDate Item delivery date
Column Name Description
PurchasingDocumentCategory Purchasing Document Category Show values
IsEndOfPurposeBlocked Business Purpose Completed Show values
Column Name Description Domain name
PurchaseRequisition Purchase requisition number BANFN
PurchaseRequisitionItem Item number of purchase requisition BNFPO
InvoiceReference null
InvoiceReferenceFiscalYear null
AccountingDocumentItem null
AccountingDocumentType null
MaterialDocument null
MaterialDocumentItem null
MaterialDocumentYear null
SupplyingPlant Supplying (issuing) plant in case of stock transport order WERKS
SupplyingPlantName Plant Name TEXT30
Plant null
PlantName Plant Name TEXT30
PurchasingDocumentItemText Short Text TEXT40
PurchasingGroupName Purchasing Group Name TEXT18
Status null
Supplier null
SupplierName Name 1 NAME
SupplierAddressCity City TEXT40
PurchasingOrganizationName Purchasing Organization Name TEXT20
ServicePerformer null
ServicePerformerName null
WorkItem null
MaterialName null
MaterialGroupName null
StatusDescription null
cntf null
cntb null
cnts null
cntg null
WBSElementExternalID Work Breakdown Structure Element (WBS Element) PS_POSID
SalesOrder null
SalesOrderItem null
WorkPackageFullName null
CostCenter null
CostCenterName null
ControllingArea null
Master Data Relations Join Conditions
Account Assignment Category
  • Account Assignment Category
  • Client
  • C_PURDOCLISTOVERVIEW.ACCOUNTASSIGNMENTCATEGORY == T163K.KNTTP
  • C_PURDOCLISTOVERVIEW.MANDT == T163K.MANDT
Currency Key
  • Currency Key
  • Client
  • C_PURDOCLISTOVERVIEW.CURRENCY == TCURC.WAERS
  • C_PURDOCLISTOVERVIEW.MANDT == TCURC.MANDT
Material number corresponding to manufacturer part number
  • Client
  • Material number corresponding to manufacturer part number
  • C_PURDOCLISTOVERVIEW.MANDT == MARA.MANDT
  • C_PURDOCLISTOVERVIEW.MANUFACTURERMATERIAL == MARA.MATNR
Material Number
  • Client
  • Material Number
  • C_PURDOCLISTOVERVIEW.MANDT == MARA.MANDT
  • C_PURDOCLISTOVERVIEW.MATERIAL == MARA.MATNR
Material Group
  • Client
  • Material Group
  • C_PURDOCLISTOVERVIEW.MANDT == T023.MANDT
  • C_PURDOCLISTOVERVIEW.MATERIALGROUP == T023.MATKL
Item category in purchasing document
  • Client
  • Item category in purchasing document
  • C_PURDOCLISTOVERVIEW.MANDT == T163.MANDT
  • C_PURDOCLISTOVERVIEW.PURCHASEORDERITEMCATEGORY == T163.PSTYP
Purchase Requisition Document Type
  • Purchasing Document Category
  • Purchase Requisition Document Type
  • Client
  • C_PURDOCLISTOVERVIEW.PURCHASINGDOCUMENTCATEGORY == T161.BSTYP
  • C_PURDOCLISTOVERVIEW.PURCHASINGDOCUMENTTYPE == T161.BSART
  • C_PURDOCLISTOVERVIEW.MANDT == T161.MANDT
Purchasing Group
  • Purchasing Group
  • Client
  • C_PURDOCLISTOVERVIEW.PURCHASINGGROUP == T024.EKGRP
  • C_PURDOCLISTOVERVIEW.MANDT == T024.MANDT
Purchasing organization
  • Purchasing organization
  • Client
  • C_PURDOCLISTOVERVIEW.PURCHASINGORGANIZATION == T024E.EKORG
  • C_PURDOCLISTOVERVIEW.MANDT == T024E.MANDT
Purchase requisition unit of measure
  • Client
  • Purchase requisition unit of measure
  • C_PURDOCLISTOVERVIEW.MANDT == T006.MANDT
  • C_PURDOCLISTOVERVIEW.QUANTITYUNIT == T006.MSEHI
Country key
  • Client
  • Country/Region Key
  • C_PURDOCLISTOVERVIEW.MANDT == T005.MANDT
  • C_PURDOCLISTOVERVIEW.SUPPLIERADDRESSCOUNTRY == T005.LAND1