I_CustomizingTaskObjects

DDL: I_CUSTOMIZINGTASKOBJECTS SQL: ICUST_TASK_OBJS Type: view
18 Fields 3 Data Sources 2 Associations

Customizing Request: Task Objects

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

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_CustomizingTaskObjectTabKeys _TaskObjectTableKeys

Annotations (5)

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

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY TransportRequestID _Tasks TransportRequestID Virtual Transport
KEY TransportRequestTaskID I_RecordedObjects TransportRequestID Virtual Transport
KEY TransportRequestObjectLineItem I_RecordedObjects TransportRequestObjectLineItem Dictionary: Line item
KEY TransportRequestObjectPgmID I_RecordedObjects TransportRequestObjectPgmID Program Name
KEY TransportRequestObjectType I_RecordedObjects TransportRequestObjectType TRFM Object
KEY TransportRequestObjectName I_RecordedObjects TransportRequestObjectName Object Name
TransportRequestObjectTypeDesc _ObjectDesc TransportRequestObjectTypeDesc
TransportRequestObjectNameDesc _CustomizingObjectTexts TransportRequestObjectNameDesc
TransportRequestObjectFunc I_RecordedObjects TransportRequestObjectFunc Function
TransportRequestObjectLanguage I_RecordedObjects TransportRequestObjectLanguage Language
LanguageName t002t sptxt Name
IMGActivity I_RecordedObjects TransportRequestObjectIMGAct VAT Activity
IMGActivityDescription cus_imgact text User Group
InDisplay
_Tasks _Tasks
_Requests _Requests
_ObjectFunctionText _ObjectFunctionText
_TaskObjectTableKeys _TaskObjectTableKeys

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_CustomizingTaskObjects.
-- 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: ICUST_TASK_OBJS

CREATE VIEW I_CustomizingTaskObjects AS
SELECT
  _Tasks.TransportRequestID AS TransportRequestID,
  I_RecordedObjects.TransportRequestID AS TransportRequestTaskID,
  I_RecordedObjects.TransportRequestObjectLineItem AS TransportRequestObjectLineItem,
  I_RecordedObjects.TransportRequestObjectPgmID AS TransportRequestObjectPgmID,
  I_RecordedObjects.TransportRequestObjectType AS TransportRequestObjectType,
  I_RecordedObjects.TransportRequestObjectName AS TransportRequestObjectName,
  _ObjectDesc.TransportRequestObjectTypeDesc AS TransportRequestObjectTypeDesc,
  _CustomizingObjectTexts.TransportRequestObjectNameDesc AS TransportRequestObjectNameDesc,
  I_RecordedObjects.TransportRequestObjectFunc AS TransportRequestObjectFunc,
  I_RecordedObjects.TransportRequestObjectLanguage AS TransportRequestObjectLanguage,
  LanguageText.sptxt AS LanguageName,
  I_RecordedObjects.TransportRequestObjectIMGAct AS IMGActivity,
  IMGActivityDescription.text AS IMGActivityDescription,
  'X' AS InDisplay
FROM I_RecordedObjects
LEFT OUTER JOIN cus_imgact AS IMGActivityDescription ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN t002t AS LanguageText ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ObjectFunction AS _ObjectFunctionText ON TransportRequestObjectFunc = _ObjectFunctionText.domvalue_l  -- association [0..1]
LEFT OUTER JOIN I_CustomizingTaskObjectTabKeys AS _TaskObjectTableKeys ON /* condition not available in parsed metadata */  -- association [0..*]
;

Learn More