| Column | Field | Description | SQL Type | Length | Decimals | Relation | Default Value | Constraints | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | | | | Allow NULL? |
| 2 | RANTYP | Contract Type | char | 1 | 0 | | | | Allow NULL? |
| 3 | KORRVORF | Correspondence activity | nvarchar | 4 | 0 | | | | Allow NULL? |
| 4 | LFDNR | Sequence no. | nvarchar | 3 | 0 | | | | Allow NULL? |
| 5 | APPL | Application Category | nvarchar | 4 | 0 | | | | Allow NULL? |
| 6 | ROLE_ORIG | Role of original addressee | nvarchar | 4 | 0 | | | | Allow NULL? |
| 7 | ROLETYP | Business Partner Role Category | nvarchar | 4 | 0 | | | | Allow NULL? |
| 8 | ROLE | Business Partner Role Type | nvarchar | 4 | 0 | | | | Allow NULL? |
| 9 | ROLETYPEMP | Role category of clerk | nvarchar | 4 | 0 | | | | Allow NULL? |
| 10 | SUBANWDG | Document group | nvarchar | 4 | 0 | | | | Allow NULL? |
| 11 | BRFNM | Letter Name | nvarchar | 15 | 0 | | | | Allow NULL? |
| 12 | DUMMY2 | Dummy, undefined field consisting of 2 digits | nvarchar | 2 | 0 | | | | Allow NULL? |
| 13 | SKZA | Expand partner relationship (yes/no) | char | 1 | 0 | | | | Allow NULL? |
| 14 | AUSWAHL | Selection indicator | char | 1 | 0 | | | | Allow NULL? |
| 15 | EDITIERBAR | Output to text processing interface (yes/no)? | char | 1 | 0 | | | | Allow NULL? |
| 16 | JBSTAUSW | Text module selection ? | char | 1 | 0 | | | | Allow NULL? |
| 17 | JSPFB | Spool control screen Yes/No ? | char | 1 | 0 | | | | Allow NULL? |
| 18 | VLISTE | Distribution list: Yes/no? | char | 1 | 0 | | | | Allow NULL? |
| 19 | TDPAGESLCT | Pages selected for printing | nvarchar | 60 | 0 | | | | Allow NULL? |
| 20 | TDCOPIES | Number of copies | tinyint | 3 | 0 | | | | |
| 21 | TDDEST | Spool: Output device | nvarchar | 4 | 0 | | | | Allow NULL? |
| 22 | TDPREVIEW | Print preview | char | 1 | 0 | | | | Allow NULL? |
| 23 | TDNOPREV | No print preview | char | 1 | 0 | | | | Allow NULL? |
| 24 | TDNOPRINT | No printing from print preview | char | 1 | 0 | | | | Allow NULL? |
| 25 | TDNEWID | New Spool Request | char | 1 | 0 | | | | Allow NULL? |
| 26 | TDPAGEFORM | Spool: Page format | nvarchar | 8 | 0 | | | | Allow NULL? |
| 27 | TDDATASET | Spool request: Name | nvarchar | 6 | 0 | | | | Allow NULL? |
| 28 | TDSUFFIX1 | Spool request: Suffix 1 | nvarchar | 4 | 0 | | | | Allow NULL? |
| 29 | TDSUFFIX2 | Spool request: Suffix 2 | nvarchar | 12 | 0 | | | | Allow NULL? |
| 30 | TDIMMED | Immediate Spool Print | char | 1 | 0 | | | | Allow NULL? |
| 31 | TDDELETE | Immediate Spool Deletion | char | 1 | 0 | | | | Allow NULL? |
| 32 | TDLIFETIME | Spool Retention Period | char | 1 | 0 | | | | Allow NULL? |
| 33 | TDSCHEDULE | Send time request | nvarchar | 3 | 0 | | | | Allow NULL? |
| 34 | TDSENDDATE | Requested send date | nvarchar | 8 | 0 | | | | Allow NULL? |
| 35 | TDSENDTIME | Requested send time | nvarchar | 6 | 0 | | | | Allow NULL? |
| 36 | TDTELELAND | Country Key | nvarchar | 3 | 0 | | | | Allow NULL? |
| 37 | TDTELENUM | Telecommunications partner | nvarchar | 30 | 0 | | | | Allow NULL? |
| 38 | TDTELENUME | Telecommunications partner | nvarchar | 30 | 0 | | | | Allow NULL? |
| 39 | TDTITLE | Title in dialog box | nvarchar | 50 | 0 | | | | Allow NULL? |
| 40 | TDAPPL | Text editor: Interface for different applications | nvarchar | 2 | 0 | | | | Allow NULL? |
| 41 | TDPRINTER | Spool: Device type name | nvarchar | 8 | 0 | | | | Allow NULL? |
| 42 | TDDRIVER | Spool: Driver name | nvarchar | 4 | 0 | | | | Allow NULL? |
| 43 | TDABAP | Spool: Driver is ABAP function module | char | 1 | 0 | | | | Allow NULL? |
| 44 | TDOTFCALL | OTF ABAP driver function module | nvarchar | 30 | 0 | | | | Allow NULL? |
| 45 | TDOTFTYPE | OTF type | nvarchar | 12 | 0 | | | | Allow NULL? |
| 46 | TDSPOOLID | Spool request number | int | 10 | 0 | | | | Allow NULL? |
| 47 | TDFAXID | Object: Number from ID | nvarchar | 12 | 0 | | | | Allow NULL? |
| 48 | TDMAILID | Object: Number from ID | nvarchar | 12 | 0 | | | | Allow NULL? |
| 49 | TDPAGES | No. of pages output | nvarchar | 5 | 0 | | | | Allow NULL? |
| 50 | TDFORMS | Number of Forms Output | nvarchar | 3 | 0 | | | | Allow NULL? |
| 51 | TDDEVICE | Output device | nvarchar | 8 | 0 | | | | Allow NULL? |
| 52 | TDWARNINGS | Number of Warnings | nvarchar | 5 | 0 | | | | Allow NULL? |
| 53 | TDSCREEN | SAPscript: name of screen type | nvarchar | 8 | 0 | | | | Allow NULL? |
| 54 | TDSCDRIVER | Screen driver | nvarchar | 4 | 0 | | | | Allow NULL? |
| 55 | TDSCABAP | Screen driver is in ABAP/4 | char | 1 | 0 | | | | Allow NULL? |
| 56 | TDPROGRAM | Program Name | nvarchar | 40 | 0 | | | | Allow NULL? |
| 57 | TDTEST | Test form | char | 1 | 0 | | | | Allow NULL? |
| 58 | TDSCRNPOS | Screen display position for OTF | nvarchar | 15 | 0 | | | | Allow NULL? |
| 59 | TDCOVER | Print: SAP cover page | char | 1 | 0 | | | | Allow NULL? |
| 60 | TDCOVTITLE | Spool Description | nvarchar | 68 | 0 | | | | Allow NULL? |
| 61 | TDRECEIVER | Spool Recipient Name | nvarchar | 12 | 0 | | | | Allow NULL? |
| 62 | TDDIVISION | Spool Department Name | nvarchar | 12 | 0 | | | | Allow NULL? |
| 63 | TDAUTORITY | Print: Authorization | nvarchar | 12 | 0 | | | | Allow NULL? |
| 64 | TDARMOD | Print: Archiving mode | char | 1 | 0 | | | | Allow NULL? |
| 65 | TDIEXIT | Immediate exit after printing/faxing from print preview | char | 1 | 0 | | | | Allow NULL? |
| 66 | USEREXIT | User function last executed | char | 1 | 0 | | | | Allow NULL? |
| 67 | TDGETOTF | Return of OTF table. No printing, display, or faxing | char | 1 | 0 | | | | Allow NULL? |
| 68 | TDRTL | A right-to-left language occurs in the OTF | char | 1 | 0 | | | | Allow NULL? |
| 69 | FAXFORMAT | 3-Byte field | nvarchar | 3 | 0 | | | | Allow NULL? |
| 70 | TDFAXUSER | SAPoffice user name | nvarchar | 12 | 0 | | | | Allow NULL? |
| 71 | RQPOSNAME | Spool: Long name of printers for host spooler | nvarchar | 50 | 0 | | | | Allow NULL? |
| 72 | TDFINAL | Spool request completed | char | 1 | 0 | | | | Allow NULL? |
| 73 | BCS_REQST | Requested Status | char | 1 | 0 | | | | Allow NULL? |
| 74 | BCS_STATUS | Setting for Which Statuses Are Reported by Mail | char | 1 | 0 | | | | Allow NULL? |
| 75 | BZTYP | Business Partner Relationship Category | nvarchar | 4 | 0 | | | | Allow NULL? |
| 76 | ROLETYP_ORIG | Role of original addressee | nvarchar | 4 | 0 | | | | Allow NULL? |
| 77 | SAKTPAS | Indicator: Asset/Liability Transaction | char | 1 | 0 | | | | Allow NULL? |
| 78 | ROLETYP_ZGP | BP Role | nvarchar | 6 | 0 | | | | Allow NULL? |
| 79 | ROLETYP_ORIG_ZGP | Role of Original Addressee | nvarchar | 6 | 0 | | | | Allow NULL? |
| 80 | ROLETYPEMP_ZGP | Role Category of Administrator | nvarchar | 6 | 0 | | | | Allow NULL? |
| 81 | BZTYP_ZGP | Business Partner Relationship Category | nvarchar | 6 | 0 | | | | Allow NULL? |
| 82 | ROLE_CORR | CML Correspondence Role Type of Recipient | nvarchar | 4 | 0 | | | | Allow NULL? |
| 83 | ROLE_CORR_ORIG | CML Correspondence Role Type of Original Recipient | nvarchar | 4 | 0 | | | | Allow NULL? |
