V_WB2_MKPF_MSEG_2

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_WB2_MKPF_MSEG_2.
-- 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: VWB2_MKPF_MSEG_2

CREATE VIEW V_WB2_MKPF_MSEG_2 AS
SELECT
  mseg.mblnr AS mblnr,
  mseg.mjahr AS mjahr,
  mseg.zeile AS zeile,
  mseg.zekkn AS zekkn,
  mseg.lifnr AS lifnr,
  mseg.budat_mkpf AS budat,
  ekko.waers AS waers,
  mseg.bukrs AS bukrs,
  ekko.ekorg AS ekorg,
  ekko.ekgrp AS ekgrp,
  ekko.llief AS llief,
  ekko.bsart AS bsart,
  ekko.stceg AS stceg,
  ekko.stceg_l AS stceg_l,
  ekpo.matkl AS matkl,
  ekpo.ekkol AS ekkol,
  mseg.werks AS werks,
  mseg.matnr AS matnr,
  mseg.shkzg AS shkzg,
  mseg.meins AS meins,
  mseg.bstme AS bstme,
  mseg.erfme AS erfme,
  ekpo.gewei AS gewei,
  ekpo.voleh AS voleh,
  ekpo.punei AS punei,
  ekpo.mwskz AS mwskz,
  ekpo.txjcd AS txjcd,
  ekpo.aktnr AS aktnr,
  cast( mseg.pargb as gsber preserving type ) AS gsber,
  cast( mseg.pprctr as prctr preserving type ) AS prctr,
  ekpo.txdat_from AS txdat_from,
  ekpo.satnr AS satnr,
  ekpo.mtart AS mtart,
  mseg.ps_psp_pnr AS ps_psp_pnr,
  t001w.j_1bbranch AS bupla,
  ekpo.tax_country AS tax_country,
  ekpo.ltsnr AS ltsnr,
  ekpo.knttp AS knttp,
  ekpo.kzbws AS kzbws,
  ekpo.sobkz AS sobkz
FROM nsdm_e_mseg AS mseg
INNER JOIN ekko ON /* join condition not captured in parsed metadata */
INNER JOIN ekpo ON /* join condition not captured in parsed metadata */
;