I_SourcesOfSupplyProposal

Calc. of relevancies for supplier-material matches | view: ISOSPROPOSAL | TRAN | 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
Column Name Description
Column Name Description Domain name
MaterialName Material Description TEXT40
NumberOfMaterials null
WeightedRelevance Weighted Relevance
PurchasingSourceType Purchasing Source Type
Master Data Relations Join Conditions
Material Number
  • Client
  • Material Number
  • I_SOURCESOFSUPPLYPROPOSAL.MANDT == MARA.MANDT
  • I_SOURCESOFSUPPLYPROPOSAL.MATERIAL == MARA.MATNR
Plant
  • Client
  • Plant
  • I_SOURCESOFSUPPLYPROPOSAL.MANDT == T001W.MANDT
  • I_SOURCESOFSUPPLYPROPOSAL.PLANT == T001W.WERKS
Purchasing Document Type
  • Client
  • ?
  • Purchasing Document Type
  • I_SOURCESOFSUPPLYPROPOSAL.MANDT == T161.MANDT
  • I_SOURCESOFSUPPLYPROPOSAL.[column in domain "BSTYP"] == T161.BSTYP
  • I_SOURCESOFSUPPLYPROPOSAL.PURCHASINGDOCUMENTTYPE == T161.BSART
Purchasing Group
  • Client
  • Purchasing Group
  • I_SOURCESOFSUPPLYPROPOSAL.MANDT == T024.MANDT
  • I_SOURCESOFSUPPLYPROPOSAL.PURCHASINGGROUP == T024.EKGRP
Purchasing organization
  • Purchasing organization
  • Client
  • I_SOURCESOFSUPPLYPROPOSAL.PURCHASINGORGANIZATION == T024E.EKORG
  • I_SOURCESOFSUPPLYPROPOSAL.MANDT == T024E.MANDT
Supplier
  • Client
  • Supplier
  • I_SOURCESOFSUPPLYPROPOSAL.MANDT == LFA1.MANDT
  • I_SOURCESOFSUPPLYPROPOSAL.SUPPLIER == LFA1.LIFNR