m_v_purchasing_sos

DDL: M_V_PURCHASING_SOS SQL: CDS_M_PUR_SOS Type: view Package: APPL_MM_PUR_SOS
69 Fields 2 Data Sources

Purchasing Sources of Supply

m_v_purchasing_sos is a CDS View that provides data about "Purchasing Sources of Supply" in SAP S/4HANA. It reads from 2 data sources (m_v_inforecord_sos, m_v_outline_agreement_sos) and exposes 69 fields. Part of development package APPL_MM_PUR_SOS.

Data Sources (2)

SourceAliasJoin Type
m_v_inforecord_sos m_v_inforecord_sos from
m_v_outline_agreement_sos OA union_all

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName CDS_M_PUR_SOS view
EndUserText.label Purchasing Sources of Supply view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view

Fields (69)

KeyFieldSource TableSource FieldDescription
matnr Inforecord matnr Vehicle Model
werks Inforecord werks Receiving Plant
lifnr Inforecord lifnr Vendor no.
validitydate Inforecord validitydate Valid On
infnr Inforecord infnr Info Record
ebeln Source PurchDoc
ebelp Item pur. doc.
zeord
aut_source
notkz
bstmi Inforecord bstmi Min. Lot Size
bstma Inforecord bstma To Lot Size
bstyp Inforecord bstyp Source doc.cat.
pstyp Inforecord pstyp Item Category
ekorg Inforecord ekorg Purchasing Org.
ekgrp Inforecord ekgrp Sub. purchasing grp
esokz Inforecord esokz Infotype
lgort Inforecord lgort Sublocation
reswk Inforecord reswk Supplying Plant
reslo Inforecord reslo Iss. Stor. Loc.
webaz Inforecord webaz GR Proc. Time
plifz Inforecord plifz Plnd Deliv.Time
verid Inforecord verid Version ID
flifn
emlif Inforecord emlif Supplier
lblkz Inforecord lblkz SC Supplier
lphis Inforecord lphis Release Docu.
rdprf Inforecord rdprf Rounding Prfl.
netpr Inforecord netpr Price
waers Inforecord waers Transaction Currency
peinh Inforecord peinh Unit of measure
eortp
meins
sobkz Inforecord sobkz Special Stock
matnr Vehicle Model
werks m_v_outline_agreement_sos werks Receiving Plant
lifnr m_v_outline_agreement_sos lifnr Vendor no.
validitydate m_v_outline_agreement_sos validitydate Valid On
infnr Info Record
ebeln m_v_outline_agreement_sos ebeln Source PurchDoc
ebelp m_v_outline_agreement_sos ebelp Item pur. doc.
zeord
aut_source
notkz
bstmi m_v_outline_agreement_sos bstmi Min. Lot Size
bstma m_v_outline_agreement_sos bstma To Lot Size
bstyp m_v_outline_agreement_sos bstyp Source doc.cat.
pstyp m_v_outline_agreement_sos pstyp Item Category
ekorg m_v_outline_agreement_sos ekorg Purchasing Org.
ekgrp m_v_outline_agreement_sos ekgrp Sub. purchasing grp
esokz m_v_outline_agreement_sos esokz Infotype
lgort m_v_outline_agreement_sos lgort Sublocation
reswk m_v_outline_agreement_sos reswk Supplying Plant
reslo m_v_outline_agreement_sos reslo Iss. Stor. Loc.
webaz m_v_outline_agreement_sos webaz GR Proc. Time
plifz m_v_outline_agreement_sos plifz Plnd Deliv.Time
verid m_v_outline_agreement_sos verid Version ID
flifn
emlif m_v_outline_agreement_sos emlif Supplier
lblkz m_v_outline_agreement_sos lblkz SC Supplier
lphis m_v_outline_agreement_sos lphis Release Docu.
rdprf m_v_outline_agreement_sos rdprf Rounding Prfl.
netpr m_v_outline_agreement_sos netpr Price
waers m_v_outline_agreement_sos waers Transaction Currency
peinh m_v_outline_agreement_sos peinh Unit of measure
eortp
meins
sobkz m_v_outline_agreement_sos sobkz Special Stock
priority

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view m_v_purchasing_sos.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: CDS_M_PUR_SOS

CREATE VIEW m_v_purchasing_sos AS
SELECT
  Inforecord.matnr AS matnr,
  Inforecord.werks AS werks,
  Inforecord.lifnr AS lifnr,
  Inforecord.validitydate AS validitydate,
  Inforecord.infnr AS infnr,
  cast(coalesce (Inforecord.ebeln,'') as ebeln) AS ebeln,
  cast(coalesce (Inforecord.ebelp,'00000') as ebelp) AS ebelp,
  cast(coalesce (Inforecord.zeord,'00000') as dzeord) AS zeord,
  cast(coalesce (Inforecord.aut_source,'') as aut_source) AS aut_source,
  cast(coalesce (Inforecord.notkz,'') as ordsp) AS notkz,
  Inforecord.bstmi AS bstmi,
  Inforecord.bstma AS bstma,
  Inforecord.bstyp AS bstyp,
  Inforecord.pstyp AS pstyp,
  Inforecord.ekorg AS ekorg,
  Inforecord.ekgrp AS ekgrp,
  Inforecord.esokz AS esokz,
  Inforecord.lgort AS lgort,
  Inforecord.reswk AS reswk,
  Inforecord.reslo AS reslo,
  Inforecord.webaz AS webaz,
  Inforecord.plifz AS plifz,
  Inforecord.verid AS verid,
  cast (coalesce (Inforecord.flifn,'') as flifn) AS flifn,
  Inforecord.emlif AS emlif,
  Inforecord.lblkz AS lblkz,
  Inforecord.lphis AS lphis,
  Inforecord.rdprf AS rdprf,
  Inforecord.netpr AS netpr,
  Inforecord.waers AS waers,
  Inforecord.peinh AS peinh,
  cast (coalesce (Inforecord.eortp,'') as eortp) AS eortp,
  cast (coalesce (Inforecord.meins,'') as bstme) AS meins,
  Inforecord.sobkz AS sobkz,
  cast(OA.priority as abap.int1) AS priority
FROM m_v_inforecord_sos
-- UNION ALL with additional select branch(es): m_v_outline_agreement_sos
;

Learn More