I_NUMBERRANGEOBJECT

CDS View

Nummernkreisobjekte

I_NUMBERRANGEOBJECT is a CDS View in S/4HANA. Nummernkreisobjekte. It contains 6 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
I_IMGACT view inner Ermittlung der IMG Aktivität ID
I_NumberRangeObject_Bypass_TP view from Nummernkreisobjekt
I_NumberRangeObject_TP view from Nummernkreis Intervallplege
I_NumberRangeObject_UI view from Nummernkreisobjekt

Fields (6)

KeyField CDS FieldsUsed in Views
KEY NumberRangeObject Object 4
NumberRangeBuffer BufferType 1
NumberRangeChangedAt LastChangedAt 1
NumberRangeDataElement SubObjectDataElement 1
NumberRangeDomainLength NumberLengthDomain 1
NumberRangePercentage Percentage 1
@AbapCatalog.sqlViewName: 'INROBJECT'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AbapCatalog.dataMaintenance : #RESTRICTED
@AccessControl.authorizationCheck: #PRIVILEGED_ONLY
@EndUserText.label: 'Nummernkreisobjekte'
@VDM.viewType: #BASIC

define view I_NumberRangeObject as select from tnro

  association [1..*] to I_NumberRangeInterval as _NumberRangeInterval
                     on $projection.NumberRangeObject = _NumberRangeInterval.NumberRangeObject
                     
  association [1]    to I_NumberRangeText     as _NumberRangeText
                     on $projection.NumberRangeObject = _NumberRangeText.NumberRangeObject
                     and _NumberRangeText.Language = $session.system_language
                     
  association [1] to I_IMGACT as _IMG
                     on $projection.NumberRangeObject = _IMG.Object
  //composition [0..1] of I_IMGACT as _IMGAct

  
  association [1] to I_PARAMTRANSACTION as _ParamTransaction on $projection.NumberRangeTransactionCode = _ParamTransaction.Tcode 
                                                                       
  {
    key tnro.object                   as NumberRangeObject,
        tnro.dtelsobj                 as NumberRangeDataElement,
        tnro.nrtab                    as NumberRangeGroupTable,
        tnro.nrintfld                 as NumberRangeInternalField,
        tnro.nrextfld                 as NumberRangeExternalField,
        tnro.nrfld                    as NumberRangeIntervalField,
        tnro.nrsobjfld                as NumberRangeSubObjectField,
        tnro.nrelefld                 as NumberRangeElementField,
        tnro.yearind                  as NumberRangeFlagYear,
        tnro.domlen                   as NumberRangeDomainLength,
        tnro.percentage               as NumberRangePercentage,
        tnro.code                     as NumberRangeTransactionCode,
        tnro.textind                  as NumberRangFlagElementTexts,
        tnro.nreltxttab               as NumberRangElementTextTable,
        tnro.nreltxtsob               as NumberRangeElementSubObject,
        tnro.nreltxtele               as NumberRangeElementElement,
        tnro.nreltxttxt               as NumberRangeElementText,
        tnro.nreltxtlng               as NumberRangeElementLanguage,
        tnro.buffer                   as NumberRangeBuffer,
        tnro.noivbuffer               as NumberRangeNumbersInBuffer,
        tnro.nonrswap                 as NumberRangeFlagNoRolling,
        tnro.rfcdest                  as NumberRangeDestination,
        tnro.nrcheckascii             as NumberRangeFlagCheckAscii,
        tnro.status                   as NumberRangeStatus,
        tnro.changed_at               as NumberRangeChangedAt,
        tnro.changed_by               as NumberRangeChangedBy,
        tnro.abap_language_version    as NumberRangeABAPLanguageVersion,
   
    _NumberRangeInterval,
    _NumberRangeText,
    _IMG,
    _ParamTransaction
    
  } where object is not initial;