C_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 C_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 C_BankAccountTP AS
SELECT
  BankAccountInternalID,
  BankAccountRevision,
  BankAccountUniqueID,
  ArchObjectNumber,
  BankAccount,
  BankAccountDescription,
  Bank,
  BankName,
  BankCountry,
  CountryName,
  CompanyCode,
  CompanyCodeCountry,
  CompanyCodeName,
  CompanyCodeCurrency,
  BankAccountType,
  BankAccountContractType,
  _ContractTypeText.BankAccountContractTypeName AS BankAccountContractTypeName,
  BankAccountCurrency,
  BankAccountStatus,
  _BankAccountStatus.BankAccountStatusName AS BankAccountStatusName,
  BankAccountRevisionStatus,
  HouseBank,
  HouseBankAccount,
  GLAccount,
  IBAN,
  IBANValidityStartDate,
  ControllingArea,
  _ControllingArea.ControllingAreaName AS ControllingAreaName,
  ProfitCenter,
  BusinessArea,
  _BusinessAreaText.BusinessAreaName AS BusinessAreaName,
  Segment,
  _SegmentText.SegmentName AS SegmentName,
  BankAccountHolderName,
  BankRelationshipManager,
  _BankRelationshipManager.BusinessPartnerFullName AS BankRelationshipManagerName,
  CompanyContactPerson,
  _CompanyContactPerson.FullName AS CompanyContactPersonFullName,
  BankContactPerson,
  _GeneralContact.BusinessPartnerFullName AS BankContactPersonName,
  BankAccountSupervisor,
  _BankAccountSupervisor.FullName AS BankAccountSupervisorFullName,
  IHBAccountHolder,
  _IHBAccountHolder.BusinessPartnerFullName AS IHBAccountHolderName,
  BankNumber,
  SWIFTCode,
  BankControlKey,
  BankGroup,
  BankNetworkGrouping,
  Region,
  _RegionText.RegionName AS RegionName,
  StreetName,
  ShortStreetName,
  CityName,
  ShortCityName,
  Branch,
  BankBranch,
  BankIntraStatRuleExternalID,
  CreatedByUser,
  Account.AddressID AS AddressID,
  OpenedByUser,
  LastChangedByUser,
  ClosedByUser,
  IsMarkedForDeletion,
  DomesticCutOffTime,
  CrossBorderCutOffTime,
  PlannedClosingDate,
  ValidityEndDate,
  CreationDate,
  CreationTime,
  BankAccountCreatedDateTime,
  ValidityStartDate,
  OpenedDate,
  OpenedTime,
  BankAccountOpenedDateTime,
  LastChangeDate,
  LastChangeTime,
  BankAccountLastChangedDateTime,
  BankAccountLastReviewDate,
  ClosedDate,
  ClosedTime,
  BankAccountClosedDateTime,
  IsUploadOfIntraDayStatement,
  IntraBkStaRuleExternalID,
  IntraDayBankStateImportMethod,
  BankStatementImportMethod,
  EndOfDayIsReconciled,
  BankStatementImportChannel,
  _BkAcctImportingChnlVH.OutputChannelDescription AS OutputChannelDescription,
  BankStatementCheckTime,
  PaymentTransactionTypeGroup,
  ProcessingStatus,
  DifferenceStatus,
  SerialNumberStatus,
  ReconciliationStatus,
  ExpectedInterval,
  ControlFrequency,
  _BkAcctIntvlUnitVH.FrequencyDescription AS FrequencyDescription,
  FactoryCalendar,
  DisplayItem,
  DifferenceAmount,
  LeadingCashPoolID,
  LeadingCashPoolDesc,
  LeadingPaymentMethod,
  _LeadingPaymentMethod.PaymentMethodName AS LeadingPaymentMethodName,
  ParticipantCashPoolID,
  ParticipantCashPoolDesc,
  CashPoolCurrency,
  MaxTargetAmount,
  MinTransferAmount,
  MaxTransferAmount,
  Note,
  ParticipantPaymentMethod,
  _ParticipantPaymentMethod.PaymentMethodName AS ParticipantPaymentMethodName,
  WithToBeActivatedRevision,
  WithToBeVerifiedRevision,
  _RevisionForVerifyText.WithToBeActivatedRevisionText AS WithToBeActivatedRevisionText,
  InWorkflowProcess,
  RevisionWithWorkflow,
  BankAccountAction,
  _CreatedBy.FullName AS CreatedByUserDescription,
  _OpenedBy.FullName AS OpenedByUserFullName,
  _ClosedBy.FullName AS ClosedByUserFullName,
  _LastChangedBy.FullName AS LastChangedByUserFullName,
  PaymentServiceProvider,
  _BkAcctPaytSrvcPrvdr.CAProviderContractName AS CAProviderContractName,
  CashToleranceGroup,
  IntradayIsReconciled,
  PlanningLevel,
  BankStmntReconciliationGrp,
  BankStmntReconciliationGrpName,
  BankAcctWorkflowNote,
  OpenNewBankAccountRequest,
  BankStatementPostingType,
  _BankAccountSetting.BankStatementPostingTypeText AS BankStatementPostingTypeText,
  BankStatementTransferMode,
  _BankAccountSetting.BankStatementTransferModeText AS BankStatementTransferModeText,
  BankStatementForwardingType,
  _BankAccountSetting.BankStatementForwardingText AS BankStatementForwardingText,
  IntradayBankStatementPosting,
  _BankAccountSetting.IntradayBkStatementPostingText AS IntradayBkStatementPostingText,
  InternalAPIBalanceIsEnabled,
  ExcelImportBalanceIsEnabled,
  ManualInputBalanceIsEnabled,
  BankAccountActivatedSequence,
  BankAcctWorkflowNoteFieldCtrl,
  BankRelationshipSecIsHidden,
  CashPoolSecIsHidden,
  OverdraftLimitSecIsHidden,
  PaymentApproverSecIsHidden,
  BkCorrespncSecIsHidden,
  AttachmentSecIsHidden,
  MultiLanguageDescSecIsHidden,
  HsBkAcctConnectivitySctnIsHidn,
  AccountDocumentSecIsHidden,
  ActnActvtRevisionIsEnbld,
  BankAcctClosingDateFieldCtrl,
  ActnRevertClosingInSystIsEnbld,
  BankAcctPostingBlkDateFldCtrl,
  ActnRetToPreviousStatusIsEnbld,
  BkAcctBackActnNoteFldCtrl,
  BankAccountActionActivation,
  ActionRestoreIsEnabled,
  BankAccountIsModifyInRestore,
  BankAccountRevisionIsNotZero,
  cast('' as fis_prctr_hryid_42) AS ProfitCenterHierarchy,
  cast('' as fis_prctr_hrynid_50) AS ProfitCenterHierarchyNode,
  ChartOfAccounts,
  cast('' as fis_glaccthier) AS GLAccountHierarchy,
  cast('' as fis_glacct_hrynid_50) AS GLAccountHierarchyNode
FROM I_BankAccountTP AS Account
LEFT OUTER JOIN C_BankAccSignatureTP AS _AccountSignature ON BankAccountInternalID = _AccountSignature.BankAccountInternalID AND BankAccountRevision = _AccountSignature.BankAccountRevision  -- association [0..*]
LEFT OUTER JOIN C_BankAccHouseBankAccTP AS _AccountConnectivePath ON BankAccountInternalID = _AccountConnectivePath.BankAccountInternalID AND BankAccountRevision = _AccountConnectivePath.BankAccountRevision  -- association [0..*]
LEFT OUTER JOIN C_BankAccLimitTP AS _AccountOverDraftLimit ON BankAccountInternalID = _AccountOverDraftLimit.BankAccountInternalID AND BankAccountRevision = _AccountOverDraftLimit.BankAccountRevision  -- association [0..*]
LEFT OUTER JOIN C_BankAccTextTP AS _AccountText ON BankAccountInternalID = _AccountText.BankAccountInternalID AND BankAccountRevision = _AccountText.BankAccountRevision  -- association [0..*]
LEFT OUTER JOIN I_BankAccRevisionStatus AS _BankAccRevisionStatus ON BankAccountRevisionStatus = _BankAccRevisionStatus.BankAccountRevisionStatus AND _BankAccRevisionStatus.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN C_BankAccCashPoolTP AS _AccountCashPool ON BankAccountInternalID = _AccountCashPool.BankAccountInternalID AND BankAccountRevision = _AccountCashPool.BankAccountRevision  -- association [0..*]
LEFT OUTER JOIN I_BankAcctNumberVH AS _BankAcctNumberVH ON BankAccountInternalID = _BankAcctNumberVH.BankAccountInternalID AND BankCountry = _BankAcctNumberVH.BankCountry AND Bank = _BankAcctNumberVH.Bank AND BankAccountCurrency = _BankAcctNumberVH.BankAccountCurrency AND BankAccount = _BankAcctNumberVH.BankAccountNumber  -- association [0..1]
LEFT OUTER JOIN C_BkAcctImportingChnlVH AS _BkAcctImportingChnlVH ON BankStatementImportChannel = _BkAcctImportingChnlVH.BankStatementImportChannel  -- association [0..1]
LEFT OUTER JOIN C_BkAcctIntvlUnitVH AS _BkAcctIntvlUnitVH ON ControlFrequency = _BkAcctIntvlUnitVH.ControlFrequency  -- association [0..1]
LEFT OUTER JOIN I_CurrencyStdVH AS _CurrencyVH ON BankAccountCurrency = _CurrencyVH.Currency  -- association [0..1]
LEFT OUTER JOIN C_FactoryCalendarValueHelp AS _FactoryCalendarText ON FactoryCalendar = _FactoryCalendarText.FactoryCalendar  -- association [0..1]
LEFT OUTER JOIN I_PlanningLevelText AS _PlanningLevelText ON PlanningLevel = _PlanningLevelText.PlanningLevel  -- association [0..*]
LEFT OUTER JOIN I_IntraBkStaRuleText AS _AcctLevelIntraRuleText ON IntraBkStaRuleExternalID = _AcctLevelIntraRuleText.IntraBkStaRuleExternalID  -- association [0..*]
LEFT OUTER JOIN I_PaymentTransactionTypeGroupT AS _PaymentTransactionTypeGroupT ON PaymentTransactionTypeGroup = _PaymentTransactionTypeGroupT.PaymentTransactionTypeGroup  -- association [0..*]
LEFT OUTER JOIN I_BankAcctContrTypeText AS _ContractTypeText ON BankAccountContractType = _ContractTypeText.BankAccountContractType AND _ContractTypeText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN C_HierRuntimeRprstnDplLeafNode AS _ProfitCenterHierLeafNode ON ProfitCenter = _ProfitCenterHierLeafNode.UnivHierarchyBusinessEntity AND ControllingArea = _ProfitCenterHierLeafNode.HierarchyNodeClass AND _ProfitCenterHierLeafNode.ValidityStartDate <= $session.system_date AND _ProfitCenterHierLeafNode.ValidityEndDate >= $session.system_date AND _ProfitCenterHierLeafNode.HierarchyType = '0101'  -- association [0..*]
LEFT OUTER JOIN C_HierRuntimeRprstnDplLeafNode AS _GLAccountHierLeafNode ON GLAccount = _GLAccountHierLeafNode.UnivHierarchyBusinessEntity AND ChartOfAccounts = _GLAccountHierLeafNode.HierarchyNodeClass AND _GLAccountHierLeafNode.ValidityStartDate <= $session.system_date AND _GLAccountHierLeafNode.ValidityEndDate >= $session.system_date AND _GLAccountHierLeafNode.HierarchyType = 'FSVN'  -- association [0..*]
;