SAP ABAP Table V_OPTI_MDRS (Generated Table for View)
Basic Data
Table Category VIEW    General view structure 
General view structure V_OPTI_MDRS   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 RSNUM RSNUM RSNUM NUMC 10   0   Number of reservation/dependent requirements  
3 RSPOS RSPOS RSPOS NUMC 4   0   Item Number of Reservation / Dependent Requirements  
4 RSART RSART RSART CHAR 1   0   Record type  
5 NDISP NO_DISP_PLUS NO_DISP_PLUS CHAR 1   0   Effective for Materials Planning  
6 BDMNG BDMNG MENG13 QUAN 13   3   Requirement Quantity  
7 DUMPS DUMPS XFELD CHAR 1   0   Phantom item indicator  
8 TXTPS TXTPS XFELD CHAR 1   0   Item text indicator  
9 SCHGT SCHGT XFELD CHAR 1   0   Indicator: bulk material  
10 VORAB VORABKZ XFELD CHAR 1   0   Ind: Preliminary order  
11 MATNR MATNR MATNR CHAR 18   0   Material Number MARA
12 WERKS WERKS_D WERKS CHAR 4   0   Plant T001W
13 LGORT LGORT_D LGORT CHAR 4   0   Storage location T001L
14 CHARG CHARG_D CHARG CHAR 10   0   Batch Number MCHA
15 ERFME ERFME MEINS UNIT 3   0   Unit of entry T006
16 ERFMG ERFMG MENG13 QUAN 13   3   Quantity in unit of entry  
17 DBSKZ DBSKZ DBSKZ CHAR 1   0   Direct procurement indicator  
18 SHKZG SHKZG SHKZG CHAR 1   0   Debit/Credit Indicator  
19 ENMNG ENMNG MENG13 QUAN 13   3   Quantity withdrawn  
20 UMLGO UMLGO LGORT CHAR 4   0   Receiving/issuing storage location T001L
21 UMWRK UMWRK WERKS CHAR 4   0   Receiving plant/issuing plant T001W
22 MEINS MEINS MEINS UNIT 3   0   Base Unit of Measure T006
23 BDART BDART BDART CHAR 2   0   Requirement type  
24 XLOEK XLOEK XFELD CHAR 1   0   Item is deleted  
25 KZEAR 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 MCHA CHARG REF C CN
2 V_OPTI_MDRS ERFME T006 MSEHI REF C CN
3 V_OPTI_MDRS LGORT T001L LGORT REF C CN
4 V_OPTI_MDRS MANDT T000 MANDT KEY 1 CN
5 V_OPTI_MDRS MATNR MARA MATNR REF 1 CN
6 V_OPTI_MDRS MEINS T006 MSEHI REF 1 CN
7 V_OPTI_MDRS UMLGO T001L LGORT REF C CN
8 V_OPTI_MDRS UMWRK T001W WERKS REF C CN
9 V_OPTI_MDRS WERKS T001W WERKS REF 1 CN
History
Last changed by/on SAP  20130529 
SAP Release Created in