JV_JVSO2_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_JVSO2_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: CJVSO2_ACD

CREATE VIEW JV_JVSO2_ACDOCA AS
SELECT
  acdoca.rclnt AS rclnt,
  cast( ' ' as gu_recid preserving type ) AS gl_sirid,
  cast( '4B' 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.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.btype AS rbilid,
  acdoca.ps_psp_pnr AS rprojk,
  cast( ' ' as jv_dpom preserving type ) AS rdpom,
  cast( ' ' as jv_dbillm preserving type ) AS rdbillm,
  coalesce( t881_4b.curt1, finsc_ld_cmp.curtph ) AS curt1_4b,
  coalesce( t882_4b.curr1, acdoca.rhcur ) AS curr1_4b,
  coalesce( t881_4b.curt2, finsc_ld_cmp.curtpk ) AS curt2_4b,
  coalesce( t882_4b.curr2, acdoca.rkcur ) AS curr2_4b,
  acdoca.wsl AS tsl,
  acdoca.hsl AS hsl,
  acdoca.sgtxt AS sgtxt,
  cast( ' ' as autom preserving type ) AS autom,
  acdoca.blart AS docty,
  cast( ' ' as bvorg preserving type ) AS bvorg,
  acdoca.budat AS budat,
  acdoca.wwert AS wsdat,
  acdoca.usnam AS usnam,
  acdoca.bldat AS bldat,
  acdoca.billm AS billm,
  acdoca.pom AS pom,
  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.rldnr AS rldnr_gl,
  acdoca.ryear AS ryear_gl,
  acdoca.buzei AS buzei,
  acdoca.mig_source AS mig_source,
  acdoca.mig_docln AS mig_docln,
  acdoca.vptnr AS vptnr,
  acdoca.ps_pspid AS ps_pspid,
  acdoca.rhcur AS rhcur,
  acdoca.tsl AS tsl_acd,
  acdoca.rkcur AS rkcur_acd,
  acdoca.ksl AS ksl_acd,
  acdoca.rocur AS rocur_acd,
  acdoca.osl AS osl_acd,
  acdoca.rvcur AS rvcur_acd,
  acdoca.vsl AS vsl_acd,
  acdoca.rbcur AS rbcur_acd,
  acdoca.bsl AS bsl_acd,
  acdoca.rccur AS rccur_acd,
  acdoca.csl AS csl_acd,
  acdoca.rdcur AS rdcur_acd,
  acdoca.dsl AS dsl_acd,
  acdoca.recur AS recur_acd,
  acdoca.esl AS esl_acd,
  acdoca.rfcur AS rfcur_acd,
  acdoca.fsl AS fsl_acd,
  acdoca.rgcur AS rgcur_acd,
  acdoca.gsl AS gsl_acd,
  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 t881 AS t881_4b ON t881_4b.rldnr = '4B'  -- association [0..1]
LEFT OUTER JOIN t882 AS t882_4b ON t882_4b.rldnr = '4B' AND t882_4b.bukrs = acdoca.rbukrs  -- association [0..1]
LEFT OUTER JOIN t881 AS t881_4d ON t881_4d.rldnr = '4D'  -- association [0..1]
LEFT OUTER JOIN t882 AS t882_4d ON t882_4d.rldnr = '4D' AND t882_4d.bukrs = acdoca.rbukrs  -- association [0..1]
;