SAP ABAP Table MDRV (Generated Table for View)
Basic Data
| Table Category | VIEW | General view structure |
| General view structure | MDRV |
Table Relationship Diagram 
|
| 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 | MANDT | CLNT | 3 | 0 | Client | T000 | |
| 2 | EBELN |
EBELN | EBELN | CHAR | 10 | 0 | Purchasing Document Number | ||
| 3 | EBELP |
EBELP | EBELP | NUMC | 5 | 0 | Item Number of Purchasing Document | ||
| 4 | RESWK |
RESWK | WERKS | CHAR | 4 | 0 | Supplying (issuing) plant in case of stock transport order | T001W | |
| 5 | BSTYP |
BSTYP | BSTYP | CHAR | 1 | 0 | Purchasing document category | ||
| 6 | LOEKZ |
ELOEK | ELOEK | CHAR | 1 | 0 | Deletion indicator in purchasing document | ||
| 7 | MATNR |
MATNR | MATNR | CHAR | 18 | 0 | Material Number | MARA | |
| 8 | EMATN |
EMATNR | MATNR | CHAR | 18 | 0 | Material number | MARA | |
| 9 | WERKS |
EWERK | WERKS | CHAR | 4 | 0 | Plant | T001W | |
| 10 | LGORT |
LGORT_D | LGORT | CHAR | 4 | 0 | Storage location | T001L | |
| 11 | PLIFZ |
EPLIF | DEC3 | DEC | 3 | 0 | Planned Delivery Time in Days | ||
| 12 | WEBAZ |
WEBAZ | DEC3 | DEC | 3 | 0 | Goods receipt processing time in days | ||
| 13 | PSTYP |
PSTYP | PSTYP | CHAR | 1 | 0 | Item category in purchasing document | T163 | |
| 14 | KNTTP |
KNTTP | KNTTP | CHAR | 1 | 0 | Account assignment category | T163K | |
| 15 | KZVBR |
KZVBR | KZVBR | CHAR | 1 | 0 | Consumption posting | ||
| 16 | SOBKZ |
SOBKZ | SOBKZ | CHAR | 1 | 0 | Special Stock Indicator | T148 | |
| 17 | LIFNR |
ELIFN | LIFNR | CHAR | 10 | 0 | Vendor's account number | LFA1 | |
| 18 | EKORG |
EKORG | EKORG | CHAR | 4 | 0 | Purchasing organization | T024E | |
| 19 | EKGRP |
BKGRP | EKGRP | CHAR | 3 | 0 | Purchasing Group | T024 |
Foreign Keys
| |
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right |
|---|---|---|---|---|---|---|---|
 |
|
|
|
|
|
|
|
| 1 | MDRV | EKGRP |  T024 |
EKGRP |
REF | 1 | N |
| 2 | MDRV | EKORG | T024E |
EKORG |
REF | 1 | N |
| 3 | MDRV | EMATN | MARA |
MATNR |
REF | 1 | N |
| 4 | MDRV | KNTTP | T163K |
KNTTP |
REF | 1 | N |
| 5 | MDRV | LGORT | T001L |
LGORT |
REF | 1 | N |
| 6 | MDRV | LIFNR | LFA1 |
LIFNR |
REF | 1 | N |
| 7 | MDRV | MANDT | T000 |
MANDT |
KEY | 1 | N |
| 8 | MDRV | MATNR | MARA |
MATNR |
REF | 1 | N |
| 9 | MDRV | PSTYP | T163 |
PSTYP |
REF | 1 | N |
| 10 | MDRV | RESWK | T001W |
WERKS |
REF | 1 | N |
| 11 | MDRV | SOBKZ | T148 |
SOBKZ |
REF | 1 | N |
| 12 | MDRV | WERKS | T001W |
WERKS |
REF | 1 | N |
History
| Last changed by/on | SAP | 20140121 |
| SAP Release Created in |
