Programme SAP SAPDBDDF - Logical Database SAPDBDDF

Use

Note
The report SAPDBDDF controls the accesses to the customer data basefrom a Financial Accounting point of view. Since the program onlycontains physical access routines for the logical data base, it cannotbe started separately.

Technical documentation
In the standard system, a basic selection screen (screen number 1000)and 4 screen variants are delivered for the logical data base SAPDBDDF.The basic selection screen contains all available data base selections.If you make changes to data base selections (for example, defining anew selection parameter or extending the customer number to 10characters), then the system will automatically regenerate this screen.It can then be used immediately by all reports that use the logicaldata base DDF. Screen variants are available in reporting by enteringthe selection screen number in the attributes.

Available fields
The available fields on a screen are indicated with an 'X'.
Screen number
Field description 1000 900 901 902 903
Customer number X X X X X
Company code X X X X X
Fiscal year X X X X
Key date of OIs X X
Clearing date X X X

Table selection
In order to improve performance, individual tables can be excluded fromselection. The following tables can be set in the application report ATTHE TIME OF INITIALIZATION or AT THE START OF SELECTION:

  • B0SG-XAGSL (blank as a default): if an 'X' is entered in this field,
  • then only A and B segments are read; in this case, only A segments forwhich there are no B segments are selected - this is normally not thecase.
    • B0SG-XBNKL ('X' as a default): if this field is left blank, then the
    • bank data is not read.
      • B0SG-XSTDL ('X' as a default): if this field is left blank, then the
      • tax data is not read.
        • B0SG-XMNDL ('X' as a default): if this field is left blank, then the
        • dunning data is not read.
          • B0SG-XKKDL ('X' as a default): if this field is left blank, then the
          • customer credit data is not read.

            Authorization checks

            • account type authorization (F_BKPF_KOA)

            • company code authorization (F_KNA1_BUK)

            • account authorization (F_KNA1_BED)

596865Archive connection for FI line item lists
1171560FBL1N/FBL5N: Custom selections for master data ignored
1104971Line Item: DBIF_RSQL_INVALID_CURSOR despite 848163/860897
860897Line item: Runtime error SAPSQL_SQLS_INVALID_CURSOR
848163Line items: Runtime error SAPSQL_SQLS_INVALID_CURSOR
449626Tax reduction law FI: logical databases
359028Line items: Expiring currencies
366042Expiring currencies processes FI
330402Short dump SQL_FIELDNAME_UNKNOWN log. database KDF and DDF
310886Line items: Dynamic selections ignored