1967837 - HANA adjustment for FRE initial and delta load

Symptom

This SAP Note contains adjustments to the SAP Forecasting and Replenishment (F&R) ERP Outbound interfaces for porting to SAP HANA as of DB Release HDB 1.0 Rev. 70.

Other Terms

SAP HANA, Forecasting and Replenishment, FRE01, FRE02, FRE05, FRE11, FRE12

Reason and Prerequisites

You plan to port to SAP HANA as of DB Release HDB 1.0 REV 70.

Solution

This SAP Note contains adjustments to database accesses, which will improve performance in general.
Changes in detail:

SAP HANA FAE (FOR ALL ENTRIES) hint during the relevance check (FRE_DB_ART_SITE selection in function module FRE_DB_ART_SITE_RELEV_CHECK). The hint has an internal effect in SAP HANA, whereby table accesses are reduced and the selection is therefore accelerated. This is relevant for all interfaces with a relevance check.

Individual selections in the FRE_DB_ART_SITE table are replaced with mass selection (prefetch) in the function module FRE_DB_ART_SITE_WRITE. Mass selection from the database and a subsequent sorted reading from a buffer is significantly faster than individual record selection from the database. This is relevant for master data interfaces (product, location product, etc.).

Individual selections in the WAKT table are replaced by mass selection in the function modules FRE_MD_DIF_INIT_CREATE and FRE_MD_DIF_DELTA_CREATE. The selected data is passed to the function module FRE_MD_DIF_BUILD_OBJECTS, where the individual records can then be read from a sorted buffer. This is relevant for the transfer of actions as DIFs.

Individual selections in the KNA1 table within change pointer processing are replaced with mass selection in the routine SOS_LANES_CHG_PTR_EVALUATE (function group FRE_MD_SOS_OUT) for all relevant sites. This is relevant for the transfer of master data (locations).

Individual selections in the MARM table are replaced with mass selection in the function module FRE_DB_ART_SITE_ATTR_READ for all relevant articles. The prefetch is executed by calling the standard module MARM_ARRAY_READ, which fills a buffer that is read in sales price determination. This is relevant for the transfer of master data (sales prices).

Individual selections in the MLAN table are replaced with mass selection in the function module FRE_DB_ART_SITE_ATTR_READ for all relevant articles. The prefetch is executed by calling the standard module MATERIAL_PRE_READ_MAWEV, which fills a buffer that is read in sales price determination. This is relevant for the transfer of master data (sales prices).

Individual selections in the MARC table are replaced with a prefetch in the function module FRE_SEND_TSD_FOR_SITE for all relevant article-site combinations. The prefetch is executed by calling the standard module FRE_TS_MARC_BUFFER, which fills a buffer that is read in the function module FRE_READ_CONSUMPTION. This is relevant for the transfer of consumption data.

Individual selections in the MARC table are replaced by mass selection in the routine SELECT_EKET_51 (include LFRE_ORDER_DBF02) during the determination of the goods issue date in the distribution center for stock transport orders for all relevant article-site combinations. This is relevant for the purchase order interface.

Header Data

Released On	03.03.2014 08:42:15
Release Status	Released for Customer
Component	SCM-FRE-IF Interfaces
Priority	Correction with medium priority
Category	Performance