I_CustomizingRequestObjects

DDL: I_CUSTOMIZINGREQUESTOBJECTS SQL: ICUST_REQ_OBJS Type: view

Customizing Request: Objects

I_CustomizingRequestObjects is a CDS View that provides data about "Customizing Request: Objects" in SAP S/4HANA. It reads from 3 data sources (I_RecordedObjects, cus_imgact, t002t) and exposes 19 fields with key fields TransportRequestID, TransportRequestObjectLineItem, TransportRequestObjectPgmID, TransportRequestObjectType, TransportRequestObjectName. It has 2 associations to related views.

3 data source(s) 19 fields

Data Sources (3)

SourceAliasJoin Type
I_RecordedObjects I_RecordedObjects from
cus_imgact ImgActivityDescription left_outer
t002t LanguageText left_outer

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_ObjectFunction _ObjectFunctionText $projection.TransportRequestObjectFunc = _ObjectFunctionText.domvalue_l
[0..*] I_CustomizingRequestObjTabKeys _RequestObjectTableKeys

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName ICUST_REQ_OBJS view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Customizing Request: Objects view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY TransportRequestID I_RecordedObjects TransportRequestID
KEY TransportRequestObjectLineItem I_RecordedObjects TransportRequestObjectLineItem
KEY TransportRequestObjectPgmID I_RecordedObjects TransportRequestObjectPgmID
KEY TransportRequestObjectType I_RecordedObjects TransportRequestObjectType
KEY TransportRequestObjectName I_RecordedObjects TransportRequestObjectName
TransportRequestObjectTypeDesc _ObjectDesc TransportRequestObjectTypeDesc
TransportRequestObjectNameDesc _CustomizingObjectTexts TransportRequestObjectNameDesc
TransportRequestObjectFunc I_RecordedObjects TransportRequestObjectFunc
TransportRequestObjectLockFlag I_RecordedObjects TransportRequestObjectLockFlag
TransportRequestObjectInfoKey I_RecordedObjects TransportRequestObjectInfoKey
TransportRequestObjectLanguage I_RecordedObjects TransportRequestObjectLanguage
LanguageName t002t sptxt
IMGActivity I_RecordedObjects TransportRequestObjectIMGAct
IMGActivityDescription cus_imgact text
InDisplay
TransportRequestStatus _Requests TransportRequestStatus
_Requests _Requests
_ObjectFunctionText _ObjectFunctionText
_RequestObjectTableKeys _RequestObjectTableKeys 
@AbapCatalog.sqlViewName: 'ICUST_REQ_OBJS'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Customizing Request: Objects'
define view I_CustomizingRequestObjects
  as select from    I_RecordedObjects
    left outer join cus_imgact as ImgActivityDescription on  I_RecordedObjects.TransportRequestObjectIMGAct = ImgActivityDescription.activity
                                                         and ImgActivityDescription.spras                   = $session.system_language
    left outer join t002t      as LanguageText           on  I_RecordedObjects.TransportRequestObjectLanguage = LanguageText.sprsl
                                                         and LanguageText.spras                               = $session.system_language
  association        to parent I_CustomizingRequests   as _Requests               on  $projection.TransportRequestID = _Requests.TransportRequestID
  association        to I_TransportObjectsDescription  as _ObjectDesc             on  $projection.TransportRequestObjectPgmID = _ObjectDesc.TransportRequestObjectPgmID
                                                                                  and $projection.TransportRequestObjectType  = _ObjectDesc.TransportRequestObjectType
  association        to I_CustomizingObjectTexts       as _CustomizingObjectTexts on  $projection.TransportRequestObjectPgmID = _CustomizingObjectTexts.TransportRequestObjectPgmID
                                                                                  and $projection.TransportRequestObjectType  = _CustomizingObjectTexts.TransportRequestObjectType
                                                                                  and $projection.TransportRequestObjectName  = _CustomizingObjectTexts.TransportRequestObjectName
  association [0..1] to I_ObjectFunction               as _ObjectFunctionText     on  $projection.TransportRequestObjectFunc = _ObjectFunctionText.domvalue_l

  composition [0..*] of I_CustomizingRequestObjTabKeys as _RequestObjectTableKeys
{
  key I_RecordedObjects.TransportRequestID,
  key I_RecordedObjects.TransportRequestObjectLineItem,
  key I_RecordedObjects.TransportRequestObjectPgmID,
  key I_RecordedObjects.TransportRequestObjectType,
  key I_RecordedObjects.TransportRequestObjectName,
      _ObjectDesc.TransportRequestObjectTypeDesc,
      _CustomizingObjectTexts.TransportRequestObjectNameDesc,
      I_RecordedObjects.TransportRequestObjectFunc,
      I_RecordedObjects.TransportRequestObjectLockFlag,
      I_RecordedObjects.TransportRequestObjectInfoKey,
      I_RecordedObjects.TransportRequestObjectLanguage,
      LanguageText.sptxt                             as LanguageName,
      I_RecordedObjects.TransportRequestObjectIMGAct as IMGActivity,
      ImgActivityDescription.text                    as IMGActivityDescription,
      'X'                                            as InDisplay,
      _Requests.TransportRequestStatus,
      _Requests,
      _ObjectFunctionText,
      _RequestObjectTableKeys
}
where
      I_RecordedObjects.TransportRequestObjectPgmID != 'CORR'
  and I_RecordedObjects.TransportRequestObjectPgmID != 'LIMU'
  and I_RecordedObjects.TransportRequestObjectType != 'RELE'
  and I_RecordedObjects.TransportRequestObjectType != 'ATOC'
  and I_RecordedObjects.TransportRequestObjectLockFlag != 'X'

Learn More