| 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 | * | MANDT | Allow NULL? |
| 2 | DOKAR | Document Type | nvarchar | 3 | 0 | CHAR | (N' ') | No | * | N2_DOKART | Allow NULL? |
| 3 | DOKNR | Document number | nvarchar | 25 | 0 | CHAR | (N' ') | No | * | DOKNR | Allow NULL? |
| 4 | DOKVR | Document Version | nvarchar | 2 | 0 | CHAR | (N' ') | No | | DOKVR | Allow NULL? |
| 5 | DOKTL | Document Part | nvarchar | 3 | 0 | CHAR | (N' ') | No | | DOKTL_D | Allow NULL? |
| 6 | LFDEM | Recipient SeqNo | nvarchar | 5 | 0 | NUMC | (N'00000') | No | | N2_LFDEM | Allow NULL? |
| 7 | ATTYP | Address Type: Type (Key) | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | N2_ATTYP | Allow NULL? |
| 8 | RECART | Recipient Type | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | N2_RECART | Allow NULL? |
| 9 | VSART | Dispatch Type - Key | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | N2_VERSART | Allow NULL? |
| 10 | ANTXT | IS-H: Form-of-Address Text | nvarchar | 25 | 0 | CHAR | (N' ') | Yes | | RI_ANTXT | Allow NULL? |
| 11 | TITEL | IS-H: Title | nvarchar | 15 | 0 | CHAR | (N' ') | Yes | * | RI_TITEL | Allow NULL? |
| 12 | NAME1 | IS-H: Last Name/ 1st Name | nvarchar | 35 | 0 | CHAR | (N' ') | Yes | | GPNAM1 | Allow NULL? |
| 13 | NAME2 | First Name / Second Name | nvarchar | 35 | 0 | CHAR | (N' ') | Yes | | GPNAM2 | Allow NULL? |
| 14 | NAME3 | Third Name | nvarchar | 35 | 0 | CHAR | (N' ') | Yes | | GPNAM3 | Allow NULL? |
| 15 | STRAS | IS-H: Street Name and Street Number of Business Partner | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | STRASSE_GP | Allow NULL? |
| 16 | PSTLZ | IS-H: Postal Code of Business Partner | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | PSTLZ_GP | Allow NULL? |
| 17 | ORT | IS-H: City of Business Partner | nvarchar | 25 | 0 | CHAR | (N' ') | Yes | | ORT_GP | Allow NULL? |
| 18 | LAND | IS-H: Country of Business Partner | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | * | LAND_GP | Allow NULL? |
| 19 | TELNR | IS-H: Telephone Number of Business Partner | nvarchar | 16 | 0 | CHAR | (N' ') | Yes | | TELEFON_GP | Allow NULL? |
| 20 | TELFX | Fax Number of Business Partner | nvarchar | 31 | 0 | CHAR | (N' ') | Yes | | TELEFAX_GP | Allow NULL? |
| 21 | EMAIL | IS-H: Internet Mail (SMTP) Address | nvarchar | 241 | 0 | CHAR | (N' ') | Yes | | ISH_SMTPADR | Allow NULL? |
| 22 | GPART | IS-H: Business Partner | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | GPARTNER | Allow NULL? |
| 23 | ORGID | Identification Key of Organizational Unit | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | * | ORGID | Allow NULL? |
| 24 | AKTAG | Spool: Output device | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | RSPOPNAME | Allow NULL? |
| 25 | ANZKP | Number of Spool Copies | nvarchar | 3 | 0 | NUMC | (N'000') | Yes | | SYPRCOP | Allow NULL? |
| 26 | ERDAT | IS-H: Date when Record Created | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | RI_ERDAT | Allow NULL? |
| 27 | ERNAM | IS-H: Name of Employee who Created Record | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | RI_ERNAM | Allow NULL? |
| 28 | UPDAT | IS-H: Date of Last Change | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | RI_UPDAT | Allow NULL? |
| 29 | UPNAM | IS-H: Name of Person who Last Changed Data | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | RI_UPNAM | Allow NULL? |
| 30 | STORN | IS-H: Cancellation Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | RI_STORN | Allow NULL? |
| 31 | STDAT | IS-H: Cancellation Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | STORNO_DAT | Allow NULL? |
| 32 | STNAM | IS-H: Name of User who Canceled Data Record | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | STORN_USER | Allow NULL? |
