C_PurgDocItmOverview

My Purchasing Document Items Overview | view: CPURGDOCITEMSOVW | TRAN | Extraction: Not supported | Component: Purchase Orders
Tables used: MMDOC_EXT_LINKS, EBAN_TECH, FMIOI, MATDOC, EBAN, EKKO, EKBE, EKPO, EKKN, EKBEH, EKET, MMPUR_ANA_EKET, EBKN, RBKP, RBCO, RBKPB, RBDRSEG, RSEG, EKBE, EKBEH, APOC_D_OR_ITEM, APOC_D_OR_ITEM, APOC_D_OR_ITEM, APOC_D_OR_ITEM, NAST, EKKO, EKPO, T163I, T163K, T001, TKA02, TKA01, CSKS, CSKS, CSKT, FM01, T001W, T163B, MMPUR_ANA_CONF, T163, T163Y, T000, LFA1, T001K, PRPS, MMPUR_C_BE_SYREG, FINSC_FISC_DATE, T161M
Column Name Description
FormattedPurDoc FK Purchasing Document Number
PurchasingDocumentItem null
AccountAssignmentNumber Sequential Number of Account Assignment
FiscalYear Fiscal Year
OrdinalNumber Four Character Sequential Number for Coding Block Show values
Supplier FK Supplier
Column Name Description
Column Name Description
Column Name Description
DeliveryDate Item delivery date
Column Name Description
OrdinalNumber Four Character Sequential Number for Coding Block Show values
ObjectType Num1 Show values
Column Name Description Domain name
SupplierName Name of Supplier TEXT80
Status null
ServicePerformer Service Performer BU_PARTNER
CostCenter Cost Center KOSTL
SalesOrder Sales and Distribution Document Number VBELN
MaterialDocumentItemText Short Text
WBSElementExternalID Work Breakdown Structure Element (WBS Element) PS_POSID
WorkItem Work Item ID /CPD/PFP_WORKITEM_ID
PurchasingDocumentItemCategory Item Category in Purchasing Document
NumberOfPurchaseRequisitions null
NumberOfPurchaseOrderItems null
NumberOfGoodsReceipts null
NumberOfInvoiceReceipts null
PurchaseRequisitionType null
CompanyCode null
IssuingOrReceivingPlant null
IsEndOfPurposeBlocked null
Master Data Relations Join Conditions
Account Assignment Category
  • Client
  • Account Assignment Category
  • C_PURGDOCITMOVERVIEW.MANDT == T163K.MANDT
  • C_PURGDOCITMOVERVIEW.ACCOUNTASSIGNMENTCATEGORY == T163K.KNTTP
Material Number
  • Material Number
  • Client
  • C_PURGDOCITMOVERVIEW.MATERIAL == MARA.MATNR
  • C_PURGDOCITMOVERVIEW.MANDT == MARA.MANDT
Material Group
  • Client
  • Material Group
  • C_PURGDOCITMOVERVIEW.MANDT == T023.MANDT
  • C_PURGDOCITMOVERVIEW.MATERIALGROUP == T023.MATKL
Plant
  • Client
  • Plant
  • C_PURGDOCITMOVERVIEW.MANDT == T001W.MANDT
  • C_PURGDOCITMOVERVIEW.PLANT == T001W.WERKS
Purchase Order Type
  • ?
  • Client
  • Purchase Order Type
  • Purchase Order Type
  • C_PURGDOCITMOVERVIEW.[column in domain "BSTYP"] == T161.BSTYP
  • C_PURGDOCITMOVERVIEW.MANDT == T161.MANDT
  • C_PURGDOCITMOVERVIEW.PURCHASINGDOCUMENTTYPE == T161.BSART
  • C_PURGDOCITMOVERVIEW.PURCHASEORDERTYPE == T161.BSART
Purchase Order Type
  • ?
  • Client
  • Purchase Order Type
  • Purchase Order Type
  • C_PURGDOCITMOVERVIEW.[column in domain "BSTYP"] == T161.BSTYP
  • C_PURGDOCITMOVERVIEW.MANDT == T161.MANDT
  • C_PURGDOCITMOVERVIEW.PURCHASINGDOCUMENTTYPE == T161.BSART
  • C_PURGDOCITMOVERVIEW.PURCHASEORDERTYPE == T161.BSART
Purchasing Group
  • Client
  • Purchasing Group
  • C_PURGDOCITMOVERVIEW.MANDT == T024.MANDT
  • C_PURGDOCITMOVERVIEW.PURCHASINGGROUP == T024.EKGRP
Purchasing organization
  • Purchasing organization
  • Client
  • C_PURGDOCITMOVERVIEW.PURCHASINGORGANIZATION == T024E.EKORG
  • C_PURGDOCITMOVERVIEW.MANDT == T024E.MANDT
Supplier
  • Supplier
  • Client
  • C_PURGDOCITMOVERVIEW.SUPPLIER == LFA1.LIFNR
  • C_PURGDOCITMOVERVIEW.MANDT == LFA1.MANDT
Supplying (issuing) plant in case of stock transport order
  • Client
  • Supplying (issuing) plant in case of stock transport order
  • C_PURGDOCITMOVERVIEW.MANDT == T001W.MANDT
  • C_PURGDOCITMOVERVIEW.SUPPLYINGPLANT == T001W.WERKS