SAP ABAP View FIN_V_ACCRV (View: Line Items in Cost and Revenue Journal)

Hierarchy

☛ SEM-BW (Software Component) SEM-BW: Strategic Enterprise Management
   ⤷ FIN-BAC-AE (Application Component) Accounting Engine
     ⤷ FINB_ACC_DOCUMENT (Package) Structue of Accounting Document

Basic Data

View Type	D	Database View
Database View	FIN_V_ACCRV
Short Description	View: Line Items in Cost and Revenue Journal
Root table	FINACHD	Accounting Document Header

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	FINACHD	FINACHD
2	FINACITCRV

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	FINACHD	CLIENT	JL	EQ				0	0
2	FINACITCRV	CLIENT	JR	EQ			AND	0	0
3	FINACHD	FIN_TECHDOCNO	JL	EQ				0	0
4	FINACITCRV	FIN_TECHDOCNO	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	CLIENT	FINACHD	CLIENT		☐	MANDT	☐	Client
2	FIN_TECHDOCNO	FINACHD	FIN_TECHDOCNO		☐	FIN_TECHDOCNO	☐	Technical Identifier of a Document
3	FIN_ITEMNO	FINACITCRV	FIN_ITEMNO		☐	FIN_ITEMNO	☐	Line Item Number
4	ACC_SYSTEM	FINACHD	ACC_SYSTEM		☐	ACC_SYSTEM	☐	Accounting System
5	KOKRS	FINACHD	KOKRS		☐	KOKRS	☐	Controlling Area
6	FIN_COMPANY	FINACHD	FIN_COMPANY		☐	FIN_COMPANY	☐	Company
7	FIN_FISCYEAR	FINACHD	FIN_FISCYEAR		☐	FIN_FISCYEAR	☐	Fiscal Year
8	FIN_DOCTYPE	FINACHD	FIN_DOCTYPE		☐	FIN_DOCTYPE	☐	Document Type
9	FIN_ACCDOCNO	FINACHD	FIN_ACCDOCNO		☐	FIN_ACCDOCNO	☐	Document Number
10	FIN_CHOFACCT	FINACHD	FIN_CHOFACCT		☐	FIN_CHOFACCT	☐	Chart of Accounts
11	FIN_HDRTEXT	FINACHD	FIN_HDRTEXT		☐	FIN_HDRTEXT	☐	Document Header Text
12	FIN_REFDOCNO	FINACHD	FIN_REFDOCNO		☐	FIN_REFDOCNO	☐	Reference Document Number
13	FIN_POSTDAT	FINACHD	FIN_POSTDAT		☐	FIN_POSTDAT	☐	Posting Date
14	FIN_DOCDAT	FINACHD	FIN_DOCDAT		☐	FIN_DOCDAT	☐	Document Date
15	FIN_VALUATDAT	FINACHD	FIN_VALUATDAT		☐	FIN_VALUATDAT	☐	Key Date for Valuation of Business Transaction
16	FINB_SND_ID	FINACHD	FINB_SND_ID		☐	FINB_SND_ID	☐	Sender Identification
17	FINB_SNDKEY	FINACHD	FINB_SNDKEY		☐	FINB_SNDKEY	☐	Document Key of the Sending System
18	FIN_REVTYPE	FINACHD	FIN_REVTYPE		☐	FIN_REVTYPE	☐	Reversal Type
19	FIN_REVIND	FINACHD	FIN_REVIND		☐	FIN_REVIND	☐	Reversal Indicator
20	FIN_REVDAT	FINACHD	FIN_REVDAT		☐	FIN_REVDAT	☐	Reversal Date
21	FIN_REVFISCYEAR	FINACHD	FIN_REVFISCYEAR		☐	FIN_REVFISCYEAR	☐	Fiscal Year of Reversed Document
22	FIN_REVDOCNO	FINACHD	FIN_REVDOCNO		☐	FIN_REVDOCNO	☐	Reversed Document
23	FIN_REVTECHDOCNO	FINACHD	FIN_REVTECHDOCNO		☐	FIN_REVTECHDOCNO	☐	Technical Identifier of Reversed Document
24	FIN_FISCYEARVAR	FINACHD	FIN_FISCYEARVAR		☐	FIN_FISCYEARVAR	☐	Fiscal Year Variant
25	FIN_FISCPER	FINACHD	FIN_FISCPER		☐	FIN_FISCPER	☐	Fiscal Period
26	FIN_FISCYEARPER	FINACHD	FIN_FISCYEARPER		☐	FIN_FISCYEARPER	☐	Fiscal Year and Period
27	FIN_CURRCONVDAT	FINACHD	FIN_CURRCONVDAT		☐	FIN_CURRCONVDAT	☐	Date of Translation of Transaction Currency into Local
28	FIN_CLOSESTEP	FINACHD	FIN_CLOSESTEP		☐	FIN_CLOSESTEP	☐	Closing Phase
29	FIN_REVALIND	FINACHD	FIN_REVALIND		☐	FIN_REVALIND	☐	Indicator for Revaluation Documents
30	FIN_BTATYPE	FINACHD	FIN_BTATYPE		☐	FIN_BTATYPE	☐	Business Transaction Category
31	/EACC/BTA_NAME	FINACHD	/EACC/BTA_NAME		☐	/EACC/BTA_NAME	☐	Business Transaction Name
32	UNAME	FINACHD	UNAME		☐	UNAME	☐	User Name
33	DATUM	FINACHD	DATUM		☐	DATUM	☐	Date
34	UZEIT	FINACHD	UZEIT		☐	UZEIT	☐	Time
35	TIMESTAMPL	FINACHD	TIMESTAMPL		☐	TIMESTAMPL	☐	UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)
36	SAPRL	FINACHD	SAPRL		☐	SAPRL	☐	SAP Release
37	FIN_TRANCHE	FINACHD	FIN_TRANCHE		☐	FIN_TRANCHE	☐	Tranche
38	FIN_EEW_ACHD	FINACHD	FIN_EEW_ACHD		☐	DUMMY	☐	Dummy function in length 1
39	FIN_GLITEMNO	FINACITCRV	FIN_GLITEMNO		☐	FIN_GLITEMNO	☐	Item Number of General Ledger Document
40	FIN_DRCRIND	FINACITCRV	FIN_DRCRIND		☐	FIN_DRCRIND	☐	Debit/Credit Indicator
41	FIN_GLACCT	FINACITCRV	FIN_GLACCT		☐	FIN_GLACCT	☐	G/L Account
42	FIN_GLIND	FINACITCRV	FIN_GLIND		☐	FIN_GLIND	☐	Relevant for General Ledger
43	FIN_ITEMTEXT	FINACITCRV	FIN_ITEMTEXT		☐	FIN_ITEMTEXT	☐	Document Item Text
44	FIN_SEGMENT	FINACITCRV	FIN_SEGMENT		☐	FIN_SEGMENT	☐	Segment
45	FIN_PROFITCTR	FINACITCRV	FIN_PROFITCTR		☐	FIN_PROFITCTR	☐	Profit Center
46	FIN_FUNCAREA	FINACITCRV	FIN_FUNCAREA		☐	FIN_FUNCAREA	☐	Functional Area
47	FIN_SEGMENT_P	FINACITCRV	FIN_SEGMENT_P		☐	FIN_SEGMENT_P	☐	Partner Segment
48	FIN_PROFITCTR_P	FINACITCRV	FIN_PROFITCTR_P		☐	FIN_PROFITCTR_P	☐	Partner Profit Center
49	FIN_FUNCAREA_P	FINACITCRV	FIN_FUNCAREA_P		☐	FIN_FUNCAREA_P	☐	Partner Functional Area
50	FIN_AMTTRA	FINACITCRV	FIN_AMTTRA		☐	FIN_AMTTRA	☐	Amount in Transaction Currency
51	FIN_CURRTRA	FINACITCRV	FIN_CURRTRA		☐	FIN_CURRTRA	☐	Transaction Currency
52	FIN_AMTCOMP	FINACITCRV	FIN_AMTCOMP		☐	FIN_AMTCOMP	☐	Amount in Local Currency
53	FIN_CURRCOMP	FINACITCRV	FIN_CURRCOMP		☐	FIN_CURRCOMP	☐	Local Currency
54	FIN_AMTACCSYS	FINACITCRV	FIN_AMTACCSYS		☐	FIN_AMTACCSYS	☐	Amount in Accounting System Currency
55	FIN_CURRACCSYS	FINACITCRV	FIN_CURRACCSYS		☐	FIN_CURRACCSYS	☐	Accounting System Currency
56	FIN_AMTHARD	FINACITCRV	FIN_AMTHARD		☐	FIN_AMTHARD	☐	Amount in Hard Currency
57	FIN_CURRHARD	FINACITCRV	FIN_CURRHARD		☐	FIN_CURRHARD	☐	Hard Currency
58	FIN_AMTINDEX	FINACITCRV	FIN_AMTINDEX		☐	FIN_AMTINDEX	☐	Amount in Index-Based Currency
59	FIN_CURRINDEX	FINACITCRV	FIN_CURRINDEX		☐	FIN_CURRINDEX	☐	Index-Based Currency
60	FIN_AMTCOMPGLOB	FINACITCRV	FIN_AMTCOMPGLOB		☐	FIN_AMTCOMPGLOB	☐	Amount in Global Company Currency
61	FIN_CURRCOMPGLOB	FINACITCRV	FIN_CURRCOMPGLOB		☐	FIN_CURRCOMPGLOB	☐	Global Company Currency
62	FIN_EEW_AMTAMT	FINACITCRV	FIN_EEW_AMTAMT		☐	FIN_EEW_AMT	☐	Extension Include for Additional Currencies
63	FIN_QTYGL	FINACITCRV	FIN_QTYGL		☐	FIN_QTYGL	☐	Quantity in General Ledger
64	FIN_UOMGL	FINACITCRV	FIN_UOMGL		☐	FIN_UOMGL	☐	Unit of Measure for General Ledger
65	FIN_ITEMSIGN	FINACITCRV	FIN_ITEMSIGN		☐	FIN_ITEMSIGN	☐	+/- Sign for a Line Item
66	FIN_POSTYPE	FINACITCRV	FIN_POSTYPE		☐	FIN_POSTYPE	☐	Item Category
67	FIN_JOURNAL	FINACITCRV	FIN_JOURNAL		☐	FIN_JOURNAL	☐	Journal
68	FIN_GLTRATYPE	FINACITCRV	FIN_GLTRATYPE		☐	FIN_GLTRATYPE	☐	Transaction Type for General Ledger
69	FIN_EEW_ACIT	FINACITCRV	FIN_EEW_ACIT		☐	FIN_EEW_ACIT	☐	Extension Point for Item of ACC Document
70	FOBJ_TYPE_NAME	FINACITCRV	FOBJ_TYPE_NAME		☐	FOBJ_TYPE_NAME	☐	Name of an Object Type
71	FOBJ_OBJECT_ID	FINACITCRV	FOBJ_OBJECT_ID		☐	FOBJ_OBJECT_ID	☐	Object ID
72	FOBJ_TYPE_NAME_P	FINACITCRV	FOBJ_TYPE_NAME_P		☐	FOBJ_TYPE_NAME_P	☐	Name of Partner Object Type
73	FOBJ_OBJECT_ID_P	FINACITCRV	FOBJ_OBJECT_ID_P		☐	FOBJ_OBJECT_ID_P	☐	Partner Object ID
74	FIN_COSTCTR	FINACITCRV	FIN_COSTCTR		☐	FIN_COSTCTR	☐	Cost Center
75	FIN_COSTCTR_P	FINACITCRV	FIN_COSTCTR_P		☐	FIN_COSTCTR_P	☐	Partner Cost Center
76	FIN_QTYETR	FINACITCRV	FIN_QTYETR		☐	FIN_QTYETR	☐	Quantity in Unit of Entry
77	FIN_UOMETR	FINACITCRV	FIN_UOMETR		☐	FIN_UOMETR	☐	Unit of Entry
78	FIN_QTYREF	FINACITCRV	FIN_QTYREF		☐	FIN_QTYREF	☐	Quantity in Reference Unit of Measure
79	FIN_UOMREF	FINACITCRV	FIN_UOMREF		☐	FIN_UOMREF	☐	Reference Unit of Measure
80	FIN_QTYVAL	FINACITCRV	FIN_QTYVAL		☐	FIN_QTYVAL	☐	Valuation Quantity
81	FIN_UOMVAL	FINACITCRV	FIN_UOMVAL		☐	FIN_UOMVAL	☐	Valuation Unit of Measure
82	FIN_COMPEL	FINACITCRV	FIN_COMPEL		☐	FIN_COMPEL	☐	Composition Element
83	FIN_CHARGEIND	FINACITCRV	FIN_CHARGEIND		☐	FIN_CHARGEIND	☐	Charge Indicator for Assets Accounts
84	FIN_EEW_ACITCRV	FINACITCRV	FIN_EEW_ACITCRV		☐	FIN_EEW_ACITCRV	☐	Extension Point for LI in COS/Revenue Journal
85	FIN_EEW_ACITCRVR	FINACITCRV	FIN_EEW_ACITCRVR		☐	FIN_EEW_ACITCRVR	☐	Extension Point for Reporting in COS/Revenue Journal

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	400