I_CustomizingRequests

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,
  _HideFields.IsRepositoryIdHidden AS IsRepositoryIdHidden,
  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,
  I_RecordedContentRequests.RepositoryId AS RepositoryId,
  _Notes(p_client: $session.client).transportrequestnotes AS TransportRequestNotes
FROM I_RecordedContentRequests
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 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_TF_CUSTOMIZINGREQUESTNOTES AS _Notes ON _Notes.transportrequestid = I_RecordedContentRequests.TransportRequestID  -- association [0..1]
LEFT OUTER JOIN I_RequestSBCLControlled AS _ControlledBySBCL ON TransportRequestID = _ControlledBySBCL.TransportRequestID  -- 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..*]
;