SAP ABAP Table NWCHGALDAT (IS-H CH: Zuordnung Materialnummer->Pharmacode (GalDat))

Hierarchy

☛ IS-H (Software Component) SAP Healthcare
   ⤷ IS-H (Application Component) SAP Healthcare - Industry-Specific Components for Hospitals
     ⤷ NCH1 (Package) IS-H: Landesversion Schweiz

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	NWCHGALDAT	Table Relationship Diagram
Short Description	IS-H CH: Zuordnung Materialnummer->Pharmacode (GalDat)

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

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	MATNR	☑	MATNR	MATNR	CHAR	18	0	Material Number	MARA
3	PHARMACODE	☐	NWCHPHAR	NUMC13	NUMC	13	0	IS-H CH: Pharmacode für GalDat
4	MTART	☐	MTART	MTART	CHAR	4	0	Material type	T134
5	MATKL	☐	MATKL	MATKL	CHAR	9	0	Material Group	T023
6	MBRSH	☐	MBRSH	MBRSH	CHAR	1	0	Industry sector	T137
7	PRDHA	☐	PRODH_D	PRODH	CHAR	18	0	Product Hierarchy	T179
8	BKLAS	☐	BKLAS	BKLAS	CHAR	4	0	Valuation Class	T025
9	MEINH	☐	LRMEI	MEINS	UNIT	3	0	Alternative Unit of Measure for Stockkeeping Unit	T006
10	BWKEY	☐	BWKEY	BWKEY	CHAR	4	0	Valuation area	T001K

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	NWCHGALDAT	BKLAS	T025	BKLAS	REF	1	CN
2	NWCHGALDAT	BWKEY	T001K	BWKEY	REF	1	CN
3	NWCHGALDAT	MANDT	T000	MANDT	KEY	1	CN
4	NWCHGALDAT	MATKL	T023	MATKL	REF	1	CN
5	NWCHGALDAT	MATNR	MARA	MATNR	KEY	1	1
6	NWCHGALDAT	MBRSH	T137	MBRSH	REF	1	CN
7	NWCHGALDAT	MEINH	T006	MSEHI	REF	1	CN
8	NWCHGALDAT	MTART	T134	MTART	REF	1	CN
9	NWCHGALDAT	PRDHA	T179	PRODH	REF	1	CN

History

Last changed by/on	SAP	20050224
SAP Release Created in	472