Define Table Groups in Special Purpose Ledger 

Use

Before you can create a new ledger in the special purpose ledgers, you must define table groups. The summary, actual line item, plan line item, and object tables are created automatically when you carry out this configuration step. You can define your requirements in each table created. You must also add the customer-specific fields configured in the customer coding block for postings to the special purpose ledgers. This section describes how to configure the table group for use with the document splitting functions in the special purpose ledgers.

Prerequisites

Before you create table groups, you must make the following configuration settings:

...

       1.      All customer fields must be created in the ABAP Dictionary together with the corresponding data elements and domains.

       2.      You must add your customer fields to the structure CI_COBL.

Procedure

Navigation

IMG path	Transaction code
Financial Accounting ® Special Purpose Ledger ® Basic Settings ® Tables ® Definition ® Define Table Group	GCIN

To create table groups, please proceed as follows:

...

       1.      Enter the name of the table group ‘ZBYTITLE’. You can use a different name if you wish, but all user-defined tables must begin with a ‘Z’.

       2.      Choose Create in the Processing Type subscreen.

       3.      Choose the indicator Local table group (company codes).

       4.      Enter the field ZZTITLE01 (Title Level 1) and the data element CRMT_IPM_TITLE01_CO on the Object Table 1 tab.

       5.      Enter the field ZZTITLE02 (Title Level 2) and the data element CRMT_IPM_TITLE02_CO on the Object Table 1 tab.

       6.      Enter the field ZZTITLE03 (Title Level 3) and the data element CRMT_IPM_TITLE03_CO on the Object Table 1 tab.

       7.      Enter the field ZZMARKET (Market) and the data element CRMT_IPM_MARKET_CO on the Object Table 1 tab.

       8.      Enter the field ZZTERRI (Territory) and the data element CRMT_IPM_TERRI_CO on the Object Table 1 tab.

       9.      Enter the field ZZLANGU (Language) and the data element CRMT_IPM_LANGU_CO on the Object Table 1 tab.

   10.      Enter the field ZZBUSTYP (Object Type) and the data element SWO_OBJTYP on the Object Table 1 tab.

   11.      Enter the field ZZORDERNR (Sales Order Number) and the data element KDAUF on the Object Table 1 tab.

   12.      Enter the field ZZLINEITEM (Item Number) and the data element KDPOS on the Object Table 1 tab.

   13.      If you also use other attributes, add these also. For example, to add the attribute Format, enter the field ZZFORMAT (Format) and the data element ZZFORMAT on the Object Table 1 tab.

   14.      The fields RZZTITLE01, RZZTITLE02, RZZTITLE03, RZZMARKET, RZZTERRI, RZZLANGU, RZZBUSTYP, RZZORDERNR, RZZLINEITEM, and, if applicable, RZZFORMAT are entered automatically on the Summary Table, Actual Line Item Table, and Plan Line Item Table tabs.

   15.      You do not need to make specific configuration settings on the Object Table 2, Actual Line Item Table, and Plan Line Item Table tabs.

   16.      Install the table group in the follow-on functions.

If you use a release lower than SAP R/3 Enterprise, please see note 396621.

 

Result

...

       1.      The installation log should indicate that the table was installed successfully.

       2.      The tables ZBYTITLET, ZBYTITLEA, and ZBYTITLEP should be listed in the FI-SL table directory (transaction GCI3).

       3.      The tables are available for use in the split ledger.