P_PurchasingGroupAnalysis1

Purchasing Group Analysis 1 | view: PMMPURGRPAN1 | Extraction: Not supported | Component: Reporting
Tables used: SCAL_TT_DATEEKKOEKPO
Column Name Description
PurchasingDocument FK Purchasing Document Number
PurchasingDocumentItem Item Number of Purchasing Document
Column Name Description
💲 null (DisplayCurrency):
NetAmountInDisplayCurrency null
Column Name Description
Column Name Description
Column Name Description
PurchasingDocumentCategory Purchasing Document Category Show values
PurchasingDocumentStatus Status of Purchasing Document Show values
IsReturnsItem Returns Item Show values
Column Name Description Domain name
PurchasingDocumentItemNo null
CalendarYear Calendar Year NUM4
CalendarMonth Calendar Month NUM2
CalendarQuarter Calendar Quarter NUM1
CalendarWeek Calendar Week NUM2
Master Data Relations Join Conditions
Company Code
  • Company Code
  • Client
  • P_PURCHASINGGROUPANALYSIS1.COMPANYCODE == T001.BUKRS
  • P_PURCHASINGGROUPANALYSIS1.MANDT == T001.MANDT
Currency Key
  • Client
  • Currency Key
  • P_PURCHASINGGROUPANALYSIS1.MANDT == TCURC.MANDT
  • P_PURCHASINGGROUPANALYSIS1.DOCUMENTCURRENCY == TCURC.WAERS
Material Number
  • Client
  • Material Number
  • P_PURCHASINGGROUPANALYSIS1.MANDT == MARA.MANDT
  • P_PURCHASINGGROUPANALYSIS1.MATERIAL == MARA.MATNR
Material Group
  • Client
  • Material Group
  • P_PURCHASINGGROUPANALYSIS1.MANDT == T023.MANDT
  • P_PURCHASINGGROUPANALYSIS1.MATERIALGROUP == T023.MATKL
Plant
  • Client
  • Plant
  • P_PURCHASINGGROUPANALYSIS1.MANDT == T001W.MANDT
  • P_PURCHASINGGROUPANALYSIS1.PLANT == T001W.WERKS
Purchasing Group
  • Client
  • Purchasing Group
  • P_PURCHASINGGROUPANALYSIS1.MANDT == T024.MANDT
  • P_PURCHASINGGROUPANALYSIS1.PURCHASINGGROUP == T024.EKGRP
Purchasing organization
  • Client
  • Purchasing organization
  • P_PURCHASINGGROUPANALYSIS1.MANDT == T024E.MANDT
  • P_PURCHASINGGROUPANALYSIS1.PURCHASINGORGANIZATION == T024E.EKORG
Supplier
  • Client
  • Supplier
  • P_PURCHASINGGROUPANALYSIS1.MANDT == LFA1.MANDT
  • P_PURCHASINGGROUPANALYSIS1.SUPPLIER == LFA1.LIFNR