m_v_purchasing_sos

Purchasing Sources of Supply' | view: CDS_M_PUR_SOS | Extraction: Not supported | Component: Source List
Tables used: SCAL_TT_DATEEKKOEKPOSCAL_TT_DATEEINAEINEEORDLFA1LFM1MARCEINEEORDLFA1LFM1MARC
Column Name Description
Column Name Description
💲 Currency Key (waers):
netpr Net Price in Purchasing Info Record
Column Name Description
bstmi null
bstma null
Column Name Description
validitydate Calendar Date
Column Name Description
aut_source Relevant for Automatic Sourcing Show values
notkz Blocked Source of Supply Show values
bstyp Purchasing Document Category Show values
esokz Purchasing info record category Show values
flifn Indicator: Fixed Supplier Show values
lblkz Subcontracting Supplier Show values
lphis Indicator for scheduling agreement release documentation Show values
eortp Category of Source List Record Show values
Column Name Description Domain name
infnr Number of purchasing info record INFNR
ebeln Purchasing Document Number EBELN
ebelp Item Number of Purchasing Document EBELP
zeord Number of Source List Record NUM5
pstyp Item category in purchasing document PSTYP
lgort Storage location LGORT
reswk Supplying (issuing) plant in case of stock transport order WERKS
reslo Issuing Storage Location for Stock Transport Order LGORT
webaz Goods receipt processing time in days DEC3
plifz Planned Delivery Time in Days DEC3
emlif Supplier to be Supplied/Who is to Receive Delivery LIFNR
peinh Price unit DEC5
sobkz Special Stock Indicator SOBKZ
priority null
Master Data Relations Join Conditions
Purchasing Group
  • Client
  • Purchasing Group
  • M_V_PURCHASING_SOS.MANDT == T024.MANDT
  • M_V_PURCHASING_SOS.EKGRP == T024.EKGRP
Purchasing organization
  • Purchasing organization
  • Client
  • M_V_PURCHASING_SOS.EKORG == T024E.EKORG
  • M_V_PURCHASING_SOS.MANDT == T024E.MANDT
Vendor's account number
  • Client
  • Vendor's account number
  • M_V_PURCHASING_SOS.MANDT == LFA1.MANDT
  • M_V_PURCHASING_SOS.LIFNR == LFA1.LIFNR
Material Number
  • Material Number
  • Client
  • M_V_PURCHASING_SOS.MATNR == MARA.MATNR
  • M_V_PURCHASING_SOS.MANDT == MARA.MANDT
Rounding Profile
  • ?
  • Client
  • Plant
  • Rounding Profile
  • M_V_PURCHASING_SOS.[column in domain "RDZAE"] == RDPR.RDZAE
  • M_V_PURCHASING_SOS.MANDT == RDPR.MANDT
  • M_V_PURCHASING_SOS.WERKS == RDPR.WERKS
  • M_V_PURCHASING_SOS.RDPRF == RDPR.RDPRF
Production Version
  • Material Number
  • Client
  • Plant
  • Production Version
  • M_V_PURCHASING_SOS.MATNR == MKAL.MATNR
  • M_V_PURCHASING_SOS.MANDT == MKAL.MANDT
  • M_V_PURCHASING_SOS.WERKS == MKAL.WERKS
  • M_V_PURCHASING_SOS.VERID == MKAL.VERID
Currency Key
  • Client
  • Currency Key
  • M_V_PURCHASING_SOS.MANDT == TCURC.MANDT
  • M_V_PURCHASING_SOS.WAERS == TCURC.WAERS
Plant
  • Client
  • Plant
  • M_V_PURCHASING_SOS.MANDT == T001W.MANDT
  • M_V_PURCHASING_SOS.WERKS == T001W.WERKS