SAP ABAP View FIN_V_ACGEN (View: Line Items in General 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_ACGEN
Short Description	View: Line Items in General Journal
Root table	FINACHD	Accounting Document Header

Table

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

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	FINACITGEN	CLIENT	JR	EQ			AND	0	0
3	FINACHD	FIN_TECHDOCNO	JL	EQ				0	0
4	FINACITGEN	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	FINACITGEN	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	FINACITGEN	FIN_GLITEMNO		☐	FIN_GLITEMNO	☐	Item Number of General Ledger Document
40	FIN_DRCRIND	FINACITGEN	FIN_DRCRIND		☐	FIN_DRCRIND	☐	Debit/Credit Indicator
41	FIN_GLACCT	FINACITGEN	FIN_GLACCT		☐	FIN_GLACCT	☐	G/L Account
42	FIN_GLIND	FINACITGEN	FIN_GLIND		☐	FIN_GLIND	☐	Relevant for General Ledger
43	FIN_ITEMTEXT	FINACITGEN	FIN_ITEMTEXT		☐	FIN_ITEMTEXT	☐	Document Item Text
44	FIN_SEGMENT	FINACITGEN	FIN_SEGMENT		☐	FIN_SEGMENT	☐	Segment
45	FIN_PROFITCTR	FINACITGEN	FIN_PROFITCTR		☐	FIN_PROFITCTR	☐	Profit Center
46	FIN_FUNCAREA	FINACITGEN	FIN_FUNCAREA		☐	FIN_FUNCAREA	☐	Functional Area
47	FIN_SEGMENT_P	FINACITGEN	FIN_SEGMENT_P		☐	FIN_SEGMENT_P	☐	Partner Segment
48	FIN_PROFITCTR_P	FINACITGEN	FIN_PROFITCTR_P		☐	FIN_PROFITCTR_P	☐	Partner Profit Center
49	FIN_FUNCAREA_P	FINACITGEN	FIN_FUNCAREA_P		☐	FIN_FUNCAREA_P	☐	Partner Functional Area
50	FIN_AMTTRA	FINACITGEN	FIN_AMTTRA		☐	FIN_AMTTRA	☐	Amount in Transaction Currency
51	FIN_CURRTRA	FINACITGEN	FIN_CURRTRA		☐	FIN_CURRTRA	☐	Transaction Currency
52	FIN_AMTCOMP	FINACITGEN	FIN_AMTCOMP		☐	FIN_AMTCOMP	☐	Amount in Local Currency
53	FIN_CURRCOMP	FINACITGEN	FIN_CURRCOMP		☐	FIN_CURRCOMP	☐	Local Currency
54	FIN_AMTACCSYS	FINACITGEN	FIN_AMTACCSYS		☐	FIN_AMTACCSYS	☐	Amount in Accounting System Currency
55	FIN_CURRACCSYS	FINACITGEN	FIN_CURRACCSYS		☐	FIN_CURRACCSYS	☐	Accounting System Currency
56	FIN_AMTHARD	FINACITGEN	FIN_AMTHARD		☐	FIN_AMTHARD	☐	Amount in Hard Currency
57	FIN_CURRHARD	FINACITGEN	FIN_CURRHARD		☐	FIN_CURRHARD	☐	Hard Currency
58	FIN_AMTINDEX	FINACITGEN	FIN_AMTINDEX		☐	FIN_AMTINDEX	☐	Amount in Index-Based Currency
59	FIN_CURRINDEX	FINACITGEN	FIN_CURRINDEX		☐	FIN_CURRINDEX	☐	Index-Based Currency
60	FIN_AMTCOMPGLOB	FINACITGEN	FIN_AMTCOMPGLOB		☐	FIN_AMTCOMPGLOB	☐	Amount in Global Company Currency
61	FIN_CURRCOMPGLOB	FINACITGEN	FIN_CURRCOMPGLOB		☐	FIN_CURRCOMPGLOB	☐	Global Company Currency
62	FIN_EEW_AMTAMT	FINACITGEN	FIN_EEW_AMTAMT		☐	FIN_EEW_AMT	☐	Extension Include for Additional Currencies
63	FIN_QTYGL	FINACITGEN	FIN_QTYGL		☐	FIN_QTYGL	☐	Quantity in General Ledger
64	FIN_UOMGL	FINACITGEN	FIN_UOMGL		☐	FIN_UOMGL	☐	Unit of Measure for General Ledger
65	FIN_ITEMSIGN	FINACITGEN	FIN_ITEMSIGN		☐	FIN_ITEMSIGN	☐	+/- Sign for a Line Item
66	FIN_POSTYPE	FINACITGEN	FIN_POSTYPE		☐	FIN_POSTYPE	☐	Item Category
67	FIN_JOURNAL	FINACITGEN	FIN_JOURNAL		☐	FIN_JOURNAL	☐	Journal
68	FIN_GLTRATYPE	FINACITGEN	FIN_GLTRATYPE		☐	FIN_GLTRATYPE	☐	Transaction Type for General Ledger
69	FIN_EEW_ACIT	FINACITGEN	FIN_EEW_ACIT		☐	FIN_EEW_ACIT	☐	Extension Point for Item of ACC Document
70	FIN_EEW_ACITGEN	FINACITGEN	FIN_EEW_ACITGEN		☐	FIN_EEW_ACITGEN	☐	Extension Point for LI in General Journal
71	FIN_EEW_ACITGENR	FINACITGEN	FIN_EEW_ACITGENR		☐	FIN_EEW_ACITGENR	☐	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