SAP ABAP Table /ISDFPS/MEMMVRQ1 (Generated Table for View)
Basic Data
| Table Category | VIEW | General view structure |
| General view structure | /ISDFPS/MEMMVRQ1 |
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 |  CLIENT |
MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
| 2 | DOC_NUM |
BANFN | BANFN | CHAR | 10 | 0 | Purchase requisition number | ||
| 3 | POS_NUM |
BNFPO | BNFPO | NUMC | 5 | 0 | Item number of purchase requisition | ||
| 4 | DOC_KEY_R3 |
BBSRT | BSART | CHAR | 4 | 0 | Purchase Requisition Document Type | ||
| 5 | MATERIAL |
MATNR | MATNR | CHAR | 18 | 0 | Material Number | MARA | |
| 6 | MAT1_S_MPN |
EMATN | MATNR | CHAR | 18 | 0 | Material number corresponding to manufacturer part number | MARA | |
| 7 | QUANTITY |
BAMNG | MENG13 | QUAN | 13 | 3 | Purchase requisition quantity | ||
| 8 | ORDERED |
BSMNG | MENG13 | QUAN | 13 | 3 | Quantity ordered against this purchase requisition | ||
| 9 | UNIT |
BAMEI | MEINS | UNIT | 3 | 0 | Purchase requisition unit of measure | T006 | |
| 10 | DELETE_IND |
ELOEK | ELOEK | CHAR | 1 | 0 | Deletion indicator in purchasing document | ||
| 11 | CREATE_IND |
ESTKZ | ESTKZ | CHAR | 1 | 0 | Creation indicator (purchase requisition/schedule lines) | ||
| 12 | CLOSED |
EBAKZ | XFELD | CHAR | 1 | 0 | Purchase requisition closed | ||
| 13 | PLANT |
EWERK | WERKS | CHAR | 4 | 0 | Plant | T001W | |
| 14 | STORE_LOC |
LGORT_D | LGORT | CHAR | 4 | 0 | Storage location | T001L | |
| 15 | SUPPL_PLANT |
RESWK | WERKS | CHAR | 4 | 0 | Supplying (issuing) plant in case of stock transport order | ||
| 16 | SUPPL_STORE_LOC |
RESLO | LGORT | CHAR | 4 | 0 | Issuing Storage Location for Stock Transport Order | ||
| 17 | CREATED_BY |
ERNAM | USNAM | CHAR | 12 | 0 | Name of Person who Created the Object | ||
| 18 | CREATED_DATE |
BADAT | DATUM | DATS | 8 | 0 | Requisition (request) date | ||
| 19 | CHANGED_DATE |
AEDAT | DATUM | DATS | 8 | 0 | Last Changed On |
Foreign Keys
| |
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right |
|---|---|---|---|---|---|---|---|
 |
|
|
|
|
|
|
|
| 1 | /ISDFPS/MEMMVRQ1 | CLIENT |  T000 |
MANDT |
KEY | 1 | N |
| 2 | /ISDFPS/MEMMVRQ1 | MAT1_S_MPN | MARA |
MATNR |
REF | 1 | N |
| 3 | /ISDFPS/MEMMVRQ1 | MATERIAL | MARA |
MATNR |
REF | 1 | N |
| 4 | /ISDFPS/MEMMVRQ1 | PLANT | T001W |
WERKS |
REF | 1 | N |
| 5 | /ISDFPS/MEMMVRQ1 | STORE_LOC | T001L |
LGORT |
REF | 1 | N |
| 6 | /ISDFPS/MEMMVRQ1 | UNIT | T006 |
MSEHI |
REF | 1 | N |
History
| Last changed by/on | SAP | 20130529 |
| SAP Release Created in |
