|
|
API ACR1
ACR1 - Business Partner Addresses - History Table
Business Partners - History ACRD 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 | ACRD Business Partners - History | 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 No. | 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
ACR1.Address AS 'Address Name',
ACR1.CardCode AS 'BP Code',
ACR1.Street AS 'Street',
ACR1.Block AS 'Block',
ACR1.ZipCode AS 'Zip Code',
ACR1.City AS 'City',
ACR1.County AS 'County',
ACR1.Country AS 'Country',
ACR1.State AS 'State',
ACR1.UserSign AS 'User Signature',
ACR1.LogInstanc AS 'Log Instance',
ACR1.ObjType AS 'Object Type',
ACR1.LicTradNum AS 'Federal Tax ID',
ACR1.LineNum AS 'Row No.',
ACR1.TaxCode AS 'Tax Code',
ACR1.Building AS 'Building/Floor/Room',
ACR1.AdresType AS 'Address Type',
ACR1.Address2 AS 'Address Name 2',
ACR1.Address3 AS 'Address Name 3',
ACR1.AddrType AS 'Address Type',
ACR1.StreetNo AS 'Street No.',
ACR1.AltCrdName AS 'Alternative BP Name',
ACR1.AltTaxId AS 'Alternative Tax ID',
ACR1.TaxOffice AS 'Tax Office',
ACR1.GlblLocNum AS 'Global Location Number',
ACR1.Ntnlty AS 'Nationality'
FROM ACR1 AS ACR1
Related information
Business Partners - History ACRD SQL Table
Countries OCRY SQL Table
Object Settings - History ADP1 SQL Table
Sales Tax Codes OSTC SQL Table
Users OUSR SQL Table
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
