FMLV_PRDHCS_UCT

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 FMLV_PRDHCS_UCT.
-- 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: FMLPRDHCSUCT

CREATE VIEW FMLV_PRDHCS_UCT AS
SELECT
  H.mlvnr AS mlvnr,
  H.VGABE AS VGABE,
  H.GJAHR AS GJAHR,
  H.BELNR AS BELNR,
  H.BUZEI AS BUZEI,
  H.KALNR AS KALNR,
  H.CURTP AS CURTP,
  K.keart AS keart,
  K.mlcct AS mlcct,
  K.kkzst AS kkzst,
  K.patnr AS patnr,
  K.dipa AS dipa,
  H.aufnr AS aufnr,
  H.posnr AS posnr,
  H.logsys AS logsys,
  H.initpoper AS initpoper,
  H.initbdatj AS initbdatj,
  H.init_done AS init_done,
  H.budat AS budat,
  H.menge AS menge,
  H.poper AS poper,
  H.bdatj AS bdatj,
  H.hrkft AS hrkft,
  H.kstar AS kstar,
  H.bwart AS bwart,
  H.MLAUF_AUFNR AS MLAUF_AUFNR,
  H.MLAUF_POSNR AS MLAUF_POSNR,
  H.settle_poper AS settle_poper,
  H.saprl AS saprl,
  H.MLAUF_CPUDT AS MLAUF_CPUDT,
  H.MLAUF_CPUTM AS MLAUF_CPUTM,
  H.xwoff AS xwoff,
  H.werks AS werks,
  H.MLAUF_STORNO AS MLAUF_STORNO,
  H.meins AS meins,
  H.bstmg AS bstmg,
  H.bstme AS bstme,
  H.MLAUFCR_WAERS AS MLAUFCR_WAERS,
  H.shkzg AS shkzg,
  H.wrbtr AS wrbtr,
  H.arewr AS arewr,
  H.reewr AS reewr,
  K.storno AS storno,
  K.cpudt AS cpudt,
  K.cputm AS cputm,
  K.waers AS waers,
  K.kst001 AS kst001,
  K.kst002 AS kst002,
  K.kst003 AS kst003,
  K.kst004 AS kst004,
  K.kst005 AS kst005,
  K.kst006 AS kst006,
  K.kst007 AS kst007,
  K.kst008 AS kst008,
  K.kst009 AS kst009,
  K.kst010 AS kst010,
  K.kst011 AS kst011,
  K.kst012 AS kst012,
  K.kst013 AS kst013,
  K.kst014 AS kst014,
  K.kst015 AS kst015,
  K.kst016 AS kst016,
  K.kst017 AS kst017,
  K.kst018 AS kst018,
  K.kst019 AS kst019,
  K.kst020 AS kst020,
  K.kst021 AS kst021,
  K.kst022 AS kst022,
  K.kst023 AS kst023,
  K.kst024 AS kst024,
  K.kst025 AS kst025,
  K.kst026 AS kst026,
  K.kst027 AS kst027,
  K.kst028 AS kst028,
  K.kst029 AS kst029,
  K.kst030 AS kst030,
  K.kst031 AS kst031,
  K.kst032 AS kst032,
  K.kst033 AS kst033,
  K.kst034 AS kst034,
  K.kst035 AS kst035,
  K.kst036 AS kst036,
  K.kst037 AS kst037,
  K.kst038 AS kst038,
  K.kst039 AS kst039,
  K.kst040 AS kst040
FROM FMLV_MLAUFKEPH_UCT_UNION AS K
INNER JOIN FMLV_PRDH_UCT AS H ON /* join condition not captured in parsed metadata */
;