SAP ABAP Table NBWD_0HC_MATERIA_ATTR (IS-H: Extract Structure for Material Master Enhancement ->BW)

Hierarchy

☛ IS-H (Software Component) SAP Healthcare
   ⤷ IS-H-IS (Application Component) Information System
     ⤷ NBWD (Package) IS-H: Data Sources for Business Information Warehouse

Basic Data

Table Category	INTTAB	Structure
Structure	NBWD_0HC_MATERIA_ATTR	Table Relationship Diagram
Short Description	IS-H: Extract Structure for Material Master Enhancement ->BW

Delivery and Maintenance

Pool/cluster
Delivery Class
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	*
2	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	*
3	.INCLUDE	☐				0	0	IS-H MM: Append Structure for MARA
4	ISH_AGENT1	☐	ISH_AGENT1	ISH_AGENT	CHAR	20	0	IS-H MM: Active Ingredient 1 (Main Active Ingredient)	TNM50A
5	ISH_AG1QUANT	☐	ISH_AGQUANT	MENG12_3	QUAN	12	3	IS-H MM: Quantity of Active Ingredient in a Material
6	ISH_AG1UNIT	☐	ISH_AGUNIT	MEINS	UNIT	3	0	IS-H MM: Unit of Measure of Active Ingredient in a Material	T006
7	ISH_AGENT2	☐	ISH_AGENT2	ISH_AGENT	CHAR	20	0	IS-H MM: Active Ingredient 2	TNM50A
8	ISH_AG2QUANT	☐	ISH_AGQUANT	MENG12_3	QUAN	12	3	IS-H MM: Quantity of Active Ingredient in a Material
9	ISH_AG2UNIT	☐	ISH_AGUNIT	MEINS	UNIT	3	0	IS-H MM: Unit of Measure of Active Ingredient in a Material	T006
10	ISH_AGENT3	☐	ISH_AGENT3	ISH_AGENT	CHAR	20	0	IS-H MM: Active Ingredient 3	TNM50A
11	ISH_AG3QUANT	☐	ISH_AGQUANT	MENG12_3	QUAN	12	3	IS-H MM: Quantity of Active Ingredient in a Material
12	ISH_AG3UNIT	☐	ISH_AGUNIT	MEINS	UNIT	3	0	IS-H MM: Unit of Measure of Active Ingredient in a Material	T006
13	ISH_KAT1	☐	ISH_KZKAT1	XFELD	CHAR	1	0	IS-H MM: Catalog 1 Indicator
14	ISH_KAT2	☐	ISH_KZKAT2	XFELD	CHAR	1	0	IS-H MM: Catalog 2 Indicator
15	ISH_KAT3	☐	ISH_KZKAT3	XFELD	CHAR	1	0	IS-H MM: Catalog 3 Indicator
16	ISH_BTM	☐	ISH_KZBTM	XFELD	CHAR	1	0	IS-H MM: Anesthetic Indicator
17	ISH_IMP	☐	ISH_KZIMP	XFELD	CHAR	1	0	IS-H MM: Imported Material Indicator
18	ISH_GEF	☐	ISH_KZGEF	XFELD	CHAR	1	0	IS-H MM: Hazardous Substance Indicator
19	ISH_ATC	☐	ISH_ATC	ISH_MCATID	CHAR	20	0	IS-H MM: ATC Code	TNM60A
20	ISH_GEART	☐	ISH_MGEART	ISH_MGEART	CHAR	2	0	IS-H MM: Approval Type	TNM10A
21	ISH_BILMOD	☐	ISH_MM_BILMOD	ISH_MM_BILMOD	CHAR	1	0	Mode for Case-Related Material Billing
22	ISH_ATCMCATTYP	☐	ISH_MCATTYP	ISH_MCATTYP	CHAR	3	0	IS-H MM: Type of a Medical Category

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	NBWD_0HC_MATERIA_ATTR	ISH_AG1UNIT	T006	MSEHI	REF	1	CN
2	NBWD_0HC_MATERIA_ATTR	ISH_AG2UNIT	T006	MSEHI	REF	1	CN
3	NBWD_0HC_MATERIA_ATTR	ISH_AG3UNIT	T006	MSEHI	REF	1	CN
4	NBWD_0HC_MATERIA_ATTR	ISH_AGENT1	TNM50A	AGENT	REF	1	CN
5	NBWD_0HC_MATERIA_ATTR	ISH_AGENT2	TNM50A	AGENT	REF	1	CN
6	NBWD_0HC_MATERIA_ATTR	ISH_AGENT3	TNM50A	AGENT	REF	1	CN
7	NBWD_0HC_MATERIA_ATTR	ISH_ATC	TNM60A	CATID	REF	1	CN
8	NBWD_0HC_MATERIA_ATTR	ISH_GEART	TNM10A	GEART	REF	1	CN

History

Last changed by/on	SAP	20070917
SAP Release Created in