JV_JVSO1_ACDOCA_CLASSIC

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_JVSO1_ACDOCA_CLASSIC.
-- 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: CJVSO1_ACD_CL

CREATE VIEW JV_JVSO1_ACDOCA_CLASSIC AS
SELECT
  acdoca.rldnr AS rldnr,
  acdoca.rrcty AS rrcty,
  acdoca.rbukrs AS rbukrs,
  acdoca.gjahr AS gjahr,
  acdoca.belnr AS docnr,
  acdoca.docln AS docln,
  acdoca.ryear AS ryear,
  acdoca.poper AS poper,
  'J' AS docct,
  acdoca.blart AS docty,
  acdoca.budat AS budat,
  acdoca.bldat AS bldat,
  acdoca.valut AS valut,
  acdoca.wwert AS wsdat,
  case when acdoca.co_belnr is initial then 'W' else 'K' end as refdocct AS co_belnrisinitialthenWelseKendasrefdocct,
  acdoca.gjahr AS refryear,
  acdoca.awtyp AS awtyp,
  acdoca.aworg AS aworg,
  acdoca.awsys AS logsys,
  acdoca.belnr AS reffidoc,
  acdoca.buzei AS reffidln,
  acdoca.prec_awtyp AS refawtyp,
  acdoca.prec_awref AS refawref,
  acdoca.prec_aworg AS refaworg,
  acdoca.prec_awsys AS reflogsys,
  acdoca.sgtxt AS sgtxt,
  acdoca.usnam AS usnam,
  tstmp_to_dats( acdoca.timestamp, abap_system_timezone( $session.client, 'NULL' ), $session.client, 'NULL' ) as cpudt AS clientNULLascpudt,
  tstmp_to_tims( acdoca.timestamp, abap_system_timezone( $session.client, 'NULL' ), $session.client, 'NULL' ) as cputm AS clientNULLascputm,
  acdoca.racct AS racct,
  acdoca.rbusa AS rbusa,
  acdoca.kokrs AS rkokrs,
  acdoca.vname AS rjvnam,
  acdoca.egrup AS regrou,
  acdoca.recid AS rrecin,
  acdoca.btype AS bilid,
  acdoca.vptnr AS rpartn,
  acdoca.prodper AS prodper,
  acdoca.billm AS billm,
  acdoca.pom AS pom,
  acdoca.prctr AS rprctr,
  acdoca.anln1 AS ranln1,
  acdoca.anln2 AS ranln2,
  acdoca.anbwa AS ranbwa,
  acdoca.drcrk AS drcrk,
  acdoca.rwcur AS rtcur,
  acdoca.wsl AS tsl,
  acdoca.rhcur AS rhcur,
  acdoca.rhcur AS hwaer,
  acdoca.hsl AS hsl,
  acdoca.rkcur AS rkcur,
  acdoca.ksl AS ksl,
  acdoca.rocur AS rocur,
  acdoca.osl AS osl,
  acdoca.rvcur AS rvcur,
  acdoca.vsl AS vsl,
  acdoca.rbcur AS rbcur,
  acdoca.bsl AS bsl,
  acdoca.rccur AS rccur,
  acdoca.csl AS csl,
  acdoca.rdcur AS rdcur,
  acdoca.dsl AS dsl,
  acdoca.recur AS recur,
  acdoca.esl AS esl,
  acdoca.rfcur AS rfcur,
  acdoca.fsl AS fsl,
  acdoca.rgcur AS rgcur,
  acdoca.gsl AS gsl,
  acdoca.matnr AS matnr,
  acdoca.msl AS msl,
  acdoca.runit AS runit,
  acdoca.mwskz AS mwskz,
  acdoca.ebeln AS ebeln,
  acdoca.ebelp AS ebelp,
  acdoca.kunnr AS cbcustomer,
  acdoca.lifnr AS cbvendor,
  acdoca.ktosl AS ktosl,
  acdoca.lstar AS lstar,
  acdoca.mig_source AS mig_source,
  acdoca.mig_docln AS mig_docln
FROM acdoca
;