|
|
DTW Administration / Setup / Purchasing / Address Formats
API Country / Address Format
OADF - Address Formats Table
Address Format AddressFormat Property· Table: OADF
Parent: Country Country Object· Table: OCRY
OADF SQL Table
Users OUSR SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | Code KEY UNIQUE | Code | Int | 6 | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| Name KEY UNIQUE | Name | nVarChar | 50 | ADF_NAME | Yes | |||
| Format | Format | nVarChar | 100 | |||||
| UserSign | User Signature | Int | 6 | OUSR Users |
Table relationship map
SELECT statement
SELECT
OADF.Code AS 'Code',
OADF.Name AS 'Name',
OADF.Format AS 'Format',
OADF.UserSign AS 'User Signature'
FROM OADF AS OADF
Related information
Address Format AddressFormat Property· Table: OADF
Sets or returns the postal address format used by the country. The postal address format must be already presented in the Address Formats table (foreign key to OADF).
Field name: AddrFormat.
Parent: Country Country Object· Table: OCRY OADF SQL Table
Users OUSR SQL Table
Country
Property
AddressFormat
Enumeration
Method
Property
Code
DB
Name
DB
Collection
Enumeration
Method
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
