SAP Table ROIISOCTSP
SOC: Assignment SO <-> Plant/Storage location IS-Oil BDRP
ROIISOCTSP (SOC: Assignment SO <-> Plant/Storage location IS-Oil BDRP) 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 ROIISOCTSP to other SAP tables.
ROIISOCTSP table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||||||||||||||||||||||||||||||
| SOCNR | SOC: Storage object characteristic segment number | OII_SOCNR | OIISOCK | CHAR | 20 | 0 | ||||||||||||||||||||||||||||||
| WERKS | Plant | WERKS_D | CHAR | 4 | 0 | |||||||||||||||||||||||||||||||
| LGORT | Storage Location | LGORT_D | T001L | CHAR | 4 | 0 | ||||||||||||||||||||||||||||||
| ERDAT | Date record created | OII_ERDAT | DATS | 8 | 0 | |||||||||||||||||||||||||||||||
| ERZEIT | Time record created | OII_ERZEIT | TIMS | 6 | 0 | |||||||||||||||||||||||||||||||
| ERNAM | User who created record | OII_ERNAM | CHAR | 12 | 0 | |||||||||||||||||||||||||||||||
| AEDAT | Date record changed | OII_AEDAT | DATS | 8 | 0 | |||||||||||||||||||||||||||||||
| AEZEIT | Time record changed | OII_AEZEIT | TIMS | 6 | 0 | |||||||||||||||||||||||||||||||
| AENAM | User who changed record | OII_AENAM | CHAR | 12 | 0 | |||||||||||||||||||||||||||||||
| BLOIND | Blocking indicator | OII_BLOIND | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||||||
| DELIND | Deletion indicator | OII_DELIND | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||||||
| NAME1 | Name | NAME1 | CHAR | 30 | 0 | |||||||||||||||||||||||||||||||
| BWKEY | Valuation Area | BWKEY | CHAR | 4 | 0 | |||||||||||||||||||||||||||||||
| BUKRS | Company Code | BUKRS | CHAR | 4 | 0 | |||||||||||||||||||||||||||||||
| BUTXT | Name of Company Code or Company | BUTXT | CHAR | 25 | 0 | |||||||||||||||||||||||||||||||
| LGOBE | Description of Storage Location | LGOBE | CHAR | 16 | 0 | |||||||||||||||||||||||||||||||
| SPART | Division | SPART | CHAR | 2 | 0 | |||||||||||||||||||||||||||||||
| VTXTK | Name | VTXTK | CHAR | 20 | 0 | |||||||||||||||||||||||||||||||
| UPD_FLAG | Transaction type | TRTYP | CHAR | 1 | 0 |
Possible values
|
||||||||||||||||||||||||||||||
ROIISOCTSP foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| ROIISOCTSP | LGORT | ROIISOCTSP | MANDT | T001L | Storage Locations | MANDT |
| ROIISOCTSP | LGORT | ROIISOCTSP | WERKS | T001L | Storage Locations | WERKS |
| ROIISOCTSP | LGORT | ROIISOCTSP | LGORT | T001L | Storage Locations | LGORT |
| ROIISOCTSP | MANDT | ROIISOCTSP | MANDT | T000 | Clients | MANDT |
| ROIISOCTSP | SOCNR | ROIISOCTSP | MANDT | OIISOCK | SOC: Storage object characteristic segment header | MANDT |
| ROIISOCTSP | SOCNR | ROIISOCTSP | SOCNR | OIISOCK | SOC: Storage object characteristic segment header | SOCNR |
