I_BankAccHouseBankAccTP

Bank Account Ac2 BO active and draft | view: IBANKACCAC2TP | Extraction: Not supported | Component: Bank Account Management
Tables used: BNKA, FCLM_BAM_ACLINK2, FCLM_BNKA_BP_FS, T012, FCLM_BAM_BNKABP2, T012D
Column Name Description
BankAccountInternalID FK Bank Account Technical ID
HouseBankAcctUUID GUID
BankAccountRevision FK Revision Number
Column Name Description
Column Name Description
Column Name Description
HouseBankAccStartDate Valid From
HouseBankAccEndDate Valid To
PostingBlockDate GL Posting Block Date
DefaultPartnerValidToDate Valid To
DefaultPartnerValidFromDate Valid From
RiskPartnerValidToDate Valid To
RiskPartnerValidFromDate Valid From
Column Name Description
IsReused Reused Flag for House Bank Account Show values
GLAcctIsBankReconciliationAcct Indicator for Using Bank Reconciliation Account Show values
MigrationStatus Bank Account Ledger Migration Status Show values
CashPoolingIsUsed Use in Cash Pooling Show values
AccountIsBlockedForPosting Indicator: Is Account Blocked for Posting? Show values
IsPostBankAccount Post Office Bank Current Account Show values
EDISignatureType Type of Signature Show values
CentralBankReportIsRequired Create Central Bank Report Show values
PaymentIsForwardedToCentralBk Forward Payment Data to the Central Bank Show values
HouseBankIDCategory ID Category in Connectivity Path Show values
Column Name Description Domain name
RemoteSystem Remote System LOGSYS
CompanyCode Company Code BUKRS
HouseBankAccount House Bank Account HKTID
RemoteAccount Remote Account CHAR32
BankAccount Bank account number BANKN
BankControlKey Bank Control Key BKONT
ReferenceInfo Reference Information CHAR27
DataMedExchangeIdentification DME Sold-To Party Identification (Switzerland) CHAR5
BankAccountAlternative Alternative Bank Account Number (for Ambiguous Acct Number) BNKN2
MinimumDays Minimum days until due date when presenting for collection NUM03
OldGLAccount General Ledger Account SAKNR
TargetGLAccount General Ledger Account SAKNR
NettingGroup Netting Group CHAR6
BankInternalID Bank Keys BANKK
SWIFTCode SWIFT/BIC for International Payments SWIFT
BankGroup Bank group (bank network) BGRUP
Bank Bank Number BANKL
BankName Name of Financial Institution TEXT60
StreetName Street and House Number TEXT35
CityName City TEXT35
Branch Bank Branch TEXT40
EDIPartner House Bank Partner Number EDI_PARNUM
DataMediumExchangeBank DME Bank Identification CHAR5
DataMediumReceivingBank Bank Number of the Bank Receiving the Data Medium BANKL
CustomerByHouseBank Customer ID at House Bank CHAR18
OrderingCompanyByBank Company Number of Ordering Party CHAR20
ChargeAccountBank Charge Account Bank Number BANKL
ChargeAccount Account Number of the Charge Account BANKN35
ChargeAccountCurrencyISOCode ISO Currency Code for Charge Account CHAR3
ExecutionLeadDays Lead Days for Date of Execution NUMC02
RegionByCentralBank Area Number NUMC02
HouseBankCategoryKey Character field, length 32 CHAR32
Master Data Relations Join Conditions
Subaccount for Bill of Exchange Collection
  • Company Code
  • Client
  • Subaccount for Bill of Exchange Collection
  • I_BANKACCHOUSEBANKACCTP.COMPANYCODE == SKB1.BUKRS
  • I_BANKACCHOUSEBANKACCTP.MANDT == SKB1.MANDT
  • I_BANKACCHOUSEBANKACCTP.ACCFORBILLOFEXCHANGECOLLECTION == SKB1.SAKNR
Bank Account Authorization Group
  • Bank Account Authorization Group
  • Client
Bank Account Technical ID
  • Bank Account Technical ID
  • ?
  • Client
  • I_BANKACCHOUSEBANKACCTP.BANKACCOUNTINTERNALID == FCLM_BAM_AMD.ACC_ID
  • I_BANKACCHOUSEBANKACCTP.[column in domain "FCLM_REVISION"] == FCLM_BAM_AMD.REVISION
  • I_BANKACCHOUSEBANKACCTP.MANDT == FCLM_BAM_AMD.MANDT
Revision Number
  • Revision Number
  • Bank Account Technical ID
  • Client
  • I_BANKACCHOUSEBANKACCTP.BANKACCOUNTREVISION == FCLM_BAM_AMD.REVISION
  • I_BANKACCHOUSEBANKACCTP.BANKACCOUNTINTERNALID == FCLM_BAM_AMD.ACC_ID
  • I_BANKACCHOUSEBANKACCTP.MANDT == FCLM_BAM_AMD.MANDT
Country/Region Key of Bank
  • Country/Region Key of Bank
  • Client
  • I_BANKACCHOUSEBANKACCTP.BANKCOUNTRY == T005.LAND1
  • I_BANKACCHOUSEBANKACCTP.MANDT == T005.MANDT
Subaccount for Bill of Exchange Presentation for Discounting
  • Company Code
  • Client
  • Subaccount for Bill of Exchange Presentation for Discounting
  • I_BANKACCHOUSEBANKACCTP.COMPANYCODE == SKB1.BUKRS
  • I_BANKACCHOUSEBANKACCTP.MANDT == SKB1.MANDT
  • I_BANKACCHOUSEBANKACCTP.BILLDISCOUNTACCOUNT == SKB1.SAKNR
Planning Group
  • Planning Group
  • Client
  • I_BANKACCHOUSEBANKACCTP.CASHPLANNINGGROUP == T035.GRUPP
  • I_BANKACCHOUSEBANKACCTP.MANDT == T035.MANDT
Instruction Key for Data Medium Exchange
  • Country/Region Key of Bank
  • Instruction Key for Data Medium Exchange
  • ?
  • Client
  • I_BANKACCHOUSEBANKACCTP.BANKCOUNTRY == T015W.BANKS
  • I_BANKACCHOUSEBANKACCTP.DATAEXCHANGEINSTRUCTIONKEY == T015W.DTAWS
  • I_BANKACCHOUSEBANKACCTP.[column in domain "DZLSCH"] == T015W.ZLSCH
  • I_BANKACCHOUSEBANKACCTP.MANDT == T015W.MANDT
Business Partner Number
  • Business Partner Number
  • Business Partner Number
  • Client
  • I_BANKACCHOUSEBANKACCTP.RISKPARTNERNO == BUT000.PARTNER
  • I_BANKACCHOUSEBANKACCTP.DEFAULTPARTNERNO == BUT000.PARTNER
  • I_BANKACCHOUSEBANKACCTP.MANDT == BUT000.CLIENT
General ledger account
  • General Ledger Account
  • Company Code
  • Client
  • I_BANKACCHOUSEBANKACCTP.GLACCOUNT == SKB1.SAKNR
  • I_BANKACCHOUSEBANKACCTP.COMPANYCODE == SKB1.BUKRS
  • I_BANKACCHOUSEBANKACCTP.MANDT == SKB1.MANDT
Tolerance Group for G/L Accounts
  • Company Code
  • Tolerance Group for G/L Accounts
  • Client
  • I_BANKACCHOUSEBANKACCTP.COMPANYCODE == T043S.BUKRS
  • I_BANKACCHOUSEBANKACCTP.GLACCOUNTTOLERANCEGROUP == T043S.TOGRU
  • I_BANKACCHOUSEBANKACCTP.MANDT == T043S.MANDT
Short Key for a House Bank
  • Short Key for a House Bank
  • Company Code
  • Client
  • I_BANKACCHOUSEBANKACCTP.HOUSEBANK == T012.HBKID
  • I_BANKACCHOUSEBANKACCTP.COMPANYCODE == T012.BUKRS
  • I_BANKACCHOUSEBANKACCTP.MANDT == T012.MANDT
Account details for debit memo from bill/exch. presentation
  • Company Code
  • Alternative house bnk for bill/exch. presentation debit memo
  • Account details for debit memo from bill/exch. presentation
  • Client
  • I_BANKACCHOUSEBANKACCTP.COMPANYCODE == T012K.BUKRS
  • I_BANKACCHOUSEBANKACCTP.HOUSEBANKALTERNATIVE1 == T012K.HBKID
  • I_BANKACCHOUSEBANKACCTP.HOUSEBANKACCALTERNATIVE1 == T012K.HKTID
  • I_BANKACCHOUSEBANKACCTP.MANDT == T012K.MANDT
Account details for debit memo from bill/exch. presentation
  • Alternative house bank for failed bill/exch. receivable
  • Company Code
  • Account details for debit memo from bill/exch. presentation
  • Client
  • I_BANKACCHOUSEBANKACCTP.HOUSEBANKALTERNATIVE2 == T012K.HBKID
  • I_BANKACCHOUSEBANKACCTP.COMPANYCODE == T012K.BUKRS
  • I_BANKACCHOUSEBANKACCTP.HOUSEBANKACCALTERNATIVE2 == T012K.HKTID
  • I_BANKACCHOUSEBANKACCTP.MANDT == T012K.MANDT
Alternative house bnk for bill/exch. presentation debit memo
  • Company Code
  • Alternative house bnk for bill/exch. presentation debit memo
  • Client
  • I_BANKACCHOUSEBANKACCTP.COMPANYCODE == T012.BUKRS
  • I_BANKACCHOUSEBANKACCTP.HOUSEBANKALTERNATIVE1 == T012.HBKID
  • I_BANKACCHOUSEBANKACCTP.MANDT == T012.MANDT
Alternative house bank for failed bill/exch. receivable
  • Alternative house bank for failed bill/exch. receivable
  • Company Code
  • Client
  • I_BANKACCHOUSEBANKACCTP.HOUSEBANKALTERNATIVE2 == T012.HBKID
  • I_BANKACCHOUSEBANKACCTP.COMPANYCODE == T012.BUKRS
  • I_BANKACCHOUSEBANKACCTP.MANDT == T012.MANDT
Region (State, Province, County)
  • Country/Region Key of Bank
  • Region (State, Province, County)
  • Client
  • I_BANKACCHOUSEBANKACCTP.BANKCOUNTRY == T005S.LAND1
  • I_BANKACCHOUSEBANKACCTP.REGION == T005S.BLAND
  • I_BANKACCHOUSEBANKACCTP.MANDT == T005S.MANDT
Bk Act to Be Debited with Amount from Returned Bill Payable
  • Bk Act to Be Debited with Amount from Returned Bill Payable
  • Company Code
  • Client
  • I_BANKACCHOUSEBANKACCTP.RETURNEDBILLOFEXCHANGEPAYABLE == SKB1.SAKNR
  • I_BANKACCHOUSEBANKACCTP.COMPANYCODE == SKB1.BUKRS
  • I_BANKACCHOUSEBANKACCTP.MANDT == SKB1.MANDT
Business Partner Number
  • Business Partner Number
  • Business Partner Number
  • Client
  • I_BANKACCHOUSEBANKACCTP.RISKPARTNERNO == BUT000.PARTNER
  • I_BANKACCHOUSEBANKACCTP.DEFAULTPARTNERNO == BUT000.PARTNER
  • I_BANKACCHOUSEBANKACCTP.MANDT == BUT000.CLIENT
Settlement currency for bank transfers
  • Settlement currency for bank transfers
  • Client
  • I_BANKACCHOUSEBANKACCTP.SETTLEMENTAMOUNTCURRENCY == TCURC.WAERS
  • I_BANKACCHOUSEBANKACCTP.MANDT == TCURC.MANDT