I_SourcesOfSupply

Sources of Supply | view: IMMSOSSIMULATE | Extraction: Not supported | Component: Source List
Tables used: EKKOEKPOEQUKEQUPEQUPMARAEORDEINAEINEA017A018A025A028KONPLFA1LFA1LFM2LFM1USR21
Column Name Description
SourceDocument FK Purchasing Document Number
SourceDocumentItem Item Number of Purchasing Document
Material FK Material Number
Plant FK Plant
PurchasingInfoRecordCategory Purchasing info record category Show values
SourceListRecord Number of Source List Record
Column Name Description
💲 Currency Key (Currency):
NetPriceAmount Net Price in Purchasing Document (in Document Currency)
Column Name Description
Column Name Description
ValidityStartDate Start of Validity Period
ValidityEndDate End of Validity Period
ValidFrom Source List Record Valid From
ValidTo Source List Record Valid To
Column Name Description
PurchasingInfoRecordCategory Purchasing info record category Show values
PurOutlineAgreementIsFixed Fixed Outline Purchase Agreement Item Show values
SourceOfSupplyIsBlocked Blocked Source of Supply Show values
SourceOfSupplyIsFixed General Flag Show values
InspResultAttributeIsValid General Flag Show values
Column Name Description Domain name
PurchasingSourceType null
Supplier Account Number of Supplier LIFNR
SupplierName Name 1 NAME
AuthorizationGroup Authorization Group BRGRU
QuotaInPercent null
SupplierRank null
PurchasingDocumentItemText Short Text TEXT40
Master Data Relations Join Conditions
Account Assignment Category
  • Account Assignment Category
  • Client
  • I_SOURCESOFSUPPLY.ACCOUNTASSIGNMENTCATEGORY == T163K.KNTTP
  • I_SOURCESOFSUPPLY.MANDT == T163K.MANDT
Currency Key
  • Currency Key
  • Client
  • I_SOURCESOFSUPPLY.CURRENCY == TCURC.WAERS
  • I_SOURCESOFSUPPLY.MANDT == TCURC.MANDT
Material Number
  • Material Number
  • Client
  • I_SOURCESOFSUPPLY.MATERIAL == MARA.MATNR
  • I_SOURCESOFSUPPLY.MANDT == MARA.MANDT
Material Group
  • Material Group
  • Client
  • I_SOURCESOFSUPPLY.MATERIALGROUP == T023.MATKL
  • I_SOURCESOFSUPPLY.MANDT == T023.MANDT
Purchase Order Unit of Measure
  • Purchase Order Unit of Measure
  • Client
  • I_SOURCESOFSUPPLY.ORDERQUANTITYUNIT == T006.MSEHI
  • I_SOURCESOFSUPPLY.MANDT == T006.MANDT
Plant
  • Plant
  • Client
  • I_SOURCESOFSUPPLY.PLANT == T001W.WERKS
  • I_SOURCESOFSUPPLY.MANDT == T001W.MANDT
Purchasing Document Type
  • ?
  • Purchasing Document Type
  • Client
  • I_SOURCESOFSUPPLY.[column in domain "BSTYP"] == T161.BSTYP
  • I_SOURCESOFSUPPLY.PURCHASINGDOCUMENTTYPE == T161.BSART
  • I_SOURCESOFSUPPLY.MANDT == T161.MANDT
Purchasing Group
  • Purchasing Group
  • Client
  • I_SOURCESOFSUPPLY.PURCHASINGGROUP == T024.EKGRP
  • I_SOURCESOFSUPPLY.MANDT == T024.MANDT
Purchasing organization
  • Purchasing organization
  • Client
  • I_SOURCESOFSUPPLY.PURCHASINGORGANIZATION == T024E.EKORG
  • I_SOURCESOFSUPPLY.MANDT == T024E.MANDT
Storage Location
  • Storage Location
  • Plant
  • Client
  • I_SOURCESOFSUPPLY.STORAGELOCATION == T001L.LGORT
  • I_SOURCESOFSUPPLY.PLANT == T001L.WERKS
  • I_SOURCESOFSUPPLY.MANDT == T001L.MANDT