SAP ABAP View /SAPPSPRO/V_FRE2 (DB View: Selection for MR11 Clearing Freight Clearing Accnt)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ MM (Application Component) Materials Management
     ⤷ /SAPPSPRO/IV_BASIS (Package) tables, structures

Basic Data

View Type	D	Database View
Database View	/SAPPSPRO/V_FRE2
Short Description	DB View: Selection for MR11 Clearing Freight Clearing Accnt
Root table	EKKO	Purchasing Document Header

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	EKKO	EKKO
2	EKPO
3	EKBZ

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	EKKO	MANDT	JL	EQ				0	0
2	EKPO	MANDT	JR	EQ			AND	0	0
3	EKKO	EBELN	JL	EQ				0	0
4	EKPO	EBELN	JR	EQ			AND	0	0
5	EKPO	MANDT	JL	EQ				0	0
6	EKBZ	MANDT	JR	EQ			AND	0	0
7	EKPO	EBELN	JL	EQ				0	0
8	EKBZ	EBELN	JR	EQ			AND	0	0
9	EKPO	EBELP	JL	EQ				0	0
10	EKBZ	EBELP	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	EKKO	MANDT		☐	MANDT	☐	Client
2	EBELN	EKKO	EBELN		☐	EBELN	☐	Purchasing Document Number
3	BSTYP	EKKO	BSTYP		☐	EBSTYP	☐	Purchasing Document Category
4	BSART	EKKO	BSART		☐	ESART	☐	Purchasing Document Type
5	LOEKZ_K	EKKO	LOEKZ		☐	ELOEK	☐	Deletion indicator in purchasing document
6	LIFNR	EKKO	LIFNR		☐	ELIFN	☐	Vendor's account number
7	EKORG	EKKO	EKORG		☐	EKORG	☐	Purchasing organization
8	EKGRP	EKKO	EKGRP		☐	BKGRP	☐	Purchasing Group
9	WAERS	EKKO	WAERS		☐	WAERS	☐	Currency Key
10	BEDAT	EKKO	BEDAT		☐	EBDAT	☐	Purchasing Document Date
11	VERKF	EKKO	VERKF		☐	EVERK	☐	Responsible Salesperson at Vendor's Office
12	TELF1	EKKO	TELF1		☐	TELF0	☐	Vendor's Telephone Number
13	KNUMV	EKKO	KNUMV		☐	KNUMV	☐	Number of the document condition
14	KALSM	EKKO	KALSM		☐	KALSM_D	☐	Procedure (Pricing, Output Control, Acct. Det., Costing,...)
15	LIFRE	EKKO	LIFRE		☐	LIFRE	☐	Different Invoicing Party
16	FRGRL	EKKO	FRGRL		☐	FRGRL	☐	Release Not Yet Completely Effected
17	MEMORY	EKKO	MEMORY		☐	MEMER	☐	Purchase order not yet complete
18	EBELP	EKPO	EBELP		☐	EBELP	☐	Item Number of Purchasing Document
19	LOEKZ_P	EKPO	LOEKZ		☐	ELOEK	☐	Deletion indicator in purchasing document
20	TXZ01	EKPO	TXZ01		☐	TXZ01	☐	Short Text
21	BUKRS	EKPO	BUKRS		☐	BUKRS	☐	Company Code
22	MATNR	EKPO	MATNR		☐	MATNR	☐	Material Number
23	BWTAR	EKPO	BWTAR		☐	BWTAR_D	☐	Valuation type
24	WERKS	EKPO	WERKS		☐	EWERK	☐	Plant
25	SOBKZ	EKPO	SOBKZ		☐	SOBKZ	☐	Special Stock Indicator
26	KZBWS	EKPO	KZBWS		☐	KZBWS	☐	Valuation of Special Stock
27	PEINH	EKPO	PEINH		☐	EPEIN	☐	Price unit
28	MEINS	EKPO	MEINS		☐	BSTME	☐	Order unit
29	BPRME	EKPO	BPRME		☐	BBPRM	☐	Order Price Unit (purchasing)
30	BPUMZ	EKPO	BPUMZ		☐	BPUMZ	☐	Numerator for Conversion of Order Price Unit into Order Unit
31	BPUMN	EKPO	BPUMN		☐	BPUMN	☐	Denominator for Conv. of Order Price Unit into Order Unit
32	UMREZ	EKPO	UMREZ		☐	UMBSZ	☐	Numerator for Conversion of Order Unit to Base Unit
33	UMREN	EKPO	UMREN		☐	UMBSN	☐	Denominator for Conversion of Order Unit to Base Unit
34	PSTYP	EKPO	PSTYP		☐	PSTYP	☐	Item category in purchasing document
35	KNTTP	EKPO	KNTTP		☐	KNTTP	☐	Account assignment category
36	VRTKZ	EKPO	VRTKZ		☐	VRTKZ	☐	Distribution indicator for multiple account assignment
37	WEPOS	EKPO	WEPOS		☐	WEPOS	☐	Goods Receipt Indicator
38	WEUNB	EKPO	WEUNB		☐	WEUNB	☐	Goods Receipt, Non-Valuated
39	REPOS	EKPO	REPOS		☐	REPOS	☐	Invoice receipt indicator
40	WEBRE	EKPO	WEBRE		☐	WEBRE	☐	Indicator: GR-Based Invoice Verification
41	LEBRE	EKPO	LEBRE		☐	LEBRE	☐	Indicator for Service-Based Invoice Verification
42	GEBER	EKPO	GEBER		☐	BP_GEBER	☐	Fund
43	FISTL	EKPO	FISTL		☐	FISTL	☐	Funds Center
44	FIPOS	EKPO	FIPOS		☐	FIPOS	☐	Commitment Item
45	FKBER	EKPO	FKBER		☐	FKBER	☐	Functional Area
46	GRANT_NBR	EKPO	GRANT_NBR		☐	GM_GRANT_NBR	☐	Grant
47	KO_GSBER	EKPO	KO_GSBER		☐	GSBER_GP	☐	Business area reported to the partner
48	KO_PARGB	EKPO	KO_PARGB		☐	PARGB_GP	☐	assumed business area of the business partner
49	KO_PRCTR	EKPO	KO_PRCTR		☐	PRCTR	☐	Profit Center
50	KO_PPRCTR	EKPO	KO_PPRCTR		☐	PPRCTR	☐	Partner Profit Center
51	MEPRF	EKPO	MEPRF		☐	MEPRF	☐	Price Determination (Pricing) Date Control
52	XERSY	EKPO	XERSY		☐	XERSY	☐	Evaluated Receipt Settlement (ERS)
53	RETPO	EKPO	RETPO		☐	RETPO	☐	Returns Item
54	STUNR	EKBZ	STUNR		☐	STUNR	☐	Level Number
55	ZAEHK	EKBZ	ZAEHK		☐	DZAEHK	☐	Condition counter
56	VGABE	EKBZ	VGABE		☐	VGABE	☐	Transaction/event type, purchase order history
57	GJAHR	EKBZ	GJAHR		☐	GJAHR	☐	Fiscal Year
58	BELNR	EKBZ	BELNR		☐	BELNR_D	☐	Accounting Document Number
59	BUZEI	EKBZ	BUZEI		☐	MBLPO	☐	Item in material document
60	BEWTP	EKBZ	BEWTP		☐	BEWTP	☐	Purchase Order History Category
61	BUDAT	EKBZ	BUDAT		☐	BUDAT	☐	Posting Date in the Document
62	MENGE	EKBZ	MENGE		☐	MENGE_D	☐	Quantity
63	DMBTR	EKBZ	DMBTR		☐	DMBTR	☐	Amount in local currency
64	AREWR	EKBZ	AREWR		☐	AREWR	☐	GR/IR account clearing value in local currency
65	SHKZG	EKBZ	SHKZG		☐	SHKZG	☐	Debit/Credit Indicator
66	LIFNR_FR	EKBZ	LIFNR		☐	LIFNR	☐	Account Number of Vendor or Creditor
67	KSCHL	EKBZ	KSCHL		☐	KSCHL	☐	Condition Type
68	BWTAR_BZ	EKBZ	BWTAR		☐	BWTAR_D	☐	Valuation type
69	BPMNG	EKBZ	BPMNG		☐	BPMNG	☐	Quantity in order price quantity unit
70	WRBTR	EKBZ	WRBTR		☐	WRBTR	☐	Amount in document currency
71	AREWB	EKBZ	AREWB		☐	AREWB	☐	Clearing Value on GR/IR Account in PO Currency
72	REWRB	EKBZ	REWRB		☐	REWRB	☐	Invoice Amount in PO Currency
73	SHKKO	EKBZ	SHKKO		☐	SHKZG	☐	Debit/Credit Indicator
74	EXLIN	EKPO	EXLIN		☐	EXLIN	☐	Item Number Length
75	CPUDT	EKBZ	CPUDT		☐	CPUDT	☐	Accounting document entry date
76	CPUTM	EKBZ	CPUTM		☐	CPUTM	☐	Time of data entry
77	DIFF_INVOICE	EKPO	DIFF_INVOICE		☐	DIFF_INVOICE	☐	Differential Invoicing

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	20140121
SAP Release Created in	700