SAP ABAP Table TNLGGZ_PRODUCT (Geisteskrankheit productkode)

Hierarchy

☛ IS-H (Software Component) SAP Healthcare
   ⤷ IS-H (Application Component) SAP Healthcare - Industry-Specific Components for Hospitals
     ⤷ NNL2 (Package) Anwendungsentwicklung Krankenhaussystem Niederlande 2

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	TNLGGZ_PRODUCT	Table Relationship Diagram
Short Description	Geisteskrankheit productkode

Delivery and Maintenance

Pool/cluster
Delivery Class	C	Customizing table, maintenance only by cust., not SAP import
Data Browser/Table View Maintenance	X	Display/Maintenance Allowed

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	EINRI	☑	EINRI	EINRI	CHAR	4	0	IS-H: Institution	TN01
3	SPEM	☑	ISH_NL_GGZ_SPEM	ISH_FACHR	CHAR	4	0	Geisteskrankheit fachrichtung	*
4	PROD_GRP	☑	ISH_NL_PRDCODE	TARLS	CHAR	10	0	IS-H NL: Produkt kode	*
5	ENDDT	☑	ISH_NL_DBC_ENDDT	DATUM	DATS	8	0	ISH_NL: Ende datum
6	BEGDT	☐	ISH_NL_DBC_BEGDT	DATUM	DATS	8	0	ISH_NL: Anfang datum
7	STAY_CODE	☐	ISH_NL_GGZ_STAY_CODE	ISH_NL_GGZ_STAY_CODE	CHAR	3	0	Geisteskrankheit productkode aufenthalt
8	STAY_TEXT	☐	ISH_NL_GGZ_STAY_TXT	ISH_NL_GGZ_TXT	CHAR	255	0	Geisteskrankheit productkode aufenthalt beschreibung
9	TREAT_CODE	☐	ISH_NL_GGZ_TRTM_CODE	ISH_NL_GGZ_TRTM_CODE	CHAR	3	0	Geisteskrankheit productkode behandlung
10	TREAT_TEXT	☐	ISH_NL_GGZ_TRTM_TXT	ISH_NL_GGZ_TXT	CHAR	255	0	Geisteskrankheit productkode behandlung beschreibung
11	TYPE_CODE	☐	ISH_NL_GGZ_TYPE_CODE	ISH_NL_GGZ_TYPE_CODE	CHAR	20	0	Geisteskrankheit productkode type
12	TYPE_TEXT	☐	ISH_NL_GGZ_TYPE_TXT	ISH_NL_GGZ_TXT	CHAR	255	0	Geisteskrankheit productkode type beschreibung
13	PROD_KZ	☐	ISH_NL_GGZ_PRD_KZ	ISH_NL_GGZ_KZ	CHAR	10	0	Geisteskrankheit productkode kennzeichen
14	SETTING	☐	ISH_NL_GGZ_SETTING	ISH_NL_GGZ_SETTING	CHAR	20	0	Geisteskrankheit productkode fassung
15	CATEGORY	☐	ISH_NL_GGZ_CATEGORY	ISH_NL_GGZ_CATEGORY	CHAR	50	0
16	LAY_TEXT	☐	ISH_NL_GGZ_LAY_TXT	ISH_NL_GGZ_LAY_TXT	CHAR	200	0	Geisteskrankheit leistungscode laientext
17	ANONYM	☐	ISH_NL_GGZ_ANONYM	ISH_TRUE_FALSE	CHAR	1	0	Geisteskrankheit anonym kennzeichen

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	TNLGGZ_PRODUCT	EINRI	TN01	EINRI	KEY
2	TNLGGZ_PRODUCT	MANDT	T000	MANDT	KEY

History

Last changed by/on	SAP	20080505
SAP Release Created in	700