SAP ABAP Table BAPIOAITEM (Item Data Outline Agreement)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ MM-PUR (Application Component) Purchasing
     ⤷ MECR (Package) Plug-In Enhancements in Purchasing for CRM

Basic Data

Table Category	INTTAB	Structure
Structure	BAPIOAITEM	Table Relationship Diagram
Short Description	Item Data Outline Agreement

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	AGRMT_ITEM	☐	EVRTP	EBELP	NUMC	5	0	Agreement Item	*
2	DELETE_IND	☐	ELOEK	ELOEK	CHAR	1	0	Deletion indicator in purchasing document
3	SHORT_TEXT	☐	TXZ01	TEXT40	CHAR	40	0	Short Text
4	MATERIAL	☐	MATNR	MATNR	CHAR	18	0	Material Number	*
5	EMATERIAL	☐	EMATNR	MATNR	CHAR	18	0	Material number	*
6	PLANT	☐	EWERK	WERKS	CHAR	4	0	Plant	*
7	STGE_LOC	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	*
8	TRACKINGNO	☐	BEDNR	CHAR10	CHAR	10	0	Requirement Tracking Number
9	MATL_GROUP	☐	MATKL	MATKL	CHAR	9	0	Material Group	*
10	INFO_REC	☐	INFNR	INFNR	CHAR	10	0	Number of purchasing info record	*
11	VEND_MAT	☐	IDNLF	IDNEX	CHAR	35	0	Material Number Used by Vendor
12	TARGET_QTY	☐	KTMNG	MENGE	QUAN	13	3	Target Quantity
13	PO_UNIT	☐	BSTME	MEINS	UNIT	3	0	Order unit	*
14	PO_UNITISO	☐	BSTME_ISO	ISOCD_UNIT	CHAR	3	0	Order unit in ISO code	*
15	ORDERPR_UN	☐	BBPRM	MEINS	UNIT	3	0	Order Price Unit (purchasing)	*
16	ORD_UN_ISO	☐	BBPRM_ISO	ISOCD_UNIT	CHAR	3	0	ISO Code for Purchase Order Price Unit	*
17	CONV_NUM1	☐	BPUMZ	UMBSZ	DEC	5	0	Numerator for Conversion of Order Price Unit into Order Unit
18	CONV_DEN1	☐	BPUMN	UMBSN	DEC	5	0	Denominator for Conv. of Order Price Unit into Order Unit
19	NET_PRICE	☐	BAPICUREXT	BAPICUREXT	DEC	28	9	Currency amount for BAPIS (with 9 decimal places)
20	PRICE_UNIT	☐	EPEIN	DEC5	DEC	5	0	Price unit
21	GR_PR_TIME	☐	WEBAZ	DEC3	DEC	3	0	Goods receipt processing time in days
22	TAX_CODE	☐	MWSKZ	MWSKZ	CHAR	2	0	Tax on sales/purchases code	*
23	BON_GRP1	☐	EBONU	EBONU	CHAR	2	0	Settlement Group 1 (Purchasing)
24	QUAL_INSP	☐	INSMK	INSMK	CHAR	1	0	Stock Type
25	INFO_UPD	☐	SPINF	SPINF	CHAR	1	0	Indicator: Update Info Record
26	PRNT_PRICE	☐	PRSDR	XFELD	CHAR	1	0	Price Printout
27	EST_PRICE	☐	SCHPR	XFELD	CHAR	1	0	Indicator: Estimated Price
28	REMINDER1	☐	MAHN1	MAHNT	DEC	3	0	Number of Days for First Reminder/Expediter
29	REMINDER2	☐	MAHN2	MAHNT	DEC	3	0	Number of Days for Second Reminder/Expediter
30	REMINDER3	☐	MAHN3	MAHNT	DEC	3	0	Number of Days for Third Reminder/Expediter
31	OVERDLVTOL	☐	UEBTO	PRZ21	DEC	3	1	Overdelivery Tolerance Limit
32	UNLIM_DLV	☐	UEBTK	XFELD	CHAR	1	0	Indicator: Unlimited Overdelivery Allowed
33	UND_DLVTOL	☐	UNTTO	PRZ21	DEC	3	1	Underdelivery Tolerance Limit
34	VAL_TYPE	☐	BWTAR_D	BWTAR	CHAR	10	0	Valuation type	*
35	ITEM_CAT	☐	PSTYP	PSTYP	CHAR	1	0	Item category in purchasing document	*
36	ACCTASSCAT	☐	KNTTP	KNTTP	CHAR	1	0	Account assignment category	*
37	DISTRIB	☐	VRTKZ	VRTKZ	CHAR	1	0	Distribution indicator for multiple account assignment
38	PART_INV	☐	TWRKZ	TWRKZ	CHAR	1	0	Partial invoice indicator
39	GR_IND	☐	WEPOS	XFELD	CHAR	1	0	Goods Receipt Indicator
40	GR_NON_VAL	☐	WEUNB	XFELD	CHAR	1	0	Goods Receipt, Non-Valuated
41	IR_IND	☐	REPOS	XFELD	CHAR	1	0	Invoice receipt indicator
42	GR_BASEDIV	☐	WEBRE	XFELD	CHAR	1	0	Indicator: GR-Based Invoice Verification
43	ACKN_REQD	☐	KZABS	XFELD	CHAR	1	0	Order Acknowledgment Requirement
44	ACKNOWL_NO	☐	LABNR	TEXT20	CHAR	20	0	Order Acknowledgment Number
45	AGREEMENT	☐	KONNR	EBELN	CHAR	10	0	Number of principal purchase agreement	*
46	AGMT_ITEM	☐	KTPNR	EBELP	NUMC	5	0	Item number of principal purchase agreement	*
47	SHIPPING	☐	EVERS	EVERS	CHAR	2	0	Shipping Instructions	*
48	CUSTOMER	☐	EKUNNR	KUNNR	CHAR	10	0	Customer	*
49	COND_GROUP	☐	EKKOG	CHAR4	CHAR	4	0	Condition Group with Vendor
50	NO_DISCT	☐	ESKTOF	XFELD	CHAR	1	0	Item Does Not Qualify for Cash Discount
51	PLAN_DEL	☐	EPLIF	DEC3	DEC	3	0	Planned Delivery Time in Days
52	NET_WEIGHT	☐	ENTGE	MENG13	QUAN	13	3	Net Weight
53	WEIGHTUNIT	☐	EGEWE	MEINS	UNIT	3	0	Unit of Weight	*
54	WEIGHTUN_I	☐	EGEWE_ISO	ISOCD_UNIT	CHAR	3	0	ISO Code for Unit of Weight	*
55	TAXJURCODE	☐	TXJCD	TXJCD	CHAR	15	0	Tax Jurisdiction	*
56	CTRL_KEY	☐	QSSPUR	QSSPUR	CHAR	8	0	Control Key for Quality Management in Procurement	*
57	CONF_CTRL	☐	BSTAE	BSTAE	CHAR	4	0	Confirmation Control Key	*
58	REV_LEV	☐	REVLV	REVLV	CHAR	2	0	Revision level
59	FUND	☐	BP_GEBER	BP_GEBER	CHAR	10	0	Fund	*
60	FUNDS_CTR	☐	FISTL	FISTL	CHAR	16	0	Funds Center	*
61	CMMT_ITEM	☐	FIPOS	FIPOS	CHAR	14	0	Commitment Item	FMFPO
62	PRICEDATE	☐	MEPRF	MEPRF	CHAR	1	0	Price Determination (Pricing) Date Control
63	PRICE_DATE	☐	PREDT	DATUM	DATS	8	0	Date of Price Determination
64	GROSS_WT	☐	BRGEW	MENG13	QUAN	13	3	Gross weight
65	VOLUME	☐	VOLUM	MENG13	QUAN	13	3	Volume
66	VOLUMEUNIT	☐	VOLEH	MEINS	UNIT	3	0	Volume unit	T006
67	VOLUMEUN_I	☐	VOLEH_ISO	ISOCD_UNIT	CHAR	3	0	Volume unit in ISO code	*
68	INCOTERMS1	☐	INCO1	INCO1	CHAR	3	0	Incoterms (part 1)	TINC
69	INCOTERMS2	☐	INCO2	INCO2	CHAR	28	0	Incoterms (part 2)
70	PRE_VENDOR	☐	KOLIF	LIFNR	CHAR	10	0	Prior Vendor	LFA1
71	VEND_PART	☐	LTSNR	LTSNR	CHAR	6	0	Vendor Subrange	WYT1
72	HL_ITEM	☐	UEBPO	EBELP	NUMC	5	0	Higher-Level Item in Purchasing Documents	EKPO
73	GR_TO_DATE	☐	LEWED	DATUM	DATS	8	0	Latest Possible Goods Receipt
74	SUPPVENDOR	☐	EMLIF	LIFNR	CHAR	10	0	Vendor to be supplied/who is to receive delivery	*
75	SC_VENDOR	☐	LBLKZ	XFELD	CHAR	1	0	Subcontracting vendor
76	KANBAN_IND	☐	KBNKZ	KBNKZ	CHAR	1	0	Kanban Indicator
77	ERS	☐	XERSY	XFELD	CHAR	1	0	Evaluated Receipt Settlement (ERS)
78	R_PROMO	☐	WAKTION	WAKTION	CHAR	10	0	Promotion	WAKH
79	POINTS	☐	ANZPU	MENG13	QUAN	13	3	Number of Points
80	POINT_UNIT	☐	PUNEI	MEINS	UNIT	3	0	Points unit	*
81	POINT_UN_I	☐	PUNEI_ISO	ISOCD_UNIT	CHAR	3	0	ISO Code for Points Unit	*
82	SEASON	☐	SAISO	SAISO	CHAR	4	0	Season Category	*
83	SEASON_YR	☐	SAISJ	CJAHR	CHAR	4	0	Season Year
84	BON_GRP2	☐	EBON2	EBONU	CHAR	2	0	Settlement Group 2 (Rebate Settlement, Purchasing)
85	BON_GRP3	☐	EBON3	EBONU	CHAR	2	0	Settlement Group 3 (Rebate Settlement, Purchasing)
86	SETT_ITEM	☐	EBONY	XFELD	CHAR	1	0	Item Relevant to Subsequent (Period-End Rebate) Settlement
87	MINREMLIFE	☐	MHDRZ	DEC4	DEC	4	0	Minimum Remaining Shelf Life
88	RFQ_NO	☐	ANFNR	EBELN	CHAR	10	0	RFQ Number	*
89	RFQ_ITEM	☐	ANFPS	EBELP	NUMC	5	0	Item Number of RFQ	*
90	PREQ_NO	☐	BANFN	BANFN	CHAR	10	0	Purchase requisition number
91	PREQ_ITEM	☐	BNFPO	BNFPO	NUMC	5	0	Item number of purchase requisition	*
92	REF_DOC	☐	REFBS	EBELN	CHAR	10	0	Reference Document Number	*
93	REF_ITEM	☐	REFPS	EBELP	NUMC	5	0	Item of reference document	*
94	SI_CAT	☐	UPTYP	UPTYP	CHAR	1	0	Subitem Category, Purchasing Document	*
95	RET_ITEM	☐	RETPO	XFELD	CHAR	1	0	Returns Item
96	AT_RELEV	☐	AUREL	AUREL	CHAR	1	0	Relevant to Allocation Table
97	ORDER_REAS	☐	BSGRU	BSGRU	CHAR	3	0	Reason for Ordering
98	BUDGET_PERIOD	☐	FM_BUDGET_PERIOD	FM_BUDGET_PERIOD	CHAR	10	0	FM: Budget Period	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	BAPIOAITEM	CMMT_ITEM	FMFPO	FIPOS	REF	C	CN
2	BAPIOAITEM	HL_ITEM	EKPO	EBELP
3	BAPIOAITEM	INCOTERMS1	TINC	INCO1	REF	1	N
4	BAPIOAITEM	PRE_VENDOR	LFA1	LIFNR	REF	1	CN
5	BAPIOAITEM	R_PROMO	WAKH	AKTNR	KEY	1	N
6	BAPIOAITEM	VEND_PART	WYT1	LTSNR	KEY	1	N
7	BAPIOAITEM	VOLUMEUNIT	T006	MSEHI	REF	1	N

History

Last changed by/on	SAP	20130529
SAP Release Created in	50A