I_NumberRangeObject_TP

DDL: I_NUMBERRANGEOBJECT_TP SQL: INROBJECT_TP Type: view
13 Fields 1 Data Sources 4 Associations

Nummernkreis Intervallplege

I_NumberRangeObject_TP is a CDS View that provides data about "Nummernkreis Intervallplege" in SAP S/4HANA. It reads from 1 data source (I_NumberRangeObject) and exposes 13 fields with key field Object. It has 4 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_NumberRangeObject NumberRangeObject from

Associations (4)

CardinalityTargetAliasCondition
[1..1] I_NumberRangeObject_UI _NumberRangeObject_UI $projection.Object = _NumberRangeObject_UI.Object
[0..*] I_BufferTypeText _BufferTypeText $projection.BufferType = _BufferTypeText.Value
[0..*] I_NumberRangeText2 _NumberRangeObjectText $projection.Object = _NumberRangeObjectText.NumberRangeObject
[0..*] I_NumberRangeInterval_TP _NumberRangeInterval

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName INROBJECT_TP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
AbapCatalog.dataMaintenance #RESTRICTED view
EndUserText.label Nummernkreis Intervallplege view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY Object I_NumberRangeObject NumberRangeObject TRFM Object
BufferType I_NumberRangeObject NumberRangeBuffer Buffering
NumbersInBuffer
NumberLengthDomain I_NumberRangeObject NumberRangeDomainLength Length Domain
Percentage I_NumberRangeObject NumberRangePercentage Well Contribution Percentage
HasToYear
HasPrefix
LastChangedAt I_NumberRangeObject NumberRangeChangedAt Timestamp
TransactionCode NumberRangeTransactionCode Water Hazard Cl.
_BufferTypeText _BufferTypeText
_NumberRangeObjectText _NumberRangeObjectText
_NumberRangeInterval _NumberRangeInterval
_NumberRangeObject_UI _NumberRangeObject_UI

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 I_NumberRangeObject_TP.
-- 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: INROBJECT_TP

CREATE VIEW I_NumberRangeObject_TP AS
SELECT
  NumberRangeObject.NumberRangeObject AS Object,
  NumberRangeObject.NumberRangeBuffer AS BufferType,
  cast( NumberRangeObject.NumberRangeNumbersInBuffer as abap.int4 ) AS NumbersInBuffer,
  NumberRangeObject.NumberRangeDomainLength AS NumberLengthDomain,
  NumberRangeObject.NumberRangePercentage AS Percentage,
  cast ( NumberRangeObject.NumberRangeFlagYear as abap_boolean preserving type ) AS HasToYear,
  cast ( NumberRangeObject.NumberRangeFlagCheckAscii as abap_boolean preserving type ) AS HasPrefix,
  NumberRangeObject.NumberRangeChangedAt AS LastChangedAt,
  NumberRangeTransactionCode AS TransactionCode
FROM I_NumberRangeObject AS NumberRangeObject
LEFT OUTER JOIN I_NumberRangeObject_UI AS _NumberRangeObject_UI ON Object = _NumberRangeObject_UI.Object  -- association [1..1]
LEFT OUTER JOIN I_BufferTypeText AS _BufferTypeText ON BufferType = _BufferTypeText.Value  -- association [0..*]
LEFT OUTER JOIN I_NumberRangeText2 AS _NumberRangeObjectText ON Object = _NumberRangeObjectText.NumberRangeObject  -- association [0..*]
LEFT OUTER JOIN I_NumberRangeInterval_TP AS _NumberRangeInterval ON /* condition not available in parsed metadata */  -- association [0..*]
;

Learn More