I_Sourceofsupplymanage

Manage Sources Of supply | view: IMMSOSMANAGE | Extraction: Not supported | Component: Source List
Tables used: EKKOEKPOEQUKEQUPEQUPEKKOT001TKA02MARAT023TMAKTEORDT001WT024WEINAT024EEINELFA1LFB1LFA1USR21
Column Name Description
SourceDocument Purchasing Document Number
SourceDocumentItem Item Number of Purchasing Document
Material FK Material Number
Plant FK Plant
PurchasingOrganization FK Purchasing organization
SourceListRecord Number of Source List Record
PurchasingInfoRecordCategory Purchasing info record category Show values
PurchasingSourceType Purchasing Source Type
Column Name Description
Column Name Description
Column Name Description
ValidityEndDate End of Validity Period
ValidityStartDate Start of Validity Period
Column Name Description
PurchasingInfoRecordCategory Purchasing info record category Show values
PurchasingDocumentCategory Purchasing Document Category Show values
Column Name Description Domain name
QuotaInPercent Quota of Quota Arrangement Item in Percent PRZ31
MaterialName Material Description TEXT40
SourceOfSupplyIsBlocked null
SourceOfSupplyIsFixed null
WeightedRelevance Weighted Relevance
IsExpired Single-Character Flag CHAR1
FormattedDocumentKey null
PlantName Plant Name TEXT30
MaterialGroupName Product Group Description TEXT20
SupplierName Name of Supplier TEXT80
PurchasingOrganizationName Purchasing Organization Name TEXT20
Master Data Relations Join Conditions
Company Code
  • Client
  • Company Code
  • I_SOURCEOFSUPPLYMANAGE.MANDT == T001.MANDT
  • I_SOURCEOFSUPPLYMANAGE.COMPANYCODE == T001.BUKRS
Material Number
  • Client
  • Material Number
  • I_SOURCEOFSUPPLYMANAGE.MANDT == MARA.MANDT
  • I_SOURCEOFSUPPLYMANAGE.MATERIAL == MARA.MATNR
Material Group
  • Client
  • Material Group
  • I_SOURCEOFSUPPLYMANAGE.MANDT == T023.MANDT
  • I_SOURCEOFSUPPLYMANAGE.MATERIALGROUP == T023.MATKL
Plant
  • Client
  • Plant
  • I_SOURCEOFSUPPLYMANAGE.MANDT == T001W.MANDT
  • I_SOURCEOFSUPPLYMANAGE.PLANT == T001W.WERKS
Purchasing Document Type
  • Purchasing Document Type
  • Purchasing Document Category
  • Client
  • I_SOURCEOFSUPPLYMANAGE.PURCHASINGDOCUMENTTYPE == T161.BSART
  • I_SOURCEOFSUPPLYMANAGE.PURCHASINGDOCUMENTCATEGORY == T161.BSTYP
  • I_SOURCEOFSUPPLYMANAGE.MANDT == T161.MANDT
Purchasing Group
  • Client
  • Purchasing Group
  • I_SOURCEOFSUPPLYMANAGE.MANDT == T024.MANDT
  • I_SOURCEOFSUPPLYMANAGE.PURCHASINGGROUP == T024.EKGRP
Purchasing organization
  • Client
  • Purchasing organization
  • I_SOURCEOFSUPPLYMANAGE.MANDT == T024E.MANDT
  • I_SOURCEOFSUPPLYMANAGE.PURCHASINGORGANIZATION == T024E.EKORG
Storage Location
  • Client
  • Plant
  • Storage Location
  • I_SOURCEOFSUPPLYMANAGE.MANDT == T001L.MANDT
  • I_SOURCEOFSUPPLYMANAGE.PLANT == T001L.WERKS
  • I_SOURCEOFSUPPLYMANAGE.STORAGELOCATION == T001L.LGORT
Supplier
  • Client
  • Supplier
  • I_SOURCEOFSUPPLYMANAGE.MANDT == LFA1.MANDT
  • I_SOURCEOFSUPPLYMANAGE.SUPPLIER == LFA1.LIFNR