JV_JVTO1_T8JTPM_COMB_4A_4C

DDL: JV_JVTO1_T8JTPM_COMB_4A_4C SQL: CJVTO1_TPMCMB4AC Type: view
35 Fields 3 Data Sources

Combined view for JVTO1 and T8JTPM

JV_JVTO1_T8JTPM_COMB_4A_4C is a CDS View that provides data about "Combined view for JVTO1 and T8JTPM" in SAP S/4HANA. It reads from 3 data sources (jvto1, t881, t882) and exposes 35 fields with key fields rclnt, rldnr, rrcty, rvers, ryear.

Data Sources (3)

SourceAliasJoin Type
jvto1 jvto1 from
t881 t881 inner
t882 t882 inner

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName CJVTO1_TPMCMB4AC 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 Combined view for JVTO1 and T8JTPM view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.serviceQuality #X view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (35)

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

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_T8JTPM_COMB_4A_4C.
-- 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_TPMCMB4AC

CREATE VIEW JV_JVTO1_T8JTPM_COMB_4A_4C AS
SELECT
  jvto1.rclnt AS rclnt,
  jvto1.rldnr AS rldnr,
  jvto1.rrcty AS rrcty,
  jvto1.rvers AS rvers,
  jvto1.ryear AS ryear,
  jvto1.robjnr AS robjnr,
  jvto1.cobjnr AS cobjnr,
  jvto1.sobjnr AS sobjnr,
  jvto1.rtcur AS rtcur,
  jvto1.runit AS runit,
  jvto1.drcrk AS drcrk,
  jvto1.rpmax AS rpmax,
  jvto1.rbukrs AS rbukrs,
  jvto1.racct AS racct,
  jvto1.rbusa AS rbusa,
  jvto1.rkokrs AS rkokrs,
  jvto1.rjvnam AS rjvnam,
  jvto1.regrou AS regrou,
  jvto1.rrecin AS rrecin,
  jvto1.rpartn AS rpartn,
  jvto1.rprctr AS rprctr,
  jvto1.rcntr AS rcntr,
  jvto1.rordnr AS rordnr,
  jvto1.rprojk AS rprojk,
  jvto1.nplnr AS nplnr,
  jvto1.vornr AS vornr,
  jvto1.aufpl AS aufpl,
  jvto1.aplzl AS aplzl,
  jvto1.ranln1 AS ranln1,
  jvto1.ranln2 AS ranln2,
  jvto1.ranbwa AS ranbwa,
  t881.curt1 AS curt1,
  t882.curr1 AS curr1,
  t881.curt2 AS curt2,
  t882.curr2 AS curr2
FROM jvto1
INNER JOIN t881 ON /* join condition not captured in parsed metadata */
INNER JOIN t882 ON /* join condition not captured in parsed metadata */
;

Learn More