I_BankAccHouseBankAccTP

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 I_BankAccHouseBankAccTP.
-- 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 I_BankAccHouseBankAccTP AS
SELECT
  acc_id AS BankAccountInternalID,
  guid AS HouseBankAcctUUID,
  revision AS BankAccountRevision,
  valid_from AS HouseBankAccStartDate,
  valid_to AS HouseBankAccEndDate,
  herku AS RemoteSystem,
  bukrs AS CompanyCode,
  hbkid AS HouseBank,
  hktid AS HouseBankAccount,
  RemoteAccount,
  bankn AS BankAccount,
  bkont AS BankControlKey,
  refzl AS ReferenceInfo,
  dtaai AS DataMedExchangeIdentification,
  bnkn2 AS BankAccountAlternative,
  is_reused AS IsReused,
  fdgrp AS CashPlanningGroup,
  abwae AS SettlementAmountCurrency,
  hkont AS GLAccount,
  wekon AS BillDiscountAccount,
  mindt AS MinimumDays,
  hbid1 AS HouseBankAlternative1,
  hkid1 AS HouseBankAccAlternative1,
  hbid2 AS HouseBankAlternative2,
  hkid2 AS HouseBankAccAlternative2,
  wkkon AS ReturnedBillOfExchangePayable,
  wikon AS AccForBillOfExchangeCollection,
  new_bacl_flag AS GLAcctIsBankReconciliationAcct,
  old_hkont AS OldGLAccount,
  target_hkont AS TargetGLAccount,
  migration_status AS MigrationStatus,
  cash_pooling_flag AS CashPoolingIsUsed,
  bank_account_auth_group AS AuthorizationGroup,
  netting_group AS NettingGroup,
  togru AS GLAccountToleranceGroup,
  xspeb AS AccountIsBlockedForPosting,
  posting_block_date AS PostingBlockDate,
  _HouseBank.DefaultPartnerValidToDate AS DefaultPartnerValidToDate,
  _HouseBank.DefaultPartnerValidFromDate AS DefaultPartnerValidFromDate,
  _HouseBank.DefaultPartnerNo AS DefaultPartnerNo,
  _HouseBank.RiskPartnerValidToDate AS RiskPartnerValidToDate,
  _HouseBank.RiskPartnerValidFromDate AS RiskPartnerValidFromDate,
  _HouseBank.RiskPartnerNo AS RiskPartnerNo,
  _HouseBank.BankCountry AS BankCountry,
  _HouseBank.BankInternalID AS BankInternalID,
  _HouseBank._Bank.SWIFTCode AS SWIFTCode,
  _HouseBank._Bank.BankNetworkGrouping AS BankGroup,
  _HouseBank._Bank.Bank AS Bank,
  _HouseBank._Bank.IsPostBankAccount AS IsPostBankAccount,
  _HouseBank._Bank.BankName AS BankName,
  _HouseBank._Bank.Region AS Region,
  _HouseBank._Bank.StreetName AS StreetName,
  _HouseBank._Bank.CityName AS CityName,
  _HouseBank._Bank.Branch AS Branch,
  _HouseBank.EDIPartner AS EDIPartner,
  _HouseBank.EDISignatureType AS EDISignatureType,
  _HouseBank.DataMediumExchangeBank AS DataMediumExchangeBank,
  _HouseBank.DataMediumReceivingBank AS DataMediumReceivingBank,
  _HouseBank.CustomerByHouseBank AS CustomerByHouseBank,
  _HouseBank.OrderingCompanyByBank AS OrderingCompanyByBank,
  _HouseBank.ChargeAccountBank AS ChargeAccountBank,
  _HouseBank.ChargeAccount AS ChargeAccount,
  _HouseBank.ChargeAccountCurrencyISOCode AS ChargeAccountCurrencyISOCode,
  _HouseBank.DataExchangeInstructionKey AS DataExchangeInstructionKey,
  _HouseBank.ExecutionLeadDays AS ExecutionLeadDays,
  _HouseBank.CentralBankReportIsRequired AS CentralBankReportIsRequired,
  _HouseBank.RegionByCentralBank AS RegionByCentralBank,
  _HouseBank.PaymentIsForwardedToCentralBk AS PaymentIsForwardedToCentralBk,
  _Account.BankAccountCurrency AS BankAccountCurrency,
  _Account.BankAccount AS BankAccountNumber,
  _Account.IBAN AS IBAN,
  cast ( 'X' as boolean preserving type ) AS HouseBankAccountIsNotRemote,
  cast ( '' as fclm_bam_semantic_object ) AS HouseBankSemanticObject,
  cast ( '' as fclm_bam_semantic_object ) AS HouseBankAccountSemanticObject,
  cast ( '' as fclm_bam_semantic_object ) AS CompanyCodeSemanticObject
LEFT OUTER JOIN I_BankAccountTP AS _Account ON BankAccountInternalID = _Account.BankAccountInternalID AND BankAccountRevision = _Account.BankAccountRevision  -- association [1..1]
LEFT OUTER JOIN I_Housebank AS _HouseBank ON HouseBank = _HouseBank.HouseBank AND CompanyCode = _HouseBank.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_BankAccIDCategory AS _BankAccIDCategory ON HouseBankIDCategory = _BankAccIDCategory.HouseBankIDCategory AND _BankAccIDCategory.Language = $session.system_language  -- association [0..1]
;