I_CustomizingRequestDocu

DDL: I_CUSTOMIZINGREQUESTDOCU SQL: ICUST_DOCU Type: view

Customizing Request: Tasks

I_CustomizingRequestDocu is a CDS View that provides data about "Customizing Request: Tasks" in SAP S/4HANA. It reads from 2 data sources (dokhl, doktl) and exposes 5 fields with key fields TransportRequestID, DocuLines.

2 data source(s) 5 fields

Data Sources (2)

SourceAliasJoin Type
dokhl _TextHeader from
doktl _TextItem inner

Annotations (4)

NameValueLevelField
AbapCatalog.sqlViewName ICUST_DOCU view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Customizing Request: Tasks view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY TransportRequestID dokhl object
KEY DocuLines
DocuFormat doktl dokformat
DocuText doktl doktext
_Requests _Requests 
@AbapCatalog.sqlViewName: 'ICUST_DOCU'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Customizing Request: Tasks'
define view I_CustomizingRequestDocu
  as select from dokhl as _TextHeader
    inner join   doktl as _TextItem on  _TextHeader.id         = _TextItem.id
                                    and _TextHeader.object     = _TextItem.object
                                    and _TextHeader.langu      = _TextItem.langu
                                    and _TextHeader.typ        = _TextItem.typ
                                    and _TextHeader.dokversion = _TextItem.dokversion
  association to parent I_CustomizingRequests as _Requests on $projection.TransportRequestID = _Requests.TransportRequestID

{
  key _TextHeader.object                  as TransportRequestID,
  key cast( _TextItem.line as abap.int4 ) as DocuLines,
      _TextItem.dokformat                 as DocuFormat,
      _TextItem.doktext                   as DocuText,
      _Requests
}
where
      _TextHeader.id    = 'TA'
  and _TextHeader.langu = $session.system_language
  and _TextHeader.typ   = 'T'

Learn More