P_MatGrpSuplrSpendIDCRe

Spend per Supplier and Mat. Group restricted by a given date | view: PMGRPSPLRSPNDIDR | Extraction: Not supported | Component: Category Management
Tables used: EKKOEKPOBUT000T023T000LFA1CVI_VEND_LINK
Column Name Description
MaterialGroup FK Material Group
Supplier FK Supplier
Column Name Description
💲 Standard Currency in Client (MaterialGroupDisplayCurrency):
MatlGrpNetAmountInDisplayCrcy null
💲 Standard Currency in Client (SupplierDisplayCurrency):
SupplierNetAmountInDisplayCrcy null
Column Name Description
Column Name Description
FromPostingDate null
PurchaseOrderDate Purchase Order Date
Column Name Description
Column Name Description Domain name
BusinessPartner Business Partner Number BU_PARTNER
Master Data Relations Join Conditions
Material Group
  • Client
  • Material Group
  • P_MATGRPSUPLRSPENDIDCRE.MANDT == T023.MANDT
  • P_MATGRPSUPLRSPENDIDCRE.MATERIALGROUP == T023.MATKL
Standard Currency in Client
  • Client
  • Standard Currency in Client
  • Standard Currency in Client
  • P_MATGRPSUPLRSPENDIDCRE.MANDT == TCURC.MANDT
  • P_MATGRPSUPLRSPENDIDCRE.MATERIALGROUPDISPLAYCURRENCY == TCURC.WAERS
  • P_MATGRPSUPLRSPENDIDCRE.SUPPLIERDISPLAYCURRENCY == TCURC.WAERS
Supplier
  • Client
  • Supplier
  • P_MATGRPSUPLRSPENDIDCRE.MANDT == LFA1.MANDT
  • P_MATGRPSUPLRSPENDIDCRE.SUPPLIER == LFA1.LIFNR
Standard Currency in Client
  • Client
  • Standard Currency in Client
  • Standard Currency in Client
  • P_MATGRPSUPLRSPENDIDCRE.MANDT == TCURC.MANDT
  • P_MATGRPSUPLRSPENDIDCRE.MATERIALGROUPDISPLAYCURRENCY == TCURC.WAERS
  • P_MATGRPSUPLRSPENDIDCRE.SUPPLIERDISPLAYCURRENCY == TCURC.WAERS