JV_JVSO1_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_JVSO1_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: CJVSO1_ACD

CREATE VIEW JV_JVSO1_ACDOCA AS
SELECT
  acdoca.rclnt AS rclnt,
  cast( ' ' as gu_recid preserving type ) AS gl_sirid,
  cast( '4A' as rldnr preserving type ) AS rldnr,
  acdoca.rrcty AS rrcty,
  cast( '001' as rvers ) AS rvers,
  acdoca.gjahr AS ryear,
  cast( acdoca.rwcur as rtcur preserving type ) AS rtcur,
  acdoca.runit AS runit,
  acdoca.drcrk AS drcrk,
  acdoca.poper AS poper,
  cast( 'J' as docct preserving type ) AS docct,
  acdoca.belnr AS docnr,
  acdoca.docln AS docln_acd,
  acdoca.rbukrs AS rbukrs,
  cast( substring(acdoca.docln,4,3) as jv_docln ) AS docln,
  acdoca.vname AS rjvnam,
  acdoca.egrup AS regrou,
  acdoca.racct AS racct,
  acdoca.rbusa AS rbusa,
  acdoca.kokrs AS rkokrs,
  acdoca.prctr AS rprctr,
  acdoca.anln1 AS ranln1,
  acdoca.anln2 AS ranln2,
  acdoca.anbwa AS ranbwa,
  acdoca.recid AS rrecin,
  acdoca.vptnr AS rpartn,
  cast( ' ' as jv_dpom preserving type ) AS rdpom,
  cast( ' ' as jv_dbillm preserving type ) AS rdbillm,
  acdoca.wsl AS tsl,
  acdoca.hsl AS hsl,
  acdoca.msl AS msl,
  cast( acdoca.runit as aunit preserving type ) AS aunit,
  acdoca.sgtxt AS sgtxt,
  cast( ' ' as autom preserving type ) AS autom,
  acdoca.blart AS docty,
  acdoca.budat AS budat,
  acdoca.wwert AS wsdat,
  acdoca.valut AS valut,
  acdoca.usnam AS usnam,
  acdoca.bldat AS bldat,
  acdoca.btype AS bilid,
  cast( ' ' as jv_orecid preserving type ) AS orecid,
  acdoca.mwskz AS mwskz,
  acdoca.billm AS billm,
  acdoca.pom AS pom,
  cast( '000' as jv_cbperi preserving type ) AS cbperiod,
  acdoca.ebeln AS ebeln,
  acdoca.ebelp AS ebelp,
  acdoca.ktosl AS ktosl,
  cast( ' ' as jv_mm_act preserving type ) AS mmact,
  acdoca.lstar AS lstar,
  cast( ' ' as cycle preserving type ) AS cycle,
  cast( '00000000' as sdate ) AS sdate,
  cast( '0000' as sqnr preserving type ) AS seqnr,
  cast( ' ' as seqname preserving type ) AS seqname,
  cast( ' ' as jv_refcyc preserving type ) AS refcyc,
  acdoca.matnr AS matnr,
  cast( ' ' as jv_condcod preserving type ) AS condi,
  acdoca.awtyp AS awtyp,
  acdoca.aworg AS aworg,
  cast( acdoca.awsys as logsys preserving type ) AS logsys,
  cast( acdoca.prec_awtyp as awtyp preserving type ) AS refawtyp,
  cast( acdoca.prec_awref as awref preserving type ) AS refawref,
  cast( acdoca.prec_aworg as aworg preserving type ) AS refaworg,
  cast( acdoca.prec_awsys as logsys preserving type ) AS reflogsys,
  acdoca.prodper AS prodper,
  acdoca.kunnr AS cbcustomer,
  acdoca.lifnr AS cbvendor,
  cast( ' ' as dzterm preserving type ) AS cbpayterm,
  cast( ' ' as jv_xsbline preserving type ) AS xsbl,
  cast( '00000' as jv_sbrefln preserving type ) AS sbrefln,
  acdoca.rldnr AS rldnr_gl,
  acdoca.ryear AS ryear_gl,
  acdoca.belnr AS belnr_gl,
  acdoca.buzei AS buzei,
  acdoca.mig_source AS mig_source,
  acdoca.mig_docln AS mig_docln,
  acdoca.ps_pspid AS ps_pspid,
  acdoca.rhcur AS rhcur,
  acdoca.rhcur AS hwaer,
  acdoca.rkcur AS rkcur,
  acdoca.ksl AS ksl_acd,
  acdoca.rocur AS rocur,
  acdoca.tsl AS tsl_acd,
  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,
  finsc_ld_cmp.curtph AS curtph,
  finsc_ld_cmp.curtpk AS curtpk,
  finsc_ld_cmp.curtpo AS curtpo,
  finsc_ld_cmp.curtpv AS curtpv,
  finsc_ld_cmp.curtpb AS curtpb,
  finsc_ld_cmp.curtpc AS curtpc,
  finsc_ld_cmp.curtpd AS curtpd,
  finsc_ld_cmp.curtpe AS curtpe,
  finsc_ld_cmp.curtpf AS curtpf,
  finsc_ld_cmp.curtpg AS curtpg,
  acdoca.timestamp AS timestamp
FROM acdoca
INNER JOIN t001 ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN jvaonacdocaactiv AS act ON act.id = 'START'  -- association [0..1]
LEFT OUTER JOIN t881 AS t881_4a ON t881_4a.rldnr = '4A'  -- association [0..1]
LEFT OUTER JOIN t882 AS t882_4a ON t882_4a.rldnr = '4A' AND t882_4a.bukrs = acdoca.rbukrs  -- association [0..1]
LEFT OUTER JOIN t881 AS t881_4c ON t881_4c.rldnr = '4C'  -- association [0..1]
LEFT OUTER JOIN t882 AS t882_4c ON t882_4c.rldnr = '4C' AND t882_4c.bukrs = acdoca.rbukrs  -- association [0..1]
;