C_BankAccountTP

Bank Account Administrative Data | view: CBANKACCOUNTTP | Extraction: Not supported | Component: Bank Account Management

Tables used: 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_AC_TYPE, FCLM_BAM_REVIWER, 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, USR21

🔑 Keys (2)
💰 Amounts (4)
∑ Quantities
📅 Dates (16)
☰ Categorical (29)
Other (75)
🔗 Relations (19)

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	`C_BANKACCOUNTTP.BANKACCOUNTTYPE == FCLM_BAM_AC_TYPE.ACC_TYPE_ID` `C_BANKACCOUNTTP.MANDT == FCLM_BAM_AC_TYPE.MANDT`
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	`C_BANKACCOUNTTP.BANKSTATEMENTIMPORTMETHOD == FCLM_BAM_BSIMP.IMPORT_TYPE` `C_BANKACCOUNTTP.MANDT == FCLM_BAM_BSIMP.MANDT`
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	`C_BANKACCOUNTTP.INTRADAYBANKSTATEIMPORTMETHOD == FCLM_BAM_BSIMP.IMPORT_TYPE` `C_BANKACCOUNTTP.MANDT == FCLM_BAM_BSIMP.MANDT`
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	`C_BANKACCOUNTTP.SEGMENT == FAGL_SEGM.SEGMENT` `C_BANKACCOUNTTP.MANDT == FAGL_SEGM.MANDT`