JV_ACDOCA_JVSO2

DDL: JV_ACDOCA_JVSO2 SQL: CACDOCA_JVSO2 Type: view Package: GJVA_MIG
51 Fields 1 Data Sources

ACDOCA-like view on JVSO2

JV_ACDOCA_JVSO2 is a CDS View that provides data about "ACDOCA-like view on JVSO2" in SAP S/4HANA. It reads from 1 data source (JV_JVSO2_COMB) and exposes 51 fields with key fields rclnt, rbukrs, gjahr, belnr, docln. Part of development package GJVA_MIG.

Data Sources (1)

SourceAliasJoin Type
JV_JVSO2_COMB jvso2 from

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName CACDOCA_JVSO2 view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AbapCatalog.dataMaintenance #DISPLAY_ONLY view
AccessControl.personalData.blocking #NOT_REQUIRED view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label ACDOCA-like view on JVSO2 view
ObjectModel.supportedCapabilities #SQL_DATA_SOURCE view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.serviceQuality #X view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (51)

KeyFieldSource TableSource FieldDescription
KEY rclnt JV_JVSO2_COMB rclnt Client
KEY rbukrs JV_JVSO2_COMB rbukrs Company Code
KEY gjahr JV_JVSO2_COMB ryear Ref. Year1
KEY belnr JV_JVSO2_COMB docnr Well doc.no.
KEY docln
buzei JV_JVSO2_COMB reffidln Item
awref JV_JVSO2_COMB refdocnr Reference
aworg JV_JVSO2_COMB aworg Refer. Org.Unit
awitem
awtyp JV_JVSO2_COMB awtyp Reference Document Type
awsys JV_JVSO2_COMB logsys Source system
ryear JV_JVSO2_COMB ryear Ref. Year1
poper JV_JVSO2_COMB poper Posting periods
budat JV_JVSO2_COMB budat Posting Date
bldat JV_JVSO2_COMB bldat Journal Entry Date
sgtxt JV_JVSO2_COMB sgtxt Text
vorgn JV_JVSO2_COMB refactiv Ref. Transactn
blart JV_JVSO2_COMB docty Document Type
vname JV_JVSO2_COMB rjvnam Joint venture
egrup JV_JVSO2_COMB regrou Equity group
btype JV_JVSO2_COMB rbilid Billing ind.
kunnr JV_JVSO2_COMB rpartn Partner
vptnr JV_JVSO2_COMB rpartn Partner
billm JV_JVSO2_COMB billm Billing Month
pom JV_JVSO2_COMB pom Proc.Oper.Month
drcrk JV_JVSO2_COMB drcrk Debit/Credit
rwcur JV_JVSO2_COMB rwcur Transaction Currency
rhcur JV_JVSO2_COMB rhcur Local Currency
rkcur JV_JVSO2_COMB rkcur Ledger curr.
rocur JV_JVSO2_COMB rocur Free Defined Crcy 1
rvcur JV_JVSO2_COMB rvcur Free Defined Crcy 4
rbcur JV_JVSO2_COMB rbcur Free Defined Crcy 3
rccur JV_JVSO2_COMB rccur Third Currency
rdcur JV_JVSO2_COMB rdcur Free Defined Crcy 5
recur JV_JVSO2_COMB recur Free Defined Crcy 6
rfcur JV_JVSO2_COMB rfcur Free Defined Crcy 7
rgcur JV_JVSO2_COMB rgcur Free Defined Crcy 8
wsl JV_JVSO2_COMB wsl OrigTrnsCrcyAmt
hsl JV_JVSO2_COMB hsl Local Crcy Amt
ksl JV_JVSO2_COMB ksl GrpCurr
osl JV_JVSO2_COMB osl Other Crcy Amnt
vsl JV_JVSO2_COMB vsl Amount in Currency 2
bsl JV_JVSO2_COMB bsl Exchange Key
csl JV_JVSO2_COMB csl Amount in Currency 4
dsl JV_JVSO2_COMB dsl Amount in Currency 5
esl JV_JVSO2_COMB esl Amount in Currency 6
fsl JV_JVSO2_COMB fsl Amount in Currency 7
gsl JV_JVSO2_COMB gsl Amount in Currency 8
usnam JV_JVSO2_COMB usnam User Name
cpudt JV_JVSO2_COMB cpudt Imported On
cputm JV_JVSO2_COMB cputm Time

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_JVSO2.
-- 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_JVSO2

CREATE VIEW JV_ACDOCA_JVSO2 AS
SELECT
  jvso2.rclnt AS rclnt,
  jvso2.rbukrs AS rbukrs,
  jvso2.ryear AS gjahr,
  jvso2.docnr AS belnr,
  cast( jvso2.docln as docln6 ) AS docln,
  jvso2.reffidln AS buzei,
  jvso2.refdocnr AS awref,
  jvso2.aworg AS aworg,
  cast( concat( '0', jvso2.refdocln ) as fins_awitem ) AS awitem,
  jvso2.awtyp AS awtyp,
  jvso2.logsys AS awsys,
  jvso2.ryear AS ryear,
  jvso2.poper AS poper,
  jvso2.budat AS budat,
  jvso2.bldat AS bldat,
  jvso2.sgtxt AS sgtxt,
  jvso2.refactiv AS vorgn,
  jvso2.docty AS blart,
  jvso2.rjvnam AS vname,
  jvso2.regrou AS egrup,
  jvso2.rbilid AS btype,
  jvso2.rpartn AS kunnr,
  jvso2.rpartn AS vptnr,
  jvso2.billm AS billm,
  jvso2.pom AS pom,
  jvso2.drcrk AS drcrk,
  jvso2.rwcur AS rwcur,
  jvso2.rhcur AS rhcur,
  jvso2.rkcur AS rkcur,
  jvso2.rocur AS rocur,
  jvso2.rvcur AS rvcur,
  jvso2.rbcur AS rbcur,
  jvso2.rccur AS rccur,
  jvso2.rdcur AS rdcur,
  jvso2.recur AS recur,
  jvso2.rfcur AS rfcur,
  jvso2.rgcur AS rgcur,
  jvso2.wsl AS wsl,
  jvso2.hsl AS hsl,
  jvso2.ksl AS ksl,
  jvso2.osl AS osl,
  jvso2.vsl AS vsl,
  jvso2.bsl AS bsl,
  jvso2.csl AS csl,
  jvso2.dsl AS dsl,
  jvso2.esl AS esl,
  jvso2.fsl AS fsl,
  jvso2.gsl AS gsl,
  jvso2.usnam AS usnam,
  jvso2.cpudt AS cpudt,
  jvso2.cputm AS cputm
FROM JV_JVSO2_COMB AS jvso2
;

Learn More