SAP ABAP View USTSTCAP (Transaction codes from TSTCA for existing profiles)
Hierarchy
SAP_BASIS (Software Component) SAP Basis Component
   BC-SEC-USR-ADM (Application Component) User and Authorization Management
     SUSR (Package) ABAP User Administration
Basic Data
View Type D Database View 
Database View USTSTCAP  
Short Description Transaction codes from TSTCA for existing profiles    
Root table UST10S   User master: Single profiles 
Table
# Table Name Foreign Table Foreign Field Foreign DIR
1 UST10S UST10S
2 UST12  
3 TSTCA  
4 TSTCT  
Join Conditions
# Table Name Field Name Negation Operator Constants Cont. line AND/OR Offset F Length Mco Field
1 UST10S MANDT JL EQ 0 0
2 UST12 MANDT JR EQ AND 0 0
3 UST10S OBJCT JL EQ 0 0
4 UST12 OBJCT JR EQ AND 0 0
5 UST10S AUTH JL EQ 0 0
6 UST12 AUTH JR EQ AND 0 0
7 UST12 FIELD JL EQ 0 0
8 TSTCA FIELD JR EQ AND 0 0
9 UST12 OBJCT JL EQ 0 0
10 TSTCA OBJCT JR EQ AND 0 0
11 TSTCA TCODE JL EQ 0 0
12 TSTCT TCODE JR EQ AND 0 0
13 UST10S AKTPS EQ 'A' 0 0
                     
View Fields
# View field Table Field Maintenance Flag Key Data element Mod Short Description
1 MANDT UST10S MANDT   MANDT Client
2 PROFN UST10S PROFN   XUPROFILE Profile name
3 TCODE TSTCA TCODE   TCODE Transaction Code
4 TTEXT TSTCT TTEXT   TTEXT_STCT Transaction text
5 SPRSL TSTCT SPRSL   SPRAS Language Key
6 AUTH UST10S AUTH   XUAUTH Authorization name in user master maintenance
7 FIELD TSTCA FIELD   XUFIELD Authorization Field
8 OBJCT TSTCA OBJCT   XUOBJECT Authorization Object
9 VALUE TSTCA VALUE   XUVAL Authorization Value
10 VON UST12 VON   XUVAL Authorization Value
11 BIS UST12 BIS   XUVAL Authorization Value
                 
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