SAP ABAP Table IOSOPORD (Database structure for purchase order - order info.system)

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	IOSOPORD	Table Relationship Diagram
Short Description	Database structure for purchase order - order info.system

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 order header structure for order info.system
2	BSART	☐	ESART	BSART	CHAR	4	0	Purchasing Document Type	*
3	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
4	LIFNR	☐	ELIFN	LIFNR	CHAR	10	0	Vendor's account number	*
5	EKORG	☐	EKORG	EKORG	CHAR	4	0	Purchasing organization	*
6	EKGRP	☐	BKGRP	EKGRP	CHAR	3	0	Purchasing Group	*
7	FRGRL	☐	FRGRL	XFELD	CHAR	1	0	Release Not Yet Completely Effected
8	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
9	.INCLUDE	☐				0	0	Purchase order item - structure for order info.system
10	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	*
11	EBELN	☐	EBELN	EBELN	CHAR	10	0	Purchasing Document Number	*
12	EBELP	☐	EBELP	EBELP	NUMC	5	0	Item Number of Purchasing Document	*
13	LOEKZ	☐	ELOEK	ELOEK	CHAR	1	0	Deletion indicator in purchasing document
14	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
15	AEDAT	☐	ERDAT	DATUM	DATS	8	0	Date on which the record was created
16	KONNR	☐	KONNR	EBELN	CHAR	10	0	Number of principal purchase agreement	*
17	TXZ01	☐	TXZ01	TEXT40	CHAR	40	0	Short Text
18	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	*
19	BANFN	☐	BANFN	BANFN	CHAR	10	0	Purchase requisition number
20	BNFPO	☐	BNFPO	BNFPO	NUMC	5	0	Item number of purchase requisition	*
21	WERKS	☐	EWERK	WERKS	CHAR	4	0	Plant	*
22	LGORT	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	*
23	MATKL	☐	MATKL	MATKL	CHAR	9	0	Material Group	*
24	INFNR	☐	INFNR	INFNR	CHAR	10	0	Number of purchasing info record	*
25	MENGE	☐	BSTMG	MENG13	QUAN	13	3	Purchase Order Quantity
26	MEINS	☐	BSTME	MEINS	UNIT	3	0	Order unit	*
27	BPRME	☐	BBPRM	MEINS	UNIT	3	0	Order Price Unit (purchasing)	*
28	NETPR	☐	BPREI	WERT11	CURR	11	2	Net Price in Purchasing Document (in Document Currency)
29	PEINH	☐	EPEIN	DEC5	DEC	5	0	Price unit
30	NETWR	☐	BWERT	WERT7	CURR	13	2	Net Order Value in PO Currency
31	BRTWR	☐	BWERT	WERT7	CURR	13	2	Net Order Value in PO Currency
32	WEBAZ	☐	WEBAZ	DEC3	DEC	3	0	Goods receipt processing time in days
33	INSMK	☐	INSMK	INSMK	CHAR	1	0	Stock Type
34	ELIKZ	☐	ELIKZ	XFELD	CHAR	1	0	"Delivery Completed" Indicator
35	EREKZ	☐	EREKZ	XFELD	CHAR	1	0	Final Invoice Indicator
36	PSTYP	☐	PSTYP	PSTYP	CHAR	1	0	Item category in purchasing document	*
37	KNTTP	☐	KNTTP	KNTTP	CHAR	1	0	Account assignment category	*
38	WEPOS	☐	WEPOS	XFELD	CHAR	1	0	Goods Receipt Indicator
39	REPOS	☐	REPOS	XFELD	CHAR	1	0	Invoice receipt indicator
40	WEBRE	☐	WEBRE	XFELD	CHAR	1	0	Indicator: GR-Based Invoice Verification
41	KTPNR	☐	KTPNR	EBELP	NUMC	5	0	Item number of principal purchase agreement	*
42	PLIFZ	☐	EPLIF	DEC3	DEC	3	0	Planned Delivery Time in Days
43	WEMNG	☐	WEMNG	MENG13	QUAN	13	3	Quantity of goods received
44	WEWRT	☐	WEWRT	WERT7	CURR	13	2	Value of goods received in local currency
45	REMNG	☐	REMNG	MENG13	QUAN	13	3	Quantity invoiced
46	REWRT	☐	REWRT	WRTV7	CURR	13	2	Invoice value in local currency
47	EINDT	☐	EEIND	CHAR10	CHAR	10	0	Delivery Date
48	LPEIN	☐	LPEIN	PRGBZ	CHAR	1	0	Category of delivery date	*
49	EINDT_ET	☐	EINDT	DATUM	DATS	8	0	Item delivery date
50	LPEIN_ET	☐	LPEIN	PRGBZ	CHAR	1	0	Category of delivery date	*
51	SLFDT_ET	☐	SLFDT	DATUM	DATS	8	0	Statistics-Relevant Delivery Date
52	RSNUM_ET	☐	RSNUM	RSNUM	NUMC	10	0	Number of reservation/dependent requirements	*
53	MENGE_ET	☐	ETMEN	MENGE	QUAN	13	3	Scheduled Quantity
54	INDEX_NODE	☐	TABIX_D	TABIX	INT4	10	0	Field defined as in SY-TABIX
55	AUFNR	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	*
56	APLFL	☐	APLFL	PLNFOLGE	CHAR	6	0	Sequence number
57	VORNR	☐	VORNR	VORNR	CHAR	4	0	Operation/Activity Number
58	PHFLG	☐	PHFLG	XFELD	CHAR	1	0	Indicator: Phase
59	UVORN	☐	UVORN	VORNR	CHAR	4	0	Suboperation
60	WEWRT_HW	☐	WEWRT	WERT7	CURR	13	2	Value of goods received in local currency
61	REWRT_HW	☐	REWRT	WRTV7	CURR	13	2	Invoice value in local currency
62	WAERS_HW	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
63	.INCLUDE	☐				0	0

History

Last changed by/on	SAP	20110901
SAP Release Created in