biuan SAP® BUSINESS ONE SDK
SQL Business Partners / BP - Bank Account / Business Partner Bank Accounts - History
DTW Business Partners / Business Partner Master Data / Business Partner Bank Accounts - History
API BP Bank Accounts / Log Instance
ACRB - Business Partner Bank Accounts - History Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AbsEntry KEY UNIQUEInternal KeyInt
11
PRIMARYYes
CardCodeBP CodenVarChar
15OCRD
Business Partner
BankCodeBank CodenVarChar
30
Country KEY UNIQUECountrynVarChar
3OCRY
Countries		ACCOUNTYes
AccountAccount No.nVarChar
50
BranchBranchnVarChar
50
StreetStreetnVarChar
100
BlockBlocknVarChar
100
ZipCodeZip CodenVarChar
20
CityCitynVarChar
100
CountyCountynVarChar
100
StateStatenVarChar
3
ControlKeyControl KeynVarChar
2
UsrNumber1User No. 1nVarChar
25
UsrNumber2User No. 2nVarChar
25
UsrNumber3User No. 3nVarChar
25
UsrNumber4User No. 4nVarChar
25
IBANIBANnVarChar
50
LogInstancLog InstanceInt
11
0
BuildingBuilding/Floor/RoomText
16
AliasNameAlias NamenVarChar
50
AcctTypeAccount TypeVarChar
1
BankKeyBank Internal IDInt
11ODSC
Bank Codes
BIKBIKnVarChar
15
AcctNameBank Account NamenVarChar
127
CorresAcctCorrespondent AccountnVarChar
30
PhonePhonenVarChar
25
FaxFaxnVarChar
25
ISRTypeISR TypeInt
6
ISRBillerIISR Biller IDnVarChar
9
CustIdNumCustomer ID NumbernVarChar
6
0
AddrTypeAddress TypenVarChar
100
StreetNoStreet No.nVarChar
100
SwiftNumBIC/SWIFT CodenVarChar
50
ABARoutNumABA Routing NumbernVarChar
25
MandateIDMandate IDnVarChar
35
SignDateDate of SignatureDate
8
PWZAbsEntrPWZ ABS EntryInt
11OPWZ
Payment Wizard
BranchChkBranch Check DigitnVarChar
5
MandatDateDate Of Mandate ExpirationDate
8
SeqTypeSEPA Seq. TypenVarChar
OOFF) OOFF
FRST) FRST
RCUR) RCUR
FNAL) FNAL
4
ActTypeAccount TypeVarChar
C) Checking Account
S) Savings Account
1
IsPrenotIs PrenotificationVarChar
Y) Yes
N) No
1
N

Table relationship map

SELECT statement

SELECT ACRB.AbsEntry AS 'Internal Key', ACRB.CardCode AS 'BP Code', ACRB.BankCode AS 'Bank Code', ACRB.Country AS 'Country', ACRB.Account AS 'Account No.', ACRB.Branch AS 'Branch', ACRB.Street AS 'Street', ACRB.Block AS 'Block', ACRB.ZipCode AS 'Zip Code', ACRB.City AS 'City', ACRB.County AS 'County', ACRB.State AS 'State', ACRB.ControlKey AS 'Control Key', ACRB.UsrNumber1 AS 'User No. 1', ACRB.UsrNumber2 AS 'User No. 2', ACRB.UsrNumber3 AS 'User No. 3', ACRB.UsrNumber4 AS 'User No. 4', ACRB.IBAN AS 'IBAN', ACRB.LogInstanc AS 'Log Instance', ACRB.Building AS 'Building/Floor/Room', ACRB.AliasName AS 'Alias Name', ACRB.AcctType AS 'Account Type', ACRB.BankKey AS 'Bank Internal ID', ACRB.BIK AS 'BIK', ACRB.AcctName AS 'Bank Account Name', ACRB.CorresAcct AS 'Correspondent Account', ACRB.Phone AS 'Phone', ACRB.Fax AS 'Fax', ACRB.ISRType AS 'ISR Type', ACRB.ISRBillerI AS 'ISR Biller ID', ACRB.CustIdNum AS 'Customer ID Number', ACRB.AddrType AS 'Address Type', ACRB.StreetNo AS 'Street No.', ACRB.SwiftNum AS 'BIC/SWIFT Code', ACRB.ABARoutNum AS 'ABA Routing Number', ACRB.MandateID AS 'Mandate ID', ACRB.SignDate AS 'Date of Signature', ACRB.PWZAbsEntr AS 'PWZ ABS Entry', ACRB.BranchChk AS 'Branch Check Digit', ACRB.MandatDate AS 'Date Of Mandate Expiration', ACRB.SeqType AS 'SEPA Seq. Type', ACRB.ActType AS 'Account Type', ACRB.IsPrenot AS 'Is Prenotification' FROM ACRB AS ACRB

Related information


Log Instance LogInstance Property· Table: ACRB
Sets or returns the key identifier of the log instance. Each activity with the BPBankAccount is logged to the ACRB log table with the LogInstance identifier.Field name: LogInstanc.Length: 3 characters.
· Table: OCRB    Parent: BP Bank Accounts BPBankAccounts Object· Table: OCRB
Bank Codes ODSC SQL Table

Business Partner OCRD SQL Table

Countries OCRY SQL Table

Payment Wizard OPWZ SQL Table
SAP® Business One is the trademark(s) or registered trademark(s) of SAP AG in Germany and in several other countries. Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates