Ansicht
Dokumentation

SAPDBZKRBRF - SAPDBBRF Logical Database

General Material Data   General Material Data  
This documentation is copyright by SAP AG.

Use

Note

Contents

1. General
2. Purpose of table B0SG
3. Selection screen variants
4. Selection parameters "Ledger" and "Ledger Group" (new General Ledger Accounting)

General

The report SAPDBBRF controls access to the Financial Accounting document data base. Since the program only contains physical access routines for the logical data base, it cannot be started separately.

Purpose of table B0SG

The selection scope of the logical data base SAPDBBRF (document data base) is controlled via the selection parameters from table B0SG. There are 3 parameter groups:

• Master data selection

By marking the parameters, you can decide whether the master data information is also to be read for the selected documents. (Additional reading of the master data information).

• Selection by document status

By selecting the document status, you can limit the selection to a status (normal document, recurring document, statistical document).

• Additional document information

Here you decide whether bill of exchange data or one-time account data is to be processed for the document.

The selection of normal documents, one-time account data and bill of exchange data is set as a default value (time of initialization of the logical data base SAPDBBRF).

If a change of the document status or additional document information is required, then the new selection parameters must be transferred from the report to the logical data base SAPDBBRF AT THE TIME OF INITIALIZATION OR AT THE START OF SELECTION.

Report example: RFDAUB00.

When processing master data information, note in particular:

The information as to which master data (customer, vendor, G/L accounts) and to what extent it is to be selected (transfer of the select option tables) must take place at the time of the GET B0SG command.

When processing recurring entry original documents, note in particular:

If the selection time is to be optimized and o n l y recurring entry original documents are to be processed in the report, the selection of normal documents is to be switched off (B0SG-XSTAN = BLANK) and the selection of recurring entry original documents is to be switched on (B0SG-XSTAD = 'X') at the time of initialization or at the start of selection in the report.

Selection screen variants

In the standard system, there is a basic selection screen (screen number 950) and 3 screen variants for the logical data base SAPDBBRF. This screen is entered in the database as its own selection screen. It contains all database selections up to the archive contents selection. This is carried out using the 901 selection screen. The following section contains descriptions of each selection screen.

The available fields on a screen are indicated with an 'X'.

Field name                          Selection screen variant

                                    950 900 901 902 903

Company code                         X   X   X   X   X  

Document number                      X       X       X  

Fiscal year                          X       X       X  

Document type                                        X  

Posting date                         X       X       X  

CPU Date                                             X  

Reference doc.no.                    X       X       X  

Reference transaction                                X  

Reference key                                        X  
Logical system                                       X  
X - Read items sequentially          X       X          
X - Archive files requested                  X   X      
X - Process archive only                     X   X      

The screen 900 is used by programs which only need the document type and the company code as selections, for example in the recurring entry program.

Screen 901 is only intended for report evaluations which are to access documents already archived. By entering the screen number (0901) in the report attributes and regenerating the report, the system offers the additional parameters on the selection screen. For test purposes, processing of the archive can be started via the Program SAPF042.

WARNING: In order for processing of the archive to be also possible in batch, the report to be requested must contain Table SARKEY (TABLES: SARKEY) in its definitions. You should also make sure that the directory in which the archived datasets are found, is also on the machine on which the batch process runs.

Screen 902 is used by programs which only need the document type and company code selections but also read archives. It is used, for example, by the report for business area transfer postings. The comments mentioned above apply for the processing of the archived data.

Screen 903 is used by all programs which do not allow a sequential document evalaution or which only evaluate document headers. In the case of online evaluations, sequential processing should be forbidden.

The option 'Read items sequentially' is used for improving the performance when editing mass data. It is difficult to make a general statement as to whether reading sequentially is better for performance, but experience has shown that it is useful to use this option if at least 20% of the selected document headers lead to document processing (and the processing of the line items is not prevented by selection criteria at document header level). This option requires all selected document headers to be stored in a data base-internal table which leads to an increased need for roll or paging area.

Authorization checks

Depending on the fields selected in B0SG, authorization checks take place for

• Account type authorization (F_BKPF_KOA)

• Company code authorization (F_BKPF_BUK)

• Account authorization (F_KNA1_BED, F_LFA1_BEK, F_SKA1_BES)

Selection Parameters "Ledger" and "Ledger Group" (new General Ledger Accounting)

Provided that new General Ledger Accounting has been activated, the Ledger field is used as the selection parameter in the logical database. With the standard setting, the Ledger input field is filled with the leading ledger. If the user sets the Ledger field to initial, the system reads the leading ledger.

In addition, the user can also select values using the ledger group. If the user wants to have this selection criterion on the screen, he or she needs to switch the MODIF ID GRP to active (screen is active = 1) and to set the indicator XLDGRP = X for table B0SG. Provided that it is possible to select the ledger group, the ledger may also be left empty. Provided it is possible to select the ledger group on the screen, the system makes selections according to the following list:

Ledger	Ledger Group	Selection
INITIAL	INITIAL	No restriction to ledger and ledger group
EQ SPACE	Any	Error message instructs the user to check the values entered
INITIAL	EQ SPACE	Selection of the ledger group "SPACE"
EQ LDNR	INITIAL	Selection of all ledger groups containing ledger LDNR
INITIAL	(N)EQ LDGRP	Selection of the ledger group LDGRP
EQ LDNR	(N)EQ LDGRP	Error message instructs the user to enter either a ledger or a ledger group

Example report: RFBELJ00

Addresses (Business Address Services)   SUBST_MERGE_LIST - merge external lists to one complete list with #if... logic for R3up  
This documentation is copyright by SAP AG.

Length: 12551 Date: 20240520 Time: 054724     sap01-206 ( 151 ms )