SAP Table SMIMPHIO
MIME Repository: Physical Documents
SMIMPHIO (MIME Repository: Physical Documents) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link SMIMPHIO to other SAP tables.
SMIMPHIO table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | Possible values | ||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
LANGU
Language Key
|
SPRAS | T002 |
LANG
|
1 | 0 | |||||||||||||||||||
|
LOIO_ID
Logical document
|
SDOK_LOID | SMIMLOIO |
CHAR
|
32 | 0 | |||||||||||||||||||
|
PHIO_ID
Physical document
|
SDOK_PHID |
CHAR
|
32 | 0 | ||||||||||||||||||||
|
PH_CLASS
Physical document class
|
SDOK_PHCL | SDOKPHCL |
CHAR
|
10 | 0 | |||||||||||||||||||
|
LO_CLASS
Class of logical document
|
SDOK_LOCL |
CHAR
|
10 | 0 | ||||||||||||||||||||
|
STATE
Technical Status of a Physical Document
|
SDOK_PHSTA |
NUMC
|
4 | 0 | ||||||||||||||||||||
|
DESCRIPT
Title of a document
|
SDOK_TITEL |
CHAR
|
64 | 0 | ||||||||||||||||||||
|
CREA_USER
Created by
|
SDOK_CRUSR |
CHAR
|
12 | 0 | ||||||||||||||||||||
|
CREA_TIME
Creation time (UTC)
|
SDOK_CRTST |
NUMC
|
14 | 0 | ||||||||||||||||||||
|
CHNG_USER
Last changed by
|
SDOK_CHUSR |
CHAR
|
12 | 0 | ||||||||||||||||||||
|
CHNG_TIME
Time of change (UTC)
|
SDOK_CHTST |
NUMC
|
14 | 0 | ||||||||||||||||||||
|
STOR_CAT
Category for physical documents
|
SDOK_STCAT | SDOKSTCAE |
CHAR
|
10 | 0 | |||||||||||||||||||
|
DOC_FORMAT
Document format (TEXT, TIFF, RTF, PDF, ...)
|
SDOK_FORM | SDOKFORM |
CHAR
|
4 | 0 | |||||||||||||||||||
|
DOC_PROT
Document protection
|
SDOK_DPROT |
CHAR
|
4 | 0 | ||||||||||||||||||||
|
||||||||||||||||||||||||
|
PROP01
Attribute feature (short version)
|
SDOK_PRV_S |
CHAR
|
15 | 0 | ||||||||||||||||||||
|
PROP02
Attribute feature (short version)
|
SDOK_PRV_S |
CHAR
|
15 | 0 | ||||||||||||||||||||
|
PROP03
Attribute feature (short version)
|
SDOK_PRV_S |
CHAR
|
15 | 0 | ||||||||||||||||||||
|
PROP04
Attribute feature (short version)
|
SDOK_PRV_S |
CHAR
|
15 | 0 | ||||||||||||||||||||
|
PROP05
Attribute feature (mid-length version)
|
SDOK_PRV_M |
CHAR
|
20 | 0 | ||||||||||||||||||||
|
PROP06
Attribute feature (mid-length version)
|
SDOK_PRV_M |
CHAR
|
20 | 0 | ||||||||||||||||||||
|
PROP07
Attribute feature (mid-length version)
|
SDOK_PRV_M |
CHAR
|
20 | 0 | ||||||||||||||||||||
|
PROP08
Attribute feature (long version)
|
SDOK_PRV_L |
CHAR
|
40 | 0 | ||||||||||||||||||||
|
PROP09
Attribute feature (long version)
|
SDOK_PRV_L |
CHAR
|
40 | 0 | ||||||||||||||||||||
|
PROP10
Attribute feature (long version)
|
SDOK_PRV_L |
CHAR
|
40 | 0 | ||||||||||||||||||||
SMIMPHIO foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field |
|---|---|---|---|---|---|
| SMIMPHIO | DOC_FORMAT | SMIMPHIO | DOC_FORMAT |
SDOKFORM
*** Out-of-Date Table (to be deleted shortly) ***
|
FILEFORMAT |
| SMIMPHIO | LANGU | SMIMPHIO | LANGU |
T002
Language Keys (Component BC-I18)
|
SPRAS |
| SMIMPHIO | LOIO_ID | SMIMPHIO | LOIO_ID |
SMIMLOIO
MIME Repository: Logical Documents
|
LOIO_ID |
| SMIMPHIO | PH_CLASS | SMIMPHIO | PH_CLASS |
SDOKPHCL
SDOK: Physical information object classes
|
PH_CLASS |
| SMIMPHIO | STOR_CAT | SMIMPHIO | STOR_CAT |
SDOKSTCAE
SDOK: Category
|
STOR_CAT |