C_ExtPurReqnProposedSOS

Available Sources of Supply | view: CEXTPRPSOS | Extraction: Not supported | Component: Processing Purchase Requisitions Centrally
Tables used: EKKOEKPOEQUKEQUPEQUPMARAEORDT001WEINAT024EEINEA017A018A025A028KONPLFA1LFA1LFM2LFM1USR21
Column Name Description
SourceDocument FK 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
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
DeliveryDate null
Column Name Description
SourceOfSupplyIsFixed General Flag Show values
SourceOfSupplyIsBlocked Blocked Source of Supply Show values
Column Name Description Domain name
PlantName Plant Name TEXT30
SourceOfSupply null
PurchasingSourceType null
SourceDocumentBusObjTypeName null
Supplier Account Number of Supplier LIFNR
SupplierName Name 1 NAME
PurchasingOrganizationName Purchasing Organization Name TEXT20
QuotaInPercent null
SupplierRank null
PurchasingDocumentItemCategory null
PurchaseRequisitionType null
ExtSourceSystem null
ConsumptionPosting null
DomainText null
ProcmtHubServicePackage null
Master Data Relations Join Conditions
Account Assignment Category
  • Account Assignment Category
  • Client
  • C_EXTPURREQNPROPOSEDSOS.ACCOUNTASSIGNMENTCATEGORY == T163K.KNTTP
  • C_EXTPURREQNPROPOSEDSOS.MANDT == T163K.MANDT
Currency Key
  • Client
  • Currency Key
  • C_EXTPURREQNPROPOSEDSOS.MANDT == TCURC.MANDT
  • C_EXTPURREQNPROPOSEDSOS.CURRENCY == TCURC.WAERS
Material Number
  • Material Number
  • Client
  • C_EXTPURREQNPROPOSEDSOS.MATERIAL == MARA.MATNR
  • C_EXTPURREQNPROPOSEDSOS.MANDT == MARA.MANDT
Material Group
  • Material Group
  • Client
  • C_EXTPURREQNPROPOSEDSOS.MATERIALGROUP == T023.MATKL
  • C_EXTPURREQNPROPOSEDSOS.MANDT == T023.MANDT
Purchase Order Unit of Measure
  • Client
  • Purchase Order Unit of Measure
  • C_EXTPURREQNPROPOSEDSOS.MANDT == T006.MANDT
  • C_EXTPURREQNPROPOSEDSOS.ORDERQUANTITYUNIT == T006.MSEHI
Plant
  • Client
  • Plant
  • C_EXTPURREQNPROPOSEDSOS.MANDT == T001W.MANDT
  • C_EXTPURREQNPROPOSEDSOS.PLANT == T001W.WERKS
Purchasing Document Type
  • Purchasing Document Type
  • ?
  • Client
  • C_EXTPURREQNPROPOSEDSOS.PURCHASINGDOCUMENTTYPE == T161.BSART
  • C_EXTPURREQNPROPOSEDSOS.[column in domain "BSTYP"] == T161.BSTYP
  • C_EXTPURREQNPROPOSEDSOS.MANDT == T161.MANDT
Purchasing Group
  • Purchasing Group
  • Client
  • C_EXTPURREQNPROPOSEDSOS.PURCHASINGGROUP == T024.EKGRP
  • C_EXTPURREQNPROPOSEDSOS.MANDT == T024.MANDT
Purchasing organization
  • Purchasing organization
  • Client
  • C_EXTPURREQNPROPOSEDSOS.PURCHASINGORGANIZATION == T024E.EKORG
  • C_EXTPURREQNPROPOSEDSOS.MANDT == T024E.MANDT
Storage Location
  • Storage Location
  • Client
  • Plant
  • C_EXTPURREQNPROPOSEDSOS.STORAGELOCATION == T001L.LGORT
  • C_EXTPURREQNPROPOSEDSOS.MANDT == T001L.MANDT
  • C_EXTPURREQNPROPOSEDSOS.PLANT == T001L.WERKS