I_BankAccountTP

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_BankAccountTP.
-- 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_BankAccountTP AS
SELECT
  Account.acc_id AS BankAccountInternalID,
  Account.revision AS BankAccountRevision,
  concat( acc_id , revision ) AS BankAccountUniqueID,
  Account.objnr AS ArchObjectNumber,
  Account.bukrs AS CompanyCode,
  Account.waers AS BankAccountCurrency,
  _AccountTextInCurrentLang.BankAccountDescription AS BankAccountDescription,
  Account.banks AS BankCountry,
  _BankCountryText.CountryName AS CountryName,
  Account.bankl AS Bank,
  _Bank.Bank AS BankNumber,
  _Bank.BankName AS BankName,
  _Bank.BankNetworkGrouping AS BankGroup,
  _Bank.BankNetworkGrouping AS BankNetworkGrouping,
  _Bank.Region AS Region,
  _Bank.Branch AS Branch,
  _Bank.BankBranch AS BankBranch,
  _Bank.CityName AS CityName,
  _Bank.ShortCityName AS ShortCityName,
  _Bank.StreetName AS StreetName,
  _Bank.ShortStreetName AS ShortStreetName,
  _Bank.AddressID AS AddressID,
  _Bank._Address.PostalCode AS PostalCode,
  _Bank._Address.POBox AS POBox,
  _Bank._Address.HouseNumber AS HouseNumber,
  _Bank.SWIFTCode AS SWIFTCode,
  _BankIntraStaRule.IntraBkStaRuleExternalID AS BankIntraStatRuleExternalID,
  Account.acc_num AS BankAccount,
  Account.acc_type_id AS BankAccountType,
  Account.valid_from AS ValidityStartDate,
  Account.valid_to AS ValidityEndDate,
  Account.iban AS IBAN,
  Account.status AS BankAccountStatus,
  _BankAccountRevision.BankAccountRevisionStatus AS BankAccountRevisionStatus,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  _CompanyCode.Country AS CompanyCodeCountry,
  _CompanyCode.Currency AS CompanyCodeCurrency,
  Account.prctr AS ProfitCenter,
  _CompanyCode.ControllingArea AS ControllingArea,
  Account.gsber AS BusinessArea,
  Account.segment AS Segment,
  Account.beneficial AS BankAccountHolderName,
  Account.bank_contact AS BankContactPerson,
  Account.rel_manager AS BankRelationshipManager,
  Account.company_contact AS CompanyContactPerson,
  Account.account_supervisor AS BankAccountSupervisor,
  Account.created_by AS CreatedByUser,
  Account.opened_by AS OpenedByUser,
  Account.changed_by AS LastChangedByUser,
  Account.reviewed_by AS ReviewedByUser,
  Account.closed_by AS ClosedByUser,
  Account.deleted_flag AS IsMarkedForDeletion,
  Account.cutoff_time_d AS DomesticCutOffTime,
  Account.cutoff_time_c AS CrossBorderCutOffTime,
  Account.planned_closing_date AS PlannedClosingDate,
  Account.created_at_dat AS CreationDate,
  Account.created_at_tim AS CreationTime,
  Account.opened_at_dat AS OpenedDate,
  Account.opened_at_tim AS OpenedTime,
  Account.changed_at_dat AS LastChangeDate,
  Account.changed_at_tim AS LastChangeTime,
  Account.closed_at_dat AS ClosedDate,
  Account.closed_at_tim AS ClosedTime,
  _SingleAccountReviewLog.BankAccountLastReviewDate AS BankAccountLastReviewDate,
  Account.control_key AS BankControlKey,
  Account.iban_valid_from AS IBANValidityStartDate,
  Account.bs_upload_time AS BankStatementCheckTime,
  Account.edbsum AS BankStatementImportMethod,
  Account.idbsum AS IntraDayBankStateImportMethod,
  Account.importing_channel AS BankStatementImportChannel,
  Account.reconcile_endofday AS EndOfDayIsReconciled,
  Account.upload_bs_flag AS IsUploadOfIntraDayStatement,
  Account.vgtyp AS PaymentTransactionTypeGroup,
  procstat_act AS ProcessingStatus,
  balstat_act AS DifferenceStatus,
  serstat_act AS SerialNumberStatus,
  reconstat_act AS ReconciliationStatus,
  exp_number AS ExpectedInterval,
  exp_rhyth AS ControlFrequency,
  calendar AS FactoryCalendar,
  sort_idx AS DisplayItem,
  amt_diff AS DifferenceAmount,
  Account.cash_pool_id AS LeadingCashPoolID,
  _LeadingCashPoolMgmt.CashPoolType AS LeadingCashPoolType,
  _LeadingCashPoolMgmt.CashPoolSrvcPrvdr AS LeadingCashPoolSrvcPrvdr,
  _LeadingCashPoolMgmt.CashPoolDesc AS LeadingCashPoolDesc,
  Account.cash_pool_id_participant AS ParticipantCashPoolID,
  Account.cash_pool_target_amt_max AS MaxTargetAmount,
  Account.cash_pool_target_amt_min AS MinTargetAmount,
  Account.cash_pool_transfer_amt_min AS MinTransferAmount,
  Account.cash_pool_transfer_amt_max AS MaxTransferAmount,
  Account.sgtxt AS Note,
  _ParticipantCashPoolMgmt.CashPoolType AS ParticipantCashPoolType,
  _ParticipantCashPoolMgmt.CashPoolSrvcPrvdr AS ParticipantCashPoolSrvcPrvdr,
  _ParticipantCashPoolMgmt.CashPoolDesc AS ParticipantCashPoolDesc,
  Account.payment_method_l AS LeadingPaymentMethod,
  Account.payment_method_p AS ParticipantPaymentMethod,
  payment_service_provider AS PaymentServiceProvider,
  Account.tolerance_group AS CashToleranceGroup,
  Account.reconcile_intraday AS IntradayIsReconciled,
  Account.reconcile_bs_endofday AS BkStmntEndOfDayIsReconciled,
  Account.ext_rule_id AS IntraBkStaRuleExternalID,
  _BankAccRequested.BankAccountChangeRequestStatus AS BankAccountChangeRequestStatus,
  Account.waers AS CashPoolCurrency,
  Account.planning_level AS PlanningLevel,
  Account.bsr_group AS BankStmntReconciliationGrp,
  cast('' as fclm_bam_bankacctworkflownote ) AS BankAcctWorkflowNote,
  open_request_id AS OpenNewBankAccountRequest,
  Account.ihb_servicer AS IHBAccountHolder,
  Account.acct_charc_id AS BankAccountCharacteristic,
  _BankStmntRecnclnGrpText.BankStmntReconciliationGrpName AS BankStmntReconciliationGrpName,
  _BankAccountRevision.BankAccountAction AS BankAccountAction,
  _BankAccountSetting.BankStatementPostingType AS BankStatementPostingType,
  _BankAccountSetting.BankStatementTransferMode AS BankStatementTransferMode,
  _BankAccountSetting.BankStatementForwardingType AS BankStatementForwardingType,
  _BankAccountSetting.IntradayBankStatementPosting AS IntradayBankStatementPosting,
  _BankAccountSetting.InternalAPIBalanceIsEnabled AS InternalAPIBalanceIsEnabled,
  _BankAccountSetting.ExcelImportBalanceIsEnabled AS ExcelImportBalanceIsEnabled,
  _BankAccountSetting.ManualInputBalanceIsEnabled AS ManualInputBalanceIsEnabled,
  _BankAccountSetting.IntraBankStatementTransferMode AS IntraBankStatementTransferMode,
  cast( '0000' as fclm_bam_activate_sequence preserving type ) AS BankAccountActivatedSequence,
  cast( 0 as sadl_gw_dynamic_field_property preserving type ) AS BankAcctWorkflowNoteFieldCtrl,
  cast('' as boolean preserving type ) AS BankRelationshipSecIsHidden,
  cast('' as boolean preserving type ) AS CashPoolSecIsHidden,
  cast('' as boolean preserving type ) AS OverdraftLimitSecIsHidden,
  cast('' as boolean preserving type ) AS PaymentApproverSecIsHidden,
  cast('' as boolean preserving type ) AS BkCorrespncSecIsHidden,
  cast('' as boolean preserving type ) AS BkCorrespncFldrSecIsHidden,
  cast('' as boolean preserving type ) AS HsBkAcctConnectivitySctnIsHidn,
  cast('' as boolean preserving type ) AS MultiLanguageDescSecIsHidden,
  cast('' as boolean preserving type ) AS AttachmentSecIsHidden,
  cast('' as boolean preserving type ) AS AccountDocumentSecIsHidden,
  cast( '' as boolean preserving type ) AS PowerOfAttorneySectionIsHidden,
  cast( '' as boolean preserving type ) AS ActnActvtRevisionIsEnbld,
  cast( 0 as sadl_gw_dynamic_field_property preserving type ) AS BankAcctClosingDateFieldCtrl,
  cast( '' as boolean preserving type ) AS ActnRevertClosingInSystIsEnbld,
  cast( 0 as sadl_gw_dynamic_field_property preserving type ) AS BankAcctPostingBlkDateFldCtrl,
  cast( '' as boolean preserving type ) AS ActnRetToPreviousStatusIsEnbld,
  cast( 0 as sadl_gw_dynamic_field_property preserving type ) AS BkAcctBackActnNoteFldCtrl,
  cast( '' as fclm_bam_contype_control) AS BankAccountActionActivation,
  cast( '' as boolean preserving type ) AS ActionRestoreIsEnabled,
  cast( '' as boolean preserving type ) AS BankAccountIsModifyInRestore,
  cast( '' as boolean preserving type ) AS BankAccountRevisionIsNotZero,
  _minHouseBankAccount.HouseBank AS HouseBank,
  _minHouseBankAccount.HouseBankAccount AS HouseBankAccount,
  _minHouseBankAccount.GLAccount AS GLAccount,
  cast( '' as fclm_bam_posting_block_date ) AS PostingBlockDate,
  _CompanyCode.ChartOfAccounts AS ChartOfAccounts,
  _Bank._Address AS _Address
FROM fclm_bam_amd AS Account
LEFT OUTER JOIN I_BankAccHouseBankAccTP AS _AccountConnectivePath ON BankAccountInternalID = _AccountConnectivePath.BankAccountInternalID AND BankAccountRevision = _AccountConnectivePath.BankAccountRevision  -- association [0..*]
LEFT OUTER JOIN I_BankAccLimitTP AS _AccountOverDraftLimit ON BankAccountInternalID = _AccountOverDraftLimit.BankAccountInternalID AND BankAccountRevision = _AccountOverDraftLimit.BankAccountRevision  -- association [0..*]
LEFT OUTER JOIN I_BankAccSignatureTP AS _AccountSignature ON BankAccountInternalID = _AccountSignature.BankAccountInternalID AND BankAccountRevision = _AccountSignature.BankAccountRevision  -- association [0..*]
LEFT OUTER JOIN I_BankAccTextTP AS _AccountText ON BankAccountInternalID = _AccountText.BankAccountInternalID AND BankAccountRevision = _AccountText.BankAccountRevision  -- association [0..*]
LEFT OUTER JOIN I_BkAcctSpcfcCorrespncFldrTP AS _CorrespondenceFolder ON BankAccountInternalID = _CorrespondenceFolder.BankAccountInternalID AND BankAccountRevision = _CorrespondenceFolder.BankAccountRevision  -- association [0..*]
LEFT OUTER JOIN I_SingleHouseBankAccount AS _SingleHouseBankAccount ON BankAccountInternalID = _SingleHouseBankAccount.BankAccountInternalID AND BankAccountRevision = _SingleHouseBankAccount.BankAccountRevision  -- association [0..1]
LEFT OUTER JOIN I_Bank_2 AS _Bank ON BankCountry = _Bank.BankCountry AND Bank = _Bank.BankInternalID  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_ProfitCenterText AS _ProfitCenterText ON ProfitCenter = _ProfitCenterText.ProfitCenter AND ControllingArea = _ProfitCenterText.ControllingArea AND _ProfitCenterText.ValidityStartDate <= $session.system_date AND _ProfitCenterText.ValidityEndDate >= $session.system_date AND _ProfitCenterText.Language = $session.system_language  -- association [0..*]
LEFT OUTER JOIN I_ControllingArea AS _ControllingArea ON ControllingArea = _ControllingArea.ControllingArea  -- association [0..1]
LEFT OUTER JOIN I_BusinessAreaText AS _BusinessAreaText ON BusinessArea = _BusinessAreaText.BusinessArea AND _BusinessAreaText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_SegmentText AS _SegmentText ON Segment = _SegmentText.Segment AND _SegmentText.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_CountryText AS _CompanyCountryText ON CompanyCodeCountry = _CompanyCountryText.Country  -- association [0..*]
LEFT OUTER JOIN I_BankAccountTypeText AS _BankAccountType ON BankAccountType = _BankAccountType.BankAccountType  -- association [0..*]
LEFT OUTER JOIN I_BankAccountTextRev AS _AccountTextInCurrentLang ON BankAccountInternalID = _AccountTextInCurrentLang.BankAccountInternalID AND BankAccountRevision = _AccountTextInCurrentLang.BankAccountRevision AND _AccountTextInCurrentLang.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_BankAccountStatusStdVH AS _BankAccountStatus ON BankAccountStatus = _BankAccountStatus.BankAccountStatus  -- association [0..1]
LEFT OUTER JOIN I_BankAccRevision AS _BankAccountRevision ON BankAccountInternalID = _BankAccountRevision.BankAccountInternalID AND BankAccountRevision = _BankAccountRevision.BankAccountRevision  -- association [0..1]
LEFT OUTER JOIN I_BankAccHasRev AS _RevisionForActivating ON BankAccountInternalID = _RevisionForActivating.BankAccountInternalID  -- association [0..1]
LEFT OUTER JOIN I_BankAccountWithVerification AS _RevisionForVerify ON BankAccountInternalID = _RevisionForVerify.BankAccountInternalID  -- association [0..1]
LEFT OUTER JOIN I_BankAccInWorkFlow AS _BankAccInWorkFlow ON BankAccountInternalID = _BankAccInWorkFlow.BankAccountInternalID  -- association [0..1]
LEFT OUTER JOIN I_BankAccountRequested AS _BankAccRequested ON BankAccountInternalID = _BankAccRequested.BankAccountInternalID  -- association [0..1]
LEFT OUTER JOIN I_BankAccHasRevText AS _RevisionForActivatingText ON WithToBeActivatedRevision = _RevisionForActivatingText.WithToBeActivatedRevision AND _RevisionForActivatingText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_BankAccHasRevText AS _RevisionForVerifyText ON WithToBeVerifiedRevision = _RevisionForVerifyText.WithToBeActivatedRevision AND _RevisionForVerifyText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_BankAccInWorkflowText AS _BankAccInWorkFlowText ON InWorkflowProcess = _BankAccInWorkFlowText.InWorkflowProcess AND _BankAccInWorkFlowText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN E_BankAccount AS _E_BankAccount ON BankAccountInternalID = _E_BankAccount.BankAccountInternalID AND BankAccountRevision = _E_BankAccount.BankAccountRevision  -- association [1..1]
LEFT OUTER JOIN I_UserContactCard AS _BankAccountSupervisor ON BankAccountSupervisor = _BankAccountSupervisor.ContactCardID  -- association [0..1]
LEFT OUTER JOIN I_UserContactCard AS _CompanyContactPerson ON CompanyContactPerson = _CompanyContactPerson.ContactCardID  -- association [0..1]
LEFT OUTER JOIN I_UserContactCard AS _CreatedBy ON CreatedByUser = _CreatedBy.ContactCardID  -- association [0..1]
LEFT OUTER JOIN I_UserContactCard AS _OpenedBy ON OpenedByUser = _OpenedBy.ContactCardID  -- association [0..1]
LEFT OUTER JOIN I_UserContactCard AS _ClosedBy ON ClosedByUser = _ClosedBy.ContactCardID  -- association [0..1]
LEFT OUTER JOIN I_UserContactCard AS _ReviewedBy ON ReviewedByUser = _ReviewedBy.ContactCardID  -- association [0..1]
LEFT OUTER JOIN I_UserContactCard AS _LastChangedBy ON LastChangedByUser = _LastChangedBy.ContactCardID  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _GeneralContact ON BankContactPerson = _GeneralContact.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _BankRelationshipManager ON BankRelationshipManager = _BankRelationshipManager.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_BusinessPartner AS _IHBAccountHolder ON IHBAccountHolder = _IHBAccountHolder.BusinessPartner  -- association [0..1]
LEFT OUTER JOIN I_CashPoolMgmt AS _LeadingCashPoolMgmt ON LeadingCashPoolID = _LeadingCashPoolMgmt.CashPoolName AND _LeadingCashPoolMgmt.CashPoolIsDeleted <> 'X'  -- association [0..1]
LEFT OUTER JOIN I_CashPoolMgmt AS _ParticipantCashPoolMgmt ON ParticipantCashPoolID = _ParticipantCashPoolMgmt.CashPoolName AND _ParticipantCashPoolMgmt.CashPoolIsDeleted <> 'X'  -- association [0..1]
LEFT OUTER JOIN I_PaymentMethod AS _ParticipantPaymentMethod ON ParticipantPaymentMethod = _ParticipantPaymentMethod.PaymentMethod AND BankCountry = _ParticipantPaymentMethod.Country  -- association [0..1]
LEFT OUTER JOIN I_PaymentMethod AS _LeadingPaymentMethod ON LeadingPaymentMethod = _LeadingPaymentMethod.PaymentMethod AND BankCountry = _LeadingPaymentMethod.Country  -- association [0..1]
LEFT OUTER JOIN I_BkAcctPaytSrvcPrvdr AS _BkAcctPaytSrvcPrvdr ON PaymentServiceProvider = _BkAcctPaytSrvcPrvdr.PaymentServiceProvider  -- association [0..1]
LEFT OUTER JOIN I_BankAccountLatestReview AS _SingleAccountReviewLog ON BankAccountInternalID = _SingleAccountReviewLog.BankAccountInternalID  -- association [0..1]
LEFT OUTER JOIN I_RegionText AS _RegionText ON BankCountry = _RegionText.Country AND region = _RegionText.Region AND _RegionText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_BankStmntRecnclnGrpText AS _BankStmntRecnclnGrpText ON BankStmntReconciliationGrp = _BankStmntRecnclnGrpText.BankStmntReconciliationGrp AND _BankStmntRecnclnGrpText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_BankAccountSetting AS _BankAccountSetting ON BankAccountInternalID = _BankAccountSetting.BankAccountInternalID  -- association [0..1]
LEFT OUTER JOIN I_BankAcctContrTypeVH AS _ContractType ON BankAccountType = _ContractType.BankAccountType  -- association [0..1]
LEFT OUTER JOIN I_BankAccountOpeningRequest AS _BankAccountApplication ON OpenNewBankAccountRequest = _BankAccountApplication.BankAccountChangeRequest AND _BankAccountApplication.BankAccountOpeningRequestUUID is not null  -- association [0..1]
LEFT OUTER JOIN I_HouseBankCount AS _HouseBankCount ON _HouseBankCount.CompanyCode = CompanyCode AND _HouseBankCount.BankCountry = BankCountry AND _HouseBankCount.BankInternalID = Bank  -- association [0..1]
LEFT OUTER JOIN I_SglHsBkAcctInBankAccount AS _minHouseBankAccount ON BankAccountInternalID = _minHouseBankAccount.BankAccountInternalID AND CompanyCode = _minHouseBankAccount.CompanyCode AND BankAccountRevision = _minHouseBankAccount.BankAccountRevision  -- association [0..1]
LEFT OUTER JOIN I_BankIntraStaRule AS _BankIntraStaRule ON BankCountry = _BankIntraStaRule.BankCountry AND Bank = _BankIntraStaRule.BankInternalID  -- association [0..1]
;