|
|
DTW Business Partners / Business Partner Master Data / Business Partners - Addresses
API Business Partners / BP Addresses
CRD1 - Business Partners - Addresses Table
BP Addresses BPAddresses Object· Table: CRD1
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
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | Address | Address Name | nVarChar | 50 |
|---|---|---|---|---|---|---|---|---|
| CardCode KEY UNIQUE | BP Code | nVarChar | 15 | OCRD Business Partner | PRIMARY | Yes | ||
| Street | Street | nVarChar | 100 | |||||
| Block | Block | nVarChar | 100 | |||||
| ZipCode | Zip Code | nVarChar | 20 | |||||
| City | City | nVarChar | 100 | |||||
| County | County | nVarChar | 100 | |||||
| Country | Country | nVarChar | 3 | OCRY Countries | ||||
| State | State | nVarChar | 3 | |||||
| UserSign | User Signature | Int | 6 | OUSR Users | ||||
| LogInstanc | Log Instance | Int | 11 | 0 | ||||
| ObjType | Object Type | nVarChar | 20 | ADP1 Object Settings - History | 2 | |||
| LicTradNum | Federal Tax ID | nVarChar | 32 | |||||
| LineNum | Row Number | Int | 11 | |||||
| TaxCode | Tax Code | nVarChar | 8 | OSTC Sales Tax Codes | ||||
| Building | Building/Floor/Room | Text | 16 | |||||
| AdresType | Address Type | VarChar | S) Ship To B) Bill to | 1 | S | |||
| Address2 | Address Name 2 | nVarChar | 50 | |||||
| Address3 | Address Name 3 | nVarChar | 50 | |||||
| AddrType | Address Type | nVarChar | 100 | |||||
| StreetNo | Street No. | nVarChar | 100 | |||||
| AltCrdName | Alternative BP Name | nVarChar | 100 | |||||
| AltTaxId | Alternative Tax ID | nVarChar | 32 | |||||
| TaxOffice | Tax Office | nVarChar | 50 | |||||
| GlblLocNum | Global Location Number | nVarChar | 50 | |||||
| Ntnlty | Nationality | nVarChar | 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
BusinessPartners
Object
BPAddresses
Method
Property
AddressName
DTW DB
AddressName2
DTW DB
AddressName3
DTW DB
AddressType
DTW DB
Block
DTW DB
BuildingFloorRoom
DTW DB
City
DTW DB
Country
DTW DB
County
DTW DB
FederalTaxID
DTW DB
State
DTW DB
Street
DTW DB
StreetNo
DTW DB
TaxCode
DTW DB
TypeOfAddress
DTW DB
ZipCode
DTW DB
Collection
Enumeration
Method
Object
CashDiscount OCDC
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
