SAP ABAP Table U_17608 (Generated Table for View U_17608)

Basic Data

Table Category	VIEW	General view structure
General view structure	U_17608	Table Relationship Diagram
Short Description	Generated Table for View U_17608

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	T000
2	LNRLM	☑	ISH_LNRLM	ISH_LNRLM	CHAR	10	0	IS-H MM: Sequence Number of a Material Requisition
3	FALNR	☐	FALNR	FALNR	CHAR	10	0	IS-H: Case Number	NFAL
4	EINRI	☐	EINRI	EINRI	CHAR	4	0	IS-H: Institution	TN01
5	MATNR	☐	ISH_MMATNR	MATNR	CHAR	18	0	IS-H: Material number for material requisition	MARA
6	MBLNR	☐	ISH_MBLNR	BELNR	CHAR	10	0	IS-H MM: Number of a material document
7	MBPOS	☐	ISH_MBPOS	BNFPO	NUMC	5	0	IS-H MM: Item Number on the Material Document
8	MJAHR	☐	ISH_MJAHR	GJAHR	NUMC	4	0	IS-H MM: Material Document Year
9	WERKS	☐	ISH_MWERKS	WERKS	CHAR	4	0	IS-H MM: Issuing Point for Material (e.g. Pharmacy)	TNM01
10	EXMAT	☐	ISH_EXMAT	ISH_EXMAT	CHAR	20	0	IS-H: External material number
11	ANFOE	☐	ANFOE	ORGID	CHAR	8	0	IS-H: Departmental Org. Unit Requesting Service	NORG
12	ANPOE	☐	ANPOE	ORGID	CHAR	8	0	IS-H: Nursing Org. Unit Requesting Service	NORG
13	ERBOE	☐	ERBOE	ORGID	CHAR	8	0	IS-H: Organizational Unit that Performs the Service
14	PREIS	☐	ISH_MPREIS	ISH_WERTV6	CURR	11	2	IS-H MM: Price of material
15	WAERS	☐	ISH_WAERS	WAERS	CUKY	5	0	IS-H: Currency Key
16	ABRKZ	☐	ISH_MABRKZ	ISH_MABRKZ	CHAR	1	0	IS-H: Indicator whether Material can be Billed for
17	MENGE	☐	ISH_MENGE	MENGV8	QUAN	15	3	IS-H MM: Quantity of Material
18	MEINS	☐	ISH_MEINS	MEINS	UNIT	3	0	IS-H: Unit of Measure
19	GESTA	☐	ISH_MGESTA	ISH_MGESTA	CHAR	1	0	IS-H MM: Approval Status for Material Requisition
20	GENAM	☐	ISH_MGENAM	USNAM	CHAR	12	0	IS-H MM: Name of the approval giver
21	GEDAT	☐	ISH_MGEDAT	RI_DATUM	DATS	8	0	IS-H MM: Date of Approval
22	TCODE	☐	ISH_TCODE	TCODE	CHAR	20	0	IS-H: Report Control: Transaction Code for Application
23	ERDAT	☐	RI_ERDAT	RI_DATUM	DATS	8	0	IS-H: Date when Record Created
24	ERUSR	☐	RI_ERNAM	USNAM	CHAR	12	0	IS-H: Name of Employee who Created Record
25	UPDAT	☐	RI_UPDAT	RI_DATUM	DATS	8	0	IS-H: Date of Last Change
26	UPUSR	☐	RI_UPNAM	USNAM	CHAR	12	0	IS-H: Name of Person who Last Changed Data
27	STORN	☐	RI_STORN	XFELD	CHAR	1	0	IS-H: Cancellation Indicator
28	STUSR	☐	STORN_USER	USNAM	CHAR	12	0	IS-H: Name of User who Canceled Data Record

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	U_17608	ANFOE	NORG	ORGID	KEY	1	CN
2	U_17608	ANPOE	NORG	ORGID	KEY	1	CN
3	U_17608	EINRI	TN01	EINRI	KEY	1	CN
4	U_17608	FALNR	NFAL	FALNR	KEY	1	CN
5	U_17608	MANDT	T000	MANDT	KEY	1	CN
6	U_17608	MATNR	MARA	MATNR	KEY	1	CN
7	U_17608	WERKS	TNM01	WERKS	KEY	1	CN

History

Last changed by/on	SAP	20050224
SAP Release Created in