| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
---|
| 1 | CLIENT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | TABLENAME | Application table logical name (address management) | nvarchar | 10 | 0 | | | | Allow NULL? |
| 3 | FIELDNAME | Application table address where-used list logical field name | nvarchar | 10 | 0 | | | | Allow NULL? |
| 4 | OBJKEY | Address owner object ID | nvarchar | 70 | 0 | | | | Allow NULL? |
| 5 | DATE_FROM | Valid-from date - in current Release only 00010101 possible | nvarchar | 8 | 0 | | | | Allow NULL? |
| 6 | CONSNUMBER | Sequence Number | nvarchar | 3 | 0 | | | | Allow NULL? |
| 7 | FLGDEFAULT | Flag: this address is the default address | char | 1 | 0 | | | | Allow NULL? |
| 8 | FLG_NOUSE | Flag: This Communication Number is Not Used | char | 1 | 0 | | | | Allow NULL? |
| 9 | HOME_FLAG | Recipient address in this communication type (mail sys.grp) | char | 1 | 0 | | | | Allow NULL? |
| 10 | SMTP_ADDR | E-Mail Address | nvarchar | 241 | 0 | | | | Allow NULL? |
| 11 | SMTP_SRCH | E-Mail Address Search Field | nvarchar | 20 | 0 | | | | Allow NULL? |
| 12 | DFT_RECEIV | Flag: Recipient is standard recipient for this address | char | 1 | 0 | | | | Allow NULL? |
| 13 | R3_USER | Flag: Connected to an SAP System | char | 1 | 0 | | | | Allow NULL? |
| 14 | ENCODE | Desired Data Coding (E-Mail) | char | 1 | 0 | | | | Allow NULL? |
| 15 | TNEF | Flag: Receiver can receive TNEF coding via SMTP | char | 1 | 0 | | | | Allow NULL? |
| 16 | VALID_FROM | Communication Data: Valid From (YYYYMMDDHHMMSS) | nvarchar | 14 | 0 | | | | Allow NULL? |
| 17 | VALID_TO | Communication Data: Valid To (YYYYMMDDHHMMSS) | nvarchar | 14 | 0 | | | | Allow NULL? |