SAP ABAP View /ISDFPS/V_BI_EBA (Extraction View for EBAN (Fields Are Renamed))

Hierarchy

☛ EA-DFPS (Software Component) SAP Enterprise Extension Defense Forces & Public Security
   ⤷ IS-DFS (Application Component) Defense Forces and Public Security
     ⤷ /ISDFPS/BI_CONTENT (Package) BI Content Defense (Extractors And So On)

Basic Data

View Type	D	Database View
Database View	/ISDFPS/V_BI_EBA
Short Description	Extraction View for EBAN (Fields Are Renamed)
Root table	EBAN	Purchase Requisition

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	EBAN	EBAN

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	EBAN	BANFN		NE	''			0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	EBAN	MANDT		☐	MANDT	☐	Client
2	PREQ_NO	EBAN	BANFN		☐	BANFN	☐	Purchase requisition number
3	PREQ_ITEM	EBAN	BNFPO		☐	BNFPO	☐	Item number of purchase requisition
4	BSART	EBAN	BSART		☐	BBSRT	☐	Purchase Requisition Document Type
5	BSTYP	EBAN	BSTYP		☐	BSTYP	☐	Purchasing document category
6	BSAKZ	EBAN	BSAKZ		☐	BSAKZ	☐	Control indicator for purchasing document type
7	LOEKZ	EBAN	LOEKZ		☐	ELOEK	☐	Deletion indicator in purchasing document
8	STATU	EBAN	STATU		☐	BANST	☐	Processing status of purchase requisition
9	ESTKZ	EBAN	ESTKZ		☐	ESTKZ	☐	Creation indicator (purchase requisition/schedule lines)
10	FRGKZ	EBAN	FRGKZ		☐	FRGKZ	☐	Release Indicator
11	FRGZU	EBAN	FRGZU		☐	FRGZU	☐	Release status
12	FRGST	EBAN	FRGST		☐	FRGST	☐	Release strategy in the purchase requisition
13	EKGRP	EBAN	EKGRP		☐	EKGRP	☐	Purchasing group
14	ERNAM	EBAN	ERNAM		☐	ERNAM	☐	Name of Person who Created the Object
15	ERDAT	EBAN	ERDAT		☐	AEDAT	☐	Last Changed On
16	AFNAM	EBAN	AFNAM		☐	AFNAM	☐	Name of requisitioner/requester
17	TXZ01	EBAN	TXZ01		☐	TXZ01	☐	Short Text
18	MATNR	EBAN	MATNR		☐	MATNR	☐	Material Number
19	EMATN	EBAN	EMATN		☐	EMATN	☐	Material number corresponding to manufacturer part number
20	WERKS	EBAN	WERKS		☐	EWERK	☐	Plant
21	LGORT	EBAN	LGORT		☐	LGORT_D	☐	Storage location
22	BEDNR	EBAN	BEDNR		☐	BEDNR	☐	Requirement Tracking Number
23	MATKL	EBAN	MATKL		☐	MATKL	☐	Material Group
24	RESWK	EBAN	RESWK		☐	RESWK	☐	Supplying (issuing) plant in case of stock transport order
25	MENGE	EBAN	MENGE		☐	BAMNG	☐	Purchase requisition quantity
26	MEINS	EBAN	MEINS		☐	BAMEI	☐	Purchase requisition unit of measure
27	BUMNG	EBAN	BUMNG		☐	BUMNG	☐	Shortage (stock undercoverage) quantity
28	BADAT	EBAN	BADAT		☐	BADAT	☐	Requisition (request) date
29	LPEIN	EBAN	LPEIN		☐	LPEIN	☐	Category of delivery date
30	LFDAT	EBAN	LFDAT		☐	EINDT	☐	Item delivery date
31	FRGDT	EBAN	FRGDT		☐	FRGDT	☐	Purchase Requisition Release Date
32	WEBAZ	EBAN	WEBAZ		☐	WEBAZ	☐	Goods receipt processing time in days
33	PREIS	EBAN	PREIS		☐	BAPRE	☐	Price in Purchase Requisition
34	PEINH	EBAN	PEINH		☐	EPEIN	☐	Price unit
35	PSTYP	EBAN	PSTYP		☐	PSTYP	☐	Item category in purchasing document
36	KNTTP	EBAN	KNTTP		☐	KNTTP	☐	Account assignment category
37	KZVBR	EBAN	KZVBR		☐	KZVBR	☐	Consumption posting
38	KFLAG	EBAN	KFLAG		☐	KFLAG	☐	Acct.asst.changeable
39	VRTKZ	EBAN	VRTKZ		☐	VRTKZ	☐	Distribution indicator for multiple account assignment
40	TWRKZ	EBAN	TWRKZ		☐	TWRKZ	☐	Partial invoice indicator
41	WEPOS	EBAN	WEPOS		☐	WEPOS	☐	Goods Receipt Indicator
42	WEUNB	EBAN	WEUNB		☐	WEUNB	☐	Goods Receipt, Non-Valuated
43	REPOS	EBAN	REPOS		☐	REPOS	☐	Invoice receipt indicator
44	LIFNR	EBAN	LIFNR		☐	WLIEF	☐	Desired vendor
45	FLIEF	EBAN	FLIEF		☐	FLIEF	☐	Fixed vendor
46	EKORG	EBAN	EKORG		☐	EKORG	☐	Purchasing organization
47	VRTYP	EBAN	VRTYP		☐	BSTYP	☐	Purchasing document category
48	KONNR	EBAN	KONNR		☐	KONNR	☐	Number of principal purchase agreement
49	KTPNR	EBAN	KTPNR		☐	KTPNR	☐	Item number of principal purchase agreement
50	INFNR	EBAN	INFNR		☐	INFNR	☐	Number of purchasing info record
51	ZUGBA	EBAN	ZUGBA		☐	DZUGBA	☐	Assigned Source of Supply
52	QUNUM	EBAN	QUNUM		☐	QUNUM	☐	Number of quota arrangement
53	QUPOS	EBAN	QUPOS		☐	QUPOS	☐	Quota arrangement item
54	DISPO	EBAN	DISPO		☐	DISPO	☐	MRP controller
55	SERNR	EBAN	SERNR		☐	SERNR	☐	BOM explosion number
56	BVDAT	EBAN	BVDAT		☐	BVDAT	☐	Date of last resubmission
57	BATOL	EBAN	BATOL		☐	BATOL	☐	Resubmission interval of purchase requisition
58	BVDRK	EBAN	BVDRK		☐	BVDRK	☐	Number of resubmissions
59	EBELN	EBAN	EBELN		☐	BSTNR	☐	Purchase order number
60	EBELP	EBAN	EBELP		☐	BSTPO	☐	Purchase order item number
61	BEDAT	EBAN	BEDAT		☐	BEDAT	☐	Purchase Order Date
62	BSMNG	EBAN	BSMNG		☐	BSMNG	☐	Quantity ordered against this purchase requisition
63	LBLNI	EBAN	LBLNI		☐	LBLNI	☐	Entry Sheet Number
64	BWTAR	EBAN	BWTAR		☐	BWTAR_D	☐	Valuation type
65	XOBLR	EBAN	XOBLR		☐	XOBLR	☐	Item affects commitments
66	EBAKZ	EBAN	EBAKZ		☐	EBAKZ	☐	Purchase requisition closed
67	RSNUM	EBAN	RSNUM		☐	RSNUM	☐	Number of reservation/dependent requirements
68	SOBKZ	EBAN	SOBKZ		☐	SOBKZ	☐	Special Stock Indicator
69	ARSNR	EBAN	ARSNR		☐	ARSNR	☐	Settlement reservation number
70	ARSPS	EBAN	ARSPS		☐	ARSPS	☐	Item number of the settlement reservation
71	FIXKZ	EBAN	FIXKZ		☐	BAFIX	☐	Purchase requisition is fixed
72	BMEIN	EBAN	BMEIN		☐	BSTME	☐	Order unit
73	REVLV	EBAN	REVLV		☐	REVLV	☐	Revision level
74	VORAB	EBAN	VORAB		☐	VORAB	☐	Advance procurement: project stock
75	PACKNO	EBAN	PACKNO		☐	PACKNO	☐	Package number
76	KANBA	EBAN	KANBA		☐	KBNKZ	☐	Kanban Indicator
77	BPUEB	EBAN	BPUEB		☐	BPUEB	☐	Adopt requisition price in purchase order
78	CUOBJ	EBAN	CUOBJ		☐	CUOBJ	☐	Configuration (internal object number)
79	FRGGR	EBAN	FRGGR		☐	FRGGR	☐	Release group
80	FRGRL	EBAN	FRGRL		☐	FRGRL	☐	Release Not Yet Completely Effected
81	AKTNR	EBAN	AKTNR		☐	WAKTION	☐	Promotion
82	BATCH	EBAN	CHARG		☐	CHARG_D	☐	Batch Number
83	UMSOK	EBAN	UMSOK		☐	UMSOK	☐	Special stock indicator for physical stock transfer
84	VERID	EBAN	VERID		☐	VERID	☐	Production Version
85	FIPOS	EBAN	FIPOS		☐	FIPOS	☐	Commitment Item
86	FISTL	EBAN	FISTL		☐	FISTL	☐	Funds Center
87	GEBER	EBAN	GEBER		☐	BP_GEBER	☐	Fund
88	KZKFG	EBAN	KZKFG		☐	KZCUH	☐	Origin of Configuration
89	SATNR	EBAN	SATNR		☐	SATNR	☐	Cross-Plant Configurable Material
90	MNG02	EBAN	MNG02		☐	MNG06	☐	Committed quantity
91	DAT01	EBAN	DAT01		☐	DAT05	☐	Committed date
92	ATTYP	EBAN	ATTYP		☐	ATTYP	☐	Material Category
93	ADRNR	EBAN	ADRNR		☐	ADRNR_MM	☐	Manual address number in purchasing document item
94	ADRN2	EBAN	ADRN2		☐	ADRN2	☐	Number of delivery address
95	KUNNR	EBAN	KUNNR		☐	EKUNNR	☐	Customer
96	EMLIF	EBAN	EMLIF		☐	EMLIF	☐	Vendor to be supplied/who is to receive delivery
97	LBLKZ	EBAN	LBLKZ		☐	LBLKZ	☐	Subcontracting vendor
98	KZBWS	EBAN	KZBWS		☐	KZBWS	☐	Valuation of Special Stock
99	WAERS	EBAN	WAERS		☐	WAERS	☐	Currency Key
100	IDNLF	EBAN	IDNLF		☐	IDNLF	☐	Material Number Used by Vendor
101	GSFRG	EBAN	GSFRG		☐	GSFRG	☐	Overall release of purchase requisitions
102	MPROF	EBAN	MPROF		☐	MPROF	☐	Mfr part profile
103	KZFME	EBAN	KZFME		☐	KZWSO	☐	Units of measure usage
104	SPRAS	EBAN	SPRAS		☐	SPRAS	☐	Language Key
105	TECHS	EBAN	TECHS		☐	TECHS	☐	Parameter Variant/Standard Variant
106	MFRPN	EBAN	MFRPN		☐	MFRPN	☐	Manufacturer Part Number
107	MFRNR	EBAN	MFRNR		☐	MFRNR	☐	Manufacturer number
108	EMNFR	EBAN	EMNFR		☐	EMNFR	☐	External manufacturer code name or number
109	FORDN	EBAN	FORDN		☐	SFORDN	☐	Framework Order
110	FORDP	EBAN	FORDP		☐	FORDP	☐	Item of framework order
111	PLIFZ	EBAN	PLIFZ		☐	PLIFZ	☐	Planned delivery time in days
112	BERID	EBAN	BERID		☐	BERID	☐	MRP Area
113	UZEIT	EBAN	UZEIT		☐	LZEIT	☐	Delivery Date Time-Spot
114	FKBER	EBAN	FKBER		☐	FKBER	☐	Functional Area
115	GRANT_NBR	EBAN	GRANT_NBR		☐	GM_GRANT_NBR	☐	Grant
116	MEMORY	EBAN	MEMORY		☐	MEMBF	☐	Purchase Requisition not yet Complete
117	BANPR	EBAN	BANPR		☐	BANPR	☐	Requisition Processing State
118	RLWRT	EBAN	RLWRT		☐	RLWRT	☐	Total value at time of release
119	BLCKD	EBAN	BLCKD		☐	BLCKD	☐	Purchase Requisition Blocked
120	REVNO	EBAN	REVNO		☐	REVNO	☐	Version number in Purchasing
121	BLCKT	EBAN	BLCKT		☐	BLCKT	☐	Reason for Item Block
122	BESWK	EBAN	BESWK		☐	BESWK	☐	Procuring Plant
123	EPROFILE	EBAN	EPROFILE		☐	MEPROFILE	☐	External Procurement Profile
124	EPREFDOC	EBAN	EPREFDOC		☐	EPREFDOC	☐	External Procurement Reference Document
125	EPREFITM	EBAN	EPREFITM		☐	EPREFITM	☐	External Procurement Reference Item
126	GMMNG	EBAN	GMMNG		☐	GMMNG	☐	PO Quantity of Purchase Requisition in POs on Hold
127	WRTKZ	EBAN	WRTKZ		☐	WRTKZ	☐	Value-Based Commitment Reduction for Service Purchase Reqs
128	RESLO	EBAN	RESLO		☐	RESLO	☐	Issuing Storage Location for Stock Transport Order
129	ADVCODE	EBAN	ADVCODE		☐	/ISDFPS/ADVCODE	☐	Advice Code
130	STACODE	EBAN	STACODE		☐	/ISDFPS/STACODE	☐	Status Code
131	BANFN_CS	EBAN	BANFN_CS		☐	/ISDFPS/BANFN_CS	☐	Cross-System PReq Number
132	BNFPO_CS	EBAN	BNFPO_CS		☐	/ISDFPS/BNFPO_CS	☐	Cross-System PReq Item
133	ITEM_CS	EBAN	ITEM_CS		☐	/ISDFPS/ITEM_CS	☐	Cross-System Item Category
134	BSMNG_SND	EBAN	BSMNG_SND		☐	/ISDFPS/BSMNG_SND	☐	PO Quantity Sender
135	PRIO_URG	EBAN	PRIO_URG		☐	PRIO_URG	☐	Requirement Urgency
136	PRIO_REQ	EBAN	PRIO_REQ		☐	PRIO_REQ	☐	Requirement Priority

Maintenance Status

Access

☑   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☐   read, change, delete and insert

Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

History

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