SAP ABAP View V_N_MD_STATUS (IS-H: View for Search Help Med. Basic Documentation Statuses)

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_STATUS
Short Description	IS-H: View for Search Help Med. Basic Documentation Statuses
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		NE	'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	463B