SAP ABAP View SMOEDELSIT_V (Deletion Check of Sites Protected by Subscription Agent)
Hierarchy
BBPCRM (Software Component) BBPCRM
   CRM-MW-ADM (Application Component) Administration Console
     SMOE (Package) AdminConsole
Basic Data
View Type D Database View 
Database View SMOEDELSIT_V  
Short Description Deletion Check of Sites Protected by Subscription Agent    
Root table SMOEGENSSI   Link bt. generators and generated site/subscription assign. 
Table
# Table Name Foreign Table Foreign Field Foreign DIR
1 SMOEGENSSI SMOEGENSSI
2 SMOEGENACT  
3 SMOEGENHEA  
Join Conditions
# Table Name Field Name Negation Operator Constants Cont. line AND/OR Offset F Length Mco Field
1 SMOEGENACT MANDT JL EQ 0 0
2 SMOEGENSSI MANDT JR EQ AND 0 0
3 SMOEGENACT SMOEGENHEA JL EQ 0 0
4 SMOEGENSSI SMOEGENHEA JR EQ AND 0 0
5 SMOEGENHEA SMOEGENHEA JL EQ 0 0
6 SMOEGENSSI SMOEGENHEA JR EQ AND 0 0
7 SMOEGENSSI DELETED EQ '0' 0 0
                     
View Fields
# View field Table Field Maintenance Flag Key Data element Mod Short Description
1 MANDT SMOEGENSSI MANDT   MANDT Client
2 SMOEGENSSI SMOEGENSSI SMOEGENSSI   SMOESSIKEY Key link between generators and subsit
3 SMOHSUBSCR SMOEGENSSI SMOHSUBSCR   SMO_SUBSCR Subscription Key
4 SITE_ID SMOEGENSSI SITE_ID   SMO_SITEID Site ID
5 SMOEGENHEA SMOEGENSSI SMOEGENHEA   SMOEHEADER Key of Header Record for a Subscription Generator
6 ACTIVE SMOEGENACT ACTIVE   SMOEACTIVE Status Flag of Subscription Generator (Values: See Domain)
7 PROTECT_SITE SMOEGENACT PROTECT_SITE   SMOEPROTECT Protection of Generated Objects
8 PROTECT_SUBSCR SMOEGENACT PROTECT_SUBSCR   SMOEPROTECT Protection of Generated Objects
9 PROTECT_SUBSIT SMOEGENACT PROTECT_SUBSIT   SMOEPROTECT Protection of Generated Objects
10 NAME SMOEGENHEA NAME   SMOEGENNAM Name of header record for a subscription generator
11 SYSTEM_ID SMOEGENHEA SYSTEM_ID   SMOESYSTID Id of system on which the generator was created
12 DEL_ACTION SMOEGENHEA DEL_ACTION   SMOE_DEL_ACTION Flag for Action to Be Triggered by Deletion
                 
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  20130604 
SAP Release Created in 400