SAP ABAP Table MMPUR_SPPR_ITEM_STY (SPPR Item Data)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ MM-PUR (Application Component) Purchasing
     ⤷ MEREQ (Package) Purchasing: Purchase Requisition

Basic Data

Table Category	INTTAB	Structure
Structure	MMPUR_SPPR_ITEM_STY	Table Relationship Diagram
Short Description	SPPR Item Data

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	SPPR Document Item
2	DOC_NUMBER	☐	BANFN	BANFN	CHAR	10	0	Purchase requisition number
3	DOC_ITEM	☐	BNFPO	BNFPO	NUMC	5	0	Item number of purchase requisition	*
4	.INCLUDE	☐				0	0	OO Purchase Requisition: Item Status
5	BNFPO	☐	BNFPO	BNFPO	NUMC	5	0	Item number of purchase requisition	*
6	BSART	☐	BBSRT	BSART	CHAR	4	0	Purchase Requisition Document Type	*
7	BSTYP	☐	BSTYP	BSTYP	CHAR	1	0	Purchasing document category
8	BSAKZ	☐	BSAKZ	BSAKZ	CHAR	1	0	Control indicator for purchasing document type
9	LOEKZ	☐	ELOEK	ELOEK	CHAR	1	0	Deletion indicator in purchasing document
10	STATU	☐	BANST	BANST	CHAR	1	0	Processing status of purchase requisition
11	ESTKZ	☐	ESTKZ	ESTKZ	CHAR	1	0	Creation indicator (purchase requisition/schedule lines)
12	FRGKZ	☐	FRGKZ	FRGKZ	CHAR	1	0	Release Indicator	*
13	FRGZU	☐	FRGZU	FRGZU	CHAR	8	0	Release status
14	FRGST	☐	FRGST	FRGST	CHAR	2	0	Release strategy in the purchase requisition
15	EKGRP	☐	EKGRP	EKGRP	CHAR	3	0	Purchasing group	*
16	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
17	ERDAT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
18	AFNAM	☐	AFNAM	AFNAM	CHAR	12	0	Name of requisitioner/requester
19	TXZ01	☐	TXZ01	TEXT40	CHAR	40	0	Short Text
20	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	*
21	EMATN	☐	EMATN	MATNR	CHAR	18	0	Material number corresponding to manufacturer part number	*
22	WERKS	☐	EWERK	WERKS	CHAR	4	0	Plant	*
23	LGORT	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	*
24	BEDNR	☐	BEDNR	CHAR10	CHAR	10	0	Requirement Tracking Number
25	MATKL	☐	MATKL	MATKL	CHAR	9	0	Material Group	*
26	RESWK	☐	RESWK	WERKS	CHAR	4	0	Supplying (issuing) plant in case of stock transport order	*
27	MENGE	☐	BAMNG	MENG13	QUAN	13	3	Purchase requisition quantity
28	MEINS	☐	BAMEI	MEINS	UNIT	3	0	Purchase requisition unit of measure	*
29	BUMNG	☐	BUMNG	MENG13	QUAN	13	3	Shortage (stock undercoverage) quantity
30	BADAT	☐	BADAT	DATUM	DATS	8	0	Requisition (request) date
31	LPEIN	☐	LPEIN	PRGBZ	CHAR	1	0	Category of delivery date	*
32	LFDAT	☐	EINDT	DATUM	DATS	8	0	Item delivery date
33	FRGDT	☐	FRGDT	DATUM	DATS	8	0	Purchase Requisition Release Date
34	WEBAZ	☐	WEBAZ	DEC3	DEC	3	0	Goods receipt processing time in days
35	PREIS	☐	BAPRE	WERT11	CURR	11	2	Price in Purchase Requisition
36	PEINH	☐	EPEIN	DEC5	DEC	5	0	Price unit
37	PSTYP	☐	PSTYP	PSTYP	CHAR	1	0	Item category in purchasing document	*
38	KNTTP	☐	KNTTP	KNTTP	CHAR	1	0	Account assignment category	*
39	KZVBR	☐	KZVBR	KZVBR	CHAR	1	0	Consumption posting
40	KFLAG	☐	KFLAG	XFELD	CHAR	1	0	Acct.asst.changeable
41	VRTKZ	☐	VRTKZ	VRTKZ	CHAR	1	0	Distribution indicator for multiple account assignment
42	TWRKZ	☐	TWRKZ	TWRKZ	CHAR	1	0	Partial invoice indicator
43	WEPOS	☐	WEPOS	XFELD	CHAR	1	0	Goods Receipt Indicator
44	WEUNB	☐	WEUNB	XFELD	CHAR	1	0	Goods Receipt, Non-Valuated
45	REPOS	☐	REPOS	XFELD	CHAR	1	0	Invoice receipt indicator
46	LIFNR	☐	WLIEF	LIFNR	CHAR	10	0	Desired vendor	*
47	FLIEF	☐	FLIEF	LIFNR	CHAR	10	0	Fixed vendor	*
48	EKORG	☐	EKORG	EKORG	CHAR	4	0	Purchasing organization	*
49	VRTYP	☐	BSTYP	BSTYP	CHAR	1	0	Purchasing document category
50	KONNR	☐	KONNR	EBELN	CHAR	10	0	Number of principal purchase agreement	*
51	KTPNR	☐	KTPNR	EBELP	NUMC	5	0	Item number of principal purchase agreement	*
52	INFNR	☐	INFNR	INFNR	CHAR	10	0	Number of purchasing info record	*
53	ZUGBA	☐	DZUGBA	XFELD	CHAR	1	0	Assigned Source of Supply
54	QUNUM	☐	QUNUM	QUNUM	CHAR	10	0	Number of quota arrangement
55	QUPOS	☐	QUPOS	NUM03	NUMC	3	0	Quota arrangement item
56	DISPO	☐	DISPO	DISPO	CHAR	3	0	MRP controller	*
57	SERNR	☐	SERNR	SERNR	CHAR	8	0	BOM explosion number	*
58	BVDAT	☐	BVDAT	DATUM	DATS	8	0	Date of last resubmission
59	BATOL	☐	BATOL	BATOL	DEC	3	0	Resubmission interval of purchase requisition
60	BVDRK	☐	BVDRK	ZAEHL	DEC	7	0	Number of resubmissions
61	EBELN	☐	BSTNR	EBELN	CHAR	10	0	Purchase order number	*
62	EBELP	☐	BSTPO	EBELP	NUMC	5	0	Purchase order item number	*
63	BEDAT	☐	BEDAT	DATUM	DATS	8	0	Purchase Order Date
64	BSMNG	☐	BSMNG	MENG13	QUAN	13	3	Quantity ordered against this purchase requisition
65	LBLNI	☐	LBLNI	LBLNI	CHAR	10	0	Entry Sheet Number	*
66	BWTAR	☐	BWTAR_D	BWTAR	CHAR	10	0	Valuation type	*
67	XOBLR	☐	XOBLR	XFELD	CHAR	1	0	Item affects commitments
68	EBAKZ	☐	EBAKZ	XFELD	CHAR	1	0	Purchase requisition closed
69	RSNUM	☐	RSNUM	RSNUM	NUMC	10	0	Number of reservation/dependent requirements	*
70	SOBKZ	☐	SOBKZ	SOBKZ	CHAR	1	0	Special Stock Indicator	*
71	ARSNR	☐	ARSNR	MDNUM	NUMC	10	0	Settlement reservation number
72	ARSPS	☐	ARSPS	RSPOS	NUMC	4	0	Item number of the settlement reservation
73	FIXKZ	☐	BAFIX	XFELD	CHAR	1	0	Purchase requisition is fixed
74	BMEIN	☐	BSTME	MEINS	UNIT	3	0	Order unit	*
75	REVLV	☐	REVLV	REVLV	CHAR	2	0	Revision level
76	VORAB	☐	VORAB	XFELD	CHAR	1	0	Advance procurement: project stock
77	PACKNO	☐	PACKNO	PACKNO	NUMC	10	0	Package number	*
78	KANBA	☐	KBNKZ	KBNKZ	CHAR	1	0	Kanban Indicator
79	BPUEB	☐	BPUEB	BPUEB	CHAR	1	0	Adopt requisition price in purchase order
80	CUOBJ	☐	CUOBJ	CUOBJ	NUMC	18	0	Configuration (internal object number)
81	FRGGR	☐	FRGGR	FRGGR	CHAR	2	0	Release group	*
82	FRGRL	☐	FRGRL	XFELD	CHAR	1	0	Release Not Yet Completely Effected
83	AKTNR	☐	WAKTION	WAKTION	CHAR	10	0	Promotion	*
84	CHARG	☐	CHARG_D	CHARG	CHAR	10	0	Batch Number	*
85	UMSOK	☐	UMSOK	SOBKZ	CHAR	1	0	Special stock indicator for physical stock transfer	*
86	VERID	☐	VERID	VERID	CHAR	4	0	Production Version	*
87	FIPOS	☐	FIPOS	FIPOS	CHAR	14	0	Commitment Item	*
88	FISTL	☐	FISTL	FISTL	CHAR	16	0	Funds Center	*
89	GEBER	☐	BP_GEBER	BP_GEBER	CHAR	10	0	Fund	*
90	KZKFG	☐	KZCUH	KZCUH	CHAR	1	0	Origin of Configuration
91	SATNR	☐	SATNR	MATNR	CHAR	18	0	Cross-Plant Configurable Material	*
92	MNG02	☐	MNG06	MENGV13	QUAN	13	3	Committed quantity
93	DAT01	☐	DAT05	DATUM	DATS	8	0	Committed date
94	ATTYP	☐	ATTYP	ATTYP	CHAR	2	0	Material Category
95	ADRNR	☐	ADRNR_MM	AD_ADDRNUM	CHAR	10	0	Manual address number in purchasing document item	*
96	ADRN2	☐	ADRN2	AD_ADDRNUM	CHAR	10	0	Number of delivery address	*
97	KUNNR	☐	EKUNNR	KUNNR	CHAR	10	0	Customer	*
98	EMLIF	☐	EMLIF	LIFNR	CHAR	10	0	Vendor to be supplied/who is to receive delivery	*
99	LBLKZ	☐	LBLKZ	XFELD	CHAR	1	0	Subcontracting vendor
100	KZBWS	☐	KZBWS	KZBWS	CHAR	1	0	Valuation of Special Stock
101	GSWRT	☐	GSWRT	WERT7	CURR	13	2	Total Value of Item
102	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
103	IDNLF	☐	IDNLF	IDNEX	CHAR	35	0	Material Number Used by Vendor
104	GSFRG	☐	GSFRG	XFELD	CHAR	1	0	Overall release of purchase requisitions
105	MPROF	☐	MPROF	MPROF	CHAR	4	0	Mfr part profile	*
106	KZFME	☐	KZWSO	KZWSO	CHAR	1	0	Units of measure usage
107	SPRAS	☐	SPRAS	SPRAS	LANG	1	0	Language Key	*
108	TECHS	☐	TECHS	TECHS	CHAR	12	0	Parameter Variant/Standard Variant
109	MFRPN	☐	MFRPN	CHAR40	CHAR	40	0	Manufacturer Part Number
110	MFRNR	☐	MFRNR	LIFNR	CHAR	10	0	Manufacturer number	*
111	EMNFR	☐	EMNFR	CHAR10	CHAR	10	0	External manufacturer code name or number
112	FORDN	☐	SFORDN	EBELN	CHAR	10	0	Framework Order	*
113	FORDP	☐	FORDP	EBELP	NUMC	5	0	Item of framework order	*
114	PLIFZ	☐	PLIFZ	DEC3	DEC	3	0	Planned delivery time in days
115	BERID	☐	BERID	BERID	CHAR	10	0	MRP Area	*
116	UZEIT	☐	LZEIT	UZEIT	TIMS	6	0	Delivery Date Time-Spot
117	REF_BANFN	☐	REFBN	BANFN	CHAR	10	0	Number of Reference Purchase Requisition
118	REF_BNFPO	☐	RFBPS	BNFPO	NUMC	5	0	Item of Reference Purchase Requisition	*
119	GRANT_NBR	☐	GM_GRANT_NBR	GM_GRANT_NBR	CHAR	20	0	Grant
120	FKBER	☐	FKBER	FKBER	CHAR	16	0	Functional Area	*
121	MEMORY	☐	MEMBF	XFELD	CHAR	1	0	Purchase Requisition not yet Complete
122	BANPR	☐	BANPR	BANPR	CHAR	2	0	Requisition Processing State
123	RLWRT	☐	RLWRT	WERT15	CURR	15	2	Total value at time of release
124	BLCKD	☐	BLCKD	BLCKD	CHAR	1	0	Purchase Requisition Blocked
125	BLCKT	☐	BLCKT	CHAR60K	CHAR	60	0	Reason for Item Block
126	REVNO	☐	REVNO	REVNO	CHAR	8	0	Version number in Purchasing
127	BESWK	☐	BESWK	WERKS	CHAR	4	0	Procuring Plant	*
128	EPROFILE	☐	MEPROFILE	EPROFILE	CHAR	2	0	External Procurement Profile
129	EPREFDOC	☐	EPREFDOC	EPREFDOC	CHAR	10	0	External Procurement Reference Document
130	EPREFITM	☐	EPREFITM	EPREFITM	NUMC	5	0	External Procurement Reference Item
131	GMMNG	☐	GMMNG	MENG13	QUAN	13	3	PO Quantity of Purchase Requisition in POs on Hold
132	WRTKZ	☐	WRTKZ	XFELD	CHAR	1	0	Value-Based Commitment Reduction for Service Purchase Reqs
133	RESLO	☐	RESLO	LGORT	CHAR	4	0	Issuing Storage Location for Stock Transport Order	*
134	KBLNR	☐	KBLNR	KBLNR	CHAR	10	0	Document Number for Earmarked Funds	*
135	KBLPOS	☐	KBLPOS	KBLPOS	NUMC	3	0	Earmarked Funds: Document Item	*
136	PRIO_URG	☐	PRIO_URG	PRIO_URG	NUMC	2	0	Requirement Urgency	PURG
137	PRIO_REQ	☐	PRIO_REQ	PRIO_REQ	NUMC	3	0	Requirement Priority	PREQ
138	ANZSN	☐	ANZSN	INT4	INT4	10	0	Number of serial numbers
139	SERNP	☐	SERAIL	SERAIL	CHAR	4	0	Serial Number Profile	*
140	MHDRZ	☐	MHDRZ	DEC4	DEC	4	0	Minimum Remaining Shelf Life
141	IPRKZ	☐	DATTP	DATTP	CHAR	1	0	Period Indicator for Shelf Life Expiration Date
142	MEMORYTYPE	☐	MEMORYTYPE	MM_MEMORYTYPE	CHAR	1	0	Category of Incompleteness
143	EXT_PROC_STATUS	☐	MEREQ_PROC_STATUS	PROC_STAT	CHAR	1	0	Processing State
144	EXT_PROC_DATE	☐	MMPUR_UTC	TIMESTAMP	CHAR	14	0	Timestamp
145	PROC_STATUS	☐	MEREQ_PROC_TYPE	PROC_TYPE	CHAR	1	0	Processing State
146	PROC_DATE	☐	MMPUR_UTC	TIMESTAMP	CHAR	14	0	Timestamp
147	EXT_DOC_NUMBER	☐	ME_PUR_EXT_DOC_ID	ME_EXT_DOC_ID	CHAR	35	0	Document Number of External Document
148	EXT_DOC_ITEM	☐	ME_PUR_EXT_DOC_ITEM_ID	ME_EXT_DOC_ITEM_ID	CHAR	10	0	Item Number of External Document
149	EXT_DOC_TYPE	☐	ME_PUR_EXT_DOC_TYPE	ME_EXT_DOC_TYPE	CHAR	4	0	External Document Type
150	NODISP	☐	NODISP	XFELD	CHAR	1	0	Ind: Reserv. not applicable to MRP;Purc. req. not created
151	SRM_CONTRACT_ID	☐	SRM_CONTRACT_ID	BBP_BAPI_EBELN	CHAR	10	0	Central Contract
152	SRM_CONTRACT_ITM	☐	SRM_CONTRACT_ITEM	BBP_ITEMNO	NUMC	10	0	Central Contract Item Number
153	SC_OBJECT_ID	☐	/SRMERP/OBJECT_ID	/SRMERP/OBJECT_ID	CHAR	10	0	Object ID - Document Number
154	SC_ITM_NO	☐	/SRMERP/SC_ITM_NO	INT4	INT4	10	0	Internal Shopping Cart Item Number
155	.INCLUDE	☐				0	0	Structure with Persistent and Transient Customer Data
156	.INCLUDE	☐				0	0
157	.INCLUDE	☐				0	0
158	MEREQITEMDUMMY	☐	XFELD	XFELD	CHAR	1	0	Checkbox
159	.INCLUDE	☐				0	0	Erweiterungsfelder zur Bestellanforderung (kein Schlüssel)
160	DUMMY1	☐	XFELD1	XFELD	CHAR	1	0	Type of consolidation of investments method
161	.INCLUDE	☐				0	0	Material Extention Structure for Brazil Localization fields
162	J_1BMATUSE	☐	J_1BMATUSE	J_1BMATUSE	CHAR	1	0	Usage of the material
163	J_1BOWNPRO	☐	J_1BOWNPRO	XFELD	CHAR	1	0	Produced in-house
164	J_1BMATORG	☐	J_1BMATORG	J_1BMATORG	CHAR	1	0	Origin of the material
165	J_1BINDUST	☐	J_1BINDUS3	J_1BINDUS3	CHAR	2	0	Material CFOP category
166	J_1BNBM	☐	J_1BNBMCO1	STEUC	CHAR	16	0	Brazilian NCM Code	*
167	J_1AINDXP	☐	J_1AINDXP	J_1AINDXP	CHAR	5	0	Inflation Index	*
168	J_1AIDATEP	☐	J_1AIDATEP	J_1AUDATEP	DATS	8	0	Last day of the time period where the index value is valid
169	LAND1	☐	LAND1	LAND1	CHAR	3	0	Country Key	*
170	BUDGET_PD	☐	FM_BUDGET_PERIOD	FM_BUDGET_PERIOD	CHAR	10	0	FM: Budget Period	*
171	.INCLU--AP	☐				0	0	DFPS: Additional Fields for Purchase Requisition Items
172	.INCLUDE	☐				0	0	Additional DFPS Fields: Advice and Status Code
173	ADVCODE	☐	/ISDFPS/ADVCODE	/ISDFPS/ADVCODE	CHAR	2	0	Advice Code	/ISDFPS/ADVCODE2
174	STACODE	☐	/ISDFPS/STACODE	/ISDFPS/STACODE	CHAR	2	0	Status Code	/ISDFPS/CSTACODE
175	.INCLUDE	☐				0	0	DFPS: EBAN Enhancement (Cross System), Append Structure
176	BANFN_CS	☐	/ISDFPS/BANFN_CS	BANFN	CHAR	10	0	Cross-System PReq Number
177	BNFPO_CS	☐	/ISDFPS/BNFPO_CS	BNFPO	NUMC	5	0	Cross-System PReq Item	*
178	ITEM_CS	☐	/ISDFPS/ITEM_CS	/ISDFPS/ITEM_CS	CHAR	1	0	Cross-System Item Category
179	BSMNG_SND	☐	/ISDFPS/BSMNG_SND	MENG13	QUAN	13	3	PO Quantity Sender
180	.INCLU--AP	☐				0	0	Append IUID
181	IUID_RELEVANT	☐	IUID_RELEVANT	UID_RELEVANT	CHAR	1	0	IUID-Relevant
182	PLANT_NAME	☐	NAME1	TEXT30	CHAR	30	0	Name
183	MATKL_NAME	☐	WGBEZ	TEXT20	CHAR	20	0	Material Group Description
184	LGORT_NAME	☐	LGOBE	TEXT16	CHAR	16	0	Description of Storage Location
185	EKGRP_NAME	☐	EKNAM	TEXT18	CHAR	18	0	Description of purchasing group
186	EKORG_NAME	☐	EKOTX	TEXT20	CHAR	20	0	Description of purchasing organization
187	EXTPROCSTAT_NAME	☐	CHAR50	TEXT50	CHAR	50	0	Comment
188	ATTYP_NAME	☐	DDTEXT	DDTEXT	CHAR	60	0	Explanatory short text
189	ERNAM_NAME	☐	CHAR50	TEXT50	CHAR	50	0	Comment
190	KUNNR_NAME	☐	CHAR50	TEXT50	CHAR	50	0	Comment
191	ELPEI	☐	LPEIN	PRGBZ	CHAR	1	0	Category of delivery date	*
192	EEIND	☐	EEIND	CHAR10	CHAR	10	0	Delivery Date

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	MMPUR_SPPR_ITEM_STY	ADVCODE	/ISDFPS/ADVCODE2	ADVCODE
2	MMPUR_SPPR_ITEM_STY	PRIO_REQ	PREQ	PRIO_REQ	REF	1	CN
3	MMPUR_SPPR_ITEM_STY	PRIO_URG	PURG	PRIO_URG	REF	1	CN
4	MMPUR_SPPR_ITEM_STY	STACODE	/ISDFPS/CSTACODE	STACODE

History

Last changed by/on	SAP	20131127
SAP Release Created in	605