OII_DIP_MVMT SAP (Related stock derived from SOC material assignment) Table details
Description: Related stock derived from SOC material assignment
Table field list including key, data, relationships and ABAP select examples
OII_DIP_MVMT is a standard SAP Table which is used to store Related stock derived from SOC material assignment data and is available within R/3 SAP systems depending on the version and release level.
The OII_DIP_MVMT table consists of various fields, each holding specific information or linking keys about Related stock derived from SOC material assignment data available in SAP. These include SOCNR (SOC: Storage object characteristic segment number), TIMESTAMP_FROM (From/start time stamp (BDRP)), TIMESTAMP_TO (To/end timestamp (BDRP)), MATNR (Material Number).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP OII_DIP_MVMT table fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | Assigned to domain | MANDT | |||
SOCNR | SOC: Storage object characteristic segment number | OII_SOCNR | CHAR | 20 | Assigned to domain | OII_SOCNR | |||
TIMESTAMP_FROM | From/start time stamp (BDRP) | OII_FTMSTM | NUMC | 14 | OII_TIMEST | ||||
TIMESTAMP_TO | To/end timestamp (BDRP) | OII_TTMSTM | NUMC | 14 | OII_TIMEST | ||||
MATNR | Material Number | MATNR | CHAR | 18 | Assigned to domain | MATN1 | MATNR | MAT | S_MAT1 |
CHARG | Batch Number | CHARG_D | CHAR | 10 | Assigned to domain | CHARG | CHA | ||
BSTAR | Stock type | BSTAR | CHAR | 1 | Assigned to domain | BSTAR | |||
SOBKZ | Special Stock Indicator | SOBKZ | CHAR | 1 | Assigned to domain | SOBKZ | |||
SOBKZ_ADD | Special stock identifier (sales order, vendor, project) | OII_SOBKZ_ADD | CHAR | 30 | CHAR30 | ||||
VERSION | Version number of dip material movement analysis | OIB_ANA_VERSION | NUMC | 4 | NUMC4 | ||||
DEBIT_QUAN | Goods receipt quantity (from material movement analysis) | OII_QUAN_GR | QUAN | 13(3) | MENGE | ||||
CREDIT_QUAN | Goods issue quantity (from material movement analysis) | OII_QUAN_GI | QUAN | 13(3) | MENGE | ||||
DEBIT_COUNT | Goods receipt mvmt count (from material movement analysis) | OII_CNT_GR | DEC | 8 | DEC8 | ||||
CREDIT_COUNT | Goods issue mvmt.count (from material movement analysis) | OII_CNT_GI | DEC | 8 | DEC8 | ||||
MEINS | Base Unit of Measure | MEINS | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
CHANGE_FLAG | Mark changed base for dip analysis (new mat.mvmts) | OIB_CHANGE_FLAG | CHAR | 1 | XFELD | ||||
ERDAT | Date record created | OII_ERDAT | DATS | 8 | DATS | ||||
ERZEIT | Time record created | OII_ERZEIT | TIMS | 6 | TIME | ||||
ERNAM | User who created record | OII_ERNAM | CHAR | 12 | USNAM |
Key field | Non-key field |
How do I retrieve data from SAP table OII_DIP_MVMT using ABAP code
The following ABAP code Example will allow you to do a basic selection on OII_DIP_MVMT to SELECT all data from the tableDATA: WA_OII_DIP_MVMT TYPE OII_DIP_MVMT.
SELECT SINGLE *
FROM OII_DIP_MVMT
INTO CORRESPONDING FIELDS OF WA_OII_DIP_MVMT
WHERE...
How to access SAP table OII_DIP_MVMT
Within an ECC or HANA version of SAP you can also view further information about OII_DIP_MVMT and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects