biuan SAP® BUSINESS ONE SDK
DTW Business Partners / Business Partner Master Data / Business Partners - Addresses
API Business Partners / BP Addresses
CRD1 - Business Partners - Addresses Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AddressAddress NamenVarChar
50
CardCode KEY UNIQUEBP CodenVarChar
15OCRD
Business Partner
PRIMARYYes
StreetStreetnVarChar
100
BlockBlocknVarChar
100
ZipCodeZip CodenVarChar
20
CityCitynVarChar
100
CountyCountynVarChar
100
CountryCountrynVarChar
3OCRY
Countries
StateStatenVarChar
3
UserSignUser SignatureInt
6OUSR
Users
LogInstancLog InstanceInt
11
0
ObjTypeObject TypenVarChar
20ADP1
Object Settings - History
2
LicTradNumFederal Tax IDnVarChar
32
LineNumRow NumberInt
11
TaxCodeTax CodenVarChar
8OSTC
Sales Tax Codes
BuildingBuilding/Floor/RoomText
16
AdresTypeAddress TypeVarChar
S) Ship To
B) Bill to
1
S
Address2Address Name 2nVarChar
50
Address3Address Name 3nVarChar
50
AddrTypeAddress TypenVarChar
100
StreetNoStreet No.nVarChar
100
AltCrdNameAlternative BP NamenVarChar
100
AltTaxIdAlternative Tax IDnVarChar
32
TaxOfficeTax OfficenVarChar
50
GlblLocNumGlobal Location NumbernVarChar
50
NtnltyNationalitynVarChar
100

Table relationship map

SELECT statement

SELECT CRD1.Address AS 'Address Name', CRD1.CardCode AS 'BP Code', CRD1.Street AS 'Street', CRD1.Block AS 'Block', CRD1.ZipCode AS 'Zip Code', CRD1.City AS 'City', CRD1.County AS 'County', CRD1.Country AS 'Country', CRD1.State AS 'State', CRD1.UserSign AS 'User Signature', CRD1.LogInstanc AS 'Log Instance', CRD1.ObjType AS 'Object Type', CRD1.LicTradNum AS 'Federal Tax ID', CRD1.LineNum AS 'Row Number', CRD1.TaxCode AS 'Tax Code', CRD1.Building AS 'Building/Floor/Room', CRD1.AdresType AS 'Address Type', CRD1.Address2 AS 'Address Name 2', CRD1.Address3 AS 'Address Name 3', CRD1.AddrType AS 'Address Type', CRD1.StreetNo AS 'Street No.', CRD1.AltCrdName AS 'Alternative BP Name', CRD1.AltTaxId AS 'Alternative Tax ID', CRD1.TaxOffice AS 'Tax Office', CRD1.GlblLocNum AS 'Global Location Number', CRD1.Ntnlty AS 'Nationality' FROM CRD1 AS CRD1

Related information


BP Addresses BPAddresses Object· Table: CRD1
BPAddresses is a child object of the BusinessPartners and represents the Ship To and Bill To addresses list of the business partner. This object is part of the Business Partner module. You can retrieve or set this object by using the Addresses...
   Parent: Business Partners BusinessPartners Object· Table: OCRD
Business Partner OCRD SQL Table

Countries OCRY SQL Table

Object Settings - History ADP1 SQL Table

Sales Tax Codes OSTC 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