Hierarchy
BBPCRM (Software Component) BBPCRM⤷
CRM-MD-PCT (Application Component) Product Catalog⤷
FF (Package) Cash Management
Basic Data
| Data Element | GLIED |
| Short Description | Grouping |
Data Type
| Category of Dictionary Type | D | Domain |
| Type of Object Referenced | No Information | |
| Domain / Name of Reference Type | GLIED | |
| Data Type | CHAR | Character String |
| Length | 10 | |
| Decimal Places | 0 | |
| Output Length | 10 | |
| Value Table | T038P |
Further Characteristics
| Search Help: Name | ||
| Search Help: Parameters | ||
| Parameter ID | FGL | |
| Default Component name | GROUPING | |
| Change document | ||
| No Input History | ||
| Basic direction is set to LTR | ||
| No BIDI Filtering |
Field Label
| Length | Field Label | |
| Short | 10 | Grouping |
| Medium | 15 | Grouping |
| Long | 20 | Grouping |
| Heading | 10 | Grouping |
Documentation
Definition
The grouping specifies which levels and accounts, or planning groups, the system should select for the cash position, the liquidity forecast, and cash concentration.
Using the grouping, you can also specify how the system should summarize data on the first screen in the cash position or the liquidity forecast.
All planning levels to be included are entered in lines for type "E", and all accounts, or planning groups, are entered in lines for type "G". You can mask your entries with "+" (from the right). If you do not specify a summarization term, the system displays the level and the account, or planning group, separately. Otherwise, the system displays the first screen according to the summarization term, and then you can break down the display according to levels or groups by selecting the lines. It is possible to exclude certain levels or groups.
In the following examples for groupings, the G/L account numbers are ten characters long and the planning groups two characters. You have to enter your account numbers with leading zeros.
Example 1: "ACCOUNTS"
You want to list all G/L accounts individually, and display all levels as a total. You define this display by entering:
Grouping Cat. Selection Exclud. SummznCode
ACCOUNTS E ++ **
ACCOUNTS G ++++++++++
Example 2: "DREBA"
Here you want to see the activity of certain G/L accounts (113200 to 113208) as a total. You want to include all levels.
Grouping Cat. Selection Exclud. SummznCode
DREBA E ++ **
DREBA G 000011320+ DRESDNER
DREBA G 0000113209 X
Example 3: "CURRENCY"
You want to display the accounts according to account currency, and include only "F" levels (levels used during posting):
Grouping Cat. Selection Exclud. SummznCode
CURRENCY E F+ **
CURRENCY G 0000113150 USD
CURRENCY G 0000113160 JPY
CURRENCY G 00001131++ EUR
CURRENCY G 0000113250 USD
CURRENCY G 0000113260 JPY
CURRENCY G 00001132++ EUR
Example 4: "LEVELS"
You want to list all accounts according to planning levels:
Grouping Cat. Selection Exclud. SummznCode
LEVELS E ++
LEVELS E T+ X
LEVELS G ++++++++++ **
LEVELS G 0000113998 X
LEVELS G 0000113999 X
Example 5: "SUBLEDGER"
You want to display customer and vendor planning groups, and compare them with the customer clearing accounts:
Grouping Cat. Selection Exclud. SummznCode
SUBLEDGER E ++ **
SUBLEDGER G E+ RECEIPTS
SUBLEDGER G A+ DISBURSE
SUBLEDGER G 0000113109 CLEARING
SUBLEDGER G 0000113209 CLEARING
Example 6: "TOTAL"
You want to display all accounts and all planning groups:
Grouping Cat. Selection Exclud. SummznCode
TOTAL E ++ **
TOTAL G ++ SUBLEDGER
TOTAL G ++++++++++ BANKS
When you select a line in the cash position or liquidity forecast, the system displays the individual components (levels/accounts/planning groups) that make up that line. Accounts are displayed with the cash management account name.
When masking, you have to use the proper field length. For example, the planning group "E1" can be masked with "E+" or "++", but not with "E++" or "+++". Therefore you must assign the same length to all planning groups. However, it can be useful to store the account number as a planning group when you have major customers or suppliers. When setting up the groupings, you can do this as follows :
Example 7: "TOTAL2"
Grouping Cat. Selection Exclud. SummznCode
TOTAL2 E ++ **
TOTAL2 G A+ VENDOR
TOTAL2 G A+++++++++ VENDOR
TOTAL2 G E+ CUST
TOTAL2 G E+++++++++ CUST
TOTAL2 G ++++++++++ BANKS
You can specify more than one grouping in the cash position and liquidity forecast.
Example 8: "BANK1"
Grouping Cat. Selection Exclud. SummznCode
BANK1 E AB **
BANK1 G 0000113100 DEUTSCHE
Example 9: "BANK2"
Grouping Cat. Selection Exclud. SummznCode
BANK2 E AU **
BANK2 G 0000113200 DRESDNER
If you enter "BANK1" and "BANK2" for the grouping, account 0000113100 takes account of level AB only and account 0000113200 takes account of level AU only. That is, if you enter more than one grouping, data selection takes account only of the records which are selected by at least one of the groupings in question.
In the case of grouping entries which affect accounts or planning groups, you can enter a company code and chart of accounts if you wish. The entry can be masked. For more information, see the online help for the "Selection" field in the grouping maintenance view (view V_T038).
History
| Last changed by/on | SAP | 20110901 |
| SAP Release Created in |
