C_BkRelshpDocAccountTP

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_BkRelshpDocAccountTP.
-- 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_BkRelshpDocAccountTP AS
SELECT
  BkRltnDocBankAccountUUID,
  BankRelationshipDocumentUUID,
  BankAccountInternalID,
  BkRltnDocBkAcctAssgmtDateTime,
  BkRltnDocBkAcctRemovalDateTime,
  _BankAccountBasicData.Bank AS Bank,
  _BankAccountBasicData.BankName AS BankName,
  _BankAccountBasicData.BankAccountNumber AS BankAccountNumber,
  cast (_BankAccountBasicData.BankCountry as banks preserving type) AS BankCountry,
  _BankAccountBasicData._BankCountry._Text.CountryName as BankCountryName : localized AS CountryNameasBankCountryNamelocalized,
  _BankAccountBasicData.BankAccountCurrency AS BankAccountCurrency,
  _BankAccountBasicData.BankControlKey AS BankControlKey,
  _BankAccountBasicData.BankAccountContractType AS BankAccountContractType,
  _BankAccountBasicData.BankAccountStatus AS BankAccountStatus,
  _BankAccountBasicData._BankAccountStatus.BankAccountStatusName AS BankAccountStatusName,
  _BankAccountBasicData.BankAccountType AS BankAccountType,
  _BankAccountBasicData.CompanyCode AS CompanyCode,
  _BankAccountBasicData._CompanyCode.CompanyCodeName AS CompanyCodeName,
  _BankAccountBasicData.CompanyCodeCountry AS CompanyCodeCountry,
  _BankAccountBasicData.BankAccountDescription AS BankAccountDescription,
  _BankAccountBasicData.BankGroup AS BankGroup,
  _BankAccountBasicData.BusinessPartnerName AS BusinessPartnerName,
  _BankAccountBasicData.HouseBank AS HouseBank,
  _BankAccountBasicData.HouseBankAccount AS HouseBankAccount,
  CreatedByUser,
  CreationDateTime,
  LastChangedByUser,
  LocalLastChangeDateTime
FROM R_BkRelshpDocAccountTP
;