JV_ACDOCA_JVSO1

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_JVSO1.
-- 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: CACDOCA_JVSO1

CREATE VIEW JV_ACDOCA_JVSO1 AS
SELECT
  jvso1.rclnt AS rclnt,
  I_JVALedger.Ledger AS rldnr,
  jvso1.rbukrs AS rbukrs,
  jvso1.ryear AS gjahr,
  jvso1.reffidln AS buzei,
  jvso1.refdocnr AS awref,
  jvso1.aworg AS aworg,
  cast( concat( '0', jvso1.refdocln ) as fins_awitem ) AS awitem,
  jvso1.awtyp AS awtyp,
  jvso1.logsys AS awsys,
  cast( ' ' as belnr_d preserving type ) AS prec_awref,
  cast( ' ' as aworg preserving type ) AS prec_aworg,
  cast( '000000' as fins_awitem preserving type ) AS prec_awitem,
  cast( ' ' as awtyp preserving type ) AS prec_awtyp,
  cast( ' ' as logsys preserving type ) AS prec_awsys,
  cast( ' ' as belnr_d preserving type ) AS src_awref,
  cast( ' ' as aworg preserving type ) AS src_aworg,
  cast( '000000' as fins_awitem preserving type ) AS src_awitem,
  cast( ' ' as awtyp preserving type ) AS src_awtyp,
  cast( ' ' as logsys preserving type ) AS src_awsys,
  jvso1.ryear AS ryear,
  jvso1.poper AS poper,
  jvso1.budat AS budat,
  jvso1.bldat AS bldat,
  jvso1.valut AS valut,
  jvso1.sgtxt AS sgtxt,
  jvso1.refactiv AS vorgn,
  jvso1.docty AS blart,
  jvso1.racct AS racct,
  jvso1.rbusa AS rbusa,
  jvso1.rkokrs AS kokrs,
  jvso1.mwskz AS mwskz,
  jvso1.ktosl AS ktosl,
  jvso1.cbcustomer AS kunnr,
  jvso1.cbvendor AS lifnr,
  jvso1.rprctr AS prctr,
  jvso1.rcntr AS rcntr,
  jvso1.rordnr AS aufnr,
  jvso1.rprojk AS ps_psp_pnr,
  jvso1.nplnr AS nplnr,
  jvso1.aufpl AS aufpl,
  jvso1.aplzl AS aplzl,
  jvso1.vornr AS vornr,
  jvso1.ranln1 AS anln1,
  jvso1.ranln2 AS anln2,
  jvso1.ranbwa AS anbwa,
  jvso1.matnr AS matnr,
  jvso1.lstar AS lstar,
  jvso1.ebeln AS ebeln,
  jvso1.ebelp AS ebelp,
  jvso1.rjvnam AS vname,
  jvso1.regrou AS egrup,
  jvso1.rrecin AS recid,
  jvso1.bilid AS btype,
  jvso1.rpartn AS vptnr,
  cast( ' ' as jv_etype preserving type ) AS etype,
  jvso1.prodper AS prodper,
  jvso1.billm AS billm,
  jvso1.pom AS pom,
  cast( 999 as timestamp ) AS cbrunid,
  jvso1.drcrk AS drcrk,
  jvso1.rwcur AS rwcur,
  jvso1.rhcur AS rhcur,
  jvso1.rkcur AS rkcur,
  jvso1.rocur AS rocur,
  jvso1.rvcur AS rvcur,
  jvso1.rbcur AS rbcur,
  jvso1.rccur AS rccur,
  jvso1.rdcur AS rdcur,
  jvso1.recur AS recur,
  jvso1.rfcur AS rfcur,
  jvso1.rgcur AS rgcur,
  jvso1.wsl AS wsl,
  jvso1.hsl AS hsl,
  jvso1.ksl_acd AS ksl,
  jvso1.osl AS osl,
  jvso1.vsl AS vsl,
  jvso1.bsl AS bsl,
  jvso1.csl AS csl,
  jvso1.dsl AS dsl,
  jvso1.esl AS esl,
  jvso1.fsl AS fsl,
  jvso1.gsl AS gsl,
  jvso1.msl AS msl,
  jvso1.runit AS runit,
  jvso1.usnam AS usnam,
  jvso1.cpudt AS cpudt,
  jvso1.cputm AS cputm,
  jvso1.docnr AS jv_docnr
FROM JV_JVSO1_COMB AS jvso1
LEFT OUTER JOIN fco_mig_nplnr AS _ConvertNetwork ON _ConvertNetwork.nplnr = nplnr AND _ConvertNetwork.aufpl = aufpl AND _ConvertNetwork.aplzl = aplzl  -- association [0..1]
LEFT OUTER JOIN I_CostElement AS _CostElement ON _CostElement.ControllingArea = kokrs AND _CostElement.CostElement = racct  -- association [0..1]
;