I_RequestsAttributes

DDL: I_REQUESTSATTRIBUTES SQL: IREQ_ATTRIBUTE Type: view

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.

1 data source(s) 5 fields

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
KEY TransportRequestAttribLineItem pos
TransportRequestAttribute attribute
TransportRequestAttributeText _Attributes TransportRequestAttributeText
TransportRequestAttributeValue reference 
@AbapCatalog.sqlViewName: 'IREQ_ATTRIBUTE'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Attributes'
define view I_RequestsAttributes
  as select from e070a
  association [0..1] to I_CTSAttributes as _Attributes on $projection.TransportRequestAttribute = _Attributes.TransportRequestAttribute
{
      //e070a

  key trkorr    as TransportRequestID,
  key pos       as TransportRequestAttribLineItem,
      attribute as TransportRequestAttribute,
      _Attributes.TransportRequestAttributeText,
      reference as TransportRequestAttributeValue
}

Learn More