V_LTR2_ANA2_INV

DDL: V_LTR2_ANA2_INV Type: view_entity Package: LTR2_ANA2
13 Fields 2 Data Sources

Comprehensive Intervals View

V_LTR2_ANA2_INV is a CDS View that provides data about "Comprehensive Intervals View" in SAP S/4HANA. It reads from 2 data sources (cnv_ana2_nriv, cnv_ana2_nriv) and exposes 13 fields with key fields run_guid, object, subobject, toyear, nrrangenr. Part of development package LTR2_ANA2.

Data Sources (2)

SourceAliasJoin Type
cnv_ana2_nriv r left_outer
cnv_ana2_nriv s from

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Comprehensive Intervals View view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY run_guid cnv_ana2_nriv run_guid GUID
KEY object cnv_ana2_nriv object TRFM Object
KEY subobject cnv_ana2_nriv subobject Triggering obj.
KEY toyear cnv_ana2_nriv toyear To Year
KEY nrrangenr cnv_ana2_nriv nrrangenr Number Range
fromnumber cnv_ana2_nriv fromnumber From number
tonumber cnv_ana2_nriv tonumber To number
nrlevel cnv_ana2_nriv nrlevel Number Status
externind cnv_ana2_nriv externind External NR
fromnumber_r cnv_ana2_nriv fromnumber From number
tonumber_r cnv_ana2_nriv tonumber To number
nrlevel_r cnv_ana2_nriv nrlevel Number Status
externind_r cnv_ana2_nriv externind External NR

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 V_LTR2_ANA2_INV.
-- 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.

CREATE VIEW V_LTR2_ANA2_INV AS
SELECT
  s.run_guid AS run_guid,
  s.object AS object,
  s.subobject AS subobject,
  s.toyear AS toyear,
  s.nrrangenr AS nrrangenr,
  s.fromnumber AS fromnumber,
  s.tonumber AS tonumber,
  s.nrlevel AS nrlevel,
  s.externind AS externind,
  r.fromnumber AS fromnumber_r,
  r.tonumber AS tonumber_r,
  r.nrlevel AS nrlevel_r,
  r.externind AS externind_r
FROM cnv_ana2_nriv AS s
LEFT OUTER JOIN cnv_ana2_nriv AS r ON /* join condition not captured in parsed metadata */
;

Learn More