SAP Table ROIJ_SPWUSERDEF
OIL TSW: SPW personal settings
ROIJ_SPWUSERDEF (OIL TSW: SPW personal settings) 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 ROIJ_SPWUSERDEF to other SAP tables.
ROIJ_SPWUSERDEF table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| SPTYPE | Stock Projection type | OIJ_DEFSPTYPE | OIJ_SPTYPES | CHAR | 5 | 0 | ||||||
| DOCK | OIL TSW: Default selection container size | OIJ_DOCKSIZE | CHAR | 10 | 0 | |||||||
| SPLIT1 | Selection Container Size | OIJ_SPLIT1 | CHAR | 10 | 0 | |||||||
| SPLIT2 | Constraints Container Size | OIJ_SPLIT2 | CHAR | 10 | 0 | |||||||
| SPLIT3 | Extra Container Size | OIJ_SPLIT3 | CHAR | 10 | 0 | |||||||
| VARNAME | OIL TSW: Default variant name for SPW | OIJ_DEFVAR | CHAR | 14 | 0 | |||||||
| TREE_EXP | OIL TSW: Expand tree | OIJ_EXPTREE | CHAR | 1 | 0 |
Possible values
|
||||||
| POPMS | OIL TSW: Multiple selection on entry | OIJ_POPMS | CHAR | 1 | 0 |
Possible values
|
||||||
| MSLOCTS | OIL TSW : Location/Transport System Indicator | OIJ_MSLOCTS | CHAR | 1 | 0 |
Possible values
|
||||||
| LOCTS | OIL TSW : Location/Transport System Indicator | OIJ_LOCTS | CHAR | 1 | 0 |
Possible values
|
||||||
| LOCID | Location ID | OIJ_DEFLOCID | OIJLOC | CHAR | 10 | 0 | ||||||
| TSYST | Transport system | OIJ_DEFTSYST | OIJTS | CHAR | 10 | 0 | ||||||
| MATNR | Loaded/Discharged Material | OIJ_DEFMATNR | MARA | CHAR | 18 | 0 | ||||||
| MULTNOM | All 'Multiple' items in the SPW drilled down/up | OIJ_RDMULT | CHAR | 1 | 0 |
Possible values
|
||||||
| SPWMODE | Stock Projection mode (Display/Change) | OIJ_SPWMODE | CHAR | 1 | 0 |
Possible values
|
||||||
| HEELBUT | Subtract Heel from Inventory | OIJ_HEELBUT | CHAR | 1 | 0 |
Possible values
|
||||||
| ACCNEG | Accumulate/Undo Accumulate negatives | OIJ_ACCNEG | CHAR | 1 | 0 |
Possible values
|
||||||
| OPTCOL | Do not Optimise ALV Column width | OIJ_OPTCOL | CHAR | 1 | 0 |
Possible values
|
||||||
ROIJ_SPWUSERDEF foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| ROIJ_SPWUSERDEF | LOCID | SYST | MANDT | OIJLOC | Location table | MANDT |
| ROIJ_SPWUSERDEF | LOCID | ROIJ_SPWUSERDEF | LOCID | OIJLOC | Location table | LOCID |
| ROIJ_SPWUSERDEF | MATNR | SYST | MANDT | MARA | General Material Data | MANDT |
| ROIJ_SPWUSERDEF | MATNR | ROIJ_SPWUSERDEF | MATNR | MARA | General Material Data | MATNR |
| ROIJ_SPWUSERDEF | SPTYPE | SYST | MANDT | OIJ_SPTYPES | Stock Projection Types | MANDT |
| ROIJ_SPWUSERDEF | SPTYPE | ROIJ_SPWUSERDEF | SPTYPE | OIJ_SPTYPES | Stock Projection Types | SPTYPE |
| ROIJ_SPWUSERDEF | TSYST | SYST | MANDT | OIJTS | Transport system (IS-Oil TSW standard/core object ) | MANDT |
| ROIJ_SPWUSERDEF | TSYST | ROIJ_SPWUSERDEF | TSYST | OIJTS | Transport system (IS-Oil TSW standard/core object ) | TSYST |
