| 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 | LOID | Logical document | nvarchar | 32 | 0 | CHAR | (N' ') | No | | SDOK_LOID | Allow NULL? |
| 3 | LOCLASS | Class of logical document | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | SDOK_LOCL | Allow NULL? |
| 4 | LOTYPE | HR documentation: Documentation class | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | DSYS_OTYPE | HRDSYS_OTYPE | Allow NULL? |
| 5 | LMOLGA | Country Grouping | nvarchar | 2 | 0 | CHAR | (N' ') | Yes | T500L | MOLGA | Allow NULL? |
| 6 | LONAME | HR Documentation: Object Name | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | HRDSYS_ONAME | Allow NULL? |
| 7 | LSYSTEM | Original System of Object | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | SRCSYSTEM | Allow NULL? |
| 8 | LLANGU | Master language documentation | char | 1 | 0 | LANG | (N' ') | Yes | T002 | HRDSYS_LOIO_SPRSL | Allow NULL? |
| 9 | LODESC | Description of Logical Information Object | nvarchar | 70 | 0 | CHAR | (N' ') | Yes | | HRDSLODESC | Allow NULL? |
| 10 | LCR_USER | Logical information object created by | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | HRDSYS_LOIO_CRUSR | Allow NULL? |
| 11 | LCR_TIME | Time of creation (UTC) of logical information object | nvarchar | 14 | 0 | NUMC | (N'00000000000000') | Yes | | HRDSYS_LOIO_CRTST | Allow NULL? |
| 12 | LCH_USER | Logical information object last changed by | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | HRDSYS_LOIO_CHUSR | Allow NULL? |
| 13 | LCH_TIME | Time of change (UTC) logical information object | nvarchar | 14 | 0 | NUMC | (N'00000000000000') | Yes | | HRDSYS_LOIO_CHTST | Allow NULL? |
| 14 | PHID | Physical document | nvarchar | 32 | 0 | CHAR | (N' ') | Yes | | SDOK_PHID | Allow NULL? |
| 15 | PHCLASS | Physical document class | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | * | SDOK_PHCL | Allow NULL? |
| 16 | PLANGU | Language Key | char | 1 | 0 | LANG | (N' ') | Yes | T002 | SPRAS | Allow NULL? |
| 17 | PCR_USER | Created by | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | SDOK_CRUSR | Allow NULL? |
| 18 | PCR_TIME | Creation time (UTC) | nvarchar | 14 | 0 | NUMC | (N'00000000000000') | Yes | | SDOK_CRTST | Allow NULL? |
| 19 | PCH_USER | Last changed by | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | SDOK_CHUSR | Allow NULL? |
| 20 | PCH_TIME | Time of change (UTC) | nvarchar | 14 | 0 | NUMC | (N'00000000000000') | Yes | | SDOK_CHTST | Allow NULL? |