G/L Accounts: Plan Line Items - SAP Documentation

G/L Accounts: Plan Line Items

Query Query: 0FIGL_M50_Q0001

This query displays specific plan version line items for aggregated or individual posting periods for one or more general ledger accounts.

Structure

Filters
Object Type	Name	Technical Name	Value Restriction / Calculation
Characteristic	InfoProvider	`0INFOPROV`
Characteristic	Access Method	`0ACCESSTP`
Characteristic	Ledger	`0AC_LEDGER`
Characteristic	Fiscal year	`0FISCYEAR`
Characteristic	Posting period	`0FISCPER3`
Characteristic	Fiscal Year Variant	`0FISCVARNT`
Characteristic	Company code	`0COMP_CODE`
Characteristic	Version	`0AC_VERSION`
Characteristic	G/L Account	`0GL_ACCOUNT`
Characteristic	Document Number	`0AC_DOC_NO`
Characteristic	Movement Type	`0MOVE_TYPE`
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`

Free Characteristics
Object Type	Name	Technical Name
Characteristic	Business area	`0BUS_AREA`
Characteristic	Functional area	`0FUNC_AREA`
Characteristic	Logical System	`0PSM_AWSYS`
Characteristic	Movement Type	`0MOVE_TYPE`
Characteristic	Trading partner	`0PCOMPANY`
Characteristic	Send. bus. area	`0PBUS_AREA`
Characteristic	Partner FArea	`0PFUNC_AREA`
Characteristic	Debit/Credit Ind.	`0FI_DBCRIND`
Characteristic	Controlling area	`0CO_AREA`
Characteristic	Business Transaction	`0FI_RACTIV`
Characteristic	Reference Procedure	`0FI_AWTYP`
Characteristic	Cost Element	`0COSTELMNT`
Characteristic	Cost Center	`0COSTCENTER`
Characteristic	Profit Center	`0PROFIT_CTR`
Characteristic	Segment	`0SEGMENT`
Characteristic	Sdr Cost Center	`0SEND_CCTR`
Characteristic	Partner profit ctr	`0PART_PRCTR`
Characteristic	Partner Segment	`0PSEGMENT`
Characteristic	Doc. Number	`0AC_DOC_NO`
Characteristic	Variant (Entry)	`0FISCVRNT_E`
Characteristic	Item	`0ITEM_NUM`
Characteristic	Posting date	`0PSTNG_DATE`
Characteristic	2nd Local Currency	`0LOC_CURRC2`
Characteristic	Posting key	`0POST_KEY`
Characteristic	Document Status	`0AC_DOCSTAT`
Characteristic	Item Category	`0ME_LINETYP`
Characteristic	Doc. Distributn Ind.	`0ME_SPLIT`
Characteristic	Third Local Currency	`0LOC_CURRC3`

Rows
Object Type	Name	Technical Name	Value Restriction / Calculation
Characteristic	Fiscal year	`0FISCYEAR`	—
Characteristic	Document Number (General Ledger View)	`0AC_DOC_NR`	—
Characteristic	Document currency	`0DOC_CURRCY`	—
Characteristic	Ledger	`0AC_LEDGER`	—
Characteristic	Record Type	`0RECTYPE`	—
Characteristic	Version	`0AC_VERSION`	—
Characteristic	G/L Account	`0GL_ACCOUNT`	—
Characteristic	Company code	`0COMP_CODE`	—
Characteristic	Line Item (General Ledger View)	`0AC_DOC_LN`	—
Characteristic	Posting period	`0FISCPER3`	—
Characteristic	Local currency	`0LOC_CURRCY`	—
Characteristic	User Name	`0USERNAME`	—

Columns
Object Type	Name	Technical Name	Value Restriction / Calculation
Key Figure	Amount	`0DEB_CRE_DC`	—
Key Figure	Debit/Credit Amount	`0DEB_CRE_LC`	—
Key Figure	Amt in 3rd LocalCrcy	`0DEB_CRE_L3`	—
Key Figure	Amt in 2nd LocalCrcy	`0DEB_CRE_L2`	—