P_PurchasingGroupAnalysis2

Purchasing Group Analysis 2 | view: PMMPURGRPAN2 | Extraction: Not supported | Component: Reporting
Tables used: SCAL_TT_DATEEKKOEKPOEKBZEKBZHEKBEEKBEHT001TKA02T163B
Column Name Description
PurchaseOrder FK Purchase Order Number
PurchaseOrderItem FK Item Number of Purchase Order
PurchaseOrderTransactionType Transaction/event type, purchase order history Show values
Column Name Description
💲 null (DisplayCurrency):
TotalInvoiceAmountInDisCrcy null
Column Name Description
Column Name Description
PostingDate Posting Date in the Document
Column Name Description
PurchaseOrderTransactionType Transaction/event type, purchase order history Show values
PurchasingDocumentCategory Purchasing Document Category Show values
PurchasingDocumentStatus Status of Purchasing Document Show values
Column Name Description Domain name
CalendarYear Calendar Year NUM4
CalendarMonth Calendar Month NUM2
CalendarQuarter Calendar Quarter NUM1
CalendarWeek Calendar Week NUM2
Master Data Relations Join Conditions
Company Code
  • Client
  • Company Code
  • P_PURCHASINGGROUPANALYSIS2.MANDT == T001.MANDT
  • P_PURCHASINGGROUPANALYSIS2.COMPANYCODE == T001.BUKRS
Currency Key
  • Client
  • Currency Key
  • P_PURCHASINGGROUPANALYSIS2.MANDT == TCURC.MANDT
  • P_PURCHASINGGROUPANALYSIS2.COMPANYCODECURRENCY == TCURC.WAERS
Plant
  • Client
  • Plant
  • P_PURCHASINGGROUPANALYSIS2.MANDT == T001W.MANDT
  • P_PURCHASINGGROUPANALYSIS2.PLANT == T001W.WERKS
Purchase Order Type
  • Purchase Order Type
  • Client
  • Purchasing Document Category
  • P_PURCHASINGGROUPANALYSIS2.PURCHASEORDERTYPE == T161.BSART
  • P_PURCHASINGGROUPANALYSIS2.MANDT == T161.MANDT
  • P_PURCHASINGGROUPANALYSIS2.PURCHASINGDOCUMENTCATEGORY == T161.BSTYP
Purchasing Group
  • Purchasing Group
  • Client
  • P_PURCHASINGGROUPANALYSIS2.PURCHASINGGROUP == T024.EKGRP
  • P_PURCHASINGGROUPANALYSIS2.MANDT == T024.MANDT
Purchasing organization
  • Client
  • Purchasing organization
  • P_PURCHASINGGROUPANALYSIS2.MANDT == T024E.MANDT
  • P_PURCHASINGGROUPANALYSIS2.PURCHASINGORGANIZATION == T024E.EKORG
Supplier
  • Supplier
  • Client
  • P_PURCHASINGGROUPANALYSIS2.SUPPLIER == LFA1.LIFNR
  • P_PURCHASINGGROUPANALYSIS2.MANDT == LFA1.MANDT