SAP ABAP Table V_OPTI_MDRS (Generated Table for View)
Basic Data
| Table Category | VIEW | General view structure |
| General view structure | V_OPTI_MDRS |
|
| Short Description | Generated Table for View |
Delivery and Maintenance
| Pool/cluster | ||
| Delivery Class | ||
| Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
| |
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|---|---|---|---|---|---|---|---|---|---|
| 1 | |
MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
| 2 | |
RSNUM | RSNUM | NUMC | 10 | 0 | Number of reservation/dependent requirements | ||
| 3 | |
RSPOS | RSPOS | NUMC | 4 | 0 | Item Number of Reservation / Dependent Requirements | ||
| 4 | |
RSART | RSART | CHAR | 1 | 0 | Record type | ||
| 5 | |
NO_DISP_PLUS | NO_DISP_PLUS | CHAR | 1 | 0 | Effective for Materials Planning | ||
| 6 | |
BDMNG | MENG13 | QUAN | 13 | 3 | Requirement Quantity | ||
| 7 | |
DUMPS | XFELD | CHAR | 1 | 0 | Phantom item indicator | ||
| 8 | |
TXTPS | XFELD | CHAR | 1 | 0 | Item text indicator | ||
| 9 | |
SCHGT | XFELD | CHAR | 1 | 0 | Indicator: bulk material | ||
| 10 | |
VORABKZ | XFELD | CHAR | 1 | 0 | Ind: Preliminary order | ||
| 11 | |
MATNR | MATNR | CHAR | 18 | 0 | Material Number | MARA | |
| 12 | |
WERKS_D | WERKS | CHAR | 4 | 0 | Plant | T001W | |
| 13 | |
LGORT_D | LGORT | CHAR | 4 | 0 | Storage location | T001L | |
| 14 | |
CHARG_D | CHARG | CHAR | 10 | 0 | Batch Number | MCHA | |
| 15 | |
ERFME | MEINS | UNIT | 3 | 0 | Unit of entry | T006 | |
| 16 | |
ERFMG | MENG13 | QUAN | 13 | 3 | Quantity in unit of entry | ||
| 17 | |
DBSKZ | DBSKZ | CHAR | 1 | 0 | Direct procurement indicator | ||
| 18 | |
SHKZG | SHKZG | CHAR | 1 | 0 | Debit/Credit Indicator | ||
| 19 | |
ENMNG | MENG13 | QUAN | 13 | 3 | Quantity withdrawn | ||
| 20 | |
UMLGO | LGORT | CHAR | 4 | 0 | Receiving/issuing storage location | T001L | |
| 21 | |
UMWRK | WERKS | CHAR | 4 | 0 | Receiving plant/issuing plant | T001W | |
| 22 | |
MEINS | MEINS | UNIT | 3 | 0 | Base Unit of Measure | T006 | |
| 23 | |
BDART | BDART | CHAR | 2 | 0 | Requirement type | ||
| 24 | |
XLOEK | XFELD | CHAR | 1 | 0 | Item is deleted | ||
| 25 | |
KZEAR | XFELD | CHAR | 1 | 0 | Final issue for this reservation |
Foreign Keys
| |
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right |
|---|---|---|---|---|---|---|---|
| 1 | V_OPTI_MDRS | CHARG | |
|
REF | C | CN |
| 2 | V_OPTI_MDRS | ERFME | |
|
REF | C | CN |
| 3 | V_OPTI_MDRS | LGORT | |
|
REF | C | CN |
| 4 | V_OPTI_MDRS | MANDT | |
|
KEY | 1 | CN |
| 5 | V_OPTI_MDRS | MATNR | |
|
REF | 1 | CN |
| 6 | V_OPTI_MDRS | MEINS | |
|
REF | 1 | CN |
| 7 | V_OPTI_MDRS | UMLGO | |
|
REF | C | CN |
| 8 | V_OPTI_MDRS | UMWRK | |
|
REF | C | CN |
| 9 | V_OPTI_MDRS | WERKS | |
|
REF | 1 | CN |
History
| Last changed by/on | SAP | 20130529 |
| SAP Release Created in |