SAP table SMIMPHIO (MIME Repository: Physical Documents)

SAP table SMIMPHIO has 3 primary key fields being LANGU,LOIO_ID,PHIO_ID.

Field Description Data Type Length Decimals Checktable Data Element
LANGU Language Key LANG 1 0 T002 SPRAS
LOIO_ID Logical document CHAR 32 0 SMIMLOIO SDOK_LOID
PHIO_ID Physical document CHAR 32 0 SDOK_PHID
PH_CLASS Physical document class CHAR 10 0 SDOKPHCL SDOK_PHCL
LO_CLASS Class of logical document CHAR 10 0 * SDOK_LOCL
STATE Technical Status of a Physical Document NUMC 4 0 SDOK_PHSTA
DESCRIPT Title of a document CHAR 64 0 SDOK_TITEL
CREA_USER Created By CHAR 12 0 SDOK_CRUSR
CREA_TIME Creation Time (UTC) NUMC 14 0 SDOK_CRTST
CHNG_USER Last Changed By CHAR 12 0 SDOK_CHUSR
CHNG_TIME Time of change (UTC) NUMC 14 0 SDOK_CHTST
STOR_CAT Category for physical documents CHAR 10 0 SDOKSTCAE SDOK_STCAT
DOC_FORMAT Document format (TEXT, TIFF, RTF, PDF, ...) CHAR 4 0 SDOKFORM SDOK_FORM
DOC_PROT Document protection CHAR 4 0 SDOK_DPROT
- No protection
d Protection Against Invalid Deletion
dr Protection Against Unauthorized Deletion and Read
dru Protection Against Unauthorized Deletion, Read and Change
du Protection Against Unauthorized Deletion and Change
r Protection Against Unauthorized Read
ru Protection Against Unauthorized Read and Change
u Protection Against Unauthorized Change
PROP01 Attribute feature (short version) CHAR 15 0 SDOK_PRV_S
PROP02 Attribute feature (short version) CHAR 15 0 SDOK_PRV_S
PROP03 Attribute feature (short version) CHAR 15 0 SDOK_PRV_S
PROP04 Attribute feature (short version) CHAR 15 0 SDOK_PRV_S
PROP05 Attribute feature (mid-length version) CHAR 20 0 SDOK_PRV_M
PROP06 Attribute feature (mid-length version) CHAR 20 0 SDOK_PRV_M
PROP07 Attribute feature (mid-length version) CHAR 20 0 SDOK_PRV_M
PROP08 Attribute feature (long version) CHAR 40 0 SDOK_PRV_L
PROP09 Attribute feature (long version) CHAR 40 0 SDOK_PRV_L
PROP10 Attribute feature (long version) CHAR 40 0 SDOK_PRV_L

SMIMPHIO foreign key relationships

Table Field Check Table Check Field
0 SMIMPHIO DOC_FORMAT SDOKFORM *** Out-of-Date Table (to be deleted shortly) *** FILEFORMAT
1 SMIMPHIO STOR_CAT SDOKSTCAE SDOK: Category STOR_CAT