FJV_MIG_JVTO1_ENH

DDL: FJV_MIG_JVTO1_ENH SQL: FJVV_JVTO1_ENH Type: view
31 Fields 2 Data Sources

View on JVTO1 with combined currencies

FJV_MIG_JVTO1_ENH is a CDS View that provides data about "View on JVTO1 with combined currencies" in SAP S/4HANA. It reads from 2 data sources (jvto1, FJV_MIG_TPM2JVT_AGGR) and exposes 31 fields with key fields rclnt, rldnr, rrcty, rvers, ryear.

Data Sources (2)

SourceAliasJoin Type
jvto1 jvto1 from
FJV_MIG_TPM2JVT_AGGR tpm left_outer

Annotations (8)

NameValueLevelField
AbapCatalog.sqlViewName FJVV_JVTO1_ENH view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #MIXED view
EndUserText.label View on JVTO1 with combined currencies view

Fields (31)

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
rjvnam jvto1 rjvnam Joint venture
regrou jvto1 regrou Equity group
racct jvto1 racct GL Account From
rbusa jvto1 rbusa Business Area
rcntr jvto1 rcntr Cost Center
rordnr jvto1 rordnr Order
rprojk jvto1 rprojk WBS Element
rprctr jvto1 rprctr Profit Center
ranln1 jvto1 ranln1 Asset
ranln2 jvto1 ranln2 Sub-number
ranbwa jvto1 ranbwa Ast Transaction Type
rrecin jvto1 rrecin Recovery Ind.
rpartn jvto1 rpartn Partner
rkokrs jvto1 rkokrs CO Area
nplnr jvto1 nplnr Network
aufpl jvto1 aufpl TaskList No.Ops
aplzl jvto1 aplzl Plan No.f.Oper.
prodper

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 FJV_MIG_JVTO1_ENH.
-- 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: FJVV_JVTO1_ENH

CREATE VIEW FJV_MIG_JVTO1_ENH 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.rjvnam AS rjvnam,
  jvto1.regrou AS regrou,
  jvto1.racct AS racct,
  jvto1.rbusa AS rbusa,
  jvto1.rcntr AS rcntr,
  jvto1.rordnr AS rordnr,
  jvto1.rprojk AS rprojk,
  jvto1.rprctr AS rprctr,
  jvto1.ranln1 AS ranln1,
  jvto1.ranln2 AS ranln2,
  jvto1.ranbwa AS ranbwa,
  jvto1.rrecin AS rrecin,
  jvto1.rpartn AS rpartn,
  jvto1.rkokrs AS rkokrs,
  jvto1.nplnr AS nplnr,
  jvto1.aufpl AS aufpl,
  jvto1.aplzl AS aplzl,
  cast(coalesce( cast( tpm.prodper as abap.numc(6) ) , '000000' ) as abap.numc(6)) AS prodper
FROM jvto1
LEFT OUTER JOIN FJV_MIG_TPM2JVT_AGGR AS tpm ON /* join condition not captured in parsed metadata */
;

Learn More