I_RequestsAttributes

DDL: I_REQUESTSATTRIBUTES SQL: IREQ_ATTRIBUTE Type: view
5 Fields 1 Data Sources 1 Associations

Attributes

I_RequestsAttributes is a CDS View that provides data about "Attributes" in SAP S/4HANA. It reads from 1 data source (e070a) and exposes 5 fields with key fields TransportRequestID, TransportRequestAttribLineItem. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
e070a e070a from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_CTSAttributes _Attributes $projection.TransportRequestAttribute = _Attributes.TransportRequestAttribute

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName IREQ_ATTRIBUTE view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Attributes view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY TransportRequestID trkorr Virtual Transport
KEY TransportRequestAttribLineItem pos Table position
TransportRequestAttribute attribute Type
TransportRequestAttributeText _Attributes TransportRequestAttributeText
TransportRequestAttributeValue reference Value

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_RequestsAttributes.
-- 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: IREQ_ATTRIBUTE

CREATE VIEW I_RequestsAttributes AS
SELECT
  trkorr AS TransportRequestID,
  pos AS TransportRequestAttribLineItem,
  attribute AS TransportRequestAttribute,
  _Attributes.TransportRequestAttributeText AS TransportRequestAttributeText,
  reference AS TransportRequestAttributeValue
FROM e070a
LEFT OUTER JOIN I_CTSAttributes AS _Attributes ON TransportRequestAttribute = _Attributes.TransportRequestAttribute  -- association [0..1]
;

Learn More