Aps_Com_Cs_D2_Inbound_C

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 Aps_Com_Cs_D2_Inbound_C.
-- 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: APS_COM_CS_I_C_2

CREATE VIEW Aps_Com_Cs_D2_Inbound_C AS
SELECT
  Document.db_key AS db_key,
  Document.parent_key AS parent_key,
  Document.CommSystInboundUserName AS CommSystInboundUserName,
  Document.SystemAuthenticationMode AS SystemAuthenticationMode,
  _AuthentificationModeText.Description AS SystemAuthenticationModeText,
  Document.CommSystInboundUserDesc AS CommSystInboundUserDesc,
  Document.OAuth2GrantType AS OAuth2GrantType,
  Document.OAuth2ClientId AS OAuth2ClientId,
  Document.OAuth2RefreshAllowed AS OAuth2RefreshAllowed,
  Document.OAuth2RefreshExpiry AS OAuth2RefreshExpiry,
  Document.OAuth2RefreshExpiryUnit AS OAuth2RefreshExpiryUnit,
  Document.CreationDateTime AS CreationDateTime,
  Document.LastChangeDateTime AS LastChangeDateTime,
  _CreatedBy.UserDescription AS CreatedByUserName,
  _ChangedBy.UserDescription AS LastChangedByUserName,
  _CommunicationUser.UserName AS UserAlias
FROM Aps_Com_Cs_D2_Inbound_Tp AS Document
LEFT OUTER JOIN Aps_Com_Cs_D2_Root_C AS _Root ON _Root.db_key = parent_key  -- association [1..1]
LEFT OUTER JOIN aps_iam_cusr_ddl AS _CommunicationUser ON _CommunicationUser.UserID = CommSystInboundUserName  -- association [0..1]
LEFT OUTER JOIN aps_user_ddl AS _ChangedBy ON _ChangedBy.UserID = Document.LastChangedByUser  -- association [0..1]
LEFT OUTER JOIN aps_user_ddl AS _CreatedBy ON _CreatedBy.UserID = Document.CreatedByUser  -- association [0..1]
LEFT OUTER JOIN I_Aps_Com_Domain_Value_Text AS _AuthentificationModeText ON _AuthentificationModeText.Name = 'APS_CS_SYS_AUTH_MC' AND _AuthentificationModeText.Code = Document.SystemAuthenticationMode  -- association [1..1]
;