C_BankAccountTP

Bank Account Administrative Data | view: CBANKACCOUNTTP | Extraction: Not supported | Component: Bank Account Management
Tables used: FCLM_BAM_REQ, FCLM_BAM_REQACNT, FCLM_BAM_REQ, FCLM_BAM_REQACNT, ADCP, ADRC, BNKA, FCLM_BAM_REV, FCLM_BAM_REVWLOG, FCLM_ACC_BS_CONF, FCLM_BAM_AMD_T, FCLM_BAM_AMD, FCLM_BAM_AMD, FCLM_BAM_REV, FCLM_BAM_AC_TYPE, FCLM_BAM_REVIWER, FCLM_BAM_REVWLOG, FCLM_BAM_AMD, FCLM_BAM_AMD_T, FCLM_BRM_RU_ASGN, FCLM_BAL_BSRGRPT, TGSBT, BUT000, FCLM_CPL, FCLM_CPL_TXT, T001, TKA02, TKA01, T005T, T042Z, T042ZT, CEPC, CEPCT, T005U, T000, FAGL_SEGMT, FCLM_BAM_AMD, USR21
Column Name Description
BankAccountInternalID Bank Account Technical ID
BankAccountRevision Revision Number
Column Name Description
💲 Currency Key (BankAccountCurrency):
DifferenceAmount FTE_BSM: Difference Amount Permitted in Account Currency
💲 Currency Key (CashPoolCurrency):
MaxTargetAmount Target Balance for Subaccount
MinTransferAmount Minimum Transfer Amount for Subaccount
MaxTransferAmount Maximum Transfer Amount for Subaccount
Column Name Description
Column Name Description
IBANValidityStartDate IBAN Valid From
DomesticCutOffTime Cut-Off Time Domestic
CrossBorderCutOffTime Cut-Off Time Cross Border
PlannedClosingDate Planned Closing Date
ValidityEndDate Bank Account Closing Date
CreationDate Bank Account Created On
CreationTime Created At
ValidityStartDate Bank Account Opening Date
OpenedDate Bank Account: Openned On
OpenedTime Bank Account Opened At
LastChangeDate Changed On
LastChangeTime Changed At
BankAccountLastReviewDate null
ClosedDate Closed On
ClosedTime Closed At
BankStatementCheckTime Bank Statement Check Time
Column Name Description
BankAccountContractType Bank Account Contract Type Show values
BankAccountStatus Bank Account Status Show values
BankAccountRevisionStatus Bank Account Master Data: Revision Status Show values
IsMarkedForDeletion Data element for domain BOOLE: TRUE (='X') and FALSE (=' ') Show values
IsUploadOfIntraDayStatement Upload of Intraday Statements Show values
EndOfDayIsReconciled Reconcile End-of-Day Memo Records Show values
BankStatementImportChannel Bank Statement Importing Channel Show values
ProcessingStatus Activate Processing Status for Bank Statement Show values
DifferenceStatus Activate Difference Status for Bank Statement Show values
SerialNumberStatus Activate Serial Number Status for Bank Statement Show values
ReconciliationStatus Activate Reconciliation Status for Bank Statement Show values
ControlFrequency FTE-BSM: Frequency Unit Show values
WithToBeActivatedRevision Revision Ready for Activation Show values
WithToBeVerifiedRevision Revision Ready for Activation Show values
InWorkflowProcess In Workflow Process Show values
RevisionWithWorkflow Bank Account revision created and actived in workflow mode Show values
BankAccountAction Action Performed on Bank Account Show values
IntradayIsReconciled Reconcile Intraday Memo Records Show values
BankStatementPostingType EoD Bank Statement Posting Category Show values
BankStatementTransferMode EoD Bank Statement Transfer Mode to Cash Show values
BankRelationshipSecIsHidden Boolean Variable (X = True, - = False, Space = Unknown) Show values
CashPoolSecIsHidden Boolean Variable (X = True, - = False, Space = Unknown) Show values
OverdraftLimitSecIsHidden Boolean Variable (X = True, - = False, Space = Unknown) Show values
PaymentApproverSecIsHidden Boolean Variable (X = True, - = False, Space = Unknown) Show values
BkCorrespncSecIsHidden Boolean Variable (X = True, - = False, Space = Unknown) Show values
ActnActvtRevisionIsEnbld Boolean Variable (X = True, - = False, Space = Unknown) Show values
ActnRevertClosingInSystIsEnbld Boolean Variable (X = True, - = False, Space = Unknown) Show values
ActnRetToPreviousStatusIsEnbld Boolean Variable (X = True, - = False, Space = Unknown) Show values
BankAccountActionActivation Activation Modes of Bank Account Revisions Show values
Column Name Description Domain name
BankAccountUniqueID null
ArchObjectNumber Object number J_OBJNR
BankAccount Bank Account Number FCLM_BAM_ACC_NUM
BankAccountDescription Account Description TEXT60
BankName Name of Financial Institution TEXT60
CountryName Country/Region Name TEXT50
CompanyCodeName Name of Company Code or Company TEXT25
BankAccountStatusName Bank Account Status Description DDTEXT
HouseBank Short Key for a House Bank HBKID
HouseBankAccount ID for Account Details HKTID
GLAccount General Ledger Account SAKNR
IBAN IBAN (International Bank Account Number) IBAN
ControllingAreaName Controlling Area Name TEXT25
ProfitCenter Profit Center PRCTR
ProfitCenterName Description of Profit Center TEXT20
BusinessAreaName Business Area Description TEXT30
SegmentName Segment Name TEXT50
BankAccountHolderName Bank Account Holder TEXT60
BankRelationshipManager Bank Relationship Manager BU_PARTNER
BankRelationshipManagerName null
CompanyContactPersonFullName User Description SUIDTECHDESC
BankContactPerson General Contact Person at Bank BU_PARTNER
BankContactPersonName null
BankAccountSupervisorFullName User Description SUIDTECHDESC
BankNumber Bank Number BANKL
SWIFTCode SWIFT/BIC for International Payments SWIFT
BankControlKey Bank Control Key BKONT
BankGroup Bank group (bank network) BGRUP
BankNetworkGrouping Bank group (bank network) BGRUP
RegionName Description TEXT20
StreetName Street and House Number TEXT35
ShortStreetName Street and House Number TEXT35
CityName City TEXT35
ShortCityName City TEXT35
Branch Bank Branch TEXT40
BankBranch Bank Branch TEXT40
BankIntraStatRuleExternalID Monitoring Rule for Intraday Statements FCLM_BRM_RULE_EXT_ID
CreatedByUser Created By XUBNAME
AddressID Address Number AD_ADDRNUM
OpenedByUser Bank Account: Opened By XUBNAME
LastChangedByUser Changed By XUBNAME
ClosedByUser Closed By XUBNAME
IntraBkStaRuleExternalID Monitoring Rule for Intraday Statements FCLM_BRM_RULE_EXT_ID
OutputChannelDescription Short Text for Fixed Values DDTEXT
ExpectedInterval Interval for Expected Bank Statements NUMC2
FrequencyDescription Short Text for Fixed Values DDTEXT
FactoryCalendar Factory Calendar WFCID
DisplayItem FTE-BSM: Display Item in Bank Statement Monitor NUMC3
LeadingCashPoolID Cash Pool ID FCLM_BAM_CASH_POOL_ID
LeadingCashPoolDesc Cash Pool Description TEXT50
LeadingPaymentMethodName Payment Method Name TEXT30
ParticipantCashPoolID Cash Pool for Subaccount FCLM_BAM_CASH_POOL_ID
ParticipantCashPoolDesc Cash Pool Description TEXT50
Note Item Text TEXT50
ParticipantPaymentMethodName Payment Method Name TEXT30
WithToBeActivatedRevisionText Has Revision to Active Description DDTEXT
CreatedByUserDescription User Description SUIDTECHDESC
OpenedByUserFullName User Description SUIDTECHDESC
ClosedByUserFullName User Description SUIDTECHDESC
LastChangedByUserFullName User Description SUIDTECHDESC
PaymentServiceProvider Payment Service Provider for Digital Payments DP_PAYMENT_SERVICE_PROVIDER
CAProviderContractName Description TEXT60
CashToleranceGroup Tolerance Group Key
PlanningLevel Planning Level FDLEV
BankStmntReconciliationGrp Bank Statement Group FCLM_BAL_BSR_GROUP
BankStmntReconciliationGrpName Bank Statement Group Description TEXT30
BankAcctWorkflowNote Note for bank account workflow
BankAcctWorkflowNoteFieldCtrl Dynamic Field Property SADL_GW_DYNAMIC_FIELD_PROPERTY
OpenNewBankAccountRequest Change Request ID NUMC12
BankStatementPostingTypeText Short Text for Fixed Values DDTEXT
BankStatementTransferModeText Short Text for Fixed Values DDTEXT
BankAccountActivatedSequence Bank Account: Revision Activated Sequence FCLM_BAM_ACT_SEQ
BankAcctClosingDateFieldCtrl Dynamic Field Property SADL_GW_DYNAMIC_FIELD_PROPERTY
BankAcctPostingBlkDateFldCtrl Dynamic Field Property SADL_GW_DYNAMIC_FIELD_PROPERTY
BkAcctBackActnNoteFldCtrl Dynamic Field Property SADL_GW_DYNAMIC_FIELD_PROPERTY
Master Data Relations Join Conditions
Bank Key
  • Bank Country/Region Key
  • Client
  • Bank Key
  • C_BANKACCOUNTTP.BANKCOUNTRY == BNKA.BANKS
  • C_BANKACCOUNTTP.MANDT == BNKA.MANDT
  • C_BANKACCOUNTTP.BANK == BNKA.BANKL
Currency Key
  • Client
  • Currency Key
  • Currency Key
  • Currency Key
  • C_BANKACCOUNTTP.MANDT == TCURC.MANDT
  • C_BANKACCOUNTTP.CASHPOOLCURRENCY == TCURC.WAERS
  • C_BANKACCOUNTTP.BANKACCOUNTCURRENCY == TCURC.WAERS
  • C_BANKACCOUNTTP.COMPANYCODECURRENCY == TCURC.WAERS
Bank Account Supervisor
  • Client
  • Bank Account Supervisor
  • C_BANKACCOUNTTP.MANDT == USR02.MANDT
  • C_BANKACCOUNTTP.BANKACCOUNTSUPERVISOR == USR02.BNAME
Bank Account Type ID
  • Bank Account Type ID
  • Client
Bank Country/Region Key
  • Bank Country/Region Key
  • Client
  • C_BANKACCOUNTTP.BANKCOUNTRY == T005.LAND1
  • C_BANKACCOUNTTP.MANDT == T005.MANDT
Import Method for End-of-Day Bank Statements
  • Import Method for End-of-Day Bank Statements
  • Client
Business Area
  • Business Area
  • Client
  • C_BANKACCOUNTTP.BUSINESSAREA == TGSB.GSBER
  • C_BANKACCOUNTTP.MANDT == TGSB.MANDT
Currency Key
  • Client
  • Currency Key
  • Currency Key
  • Currency Key
  • C_BANKACCOUNTTP.MANDT == TCURC.MANDT
  • C_BANKACCOUNTTP.CASHPOOLCURRENCY == TCURC.WAERS
  • C_BANKACCOUNTTP.BANKACCOUNTCURRENCY == TCURC.WAERS
  • C_BANKACCOUNTTP.COMPANYCODECURRENCY == TCURC.WAERS
Company Code
  • Client
  • Company Code
  • C_BANKACCOUNTTP.MANDT == T001.MANDT
  • C_BANKACCOUNTTP.COMPANYCODE == T001.BUKRS
Country/Region Key
  • Country/Region Key
  • Client
  • C_BANKACCOUNTTP.COMPANYCODECOUNTRY == T005.LAND1
  • C_BANKACCOUNTTP.MANDT == T005.MANDT
Currency Key
  • Client
  • Currency Key
  • Currency Key
  • Currency Key
  • C_BANKACCOUNTTP.MANDT == TCURC.MANDT
  • C_BANKACCOUNTTP.CASHPOOLCURRENCY == TCURC.WAERS
  • C_BANKACCOUNTTP.BANKACCOUNTCURRENCY == TCURC.WAERS
  • C_BANKACCOUNTTP.COMPANYCODECURRENCY == TCURC.WAERS
Company Contact Person
  • Client
  • Company Contact Person
  • C_BANKACCOUNTTP.MANDT == USR02.MANDT
  • C_BANKACCOUNTTP.COMPANYCONTACTPERSON == USR02.BNAME
Controlling Area
  • Client
  • Controlling Area
  • C_BANKACCOUNTTP.MANDT == TKA01.MANDT
  • C_BANKACCOUNTTP.CONTROLLINGAREA == TKA01.KOKRS
Import Method for Intraday Bank Statements
  • Import Method for Intraday Bank Statements
  • Client
Payment Method for Header Account
  • Payment Method for Header Account
  • Bank Country/Region Key
  • Client
  • C_BANKACCOUNTTP.LEADINGPAYMENTMETHOD == T042Z.ZLSCH
  • C_BANKACCOUNTTP.BANKCOUNTRY == T042Z.LAND1
  • C_BANKACCOUNTTP.MANDT == T042Z.MANDT
Payment Method for Subaccount
  • Bank Country/Region Key
  • Client
  • Payment Method for Subaccount
  • C_BANKACCOUNTTP.BANKCOUNTRY == T042Z.LAND1
  • C_BANKACCOUNTTP.MANDT == T042Z.MANDT
  • C_BANKACCOUNTTP.PARTICIPANTPAYMENTMETHOD == T042Z.ZLSCH
Payment Transaction Type Group
  • Payment Transaction Type Group
  • Client
  • C_BANKACCOUNTTP.PAYMENTTRANSACTIONTYPEGROUP == T028V.VGTYP
  • C_BANKACCOUNTTP.MANDT == T028V.MANDT
Region (State, Province, County)
  • Bank Country/Region Key
  • Client
  • Region (State, Province, County)
  • C_BANKACCOUNTTP.BANKCOUNTRY == T005S.LAND1
  • C_BANKACCOUNTTP.MANDT == T005S.MANDT
  • C_BANKACCOUNTTP.REGION == T005S.BLAND
Segment for Segmental Reporting
  • Segment for Segmental Reporting
  • Client