| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | T000 | MANDT | Allow NULL? |
| 2 | LISTNR | Number of the Address List | nvarchar | 10 | 0 | CHAR | (N' ') | No | SADLSTIAD | KTANR | Allow NULL? |
| 3 | VERSION | Version number | nvarchar | 4 | 0 | NUMC | (N'0000') | No | SADLSTIAD | CASVERSION | Allow NULL? |
| 4 | BLKNR | CAS usage: Address interval number | nvarchar | 6 | 0 | CHAR | (N' ') | No | SADLSTIAD | CASBLKNR | Allow NULL? |
| 5 | SORT_HIGH1 | Sort key for addresses in a list | nvarchar | 35 | 0 | CHAR | (N' ') | Yes | | CASCHAR35 | Allow NULL? |
| 6 | SORT_HIGH2 | Sort key for addresses in a list | nvarchar | 35 | 0 | CHAR | (N' ') | Yes | | CASCHAR35 | Allow NULL? |
| 7 | SORT_HIGH3 | Sort key for addresses in a list | nvarchar | 35 | 0 | CHAR | (N' ') | Yes | | CASCHAR35 | Allow NULL? |
| 8 | BNRARTHIGH | Type of partner number | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | TVPA | NRART | Allow NULL? |
| 9 | BPARNRHIGH | Partner number (KUNNR, LIFNR, or PERNR) | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | KUNDE_D | Allow NULL? |
| 10 | SORT_LOW1 | Sort key for addresses in a list | nvarchar | 35 | 0 | CHAR | (N' ') | Yes | | CASCHAR35 | Allow NULL? |
| 11 | SORT_LOW2 | Sort key for addresses in a list | nvarchar | 35 | 0 | CHAR | (N' ') | Yes | | CASCHAR35 | Allow NULL? |
| 12 | SORT_LOW3 | Sort key for addresses in a list | nvarchar | 35 | 0 | CHAR | (N' ') | Yes | | CASCHAR35 | Allow NULL? |
| 13 | MANKZ | Use in CAS: Indicator "edited manually" | char | 1 | 0 | CHAR | (N' ') | Yes | | CASMANKZ | Allow NULL? |
| 14 | STATUS | Use in CAS: Status flag for address area | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | CASISTATUS | Allow NULL? |