G/L Accounts: Line Items

Query Query: 0FIGL_M40_Q0001

This query lists open, cleared, or all line items for one or more general ledger accounts, together with account assignments and ledger-specific document data.

Structure

Filters
Object Type	Name	Technical Name
Characteristic	InfoProvider	`0INFOPROV`
Characteristic	Access Method	`0ACCESSTP`
Characteristic	G/L Account	`0GL_ACCOUNT`
Characteristic	Company code	`0COMP_CODE`
Characteristic	Clearing Status of Line Item	`0GL_CLRSTAT`
Characteristic	Clearing	`0CLEAR_DATE`
Characteristic	Posting date	`0PSTNG_DATE`
Characteristic	Ledger	`0AC_LEDGER`
Characteristic	Document Status (for Selection)	`0GL_DOCSTAT`
Characteristic	Accounting Document Number	`0AC_DOC_NR`
Characteristic	Fiscal Year Variant	`0FISCVARNT`
Characteristic	Fiscal year	`0FISCYEAR`
Characteristic	Posting period	`0FISCPER3`
Characteristic	Line Item (General Ledger View)	`0AC_DOC_LN`
Characteristic	Movement Type	`0MOVE_TYPE`
Characteristic	Cost Element	`0COSTELMNT`
Characteristic	Cost Center	`0COSTCENTER`
Characteristic	Profit Center	`0PROFIT_CTR`
Characteristic	Functional area	`0FUNC_AREA`
Characteristic	Business area	`0BUS_AREA`
Characteristic	Controlling area	`0CO_AREA`
Characteristic	Segment	`0SEGMENT`
Characteristic	Sdr Cost Center	`0SEND_CCTR`
Characteristic	Partner profit ctr	`0PART_PRCTR`
Characteristic	Partner FArea	`0PFUNC_AREA`
Characteristic	Send. bus. area	`0PBUS_AREA`
Characteristic	Trading partner	`0PCOMPANY`
Characteristic	Partner Segment	`0PSEGMENT`

Free Characteristics
Object Type	Name	Technical Name
Characteristic	Ledger	`0AC_LEDGER`
Characteristic	Attachment	`0ASSET_MAIN`
Characteristic	Sub-number	`0ASSET`
Characteristic	Order	`0COORDER`
Characteristic	Clearing	`0CLEAR_DATE`
Characteristic	Document Status	`0AC_DOCSTAT`
Characteristic	Posting date	`0PSTNG_DATE`
Characteristic	Item	`0ITEM_NUM`
Characteristic	2nd Local Currency	`0LOC_CURRC2`
Characteristic	Third Local Currency	`0LOC_CURRC3`
Characteristic	Purchasing document	`0OI_EBELN`
Characteristic	Item	`0OI_EBELP`
Characteristic	Net due date	`0NETDUEDATE`
Characteristic	Branch	`0FI_SUBSID`
Characteristic	Fiscal year/period	`0FISCPER`
Characteristic	Account type	`0ACCT_TYPE`
Characteristic	Cost Center	`0COSTCENTER`
Characteristic	Dunning area	`0DUNN_AREA`
Characteristic	Last dunned	`0LAST_DUNN`
Characteristic	Dunning block	`0DUNN_BLOCK`
Characteristic	Dunning level	`0DUNN_LEVEL`
Characteristic	Posting period	`0FISCPER3`
Characteristic	Dunning key	`0DUNN_KEY`
Characteristic	Item	`0S_ORD_ITEM`
Characteristic	Document Number of Invoice to which Transaction Relates	`0ACDOCNO_IR`
Characteristic	Sp.G/L Trans.Type	`0SP_GL_TT`
Characteristic	Spec. G/L indicator	`0SP_GL_IND`
Characteristic	Pmnt meth.supplement	`0PMTMTHSUPL`
Characteristic	Value Date	`0VALUE_DATE`
Characteristic	Sales document	`0DOC_NUMBER`
Characteristic	Billing document	`0BILL_NUM`
Characteristic	Flow Type	`0FS_FLW_TP`
Characteristic	Contract Number	`0FS_CTR_NO`
Characteristic	Contract Type	`0FS_CTR_TP`
Characteristic	Plant	`0PLANT`
Characteristic	Document currency	`0DOC_CURRCY`
Characteristic	Type of Bill of Exchange Usage	`0BILLEXCHUS`
Characteristic	Reference	`0REF_DOC_NO`
Characteristic	Cash discount 1	`0DSCT_DATE1`
Characteristic	Base Date	`0BLINE_DATE`
Characteristic	Payment block	`0PMNT_BLOCK`
Characteristic	Payment terms	`0PMNTTRMS`
Characteristic	Reference Key 1	`0REF_KEY1`
Characteristic	Reference Key 2	`0REF_KEY2`
Characteristic	Reason code	`0REASON_CDE`
Characteristic	Credit Control Area	`0C_CTR_AREA`
Characteristic	Reference Key 3	`0REF_KEY3`
Characteristic	WBS element (ext.)	`0WBS_ELM_EX`
Characteristic	Payment Reference	`0AB_KIDNO`
Characteristic	Business Place	`0ID_BUPLA`
Characteristic	Reference Doc:FY	`0CLR_DOC_FY`
Characteristic	Clearing was reset	`0CLEAR_REV`
Characteristic	Accounts Receivable Pledging Indicator	`0CESSION`
Characteristic	Logical System	`0PSM_AWSYS`
Characteristic	Reference Procedure	`0FI_AWTYP`
Characteristic	Movement Type	`0MOVE_TYPE`
Characteristic	Accounting Document Number	`0AC_DOC_NR`
Characteristic	Line Item (General Ledger View)	`0AC_DOC_LN`
Characteristic	Functional area	`0FUNC_AREA`
Characteristic	Business Transaction	`0FI_RACTIV`
Characteristic	Controlling area	`0CO_AREA`
Characteristic	Cost Element	`0COSTELMNT`
Characteristic	Customer	`0DEBITOR`
Characteristic	Vendor	`0CREDITOR`
Characteristic	Unit of Measure	`0UNIT`
Characteristic	Send. bus. area	`0PBUS_AREA`
Characteristic	Partner FArea	`0PFUNC_AREA`
Characteristic	Partner profit ctr	`0PART_PRCTR`
Characteristic	Sdr Cost Center	`0SEND_CCTR`
Characteristic	Partner Segment	`0PSEGMENT`
Characteristic	Ledger Group	`0GL_LDGRP`
Characteristic	Ledger Group-Specific Clearing	`0GL_LGCLR`
Characteristic	Reference Key	`0PSM_AWKEY`
Characteristic	Created on	`0CREATEDON`

Rows
Object Type	Name	Technical Name	Value Restriction / Calculation
Characteristic	G/L Account	`0GL_ACCOUNT`	—
Characteristic	Company code	`0COMP_CODE`	—
Characteristic	Clearing Status	`0GL_CLRSTAT`	—
Characteristic	Allocation Number	`0ALLOC_NMBR`	—
Characteristic	Doc.number	`0AC_DOC_NO`	—
Characteristic	Business area	`0BUS_AREA`	—
Characteristic	Document type	`0AC_DOC_TYP`	—
Characteristic	Document Date	`0DOC_DATE`	—
Characteristic	Posting key	`0POST_KEY`	—
Characteristic	Local currency	`0LOC_CURRCY`	—
Characteristic	Tax Code	`0IS_TXCOD`	—
Characteristic	Clearing Doc.Number	`0CLR_DOC_NO`	—
Characteristic	Profit Center	`0PROFIT_CTR`	—
Characteristic	Segment	`0SEGMENT`	—
Characteristic	Item Text	`0POSTXT`	—

Columns
Object Type	Name	Technical Name	Value Restriction / Calculation
Key Figure	Debit/Credit Amount	`0DEB_CRE_LC`

Report/Report Interfaces
Name	Technical Name
Display Line Item (Transaction)	`FB09D`