SE11 ABAP Dictionary SE11 EBAN

Popular:

VBAK VBAP MARA MAKT BKPF BSEG BVOR EKKO EKPO KNA1 LFA1 LIKP VBRK

EBAN

Purchase Requisition

SAP SAP Transparent Table 155 Fields

Primary Key:

MANDT BANFN BNFPO

#	Field Name	Key	Field Label	Type	Length	Dec	Check Table	Short Description
1	MANDT	KEY	Client	CLNT	3	-	T000	Client
2	BANFN	KEY	Purch.Req.	CHAR	10	-	-	Purchase Requisition Number
3	BNFPO	KEY	PReq. Item	NUMC	5	-	-	Item Number of Purchase Requisition
4	BSART	-	Doc. Type	CHAR	4	-	-	Purchase Requisition Document Type
5	BSTYP	-	Doc. Cat.	CHAR	1	-	-	Purchasing Document Category
6	BSAKZ	-	Ctrl. ind.	CHAR	1	-	-	Control indicator for purchasing document type
7	LOEKZ	-	Delet.Ind.	CHAR	1	-	-	Deletion Indicator in Purchasing Document
8	STATU	-	Proc.stat.	CHAR	1	-	-	Processing status of purchase requisition
9	ESTKZ	-	Crea. Ind.	CHAR	1	-	-	Creation Indicator (Purchase Requisition/Schedule Lines)
10	FRGKZ	-	Release	CHAR	1	-	-	Release Indicator
11	FRGZU	-	Rel.status	CHAR	8	-	-	Release status
12	FRGST	-	Rel.Strat.	CHAR	2	-	-	Release Strategy in Purchase Requisition
13	EKGRP	-	Purch. Grp	CHAR	3	-	-	Purchasing Group
14	ERNAM	-	Created	CHAR	12	-	-	Name of Person who Created the Object
15	ERDAT	-	Chngd	DATS	8	-	-	Changed On
16	AFNAM	-	Requisnr.	CHAR	12	-	-	Name of Requisitioner/Requester
17	TXZ01	-	Short Text	CHAR	40	-	-	Short Text
18	MATNR	-	Material	CHAR	18	-	MARA	Material Number
19	EMATN	-	MPN Mat.	CHAR	18	-	-	Material Number Corresponding to Manufacturer Part Number
20	WERKS	-	Plant	CHAR	4	-	T001W	Plant
21	LGORT	-	Stor. Loc.	CHAR	4	-	T001L	Storage Location
22	BEDNR	-	TrackingNo	CHAR	10	-	-	Requirement Tracking Number
23	MATKL	-	Matl Group	CHAR	9	-	-	Material Group
24	RESWK	-	Suppl.Plnt	CHAR	4	-	-	Supplying (Issuing) Plant in Stock Transport Order
25	MENGE	-	Quantity	QUAN	13	3	-	Purchase Requisition Quantity
26	MEINS	-	Unit	UNIT	3	-	-	Purchase Requisition Unit of Measure
27	BUMNG	-	Shortage	QUAN	13	3	-	Shortage (stock undercoverage) quantity
28	BADAT	-	Req. Date	DATS	8	-	-	Requisition (Request) Date
29	LPEIN	-	Deliv.Date	CHAR	1	-	-	Category of Delivery Date
30	LFDAT	-	Del. Date	DATS	8	-	-	Item Delivery Date
31	FRGDT	-	Release Dt	DATS	8	-	-	Purchase Requisition Release Date
32	WEBAZ	-	GR ProcTme	DEC	3	-	-	Goods Receipt Processing Time in Days
33	PREIS	-	Val. Price	CURR	11	2	-	Price in Purchase Requisition
34	PEINH	-	Per	DEC	5	-	-	Price Unit
35	PSTYP	-	Item Cat.	CHAR	1	-	-	Item Category in Purchasing Document
36	KNTTP	-	AcctAssCat	CHAR	1	-	-	Account Assignment Category
37	KZVBR	-	Consumpt.	CHAR	1	-	-	Consumption Posting
38	KFLAG	-	Changeable	CHAR	1	-	-	Acct.asst.changeable
39	VRTKZ	-	Distrib.	CHAR	1	-	-	Distribution Indicator for Multiple Account Assignment
40	TWRKZ	-	Part. Inv.	CHAR	1	-	-	Partial Invoice Indicator
41	WEPOS	-	GR	CHAR	1	-	-	Goods Receipt Indicator
42	WEUNB	-	GR Non-Val	CHAR	1	-	-	Goods Receipt, Non-Valuated
43	REPOS	-	IR	CHAR	1	-	-	Invoice Receipt Indicator
44	LIFNR	-	Des.Vendor	CHAR	10	-	LFA1	Desired Vendor
45	FLIEF	-	Fix. Vend.	CHAR	10	-	-	Fixed Vendor
46	EKORG	-	Purch.Org.	CHAR	4	-	-	Purchasing Organization
47	VRTYP	-	Doc. Cat.	CHAR	1	-	-	Purchasing Document Category
48	KONNR	-	Agreement	CHAR	10	-	-	Number of Principal Purchase Agreement
49	KTPNR	-	Agmt Item	NUMC	5	-	-	Item Number of Principal Purchase Agreement
50	INFNR	-	Info Rec.	CHAR	10	-	-	Number of Purchasing Info Record
51	ZUGBA	-	Assigned	CHAR	1	-	-	Assigned Source of Supply
52	QUNUM	-	Quota Arr.	CHAR	10	-	-	Number of Quota Arrangement
53	QUPOS	-	QuotArrItm	NUMC	3	-	-	Quota Arrangement Item
54	DISPO	-	MRP Cont.	CHAR	3	-	-	MRP Controller (Materials Planner)
55	SERNR	-	BOMexpl.no	CHAR	8	-	-	BOM explosion number
56	BVDAT	-	Last resub	DATS	8	-	-	Date of last resubmission
57	BATOL	-	Resubmiss.	DEC	3	-	-	Resubmission Interval of Purchase Requisition
58	BVDRK	-	No. resub.	DEC	7	-	-	Number of resubmissions
59	EBELN	-	PO	CHAR	10	-	EKKO	Purchase Order Number
60	EBELP	-	Item	NUMC	5	-	-	Purchase Order Item Number
61	BEDAT	-	PO Date	DATS	8	-	-	Purchase Order Date
62	BSMNG	-	Ordered	QUAN	13	3	-	Quantity Ordered Against this Purchase Requisition
63	LBLNI	-	Entry Sh.	CHAR	10	-	-	Entry Sheet Number
64	BWTAR	-	Val. Type	CHAR	10	-	-	Valuation Type
65	XOBLR	-	Commitment	CHAR	1	-	-	Item affects commitments
66	EBAKZ	-	Closed	CHAR	1	-	-	Purchase Requisition Closed
67	RSNUM	-	Reserv.No.	NUMC	10	-	-	Number of Reservation/Dependent Requirement
68	SOBKZ	-	Spec.Stock	CHAR	1	-	-	Special Stock Indicator
69	ARSNR	-	SetReserNo	NUMC	10	-	-	Settlement reservation number
70	ARSPS	-	SettlItmNo	NUMC	4	-	-	Item number of the settlement reservation
71	FIXKZ	-	Fixed	CHAR	1	-	-	Purchase Requisition is Fixed
72	BMEIN	-	Order Unit	UNIT	3	-	-	Purchase Order Unit of Measure
73	REVLV	-	Rev. Level	CHAR	2	-	-	Revision Level
74	VORAB	-	Advance	CHAR	1	-	-	Advance procurement: project stock
75	PACKNO	-	Number	NUMC	10	-	-	Package number
76	KANBA	-	KanbanInd.	CHAR	1	-	-	Kanban Indicator
77	BPUEB	-	PO Price	CHAR	1	-	-	Adopt Requisition Price in Purchase Order
78	CUOBJ	-	Int.obj.no	NUMC	18	-	-	Configuration (internal object number)
79	FRGGR	-	Rel. group	CHAR	2	-	-	Release group
80	FRGRL	-	Subj.to r.	CHAR	1	-	-	Release Not Yet Completely Effected
81	AKTNR	-	Promotion	CHAR	10	-	-	Promotion
82	CHARG	-	Batch	CHAR	10	-	-	Batch Number
83	UMSOK	-	Stock Tfr	CHAR	1	-	-	Special Stock Indicator for Physical Stock Transfer
84	VERID	-	Version	CHAR	4	-	-	Production Version
85	FIPOS	-	Cmmt Item	CHAR	14	-	-	Commitment Item
86	FISTL	-	Funds Ctr	CHAR	16	-	-	Funds Center
87	GEBER	-	Fund	CHAR	10	-	-	Fund
88	KZKFG	-	OrigConfig	CHAR	1	-	-	Origin of Configuration
89	SATNR	-	Conf. matl	CHAR	18	-	-	Cross-Plant Configurable Material
90	MNG02	-	Comm. Qty	QUAN	13	3	-	Committed Quantity
91	DAT01	-	Comm. Date	DATS	8	-	-	Committed Date
92	ATTYP	-	Matl Cat.	CHAR	2	-	-	Material Category
93	ADRNR	-	Address	CHAR	10	-	-	Manual address number in purchasing document item
94	ADRN2	-	Address	CHAR	10	-	-	Number of delivery address
95	KUNNR	-	Customer	CHAR	10	-	KNA1	Customer
96	EMLIF	-	Vendor	CHAR	10	-	-	Vendor to be supplied/who is to receive delivery
97	LBLKZ	-	SC vendor	CHAR	1	-	-	Subcontracting vendor
98	KZBWS	-	Valuation	CHAR	1	-	-	Valuation of Special Stock
99	WAERS	-	Currency	CUKY	5	-	TCURC	Currency Key
100	IDNLF	-	Vend. Mat.	CHAR	35	-	-	Material Number Used by Vendor
101	GSFRG	-	OverReqRel	CHAR	1	-	-	Overall release of purchase requisitions
102	MPROF	-	MPP	CHAR	4	-	-	Manufacturer Part Profile
103	KZFME	-	Usage UoM	CHAR	1	-	-	Units of measure usage
104	SPRAS	-	Language	LANG	1	-	T002	Language Key
105	TECHS	-	StdVariant	CHAR	12	-	-	Parameter Variant/Standard Variant
106	MFRPN	-	MPN	CHAR	40	-	-	Manufacturer Part Number
107	MFRNR	-	Manufact.	CHAR	10	-	-	Number of a Manufacturer
108	EMNFR	-	Ex. manuf.	CHAR	10	-	-	External manufacturer code name or number
109	FORDN	-	FW Order	CHAR	10	-	-	Framework Order
110	FORDP	-	Order item	NUMC	5	-	-	Item of framework order
111	PLIFZ	-	Plnd Dely	DEC	3	-	-	Planned Delivery Time in Days
112	BERID	-	MRP Area	CHAR	10	-	-	MRP Area
113	UZEIT	-	Time	TIMS	6	-	-	Delivery Date Time-Spot
114	FKBER	-	Func. Area	CHAR	16	-	-	Functional Area
115	GRANT_NBR	-	Grant	CHAR	20	-	-	Grant
116	MEMORY	-	Incomplete	CHAR	1	-	-	Purchase Requisition not yet Complete
117	BANPR	-	Proc.state	CHAR	2	-	-	Requisition Processing State
118	RLWRT	-	Tot. value	CURR	15	2	-	Total value at time of release
119	BLCKD	-	Block	CHAR	1	-	-	Purchase Requisition Blocked
120	REVNO	-	Version	CHAR	8	-	-	Version number in Purchasing
121	BLCKT	-	Blkg Text	CHAR	60	-	-	Reason for Item Block
122	BESWK	-	Proc. Plan	CHAR	4	-	-	Procuring Plant
123	EPROFILE	-	Profile	CHAR	2	-	-	External Procurement Profile
124	EPREFDOC	-	Ext. doc.	CHAR	10	-	-	External Procurement Reference Document
125	EPREFITM	-	ExItem	NUMC	5	-	-	External Procurement Reference Item
126	GMMNG	-	Hld PO Qty	QUAN	13	3	-	PO Quantity of Purchase Requisition in POs on Hold
127	WRTKZ	-	Value-Bsd	CHAR	1	-	-	Value-Based Commitment Reduction for Service Purchase Reqs
128	RESLO	-	Iss.St.Loc	CHAR	4	-	-	Issuing Storage Location for Stock Transport Order
129	KBLNR	-	DocumentNo	CHAR	10	-	-	Document Number for Earmarked Funds
130	KBLPOS	-	Doc. item	NUMC	3	-	-	Earmarked Funds: Document Item
131	PRIO_URG	-	ReqmtUrgcy	NUMC	2	-	-	Requirement Urgency
132	PRIO_REQ	-	ReqmtPrio.	NUMC	3	-	-	Requirement Priority
133	MEMORYTYPE	-	Category	CHAR	1	-	-	Category of Incompleteness
134	ANZSN	-	No.ser.no.	INT4	10	-	-	Number of serial numbers
135	MHDRZ	-	Rem. Life	DEC	4	-	-	Minimum Remaining Shelf Life
136	IPRKZ	-	Per. Ind.	CHAR	1	-	-	Period Indicator for Shelf Life Expiration Date
137	NODISP	-	Res/PurcRq	CHAR	1	-	-	Ind: Reserv. not applicable to MRP;Purc. req. not created
138	SRM_CONTRACT_ID	-	CentContr.	CHAR	10	-	-	Central Contract
139	SRM_CONTRACT_ITM	-	CC Item	NUMC	10	-	-	Central Contract Item Number
140	BUDGET_PD	-	BP	CHAR	10	-	-	FM: Budget Period
141	ADVCODE	-	AdvCd	CHAR	2	-	-	Advice Code
142	STACODE	-	StatC	CHAR	2	-	-	Status Code
143	BANFN_CS	-	CS PReq	CHAR	10	-	-	Cross-System PReq Number
144	BNFPO_CS	-	CS PReqItm	NUMC	5	-	-	Cross-System PReq Item
145	ITEM_CS	-	Category	CHAR	1	-	-	Cross-System Item Category
146	BSMNG_SND	-	Ordered	QUAN	13	3	-	PO Quantity Sender
147	NO_MARD_DATA	-	SLoc Data	CHAR	1	-	-	No Storage Location Data Exists for Material
148	SERRU	-	SC type	CHAR	1	-	-	Type of subcontracting
149	DISUB_SOBKZ	-	Sp. stck	CHAR	1	-	-	Special stock indicator Subcontracting
150	DISUB_PSPNR	-	WBS Elem.	NUMC	8	-	-	Work Breakdown Structure Element (WBS Element)
151	DISUB_KUNNR	-	Customer	CHAR	10	-	-	Customer Number 1
152	DISUB_VBELN	-	SD Doc.	CHAR	10	-	-	Sales and Distribution Document Number
153	DISUB_POSNR	-	Item	NUMC	6	-	-	Item number of the SD document
154	DISUB_OWNER	-	Owner	CHAR	10	-	-	Owner of stock
155	IUID_RELEVANT	-	IUID-Rel.	CHAR	1	-	-	IUID-Relevant

Related References & SQL

Diagram ERD, T-Code standar, tabel terkait, dan contoh query untuk EBAN.

Interactive ERD Diagrams

SAP MM - Purchase Requisition Relation →

Standard T-Codes

ME53N ME51N ME52N ME5A

Related Tables

MARA T001W T001L LFA1 EKKO KNA1 TCURC T002

ANSI SQL Query

SELECT a.BANFN,
       a.BNFPO,
       a.BSART,
       a.BSTYP,
       a.BSAKZ,
       a.LOEKZ,
       a.STATU
FROM EBAN AS a
WHERE a.BANFN = '0001'
  AND a.BNFPO = '0001';

ABAP OpenSQL (7.40+)

SELECT a~banfn,
       a~bnfpo,
       a~bsart,
       a~bstyp,
       a~bsakz,
       a~loekz,
       a~statu
  FROM eban AS a
  WHERE a~banfn = '0001'
  and a~bnfpo = '0001'
  INTO TABLE @DATA(lt_eban)
  UP TO 100 ROWS.

SE11 ABAP Dictionary SE11 EBAN

EBAN

Dictionary Fields Fields

Related References & SQL