C_BankAccountOpeningReqDrftTP

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_BankAccountOpeningReqDrftTP.
-- 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_BankAccountOpeningReqDrftTP 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 BankAccountRequestBankCountry,
  _BankAccountReqBankCountryText.CountryName AS CountryName,
  request.BankAccountContractType AS BankAccountRequestContractType,
  _BankAccountReqContractType.BankAccountContractTypeName AS BkAcctReqContrTypeName,
  request.CompanyCode AS BankAccountRequestCompanyCode,
  _BankAccountRequestCompanyCode.CompanyCodeName AS RequestingCompanyCodeName,
  request.BankAccountCurrency AS BankAccountRequestCurrency,
  account.acc_num AS BankAccountNumber,
  account.status AS BankAccountStatus,
  account.acc_id AS BankAccountInternalID,
  account.revision AS BankAccountRevision,
  _Bank.BankName AS BankName,
  account.bukrs AS CompanyCode,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  account.waers AS BankAccountCurrency,
  request.BankAccountContractType AS BankAccountContractType,
  _BankAccountContractType.BankAccountContractTypeName AS BankAccountContractTypeName,
  account.banks AS BankCountry,
  _BankCountryText.CountryName AS BankCountryName,
  account.bankl AS Bank,
  request.BankAccountAction AS BankAccountAction,
  request.BankAccountRequestCreatedBy AS BankAccountRequestCreatedBy,
  request.BankAccountReqCreatedDateTime AS BankAccountReqCreatedDateTime,
  request.BkAcctReqLastChgdDteTme AS BkAcctReqLastChgdDteTme,
  request.BankAccountReqLastChangedBy AS BankAccountReqLastChangedBy,
  request.BankAcctReqProcessedDateTime AS BankAcctReqProcessedDateTime,
  request.BankAccountReqProcessedBy AS BankAccountReqProcessedBy,
  request.BkAcctReqLocalLastChgdDteTme AS BkAcctReqLocalLastChgdDteTme,
  _BkAcctOpngReqApprvrCnt.NumberOfPersons AS NumberOfPersons,
  cast( ' ' as xfeld preserving type ) AS BkAcctApplAttchIsChgd,
  request.IsMarkedForDeletion AS IsMarkedForDeletion
FROM I_BankAccountOpeningRequest AS request
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _BankAccountRequestCompanyCode ON BankAccountRequestCompanyCode = _BankAccountRequestCompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_BankAcctReqStatusText AS _RequestStatusText ON BankAccountChangeRequestStatus = _RequestStatusText.BankAccountChangeRequestStatus AND _RequestStatusText.Language = $session.system_language  -- 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_Bank AS _Bank ON BankCountry = _Bank.BankCountry AND Bank = _Bank.BankInternalID  -- association [0..1]
LEFT OUTER JOIN I_CountryText AS _BankAccountReqBankCountryText ON BankAccountRequestBankCountry = _BankAccountReqBankCountryText.Country AND _BankAccountReqBankCountryText.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_BankAcctContrTypeText AS _BankAccountContractType ON BankAccountContractType = _BankAccountContractType.BankAccountContractType AND _BankAccountContractType.Language = $session.system_language  -- 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 I_BkAcctOpngReqApprvrCnt AS _BkAcctOpngReqApprvrCnt ON BankAccountChangeRequest = _BkAcctOpngReqApprvrCnt.BankAccountChangeRequest  -- association [0..1]
LEFT OUTER JOIN C_BankAccountOpeningRequestLog AS _BankAccountOpeningRequestLog ON BankAccountChangeRequest = _BankAccountOpeningRequestLog.BankAccountChangeRequest  -- association [0..*]
;