What is JV_T8JTPM_CONV in SAP S/4HANA?

JV_T8JTPM_CONV is a cds CDS view in SAP S/4HANA. Conversion view for table T8JTPM It contains 101 fields.

Which tables does JV_T8JTPM_CONV read from?

JV_T8JTPM_CONV reads data from: t882, t8jtpm.

JV_T8JTPM_CONV

DDL: JV_T8JTPM_CONV SQL: T8JTPM_CONV Type: view

101 Fields 2 Data Sources

Conversion view for table T8JTPM

JV_T8JTPM_CONV is a CDS View that provides data about "Conversion view for table T8JTPM" in SAP S/4HANA. It reads from 2 data sources (t882, t8jtpm) and exposes 101 fields with key fields rrcty, rvers, ryear, robjnr, cobjnr.

Data Sources (2)

Source	Alias	Join Type
t882	t882_4a	inner
t8jtpm	t8jtpm	from

Annotations (12)

Name	Value	Level
AbapCatalog.sqlViewName	T8JTPM_CONV	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	Conversion view for table T8JTPM	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 (101)

Key	Field	Source Table	Source Field	Description
KEY	rrcty	t8jtpm	rrcty	Record Type
KEY	rvers	t8jtpm	rvers	Version: Tax rt
KEY	ryear	t8jtpm	ryear	Ref. Year1
KEY	robjnr	t8jtpm	robjnr	Object number
KEY	cobjnr	t8jtpm	cobjnr	Trans.objct no.
KEY	sobjnr	t8jtpm	sobjnr	Trans.objct no.
KEY	rtcur	t8jtpm	rtcur	Currency
KEY	runit	t8jtpm	runit	Unit/Area
KEY	drcrk	t8jtpm	drcrk	Debit/Credit
KEY	rbukrs	t8jtpm	rbukrs	Company Code
	prodper	t8jtpm	prodper	Production Month
	poper	t8jtpm	poper	Posting periods
	tslvt
	tsl01
	tsl02
	tsl03
	tsl04
	tsl05
	tsl06
	tsl07
	tsl08
	tsl09
	tsl10
	tsl11
	tsl12
	tsl13
	tsl14
	tsl15
	tsl16
	rhcur	t882	curr1	Currency 2
	hslvt
	hsl01
	hsl02
	hsl03
	hsl04
	hsl05
	hsl06
	hsl07
	hsl08
	hsl09
	hsl10
	hsl11
	hsl12
	hsl13
	hsl14
	hsl15
	hsl16
	rkcur_4a	t882	curr2	Currency 3
	kslvt_4a
	ksl01_4a
	ksl02_4a
	ksl03_4a
	ksl04_4a
	ksl05_4a
	ksl06_4a
	ksl07_4a
	ksl08_4a
	ksl09_4a
	ksl10_4a
	ksl11_4a
	ksl12_4a
	ksl13_4a
	ksl14_4a
	ksl15_4a
	ksl16_4a
	rhcur_4c	t882_4c	curr1	Currency 2
	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
	rkcur_4c	t882_4c	curr2	Currency 3
	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

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_T8JTPM_CONV.
-- 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: T8JTPM_CONV

CREATE VIEW JV_T8JTPM_CONV AS
SELECT
  t8jtpm.rrcty AS rrcty,
  t8jtpm.rvers AS rvers,
  t8jtpm.ryear AS ryear,
  t8jtpm.robjnr AS robjnr,
  t8jtpm.cobjnr AS cobjnr,
  t8jtpm.sobjnr AS sobjnr,
  t8jtpm.rtcur AS rtcur,
  t8jtpm.runit AS runit,
  t8jtpm.drcrk AS drcrk,
  t8jtpm.rbukrs AS rbukrs,
  t8jtpm.prodper AS prodper,
  t8jtpm.poper AS poper,
  case when t8jtpm.poper = '000' then t8jtpm.tsla else cast( 0 as wertv9 ) end AS tslvt,
  case when t8jtpm.poper = '001' then t8jtpm.tsla else cast( 0 as wertv9 ) end AS tsl01,
  case when t8jtpm.poper = '002' then t8jtpm.tsla else cast( 0 as wertv9 ) end AS tsl02,
  case when t8jtpm.poper = '003' then t8jtpm.tsla else cast( 0 as wertv9 ) end AS tsl03,
  case when t8jtpm.poper = '004' then t8jtpm.tsla else cast( 0 as wertv9 ) end AS tsl04,
  case when t8jtpm.poper = '005' then t8jtpm.tsla else cast( 0 as wertv9 ) end AS tsl05,
  case when t8jtpm.poper = '006' then t8jtpm.tsla else cast( 0 as wertv9 ) end AS tsl06,
  case when t8jtpm.poper = '007' then t8jtpm.tsla else cast( 0 as wertv9 ) end AS tsl07,
  case when t8jtpm.poper = '008' then t8jtpm.tsla else cast( 0 as wertv9 ) end AS tsl08,
  case when t8jtpm.poper = '009' then t8jtpm.tsla else cast( 0 as wertv9 ) end AS tsl09,
  case when t8jtpm.poper = '010' then t8jtpm.tsla else cast( 0 as wertv9 ) end AS tsl10,
  case when t8jtpm.poper = '011' then t8jtpm.tsla else cast( 0 as wertv9 ) end AS tsl11,
  case when t8jtpm.poper = '012' then t8jtpm.tsla else cast( 0 as wertv9 ) end AS tsl12,
  case when t8jtpm.poper = '013' then t8jtpm.tsla else cast( 0 as wertv9 ) end AS tsl13,
  case when t8jtpm.poper = '014' then t8jtpm.tsla else cast( 0 as wertv9 ) end AS tsl14,
  case when t8jtpm.poper = '015' then t8jtpm.tsla else cast( 0 as wertv9 ) end AS tsl15,
  case when t8jtpm.poper = '016' then t8jtpm.tsla else cast( 0 as wertv9 ) end AS tsl16,
  t882_4a.curr1 AS rhcur,
  case when t8jtpm.poper = '000' then t8jtpm.hsla else cast( 0 as wertv9 ) end AS hslvt,
  case when t8jtpm.poper = '001' then t8jtpm.hsla else cast( 0 as wertv9 ) end AS hsl01,
  case when t8jtpm.poper = '002' then t8jtpm.hsla else cast( 0 as wertv9 ) end AS hsl02,
  case when t8jtpm.poper = '003' then t8jtpm.hsla else cast( 0 as wertv9 ) end AS hsl03,
  case when t8jtpm.poper = '004' then t8jtpm.hsla else cast( 0 as wertv9 ) end AS hsl04,
  case when t8jtpm.poper = '005' then t8jtpm.hsla else cast( 0 as wertv9 ) end AS hsl05,
  case when t8jtpm.poper = '006' then t8jtpm.hsla else cast( 0 as wertv9 ) end AS hsl06,
  case when t8jtpm.poper = '007' then t8jtpm.hsla else cast( 0 as wertv9 ) end AS hsl07,
  case when t8jtpm.poper = '008' then t8jtpm.hsla else cast( 0 as wertv9 ) end AS hsl08,
  case when t8jtpm.poper = '009' then t8jtpm.hsla else cast( 0 as wertv9 ) end AS hsl09,
  case when t8jtpm.poper = '010' then t8jtpm.hsla else cast( 0 as wertv9 ) end AS hsl10,
  case when t8jtpm.poper = '011' then t8jtpm.hsla else cast( 0 as wertv9 ) end AS hsl11,
  case when t8jtpm.poper = '012' then t8jtpm.hsla else cast( 0 as wertv9 ) end AS hsl12,
  case when t8jtpm.poper = '013' then t8jtpm.hsla else cast( 0 as wertv9 ) end AS hsl13,
  case when t8jtpm.poper = '014' then t8jtpm.hsla else cast( 0 as wertv9 ) end AS hsl14,
  case when t8jtpm.poper = '015' then t8jtpm.hsla else cast( 0 as wertv9 ) end AS hsl15,
  case when t8jtpm.poper = '016' then t8jtpm.hsla else cast( 0 as wertv9 ) end AS hsl16,
  t882_4a.curr2 AS rkcur_4a,
  case when t8jtpm.poper = '000' then t8jtpm.ksla else cast( 0 as wertv9 ) end AS kslvt_4a,
  case when t8jtpm.poper = '001' then t8jtpm.ksla else cast( 0 as wertv9 ) end AS ksl01_4a,
  case when t8jtpm.poper = '002' then t8jtpm.ksla else cast( 0 as wertv9 ) end AS ksl02_4a,
  case when t8jtpm.poper = '003' then t8jtpm.ksla else cast( 0 as wertv9 ) end AS ksl03_4a,
  case when t8jtpm.poper = '004' then t8jtpm.ksla else cast( 0 as wertv9 ) end AS ksl04_4a,
  case when t8jtpm.poper = '005' then t8jtpm.ksla else cast( 0 as wertv9 ) end AS ksl05_4a,
  case when t8jtpm.poper = '006' then t8jtpm.ksla else cast( 0 as wertv9 ) end AS ksl06_4a,
  case when t8jtpm.poper = '007' then t8jtpm.ksla else cast( 0 as wertv9 ) end AS ksl07_4a,
  case when t8jtpm.poper = '008' then t8jtpm.ksla else cast( 0 as wertv9 ) end AS ksl08_4a,
  case when t8jtpm.poper = '009' then t8jtpm.ksla else cast( 0 as wertv9 ) end AS ksl09_4a,
  case when t8jtpm.poper = '010' then t8jtpm.ksla else cast( 0 as wertv9 ) end AS ksl10_4a,
  case when t8jtpm.poper = '011' then t8jtpm.ksla else cast( 0 as wertv9 ) end AS ksl11_4a,
  case when t8jtpm.poper = '012' then t8jtpm.ksla else cast( 0 as wertv9 ) end AS ksl12_4a,
  case when t8jtpm.poper = '013' then t8jtpm.ksla else cast( 0 as wertv9 ) end AS ksl13_4a,
  case when t8jtpm.poper = '014' then t8jtpm.ksla else cast( 0 as wertv9 ) end AS ksl14_4a,
  case when t8jtpm.poper = '015' then t8jtpm.ksla else cast( 0 as wertv9 ) end AS ksl15_4a,
  case when t8jtpm.poper = '016' then t8jtpm.ksla else cast( 0 as wertv9 ) end AS ksl16_4a,
  t882_4c.curr1 AS rhcur_4c,
  case when t8jtpm.poper = '000' then t8jtpm.hslc else cast( 0 as wertv9 ) end AS hslvt_4c,
  case when t8jtpm.poper = '001' then t8jtpm.hslc else cast( 0 as wertv9 ) end AS hsl01_4c,
  case when t8jtpm.poper = '002' then t8jtpm.hslc else cast( 0 as wertv9 ) end AS hsl02_4c,
  case when t8jtpm.poper = '003' then t8jtpm.hslc else cast( 0 as wertv9 ) end AS hsl03_4c,
  case when t8jtpm.poper = '004' then t8jtpm.hslc else cast( 0 as wertv9 ) end AS hsl04_4c,
  case when t8jtpm.poper = '005' then t8jtpm.hslc else cast( 0 as wertv9 ) end AS hsl05_4c,
  case when t8jtpm.poper = '006' then t8jtpm.hslc else cast( 0 as wertv9 ) end AS hsl06_4c,
  case when t8jtpm.poper = '007' then t8jtpm.hslc else cast( 0 as wertv9 ) end AS hsl07_4c,
  case when t8jtpm.poper = '008' then t8jtpm.hslc else cast( 0 as wertv9 ) end AS hsl08_4c,
  case when t8jtpm.poper = '009' then t8jtpm.hslc else cast( 0 as wertv9 ) end AS hsl09_4c,
  case when t8jtpm.poper = '010' then t8jtpm.hslc else cast( 0 as wertv9 ) end AS hsl10_4c,
  case when t8jtpm.poper = '011' then t8jtpm.hslc else cast( 0 as wertv9 ) end AS hsl11_4c,
  case when t8jtpm.poper = '012' then t8jtpm.hslc else cast( 0 as wertv9 ) end AS hsl12_4c,
  case when t8jtpm.poper = '013' then t8jtpm.hslc else cast( 0 as wertv9 ) end AS hsl13_4c,
  case when t8jtpm.poper = '014' then t8jtpm.hslc else cast( 0 as wertv9 ) end AS hsl14_4c,
  case when t8jtpm.poper = '015' then t8jtpm.hslc else cast( 0 as wertv9 ) end AS hsl15_4c,
  case when t8jtpm.poper = '016' then t8jtpm.hslc else cast( 0 as wertv9 ) end AS hsl16_4c,
  t882_4c.curr2 AS rkcur_4c,
  case when t8jtpm.poper = '000' then t8jtpm.kslc else cast( 0 as wertv9 ) end AS kslvt_4c,
  case when t8jtpm.poper = '001' then t8jtpm.kslc else cast( 0 as wertv9 ) end AS ksl01_4c,
  case when t8jtpm.poper = '002' then t8jtpm.kslc else cast( 0 as wertv9 ) end AS ksl02_4c,
  case when t8jtpm.poper = '003' then t8jtpm.kslc else cast( 0 as wertv9 ) end AS ksl03_4c,
  case when t8jtpm.poper = '004' then t8jtpm.kslc else cast( 0 as wertv9 ) end AS ksl04_4c,
  case when t8jtpm.poper = '005' then t8jtpm.kslc else cast( 0 as wertv9 ) end AS ksl05_4c,
  case when t8jtpm.poper = '006' then t8jtpm.kslc else cast( 0 as wertv9 ) end AS ksl06_4c,
  case when t8jtpm.poper = '007' then t8jtpm.kslc else cast( 0 as wertv9 ) end AS ksl07_4c,
  case when t8jtpm.poper = '008' then t8jtpm.kslc else cast( 0 as wertv9 ) end AS ksl08_4c,
  case when t8jtpm.poper = '009' then t8jtpm.kslc else cast( 0 as wertv9 ) end AS ksl09_4c,
  case when t8jtpm.poper = '010' then t8jtpm.kslc else cast( 0 as wertv9 ) end AS ksl10_4c,
  case when t8jtpm.poper = '011' then t8jtpm.kslc else cast( 0 as wertv9 ) end AS ksl11_4c,
  case when t8jtpm.poper = '012' then t8jtpm.kslc else cast( 0 as wertv9 ) end AS ksl12_4c,
  case when t8jtpm.poper = '013' then t8jtpm.kslc else cast( 0 as wertv9 ) end AS ksl13_4c,
  case when t8jtpm.poper = '014' then t8jtpm.kslc else cast( 0 as wertv9 ) end AS ksl14_4c,
  case when t8jtpm.poper = '015' then t8jtpm.kslc else cast( 0 as wertv9 ) end AS ksl15_4c,
  case when t8jtpm.poper = '016' then t8jtpm.kslc else cast( 0 as wertv9 ) end AS ksl16_4c
FROM t8jtpm
INNER JOIN t882 AS t882_4a ON /* join condition not captured in parsed metadata */
;

Depth:

JV_T8JTPM_CONV view