What is JV_JVTO1_ACDOCA_INT_SWITCH in SAP S/4HANA?

JV_JVTO1_ACDOCA_INT_SWITCH is a cds CDS view in SAP S/4HANA. Intermediate JVTO1-like view on ACDOCA It contains 143 fields.

Which tables does JV_JVTO1_ACDOCA_INT_SWITCH read from?

JV_JVTO1_ACDOCA_INT_SWITCH reads data from: JV_JVSO1_ACDOCA_SWITCH.

JV_JVTO1_ACDOCA_INT_SWITCH

DDL: JV_JVTO1_ACDOCA_INT_SWITCH SQL: CJVTO1_ACDINTSW Type: view

143 Fields 1 Data Sources

Intermediate JVTO1-like view on ACDOCA

JV_JVTO1_ACDOCA_INT_SWITCH is a CDS View that provides data about "Intermediate JVTO1-like view on ACDOCA" in SAP S/4HANA. It reads from 1 data source (JV_JVSO1_ACDOCA_SWITCH) and exposes 143 fields with key fields rldnr, rrcty, rvers, ryear, robjnr.

Data Sources (1)

Source	Alias	Join Type
JV_JVSO1_ACDOCA_SWITCH	JV_JVSO1_ACDOCA_SWITCH	from

Annotations (12)

Name	Value	Level
AbapCatalog.sqlViewName	CJVTO1_ACDINTSW	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	Intermediate JVTO1-like view on ACDOCA	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 (143)

Key	Field	Source Field	Description
KEY	rldnr	rldnr	Ledger (Compat.)
KEY	rrcty	rrcty	Record Type
KEY	rvers	rvers	Version: Tax rt
KEY	ryear	ryear	Ref. Year1
KEY	robjnr
KEY	cobjnr
KEY	sobjnr
KEY	rtcur	rtcur	Currency
KEY	runit	runit	Unit/Area
KEY	drcrk
KEY	rpmax
	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.
	prodper
	rhcur	rhcur	Local Currency
	rkcur	rkcur	Ledger curr.
	curt1_4a	curt1_4a
	curr1_4a	curr1_4a
	curt2_4a	curt2_4a
	curr2_4a	curr2_4a
	curt1_4c	curt1_4c
	curr1_4c	curr1_4c
	curt2_4c	curt2_4c
	curr2_4c	curr2_4c
	tslvt
	tsl01
	tsl02
	tsl03
	tsl04
	tsl05
	tsl06
	tsl07
	tsl08
	tsl09
	tsl10
	tsl11
	tsl12
	tsl13
	tsl14
	tsl15
	tsl16
	hslvt
	hsl01
	hsl02
	hsl03
	hsl04
	hsl05
	hsl06
	hsl07
	hsl08
	hsl09
	hsl10
	hsl11
	hsl12
	hsl13
	hsl14
	hsl15
	hsl16
	kslvt
	ksl01
	ksl02
	ksl03
	ksl04
	ksl05
	ksl06
	ksl07
	ksl08
	ksl09
	ksl10
	ksl11
	ksl12
	ksl13
	ksl14
	ksl15
	ksl16
	hslvt_4c
	hsl01_4c
	hsl02_4c
	hsl03_4c
	hsl04_4c
	hsl05_4c
	hsl06_4c
	hsl07_4c
	hsl08_4c
	hsl09_4c
	hsl10_4c
	hsl11_4c
	hsl12_4c
	hsl13_4c
	hsl14_4c
	hsl15_4c
	hsl16_4c
	kslvt_4c
	ksl01_4c
	ksl02_4c
	ksl03_4c
	ksl04_4c
	ksl05_4c
	ksl06_4c
	ksl07_4c
	ksl08_4c
	ksl09_4c
	ksl10_4c
	ksl11_4c
	ksl12_4c
	ksl13_4c
	ksl14_4c
	ksl15_4c
	ksl16_4c
	mslvt
	msl01
	msl02
	msl03
	msl04
	msl05
	msl06
	msl07
	msl08
	msl09
	msl10
	msl11
	msl12
	msl13
	msl14
	msl15
	msl16

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_INT_SWITCH.
-- 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: CJVTO1_ACDINTSW

CREATE VIEW JV_JVTO1_ACDOCA_INT_SWITCH AS
SELECT
  rldnr,
  rrcty,
  rvers,
  ryear,
  cast( '000000000000000000' as gobjnr_r ) AS robjnr,
  cast( '000000000000000000' as gobjnr_c ) AS cobjnr,
  cast( '000000000000000000' as gobjnr_s ) AS sobjnr,
  rtcur,
  runit,
  cast( ' ' as shkzg preserving type ) AS drcrk,
  cast( '016' as rpmax preserving type ) AS rpmax,
  rbukrs,
  rjvnam,
  regrou,
  racct,
  rbusa,
  rcntr,
  rordnr,
  rprojk,
  rprctr,
  ranln1,
  ranln2,
  ranbwa,
  rrecin,
  rpartn,
  rkokrs,
  nplnr,
  vornr,
  aufpl,
  aplzl,
  cast( substring(prodper,1,6) as jva_prod_month ) AS prodper,
  rhcur,
  rkcur,
  curt1_4a,
  curr1_4a,
  curt2_4a,
  curr2_4a,
  curt1_4c,
  curr1_4c,
  curt2_4c,
  curr2_4c,
  case when poper = '000' then sum( tsl ) end AS tslvt,
  case when poper = '001' then sum( tsl ) end AS tsl01,
  case when poper = '002' then sum( tsl ) end AS tsl02,
  case when poper = '003' then sum( tsl ) end AS tsl03,
  case when poper = '004' then sum( tsl ) end AS tsl04,
  case when poper = '005' then sum( tsl ) end AS tsl05,
  case when poper = '006' then sum( tsl ) end AS tsl06,
  case when poper = '007' then sum( tsl ) end AS tsl07,
  case when poper = '008' then sum( tsl ) end AS tsl08,
  case when poper = '009' then sum( tsl ) end AS tsl09,
  case when poper = '010' then sum( tsl ) end AS tsl10,
  case when poper = '011' then sum( tsl ) end AS tsl11,
  case when poper = '012' then sum( tsl ) end AS tsl12,
  case when poper = '013' then sum( tsl ) end AS tsl13,
  case when poper = '014' then sum( tsl ) end AS tsl14,
  case when poper = '015' then sum( tsl ) end AS tsl15,
  case when poper = '016' then sum( tsl ) end AS tsl16,
  case when poper = '000' then sum( hsl ) end AS hslvt,
  case when poper = '001' then sum( hsl ) end AS hsl01,
  case when poper = '002' then sum( hsl ) end AS hsl02,
  case when poper = '003' then sum( hsl ) end AS hsl03,
  case when poper = '004' then sum( hsl ) end AS hsl04,
  case when poper = '005' then sum( hsl ) end AS hsl05,
  case when poper = '006' then sum( hsl ) end AS hsl06,
  case when poper = '007' then sum( hsl ) end AS hsl07,
  case when poper = '008' then sum( hsl ) end AS hsl08,
  case when poper = '009' then sum( hsl ) end AS hsl09,
  case when poper = '010' then sum( hsl ) end AS hsl10,
  case when poper = '011' then sum( hsl ) end AS hsl11,
  case when poper = '012' then sum( hsl ) end AS hsl12,
  case when poper = '013' then sum( hsl ) end AS hsl13,
  case when poper = '014' then sum( hsl ) end AS hsl14,
  case when poper = '015' then sum( hsl ) end AS hsl15,
  case when poper = '016' then sum( hsl ) end AS hsl16,
  case when poper = '000' then sum( ksl ) end AS kslvt,
  case when poper = '001' then sum( ksl ) end AS ksl01,
  case when poper = '002' then sum( ksl ) end AS ksl02,
  case when poper = '003' then sum( ksl ) end AS ksl03,
  case when poper = '004' then sum( ksl ) end AS ksl04,
  case when poper = '005' then sum( ksl ) end AS ksl05,
  case when poper = '006' then sum( ksl ) end AS ksl06,
  case when poper = '007' then sum( ksl ) end AS ksl07,
  case when poper = '008' then sum( ksl ) end AS ksl08,
  case when poper = '009' then sum( ksl ) end AS ksl09,
  case when poper = '010' then sum( ksl ) end AS ksl10,
  case when poper = '011' then sum( ksl ) end AS ksl11,
  case when poper = '012' then sum( ksl ) end AS ksl12,
  case when poper = '013' then sum( ksl ) end AS ksl13,
  case when poper = '014' then sum( ksl ) end AS ksl14,
  case when poper = '015' then sum( ksl ) end AS ksl15,
  case when poper = '016' then sum( ksl ) end AS ksl16,
  case when poper = '000' then sum( hsl_4c ) end AS hslvt_4c,
  case when poper = '001' then sum( hsl_4c ) end AS hsl01_4c,
  case when poper = '002' then sum( hsl_4c ) end AS hsl02_4c,
  case when poper = '003' then sum( hsl_4c ) end AS hsl03_4c,
  case when poper = '004' then sum( hsl_4c ) end AS hsl04_4c,
  case when poper = '005' then sum( hsl_4c ) end AS hsl05_4c,
  case when poper = '006' then sum( hsl_4c ) end AS hsl06_4c,
  case when poper = '007' then sum( hsl_4c ) end AS hsl07_4c,
  case when poper = '008' then sum( hsl_4c ) end AS hsl08_4c,
  case when poper = '009' then sum( hsl_4c ) end AS hsl09_4c,
  case when poper = '010' then sum( hsl_4c ) end AS hsl10_4c,
  case when poper = '011' then sum( hsl_4c ) end AS hsl11_4c,
  case when poper = '012' then sum( hsl_4c ) end AS hsl12_4c,
  case when poper = '013' then sum( hsl_4c ) end AS hsl13_4c,
  case when poper = '014' then sum( hsl_4c ) end AS hsl14_4c,
  case when poper = '015' then sum( hsl_4c ) end AS hsl15_4c,
  case when poper = '016' then sum( hsl_4c ) end AS hsl16_4c,
  case when poper = '000' then sum( ksl_4c ) end AS kslvt_4c,
  case when poper = '001' then sum( ksl_4c ) end AS ksl01_4c,
  case when poper = '002' then sum( ksl_4c ) end AS ksl02_4c,
  case when poper = '003' then sum( ksl_4c ) end AS ksl03_4c,
  case when poper = '004' then sum( ksl_4c ) end AS ksl04_4c,
  case when poper = '005' then sum( ksl_4c ) end AS ksl05_4c,
  case when poper = '006' then sum( ksl_4c ) end AS ksl06_4c,
  case when poper = '007' then sum( ksl_4c ) end AS ksl07_4c,
  case when poper = '008' then sum( ksl_4c ) end AS ksl08_4c,
  case when poper = '009' then sum( ksl_4c ) end AS ksl09_4c,
  case when poper = '010' then sum( ksl_4c ) end AS ksl10_4c,
  case when poper = '011' then sum( ksl_4c ) end AS ksl11_4c,
  case when poper = '012' then sum( ksl_4c ) end AS ksl12_4c,
  case when poper = '013' then sum( ksl_4c ) end AS ksl13_4c,
  case when poper = '014' then sum( ksl_4c ) end AS ksl14_4c,
  case when poper = '015' then sum( ksl_4c ) end AS ksl15_4c,
  case when poper = '016' then sum( ksl_4c ) end AS ksl16_4c,
  case when poper = '000' then sum( msl ) end AS mslvt,
  case when poper = '001' then sum( msl ) end AS msl01,
  case when poper = '002' then sum( msl ) end AS msl02,
  case when poper = '003' then sum( msl ) end AS msl03,
  case when poper = '004' then sum( msl ) end AS msl04,
  case when poper = '005' then sum( msl ) end AS msl05,
  case when poper = '006' then sum( msl ) end AS msl06,
  case when poper = '007' then sum( msl ) end AS msl07,
  case when poper = '008' then sum( msl ) end AS msl08,
  case when poper = '009' then sum( msl ) end AS msl09,
  case when poper = '010' then sum( msl ) end AS msl10,
  case when poper = '011' then sum( msl ) end AS msl11,
  case when poper = '012' then sum( msl ) end AS msl12,
  case when poper = '013' then sum( msl ) end AS msl13,
  case when poper = '014' then sum( msl ) end AS msl14,
  case when poper = '015' then sum( msl ) end AS msl15,
  case when poper = '016' then sum( msl ) end AS msl16
FROM JV_JVSO1_ACDOCA_SWITCH
;

Depth:

JV_JVTO1_ACDOCA_INT_SWITCH view

JV_JVSO1_ACDOCA_SWITCH view

JV_JVTO1_ACDOCA_SWITCH view