JV_ACDOCA

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 JV_ACDOCA.
-- 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: CJVACDOCA

CREATE VIEW JV_ACDOCA AS
SELECT
  acdoca.rclnt AS rclnt,
  acdoca.rldnr AS rldnr,
  acdoca.rbukrs AS rbukrs,
  acdoca.gjahr AS gjahr,
  acdoca.belnr AS belnr,
  acdoca.docln AS docln,
  acdoca.buzei AS buzei,
  acdoca.co_belnr AS co_belnr,
  acdoca.co_buzei AS co_buzei,
  acdoca.vorgn AS vorgn,
  acdoca.blart AS blart,
  acdoca.ryear AS ryear,
  acdoca.poper AS poper,
  acdoca.budat AS budat,
  acdoca.valut AS valut,
  acdoca.bldat AS bldat,
  acdoca.awref AS awref,
  acdoca.aworg AS aworg,
  acdoca.awitem AS awitem,
  acdoca.awtyp AS awtyp,
  acdoca.awsys AS awsys,
  acdoca.prec_awref AS prec_awref,
  acdoca.prec_aworg AS prec_aworg,
  acdoca.prec_awitem AS prec_awitem,
  acdoca.prec_awtyp AS prec_awtyp,
  acdoca.prec_awsys AS prec_awsys,
  acdoca.src_awref AS src_awref,
  acdoca.src_aworg AS src_aworg,
  acdoca.src_awitem AS src_awitem,
  acdoca.src_awtyp AS src_awtyp,
  acdoca.src_awsys AS src_awsys,
  acdoca.racct AS racct,
  acdoca.rbusa AS rbusa,
  acdoca.kokrs AS kokrs,
  acdoca.sgtxt AS sgtxt,
  acdoca.mwskz AS mwskz,
  acdoca.ktosl AS ktosl,
  acdoca.kunnr AS kunnr,
  acdoca.lifnr AS lifnr,
  acdoca.prctr AS prctr,
  acdoca.segment AS segment,
  acdoca.anln1 AS anln1,
  acdoca.anln2 AS anln2,
  acdoca.anbwa AS anbwa,
  acdoca.mat_pspnr AS mat_pspnr,
  acdoca.matnr AS matnr,
  acdoca.lstar AS lstar,
  acdoca.ebeln AS ebeln,
  acdoca.ebelp AS ebelp,
  acdoca.vname AS vname,
  acdoca.egrup AS egrup,
  acdoca.recid AS recid,
  acdoca.btype AS btype,
  acdoca.vptnr AS vptnr,
  acdoca.etype AS etype,
  acdoca.prodper AS prodper,
  acdoca.billm AS billm,
  acdoca.pom AS pom,
  acdoca.jvactivity AS jvactivity,
  acdoca.cbrunid AS cbrunid,
  acdoca.drcrk AS drcrk,
  acdoca.rwcur AS rwcur,
  acdoca.rhcur AS rhcur,
  acdoca.rkcur AS rkcur,
  acdoca.rocur AS rocur,
  acdoca.rvcur AS rvcur,
  acdoca.rbcur AS rbcur,
  acdoca.rccur AS rccur,
  acdoca.rdcur AS rdcur,
  acdoca.recur AS recur,
  acdoca.rfcur AS rfcur,
  acdoca.rgcur AS rgcur,
  acdoca.wsl AS wsl,
  acdoca.hsl AS hsl,
  acdoca.ksl AS ksl,
  acdoca.osl AS osl,
  acdoca.vsl AS vsl,
  acdoca.bsl AS bsl,
  acdoca.csl AS csl,
  acdoca.dsl AS dsl,
  acdoca.esl AS esl,
  acdoca.fsl AS fsl,
  acdoca.gsl AS gsl,
  acdoca.msl AS msl,
  acdoca.runit AS runit,
  acdoca.usnam AS usnam,
  acdoca.timestamp AS timestamp
FROM acdoca
INNER JOIN t8jz ON /* join condition not captured in parsed metadata */
;