C_BankAccountWithRevision

Bank Account With Revision | view: CBANKACCTWITHREV | Extraction: Not supported | Component: Bank Account Management
Tables used: ADCP, ADRC, ADR6, ADR3, ADR12, ADR2, BNKA, FCLM_BAM_AMD_T, FCLM_BAM_AMD, FCLM_BAM_REV, BUT000, BUT020, T001, TKA02, T005, T005T, FCLM_BAM_AMD
Column Name Description
BankAccountInternalID Bank Account Technical ID
BankAccountRevision Revision Number
Column Name Description
DifferenceAmount FTE_BSM: Difference Amount Permitted in Account Currency
💲 Currency Key (BankAccountCurrency):
MaxTargetAmount Target Balance for Subaccount
MinTargetAmount Minimum Target Amount for Subaccount
MinTransferAmount Minimum Transfer Amount for Subaccount
Column Name Description
Column Name Description
ValidityStartDate Bank Account Opening Date
ValidityEndDate Bank Account Closing Date
BankStatementCheckTime Bank Statement Check Time
DomesticCutOffTime Cut-Off Time Domestic
CrossBorderCutOffTime Cut-Off Time Cross Border
PlannedClosingDate Planned Closing Date
CreationDate Bank Account Created On
CreationTime Created At
OpenedDate Bank Account: Openned On
LastChangeDate Changed On
LastChangeTime Changed At
ClosedDate Closed On
ClosedTime Closed At
IBANValidityStartDate IBAN Valid From
FormPrintDate null
Column Name Description
BankAccountStatus Bank Account Status Show values
BankStatementImportChannel Bank Statement Importing Channel Show values
IsUploadOfIntraDayStatement Upload of Intraday Statements 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
Column Name Description Domain name
BankAccountDescription Account Description TEXT60
BankAccountNumber Bank Account Number FCLM_BAM_ACC_NUM
IBAN IBAN (International Bank Account Number) IBAN
LeadingCashPoolID Cash Pool ID FCLM_BAM_CASH_POOL_ID
ProfitCenter Profit Center PRCTR
BankAccountHolderName Bank Account Holder TEXT60
BankContactPerson General Contact Person at Bank BU_PARTNER
BankRelationshipManager Bank Relationship Manager BU_PARTNER
CreatedByUser Created By XUBNAME
OpenedByUser Bank Account: Opened By XUBNAME
LastChangedByUser Changed By XUBNAME
ReviewedByUser Bank Account Master Record Reviewed By XUBNAME
ClosedByUser Closed By XUBNAME
BankControlKey Bank Control Key BKONT
ArchObjectNumber Object number J_OBJNR
ExpectedInterval Interval for Expected Bank Statements NUMC2
FactoryCalendar Factory Calendar WFCID
DisplayItem FTE-BSM: Display Item in Bank Statement Monitor NUMC3
ParticipantCashPoolID Cash Pool for Subaccount FCLM_BAM_CASH_POOL_ID
PaymentServiceProvider Payment Service Provider for Digital Payments DP_PAYMENT_SERVICE_PROVIDER
BankAddressID Address Number AD_ADDRNUM
BankName Name of Financial Institution TEXT60
BankBranch Bank Branch TEXT40
ShortStreetName Street and House Number TEXT35
ShortCityName City TEXT35
CountryName Country/Region Name TEXT50
District District TEXT40
PostalCode City postal code CHAR10
HouseNumber House Number TEXT10
HouseNumberSupplementText House number supplement TEXT10
Building Building (Number or Code) TEXT20
Floor Floor in building TEXT10
RoomNumber Room or Apartment Number TEXT10
PhoneNumber First telephone no.: dialling code+number CHAR30
FaxNumber First Fax No.: Area Code + Number CHAR30
EmailAddress E-Mail Address AD_SMTPADR
CompanyCodeName Name of Company Code or Company TEXT25
CompanyStreetName Street TEXT60
CompanyPostalCode City postal code CHAR10
CompanyCodeCityName City TEXT40
CompanyDistrict District TEXT40
CompanyHouseNumber House Number TEXT10
CompanyBuilding Building (Number or Code) TEXT20
CompanyFloor Floor in building TEXT10
CompanyRoomNumber Room or Apartment Number TEXT10
CompanyPhoneNumber First telephone no.: dialling code+number CHAR30
CompanyFaxNumber First Fax No.: Area Code + Number CHAR30
CompanyCountryName Country/Region Name TEXT50
CompanyEmailAddress E-Mail Address AD_SMTPADR
BusinessPartnerName null
BusinessPartnerFullName null
PersonFullName Full Name TEXT80
BusinessPartnerCityName City TEXT40
BusinessPartnerDistrict District TEXT40
BusinessPartnerPostalCode City postal code CHAR10
BusinessPartnerStreetName Street TEXT60
BusinessPartnerHouseNumber House Number TEXT10
BusinessPartnerCountryName Country/Region Name TEXT50
BusinessPartnerPhoneNumber null
BusinessPartnerFaxNumber null
BusinessPartnerEmailAddress null
CompanyAddressID Address ADRNR
Master Data Relations Join Conditions
Bank Key
  • Bank Country/Region Key
  • Bank Key
  • Client
  • C_BANKACCOUNTWITHREVISION.BANKCOUNTRY == BNKA.BANKS
  • C_BANKACCOUNTWITHREVISION.BANK == BNKA.BANKL
  • C_BANKACCOUNTWITHREVISION.MANDT == BNKA.MANDT
Currency Key
  • Client
  • Currency Key
  • C_BANKACCOUNTWITHREVISION.MANDT == TCURC.MANDT
  • C_BANKACCOUNTWITHREVISION.BANKACCOUNTCURRENCY == TCURC.WAERS
Bank Account Supervisor
  • Bank Account Supervisor
  • Client
  • C_BANKACCOUNTWITHREVISION.BANKACCOUNTSUPERVISOR == USR02.BNAME
  • C_BANKACCOUNTWITHREVISION.MANDT == USR02.MANDT
Bank Account Type ID
  • Bank Account Type ID
  • Client
Bank Country/Region Key
  • Bank Country/Region Key
  • Client
  • C_BANKACCOUNTWITHREVISION.BANKCOUNTRY == T005.LAND1
  • C_BANKACCOUNTWITHREVISION.MANDT == T005.MANDT
Import Method for End-of-Day Bank Statements
  • Import Method for End-of-Day Bank Statements
  • Client
Region code
  • Country/Region Key
  • Country/Region Key
  • Client
  • Region (State, Province, County)
  • Region (State, Province, County)
  • Region (State, Province, County)
  • C_BANKACCOUNTWITHREVISION.BUSINESSPARTNERCOUNTRY == T005S.LAND1
  • C_BANKACCOUNTWITHREVISION.COMPANYCODECOUNTRY == T005S.LAND1
  • C_BANKACCOUNTWITHREVISION.MANDT == T005S.MANDT
  • C_BANKACCOUNTWITHREVISION.COMPANYREGION == T005S.BLAND
  • C_BANKACCOUNTWITHREVISION.BPRGN == T005S.BLAND
  • C_BANKACCOUNTWITHREVISION.REGION == T005S.BLAND
Business Area
  • Client
  • Business Area
  • C_BANKACCOUNTWITHREVISION.MANDT == TGSB.MANDT
  • C_BANKACCOUNTWITHREVISION.BUSINESSAREA == TGSB.GSBER
Country key
  • Country/Region Key
  • Country/Region Key
  • Client
  • C_BANKACCOUNTWITHREVISION.BUSINESSPARTNERCOUNTRY == T005.LAND1
  • C_BANKACCOUNTWITHREVISION.COMPANYCODECOUNTRY == T005.LAND1
  • C_BANKACCOUNTWITHREVISION.MANDT == T005.MANDT
Company Code
  • Company Code
  • Client
  • C_BANKACCOUNTWITHREVISION.COMPANYCODE == T001.BUKRS
  • C_BANKACCOUNTWITHREVISION.MANDT == T001.MANDT
Country key
  • Country/Region Key
  • Country/Region Key
  • Client
  • C_BANKACCOUNTWITHREVISION.BUSINESSPARTNERCOUNTRY == T005.LAND1
  • C_BANKACCOUNTWITHREVISION.COMPANYCODECOUNTRY == T005.LAND1
  • C_BANKACCOUNTWITHREVISION.MANDT == T005.MANDT
Company Contact Person
  • Client
  • Company Contact Person
  • C_BANKACCOUNTWITHREVISION.MANDT == USR02.MANDT
  • C_BANKACCOUNTWITHREVISION.COMPANYCONTACTPERSON == USR02.BNAME
Version ID for International Addresses
  • Version ID for International Addresses
  • Version ID for International Addresses
  • C_BANKACCOUNTWITHREVISION.COMPANYNATION == TSADV.NATION
  • C_BANKACCOUNTWITHREVISION.NATION == TSADV.NATION
Region code
  • Country/Region Key
  • Country/Region Key
  • Client
  • Region (State, Province, County)
  • Region (State, Province, County)
  • Region (State, Province, County)
  • C_BANKACCOUNTWITHREVISION.BUSINESSPARTNERCOUNTRY == T005S.LAND1
  • C_BANKACCOUNTWITHREVISION.COMPANYCODECOUNTRY == T005S.LAND1
  • C_BANKACCOUNTWITHREVISION.MANDT == T005S.MANDT
  • C_BANKACCOUNTWITHREVISION.COMPANYREGION == T005S.BLAND
  • C_BANKACCOUNTWITHREVISION.BPRGN == T005S.BLAND
  • C_BANKACCOUNTWITHREVISION.REGION == T005S.BLAND
Form-of-Address Key
  • Form-of-Address Key
  • Client
  • C_BANKACCOUNTWITHREVISION.FORMOFADDRESS == TSAD3.TITLE
  • C_BANKACCOUNTWITHREVISION.MANDT == TSAD3.CLIENT
Import Method for Intraday Bank Statements
  • Import Method for Intraday Bank Statements
  • Client
  • C_BANKACCOUNTWITHREVISION.INTRADAYBANKSTATEIMPORTMETHOD == FCLM_BAM_BSIMP.IMPORT_TYPE
  • C_BANKACCOUNTWITHREVISION.MANDT == FCLM_BAM_BSIMP.MANDT
Payment Method for Header Account
  • Bank Country/Region Key
  • Client
  • Payment Method for Header Account
  • C_BANKACCOUNTWITHREVISION.BANKCOUNTRY == T042Z.LAND1
  • C_BANKACCOUNTWITHREVISION.MANDT == T042Z.MANDT
  • C_BANKACCOUNTWITHREVISION.LEADINGPAYMENTMETHOD == T042Z.ZLSCH
Version ID for International Addresses
  • Version ID for International Addresses
  • Version ID for International Addresses
  • C_BANKACCOUNTWITHREVISION.COMPANYNATION == TSADV.NATION
  • C_BANKACCOUNTWITHREVISION.NATION == TSADV.NATION
Payment Method for Subaccount
  • Bank Country/Region Key
  • Payment Method for Subaccount
  • Client
  • C_BANKACCOUNTWITHREVISION.BANKCOUNTRY == T042Z.LAND1
  • C_BANKACCOUNTWITHREVISION.PARTICIPANTPAYMENTMETHOD == T042Z.ZLSCH
  • C_BANKACCOUNTWITHREVISION.MANDT == T042Z.MANDT
Payment Transaction Type Group
  • Payment Transaction Type Group
  • Client
  • C_BANKACCOUNTWITHREVISION.PAYMENTTRANSACTIONTYPEGROUP == T028V.VGTYP
  • C_BANKACCOUNTWITHREVISION.MANDT == T028V.MANDT
Region code
  • Country/Region Key
  • Country/Region Key
  • Client
  • Region (State, Province, County)
  • Region (State, Province, County)
  • Region (State, Province, County)
  • C_BANKACCOUNTWITHREVISION.BUSINESSPARTNERCOUNTRY == T005S.LAND1
  • C_BANKACCOUNTWITHREVISION.COMPANYCODECOUNTRY == T005S.LAND1
  • C_BANKACCOUNTWITHREVISION.MANDT == T005S.MANDT
  • C_BANKACCOUNTWITHREVISION.COMPANYREGION == T005S.BLAND
  • C_BANKACCOUNTWITHREVISION.BPRGN == T005S.BLAND
  • C_BANKACCOUNTWITHREVISION.REGION == T005S.BLAND
Segment for Segmental Reporting
  • Segment for Segmental Reporting
  • Client
  • C_BANKACCOUNTWITHREVISION.SEGMENT == FAGL_SEGM.SEGMENT
  • C_BANKACCOUNTWITHREVISION.MANDT == FAGL_SEGM.MANDT