I_RecordedContentRequests

DDL: I_RECORDEDCONTENTREQUESTS SQL: IREC_REQUEST Type: view
11 Fields 2 Data Sources

Requests: Content Recorded Customizing and Workbench

I_RecordedContentRequests is a CDS View that provides data about "Requests: Content Recorded Customizing and Workbench" in SAP S/4HANA. It reads from 2 data sources (bctools_cust, I_RequestsAttributes) and exposes 11 fields with key field TransportRequestID.

Data Sources (2)

SourceAliasJoin Type
bctools_cust Customizing left_outer
I_RequestsAttributes RequestAttribute inner

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName IREC_REQUEST view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Requests: Content Recorded Customizing and Workbench view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY TransportRequestID RequestHeader TransportRequestID Virtual Transport
ABAPSourceSystem RequestHeader ABAPSourceSystem
TransportRequestSourceClient RequestHeader TransportRequestSourceClient
TransportRequestType RequestHeader TransportRequestType
TransportRequestStatus RequestHeader TransportRequestStatus
TransportRequestTarget RequestHeader TransportRequestTarget
TransportRequestCategory RequestHeader TransportRequestCategory
TransportRequestOwner RequestHeader TransportRequestOwner
TransportRequestChangedOn RequestHeader TransportRequestChangedOn
TransportRequestChangedAt RequestHeader TransportRequestChangedAt
TransportRequestDesc RequestHeader TransportRequestDesc

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_RecordedContentRequests.
-- 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: IREC_REQUEST

CREATE VIEW I_RecordedContentRequests AS
SELECT
  RequestHeader.TransportRequestID AS TransportRequestID,
  RequestHeader.ABAPSourceSystem AS ABAPSourceSystem,
  RequestHeader.TransportRequestSourceClient AS TransportRequestSourceClient,
  RequestHeader.TransportRequestType AS TransportRequestType,
  RequestHeader.TransportRequestStatus AS TransportRequestStatus,
  RequestHeader.TransportRequestTarget AS TransportRequestTarget,
  RequestHeader.TransportRequestCategory AS TransportRequestCategory,
  RequestHeader.TransportRequestOwner AS TransportRequestOwner,
  RequestHeader.TransportRequestChangedOn AS TransportRequestChangedOn,
  RequestHeader.TransportRequestChangedAt AS TransportRequestChangedAt,
  RequestHeader.TransportRequestDesc AS TransportRequestDesc
INNER JOIN I_RequestsAttributes AS RequestAttribute ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN bctools_cust AS Customizing ON /* join condition not captured in parsed metadata */
;

Learn More