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

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AbsEntry KEY UNIQUEInternal KeyInt
11
ABSENTRYYes
CardCodeBP CodenVarChar
15OCRD
Business Partner
BankCodeBank CodenVarChar
30
Country KEY UNIQUECountrynVarChar
3OCRY
Countries		PRIMARYYes
AccountAccount No.nVarChar
50
BranchBranchnVarChar
50
StreetStreetnVarChar
100
BlockBlocknVarChar
100
ZipCodeZip CodenVarChar
20
CityCitynVarChar
100
CountyCountynVarChar
100
StateStatenVarChar
3
ControlKeyCtrl Int. IDnVarChar
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
1) ISR
2) BISR
3) ISR+
4) BISR+
6
2
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 OCRB.AbsEntry AS 'Internal Key', OCRB.CardCode AS 'BP Code', OCRB.BankCode AS 'Bank Code', OCRB.Country AS 'Country', OCRB.Account AS 'Account No.', OCRB.Branch AS 'Branch', OCRB.Street AS 'Street', OCRB.Block AS 'Block', OCRB.ZipCode AS 'Zip Code', OCRB.City AS 'City', OCRB.County AS 'County', OCRB.State AS 'State', OCRB.ControlKey AS 'Ctrl Int. ID', OCRB.UsrNumber1 AS 'User No. 1', OCRB.UsrNumber2 AS 'User No. 2', OCRB.UsrNumber3 AS 'User No. 3', OCRB.UsrNumber4 AS 'User No. 4', OCRB.IBAN AS 'IBAN', OCRB.LogInstanc AS 'Log Instance', OCRB.Building AS 'Building/Floor/Room', OCRB.AliasName AS 'Alias Name', OCRB.AcctType AS 'Account Type', OCRB.BankKey AS 'Bank Internal ID', OCRB.BIK AS 'BIK', OCRB.AcctName AS 'Bank Account Name', OCRB.CorresAcct AS 'Correspondent Account', OCRB.Phone AS 'Phone', OCRB.Fax AS 'Fax', OCRB.ISRType AS 'ISR Type', OCRB.ISRBillerI AS 'ISR Biller ID', OCRB.CustIdNum AS 'Customer ID Number', OCRB.AddrType AS 'Address Type', OCRB.StreetNo AS 'Street No.', OCRB.SwiftNum AS 'BIC/SWIFT Code', OCRB.ABARoutNum AS 'ABA Routing Number', OCRB.MandateID AS 'Mandate ID', OCRB.SignDate AS 'Date of Signature', OCRB.PWZAbsEntr AS 'PWZ ABS Entry', OCRB.BranchChk AS 'Branch Check Digit', OCRB.MandatDate AS 'Date Of Mandate Expiration', OCRB.SeqType AS 'SEPA Seq. Type', OCRB.ActType AS 'Account Type', OCRB.IsPrenot AS 'Is Prenotification' FROM OCRB AS OCRB

Related information


BP Bank Accounts BPBankAccounts Object· Table: OCRB
BPBankAccounts is a business object that represents the bank accounts of the business partner. Source table: OCRB.
   Parent: Business Partners BusinessPartners Object· Table: OCRD
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