C_PurchasingGroupAnalysis

Purchasing Group Analysis Query | view: CMMPURGRPANA | TRAN | Extraction: Not supported | Component: Reporting
Tables used: SCAL_TT_DATEEKKOEKPOEKETEKBZEKBZHEKBEEKBEHADCPADRCBUT000T001TKA02T005TT163BT024T024ELFA1LFB1CVI_VEND_LINK
Column Name Description
CalendarYear Calendar Year
CalendarMonth Calendar Month
CalendarQuarter Calendar Quarter
CalendarWeek Calendar Week
PurchasingOrganization FK Purchasing organization
PurchasingGroup FK Purchasing Group
Supplier FK Supplier
CompanyCode FK Company Code
OrderQuantityUnit Unit
PurchasingDocumentCategory Purchasing Document Category Show values
PurchasingDocumentStatus Status of Purchasing Document Show values
Column Name Description
💲 Display Currency (DisplayCurrency):
PurchaseOrderAmount Purchase Order Net Amount
InvoiceAmtInDisplayCurrency Invoice Amount
Column Name Description
📏 Unit (OrderQuantityUnit):
GoodsReceiptQty Quantity of Goods Received
Column Name Description
Column Name Description
PurchasingDocumentCategory Purchasing Document Category Show values
PurchasingDocumentStatus Status of Purchasing Document Show values
Column Name Description Domain name
PurchasingOrganizationName Purchasing Organization Name TEXT20
PurchasingGroupName Purchasing Group Name TEXT18
SupplierName Name of Supplier TEXT80
CountryName Country/Region Name TEXT50
NumberOfContracts Number of Contracts
NumberOfContractItems null
NumberOfPurchaseOrders Number of Purchase Orders
NumberOfPurchaseOrderItems null
NumberOfQuotationItems null
NumberOfPurOrderSchedgLines null
NumberOfSchedgAgrmtSchedgLines null
NumberOfSchedulingAgreements Number Of Scheduling Agreements
NumberOfSchedgAgrmtItems null
NumberOfRequestsForQuotation null
NumberOfReqForQuotationItems null
NumberOfDeliveries Number of Deliveries
Master Data Relations Join Conditions
Company Code
  • Company Code
  • Client
  • C_PURCHASINGGROUPANALYSIS.COMPANYCODE == T001.BUKRS
  • C_PURCHASINGGROUPANALYSIS.MANDT == T001.MANDT
Purchasing Group
  • Purchasing Group
  • Client
  • C_PURCHASINGGROUPANALYSIS.PURCHASINGGROUP == T024.EKGRP
  • C_PURCHASINGGROUPANALYSIS.MANDT == T024.MANDT
Purchasing organization
  • Purchasing organization
  • Client
  • C_PURCHASINGGROUPANALYSIS.PURCHASINGORGANIZATION == T024E.EKORG
  • C_PURCHASINGGROUPANALYSIS.MANDT == T024E.MANDT
Supplier
  • Supplier
  • Client
  • C_PURCHASINGGROUPANALYSIS.SUPPLIER == LFA1.LIFNR
  • C_PURCHASINGGROUPANALYSIS.MANDT == LFA1.MANDT
Country key
  • Supplier Country/Region
  • Client
  • C_PURCHASINGGROUPANALYSIS.SUPPLIERCOUNTRY == T005.LAND1
  • C_PURCHASINGGROUPANALYSIS.MANDT == T005.MANDT