| 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 | OBJTP | Code for document class | nvarchar | 3 | 0 | CHAR | (N' ') | No | TSOTD | SO_OBJ_TP | Allow NULL? |
| 3 | OBJYR | Object: Year from ID | nvarchar | 2 | 0 | CHAR | (N' ') | No | | SO_OBJ_YR | Allow NULL? |
| 4 | OBJNO | Object: Number from ID | nvarchar | 12 | 0 | CHAR | (N' ') | No | | SO_OBJ_NO | Allow NULL? |
| 5 | OBJLA | Language in Which Document Is Created | char | 1 | 0 | LANG | (N' ') | Yes | T002 | SO_OBJ_LA | Allow NULL? |
| 6 | OBJSRT | Sort field | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | SO_OBJ_SRT | Allow NULL? |
| 7 | OBJNAM | Name of document, folder or distribution list | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | SO_OBJ_NAM | Allow NULL? |
| 8 | OBJDES | Short description of contents | nvarchar | 50 | 0 | CHAR | (N' ') | Yes | | SO_OBJ_DES | Allow NULL? |
| 9 | OWNTP | Owner type from ID | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | TSOTD | SO_OWN_TP | Allow NULL? |
| 10 | OWNYR | Owner year from the ID | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | SO_OWN_YR | Allow NULL? |
| 11 | OWNNO | Owner number from the ID | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | * | SO_OWN_NO | Allow NULL? |
| 12 | OWNNAM | Name of document owner | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | SO_OWN_NAM | Allow NULL? |
| 13 | CROTP | User who created object: Object type from ID | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | TSOTD | SO_CRO_TP | Allow NULL? |
| 14 | CROYR | User that created object: year from the ID | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | SO_CRO_YR | Allow NULL? |
| 15 | CRONO | User that created object: number from the ID | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | * | SO_CRO_NO | Allow NULL? |
| 16 | CRONAM | Creator Name | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | SO_CRO_NAM | Allow NULL? |
| 17 | CRDAT | Date created | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | SO_DAT_CR | Allow NULL? |
| 18 | CRTIM | Time created | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | SO_TIM_CR | Allow NULL? |
| 19 | CHOTP | User that changed the object: Object type from ID | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | TSOTD | SO_CHO_TP | Allow NULL? |
| 20 | CHOYR | User that changed the object: year from the ID | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | SO_CHO_YR | Allow NULL? |
| 21 | CHONO | User that changed the object: number from the ID | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | * | SO_CHO_NO | Allow NULL? |
| 22 | CHONAM | Changed by | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | SO_CHO_NAM | Allow NULL? |
| 23 | CHDAT | Date of Last Change | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | SO_DAT_CH | Allow NULL? |
| 24 | CHTIM | Time of Last Change | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | SO_TIM_CH | Allow NULL? |
| 25 | NOTTP | Default setting of document class | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | TSOTD | SO_NOT_TP | Allow NULL? |
| 26 | NOTYR | Object note: year from the ID | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | SO_NOT_YR | Allow NULL? |
| 27 | NOTNO | Object note: number from the ID | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | * | SO_NOT_NO | Allow NULL? |
| 28 | OBJAPP | Application object | char | 1 | 0 | CHAR | (N' ') | Yes | | SO_OBJ_APP | Allow NULL? |
| 29 | OBJFIL | Object from SAPfile | char | 1 | 0 | CHAR | (N' ') | Yes | | SO_OBJ_FIL | Allow NULL? |
| 30 | FOLRG | Folder: Area (private, shared folders) | char | 1 | 0 | CHAR | (N' ') | Yes | | SO_FOL_RG | Allow NULL? |
| 31 | NOTES | Flag for an attachment | char | 1 | 0 | CHAR | (N' ') | Yes | | SO_NOTES | Allow NULL? |
| 32 | UHCNT | Counts how many users have this object in HOLD status | varbinary | 2 | 0 | RAW | | Yes | | SO_UHCNT | |
| 33 | ENCCNT | Number of attachments for the object | varbinary | 2 | 0 | RAW | | Yes | | SO_ENC_CNT | |
| 34 | PTFOL | Number of folders which contain the object | varbinary | 2 | 0 | RAW | | Yes | | SO_PTFOL | |
| 35 | PTENC | Number of objects for which this object is an attachment | varbinary | 2 | 0 | RAW | | Yes | | SO_PTENC | |
| 36 | PTHYP | Number of hyperlinks to this object | varbinary | 2 | 0 | RAW | | Yes | | SO_PTHYP | |
| 37 | PTNOT | Number of objects, in which this object is a note | varbinary | 2 | 0 | RAW | | Yes | | SO_PTNOT | |
| 38 | PTMBO | Number of MBO objects which contain this object | varbinary | 2 | 0 | RAW | | Yes | | SO_PTMBO | |
| 39 | PAFOL | Number of folders, in which object is stored and archived | varbinary | 2 | 0 | RAW | | Yes | | SO_PAFOL | |
| 40 | PAENC | No.of archived objects f. which this object is an attachment | varbinary | 2 | 0 | RAW | | Yes | | SO_PAENC | |
| 41 | PAHYP | Number of archived hyperlinks to this object | varbinary | 2 | 0 | RAW | | Yes | | SO_PAHYP | |
| 42 | PANOT | Number of archived objects in which this object is a note | varbinary | 2 | 0 | RAW | | Yes | | SO_PANOT | |
| 43 | PAMBO | Number of archived MBO objects which contain this object | varbinary | 2 | 0 | RAW | | Yes | | SO_PAMBO | |
| 44 | ARCHI | The document is stored in archive | char | 1 | 0 | CHAR | (N' ') | Yes | | SO_ARCHI | Allow NULL? |
| 45 | LADAT | Date of last access | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | SO_DAT_LA | Allow NULL? |
| 46 | DLDAT | Document Expiration Date | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | SO_DAT_DL | Allow NULL? |
| 47 | DLTIM | Expiry time of object | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | SO_TIM_DL | Allow NULL? |
| 48 | OBJPRI | Document priority | char | 1 | 0 | CHAR | (N' ') | Yes | | SO_OBJ_PRI | Allow NULL? |
| 49 | OBJSNS | Object: Sensitivity (private, functional, ...) | char | 1 | 0 | CHAR | (N' ') | Yes | | SO_OBJ_SNS | Allow NULL? |
| 50 | OBJENC | Object: coded | char | 1 | 0 | CHAR | (N' ') | Yes | | SO_OBJ_ENC | Allow NULL? |
| 51 | OBJSND | Object has already been sent | char | 1 | 0 | CHAR | (N' ') | Yes | | SO_OBJ_SND | Allow NULL? |
| 52 | SDDAT | Date On Which Object Was Sent | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | SO_DAT_SD | Allow NULL? |
| 53 | SDTIM | Time at Which The Object Was Sent | nvarchar | 6 | 0 | TIMS | (N'000000') | Yes | | SO_TIM_SD | Allow NULL? |
| 54 | RECCNT | Number of recipients of the object | varbinary | 2 | 0 | RAW | | Yes | | SO_RECCNT | |
| 55 | RRDCNT | Number of Recipients Who Have Read Object | varbinary | 2 | 0 | RAW | | Yes | | SO_RRDCNT | |
| 56 | RRRCNT | Number of recipients who must reply to the object | varbinary | 2 | 0 | RAW | | Yes | | SO_RRRCNT | |
| 57 | RRPCNT | Number of recipients who have sent required reply | varbinary | 2 | 0 | RAW | | Yes | | SO_RRPCNT | |
| 58 | RARCNT | Number of recipients who must take action | varbinary | 2 | 0 | RAW | | Yes | | SO_RARCNT | |
| 59 | RAPCNT | Number of recipients processing the object | varbinary | 2 | 0 | RAW | | Yes | | SO_RAPCNT | |
| 60 | RATCNT | Number of recipients who have taken action | varbinary | 2 | 0 | RAW | | Yes | | SO_RATCNT | |
| 61 | REXCNT | Number of recipients of the express message | varbinary | 2 | 0 | RAW | | Yes | | SO_REXCNT | |
| 62 | RCPCNT | Number of recipients of a copy | varbinary | 2 | 0 | RAW | | Yes | | SO_RCPCNT | |
| 63 | RBCCNT | Number of recipients of a blind copy | varbinary | 2 | 0 | RAW | | Yes | | SO_RBCCNT | |
| 64 | ACONE | ToDo by one of the recipients in the group | varbinary | 1 | 0 | RAW | | Yes | | SO_ACONE | |
| 65 | ACOUT | ToDo: To Be Completed Outside SAPoffice | char | 1 | 0 | CHAR | (N' ') | Yes | | SO_ACOUT | Allow NULL? |
| 66 | FROUT | Object is to be forwarded outside of SAPoffice | char | 1 | 0 | CHAR | (N' ') | Yes | | SO_FROUT | Allow NULL? |
| 67 | VMTYP | Execute: Type (Report, Dialog Module, ...) | char | 1 | 0 | CHAR | (N' ') | Yes | TSOVM | SO_VM_TYP | Allow NULL? |
| 68 | SKIPS | Execute: Process First Screen in Background | char | 1 | 0 | CHAR | (N' ') | Yes | | SO_SKIPS | Allow NULL? |
| 69 | ACNAM | Execute: Name of Report, FM, DB, TCode | nvarchar | 54 | 0 | CHAR | (N' ') | Yes | | SO_ACNAM | Allow NULL? |
| 70 | ACMEM | Process: memory ID | nvarchar | 32 | 0 | CHAR | (N' ') | Yes | | SO_ACMEM | Allow NULL? |
| 71 | HYPTP | Hypertext pointer: Object type | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | TSOTD | SO_HYP_TP | Allow NULL? |
| 72 | HYPYR | Hypertext pointer: year | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | SO_HYP_YR | Allow NULL? |
| 73 | HYPNO | Hypertext pointer: number | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | * | SO_HYP_NO | Allow NULL? |
| 74 | AUTTP | Authorization list: Type from ID | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | TSOTD | SO_AUT_TP | Allow NULL? |
| 75 | AUTYR | Authorization list: year from the ID | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | SO_AUT_YR | Allow NULL? |
| 76 | AUTNO | Authorization list: number from the ID | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | * | SO_AUT_NO | Allow NULL? |
| 77 | PCTRL | SAPoffice: object can be deleted in external inbox | char | 1 | 0 | CHAR | (N' ') | Yes | | SO_PCTRL | Allow NULL? |
| 78 | CCOTP | Change copy: object type from the ID | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | TSOTD | SO_CCO_TP | Allow NULL? |
| 79 | CCOYR | Change copy: year from the ID | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | | SO_CCO_YR | Allow NULL? |
| 80 | CCONO | Change copy: number from the ID | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | * | SO_CCO_NO | Allow NULL? |
| 81 | OBJCP | Document cannot be changed | char | 1 | 0 | CHAR | (N' ') | Yes | | SO_OBJ_CP | Allow NULL? |
| 82 | PRTCT | Document title modifiable | char | 1 | 0 | CHAR | (N' ') | Yes | | SO_PRTCT | Allow NULL? |
| 83 | FIXED | Check-in/check-out flag | char | 1 | 0 | CHAR | (N' ') | Yes | | SO_FIXED | Allow NULL? |
| 84 | EXTHD | Object-specific header is stored externally | char | 1 | 0 | CHAR | (N' ') | Yes | | SO_EXTHD | Allow NULL? |
| 85 | EXTCT | Object contents are stored externally | char | 1 | 0 | CHAR | (N' ') | Yes | | SO_EXTCT | Allow NULL? |
| 86 | FILE_EXT | File extension for PC application | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | | SO_FILEEXT | Allow NULL? |
| 87 | OBJLEN | Size of Document Content | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | SO_OBJ_LEN | Allow NULL? |
| 88 | OBJDBLEN | Size of Document Content | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | SO_OBJ_LEN | Allow NULL? |
| 89 | CREATOR | Creator for MacIntosh-based files | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | SO_CREATOR | Allow NULL? |
| 90 | ATTLEN | Total size of all attachments to a document | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | SO_ATT_LEN | Allow NULL? |
| 91 | IF_DOC_BCS | Globally Unique Identifier | varbinary | 16 | 0 | RAW | | Yes | | OS_GUID | |
| 92 | IF_DOC_CLS | Globally Unique Identifier | varbinary | 16 | 0 | RAW | | Yes | | OS_GUID | |