C_BankAccountOpeningReqWl

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_BankAccountOpeningReqWl.
-- 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_BankAccountOpeningReqWl AS
SELECT
  request.BankAccountOpeningRequestUUID AS BankAccountOpeningRequestUUID,
  request.BankAccountChangeRequest AS BankAccountChangeRequest,
  request.BankAcctChangeReqHeadingText AS BankAcctChangeReqHeadingText,
  request.BankAccountChangeRequestStatus AS BankAccountChangeRequestStatus,
  request.BankAccountRequestNote AS BankAccountRequestNote,
  request.BankCountry AS BankCountry,
  _BankCountryText.CountryName AS CountryName,
  request.BankAccountContractType AS BankAccountContractType,
  _BankAccountReqContractType.BankAccountContractTypeName AS BkAcctReqContrTypeName,
  request.CompanyCode AS CompanyCode,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  request.BankAccountCurrency AS BankAccountCurrency,
  account.status AS BankAccountStatus,
  _BankAccountStatus.BankAccountStatusName AS BankAccountStatusName,
  account.acc_num AS BankAccountNumber,
  account.acc_id AS BankAccountInternalID,
  account.revision AS BankAccountRevision,
  request.BankAccountReqCreatedDateTime AS BankAccountReqCreatedDateTime,
  request.BankAcctReqProcessedDateTime AS BankAcctReqProcessedDateTime,
  request.BankAccountRequestCreatedBy AS BankAccountRequestCreatedBy,
  _CreatedByUser.FullName AS FullName,
  request.BkAcctReqLastChgdDteTme AS BkAcctReqLastChgdDteTme,
  request.BkAcctReqLocalLastChgdDteTme AS BkAcctReqLocalLastChgdDteTme,
  request.BankAccountReqLastChangedBy AS BankAccountReqLastChangedBy,
  request.BankAccountAction AS BankAccountAction
FROM I_BankAccountOpeningRequest AS request
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_BankAcctReqStatusText AS _RequestStatusText ON BankAccountChangeRequestStatus = _RequestStatusText.BankAccountChangeRequestStatus  -- association [0..1]
LEFT OUTER JOIN I_BankAccountStatus AS _BankAccountStatus ON BankAccountStatus = _BankAccountStatus.BankAccountStatus AND _BankAccountStatus.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_CountryText AS _BankCountryText ON BankCountry = _BankCountryText.Country AND _BankCountryText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_UserContactCard AS _CreatedByUser ON BankAccountRequestCreatedBy = _CreatedByUser.ContactCardID  -- association [0..1]
LEFT OUTER JOIN I_BankAcctContrTypeText AS _BankAccountReqContractType ON BankAccountContractType = _BankAccountReqContractType.BankAccountContractType AND _BankAccountReqContractType.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN C_BankAccountOpeningRequestLog AS _BankAccountOpeningRequestLog ON BankAccountChangeRequest = _BankAccountOpeningRequestLog.BankAccountChangeRequest  -- association [0..*]
;