SAP ABAP Table /ISDFPS/EBAN_MAT_PRPL_S (Prioritized Matls Plng: PReq, Material, and Customizing Data)

Hierarchy

☛ EA-DFPS (Software Component) SAP Enterprise Extension Defense Forces & Public Security
   ⤷ IS-DFS-MM (Application Component) Materials Management
     ⤷ /ISDFPS/MM (Package) SDP BW Enhancements in Materials Management

Basic Data

Table Category	INTTAB	Structure
Structure	/ISDFPS/EBAN_MAT_PRPL_S	Table Relationship Diagram
Short Description	Prioritized Matls Plng: PReq, Material, and Customizing 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	Purchase Requisition
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
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	T161
6	BSTYP	☐	BSTYP	BSTYP	CHAR	1	0	Purchasing document category
7	BSAKZ	☐	BSAKZ	BSAKZ	CHAR	1	0	Control indicator for purchasing document type
8	LOEKZ	☐	ELOEK	ELOEK	CHAR	1	0	Deletion indicator in purchasing document
9	STATU	☐	BANST	BANST	CHAR	1	0	Processing status of purchase requisition
10	ESTKZ	☐	ESTKZ	ESTKZ	CHAR	1	0	Creation indicator (purchase requisition/schedule lines)
11	FRGKZ	☐	FRGKZ	FRGKZ	CHAR	1	0	Release Indicator	T161S
12	FRGZU	☐	FRGZU	FRGZU	CHAR	8	0	Release status
13	FRGST	☐	FRGST	FRGST	CHAR	2	0	Release strategy in the purchase requisition
14	EKGRP	☐	EKGRP	EKGRP	CHAR	3	0	Purchasing group	T024
15	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
16	ERDAT	☐	AEDAT	DATUM	DATS	8	0	Last Changed On
17	AFNAM	☐	AFNAM	AFNAM	CHAR	12	0	Name of requisitioner/requester
18	TXZ01	☐	TXZ01	TEXT40	CHAR	40	0	Short Text
19	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	MARA
20	EMATN	☐	EMATN	MATNR	CHAR	18	0	Material number corresponding to manufacturer part number	MARA
21	WERKS	☐	EWERK	WERKS	CHAR	4	0	Plant	T001W
22	LGORT	☐	LGORT_D	LGORT	CHAR	4	0	Storage location	T001L
23	BEDNR	☐	BEDNR	CHAR10	CHAR	10	0	Requirement Tracking Number
24	MATKL	☐	MATKL	MATKL	CHAR	9	0	Material Group	T023
25	RESWK	☐	RESWK	WERKS	CHAR	4	0	Supplying (issuing) plant in case of stock transport order	*
26	MENGE	☐	BAMNG	MENG13	QUAN	13	3	Purchase requisition quantity
27	MEINS	☐	BAMEI	MEINS	UNIT	3	0	Purchase requisition unit of measure	T006
28	BUMNG	☐	BUMNG	MENG13	QUAN	13	3	Shortage (stock undercoverage) quantity
29	BADAT	☐	BADAT	DATUM	DATS	8	0	Requisition (request) date
30	LPEIN	☐	LPEIN	PRGBZ	CHAR	1	0	Category of delivery date	TPRG
31	LFDAT	☐	EINDT	DATUM	DATS	8	0	Item delivery date
32	FRGDT	☐	FRGDT	DATUM	DATS	8	0	Purchase Requisition Release Date
33	WEBAZ	☐	WEBAZ	DEC3	DEC	3	0	Goods receipt processing time in days
34	PREIS	☐	BAPRE	WERT11	CURR	11	2	Price in Purchase Requisition
35	PEINH	☐	EPEIN	DEC5	DEC	5	0	Price unit
36	PSTYP	☐	PSTYP	PSTYP	CHAR	1	0	Item category in purchasing document	T163
37	KNTTP	☐	KNTTP	KNTTP	CHAR	1	0	Account assignment category	T163K
38	KZVBR	☐	KZVBR	KZVBR	CHAR	1	0	Consumption posting
39	KFLAG	☐	KFLAG	XFELD	CHAR	1	0	Acct.asst.changeable
40	VRTKZ	☐	VRTKZ	VRTKZ	CHAR	1	0	Distribution indicator for multiple account assignment
41	TWRKZ	☐	TWRKZ	TWRKZ	CHAR	1	0	Partial invoice indicator
42	WEPOS	☐	WEPOS	XFELD	CHAR	1	0	Goods Receipt Indicator
43	WEUNB	☐	WEUNB	XFELD	CHAR	1	0	Goods Receipt, Non-Valuated
44	REPOS	☐	REPOS	XFELD	CHAR	1	0	Invoice receipt indicator
45	LIFNR	☐	WLIEF	LIFNR	CHAR	10	0	Desired vendor	LFA1
46	FLIEF	☐	FLIEF	LIFNR	CHAR	10	0	Fixed vendor	LFA1
47	EKORG	☐	EKORG	EKORG	CHAR	4	0	Purchasing organization	T024E
48	VRTYP	☐	BSTYP	BSTYP	CHAR	1	0	Purchasing document category
49	KONNR	☐	KONNR	EBELN	CHAR	10	0	Number of principal purchase agreement	EKKO
50	KTPNR	☐	KTPNR	EBELP	NUMC	5	0	Item number of principal purchase agreement	EKPO
51	INFNR	☐	INFNR	INFNR	CHAR	10	0	Number of purchasing info record	EINA
52	ZUGBA	☐	DZUGBA	XFELD	CHAR	1	0	Assigned Source of Supply
53	QUNUM	☐	QUNUM	QUNUM	CHAR	10	0	Number of quota arrangement
54	QUPOS	☐	QUPOS	NUM03	NUMC	3	0	Quota arrangement item
55	DISPO	☐	DISPO	DISPO	CHAR	3	0	MRP controller	T024D
56	SERNR	☐	SERNR	SERNR	CHAR	8	0	BOM explosion number	*
57	BVDAT	☐	BVDAT	DATUM	DATS	8	0	Date of last resubmission
58	BATOL	☐	BATOL	BATOL	DEC	3	0	Resubmission interval of purchase requisition
59	BVDRK	☐	BVDRK	ZAEHL	DEC	7	0	Number of resubmissions
60	EBELN	☐	BSTNR	EBELN	CHAR	10	0	Purchase order number	EKKO
61	EBELP	☐	BSTPO	EBELP	NUMC	5	0	Purchase order item number	EKPO
62	BEDAT	☐	BEDAT	DATUM	DATS	8	0	Purchase Order Date
63	BSMNG	☐	BSMNG	MENG13	QUAN	13	3	Quantity ordered against this purchase requisition
64	LBLNI	☐	LBLNI	LBLNI	CHAR	10	0	Entry Sheet Number	ESSR
65	BWTAR	☐	BWTAR_D	BWTAR	CHAR	10	0	Valuation type	T149D
66	XOBLR	☐	XOBLR	XFELD	CHAR	1	0	Item affects commitments
67	EBAKZ	☐	EBAKZ	XFELD	CHAR	1	0	Purchase requisition closed
68	RSNUM	☐	RSNUM	RSNUM	NUMC	10	0	Number of reservation/dependent requirements	*
69	SOBKZ	☐	SOBKZ	SOBKZ	CHAR	1	0	Special Stock Indicator	T148
70	ARSNR	☐	ARSNR	MDNUM	NUMC	10	0	Settlement reservation number
71	ARSPS	☐	ARSPS	RSPOS	NUMC	4	0	Item number of the settlement reservation
72	FIXKZ	☐	BAFIX	XFELD	CHAR	1	0	Purchase requisition is fixed
73	BMEIN	☐	BSTME	MEINS	UNIT	3	0	Order unit	T006
74	REVLV	☐	REVLV	REVLV	CHAR	2	0	Revision level
75	VORAB	☐	VORAB	XFELD	CHAR	1	0	Advance procurement: project stock
76	PACKNO	☐	PACKNO	PACKNO	NUMC	10	0	Package number	ESLH
77	KANBA	☐	KBNKZ	KBNKZ	CHAR	1	0	Kanban Indicator
78	BPUEB	☐	BPUEB	BPUEB	CHAR	1	0	Adopt requisition price in purchase order
79	CUOBJ	☐	CUOBJ	CUOBJ	NUMC	18	0	Configuration (internal object number)
80	FRGGR	☐	FRGGR	FRGGR	CHAR	2	0	Release group	T16FG
81	FRGRL	☐	FRGRL	XFELD	CHAR	1	0	Release Not Yet Completely Effected
82	AKTNR	☐	WAKTION	WAKTION	CHAR	10	0	Promotion	WAKH
83	CHARG	☐	CHARG_D	CHARG	CHAR	10	0	Batch Number	*
84	UMSOK	☐	UMSOK	SOBKZ	CHAR	1	0	Special stock indicator for physical stock transfer	*
85	VERID	☐	VERID	VERID	CHAR	4	0	Production Version	*
86	FIPOS	☐	FIPOS	FIPOS	CHAR	14	0	Commitment Item	*
87	FISTL	☐	FISTL	FISTL	CHAR	16	0	Funds Center	*
88	GEBER	☐	BP_GEBER	BP_GEBER	CHAR	10	0	Fund	*
89	KZKFG	☐	KZCUH	KZCUH	CHAR	1	0	Origin of Configuration
90	SATNR	☐	SATNR	MATNR	CHAR	18	0	Cross-Plant Configurable Material	*
91	MNG02	☐	MNG06	MENGV13	QUAN	13	3	Committed quantity
92	DAT01	☐	DAT05	DATUM	DATS	8	0	Committed date
93	ATTYP	☐	ATTYP	ATTYP	CHAR	2	0	Material Category
94	ADRNR	☐	ADRNR_MM	AD_ADDRNUM	CHAR	10	0	Manual address number in purchasing document item	ADRC
95	ADRN2	☐	ADRN2	AD_ADDRNUM	CHAR	10	0	Number of delivery address	ADRC
96	KUNNR	☐	EKUNNR	KUNNR	CHAR	10	0	Customer	KNA1
97	EMLIF	☐	EMLIF	LIFNR	CHAR	10	0	Vendor to be supplied/who is to receive delivery	LFA1
98	LBLKZ	☐	LBLKZ	XFELD	CHAR	1	0	Subcontracting vendor
99	KZBWS	☐	KZBWS	KZBWS	CHAR	1	0	Valuation of Special Stock
100	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
101	IDNLF	☐	IDNLF	IDNEX	CHAR	35	0	Material Number Used by Vendor
102	GSFRG	☐	GSFRG	XFELD	CHAR	1	0	Overall release of purchase requisitions
103	MPROF	☐	MPROF	MPROF	CHAR	4	0	Mfr part profile	*
104	KZFME	☐	KZWSO	KZWSO	CHAR	1	0	Units of measure usage
105	SPRAS	☐	SPRAS	SPRAS	LANG	1	0	Language Key	T002
106	TECHS	☐	TECHS	TECHS	CHAR	12	0	Parameter Variant/Standard Variant
107	MFRPN	☐	MFRPN	CHAR40	CHAR	40	0	Manufacturer Part Number
108	MFRNR	☐	MFRNR	LIFNR	CHAR	10	0	Manufacturer number	LFA1
109	EMNFR	☐	EMNFR	CHAR10	CHAR	10	0	External manufacturer code name or number
110	FORDN	☐	SFORDN	EBELN	CHAR	10	0	Framework Order	*
111	FORDP	☐	FORDP	EBELP	NUMC	5	0	Item of framework order	*
112	PLIFZ	☐	PLIFZ	DEC3	DEC	3	0	Planned delivery time in days
113	BERID	☐	BERID	BERID	CHAR	10	0	MRP Area	*
114	UZEIT	☐	LZEIT	UZEIT	TIMS	6	0	Delivery Date Time-Spot
115	FKBER	☐	FKBER	FKBER	CHAR	16	0	Functional Area	*
116	GRANT_NBR	☐	GM_GRANT_NBR	GM_GRANT_NBR	CHAR	20	0	Grant
117	MEMORY	☐	MEMBF	XFELD	CHAR	1	0	Purchase Requisition not yet Complete
118	BANPR	☐	BANPR	BANPR	CHAR	2	0	Requisition Processing State
119	RLWRT	☐	RLWRT	WERT15	CURR	15	2	Total value at time of release
120	BLCKD	☐	BLCKD	BLCKD	CHAR	1	0	Purchase Requisition Blocked
121	REVNO	☐	REVNO	REVNO	CHAR	8	0	Version number in Purchasing
122	BLCKT	☐	BLCKT	CHAR60K	CHAR	60	0	Reason for Item Block
123	BESWK	☐	BESWK	WERKS	CHAR	4	0	Procuring Plant	T001W
124	EPROFILE	☐	MEPROFILE	EPROFILE	CHAR	2	0	External Procurement Profile
125	EPREFDOC	☐	EPREFDOC	EPREFDOC	CHAR	10	0	External Procurement Reference Document
126	EPREFITM	☐	EPREFITM	EPREFITM	NUMC	5	0	External Procurement Reference Item
127	GMMNG	☐	GMMNG	MENG13	QUAN	13	3	PO Quantity of Purchase Requisition in POs on Hold
128	WRTKZ	☐	WRTKZ	XFELD	CHAR	1	0	Value-Based Commitment Reduction for Service Purchase Reqs
129	RESLO	☐	RESLO	LGORT	CHAR	4	0	Issuing Storage Location for Stock Transport Order	*
130	KBLNR	☐	KBLNR	KBLNR	CHAR	10	0	Document Number for Earmarked Funds	*
131	KBLPOS	☐	KBLPOS	KBLPOS	NUMC	3	0	Earmarked Funds: Document Item	*
132	PRIO_URG	☐	PRIO_URG	PRIO_URG	NUMC	2	0	Requirement Urgency	PURG
133	PRIO_REQ	☐	PRIO_REQ	PRIO_REQ	NUMC	3	0	Requirement Priority	PREQ
134	MEMORYTYPE	☐	MEMORYTYPE	MM_MEMORYTYPE	CHAR	1	0	Category of Incompleteness
135	ANZSN	☐	ANZSN	INT4	INT4	10	0	Number of serial numbers
136	MHDRZ	☐	MHDRZ	DEC4	DEC	4	0	Minimum Remaining Shelf Life
137	IPRKZ	☐	DATTP	DATTP	CHAR	1	0	Period Indicator for Shelf Life Expiration Date
138	NODISP	☐	NODISP	XFELD	CHAR	1	0	Ind: Reserv. not applicable to MRP;Purc. req. not created
139	SRM_CONTRACT_ID	☐	SRM_CONTRACT_ID	BBP_BAPI_EBELN	CHAR	10	0	Central Contract
140	SRM_CONTRACT_ITM	☐	SRM_CONTRACT_ITEM	BBP_ITEMNO	NUMC	10	0	Central Contract Item Number
141	BUDGET_PD	☐	FM_BUDGET_PERIOD	FM_BUDGET_PERIOD	CHAR	10	0	FM: Budget Period	*
142	.INCLUDE	☐				0	0
143	.INCLU--AP	☐				0	0	Append to EBAN for DFPS
144	ADVCODE	☐	/ISDFPS/ADVCODE	/ISDFPS/ADVCODE	CHAR	2	0	Advice Code	/ISDFPS/ADVCODE2
145	STACODE	☐	/ISDFPS/STACODE	/ISDFPS/STACODE	CHAR	2	0	Status Code	/ISDFPS/CSTACODE
146	.INCLU--AP	☐				0	0	DFPS: EBAN Enhancement (Cross System)
147	.INCLUDE	☐				0	0	DFPS: EBAN Enhancement (Cross System), Append Structure
148	BANFN_CS	☐	/ISDFPS/BANFN_CS	BANFN	CHAR	10	0	Cross-System PReq Number
149	BNFPO_CS	☐	/ISDFPS/BNFPO_CS	BNFPO	NUMC	5	0	Cross-System PReq Item	*
150	ITEM_CS	☐	/ISDFPS/ITEM_CS	/ISDFPS/ITEM_CS	CHAR	1	0	Cross-System Item Category
151	BSMNG_SND	☐	/ISDFPS/BSMNG_SND	MENG13	QUAN	13	3	PO Quantity Sender
152	.INCLU--AP	☐				0	0	IUID Append
153	IUID_RELEVANT	☐	IUID_RELEVANT	UID_RELEVANT	CHAR	1	0	IUID-Relevant
154	.INCLUDE	☐				0	0	Prioritized Materials Planning: Material Data
155	LOGLEV	☐	/ISDFPS/LOGLEV	/ISDFPS/LOGLEV	CHAR	1	0	Logistics Level	/ISDFPS/CLOGLEV
156	EXTWG	☐	EXTWG	EXTWG	CHAR	18	0	External material group	TWEW
157	IMATN	☐	/ISDFPS/IMATN	MATNR	CHAR	18	0	FFF Class	*
158	.INCLUDE	☐				0	0	Prioritized Materials Planning: Customizing Data
159	PRPL_AUT	☐	/ISDFPS/PRPL_AUT	/ISDFPS/PRPL_AUT	CHAR	1	0	Workflow for Prioritized Matls Plng
160	PRPL_MES	☐	/ISDFPS/PRPL_MES	/ISDFPS/PRPL_MES	CHAR	1	0	Notification Type
161	PRPL_PART	☐	/ISDFPS/PRPL_PART	XFELD	CHAR	1	0	Make Partial Order
162	PRPL_DLIV	☐	/ISDFPS/PRPL_DLIV	XFELD	CHAR	1	0	Create Delivery Automatically
163	PRPL_FOLW	☐	/ISDFPS/PRPL_FOLW	/ISDFPS/PRPL_FOLW	CHAR	1	0	Follow-Up Action in Event of Non-Availability
164	PRPL_FFFC	☐	/ISDFPS/PRPL_FFFC	XFELD	CHAR	1	0	Stop Follow-Up Action for FFFC Materials
165	NO_PRPL	☐	/ISDFPS/NO_PRPL	/ISDFPS/NO_PRPL	CHAR	1	0	Exclusion Criterion for Prioritized Materials Planning

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	/ISDFPS/EBAN_MAT_PRPL_S	ADRN2	ADRC	ADDRNUMBER
2	/ISDFPS/EBAN_MAT_PRPL_S	ADRNR	ADRC	ADDRNUMBER	KEY	1	CN
3	/ISDFPS/EBAN_MAT_PRPL_S	ADVCODE	/ISDFPS/ADVCODE2	ADVCODE
4	/ISDFPS/EBAN_MAT_PRPL_S	AKTNR	WAKH	AKTNR	KEY	1	N
5	/ISDFPS/EBAN_MAT_PRPL_S	BESWK	T001W	WERKS	REF	1	N
6	/ISDFPS/EBAN_MAT_PRPL_S	BMEIN	T006	MSEHI	REF	1	N
7	/ISDFPS/EBAN_MAT_PRPL_S	BSART	T161	BSART	REF	1	N
8	/ISDFPS/EBAN_MAT_PRPL_S	BWTAR	T149D	BWTAR	REF	1	N
9	/ISDFPS/EBAN_MAT_PRPL_S	DISPO	T024D	DISPO	REF	1	N
10	/ISDFPS/EBAN_MAT_PRPL_S	EBELN	EKKO	EBELN	REF	1	N
11	/ISDFPS/EBAN_MAT_PRPL_S	EBELP	EKPO	EBELP	REF	1	N
12	/ISDFPS/EBAN_MAT_PRPL_S	EKGRP	T024	EKGRP	REF	1	N
13	/ISDFPS/EBAN_MAT_PRPL_S	EKORG	T024E	EKORG	REF	1	N
14	/ISDFPS/EBAN_MAT_PRPL_S	EMATN	MARA	MATNR	REF	1	N
15	/ISDFPS/EBAN_MAT_PRPL_S	EMLIF	LFA1	LIFNR	REF	1	N
16	/ISDFPS/EBAN_MAT_PRPL_S	EXTWG	TWEW	EXTWG
17	/ISDFPS/EBAN_MAT_PRPL_S	FLIEF	LFA1	LIFNR	REF	1	N
18	/ISDFPS/EBAN_MAT_PRPL_S	FRGGR	T16FG	FRGGR	REF	1	CN
19	/ISDFPS/EBAN_MAT_PRPL_S	FRGKZ	T161S	FRGKZ	REF	1	CN
20	/ISDFPS/EBAN_MAT_PRPL_S	INFNR	EINA	INFNR	REF	1	N
21	/ISDFPS/EBAN_MAT_PRPL_S	KNTTP	T163K	KNTTP	REF	1	N
22	/ISDFPS/EBAN_MAT_PRPL_S	KONNR	EKKO	EBELN	REF	1	N
23	/ISDFPS/EBAN_MAT_PRPL_S	KTPNR	EKPO	EBELP	REF	1	N
24	/ISDFPS/EBAN_MAT_PRPL_S	KUNNR	KNA1	KUNNR	REF	1	N
25	/ISDFPS/EBAN_MAT_PRPL_S	LBLNI	ESSR	LBLNI	KEY	1	N
26	/ISDFPS/EBAN_MAT_PRPL_S	LGORT	T001L	LGORT	REF	1	N
27	/ISDFPS/EBAN_MAT_PRPL_S	LIFNR	LFA1	LIFNR	REF	1	N
28	/ISDFPS/EBAN_MAT_PRPL_S	LOGLEV	/ISDFPS/CLOGLEV	LOGLEV
29	/ISDFPS/EBAN_MAT_PRPL_S	LPEIN	TPRG	PRGBZ	REF	1	N
30	/ISDFPS/EBAN_MAT_PRPL_S	MANDT	T000	MANDT	KEY	1	N
31	/ISDFPS/EBAN_MAT_PRPL_S	MATKL	T023	MATKL	REF	1	N
32	/ISDFPS/EBAN_MAT_PRPL_S	MATNR	MARA	MATNR	REF	1	N
33	/ISDFPS/EBAN_MAT_PRPL_S	MEINS	T006	MSEHI	REF	1	N
34	/ISDFPS/EBAN_MAT_PRPL_S	MFRNR	LFA1	LIFNR
35	/ISDFPS/EBAN_MAT_PRPL_S	PACKNO	ESLH	PACKNO	KEY	1	N
36	/ISDFPS/EBAN_MAT_PRPL_S	PRIO_REQ	PREQ	PRIO_REQ	REF	1	CN
37	/ISDFPS/EBAN_MAT_PRPL_S	PRIO_URG	PURG	PRIO_URG	REF	1	CN
38	/ISDFPS/EBAN_MAT_PRPL_S	PSTYP	T163	PSTYP	REF	1	N
39	/ISDFPS/EBAN_MAT_PRPL_S	SOBKZ	T148	SOBKZ	REF	1	N
40	/ISDFPS/EBAN_MAT_PRPL_S	SPRAS	T002	SPRAS	REF	1	N
41	/ISDFPS/EBAN_MAT_PRPL_S	STACODE	/ISDFPS/CSTACODE	STACODE
42	/ISDFPS/EBAN_MAT_PRPL_S	WAERS	TCURC	WAERS
43	/ISDFPS/EBAN_MAT_PRPL_S	WERKS	T001W	WERKS	REF	1	N

History

Last changed by/on	SAP	20130529
SAP Release Created in	470