C_CASrvcDisconnectionReq

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 C_CASrvcDisconnectionReq.
-- 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 C_CASrvcDisconnectionReq AS
SELECT
  CAServiceDisconnectionRequest,
  CASrvcDisconncnReqIsInvalid,
  CASrvcDisconncnReqIsObsolete,
  CASrvcDisconncnReqStatus,
  _CASrvcDisconncnReqStatus._Text[1: Language=$session.system_language].CASrvcDisconncnReqStatusText AS CASrvcDisconncnReqStatusText,
  CASrvcDisconncnReqSendStatus,
  _CASrvcDisconncnReqSendSts._Text[1: Language=$session.system_language].CASrvcDisconncnReqSendStsText AS CASrvcDisconncnReqSendStsText,
  CAMassRunDate,
  CAMassRunID,
  cast(concat( cast(CAMassRunDate as date), CAMassRunID) as abap.char(20) ) AS CAMassRunDateAndID,
  BusinessPartner,
  _BusinessPartner.BusinessPartnerFullName AS BusinessPartnerName,
  ContractAccount,
  _ContrAccText.ContractAccountName AS ContractAccountName,
  CAContract,
  _CAProviderContract.CAProviderContractName AS CAProviderContractName,
  CASubApplication,
  Division,
  CompanyCode,
  _CoCoText.CompanyCodeName AS CompanyCodeName,
  CreatedByUser,
  _CreatedByContact.FullName AS PersonFullName,
  CreationDate,
  CreationTime,
  RequestSendDate,
  RequestSendTime,
  CADunningAmount,
  TransactionCurrency,
  concat_with_space( _BPCurrentDefaultAddress._AddressDefaultRepresentation.StreetName, _BPCurrentDefaultAddress._AddressDefaultRepresentation.HouseNumber, 1 ) as AddressLine1 AS HouseNumber1asAddressLine1,
  concat_with_space( _BPCurrentDefaultAddress._AddressDefaultRepresentation.PostalCode, _BPCurrentDefaultAddress._AddressDefaultRepresentation.CityName, 1 ) as AddressLine2 AS CityName1asAddressLine2,
  _BPCurrentDefaultAddress._AddressDefaultRepresentation.Country AS AddressLine3,
  _BPCurrentDefaultAddress._AddressDefaultRepresentation._Country._Text[1: Language=$session.system_language].CountryName AS CountryName
FROM I_CASrvcDisconnectionReqEnhcd
LEFT OUTER JOIN I_BPCurrentDefaultAddress AS _BPCurrentDefaultAddress ON BusinessPartner = _BPCurrentDefaultAddress.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN C_CAInvcgUserContact AS _CreatedByContact ON CreatedByUser = _CreatedByContact.ContactCardID  -- association [0..1]
LEFT OUTER JOIN C_CASrvcDisconnectionReqItm AS _Items ON CAServiceDisconnectionRequest = _Items.CAServiceDisconnectionRequest  -- association [1..*]
LEFT OUTER JOIN C_CASrvcReconnectionReq AS _Reconnection ON CAServiceDisconnectionRequest = _Reconnection.CAServiceDisconnectionRequest  -- association [0..*]
LEFT OUTER JOIN C_CompanyCodeValueHelp AS _CoCoText ON CompanyCode = _CoCoText.CompanyCode  -- association [1..1]
LEFT OUTER JOIN C_ContractAccountValueHelp AS _ContrAccText ON ContractAccount = _ContrAccText.ContractAccount AND BusinessPartner = _ContrAccText.BusinessPartner  -- association [0..1]
;