SAP ABAP Table ISH_MM_CONSUMP (IS-H MM: Case-Rel. Material Consumption / NMATV and Texts)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ NPAS (Package) Application development patient accounting system

Basic Data

Table Category	INTTAB	Structure
Structure	ISH_MM_CONSUMP	Table Relationship Diagram
Short Description	IS-H MM: Case-Rel. Material Consumption / NMATV and Texts

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	.INCLUDE	☐				0	0	IS-H: Material Issued for Case
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
3	LNRLM	☐	ISH_LNRLP	ISH_LNRLM	CHAR	10	0	IS-H MM: Sequence Number of Material Consumption
4	LNRLM_P	☐	ISH_LNRLM	ISH_LNRLM	CHAR	10	0	IS-H MM: Sequence Number of a Material Requisition
5	FALNR	☐	FALNR	FALNR	CHAR	10	0	IS-H: Case Number	NFAL
6	EINRI	☐	EINRI	EINRI	CHAR	4	0	IS-H: Institution	*
7	LNRLS	☐	LNRLS	LNRLS	CHAR	10	0	IS-H: Service Sequence Number
8	MATNR	☐	ISH_MMATNR_CONS	MATNR	CHAR	18	0	IS-H: Material Number for Material Consumption	*
9	WERKS	☐	ISH_MWERKS	WERKS	CHAR	4	0	IS-H MM: Issuing Point for Material (e.g. Pharmacy)	*
10	MBLNR	☐	ISH_MBLNR	BELNR	CHAR	10	0	IS-H MM: Number of a material document
11	MBPOS	☐	ISH_MBPOS	BNFPO	NUMC	5	0	IS-H MM: Item Number on the Material Document	*
12	MJAHR	☐	ISH_MJAHR	GJAHR	NUMC	4	0	IS-H MM: Material Document Year
13	EXMAT	☐	ISH_EXMAT	ISH_EXMAT	CHAR	20	0	IS-H: External material number
14	ANFOE	☐	ANFOE	ORGID	CHAR	8	0	IS-H: Departmental Org. Unit Requesting Service	*
15	ANPOE	☐	ANPOE	ORGID	CHAR	8	0	IS-H: Nursing Org. Unit Requesting Service	*
16	ERBOE	☐	ERBOE	ORGID	CHAR	8	0	IS-H: Organizational Unit that Performs the Service	*
17	PREIS	☐	ISH_MPREIS	ISH_WERTV6	CURR	11	2	IS-H MM: Price of material
18	WAERS	☐	ISH_WAERS	WAERS	CUKY	5	0	IS-H: Currency Key	*
19	ABRKZ	☐	ISH_MABRKZ	ISH_MABRKZ	CHAR	1	0	IS-H: Indicator whether Material can be Billed for
20	MENGE	☐	ISH_MENGE	MENGV8	QUAN	15	3	IS-H MM: Quantity of Material
21	MEINS	☐	ISH_MEINS	MEINS	UNIT	3	0	IS-H: Unit of Measure	T006
22	SHKZG	☐	ISH_MSHKZG	SHKZG	CHAR	1	0	Debit/Credit Indicator
23	CHARG	☐	CHARG_D	CHARG	CHAR	10	0	Batch Number	*
24	TCODE	☐	ISH_TCODE	TCODE	CHAR	20	0	IS-H: Report Control: Transaction Code for Application	*
25	ERDAT	☐	RI_ERDAT	RI_DATUM	DATS	8	0	IS-H: Date when Record Created
26	ERUSR	☐	RI_ERNAM	USNAM	CHAR	12	0	IS-H: Name of Employee who Created Record
27	UPDAT	☐	RI_UPDAT	RI_DATUM	DATS	8	0	IS-H: Date of Last Change
28	UPUSR	☐	RI_UPNAM	USNAM	CHAR	12	0	IS-H: Name of Person who Last Changed Data
29	STORN	☐	RI_STORN	XFELD	CHAR	1	0	IS-H: Cancellation Indicator
30	STUSR	☐	STORN_USER	USNAM	CHAR	12	0	IS-H: Name of User who Canceled Data Record
31	STBEL	☐	ISH_LNRLPREF	ISH_LNRLM	CHAR	10	0	IS-H MM: Reference to Cancellation Doc. of Mat. Consumption
32	HCOKZ	☐	ISH_MHCOKZ	XFELD	CHAR	1	0	IS-H: Indicator for CO-Relevant Material Consumption
33	UBLKZ	☐	ISH_UBLKZ	ISH_UBLKZ	CHAR	1	0	IS-HCO: Transfer Indicator for Service/Material
34	UAEKZ	☐	ISH_UAEKZ	XFELD	CHAR	1	0	IS-HCO: Service/Material Was Changed after Transfer into CO
35	MATFTEXT	☐	ISH_MMFTEXT	TEXT40	CHAR	40	0	IS-H MM: Material Text / Free Text
36	EXCHARG	☐	ISH_MEXCHN	LICHN	CHAR	15	0	IS-H MM: Vendor Batch Number
37	CONSDT	☐	ISH_MCONSDT	DATUM	DATS	8	0	IS-H MM: Date of Material Administration
38	CONSTM	☐	ISH_MCONSTM	UZEIT	TIMS	6	0	IS-H MM: Time of Material Administration
39	PERNR	☐	ISH_PERNR_MAT	RI_KUNNR	CHAR	10	0	Ordering Physician	*
40	.INCLUDE	☐				0	0	IS-H MM: Details, Texts for Case-Rel. Case Consumption
41	ANFOEKB	☐	ISH_ANFOEKB	TEXT12	CHAR	12	0	IS-H: Dept. Org. Unit. Requesting Service
42	ANPOEKB	☐	ISH_ANPOEKB	TEXT12	CHAR	12	0	IS-H: Nursing Org. Unit Requesting Service
43	MAKTX	☐	MAKTX	TEXT40	CHAR	40	0	Material description
44	MATKL	☐	MATKL	MATKL	CHAR	9	0	Material Group	*
45	MTART	☐	MTART	MTART	CHAR	4	0	Material type	*
46	WERKS_NAME1	☐	ISH_MWERKS_TXT	TEXT30	CHAR	30	0	IS-H: Name of Plant
47	MATNAM	☐	ISH_MATNAM	TEXT40	CHAR	40	0	Last and First Name of Ordering Physician
48	PATNR	☐	PATNR	PATNR	CHAR	10	0	IS-H: Patient Number
49	PATNAM	☐	RI_NAME	TEXT30	CHAR	30	0	IS-H: Patient Name

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	ISH_MM_CONSUMP	FALNR	NFAL	FALNR	KEY	1	CN
2	ISH_MM_CONSUMP	MANDT	T000	MANDT	KEY	1	CN
3	ISH_MM_CONSUMP	MEINS	T006	MSEHI	KEY	1	CN

History

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