biuan SAP® BUSINESS ONE SDK
API ABPL
ABPL - Business Place Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
BPLId KEY UNIQUEBranch IDInt
11
PRIMARYYes
BPLNameBranch NamenVarChar
100
BPLFrNameBranch Name (Foreign)nVarChar
100
VATRegNumVAT Reg. NumbernVarChar
12
RepNameRep. NamenVarChar
15
IndustryIndustrynVarChar
20
BusinessBusinessnVarChar
20
AddressAddressnVarChar
127
AddressFrAddress (Foreign)nVarChar
127
MainBPLMain BPLVarChar
Y) Main Business Place
N) Not Main Business Place
1
N
TxOffcNoTax Office No.nVarChar
3
DisabledDisabledVarChar
Y) Disabled
N) Enabled
1
N
LogInstancLog InstanceInt
11
0
UserSign2Updating UserInt
6OUSR
Users
UpdateDateUpdate DateDate
8
DflCustDefault Customer IDnVarChar
15OCRD
Business Partner
DflVendorDefault Vendor IDnVarChar
15OCRD
Business Partner
DflWhsDefault Warehouse IDnVarChar
8OWHS
Warehouses
DflTaxCodeDefault Tax CodenVarChar
8OCNA
CNAE Code
RevOfficeTax OfficenVarChar
100
TaxIdNumFederal Tax IDnVarChar
32
TaxIdNum2Federal Tax ID 2nVarChar
32
TaxIdNum3Federal Tax ID 3nVarChar
32
AddtnlIdAdditional ID NumbernVarChar
32
CompNatureNature of CompanyInt
11OBNI
Brazil Numeric Indexer
-1
EconActTEconomic Activity TypeInt
11OBNI
Brazil Numeric Indexer
-1
CredCOrigCredit Contribution OriginnVarChar
2OBSI
Brazil String Indexer
IPIPeriodIPI PeriodnVarChar
2OBSI
Brazil String Indexer
CoopAssocTCooperative Association TypeInt
11OBNI
Brazil Numeric Indexer
-1
PrefStateDefault StatenVarChar
3
ProfTaxProfit TaxationInt
11OBNI
Brazil Numeric Indexer
-1
CompQualifCompany QualificationInt
11OBNI
Brazil Numeric Indexer
-1
DeclTypeDeclarer TypeInt
11OBNI
Brazil Numeric Indexer
-1
AddrTypeAddress TypenVarChar
100
StreetStreetnVarChar
100
StreetNoStreet No.nVarChar
100
BuildingBuilding/Floor/RoomnVarChar
100
ZipCodeZip CodenVarChar
20
BlockBlocknVarChar
100
CityCitynVarChar
100
StateStatenVarChar
3OCST
States
CountyCountynVarChar
100OCNT
Counties
CountryCountrynVarChar
3OCST
States
PmtClrActPayment Clearing AccountnVarChar
15OACT
G/L Accounts
CommerRegCommercial RegisternVarChar
60
DateOfIncDate of IncorporationDate
8
SPEDProfSPED ProfilenVarChar
2OBSI
Brazil String Indexer
EnvTypeNFeEnvironment Type NFeInt
11OBNI
Brazil Numeric Indexer
-1
Opt4ICMSOpting for ICMS 115_03VarChar
1
N
AliasNameAlias NameText
16
GlblLocNumGlobal Location NumbernVarChar
50
TaxRptFrmTax Wizard Reporting FromDate
8
SuframaSUFRAMAnVarChar
100
DfltResWhsDefault Resource Warehouse IDnVarChar
8OWHS
Warehouses

Table relationship map

SELECT statement

SELECT ABPL.BPLId AS 'Branch ID', ABPL.BPLName AS 'Branch Name', ABPL.BPLFrName AS 'Branch Name (Foreign)', ABPL.VATRegNum AS 'VAT Reg. Number', ABPL.RepName AS 'Rep. Name', ABPL.Industry AS 'Industry', ABPL.Business AS 'Business', ABPL.Address AS 'Address', ABPL.AddressFr AS 'Address (Foreign)', ABPL.MainBPL AS 'Main BPL', ABPL.TxOffcNo AS 'Tax Office No.', ABPL.Disabled AS 'Disabled', ABPL.LogInstanc AS 'Log Instance', ABPL.UserSign2 AS 'Updating User', ABPL.UpdateDate AS 'Update Date', ABPL.DflCust AS 'Default Customer ID', ABPL.DflVendor AS 'Default Vendor ID', ABPL.DflWhs AS 'Default Warehouse ID', ABPL.DflTaxCode AS 'Default Tax Code', ABPL.RevOffice AS 'Tax Office', ABPL.TaxIdNum AS 'Federal Tax ID', ABPL.TaxIdNum2 AS 'Federal Tax ID 2', ABPL.TaxIdNum3 AS 'Federal Tax ID 3', ABPL.AddtnlId AS 'Additional ID Number', ABPL.CompNature AS 'Nature of Company', ABPL.EconActT AS 'Economic Activity Type', ABPL.CredCOrig AS 'Credit Contribution Origin', ABPL.IPIPeriod AS 'IPI Period', ABPL.CoopAssocT AS 'Cooperative Association Type', ABPL.PrefState AS 'Default State', ABPL.ProfTax AS 'Profit Taxation', ABPL.CompQualif AS 'Company Qualification', ABPL.DeclType AS 'Declarer Type', ABPL.AddrType AS 'Address Type', ABPL.Street AS 'Street', ABPL.StreetNo AS 'Street No.', ABPL.Building AS 'Building/Floor/Room', ABPL.ZipCode AS 'Zip Code', ABPL.Block AS 'Block', ABPL.City AS 'City', ABPL.State AS 'State', ABPL.County AS 'County', ABPL.Country AS 'Country', ABPL.PmtClrAct AS 'Payment Clearing Account', ABPL.CommerReg AS 'Commercial Register', ABPL.DateOfInc AS 'Date of Incorporation', ABPL.SPEDProf AS 'SPED Profile', ABPL.EnvTypeNFe AS 'Environment Type NFe', ABPL.Opt4ICMS AS 'Opting for ICMS 115_03', ABPL.AliasName AS 'Alias Name', ABPL.GlblLocNum AS 'Global Location Number', ABPL.TaxRptFrm AS 'Tax Wizard Reporting From', ABPL.Suframa AS 'SUFRAMA', ABPL.DfltResWhs AS 'Default Resource Warehouse ID' FROM ABPL AS ABPL

Related information


Brazil Numeric Indexer OBNI SQL Table

States OCST SQL Table

Counties OCNT SQL Table

Brazil String Indexer OBSI SQL Table

Business Partner OCRD SQL Table

CNAE Code OCNA SQL Table

Warehouses OWHS SQL Table

G/L Accounts OACT SQL Table

Users OUSR SQL Table



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