SAP ABAP Table FAGLPOSX_QUERY (FI-GL Line Item (Query-Structure))

Hierarchy

☛ SAP_FIN (Software Component) SAP_FIN
   ⤷ FI-GL (Application Component) General Ledger Accounting
     ⤷ DECO_FAGL_REPORTING (Package) Reporting Accounting GL

Basic Data

Table Category	INTTAB	Structure
Structure	FAGLPOSX_QUERY	Table Relationship Diagram
Short Description	FI-GL Line Item (Query-Structure)

Delivery and Maintenance

Pool/cluster
Delivery Class
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	NORMAL_ITEM	☐	XNORM_IT	XFELD	CHAR	1	0	Selection: Normal Items
2	LEDGER	☐	FAGL_RLDNR	RLDNR	CHAR	2	0	Ledger in General Ledger Accounting	*
3	KIND_OF_SELECTION	☐	FAGL_LINE_ITEM_SELECTION	FAGL_LINE_ITEM_SELECTION	CHAR	1	0	Defines what kind of line items should be selected
4	KEY_DATE	☐	ALLGSTID	DATUM	DATS	8	0	Open Items at Key Date
5	CLEARING_DATE	☐	AUGDT	DATUM	DATS	8	0	Clearing Date
6	POSTING_DATE	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
7	COMPANY_CODES	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
8	ACCOUNTS	☐	SAKNR	SAKNR	CHAR	10	0	G/L Account Number	*
9	ENTRY_VIEW	☐	BOOLE_D	BOOLE	CHAR	1	0	Data element for domain BOOLE: TRUE (='X') and FALSE (=' ')
10	.INCLUDE	☐				0	0	G/L Account Line Items
11	BELNR	☐	BELNR_D	BELNR	CHAR	10	0	Accounting Document Number
12	GJAHR	☐	GJAHR	GJAHR	NUMC	4	0	Fiscal Year
13	BUDAT	☐	BUDAT	DATUM	DATS	8	0	Posting Date in the Document
14	BLDAT	☐	BLDAT	DATUM	DATS	8	0	Document Date in Document
15	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
16	XBLNR	☐	XBLNR1	XBLNR1	CHAR	16	0	Reference Document Number
17	BLART	☐	BLART	BLART	CHAR	2	0	Document type	T003
18	MONAT	☐	MONAT	MONAT	NUMC	2	0	Fiscal period
19	AUGBL	☐	AUGBL	BELNR	CHAR	10	0	Document Number of the Clearing Document
20	ZUONR	☐	DZUONR	ZUONR	CHAR	18	0	Assignment number
21	BSCHL	☐	BSCHL	BSCHL	CHAR	2	0	Posting Key	TBSL
22	SHKZG	☐	SHKZG	SHKZG	CHAR	1	0	Debit/Credit Indicator
23	MWSKZ	☐	MWSKZ	MWSKZ	CHAR	2	0	Tax on sales/purchases code	T007A
24	DMBTR	☐	DMBTR	WERT7	CURR	13	2	Amount in local currency
25	WRBTR	☐	WRBTR	WERT7	CURR	13	2	Amount in document currency
26	AUFNR	☐	AUFNR	AUFNR	CHAR	12	0	Order Number	AUFK
27	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	T001W
28	VALUT	☐	VALUT	DATUM	DATS	8	0	Fixed Value Date
29	PROJK	☐	PS_PSP_PNR	PS_POSNR	NUMC	8	0	Work Breakdown Structure Element (WBS Element)	PRPS
30	IMKEY	☐	IMKEY	IMKEY	CHAR	8	0	Internal Key for Real Estate Object
31	DABRZ	☐	DABRBEZ	DDAT	DATS	8	0	Reference date for settlement

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	FAGLPOSX_QUERY	AUFNR	AUFK	AUFNR	REF	C	CN
2	FAGLPOSX_QUERY	BLART	T003	BLART
3	FAGLPOSX_QUERY	BSCHL	TBSL	BSCHL
4	FAGLPOSX_QUERY	MWSKZ	T007A	MWSKZ	REF	C	CN
5	FAGLPOSX_QUERY	PROJK	PRPS	PSPNR	REF	C	CN
6	FAGLPOSX_QUERY	WAERS	TCURC	WAERS
7	FAGLPOSX_QUERY	WERKS	T001W	WERKS

History

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