SAP ABAP Table ENT5123 (Generated Table for View)
Basic Data
Table Category VIEW    General view structure 
General view structure ENT5123   Table Relationship Diagram
Short Description Generated Table for View    
Delivery and Maintenance
Pool/cluster MCHA    
Delivery Class      
Data Browser/Table View Maintenance X   Display/Maintenance Allowed 
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 MATNR MATNR MATNR CHAR 18   0   Material Number MARA
3 WERKS WERKS_D WERKS CHAR 4   0   Plant MARC
4 VERAB VERAB DATUM DATS 8   0   Availability date  
5 VFDAT VFDAT DATUM DATS 8   0   Shelf Life Expiration or Best-Before Date  
6 ZUSCH DZUSCH ZUSCH CHAR 1   0   Batch status key  
7 ZUSTD DZUSTD XFELD CHAR 1   0   Batch in Restricted-Use Stock  
8 ZAEDT DZAEDT DATUM DATS 8   0   Date of last status change  
9 LICHA LICHN LICHN CHAR 15   0   Vendor Batch Number  
10 VLCHA VLCHN CHARG CHAR 10   0   Original batch number (deactivated) MCHA
11 VLWRK VLWRK WERKS CHAR 4   0   Original plant (deactivated) MARC
12 VLMAT VLMAT MATNR CHAR 18   0   Original material (deactivated) MARA
13 CHAME CHAME MEINS UNIT 3   0   Unit of issue for batch (deactivated) T006
14 LWEDT LWEDT DATUM DATS 8   0   Date of last goods receipt  
15 FVDT1 FVDAT DATUM DATS 8   0   Date for unrestricted use  
16 FVDT2 FVDAT DATUM DATS 8   0   Date for unrestricted use  
17 FVDT3 FVDAT DATUM DATS 8   0   Date for unrestricted use  
18 FVDT4 FVDAT DATUM DATS 8   0   Date for unrestricted use  
19 FVDT5 FVDAT DATUM DATS 8   0   Date for unrestricted use  
20 FVDT6 FVDAT DATUM DATS 8   0   Date for unrestricted use  
21 LIFNR ELIFN LIFNR CHAR 10   0   Vendor's account number LFA1
22 LVORM LVOCA XFELD CHAR 1   0   Deletion Flag for All Data on a Batch at a Plant  
23 BWTAR BWTAR_D BWTAR CHAR 10   0   Valuation type MBEW
24 CHARG CHARG_D CHARG CHAR 10   0   Batch Number MCH1
25 ERSDA ERSDA DATUM DATS 8   0   Created On  
26 ERNAM ERNAM USNAM CHAR 12   0   Name of Person who Created the Object  
27 AENAM AENAM USNAM CHAR 12   0   Name of Person Who Changed Object  
28 LAEDA LAEDA DATUM DATS 8   0   Date of Last Change  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 ENT5123 BWTAR MBEW BWTAR    
2 ENT5123 CHAME T006 MSEHI REF C CN
3 ENT5123 CHARG MCH1 CHARG KEY 1 CN
4 ENT5123 LIFNR LFA1 LIFNR    
5 ENT5123 MANDT T000 MANDT KEY 1 CN
6 ENT5123 MATNR MARA MATNR KEY 1 CN
7 ENT5123 VLCHA MCHA CHARG REF C CN
8 ENT5123 VLMAT MARA MATNR REF C CN
9 ENT5123 VLWRK MARC WERKS REF C CN
10 ENT5123 WERKS MARC WERKS KEY 1 CN
History
Last changed by/on SAP  20110901 
SAP Release Created in