SAP ABAP View EHSWAV_PART_ROLL (Database View: Search for Waste Management Business Partner)
Hierarchy
EA-APPL (Software Component) SAP Enterprise Extension PLM, SCM, Financials
   EHS-WA (Application Component) Waste Management
     CBWA (Package) EH&S: Waste Management
Basic Data
View Type D Database View 
Database View EHSWAV_PART_ROLL  
Short Description Database View: Search for Waste Management Business Partner    
Root table EHSWAT000   MD (BDT): Master Table for the Waste Management Master Data 
Table
# Table Name Foreign Table Foreign Field Foreign DIR
1 EHSWAT000 EHSWAT000
2 EHSWAT001  
3 EHSWAT100  
4 TBZ0T  
Join Conditions
# Table Name Field Name Negation Operator Constants Cont. line AND/OR Offset F Length Mco Field
1 EHSWAT100 MANDT JL EQ 0 0
2 EHSWAT000 MANDT JR EQ AND 0 0
3 EHSWAT001 MANDT JL EQ 0 0
4 EHSWAT100 MANDT JR EQ AND 0 0
5 TBZ0T CLIENT JL EQ 0 0
6 EHSWAT100 MANDT JR EQ AND 0 0
7 EHSWAT100 RECNROOT JL EQ 0 0
8 EHSWAT000 RECN JR EQ AND 0 0
9 EHSWAT001 RECN JL EQ 0 0
10 EHSWAT100 RECN JR EQ AND 0 0
11 EHSWAT100 RLTYP JL EQ 0 0
12 TBZ0T RLTYP JR EQ AND 0 0
13 EHSWAT000 DELFLG NE 'X' AND 0 0
14 EHSWAT001 DELFLG NE 'X' AND 0 0
15 EHSWAT100 DELFLG NE 'X' AND 0 0
16 TBZ0T OBJAP EQ 'WAMA' 0 0
                     
View Fields
# View field Table Field Maintenance Flag Key Data element Mod Short Description
1 MANDT EHSWAT000 MANDT   MANDT Client
2 RLTYP EHSWAT100 RLTYP   EHSWAE_WABPROLE Business Partner Role in Waste Management
3 PARTNER EHSWAT000 PARTNER   EHSWAE_PARTNER Business Partner for Waste Management
4 BEZ50 TBZ0T BEZ50   BU_BEZ50 Description
5 SPRAS TBZ0T SPRAS   SPRAS Language Key
6 WABPCAT EHSWAT001 WABPCAT   EHSWAE_WABPCAT Partner Type
7 RECN EHSWAT001 RECN   EHSBE_UUID_32 GUID Number
                 
Maintenance Status
Access
  read only
  read and change
  Time-dependent views: like U, validity data like ' '
  read, change, delete and insert
Delivery Class      
Data Browser/Table View Maintenance    Display/Maintenance Allowed with Restrictions  
History
Last changed by/on SAP  20130529 
SAP Release Created in