About sap bw lo extraction-global setting

This is obtained directly from SAP help. Data extraction has always been a weakness, but it may be limited by work. It should be strengthened.

Global settings

For the transferal of line items from financial accounting, important global settings can be made in the sap r/3 system in Table bwom_settings. for this purpose, change the table using transaction SE16 (Table maintenance ).

Oltpsource	Param_name	Param_value	Default Value
<Space>	Bwfilowlim	Yyyymmdd	19910101
<Space>	Bwfisafety	<Days>	1
<Space>	Orgsysonly	<Space> or X	<Space>
<Space>	Deltimest	<Days>	60
<Space>	Bwfioverla	<Space> or X	<Space>
<Space>	Bwfitimbor	<Time>	020000

• Bwfilowlim

Here, you can set the lower time limit of the time stamp selection
DataRequests in update modeInitialization of the delta method. Together with the selection criteria, this parameter is a decisive factor for the data volume with data requests in update modeInitialization of the Delta
Method.

Set the creation time of the starting document for data capture. The system defaults to January 1, January 1, 1991, which is enough.

• Bwfisafety

Here, you can the upper time limit of the time stamp selection for data requests in all update modes. value 1 in this parameter means that the upper time limit of the time stamp selection is the previous day. with larger parameter values, the upper limit
Of the time stamp selection is correspondingly further (in days) in the past.

Note that you cannot choose a parameter value cannot be smaller than 1, as this wowould prevent the Delta dataset being found completely.

To put it simply, it is to capture data today. When selecting the document creation date, we need to push it forward for a few days. This is a good understanding, because today, unless it is the last second of the night, it is very likely that the ticket will be dropped, for the sake of insurance, choose the one before today. 1 indicates the previous day, and N indicates n days.

You cannot set a value smaller than 1.

• Orgsysonly

If you sap r/3 system is part of an ale scenario, set this parameter to X. this ensures that only those line items that were originally posted to the BW system will be transferred there from the sap r/3 system. this prevents line items being transferred
Several times from various sap r/3 system.

Did not understand, for help.

• Deltimest

With this parameter, you can set the retention period of entries that are no longer required in time stamp table bwom2_timest. the default setting for deletion of entries that are no longer required in the time stamp table is 60 days. the minimum retention
Period for entries in the time stamp table is 15 days. When entries are deleted from table bwom2_timest, the corresponding entries for the changed fi line items are deleted simultaneously from log table bwfi_aedat.

Because the timestamp log is retained for Data Extraction for a few days.

• Bwfioverla

The logic of this parameter prevents records with the previous day as their CPU date from still being in the update at the time of extraction.

• Ifxis set for this parameter, selection is made up to the previous day if the time limit is not reached.
  
• If <space> is selected for this parameter, selection is made up to the day before the previous day if the time limit is not reached.

That is, when the data is being extracted, it goes through 12 points. If X is selected and there is no limited time, the time range will add the execution day. If you leave it blank and there is no time limit for the export, the time range is defined as the day before yesterday.

• Bwfitimbor

This parameter designates 02.00 (2. M .) as the time limit for extraction. if this limit is not reached, the system applies a safety time interval of one day for determination of the to-value. if extraction is started before therefore, the selection
Takes place only up to the day before the extraction run.

Set the time limit.

Changing the default value isNotRecommended.