P_SupplierMaterialGroupSpend2

Supplier and Material Group Spends with Display Currencies | view: PSUPLRMGRPSPND2 | Extraction: Not supported | Component: Category Management
Tables used: EKKOEKPOBUT000LFA1CVI_VEND_LINK
Column Name Description
MaterialGroup FK Material Group
Supplier FK Supplier
Column Name Description
💲 Currency Key (OriginalCurrency):
PurchaseOrderNetAmount 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
  • Client
  • Material Group
  • P_SUPPLIERMATERIALGROUPSPEND2.MANDT == T023.MANDT
  • P_SUPPLIERMATERIALGROUPSPEND2.MATERIALGROUP == T023.MATKL
Currency Key
  • Client
  • Currency Key
  • P_SUPPLIERMATERIALGROUPSPEND2.MANDT == TCURC.MANDT
  • P_SUPPLIERMATERIALGROUPSPEND2.ORIGINALCURRENCY == TCURC.WAERS
Supplier
  • Supplier
  • Client
  • P_SUPPLIERMATERIALGROUPSPEND2.SUPPLIER == LFA1.LIFNR
  • P_SUPPLIERMATERIALGROUPSPEND2.MANDT == LFA1.MANDT