SAP ABAP View /SAPPSPRO/V_GRIR (DB View: Selection for MR11 Clearing GR/IR Clearing Account)

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_GRIR
Short Description	DB View: Selection for MR11 Clearing GR/IR Clearing Account
Root table	EKKO	Purchasing Document Header

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	EKKO	EKKO
2	EKPO
3	EKBE
4	/SAPPSPRO/EADD

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	EKBE	MANDT	JR	EQ			AND	0	0
7	EKPO	EBELN	JL	EQ				0	0
8	EKBE	EBELN	JR	EQ			AND	0	0
9	EKPO	EBELP	JL	EQ				0	0
10	EKBE	EBELP	JR	EQ			AND	0	0
11	/SAPPSPRO/EADD	EBELN	JL	EQ				0	0
12	EKKO	EBELN	JR	EQ			AND	0	0
13	/SAPPSPRO/EADD	MANDT	JL	EQ				0	0
14	EKKO	MANDT	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	LIFRE	EKKO	LIFRE		☐	LIFRE	☐	Different Invoicing Party
14	FRGRL	EKKO	FRGRL		☐	FRGRL	☐	Release Not Yet Completely Effected
15	MEMORY	EKKO	MEMORY		☐	MEMER	☐	Purchase order not yet complete
16	EBELP	EKPO	EBELP		☐	EBELP	☐	Item Number of Purchasing Document
17	LOEKZ_P	EKPO	LOEKZ		☐	ELOEK	☐	Deletion indicator in purchasing document
18	TXZ01	EKPO	TXZ01		☐	TXZ01	☐	Short Text
19	BUKRS	EKPO	BUKRS		☐	BUKRS	☐	Company Code
20	MATNR	EKPO	MATNR		☐	MATNR	☐	Material Number
21	BWTAR	EKPO	BWTAR		☐	BWTAR_D	☐	Valuation type
22	WERKS	EKPO	WERKS		☐	EWERK	☐	Plant
23	SOBKZ	EKPO	SOBKZ		☐	SOBKZ	☐	Special Stock Indicator
24	KZBWS	EKPO	KZBWS		☐	KZBWS	☐	Valuation of Special Stock
25	PEINH	EKPO	PEINH		☐	EPEIN	☐	Price unit
26	MEINS	EKPO	MEINS		☐	BSTME	☐	Order unit
27	BPRME	EKPO	BPRME		☐	BBPRM	☐	Order Price Unit (purchasing)
28	BPUMZ	EKPO	BPUMZ		☐	BPUMZ	☐	Numerator for Conversion of Order Price Unit into Order Unit
29	BPUMN	EKPO	BPUMN		☐	BPUMN	☐	Denominator for Conv. of Order Price Unit into Order Unit
30	UMREZ	EKPO	UMREZ		☐	UMBSZ	☐	Numerator for Conversion of Order Unit to Base Unit
31	UMREN	EKPO	UMREN		☐	UMBSN	☐	Denominator for Conversion of Order Unit to Base Unit
32	PSTYP	EKPO	PSTYP		☐	PSTYP	☐	Item category in purchasing document
33	KNTTP	EKPO	KNTTP		☐	KNTTP	☐	Account assignment category
34	VRTKZ	EKPO	VRTKZ		☐	VRTKZ	☐	Distribution indicator for multiple account assignment
35	WEPOS	EKPO	WEPOS		☐	WEPOS	☐	Goods Receipt Indicator
36	WEUNB	EKPO	WEUNB		☐	WEUNB	☐	Goods Receipt, Non-Valuated
37	REPOS	EKPO	REPOS		☐	REPOS	☐	Invoice receipt indicator
38	WEBRE	EKPO	WEBRE		☐	WEBRE	☐	Indicator: GR-Based Invoice Verification
39	GEBER	EKPO	GEBER		☐	BP_GEBER	☐	Fund
40	FISTL	EKPO	FISTL		☐	FISTL	☐	Funds Center
41	FIPOS	EKPO	FIPOS		☐	FIPOS	☐	Commitment Item
42	FKBER	EKPO	FKBER		☐	FKBER	☐	Functional Area
43	GRANT_NBR	EKPO	GRANT_NBR		☐	GM_GRANT_NBR	☐	Grant
44	KO_GSBER	EKPO	KO_GSBER		☐	GSBER_GP	☐	Business area reported to the partner
45	KO_PARGB	EKPO	KO_PARGB		☐	PARGB_GP	☐	assumed business area of the business partner
46	KO_PRCTR	EKPO	KO_PRCTR		☐	PRCTR	☐	Profit Center
47	KO_PPRCTR	EKPO	KO_PPRCTR		☐	PPRCTR	☐	Partner Profit Center
48	XERSY	EKPO	XERSY		☐	XERSY	☐	Evaluated Receipt Settlement (ERS)
49	RETPO	EKPO	RETPO		☐	RETPO	☐	Returns Item
50	LEBRE	EKPO	LEBRE		☐	LEBRE	☐	Indicator for Service-Based Invoice Verification
51	ZEKKN	EKBE	ZEKKN		☐	DZEKKN	☐	Sequential Number of Account Assignment
52	VGABE	EKBE	VGABE		☐	VGABE	☐	Transaction/event type, purchase order history
53	GJAHR	EKBE	GJAHR		☐	MJAHR	☐	Year of material document
54	BELNR	EKBE	BELNR		☐	MBLNR	☐	Number of Material Document
55	BUZEI	EKBE	BUZEI		☐	MBLPO	☐	Item in material document
56	BEWTP	EKBE	BEWTP		☐	BEWTP	☐	Purchase Order History Category
57	BUDAT	EKBE	BUDAT		☐	BUDAT	☐	Posting Date in the Document
58	MENGE	EKBE	MENGE		☐	MENGE_D	☐	Quantity
59	DMBTR	EKBE	DMBTR		☐	DMBTR	☐	Amount in local currency
60	AREWR	EKBE	AREWR		☐	AREWR	☐	GR/IR account clearing value in local currency
61	SHKZG	EKBE	SHKZG		☐	SHKZG	☐	Debit/Credit Indicator
62	LFGJA	EKBE	LFGJA		☐	LFBJA	☐	Fiscal Year of a Reference Document
63	LFBNR	EKBE	LFBNR		☐	LFBNR	☐	Document number of a reference document
64	LFPOS	EKBE	LFPOS		☐	LFPOS	☐	Item of a reference document
65	BWTAR_BE	EKBE	BWTAR		☐	BWTAR_D	☐	Valuation type
66	SRVPOS	EKBE	SRVPOS		☐	SRVPOS	☐	Service number
67	BPMNG	EKBE	BPMNG		☐	MENGE_BPR	☐	Quantity in purchase order price unit
68	XWOFF	EKBE	XWOFF		☐	XWOFF	☐	Calculation of val. open
69	PACKNO	EKBE	PACKNO		☐	PACKNO_EKBE	☐	Package Number of Service
70	INTROW	EKBE	INTROW		☐	INTROW_EKBE	☐	Line Number of Service
71	AREWB	EKBE	AREWB		☐	AREWB	☐	Clearing Value on GR/IR Account in PO Currency
72	REWRB	EKBE	REWRB		☐	REWRB	☐	Invoice Amount in PO Currency
73	WRBTR	EKBE	WRBTR		☐	WRBTR	☐	Amount in document currency
74	STAPO	EKPO	STAPO		☐	STAPO	☐	Item is statistical
75	XBLNR	EKBE	XBLNR		☐	XBLNR1	☐	Reference Document Number
76	LONGNUM	/SAPPSPRO/EADD	LONGNUM		☐	/SAPPSPRO/LONGNUM	☐	Smart Number
77	WESBB	EKBE	WESBB		☐	WESBB	☐	Valuated Goods Receipt Blocked Stock in Order Unit
78	BPWEB	EKBE	BPWEB		☐	BPWEB	☐	Quantity in Valuated GR Blocked Stock in Order Price Unit
79	XMACC	EKBE	XMACC		☐	XMACC	☐	Multiple Account Assignment
80	CPUDT	EKBE	CPUDT		☐	CPUDT	☐	Accounting document entry date
81	CPUTM	EKBE	CPUTM		☐	CPUTM	☐	Time of data entry
82	STATU	EKKO	STATU		☐	ESTAK	☐	Status of Purchasing Document
83	HISTCURR	EKBE	WAERS		☐	WAERS	☐	Currency Key
84	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	600