SAP ABAP View V_N_MD_FAS (IS-H: View for Search Help Dept Status Basic Medical Doc.)
Hierarchy
☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ NPVS (Package) Application development patient management system
Basic Data
View Type D Database View 
Database View V_N_MD_FAS  
Short Description IS-H: View for Search Help Dept Status Basic Medical Doc.    
Root table TJ30   Status 
Table
# Table Name Foreign Table Foreign Field Foreign DIR
1 TJ30 TJ30
2 TJ30T  
3 TJ20  
4 TJ20T  
5 TJ21  
Join Conditions
# Table Name Field Name Negation Operator Constants Cont. line AND/OR Offset F Length Mco Field
1 TJ30 MANDT JL EQ 0 0
2 TJ30T MANDT JR EQ AND 0 0
3 TJ30 STSMA JL EQ 0 0
4 TJ30T STSMA JR EQ AND 0 0
5 TJ30 ESTAT JL EQ 0 0
6 TJ30T ESTAT JR EQ AND 0 0
7 TJ30 MANDT JL EQ 0 0
8 TJ20 MANDT JR EQ AND 0 0
9 TJ20 MANDT JL EQ 0 0
10 TJ20T MANDT JR EQ AND 0 0
11 TJ20 STSMA JL EQ 0 0
12 TJ20T STSMA JR EQ AND 0 0
13 TJ30 STSMA JL EQ 0 0
14 TJ20 STSMA JR EQ AND 0 0
15 TJ30T SPRAS JL EQ 0 0
16 TJ20T SPRAS JR EQ AND 0 0
17 TJ30 MANDT JL EQ 0 0
18 TJ21 MANDT JR EQ AND 0 0
19 TJ30 STSMA JL EQ 0 0
20 TJ21 STSMA JR EQ AND 0 0
21 TJ21 OBTYP EQ 'NF' AND 0 0
22 TJ30 STONR EQ '00' 0 0
                     
View Fields
# View field Table Field Maintenance Flag Key Data element Mod Short Description
1 MANDT TJ30 MANDT   MANDT Client
2 STONR TJ30 STONR   J_STONR Status Order Number
3 TXT04 TJ30T TXT04   N_MD_STATUS_TXT04 IS-H: Key of Basic Medical Documentation Status
4 TXT30 TJ30T TXT30   N_MD_STATUS_TXT30 IS-H: Text of Status for Medical Basic Documentation
5 STSMA TJ30 STSMA   N_MD_STSMA IS-H: Status Profile for Basic Medical Documentation
6 TXT TJ20T TXT   N_MD_STSMA_TXT30 IS-H: Text for Status Profile of Medical Basic Documentation
7 ESTAT TJ30 ESTAT   N_MD_STATUS_STAT IS-H: Key of Status for Basic Medical Documentation
8 SPRAS TJ20T SPRAS   SPRAS Language Key
                 
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 472