C_BkPOABankAccountComparison

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_BkPOABankAccountComparison.
-- 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.
-- Parameters: P_BkPowerOfAttorneyOriginUUID : fclm_poa_uuid, P_BankPowerOfAttorneyOtherUUID : fclm_poa_uuid, P_BkPOAOriginIsSuccessor : boolean

CREATE VIEW C_BkPOABankAccountComparison AS
SELECT
  BankAccountInternalID,
  _BankAccountBasicData.BankAccountNumber AS BankAccountNumber,
  _BankAccountBasicData.Bank AS Bank,
  cast (_BankAccountBasicData.BankCountry as fclm_poa_bank_country_key preserving type) AS BankCountry,
  _BankAccountBasicData._BankCountry._Text[1:Language = $session.system_language].CountryName AS BankCountryName,
  _BankAccountBasicData.BankAccountCurrency AS BankAccountCurrency,
  _BankAccountBasicData.BankControlKey AS BankControlKey,
  _BankAccountBasicData.BankAccountContractType AS BankAccountContractType,
  _BankAccountBasicData.BankAccountType AS BankAccountType,
  _BankAccountBasicData._BankAccountType[1:Language = $session.system_language].BankAccountTypeText AS BankAccountTypeText,
  _BankAccountBasicData.CompanyCode AS CompanyCode,
  _BankAccountText[1:Language = $session.system_language].BankAccountDescription AS BankAccountDescription,
  _BankAccountBasicData._CompanyCode.CompanyCodeName AS CompanyCodeName,
  BkPowerOfAttorneyOriginUUID,
  BankPowerOfAttorneyOtherUUID,
  BkPOABkAcctRemovalDateTime
FROM C_BkPOABankAccountReduction
LEFT OUTER JOIN I_BkPOAComparisonResultText AS _BkPOAComparisonResultText ON BkPOAComparisonResult = _BkPOAComparisonResultText.BkPOAComparisonResult  -- association [0..*]
;