P_SourcesOfSupplyMaxDateCount

Calc. of latest creat. date and max count on match level | view: PSOSMAXDATECOUNT | Extraction: Not supported | Component: Quota Arrangement
Tables used: EKKOEKPOEQUKEQUPEQUPEKKOT001TKA02MARAMAKTEORDT001WT024WEINAEINELFA1LFB1LFA1USR21
Column Name Description
Supplier FK Supplier
Plant FK Plant
PurchasingOrganization FK Purchasing organization
Material FK Material Number
Column Name Description
Column Name Description
Column Name Description
LastSuppliedDate null
Column Name Description
Column Name Description Domain name
PurchasingDocumentCount null
Master Data Relations Join Conditions
Material Number
  • Client
  • Material Number
  • P_SOURCESOFSUPPLYMAXDATECOUNT.MANDT == MARA.MANDT
  • P_SOURCESOFSUPPLYMAXDATECOUNT.MATERIAL == MARA.MATNR
Plant
  • Plant
  • Client
  • P_SOURCESOFSUPPLYMAXDATECOUNT.PLANT == T001W.WERKS
  • P_SOURCESOFSUPPLYMAXDATECOUNT.MANDT == T001W.MANDT
Purchasing organization
  • Purchasing organization
  • Client
  • P_SOURCESOFSUPPLYMAXDATECOUNT.PURCHASINGORGANIZATION == T024E.EKORG
  • P_SOURCESOFSUPPLYMAXDATECOUNT.MANDT == T024E.MANDT
Supplier
  • Supplier
  • Client
  • P_SOURCESOFSUPPLYMAXDATECOUNT.SUPPLIER == LFA1.LIFNR
  • P_SOURCESOFSUPPLYMAXDATECOUNT.MANDT == LFA1.MANDT