oib_e_mardo1

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 oib_e_mardo1.
-- 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: OIB_V_MARDO1

CREATE VIEW oib_e_mardo1 AS
SELECT
  t.mandt AS mandt,
  t.matnr AS matnr,
  t.werks AS werks,
  t.lgort AS lgort,
  t.msehi AS msehi,
  case when m.labst is null then 0 else m.labst end AS labst,
  case when m.umlme is null then 0 else m.umlme end AS umlme,
  case when m.insme is null then 0 else m.insme end AS insme,
  case when m.einme is null then 0 else m.einme end AS einme,
  case when m.speme is null then 0 else m.speme end AS speme,
  case when m.retme is null then 0 else m.retme end AS retme,
  case when m.vmlab is null then 0 else m.vmlab end AS vmlab,
  case when m.vmuml is null then 0 else m.vmuml end AS vmuml,
  case when m.vmins is null then 0 else m.vmins end AS vmins,
  case when m.vmein is null then 0 else m.vmein end AS vmein,
  case when m.vmspe is null then 0 else m.vmspe end AS vmspe,
  case when m.vmret is null then 0 else m.vmret end AS vmret,
  case when m.klabs is null then 0 else m.klabs end AS klabs,
  case when m.kinsm is null then 0 else m.kinsm end AS kinsm,
  case when m.keinm is null then 0 else m.keinm end AS keinm,
  case when m.kspem is null then 0 else m.kspem end AS kspem
FROM mardo1 AS t
LEFT OUTER JOIN oib_e_mardo1_dif AS m ON /* join condition not captured in parsed metadata */
;