SAP ABAP Table EHSWAV_MNVHSIGN (Generated Table for View)
Basic Data
Table Category VIEW    General view structure 
General view structure EHSWAV_MNVHSIGN   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  
2 RECN EHSBE_UUID_32 EHSBD_UUID_32 CHAR 32   0   GUID Number  
3 DELFLG ESEDELFLG ESDFLAG CHAR 1   0   Deletion Indicator  
4 PARKFLG ESEPARKFLG ESDFLAG CHAR 1   0   Data Record Is Inactive  
5 CRDAT ESECRDAT DATUM DATS 8   0   Created On  
6 CRNAM ESECRNAM USNAM CHAR 12   0   Created By  
7 UPDDAT ESEUPDDAT DATUM DATS 8   0   Changed On  
8 UPDNAM ESEUPDNAM USNAM CHAR 12   0   Last Changed By  
9 SRSID ESESRSID ESDSRSID CHAR 10   0   Source of Data  
10 OWNID ESEVENDRID AD_ADDRNUM CHAR 10   0   Data Provider  
11 RECNROOT EHSBE_UUID_32 EHSBD_UUID_32 CHAR 32   0   GUID Number EHSWAT_MN
12 MNBPROLE EHSWAE_WABPROLE BU_RLTYP CHAR 6   0   Business Partner Role in Waste Management  
13 MNRECNBP EHSWAE_RECNBP EHSBD_UUID_32 CHAR 32   0   Waste Management Business Partner (RECN)  
14 MNBPORD EHSWAE_MNBPORD NUMC3 NUMC 3   0   Sequence of the Partners in the Disposal Document  
15 MNBPIDCTRY EHSWAE_MNBPIDCTRY CHAR15 CHAR 15   0   No. Assigned by a Transregional Authority  
16 MNBPIDST EHSWAE_MNBPIDST CHAR15 CHAR 15   0   No. Assigned by a Regional Authority  
17 MNDATEDEL EHSWAE_MNDATEDEL DATUM DATS 8   0   Handover Date for Disposal Document  
18 MNDATEADO EHSWAE_MNDATEADO DATUM DATS 8   0   Takeover Date for Disposal Document  
19 MNSIGNBPMN EHSWAE_SIGNBPMN CHAR15 CHAR 15   0   Signatory at Business Partner for Waste Management  
20 MNVHSIGN EHSWAE_MNVHSIGN CHAR15 CHAR 15   0   License Plate Number  
21 MNDRIVER EHSWAE_MNDRIVER CHAR35 CHAR 35   0   Driver's Name  
22 MNBAL EHSWAE_MNBAL X CHAR 1   0   Waste Management Business Partner Is Relevant for Waste LCA  
23 MNORDNO EHSWAE_MNORDNO CHAR20 CHAR 20   0   Order Number for Waste Management Business Partner  
24 WABPID_INH EHSWAE_WABPID_INH X CHAR 1   0   Transreg. Auth.-Assigned No. Comes from Higher-Level Partner  
25 NAME1 AD_NAME1 TEXT40 CHAR 40   0   Name 1  
26 NAME2 AD_NAME2 TEXT40 CHAR 40   0   Name 2  
27 NAME3 AD_NAME3 TEXT40 CHAR 40   0   Name 3  
28 NAME4 AD_NAME4 TEXT40 CHAR 40   0   Name 4  
29 CITY1 AD_CITY1 TEXT40 CHAR 40   0   City  
30 CITY2 AD_CITY2 TEXT40 CHAR 40   0   District  
31 POST_CODE1 AD_PSTCD1 CHAR10 CHAR 10   0   City postal code  
32 POST_CODE2 AD_PSTCD2 CHAR10 CHAR 10   0   PO Box postal code  
33 POST_CODE3 AD_PSTCD3 CHAR10 CHAR 10   0   Company postal code (for large customers)  
34 PO_BOX AD_POBX CHAR10 CHAR 10   0   PO Box  
35 PO_BOX_LOC AD_POBXLOC TEXT40 CHAR 40   0   PO Box city  
36 STREET AD_STREET TEXT60 CHAR 60   0   Street  
37 HOUSE_NUM1 AD_HSNM1 TEXT10 CHAR 10   0   House Number  
38 STR_SUPPL1 AD_STRSPP1 TEXT40 CHAR 40   0   Street 2  
39 STR_SUPPL2 AD_STRSPP2 TEXT40 CHAR 40   0   Street 3  
40 STR_SUPPL3 AD_STRSPP3 TEXT40 CHAR 40   0   Street 4  
41 COUNTRY LAND1 LAND1 CHAR 3   0   Country Key  
42 REGION REGIO REGIO CHAR 3   0   Region (State, Province, County)  
43 HOUSE_NUM2 AD_HSNM2 TEXT10 CHAR 10   0   House number supplement  
44 LOCATION AD_LCTN TEXT40 CHAR 40   0   Street 5  
45 TEL_NUMBER AD_TLNMBR1 CHAR30 CHAR 30   0   First telephone no.: dialling code+number  
46 TEL_EXTENS AD_TLXTNS1 CHAR10 CHAR 10   0   First Telephone No.: Extension  
47 FAX_NUMBER AD_FXNMBR1 CHAR30 CHAR 30   0   First fax no.: dialling code+number  
48 FAX_EXTENS AD_FXXTNS1 CHAR10 CHAR 10   0   First fax no.: extension  
49 PARTNER EHSWAE_PARTNER EHSWAD_PARTNER CHAR 10   0   Business Partner for Waste Management  
50 WADESCRPOFG EHSWAE_DESCRPOFG TEXT50 CHAR 50   0   Role-Dependent Partner Name  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 EHSWAV_MNVHSIGN RECNROOT EHSWAT_MN MANDT KEY 1 CN
History
Last changed by/on SAP  20130529 
SAP Release Created in