Documentation View

We are hiring and constantly growing! Have a look through our vacancies to find the right role for you!

/FRE/DB_DIF_VIEW_READ - Read DIF Occurrences via view

/FRE/DB_DIF_VIEW_READ - Read DIF Occurrences via view

Addresses (Business Address Services)   TXBHW - Original Tax Base Amount in Local Currency  
This documentation is copyright by SAP AG.
SAP E-Book

Functionality

Reads relevant DIF data using a view on different DIF tables. It returns separate tables of DIF Occurrences and the corresponding assignment. It is used for fast data selection in the FRP outbound process.

Features:

  • The function allows selection for a location, range of products, and set of DIFs within time interval by DIF.
  • For performance reasons, the function reads product specific assignment only with a range of products, specified by the first and last product ID of the range. If no product range is provided, the data is selected without product restriction. Access for a set of single products is not supported.
  • The function also selects generic assignment for locations and products as well as location group assignment for location groups including the requested location.
  • The function is called separately for DIFs with assignment level location and assignment level product. For DIFs with assignment level location, the import fields for product selection are not populated to reduce run time. For DIFs with assignment level product, they must be populated in order to retrieve product specific assignment records.
  • The function supports different database access paths for performance optimization. The default should be the fastest one in most cases. However, with certain customer configurations, a different access path may be faster:
  • Select first occurrences with DIF identifier and time interval restrictions and then assignment with DIF numbers from occurrences and location and product as additional restrictions. This achieves the best performance if DIF identifier and time interval are highly selective but locations and products are not. This should be the normal case for FRP outbound processing with delta handling (default).

  • Select first assignment with location and product restrictions and then occurrences with DIF numbers from assignment and DIF identifier and time interval as additional restrictions. This achieves the best performance if locations and products are highly selective but DIF identifier and time intervals are not. This will be the case for an initial data load (no delta handling) or after changes reaching far in the past.

  • Select assignment from a join (view) of occurrences with assignment with all restrictions applied at once and then occurrences with the DIF numbers from assignment (all relevant). This achieves the best performance if DIF identifier and time intervals as well as locations and products are not highly selective but their combination is.

  • A BAdI allow you to change the access path in a customer project without modification..
  • The function provides buffering of DIF Occurrences for subsequent calls with same DIFIDs and same time intervals (product packet processing) and buffering for generic product assignment for subsequent calls with same LOCID (product packet processing). There is an option to refresh the buffer.
  • The function provides simple run time statistics (internal table) that can be used in an implementation project to find the best fitting access path in case of performance problems.

Example

Notes

Further information





Parameters

ET_DIF_ASSIGN
ET_DIF_OCCURR
IT_DIFID_TIME
I_ACCESSPATH
I_LOCID
I_MATID_HIGH
I_MATID_LOW
I_REFRESH_BUFFER

Exceptions

/FRE/CX_DB
/FRE/CX_DB_BADI_ERROR
/FRE/CX_DB_DIF_OCC_ERROR
/FRE/CX_DB_WRONG_PARAM
CX_STATIC_CHECK

Function Group

/SAPLDB_DIF_ACCESS

ABAP Short Reference   BAL_S_LOG - Application Log: Log header data  
This documentation is copyright by SAP AG.

Length: 4213 Date: 20211128 Time: 130700     sap01-206 ( 85 ms )