SAP GXL

Use the GXL formula to retrieve account balances for a specific format/reporting period. The following is an overview for the GXL formula for SAP ledgers:

Syntax

=GXL("Ledger","Currency Type","Key 3","Year","Format","Period","Account Segment 1","Account Segment 2","Account Segment 3","Account Segment 4","Account Segment 5"...)

Note: It is common practice to use cell references within GXL formulas to identify parameters.

Parameters

The following are GXL formula parameters for SAP ledgers:

Ledger

Identifies the specific ledger in SAP. Valid values are:

• FI
• CO
• COOR
• PCA
• Special SAP ledgers

Currency Type

Identifies the currency type.

Key 3

Optionally, identifies host configuration criteria. Enter the necessary literal and a value as defined below:

• If more than one variable needs to be defined, separate the variables with a semi-colon ( ; ). Enter 0 or leave blank if not used.
• "CONFIGURATION=X": where X is either the full configuration name or only the number. If left blank, the system uses the default configuration as defined in Application Configurator.

Year

Year identifier.

Format

Format options are:

• PER: the activity of the selected period.
• QTR: the activity for the periods provided in the selected quarter number.
• DQTR: the activity for the periods provided in the selected daily quarter number.
• YTD: the activity for periods 1 through the designated period number, excluding the opening balance.
• LTD: the activity for periods 1 through the designated period number, including the opening balance.

Note: Not applicable to CO, COOR, and various special ledgers.

• RANGE: the activity for the range of specified periods.

Period

Corresponds to period, quarter number, or range of periods (for example, 1.5 for periods 1 through 5) for the specified format.

Account Segment 1-nn

Enter one parameter for each segment in the account string. The number of account segments vary based on the account structure for the selected ledger. May be a single value, mask, range, value list, segment list, hierarchy value, or @ field (see Account Segment Syntax for more information).

• Type: valid values are 0 (Actual) and 1 (Plan)
• Plan Version: use 000 if actual results are desired

Formula Example: Using a Value List, Range, and Mask (FI Ledger)

=GXL("FI","TRANS","CONFIGURATION=SAP 1 - Prod","1999","PER","1","0","1000","000","DEM","[1000,2000]","800000.859999","*")

Retrieves the actual balance for period 1 of 1999, for companies 1000 and 2000, accounts in the range of 800000 through 859999, and all business areas.

Formula Example: Using Single Values (CO Ledger)

=GXL("CO","TRANS","CONFIGURATION=SAP 1 - Prod","1999","PER","1","INT","000","DEM","01","1000","2000","435000","100")

Retrieves the actual balance for period 1 of 1999, for controlling area 1000, cost center 2000, cost element 435000, and activity 100.

Formula Example: Using Single Values (COOR Ledger)

=GXL("COOR","TRANS","CONFIGURATION=1","2003","PER","2","1000","000","USD","01","1000","000000100000","0000000802")

Retrieves the actual balance for period 2 of 2003, for controlling area 1000, order number 000000100000, and cost element 0000000802.

Formula Example: Using a Value List, Masks and a Range (PCA Ledger)

=GXL("PCA","TRANS","CONFIGURATION=1","2007","PER","1","0","1000","000","DEM","2000","9999","100","1000","800000")

Retrieves the actual balance for period 1 of 2007, for company 2000, profit centers 5000 and 9999, all function areas, range of controlling areas from 1000 through 2500, and accounts that begin with 80.

See Control Panel, GL Reporting, Create or Maintain GL Formulas, and GXL Formula for Account Values for more information.