JV_JVTO1_ACDOCA_CFW

DDL: JV_JVTO1_ACDOCA_CFW Type: view
44 Fields 1 Data Sources

JVTO1-like ACDOCA view for CFW amnts

JV_JVTO1_ACDOCA_CFW is a CDS View that provides data about "JVTO1-like ACDOCA view for CFW amnts" in SAP S/4HANA. It reads from 1 data source (JV_JVTO1_ACDOCA_CFW_PREP) and exposes 44 fields with key fields rldnr, rrcty, rvers, ryear, robjnr.

Data Sources (1)

SourceAliasJoin Type
JV_JVTO1_ACDOCA_CFW_PREP JV_JVTO1_ACDOCA_CFW_PREP from

Parameters (1)

NameTypeDefault
fiscal_year gjahr

Annotations (11)

NameValueLevelField
EndUserText.label JVTO1-like ACDOCA view for CFW amnts view
AbapCatalog.sqlViewName CJVTO1_ACDCFW view
AbapCatalog.buffering.status #NOT_ALLOWED view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.dataMaintenance #DISPLAY_ONLY view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
AccessControl.personalData.blocking #NOT_REQUIRED view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (44)

KeyFieldSource TableSource FieldDescription
KEY rldnr rldnr Ledger (Compat.)
KEY rrcty rrcty Record Type
KEY rvers rvers Version: Tax rt
KEY ryear ryear Ref. Year1
KEY robjnr robjnr Object number
KEY cobjnr cobjnr Trans.objct no.
KEY sobjnr sobjnr Trans.objct no.
KEY rtcur rtcur Currency
KEY runit runit Unit/Area
KEY drcrk drcrk Debit/Credit
KEY rpmax rpmax Period
rbukrs rbukrs Company Code
rjvnam rjvnam Joint venture
regrou regrou Equity group
racct racct GL Account From
rbusa rbusa Business Area
rcntr rcntr Cost Center
rordnr rordnr Order
rprojk rprojk WBS Element
rprctr rprctr Profit Center
ranln1 ranln1 Asset
ranln2 ranln2 Sub-number
ranbwa ranbwa Ast Transaction Type
rrecin rrecin Recovery Ind.
rpartn rpartn Partner
rkokrs rkokrs CO Area
nplnr nplnr Network
vornr vornr Operation
aufpl aufpl TaskList No.Ops
aplzl aplzl Plan No.f.Oper.
curt1_4a curt1_4a LC1 curr.type
curr1_4a curr1_4a Currency 2
curt2_4a curt2_4a LC2 Crcy Type
curr2_4a curr2_4a Currency 3
curt1_4c curt1_4c
curr1_4c curr1_4c
curt2_4c curt2_4c
curr2_4c curr2_4c
tslvt
hslvt
kslvt
hslvt_4c
kslvt_4c
mslvt

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_JVTO1_ACDOCA_CFW.
-- 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.
-- Parameters: fiscal_year : gjahr

CREATE VIEW JV_JVTO1_ACDOCA_CFW AS
SELECT
  rldnr,
  rrcty,
  rvers,
  ryear,
  robjnr,
  cobjnr,
  sobjnr,
  rtcur,
  runit,
  drcrk,
  rpmax,
  rbukrs,
  rjvnam,
  regrou,
  racct,
  rbusa,
  rcntr,
  rordnr,
  rprojk,
  rprctr,
  ranln1,
  ranln2,
  ranbwa,
  rrecin,
  rpartn,
  rkokrs,
  nplnr,
  vornr,
  aufpl,
  aplzl,
  curt1_4a,
  curr1_4a,
  curt2_4a,
  curr2_4a,
  curt1_4c,
  curr1_4c,
  curt2_4c,
  curr2_4c,
  sum( tslvt ) AS tslvt,
  sum( hslvt ) AS hslvt,
  sum( kslvt ) AS kslvt,
  sum( hslvt_4c ) AS hslvt_4c,
  sum( kslvt_4c ) AS kslvt_4c,
  sum( mslvt ) AS mslvt
FROM JV_JVTO1_ACDOCA_CFW_PREP
;

Learn More