P_MatGroupSupplierSpendIDC

Spend per Supplier MaterialGroup combination in Disp Crcy | view: PMGRPSUPLRSPNDID | Extraction: Not supported | Component: Category Management
Tables used: EKKOEKPOBUT000T023T000LFA1CVI_VEND_LINK
Column Name Description
MaterialGroup FK Material Group
Supplier FK Supplier
Column Name Description
💲 Currency Key (OriginalCurrency):
PurchaseOrderNetAmount null
💲 Standard Currency in Client (SupplierDisplayCurrency):
SupplierNetAmountInDisplayCrcy null
💲 Standard Currency in Client (MaterialGroupDisplayCurrency):
MatlGrpNetAmountInDisplayCrcy null
Column Name Description
Column Name Description
FromPostingDate null
PurchaseOrderDate Purchase Order Date
Column Name Description
ItemIsStatistical Item is statistical Show values
IsReturnsItem Returns Item Show values
Column Name Description Domain name
BusinessPartner Business Partner Number BU_PARTNER
PurchasingDocumentDeletionCode Deletion Indicator in Purchasing Document ELOEK
Master Data Relations Join Conditions
Material Group
  • Material Group
  • Client
  • P_MATGROUPSUPPLIERSPENDIDC.MATERIALGROUP == T023.MATKL
  • P_MATGROUPSUPPLIERSPENDIDC.MANDT == T023.MANDT
Standard Currency in Client
  • Client
  • Standard Currency in Client
  • Standard Currency in Client
  • P_MATGROUPSUPPLIERSPENDIDC.MANDT == TCURC.MANDT
  • P_MATGROUPSUPPLIERSPENDIDC.MATERIALGROUPDISPLAYCURRENCY == TCURC.WAERS
  • P_MATGROUPSUPPLIERSPENDIDC.SUPPLIERDISPLAYCURRENCY == TCURC.WAERS
Currency Key
  • Currency Key
  • Client
  • P_MATGROUPSUPPLIERSPENDIDC.ORIGINALCURRENCY == TCURC.WAERS
  • P_MATGROUPSUPPLIERSPENDIDC.MANDT == TCURC.MANDT
Supplier
  • Supplier
  • Client
  • P_MATGROUPSUPPLIERSPENDIDC.SUPPLIER == LFA1.LIFNR
  • P_MATGROUPSUPPLIERSPENDIDC.MANDT == LFA1.MANDT
Standard Currency in Client
  • Client
  • Standard Currency in Client
  • Standard Currency in Client
  • P_MATGROUPSUPPLIERSPENDIDC.MANDT == TCURC.MANDT
  • P_MATGROUPSUPPLIERSPENDIDC.MATERIALGROUPDISPLAYCURRENCY == TCURC.WAERS
  • P_MATGROUPSUPPLIERSPENDIDC.SUPPLIERDISPLAYCURRENCY == TCURC.WAERS