R_BankAcctTwoPersonRequestWlTP

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 R_BankAcctTwoPersonRequestWlTP.
-- 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 R_BankAcctTwoPersonRequestWlTP AS
SELECT
  worklist.BankAccountChangeRequest AS BankAccountChangeRequest,
  worklist.BankAccountInternalID AS BankAccountInternalID,
  worklist.BankAccountRevision AS BankAccountRevision,
  worklist.BankAcctChangeReqHeadingText AS BankAcctChangeReqHeadingText,
  worklist.BankAccountAction AS BankAccountAction,
  worklist.CreatedByUser AS CreatedByUser,
  worklist.BankCountry AS BankCountry,
  worklist.Bank AS Bank,
  worklist.CompanyCode AS CompanyCode,
  worklist.BankAccountCurrency AS BankAccountCurrency,
  worklist.BankAccountStatus AS BankAccountStatus,
  worklist.BankAccountNumber AS BankAccountNumber,
  worklist.BankAccountDescription AS BankAccountDescription,
  BankAccountType,
  BankControlKey,
  BankAccountActivatedRevision,
  BankAccountActivatedSequence,
  cast( dats_tims_to_tstmp(worklist.CreationDate, worklist.CreationTime,abap_system_timezone($session.client,'NULL'),$session.client,'NULL') as timestamp ) AS BankAccountReqCreatedDateTime
FROM I_BankAccTwoPersonReq AS worklist
LEFT OUTER JOIN I_CountryText AS _CountryText ON BankCountry = _CountryText.Country  -- association [0..*]
LEFT OUTER JOIN I_Bank AS _Bank ON BankCountry = _Bank.BankCountry AND Bank = _Bank.BankInternalID  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _Company ON CompanyCode = _Company.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_BankAccountAction AS _BankAcctActionText ON BankAccountAction = _BankAcctActionText.BankAccountAction  -- association [0..*]
LEFT OUTER JOIN I_BankAccountStatus AS _BankAcctStatus ON BankAccountStatus = _BankAcctStatus.BankAccountStatus  -- association [0..*]
LEFT OUTER JOIN I_UserContactCard AS _ContactCard ON CreatedByUser = _ContactCard.ContactCardID  -- association [0..1]
LEFT OUTER JOIN I_BankAccountTypeText AS _AcctTypeText ON BankAccountType = _AcctTypeText.BankAccountType  -- association [0..*]
;