SAP ABAP Table U_17607 (Generated Table for View U_17607)

Basic Data

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

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

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	U_17607	ANFOE	NORG	ORGID	KEY	1	CN
2	U_17607	ANPOE	NORG	ORGID	KEY	1	CN
3	U_17607	MANDT	T000	MANDT	KEY	1	CN
4	U_17607	MATNR	MARC	MATNR	KEY	1	CN
5	U_17607	MEINS	T006	MSEHI	KEY	1	CN
6	U_17607	TCODE	TSTC	TCODE	KEY	1	CN
7	U_17607	WERKS	T001W	WERKS

History

Last changed by/on	SAP	20050224
SAP Release Created in