Kontakt

Ansicht
Dokumentation

J_1GTBDE0 - Customer Trial Balance

J_1GTBDE0 - Customer Trial Balance

ROGBILLS - Synchronize billing plans   TXBHW - Original Tax Base Amount in Local Currency  
This documentation is copyright by SAP AG.
SAP E-Book

Description

This program outputs balances for customers.

If show line items is selected every customer is analyzed by Reconciliation account and G/L indicator.
A second part of output is also displayed with the Reconciliation account balances as formed in the 1st part of output.

Output

For each Reconciliation account we have several balances:

-- Previous Year Balance C/F
It is either Debit or Credit exclusively, i.e one of the two must be zero. It can be be shown in 2 columns ( DEBIT/CREDIT ) or in one column with a sign. This balance can be also excluded by checking off the select option Include previous year balance

-- Previous Periods
Shown in two columns ( DEBIT/CREDIT ) and are the balances within the same fiscal year but before the period selected by the user for analysis. ( The total DEBITS and CREDITS of this period ).

-- Current Periods
Shown in two columns ( DEBIT/CREDIT ) and are the balances for the period selected by the user for analysis. ( The total DEBITS and CREDITS of the period ).

-- Totals
Are the sums in DEBIT/CREDIT of Previous year + Previous periods + Current periods. The user can also select not to include Previous year in the sum. ( Select option : Add previous year to total ).

-- Balance
Is the Sum of all the above where Debits are + and Credits are -. Therefore it is either a Debit(+) or Credit(-). User can also select to have the balance in two columns (DEBIT/CREDIT) or in one column.

Selection

  • Official TB layout:
    List column layout matches the Official GL Trial Balance layout.

Requirements

Note: The program determines the GL account based on customer's master data and not on transactions, except an SPL is used.

Standard Ledger & Extended Ledger (SPL)
The program reads from table KNC1 ( Standard Ledger ) for "normal" transcation period sums. If there is a need to read period sums for special GL transactions, these must be read from a suitable extended ledger (or special purpose ledger - SPL).

  • A suitable SPL must have a "key" (object table) comprising at least the following fields: Company code (RBUKRS) - GL Account (RACCT) - Account type (RZZKOART) - Vendor number (RZZLIFNR) - Customer number (RZZKUNNR) - Special GL Indicator (RZZUMSKZ).
  • The SPL must store both normal & special GL transaction sums.
  • There is no need for the SPL to store line items.
  • The SPL can also use another Fisal Year Variant (but in case of posting date selections, the SPL's FYV must coincide chronologically with the Company's FYV).
  • The SPL's summary table, must have at least all the fields of program's internal data type SPL_TYPE (see include J_1GSPLEDGER).
    If 2nd currency is used, the program assumes that it is stored in SPL's KSL field group.
    If such a ledger exists, it is also advisable to use it everytime, The reason being that when reading from KNC1 we determine the reconciliation account for the customer based on its master file, which can lead to errors if a customer has changed reconciliation account in the interim ( not advisable to do such anyways , but... ).

Performance issues
In case you need to use the "Posting date" select option, a non unique index on BSID/BSAD for fields: MANDT - BUKRS - KUNNR - BUDAT, will make things faster.






SUBST_MERGE_LIST - merge external lists to one complete list with #if... logic for R3up   Fill RESBD Structure from EBP Component Structure  
This documentation is copyright by SAP AG.

Length: 3721 Date: 20240531 Time: 215333     sap01-206 ( 45 ms )