P_PurchasingGroupAnalysis3

Purchasing Group Analysis 3 | view: PMMPURGRPAN3 | Extraction: Not supported | Component: Reporting
Tables used: SCAL_TT_DATEEKKOEKPOEKETEKBZEKBZHEKBEEKBEHT001TKA02T163B
Column Name Description
PurchasingOrganization FK Purchasing organization
PurchasingGroup FK Purchasing Group
Supplier FK Supplier
CompanyCode FK Company Code
CalendarYear Calendar Year
CalendarMonth Calendar Month
CalendarQuarter Calendar Quarter
CalendarWeek Calendar Week
PurchasingDocumentCategory Purchasing Document Category Show values
PurchasingDocumentStatus Status of Purchasing Document Show values
Column Name Description
💲 Display Currency (DisplayCurrency):
PurchaseOrderAmount null
TotalInvoiceAmountInDisCrcy null
Column Name Description
RoughGoodsReceiptQty null
Column Name Description
Column Name Description
PurchasingDocumentCategory Purchasing Document Category Show values
PurchasingDocumentStatus Status of Purchasing Document Show values
Column Name Description Domain name
NumberOfRequestsForQuotation null
NumberOfReqForQuotationItems null
NumberOfPurchaseOrders null
NumberOfPurchaseOrderItems null
NumberOfSchedulingAgreements null
NumberOfSchedgAgrmtItems null
NumberOfContracts null
NumberOfContractItems null
NumberOfQuotation null
NumberOfQuotationItems null
ScheduleLines null
NumberOfDeliveries null
Master Data Relations Join Conditions
Company Code
  • Company Code
  • Client
  • P_PURCHASINGGROUPANALYSIS3.COMPANYCODE == T001.BUKRS
  • P_PURCHASINGGROUPANALYSIS3.MANDT == T001.MANDT
Purchasing Group
  • Purchasing Group
  • Client
  • P_PURCHASINGGROUPANALYSIS3.PURCHASINGGROUP == T024.EKGRP
  • P_PURCHASINGGROUPANALYSIS3.MANDT == T024.MANDT
Purchasing organization
  • Purchasing organization
  • Client
  • P_PURCHASINGGROUPANALYSIS3.PURCHASINGORGANIZATION == T024E.EKORG
  • P_PURCHASINGGROUPANALYSIS3.MANDT == T024E.MANDT
Supplier
  • Supplier
  • Client
  • P_PURCHASINGGROUPANALYSIS3.SUPPLIER == LFA1.LIFNR
  • P_PURCHASINGGROUPANALYSIS3.MANDT == LFA1.MANDT