SAP GXD

For SAP ledgers, the GXD formula is used to retrieve the description of a single account segment (for example, account, cost center, internal order, or profit center).

Syntax

=GXD("Descriptions","Parm 1","Parm 2","Parm 3")

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

Parameters

The following are GXD formula parameters for SAP ledgers:

Descriptions

Identifies the segment type for which to retrieve a description. Valid values are:

• Account (ACCOUNT)
• Cost Center (CC)
• Internal Order (IO)
• Profit Center (PC)

Parm 1

• If the description is Account (ACCOUNT), identifies the chart of accounts.
• If the description is Cost Center (CC) or Profit Center (PC), identifies the controlling area.
• If the description is Internal Order (IO), leave the field blank.

Parm 2

Identifies the value of the account, cost center, order number, or profit center for which to retrieve the description.

Parm 3

Optionally, identifies the host configuration from which to retrieve the description. May specify either the full configuration name or only the number. If left blank, the system uses the default configuration as defined in Application Configurator.

Formula Example: Retrieve an Account Description

=GXD("ACCOUNT","INT","430000","SAP 1 - Prod")

Retrieves the description of account 430000, from the INT chart of accounts.

Formula Example: Retrieve a Cost Center Description

=GXD("CC","1000","1200","SAP 1 - Prod")

Retrieves the description of cost center 1200, from the 1000 controlling area.

Formula Example: Retrieve an Internal Order Description

=GXD("IO",,"702267","SAP 1 - Prod"

Retrieves the description of internal order 702267.

Formula Example: Retrieve a Profit Center Description:

=GXD("PC","1000","1010","SAP 1 - Prod")

Retrieves the description for profit center 1010, from the 1000 controlling area.

See GL Reporting and Create or Maintain GL Formulas for more information.