I_CASrvcDisconnectionReqEnhcd

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_CASrvcDisconnectionReqEnhcd.
-- 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.

CREATE VIEW I_CASrvcDisconnectionReqEnhcd AS
SELECT
  Request.CAServiceDisconnectionRequest AS CAServiceDisconnectionRequest,
  Request.CASrvcDisconncnReqIsInvalid AS CASrvcDisconncnReqIsInvalid,
  Request.CASrvcDisconncnReqIsObsolete AS CASrvcDisconncnReqIsObsolete,
  Request.CASrvcDisconncnReqStatus AS CASrvcDisconncnReqStatus,
  Request.CAMassRunDate AS CAMassRunDate,
  Request.CAMassRunID AS CAMassRunID,
  Request.BusinessPartner AS BusinessPartner,
  Request.ContractAccount AS ContractAccount,
  Request.CAContract AS CAContract,
  Request.CASubApplication AS CASubApplication,
  Request.CompanyCode AS CompanyCode,
  Request.Division AS Division,
  Request.CADunningAmount AS CADunningAmount,
  Request.TransactionCurrency AS TransactionCurrency,
  Request.CreatedByUser AS CreatedByUser,
  Request.CreationDate AS CreationDate,
  Request.CreationTime AS CreationTime,
  _CASrvcDisconnectionReqLog.RequestSendDate AS RequestSendDate,
  _CASrvcDisconnectionReqLog.RequestSendTime AS RequestSendTime,
  Request._BusinessPartner AS _BusinessPartner,
  Request._CAProviderContract AS _CAProviderContract,
  Request._CASrvcDisconncnReqStatus AS _CASrvcDisconncnReqStatus,
  Request._CASubApplication AS _CASubApplication,
  Request._CompanyCode AS _CompanyCode,
  Request._ContractAccount AS _ContractAccount,
  Request._ContractAccountPartner AS _ContractAccountPartner,
  Request._Division AS _Division,
  Request._TransactionCurrency AS _TransactionCurrency
FROM I_CASrvcDisconnectionRequest AS Request
INNER JOIN P_CASrvcDisconnectionReqUnq AS Unique ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_CASrvcDisconncnReqSendSts AS _CASrvcDisconncnReqSendSts ON CASrvcDisconncnReqSendStatus = _CASrvcDisconncnReqSendSts.CASrvcDisconncnReqSendStatus  -- association [1..1]
LEFT OUTER JOIN I_CASrvcDisconnectionReqLog AS _CASrvcDisconnectionReqLog ON CAServiceDisconnectionRequest = _CASrvcDisconnectionReqLog.CAServiceDisconnectionRequest AND CASrvcDisconncnReqIsInvalid = _CASrvcDisconnectionReqLog.CASrvcDisconncnReqIsInvalid  -- association [0..1]
;