SAP ABAP View V_RFFMRE10 (View for Earmarked Funds Journal)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ FI-FM-PO (Application Component) Postings
     ⤷ FMRE (Package) Funds Management: Earmarked Funds

Basic Data

View Type	D	Database View
Database View	V_RFFMRE10
Short Description	View for Earmarked Funds Journal
Root table	KBLK	Document Header: Manual Document Entry

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	KBLK	KBLK
2	KBLP

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	KBLK	MANDT	JL	EQ				0	0
2	KBLP	MANDT	JR	EQ			AND	0	0
3	KBLK	BELNR	JL	EQ				0	0
4	KBLP	BELNR	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	KBLK	MANDT		☐	MANDT	☐	Client
2	BELNR	KBLK	BELNR		☐	KBLNR	☐	Document Number for Earmarked Funds
3	BLPOS	KBLP	BLPOS		☐	KBLPOS	☐	Earmarked Funds: Document Item
4	BLTYP	KBLK	BLTYP		☐	KBLTYP	☐	Earmarked Funds Document Category
5	KVRGNG	KBLK	KVRGNG		☐	KBLVORGANG	☐	Business Transaction
6	KERFAS	KBLK	KERFAS		☐	KBLERF	☐	Created by
7	KERDAT	KBLK	KERDAT		☐	KBLERDAT	☐	Entry date
8	KAENDE	KBLK	KAENDE		☐	KBLAEN	☐	Last changed by
9	KAEDAT	KBLK	KAEDAT		☐	KBLAEDAT	☐	Date of Last Change
10	BLDAT	KBLK	BLDAT		☐	BLDAT	☐	Document Date in Document
11	KTEXT	KBLK	KTEXT		☐	KBLKTEXT	☐	Doc.header text
12	XBLNR	KBLK	XBLNR		☐	XBLNR1	☐	Reference Document Number
13	BLART	KBLK	BLART		☐	KBLART	☐	Doc.type: Manual document entry
14	WAERS	KBLK	WAERS		☐	TWAER	☐	Transaction Currency
15	KLOEKZ	KBLK	KLOEKZ		☐	KBLLOEKZ	☐	Deletion Indicator
16	BUKRS	KBLK	BUKRS		☐	BUKRS	☐	Company Code
17	KOKRS	KBLK	KOKRS		☐	KOKRS	☐	Controlling Area
18	FIKRS	KBLK	FIKRS		☐	FIKRS	☐	Financial Management Area
19	LOTKZ	KBLK	LOTKZ		☐	LOTKZ	☐	Lot Number for Documents
20	HWAER	KBLK	HWAER		☐	HSWAE	☐	Local currency key
21	KURSF	KBLK	KURSF		☐	KURSF	☐	Exchange rate
22	WWERT	KBLK	WWERT		☐	WWERT_D	☐	Translation date
23	BLKKZ	KBLK	BLKKZ		☐	BLKKZ	☐	Blocking indicator (header)
24	FEXEC	KBLK	FEXEC		☐	FEXEC	☐	Indicator: final completion (paid)
25	WKAPK	KBLK	WKAPK		☐	WKAPK	☐	Indicator: document is approved
26	FMREASON	KBLK	FMREASON		☐	FMREASON	☐	Reason for decision for workflow
27	KURSUK	KBLK	KURSUK		☐	KURSU	☐	Last revaluation rate
28	DATUK	KBLK	DATUK		☐	DATU	☐	Date of last revaluation
29	DOCLOCK	KBLK	DOCLOCK		☐	FMRDOCLOCK	☐	Funds precommitment document block
30	CCINS	KBLK	CCINS		☐	CCINS_30F	☐	Payment cards: Card type
31	CCNUM	KBLK	CCNUM		☐	CCNUM_30F	☐	Payment cards: Card number
32	CCNAME	KBLK	CCNAME		☐	CCNAME_30F	☐	Payment cards: Name of cardholder
33	CRPUDATE	KBLK	CRPUDATE		☐	CRPUDATE	☐	Card Document: Date of Card Transaction (Purchase Date)
34	CRAUTHNO	KBLK	CRAUTHNO		☐	CRAUTHNO	☐	Card Document: Authorization Number of Transaction
35	CRWRBTR	KBLK	CRWRBTR		☐	CRWRBTR	☐	Card Document: Paid Transaction Amount
36	CRWMWST	KBLK	CRWMWST		☐	CRWMWST	☐	Card Document: Tax on Sales/Purchases Paid
37	CRCALCTAX	KBLK	CRCALCTAX		☐	CRCALCTAX	☐	Payment Cards: Calculate Tax
38	CRNETBTR	KBLK	CRNETBTR		☐	CRNETBTR	☐	Card Document: Net Amount Paid
39	CRDMBTR	KBLK	CRDMBTR		☐	CRDMBTR	☐	Card Document: Transaction Amount in Local Currency (Calc.)
40	CRMWSTS	KBLK	CRMWSTS		☐	CRMWSTS	☐	Card Document: Tax on Sales/Purchases Paid in Local Currency
41	CRNETDMBTR	KBLK	CRNETDMBTR		☐	CRNETDMBTR	☐	Card Document: Net Amount Paid in Local Currency
42	CRMATGOT	KBLK	CRMATGOT		☐	CRRECIEVED	☐	Card Document: Goods Received
43	CREATE_RES	KBLK	CREATE_RES		☐	CREATE_RES	☐	Card Document: Reserve Funds
44	CRMATCH	KBLK	CRMATCH		☐	CRMATCH	☐	Card Document: Reduction Earmarked
45	CRSUPNAM	KBLK	CRSUPNAM		☐	CRSUPNAM	☐	Payment Cards: Name and Address of Vendor
46	BUDAT	KBLK	BUDAT		☐	BUDAT	☐	Posting Date in the Document
47	MVSTAT	KBLK	MVSTAT		☐	FMR_MVSTAT	☐	Document Entry Status (Posted, Parked)
48	PTEXT	KBLP	PTEXT		☐	SGTXT	☐	Item Text
49	ERLKZ	KBLP	ERLKZ		☐	KBLERLKZ	☐	Completion indicator for line item
50	ERLDAT	KBLP	ERLDAT		☐	KBLERLDAT	☐	Completion date
51	LOEKZ	KBLP	LOEKZ		☐	KBLLOEKZ	☐	Deletion Indicator
52	WTGES	KBLP	WTGES		☐	KBLWTG	☐	Total reserved amount in transaction currency
53	MENGE	KBLP	MENGE		☐	KBLMENGE	☐	Reserved quantity
54	MEINH	KBLP	MEINH		☐	CO_MEINH	☐	Unit of Measure
55	PREIS	KBLP	PREIS		☐	KBLPREIS	☐	Price
56	PEINH	KBLP	PEINH		☐	PEINH	☐	Price unit
57	FIPOS	KBLP	FIPOS		☐	FIPOS_XPO	☐	Commitment item
58	FIPEX	KBLP	FIPEX		☐	FM_FIPEX	☐	Commitment item
59	AUFNR	KBLP	AUFNR		☐	AUFNR	☐	Order Number
60	KOSTL	KBLP	KOSTL		☐	KOSTL	☐	Cost Center
61	PSPNR	KBLP	PSPNR		☐	PS_PSP_ELE	☐	Work breakdown structure element (WBS element)
62	FISTL	KBLP	FISTL		☐	FISTL	☐	Funds Center
63	GEBER	KBLP	GEBER		☐	BP_GEBER	☐	Fund
64	FDATK	KBLP	FDATK		☐	KBLFDATK	☐	Costs due on
65	MATNR	KBLP	MATNR		☐	MATNR	☐	Material Number
66	LIFNR	KBLP	LIFNR		☐	LIFNR	☐	Account Number of Vendor or Creditor
67	XSENDER	KBLP	XSENDER		☐	XSENDER	☐	Indicator: Sender
68	XEMPFGR	KBLP	XEMPFGR		☐	XEMPFGR	☐	Indicator: Receiver
69	AUFPL	KBLP	AUFPL		☐	CO_AUFPL	☐	Routing number of operations in the order
70	APLZL	KBLP	APLZL		☐	CO_APLZL	☐	General counter for order
71	STATS	KBLP	STATS		☐	FMRE_STATS	☐	Funds Management Statistical Indicator
72	BLPKZ	KBLP	BLPKZ		☐	BLPKZ	☐	Blocking Indicator (Item)
73	UEBTO	KBLP	UEBTO		☐	FMUEBTO	☐	Tolerance limit for overrun
74	ABGWAERS	KBLP	ABGWAERS		☐	FMABGWAERS	☐	Reduction in local currency only
75	WKAPP	KBLP	WKAPP		☐	WKAPP	☐	Item approved
76	CARRYOV	KBLP	CARRYOV		☐	CARRYOV	☐	Do not carry forward open documents in the fiscal year chge
77	LNRZA	KBLP	LNRZA		☐	LNRZA	☐	Account Number of the Alternative Payee
78	REFBLTYP	KBLP	REFBLTYP		☐	REFBLTYP	☐	Reference doc.category: funds precommitment or reservation
79	REFBELNR	KBLP	REFBELNR		☐	REFKBLNR	☐	Reference document number: reservation/funds precommitment
80	REFBLPOS	KBLP	REFBLPOS		☐	REFKBLPOS	☐	Item in reference document
81	DELTAWTAPP	KBLP	DELTAWTAPP		☐	DELTAWTAPP	☐	Amount change to be approved (transaction currency)
82	DELTAHWAPP	KBLP	DELTAHWAPP		☐	DELTAHWAPP	☐	Amount change to be approved (local currency)
83	SAKNR	KBLP	SAKNR		☐	SAKNR	☐	G/L Account Number
84	KUNNR	KBLP	KUNNR		☐	KUNNR	☐	Customer Number
85	KURSUP	KBLP	KURSUP		☐	KURSU	☐	Last revaluation rate
86	DATUP	KBLP	DATUP		☐	DATU	☐	Date of last revaluation
87	WTFREE	KBLP	WTFREE		☐	FMWTFREE	☐	Open amount (transaction currency)
88	HWFREE	KBLP	HWFREE		☐	FMHWFREE	☐	Open amount (local currency)
89	WTORIG	KBLP	WTORIG		☐	FMWTORIG	☐	Original Amount in Transaction Currency
90	HWORIG	KBLP	HWORIG		☐	FMHWORIG	☐	Original amount in local currency
91	POSLOCK	KBLP	POSLOCK		☐	FMRPOSLOCK	☐	Earmarked funds item block
92	PMACTIVE	KBLP	PMACTIVE		☐	FMRPMACTIVE	☐	Indicator: Amount Change Only with Value Adjustment Document
93	HWGES	KBLP	HWGES		☐	KBLHWG	☐	Total value in local currency
94	MWSKZ	KBLP	MWSKZ		☐	CRMWSKZ	☐	Card Document: Tax on Sales/Purchases Code
95	TXJCD	KBLP	TXJCD		☐	TXJCD	☐	Tax Jurisdiction
96	WMWST	KBLP	WMWST		☐	CRWMWST	☐	Card Document: Tax on Sales/Purchases Paid
97	MWSTS	KBLP	MWSTS		☐	CRMWSTS	☐	Card Document: Tax on Sales/Purchases Paid in Local Currency
98	NETBTR	KBLP	NETBTR		☐	CRNETBTR	☐	Card Document: Net Amount Paid
99	NETHW	KBLP	NETHW		☐	CRNETDMBTR	☐	Card Document: Net Amount Paid in Local Currency
100	CONSUMEKZ	KBLP	CONSUMEKZ		☐	FMCONSUME	☐	Usage may exceed reserved amount without limit
101	ACCHANG	KBLP	ACCHANG		☐	FM_ACCHANG	☐	FM account assignment can be changed in follow-on document
102	FKBER	KBLP	FKBER		☐	FKBER	☐	Functional Area
103	GRANT_NBR	KBLP	GRANT_NBR		☐	GM_GRANT_NBR	☐	Grant
104	BUDGET_PD	KBLP	BUDGET_PD		☐	FM_BUDGET_PERIOD	☐	FM: Budget Period

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