FISVD_OPNIT_01

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 FISVD_OPNIT_01.
-- 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.

CREATE VIEW FISVD_OPNIT_01 AS
SELECT
  bseg.bukrs AS bukrs,
  bseg.gjahr AS gjahr,
  bseg.belnr AS belnr,
  bseg.buzei AS buzei,
  cast('S' as koart) AS koart,
  bseg.gsber AS gsber,
  bseg.shkzg AS shkzg,
  bseg.h_hwaer AS h_hwaer,
  bseg.dmbtr AS dmbtr,
  bseg.wrbtr AS wrbtr,
  bseg.h_hwae2 AS h_hwae2,
  bseg.h_hwae3 AS h_hwae3,
  bseg.pswsl AS pswsl,
  bseg.zuonr AS zuonr,
  bseg.kidno AS kidno,
  bseg.sgtxt AS sgtxt,
  bseg.rebzg AS rebzg,
  bseg.rebzj AS rebzj,
  bseg.rebzz AS rebzz,
  bseg.rebzt AS rebzt,
  bseg.xzahl AS xzahl,
  bseg.hkont AS hkont,
  bseg.kunnr AS kunnr,
  bseg.lifnr AS lifnr,
  bseg.netdt AS netdt,
  bseg.h_bldat AS h_bldat,
  bseg.h_budat AS h_budat,
  bseg.umsks AS umsks,
  bseg.umskz AS umskz,
  bseg.h_waers AS h_waers,
  bseg.h_blart AS h_blart,
  kna1_assoc.begru AS kna1_begru,
  knb1_assoc.begru AS knb1_begru,
  kna1_assoc.knrza AS kna1_knrza,
  knb1_assoc.knrzb AS knb1_knrzb,
  lfa1_assoc.begru AS lfa1_begru,
  lfb1_assoc.begru AS lfb1_begru,
  skb1.begru AS skb1_begru,
  bseg.hkont AS konko,
  bseg.zfbdt AS zfbdt,
  bseg.zbd1t AS zbd1t,
  bseg.zbd1p AS zbd1p,
  bseg.zbd2t AS zbd2t,
  bseg.zbd2p AS zbd2p,
  bseg.zbd3t AS zbd3t,
  bseg.wskto AS wskto,
  bseg.zlspr AS zlspr,
  bseg.zlsch AS zlsch,
  bseg.maber AS maber,
  bseg.madat AS madat,
  bseg.manst AS manst,
  bseg.mansp AS mansp,
  bseg.mschl AS mschl,
  bseg.pyamt AS pyamt,
  bseg.pycur AS pycur,
  bseg.vbeln AS vbeln,
  bseg.j_1tpbupl AS j_1tpbupl,
  cast('' as fith_desc) AS TH_BranchCodeDescription,
  ' ' AS busab,
  ' ' AS togru,
  ' ' AS adrnr,
  accdoc_header.bktxt AS h_bktxt,
  accdoc_header.xblnr AS h_xblnr,
  accdoc_header.xblnr_alt AS h_xblnr_alt,
  accdoc_header.awtyp AS h_awtyp,
  bseg.vbund AS vbund,
  bseg.buzei_sender AS buzei_sender,
  bseg.ebeln AS ebeln,
  bseg.ebelp AS ebelp,
  bseg.vbel2 AS vbel2,
  bseg.posn2 AS posn2,
  bseg.filkd AS filkd,
  bseg.xref1 AS xref1,
  bseg.xref2 AS xref2,
  bseg.xref3 AS xref3,
  bseg.vname AS vname,
  bseg.recid AS recid,
  bseg.egrup AS egrup,
  bseg.bupla AS bupla,
  bseg.hbkid AS hbkid,
  bseg.hktid AS hktid,
  bseg.rfccur AS rfccur,
  bseg.kkber AS kkber,
  bseg.btype AS btype
FROM bseg
LEFT OUTER JOIN skb1 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN kna1 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN knb1 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN lfa1 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN lfb1 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN kna1 AS kna1_assoc ON bseg.kunnr = kna1_assoc.kunnr  -- association [0..1]
LEFT OUTER JOIN knb1 AS knb1_assoc ON bseg.bukrs = knb1_assoc.bukrs AND bseg.kunnr = knb1_assoc.kunnr  -- association [0..1]
LEFT OUTER JOIN lfa1 AS lfa1_assoc ON bseg.lifnr = lfa1_assoc.lifnr  -- association [0..1]
LEFT OUTER JOIN lfb1 AS lfb1_assoc ON bseg.bukrs = lfb1_assoc.bukrs AND bseg.lifnr = lfb1_assoc.lifnr  -- association [0..1]
LEFT OUTER JOIN skb1 AS skb1_assoc ON bseg.bukrs = skb1_assoc.bukrs AND bseg.hkont = skb1_assoc.saknr  -- association [0..1]
LEFT OUTER JOIN I_TH_CustomerBranchCodeVH AS _TH_CustomerBranchCodeVH ON bseg.kunnr = _TH_CustomerBranchCodeVH.Customer AND bseg.j_1tpbupl = _TH_CustomerBranchCodeVH.BranchCode  -- association [0..1]
LEFT OUTER JOIN I_TH_SupplierBranchCodeVH AS _TH_SupplierBranchCodeVH ON bseg.lifnr = _TH_SupplierBranchCodeVH.Supplier AND bseg.j_1tpbupl = _TH_SupplierBranchCodeVH.BranchCode  -- association [0..1]
-- UNION ALL with additional select branch(es): bseg
;