| 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 | EINRI | Institution | nvarchar | 4 | 0 | CHAR | (N' ') | No | TN01 | EINRI | Allow NULL? |
| 3 | TOMID | IS-H: Work Organizer Key | nvarchar | 8 | 0 | CHAR | (N' ') | No | TNF03 | TOMID | Allow NULL? |
| 4 | LOMID | IS-H: Work Organizer Type Key | nvarchar | 8 | 0 | CHAR | (N' ') | No | TNF01 | LOMID | Allow NULL? |
| 5 | ABART | IS-H: Billing Type for Patient Accounting | nvarchar | 2 | 0 | CHAR | (N' ') | No | TN21 | ABRART | Allow NULL? |
| 6 | KTART | IS-H: Insurance Provider Type (e.g. Private, Statutory) | nvarchar | 3 | 0 | CHAR | (N' ') | No | TN18 | KOSTR_ART | Allow NULL? |
| 7 | SPERR | Blocking Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | RI_SPERR | Allow NULL? |
| 8 | PRSTD | IS-H: Standard Printout of Work Organizer | char | 1 | 0 | CHAR | (N' ') | Yes | | PRSTD | Allow NULL? |
| 9 | TDFORM | IS-H: Form name of a SAPscript form | nvarchar | 16 | 0 | CHAR | (N' ') | Yes | | N_TDFORM | Allow NULL? |
| 10 | EDIT | IS-H: Editor Indicator for Free Text | char | 1 | 0 | CHAR | (N' ') | Yes | | N_TDEDIT | Allow NULL? |
| 11 | TXTHE | IS-H: Text Module for Letterhead | nvarchar | 16 | 0 | CHAR | (N' ') | Yes | | TXTHE_NFOM | Allow NULL? |
| 12 | TXTFO | IS-H: Text Module for Footer | nvarchar | 16 | 0 | CHAR | (N' ') | Yes | | TXTFO_NFOM | Allow NULL? |
| 13 | TXTSE | IS-H: Text Module for Sender in Letter Window | nvarchar | 16 | 0 | CHAR | (N' ') | Yes | | TXTSE_NFOM | Allow NULL? |
| 14 | TXTSI | IS-H: Text Module for Signature Specification | nvarchar | 16 | 0 | CHAR | (N' ') | Yes | | TXTSI_NFOM | Allow NULL? |
| 15 | TXTFR | IS-H: Text Module Free Text in Form | nvarchar | 16 | 0 | CHAR | (N' ') | Yes | | TXTFR_NFOM | Allow NULL? |
| 16 | TDDATASET | Spool request: Name | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | | RSPO0NAME | Allow NULL? |
| 17 | TDSUFFIX1 | Spool request: Suffix 1 | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | RSPO1NAME | Allow NULL? |
| 18 | TDSUFFIX2 | Spool request: Suffix 2 | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | RSPO2NAME | Allow NULL? |
| 19 | TDIMMED | IS-H: Print Immediately | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_PRIMM | Allow NULL? |
| 20 | TDDELETE | Immediate Spool Deletion | char | 1 | 0 | CHAR | (N' ') | Yes | | SYPRREL | Allow NULL? |
| 21 | TDLIFETIME | Spool Retention Period | char | 1 | 0 | NUMC | (N'0') | Yes | | SYPEXPI | Allow NULL? |
| 22 | TDTEST | Test form | char | 1 | 0 | CHAR | (N' ') | Yes | | TDTEST | Allow NULL? |
| 23 | TDDIALOG | IS-H: User Dialog when Printing Form | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_DIALPR | Allow NULL? |
| 24 | DEVICE | IS-H: Output Device | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | | ISH_DEVICE | Allow NULL? |
| 25 | TDCOPIES | Number of copies | tinyint | 3 | 0 | INT1 | ((0)) | Yes | | RSPOCOPIES | |
| 26 | FBPRINT | IS-H: User-Defined Print Function Module | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | ISH_FUBU | Allow NULL? |
| 27 | FBMOD | IS-H: Customer Function Module for Logical Work Organizer | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | * | FBFORM_C | Allow NULL? |
| 28 | LANGUFLAG | IS-H: Language Control Indicator | char | 1 | 0 | CHAR | (N' ') | No | | N_LANGUFLAG | Allow NULL? |
| 29 | ALTLANGU | IS-H: Alternative Language for Language-Controlled Forms | char | 1 | 0 | LANG | (N' ') | No | T002 | ISH_ALTLANGU | Allow NULL? |
| 30 | FORMARCHIV | IS-H: Name of target archive for overlay form | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | ISH_SAEARC | Allow NULL? |
| 31 | FORM_ID | IS-H: Archive Document ID for Overlay Form | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | ISH_ARDOID | Allow NULL? |
| 32 | AR_OBJECT | IS-H: ArchiveLink Document Type | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | ISH_SAEOBJ | Allow NULL? |
| 33 | ARCTEXT | IS-H: ArchiveLink Text Information Field | nvarchar | 40 | 0 | CHAR | (N' ') | Yes | | ISH_SAETXT | Allow NULL? |
| 34 | ARPER | SAP ArchiveLink: Retention period in months | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | SAEEXPIRY | Allow NULL? |
| 35 | ACTIV | IS-H: Indicator whether a form is to be archived | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_ACTIV | Allow NULL? |
| 36 | SFFNAME | Smart Forms: Form Name | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | STXFADM | TDSFNAME | Allow NULL? |
| 37 | SFVARIA | Smart Forms: Variant | nvarchar | 8 | 0 | CHAR | (N' ') | Yes | STXFVAR | TDVARIANT | Allow NULL? |
| 38 | SMARTFACT | IS-H: Smart Forms Active | char | 1 | 0 | CHAR | (N' ') | No | | ISH_SMARTFORMS_ACTIVE | Allow NULL? |
| 39 | AFNAME | Name of Form Object | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | * | ISH_FP_NAME | Allow NULL? |
| 40 | AFACT | PDF-Based Forms Active | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_FP_ACTIVE | Allow NULL? |
| 41 | AFSFCOMP | IS-H: Boolean Data Type for ON (= "X") and OFF (= " ") | char | 1 | 0 | CHAR | (N' ') | Yes | | ISH_ON_OFF | Allow NULL? |
