SAP Table SOFFPHIO
SOFF: Instances of Physical Information Objects
SOFFPHIO (SOFF: Instances of Physical Information Objects) 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 SOFFPHIO to other SAP tables.
SOFFPHIO table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | Possible values | ||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
MANDT
Client
|
MANDT |
CLNT
|
3 | 0 | ||||||||||||||||||||
|
PHIO_ID
Physical document
|
SDOK_PHID |
CHAR
|
32 | 0 | ||||||||||||||||||||
|
PH_CLASS
Physical document class
|
SDOK_PHCL | SDOKPHCL |
CHAR
|
10 | 0 | |||||||||||||||||||
|
LOIO_ID
Logical document
|
SDOK_LOID | SOFFLOIO |
CHAR
|
32 | 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 | ||||||||||||||||||||
|
LANGU
Language Key
|
SPRAS | T002 |
LANG
|
1 | 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 | ||||||||||||||||||||
SOFFPHIO foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field |
|---|---|---|---|---|---|
| SOFFPHIO | DOC_FORMAT | SOFFPHIO | DOC_FORMAT |
SDOKFORM
*** Out-of-Date Table (to be deleted shortly) ***
|
FILEFORMAT |
| SOFFPHIO | LANGU | SOFFPHIO | LANGU |
T002
Language Keys (Component BC-I18)
|
SPRAS |
| SOFFPHIO | LOIO_ID | SOFFPHIO | MANDT |
SOFFLOIO
SOFF: Instances of Logical Information Objects
|
MANDT |
| SOFFPHIO | LOIO_ID | SOFFPHIO | LOIO_ID |
SOFFLOIO
SOFF: Instances of Logical Information Objects
|
LOIO_ID |
| SOFFPHIO | PH_CLASS | SOFFPHIO | PH_CLASS |
SDOKPHCL
SDOK: Physical information object classes
|
PH_CLASS |
| SOFFPHIO | STOR_CAT | SOFFPHIO | STOR_CAT |
SDOKSTCAE
SDOK: Category
|
STOR_CAT |