Sapass

 Simplify SAP R/3 development with Excel VBA/VB RFC  
Home> Bapi>GeneralLedger



Index

GeneralLedger

GeneralLedger


The business object General ledger is a ledger that is defined
for the representation of values in general ledger accounting that are
used as a basis for preparation of the balance sheet as well as the profit and loss statement.


The general ledger records values at company code level.


11-Dec-2005


Methods

Available Methods


  • GetDocumentItems : Line item of document for ledger with summary table GLFLEXT [ BAPI_GLX_GETDOCITEMS ]
  • GetGLAccountBalance : Closing balance of G/L account for chosen year [ BAPI_GL_GETGLACCBALANCE ]
  • GetGLAccountCurrentBalance : Closing balance of G/L account for current year [ BAPI_GL_GETGLACCCURRENTBALANCE ]
  • GetGLAccountPeriodBalances : Posting period balances for each G/L account [ BAPI_GL_GETGLACCPERIODBALANCES ]

11-Dec-2005


GetDocumentItems

GetDocumentItems


With this procedure you can call up line items for a ledger of the general ledger (Requirement: Summary table V_GLFLEXT).

To do this, you have to enter the ledger (LEDGER), company code (COMPANYCODE), fiscal year (FISCALYEAR), and document number(DOCNUMBERFROM). By entering a second document number (DOCNUMBERTO),
you can select an interval of documents from which the correspondingline items are selected. By entering a document type (DOCUMENTTYPE) you can limit this selection.

The list of line items is provided in table ITEMSLIST. Fields in thistable are not taken into consideration, if they were included in the flexible general ledger by means of a customer include. Table
EXTENSION1 is provided for displaying these fields. To do this, proceed as follows:

A) Customer include CI_1028_INCLUDE1 is located in structureBAPI1028EXT_1. Here, you select the fields that you want displayed in table EXTENSION1.

B) Maintain include zxx28u01 of user-exit exit_sapl1028_001. Assign each field ITEMS_LINE-ZZ* of structure GLU1 to the field
CUSTOMER_FIELDS-ZZ*, which you have included in include CI_1028_INCLUDE1. (The entries in this table are numbered for uniqueassignment of values in tables ITEMSLIST and EXTENSION1.)

C) Create a project with the help of transaction CMOD and assign enhancement GLX1028 to the project. Activate the project.


11-Dec-2005


GetGLAccountBalance

GetGLAccountBalance


This method provides the ending balance of a G/L account for the fiscal year selected.
The user decides whether the balance is provided in the transaction orcompany code currency. Exceptions are G/L accounts kept in varioustransaction currencies. In such cases, only the company code currency is allowed.


The balance determined by the system and the currency are provided. Should problems arise, they are reported in a return code.

Notes

The same authorization checks are carried out as those for display authorization within a R/3 transaction.


The entry parameter COMPANYCODE is not converted, so that the leadingzeros in this parameter are not cleared. This is also the case forparameter GLACCT. G/L account numbers have to be entered with leading zeros (for example, 0000113100).

Messages are provided in parameter RETURN. In the parameter documentation, you can find information on return values and their
meanings.


11-Dec-2005


GetGLAccountCurrentBalance

GetGLAccountCurrentBalance


The method provides the ending balance of a G/L account for the current fiscal year.
The user decides whether the balance should be provided in thetransaction currency or the company code currency. Exceptions are G/Laccounts kept in various transaction currencies. In this case, only the company code currency can be used.


The system provides the balance and currency determined. Should problems arise, they are reported in a return code.

Notes

The same authorization checks are carried out as those needed for display authorization in the R/3 transaction.

The entry parameter COMPANYCODE is not converted, so that leading zeros
in this parameter are not cleared. No conversion is made for parameterGLACCT either. G/L account numbers have to be entered with leading zeros (for example, 0000113100).

Messages are reported in parameter RETURN. You can find the returnvalues and their meanings in the documentation for this parameter.



11-Dec-2005


GetGLAccountPeriodBalances

GetGLAccountPeriodBalances


For a G/L account, the method provides the balances per company code for the fiscal year selected.
The user selects whether the balance is provided in the transaction orcompany code currency. Exceptions are G/L accounts kept in varioustransaction currencies. In this case, only the company code currency can be used.


The balance determined by the system and the currency are provided. Should problems arise, they are reported in a return code.

Notes

The same authorizations as those for display authorization in the R/3 transaction are also carried out.


The entry parameter COMPANYCODE is not converted so that leading zerosin this parameter are not cleared. This is also the case for parameterGLACCT. G/L account numbers have to be entered with leading zeros (for example, 0000113100).

Messages are provided in the parameter RETURN. You can find the return
values and their meanings in the documentation for this parameter.


11-Dec-2005