SAP ABAP Table FAGL_BW_LOG_ITEM (FI-GL: Log for BW Extraction: Line Items)

Hierarchy

☛ SAP_FIN (Software Component) SAP_FIN
   ⤷ FI-GL (Application Component) General Ledger Accounting
     ⤷ GBIW_ERP (Package) Extractors for General Ledger in ERP

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	FAGL_BW_LOG_ITEM	Table Relationship Diagram
Short Description	FI-GL: Log for BW Extraction: Line Items

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	*
2	DATASOURCE	☑	RSISOURCE	RSISOURCE	CHAR	30	0	InfoSource
3	REQUNR	☑	RSREQUNR	RSREQUNR	CHAR	30	0	Request number for the data transfer
4	LOGTIMESTAMP	☑	TIMESTAMP	TZNTSTMPS	DEC	15	0	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
5	RECNR	☑	GU_RECID	OBJNR	CHAR	18	0	Record number of the line item record
6	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
7	GJAHR	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
8	BELNR	☐	BELNR_BIW	BELNR	CHAR	10	0	Accounting Document Number
9	BUZEI	☐	BUZEI	BUZEI	NUMC	3	0	Number of Line Item Within Accounting Document
10	RLDNR	☐	RLDNR	RLDNR	CHAR	2	0	Ledger	*
11	LDGRP	☐	FAGL_LDGRP	FAGL_LDGRP	CHAR	4	0	Ledger Group	*
12	DOCNR	☐	DOCNR	BELNR	CHAR	10	0	Doc. Number
13	DOCLN	☐	DOCLN6_POS	DOCLN6	CHAR	6	0	Six-Character Posting Item for Ledger
14	MONAT	☐	MONAT	MONAT	NUMC	2	0	Fiscal period
15	FISCPER	☐	RSFISCPER	RSFISCPER	NUMC	7	0	Fiscal year / period
16	AUGBL	☐	AUGBL	BELNR	CHAR	10	0	Document Number of the Clearing Document
17	AUGDT	☐	AUGDT	DATUM	DATS	8	0	Clearing Date
18	BLART	☐	BLART	BLART	CHAR	2	0	Document type	*
19	BLDAT	☐	BLDAT	DATUM	DATS	8	0	Document Date in Document
20	BSCHL	☐	BSCHL	BSCHL	CHAR	2	0	Posting Key	*
21	BSTAT	☐	BSTAT_D	BSTAT	CHAR	1	0	Document Status
22	BUDAT	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
23	HKONT	☐	HKONT	SAKNR	CHAR	10	0	General Ledger Account	*
24	KOSTL	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	*
25	PRCTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	*
26	SEGMENT	☐	FB_SEGMENT	FB_SEGMENT	CHAR	10	0	Segment for Segmental Reporting	*
27	GSBER	☐	GSBER	GSBER	CHAR	4	0	Business Area	*
28	SHKZG	☐	SHKZG	SHKZG	CHAR	1	0	Debit/Credit Indicator
29	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	*
30	WRBTR	☐	WRBTR	WERT7	CURR	13	2	Amount in document currency
31	CURT2	☐	CURT2	CURTP	CHAR	2	0	Currency Type of Second Local Currency
32	CURT3	☐	CURT3	CURTP	CHAR	2	0	Currency Type of Third Local Currency
33	DMSHB	☐	DMSHB	WRTV7	CURR	13	2	Amount in Local Currency with +/- Signs
34	HWAER	☐	HWAER	WAERS	CUKY	5	0	Local Currency	*
35	DMBTR	☐	DMBTR	WERT7	CURR	13	2	Amount in local currency
36	DMBE2	☐	DMBE2	WERT7	CURR	13	2	Amount in Second Local Currency
37	HWAE2	☐	HWAE2	WAERS	CUKY	5	0	Currency Key of Second Local Currency	*
38	DMBE3	☐	DMBE3	WERT7	CURR	13	2	Amount in Third Local Currency
39	HWAE3	☐	HWAE3	WAERS	CUKY	5	0	Currency Key of Third Local Currency	*
40	DMHAB	☐	DMHAB	WERT7	CURR	13	2	Credit Amount in Local Currency
41	DMHA2	☐	DMHA2	WERT7	CURR	13	2	Credit Amount in Second Local Currency
42	DMHA3	☐	DMHA3	WERT7	CURR	13	2	Credit Amount in Third Local Currency
43	DMSOL	☐	DMSOL	WERT7	CURR	13	2	Debit Amount in Local Currency
44	DMSO2	☐	DMSO2	WERT7	CURR	13	2	Debit Amount in Second Local Currency
45	DMSO3	☐	DMSO3	WERT7	CURR	13	2	Debit Amount in Third Local Currency
46	DMSH2	☐	DMSH2	WRTV7	CURR	13	2	Amount in Second Local Currency with +/- Sign
47	DMSH3	☐	DMSH3	WRTV7	CURR	13	2	Amount in Third Local Currency with +/- Sign
48	WRHAB	☐	WRHAB	WERT7	CURR	13	2	Credit Amount in Document Currency
49	WRSOL	☐	WRSOL	WERT7	CURR	13	2	Debit Amount in Document Currency
50	RBUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
51	RACCT	☐	RACCT	SAKNR	CHAR	10	0	Account Number	*
52	RCNTR	☐	KOSTL	KOSTL	CHAR	10	0	Cost Center	*
53	RPRCTR	☐	RPRCTR	PRCTR	CHAR	10	0	Receiver profit center	*
54	QUANUNIT	☐	ROUNIT	MEINS	UNIT	3	0	Unit of Measure	*
55	VALUETYPE	☐	RSVTYPE	RSVTYPE	NUMC	3	0	Value type for Reporting	*
56	CURTYPE	☐	RSCURTYPE	RSCURTYPE	CHAR	2	0	Currency type
57	FISCVAR	☐	RSFISCVAR	RSFISCVAR	CHAR	2	0	Fiscal year variant
58	CHARTACCTS	☐	KTOPL	KTOPL	CHAR	4	0	Chart of Accounts	*
59	UPMOD	☐	RODMUPDMOD	RODMUPDMOD	CHAR	1	0	BW Delta Process: Record Mode
60	VALUTYP	☐	VALUTYP	VALUTYP	NUMC	1	0	Valuation View
61	CURRUNIT	☐	RSCURRENCY	WAERS	CUKY	5	0	Currency Key	*
62	BALANCE	☐	RR_KUMSL	WERTV9	CURR	17	2	Accumulated balance
63	DEBIT	☐	RR_UMSOL	WERTV9	CURR	17	2	Total debit postings
64	CREDIT	☐	RR_UMHAB	WERTV9	CURR	17	2	Total credit postings
65	TURNOVER	☐	RR_SALES	WERTV9	CURR	17	2	Sales of the period
66	QUANTITY	☐	SMEGR9	MENGV9	QUAN	17	3	Consumption Quantity

History

Last changed by/on	SAP	20130529
SAP Release Created in	606