V_Mmim_Ddl_Sit_Po_Ivs

DDL: V_MMIM_DDL_SIT_PO_IVS SQL: V_PO_SIT_IVS Type: view
6 Fields 2 Data Sources

Show is. val. stock in transit for a PO

V_Mmim_Ddl_Sit_Po_Ivs is a CDS View that provides data about "Show is. val. stock in transit for a PO" in SAP S/4HANA. It reads from 2 data sources (V_Mmim_Ddl_Obd_Pohist, nsdm_e_mssa) and exposes 6 fields with key fields ebeln, ebelp, matnr, werks, sobkz.

Data Sources (2)

SourceAliasJoin Type
V_Mmim_Ddl_Obd_Pohist ekdlvry from
nsdm_e_mssa mssa inner

Annotations (9)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.preserveKey true view
AbapCatalog.sqlViewName V_PO_SIT_IVS view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #XL view
EndUserText.label Show is. val. stock in transit for a PO view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY ebeln V_Mmim_Ddl_Obd_Pohist ebeln Source PurchDoc
KEY ebelp V_Mmim_Ddl_Obd_Pohist ebelp Item pur. doc.
KEY matnr nsdm_e_mssa matnr Vehicle Model
KEY werks nsdm_e_mssa werks Receiving Plant
KEY sobkz nsdm_e_mssa sobkz Special Stock
sum_saspe

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 V_Mmim_Ddl_Sit_Po_Ivs.
-- 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: V_PO_SIT_IVS

CREATE VIEW V_Mmim_Ddl_Sit_Po_Ivs AS
SELECT
  ekdlvry.ebeln AS ebeln,
  ekdlvry.ebelp AS ebelp,
  mssa.matnr AS matnr,
  mssa.werks AS werks,
  mssa.sobkz AS sobkz,
  sum (mssa.saspe) AS sum_saspe
FROM V_Mmim_Ddl_Obd_Pohist AS ekdlvry
INNER JOIN nsdm_e_mssa AS mssa ON /* join condition not captured in parsed metadata */
;

Learn More