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_CustomizingRequests.
-- 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_REQUEST
CREATE VIEW I_CustomizingRequests AS
SELECT
I_RecordedContentRequests.TransportRequestID AS TransportRequestID,
I_RecordedContentRequests.TransportRequestSourceClient AS TransportRequestSourceClient,
I_RecordedContentRequests.TransportRequestType AS TransportRequestType,
I_RecordedContentRequests.TransportRequestTarget AS TransportRequestTarget,
I_RecordedContentRequests.TransportRequestCategory AS TransportRequestCategory,
I_RecordedContentRequests.TransportRequestOwner AS TransportRequestOwner,
case when _User.UserDescription is null then I_RecordedContentRequests.TransportRequestOwner when _User.UserDescription = '' then I_RecordedContentRequests.TransportRequestOwner else _User.UserDescription end as UserDescription AS UserDescriptionendasUserDescription,
I_RecordedContentRequests.TransportRequestChangedOn AS TransportRequestChangedOn,
I_RecordedContentRequests.TransportRequestChangedAt AS TransportRequestChangedAt,
I_RecordedContentRequests.TransportRequestDesc AS TransportRequestDesc,
I_RecordedContentRequests.TransportRequestStatus AS TransportRequestStatusOld,
_RequestStatusNew.TransportRequestStatus AS TransportRequestStatus,
cast( _RequestStatusNew.LogHandle as abap.char(22) ) AS LogHandle,
cast( _RequestStatusNew.EnableShowLogs as boolean ) AS EnableLogs,
_RequestTypeText.TransportRequestTypeText AS TransportRequestTypeText,
_RequestStatusNew._RequestStatusText.TransportRequestStatusText AS TransportRequestStatusText,
_RequestsProject.ProjectID AS ProjectID,
_RequestsProject.ProjectDescription AS ProjectDescription,
cast( _HideFields.IsFieldHidden as boolean) AS IsFieldHidden,
cast( _HideFields.IsSoftwareComponentHidden as boolean ) AS IsSoftwareComponentHidden,
I_RequestsAttributes.TransportRequestAttributeValue AS TransportRequestAttributeValue,
_RequestCategory.TransportRequestCategoryText AS TransportRequestCategoryText,
_atocategory.description AS ATOTransportType,
_atocategory.code AS ATOTransportTypeCode,
cast('' as trkorr) AS CreateTransportRequestCopy,
CBCStagingCheck.TransportRequestAttributeValue AS CBCStagingID,
cast ( SoftwareComponent.TransportRequestAttributeValue as abap.char( 18 ) ) AS SoftwareComponent
INNER JOIN tadir AS ObjectDirectory ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_RequestsAttributes ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_RequestsAttributes AS ATORequestAttribute ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_RequestsAttributes AS ControlledBySBCL ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_RequestsAttributes AS SoftwareComponent ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_RequestsAttributes AS CBCStagingCheck ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_RequestType AS _RequestTypeText ON TransportRequestType = _RequestTypeText.TransportRequestType -- association [0..1]
LEFT OUTER JOIN I_NewRequestStaus AS _RequestStatusNew ON TransportRequestID = _RequestStatusNew.TransportRequestID -- association [0..1]
LEFT OUTER JOIN I_User AS _User ON TransportRequestOwner = _User.UserID -- association [0..1]
LEFT OUTER JOIN I_RequestsProject AS _RequestsProject ON TransportRequestID = _RequestsProject.TransportRequestID -- association [0..1]
LEFT OUTER JOIN I_CTOHideFields AS _HideFields ON _HideFields.BCToolsFeatureID = 'BCFG_TRANSPORT_API' -- association [0..1]
LEFT OUTER JOIN I_TransportCategory AS _RequestCategory ON TransportRequestAttributeValue = _RequestCategory.DomainValue -- association [0..1]
LEFT OUTER JOIN ATOV_CMN_TRANSPORT_TYPE_DESCR AS _atocategory ON ATORequestAttribute.TransportRequestAttributeValue = _atocategory.code -- association [0..1]
LEFT OUTER JOIN I_CustomizingTasks AS _Tasks ON /* condition not available in parsed metadata */ -- association [0..*]
LEFT OUTER JOIN I_CustomizingRequestObjects AS _Objects ON /* condition not available in parsed metadata */ -- association [0..*]
LEFT OUTER JOIN I_CustomizingRequestAttributes AS _Attributes ON /* condition not available in parsed metadata */ -- association [0..*]
LEFT OUTER JOIN I_CustomizingRequestDocu AS _Documentation ON /* condition not available in parsed metadata */ -- association [0..*]
;