C_POItemCountForSuplrQuery

PO and Item Count for Total Supplier - Query | view: CPOITMCNTQRY | Extraction: Not supported | Component: Reporting
Tables used: EKKOEKPOLFA1
Column Name Description
Supplier Account Number of Supplier
PurchaseOrder Purchase Order Number
PurchaseOrderItem Item Number of Purchase Order
Column Name Description
Column Name Description
Column Name Description
Column Name Description
Column Name Description Domain name
AuthorizationGroup Authorization Group BRGRU
NumberOfPurchaseOrders Number of Purchase Orders
NumberOfPurchaseOrderItems Number of Purchase Order Items
Master Data Relations Join Conditions
Country/Region Key
  • Country/Region Key
  • Client
  • C_POITEMCOUNTFORSUPLRQUERY.COUNTRY == T005.LAND1
  • C_POITEMCOUNTFORSUPLRQUERY.MANDT == T005.MANDT
Region (State, Province, County)
  • Region (State, Province, County)
  • Country/Region Key
  • Client
  • C_POITEMCOUNTFORSUPLRQUERY.REGION == T005S.BLAND
  • C_POITEMCOUNTFORSUPLRQUERY.COUNTRY == T005S.LAND1
  • C_POITEMCOUNTFORSUPLRQUERY.MANDT == T005S.MANDT
Vendor account group
  • Vendor account group
  • Client
  • C_POITEMCOUNTFORSUPLRQUERY.SUPPLIERACCOUNTGROUP == T077K.KTOKK
  • C_POITEMCOUNTFORSUPLRQUERY.MANDT == T077K.MANDT