Ansicht
Dokumentation
/FRE/DB_DIF_VIEW_READ - Read DIF Occurrences via view
SUBST_MERGE_LIST - merge external lists to one complete list with #if... logic for R3up General Material DataThis documentation is copyright by SAP AG.
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_ASSIGNET_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_ACCESSRFUMSV00 - Advance Return for Tax on Sales/Purchases ABAP Short Reference
This documentation is copyright by SAP AG.
Length: 4213 Date: 20240416 Time: 080852 sap01-206 ( 88 ms )
