Fins_Trr_Acc_Ass_Obj_vbap

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 Fins_Trr_Acc_Ass_Obj_vbap.
-- 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 Fins_Trr_Acc_Ass_Obj_vbap AS
SELECT
  vbak.vbeln AS vbeln,
  vbak.kunnr AS kunnr,
  vbak.bstnk AS bstnk,
  vbak.vbtyp AS vbtyp,
  vbap.kzvbr AS kzvbr,
  vbak.vkorg AS vkorg,
  cast( vbak.bukrs_vf as bukrs ) AS bukrs,
  tka02.kokrs AS kokrs,
  vbap.posnr AS posnr,
  vbap.werks AS werks,
  vbap.prctr AS prctr,
  vbap.abgrs AS abgsl,
  vbap.pstyv AS PSTYV,
  vbap.matnr AS matnr,
  cast( case when vbap.fkrel = ' ' then ' ' else 'X' end as ps_fakkz) AS fakkz,
  cast( vbap.arktx as auftext ) AS ktext
FROM vbap
INNER JOIN vbak ON /* join condition not captured in parsed metadata */
INNER JOIN tka02 ON /* join condition not captured in parsed metadata */
;