SAP ABAP Table EHSWAV_APPBP (Generated Table for View)
Basic Data
Table Category VIEW    General view structure 
General view structure EHSWAV_APPBP   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 RECN EHSBE_UUID_32 EHSBD_UUID_32 CHAR 32   0   GUID Number  
3 ACTN EHSBE_UUID_32 EHSBD_UUID_32 CHAR 32   0   GUID Number  
4 VALFR ESEVALFR DATUM DATS 8   0   Valid-From Date  
5 VALTO ESEVALTO DATUM DATS 8   0   Valid-To Date  
6 AENNR ESEAENNR AENNR CHAR 12   0   Change Number  
7 DELFLG ESEDELFLG ESDFLAG CHAR 1   0   Deletion Indicator  
8 PARKFLG ESEPARKFLG ESDFLAG CHAR 1   0   Data Record Is Inactive  
9 CRDAT ESECRDAT DATUM DATS 8   0   Created On  
10 CRNAM ESECRNAM USNAM CHAR 12   0   Created By  
11 UPDDAT ESEUPDDAT DATUM DATS 8   0   Changed On  
12 UPDNAM ESEUPDNAM USNAM CHAR 12   0   Last Changed By  
13 SRSID ESESRSID ESDSRSID CHAR 10   0   Source of Data  
14 OWNID ESEVENDRID AD_ADDRNUM CHAR 10   0   Data Provider  
15 RECNROOT EHSBE_UUID_32 EHSBD_UUID_32 CHAR 32   0   GUID Number  
16 RECNBPWA EHSBE_UUID_32 EHSBD_UUID_32 CHAR 32   0   GUID Number  
17 WABPID EHSWAE_MNBPIDCTRY CHAR15 CHAR 15   0   No. Assigned by a Transregional Authority  
18 WABPIDS EHSWAE_MNBPIDST CHAR15 CHAR 15   0   No. Assigned by a Regional Authority  
19 APSDAT EHSWAE_APSDAT DATS DATS 8   0   Date Sent to Business Partner for Waste Management  
20 APDDAT EHSWAE_APDDAT DATS DATS 8   0   Date Receipt Confirmation Received from Partner  
21 APGADAT EHSWAE_APGADAT DATS DATS 8   0   Date License Received from Partner  
22 APBPSIGN EHSWAE_APBPSIGN CHAR20 CHAR 20   0   Signatory at Business Partner for Waste Management  
23 APREF EHSWAE_APREF CHAR15 CHAR 15   0   Reference  
24 APBPMN EHSWAE_APBPMN X CHAR 1   0   Partner is Relevant for Output on a Disposal Document  
25 WABPID_INH EHSWAE_WABPID_INH X CHAR 1   0   Transreg. Auth.-Assigned No. Comes from Higher-Level Partner  
26 LIZCAT EHSWAE_LIZCAT EHSWAD_LIZCAT CHAR 4   0   License Type EHSWAC_LIZCAT
27 LIZNO EHSWAE_LIZNO TEXT20 CHAR 20   0   License or Exception Number  
28 NAME1 AD_NAME1 TEXT40 CHAR 40   0   Name 1  
29 NAME2 AD_NAME2 TEXT40 CHAR 40   0   Name 2  
30 NAME3 AD_NAME3 TEXT40 CHAR 40   0   Name 3  
31 NAME4 AD_NAME4 TEXT40 CHAR 40   0   Name 4  
32 CITY1 AD_CITY1 TEXT40 CHAR 40   0   City  
33 CITY2 AD_CITY2 TEXT40 CHAR 40   0   District  
34 POST_CODE1 AD_PSTCD1 CHAR10 CHAR 10   0   City postal code  
35 POST_CODE2 AD_PSTCD2 CHAR10 CHAR 10   0   PO Box postal code  
36 POST_CODE3 AD_PSTCD3 CHAR10 CHAR 10   0   Company postal code (for large customers)  
37 PO_BOX AD_POBX CHAR10 CHAR 10   0   PO Box  
38 PO_BOX_LOC AD_POBXLOC TEXT40 CHAR 40   0   PO Box city  
39 STREET AD_STREET TEXT60 CHAR 60   0   Street  
40 HOUSE_NUM1 AD_HSNM1 TEXT10 CHAR 10   0   House Number  
41 STR_SUPPL1 AD_STRSPP1 TEXT40 CHAR 40   0   Street 2  
42 STR_SUPPL2 AD_STRSPP2 TEXT40 CHAR 40   0   Street 3  
43 STR_SUPPL3 AD_STRSPP3 TEXT40 CHAR 40   0   Street 4  
44 COUNTRY LAND1 LAND1 CHAR 3   0   Country Key  
45 REGION REGIO REGIO CHAR 3   0   Region (State, Province, County)  
46 HOUSE_NUM2 AD_HSNM2 TEXT10 CHAR 10   0   House number supplement  
47 LOCATION AD_LCTN TEXT40 CHAR 40   0   Street 5  
48 TEL_NUMBER AD_TLNMBR1 CHAR30 CHAR 30   0   First telephone no.: dialling code+number  
49 TEL_EXTENS AD_TLXTNS1 CHAR10 CHAR 10   0   First Telephone No.: Extension  
50 FAX_NUMBER AD_FXNMBR1 CHAR30 CHAR 30   0   First fax no.: dialling code+number  
51 FAX_EXTENS AD_FXXTNS1 CHAR10 CHAR 10   0   First fax no.: extension  
52 PARTNER EHSWAE_PARTNER EHSWAD_PARTNER CHAR 10   0   Business Partner for Waste Management  
53 RLTYP EHSWAE_WABPROLE BU_RLTYP CHAR 6   0   Business Partner Role in Waste Management TBZ0
54 WA_DSCRP_ROLE BU_RTITL TEXT25 CHAR 25   0   Title of Object Part  
55 SPRAS SPRAS SPRAS LANG 1   0   Language Key T002
56 INTAPPNO EHSWAE_APPNOINT EHSWAD_APPNOINT CHAR 10   0   Waste Approval  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 EHSWAV_APPBP LIZCAT EHSWAC_LIZCAT LIZCAT    
2 EHSWAV_APPBP MANDT T000 MANDT    
3 EHSWAV_APPBP RLTYP TBZ0 RLTYP    
4 EHSWAV_APPBP SPRAS T002 SPRAS KEY 1 CN
History
Last changed by/on SAP  20130529 
SAP Release Created in