SAP ABAP Table IOOPPREQ (DB structure for purchase req. - order infosystem)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ PP-SFC (Application Component) Production Orders
     ⤷ COIS (Package) Order Information System

Basic Data

Table Category	INTTAB	Structure
Structure	IOOPPREQ	Table Relationship Diagram
Short Description	DB structure for purchase req. - order infosystem

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	Purchase requisition structure for order info.system
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	*
3	BANFN	☐	BANFN	BANFN	CHAR	10	0	Purchase requisition number
4	BNFPO	☐	BNFPO	BNFPO	NUMC	5	0	Item number of purchase requisition	*
5	BSART	☐	BBSRT	BSART	CHAR	4	0	Purchase Requisition Document Type	*
6	BSTYP	☐	BSTYP	BSTYP	CHAR	1	0	Purchasing document category
7	STATU	☐	BANST	BANST	CHAR	1	0	Processing status of purchase requisition
8	EKGRP	☐	EKGRP	EKGRP	CHAR	3	0	Purchasing group	*
9	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
10	ERDAT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
11	TXZ01	☐	TXZ01	TEXT40	CHAR	40	0	Short Text
12	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	*
13	WERKS	☐	EWERK	WERKS	CHAR	4	0	Plant	*
14	LGORT	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	*
15	MATKL	☐	MATKL	MATKL	CHAR	9	0	Material Group	*
16	MENGE	☐	BAMNG	MENG13	QUAN	13	3	Purchase requisition quantity
17	MEINS	☐	BAMEI	MEINS	UNIT	3	0	Purchase requisition unit of measure	*
18	LFDAT	☐	EINDT	DATUM	DATS	8	0	Item delivery date
19	FRGDT	☐	FRGDT	DATUM	DATS	8	0	Purchase Requisition Release Date
20	WEBAZ	☐	WEBAZ	DEC3	DEC	3	0	Goods receipt processing time in days
21	PREIS	☐	BAPRE	WERT11	CURR	11	2	Price in Purchase Requisition
22	PEINH	☐	EPEIN	DEC5	DEC	5	0	Price unit
23	PSTYP	☐	PSTYP	PSTYP	CHAR	1	0	Item category in purchasing document	*
24	KNTTP	☐	KNTTP	KNTTP	CHAR	1	0	Account assignment category	*
25	WEPOS	☐	WEPOS	XFELD	CHAR	1	0	Goods Receipt Indicator
26	REPOS	☐	REPOS	XFELD	CHAR	1	0	Invoice receipt indicator
27	LIFNR	☐	WLIEF	LIFNR	CHAR	10	0	Desired vendor	*
28	FLIEF	☐	FLIEF	LIFNR	CHAR	10	0	Fixed vendor	*
29	EKORG	☐	EKORG	EKORG	CHAR	4	0	Purchasing organization	*
30	KONNR	☐	KONNR	EBELN	CHAR	10	0	Number of principal purchase agreement	*
31	KTPNR	☐	KTPNR	EBELP	NUMC	5	0	Item number of principal purchase agreement	*
32	INFNR	☐	INFNR	INFNR	CHAR	10	0	Number of purchasing info record	*
33	EBELN	☐	BSTNR	EBELN	CHAR	10	0	Purchase order number	*
34	EBELP	☐	BSTPO	EBELP	NUMC	5	0	Purchase order item number	*
35	BEDAT	☐	BEDAT	DATUM	DATS	8	0	Purchase Order Date
36	BSMNG	☐	BSMNG	MENG13	QUAN	13	3	Quantity ordered against this purchase requisition
37	EBAKZ	☐	EBAKZ	XFELD	CHAR	1	0	Purchase requisition closed
38	BPUEB	☐	BPUEB	BPUEB	CHAR	1	0	Adopt requisition price in purchase order
39	FRGGR	☐	FRGGR	FRGGR	CHAR	2	0	Release group	*
40	FRGKZ	☐	FRGKZ	FRGKZ	CHAR	1	0	Release Indicator	*
41	FRGZU	☐	FRGZU	FRGZU	CHAR	8	0	Release status
42	FRGST	☐	FRGST	FRGST	CHAR	2	0	Release strategy in the purchase requisition
43	FRGRL	☐	FRGRL	XFELD	CHAR	1	0	Release Not Yet Completely Effected
44	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
45	KZ_MARK	☐	CHAR1	CHAR1	CHAR	1	0	Single-Character Flag
46	INDEX_NODE	☐	TABIX_D	TABIX	INT4	10	0	Field defined as in SY-TABIX
47	AUFNR	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	*
48	APLFL	☐	APLFL	PLNFOLGE	CHAR	6	0	Sequence number
49	VORNR	☐	VORNR	VORNR	CHAR	4	0	Operation/Activity Number
50	UVORN	☐	UVORN	VORNR	CHAR	4	0	Suboperation
51	PHFLG	☐	PHFLG	XFELD	CHAR	1	0	Indicator: Phase
52	RSNUM	☐	RSNUM	RSNUM	NUMC	10	0	Number of reservation/dependent requirements	*
53	RSPOS	☐	RSPOS	RSPOS	NUMC	4	0	Item Number of Reservation / Dependent Requirements
54	.INCLUDE	☐				0	0

History

Last changed by/on	SAP	20110901
SAP Release Created in