Programme SAP SAPDBSDF - SAPDBSDF Logical Database

Use
Report SAPDBSDF controls the access to the G/L account data base from aFinancial Accounting point of view. Since the program only containsphysical access routines for the logical data base, it cannot be startedseparately.
IF &[SWITCH]FAGL_FIN_GL_CI_3_RS& = 'X'.
You can read data from the database as well as data from the archive.When data is read from the archive, you can access line items as well astotals records.
ENDIF.

Special features:
Selection criteria - Chart of accounts and company code.
By reducing the selection using the above selection parameters, thevalid choice of data is determined from the assigned charts of accountsin the logical data base for the existing company codes and used as thebasis for selection.
If you leave both selection criteria blank, all company codes areevaluated at company code level. At G/L account master data level, it isthen possible to edit non-assigned charts of accounts.
G/L account transaction figures
2 G/L account C segments, SKC1A and SKC1C are available for processing.

  • Using GET SKC1A, the transaction figures per business area and in local
  • currency or group currency (accumulated across all currencies) are madeavailable to the report being called up.
    • Using GET SKC1C, the transaction figures per business area and currency
    • are made available to the report being called up. In addition, the localcurrency fields are displayed p e r foreign currency or groupcurrency.
      With the currency type parameter, you select whether local currency,group currency, index currency, ....will be used.

      Technical documentation
      In the standard system, a basic selection screen (screen number 950) and5 screen variants are delivered for the logical data base SAPDBSDF. Thebasic selection screen contains all available data base selections.apart from the group currency field. If you make changes to data baseselections (for example, defining a new selection parameter or extendingthe G/L account number to 10 characters), then screen 1000 isautomatically regenerated by the system. Screen variants are availablein reporting by entering the screen number in the attributes.

      Available fields
      The available fields on a screen are indicated with an 'X'.
      Selection screen variant
      Field name 950 900 901 902 903 904 905
      Chart of accounts X X X X X X
      G/L account number X X X X X X X
      Company code X X X X X X
      Fiscal year X X X X X
      Business area X X X X X X
      Key date of OIs X X X X
      Clearing date X X X X
      Currency type X X

      Authorization checks

      • account type authorization (F_BKPF_KOA)

      • company code authorization (F_SKA1_BUK, F_BKPF_BUK)

      • account authorization (F_SKA1_BES)

596865Archive connection for FI line item lists
1168430FS10N: Display 'classic' balances when new G/L is active II
782897Turkey: Program adjustments for currency change
860897Line item: Runtime error SAPSQL_SQLS_INVALID_CURSOR
848163Line items: Runtime error SAPSQL_SQLS_INVALID_CURSOR
449626Tax reduction law FI: logical databases
321671Local currency changeover RE: expiring currencies
359028Line items: Expiring currencies
366042Expiring currencies processes FI
191763Incorrect report results/lacking authorization