SAP ABAP Reports and Programs

Share |

FRE_SEND_TSD SAP Report - Transfer consumption data and stock information to F&R

FRE_SEND_TSD is a standard ABAP report available within your SAP system (depending on your version and release level). Below is the standard documentation available for this report and a few details of other objects it interacts with such as tables, function modules, includes etc. If you would like to see the full code listing simply enter FRE_SEND_TSD into the relevant SAP transaction such as SE38 or SE80

Although this basic information may have limited use other that for reference, within the comments section below there is also an opportunity for anyone to add useful hints, information and links to existing content specific to this abap report. This page will therfore over time start to contain a useful amount of information that can be found quickly, simply by searching on the object name, FRE_SEND_TSD.


SAP Documentation for program FRE_SEND_TSD

Transaction Code(s):

Below is a list of transaction codes which are relevant to this SAP report


FRE03 - Transfer Time Series Data

TITLE
Transfer consumption data and stock information to F R

PURPOSE
Execution of Forecasting and Replenishment in F R requires input from external systems. A part of these input are stock information and consumption data for stores and DC's from the SAP Retail system. To supply F R with the required data, this report selects stock information and consumption data for relevant article/site-combinations and transfers these data to F R.

INTEGRATION


PREREQUISITES


FEATURES

SELECTION
In general, only data for article/site-combinations stored in table FRE_DB_ART_SITE will be processed. From this specified amount only those entries will be processed, for which stock has changed. With the settings on selection screen the data selection and data transfer from this specified amount will be affected.
Input in block "Selection settings" for Site and Article restrict the data selection to these article/site-combinations.
The block "Transfer settings" controls the kind of data, which will be selected and transferred. Only the marked kind of data will be processed.
Differing from the normal run, with the parameter "Transfer data general" in this block it is possible to enforce the data transfer for specified article/site-combination. If this parameter is set, data will be transferred even when there is no stock change for this article/site-combination.
Normally only for the first transfer of an article/site-combination to F
R consumption data will be selected and transferred with "number of periods for initial load". Thereafter the "number of periods for normal load" will be used. The parameter "Consumption data selection with no of periods for initial load" affects this logic. Setting this parameter enforce a generally transfer of consumption data with "number of periods for initial load".
Documentation extract taken from SAP system, Copyright (c) SAP AG

Includes used within report:

INCLUDE FRE_SEND_TSD_TOP.
INCLUDE FRE_SEND_TSD_F01.


Tables used within report and the associated select statement:

No SAP database TABLES are accessed within this report code!


Function Modules used within report and the associated call statement:

FRE_DB_CONVERT_50 CALL FUNCTION 'FRE_DB_CONVERT_50' EXCEPTIONS conversion_error = 1 nothing_to_do = 2 OTHERS = 3.

AIC0_OWN_LOGSYSTEM_GET CALL FUNCTION 'AIC0_OWN_LOGSYSTEM_GET' IMPORTING e_own_logsystem = gv_sender EXCEPTIONS own_logsystem_not_defined = 1 OTHERS = 2.

FRE_SEND_TSD_FOR_SITE CALL FUNCTION 'FRE_SEND_TSD_FOR_SITE' STARTING NEW TASK gv_tname DESTINATION IN GROUP gv_srvgrp PERFORMING come_back ON END OF TASK EXPORTING * I_WERKS = gt_site-werks "1233803 * I_TZONE = gt_site-tzone "1233803 i_trsto = p_trsto i_stock_gen = p_stgen i_trcon = p_trcon i_con_init = p_init i_sender = gv_sender i_refid = gv_refid i_send_opt = fre_send_option TABLES t_matnr = so_matnr t_sttyp = gt_sttyp t_art_site = gt_relart[] " 1233803 t_site_tz_loctype = lt_loc_tz_loctype[] " 1233803 t_art_site_org = gt_relart_org[] " 1233803 EXCEPTIONS *-> Note 1154950 lock_on_db_art_site = 1 communication_failure = 2 system_failure = 3 resource_failure = 4.

FRE_SEND_TSD_FOR_SITE CALL FUNCTION 'FRE_SEND_TSD_FOR_SITE' EXPORTING * I_WERKS = gt_site-werks * I_TZONE = gt_site-tzone i_trsto = p_trsto i_stock_gen = p_stgen i_trcon = p_trcon i_con_init = p_init i_sender = gv_sender i_refid = gv_refid i_send_opt = fre_send_option TABLES t_matnr = so_matnr t_sttyp = gt_sttyp t_art_site = gt_relart[] t_site_tz_loctype = lt_loc_tz_loctype[] t_art_site_org = gt_relart_org[] EXCEPTIONS lock_on_db_art_site = 1.

FRE_SEND_TSD_FOR_SITE CALL FUNCTION 'FRE_SEND_TSD_FOR_SITE' EXPORTING * I_WERKS = gt_site-werks "1233803 * I_TZONE = gt_site-tzone "1233803 i_trsto = p_trsto i_stock_gen = p_stgen i_trcon = p_trcon i_con_init = p_init i_sender = gv_sender i_refid = gv_refid i_send_opt = fre_send_option TABLES t_matnr = so_matnr t_sttyp = gt_sttyp t_art_site = gt_relart[] " 1233803 t_site_tz_loctype = lt_loc_tz_loctype[] " 1233803 t_art_site_org = gt_relart_org[] " 1233803 *-> Note 1154950 EXCEPTIONS lock_on_db_art_site = 1.

FRE_MESSAGE_DB CALL FUNCTION 'FRE_MESSAGE_DB' EXPORTING mode = 'I' * NO_COMMIT = 'X' * IMPORTING * DB_COUNT = TABLES messages = gt_messages[] * SO_MSG = EXCEPTIONS database_error = 0 wrong_mode = 0 OTHERS = 0.

AIC0_OWN_LOGSYSTEM_GET CALL FUNCTION 'AIC0_OWN_LOGSYSTEM_GET' IMPORTING e_own_logsystem = gv_sender EXCEPTIONS own_logsystem_not_defined = 1 OTHERS = 2.

FRE_TS_INITIAL * CALL FUNCTION 'FRE_TS_INITIAL' * EXPORTING * it_relart = gt_relart[] * it_loc_tz_loctype = gt_loc_tz_loctype * it_sttyp = lt_sttyp * i_tr_stock = p_trsto * i_tr_consumption = p_trcon * i_parallel = p_paral * i_svrgrp = p_svrgr * i_tasks = p_tasks * i_block = l_block * i_sender = gv_sender * i_refid = gv_refid * i_send_opt = fre_send_option * EXCEPTIONS * no_data = 1 * no_relevant_sites = 2 * no_relevant_stock_types = 3 * no_resources_for_parallel_proc = 4 * communication_failure = 5 * lock_error = 6 * OTHERS = 7.

FRE_TS_DELTA * CALL FUNCTION 'FRE_TS_DELTA' * EXPORTING ** I_DATE_FROM = '00000000' ** I_DATE_TO = SY-DATUM ** I_TIME_FROM = '000000' ** I_TIME_TO = SY-UZEIT * it_relart = gt_relart[] * it_loc_tz_loctype = gt_loc_tz_loctype * it_sttyp = lt_sttyp * i_tr_stock = p_trsto * i_tr_consumption = p_trcon ** I_TEST = ' ' * i_parallel = p_paral * i_svrgrp = p_svrgr * i_tasks = p_tasks * i_block = p_block * i_sender = gv_sender * i_refid = gv_refid * i_send_opt = fre_send_option ** IMPORTING ** E_CP_STOCK = ** E_CP_CONS = * EXCEPTIONS * no_data = 1 * error_in_date_interval = 2 * error_in_time_interval = 3 * no_relevant_sites = 4 * no_relevant_stock_types = 5 * no_resources_for_parallel_proc = 6 * communication_failure = 7 * lock_error = 8 * OTHERS = 9.

FRE_TS_INITIAL CALL FUNCTION 'FRE_TS_INITIAL' EXPORTING it_relart = gt_relart[] it_loc_tz_loctype = gt_loc_tz_loctype it_sttyp = lt_sttyp *$ note 1463504 begin * i_tr_stock = p_trsto * i_tr_consumption = p_trcon i_tr_stock = l_stock_init i_tr_consumption = l_cons_init *$ note 1463504 end i_parallel = p_paral i_svrgrp = p_svrgr i_tasks = p_tasks i_block = l_block i_sender = gv_sender i_refid = gv_refid i_send_opt = fre_send_option EXCEPTIONS no_relevant_sites = 1 no_relevant_stock_types = 2 no_resources_for_parallel_proc = 3 communication_failure = 5 lock_error = 6 OTHERS = 7.

FRE_TS_DELTA CALL FUNCTION 'FRE_TS_DELTA' EXPORTING * I_DATE_FROM = '00000000' * I_DATE_TO = SY-DATUM * I_TIME_FROM = '000000' * I_TIME_TO = SY-UZEIT it_relart = gt_relart[] it_loc_tz_loctype = gt_loc_tz_loctype it_sttyp = lt_sttyp * $ note 1463504 begin * i_tr_stock = p_trsto * i_tr_consumption = p_trcon i_tr_stock = l_stock_delta i_tr_consumption = l_cons_delta * $ note 1463504 end * I_TEST = ' ' i_parallel = p_paral i_svrgrp = p_svrgr i_tasks = p_tasks i_block = p_block i_sender = gv_sender i_refid = gv_refid i_send_opt = fre_send_option * IMPORTING * E_CP_STOCK = * E_CP_CONS = EXCEPTIONS no_data = 1 error_in_date_interval = 2 error_in_time_interval = 3 no_relevant_sites = 4 no_relevant_stock_types = 5 no_resources_for_parallel_proc = 6 communication_failure = 7 lock_error = 8 OTHERS = 9.

FRE_MESSAGE_DB CALL FUNCTION 'FRE_MESSAGE_DB' EXPORTING mode = 'I' * NO_COMMIT = TABLES messages = gt_messages[] EXCEPTIONS database_error = 1 wrong_mode = 2 foreign_lock = 3 OTHERS = 4.


Text pool values


Selection Text: SO_WERKS = Site
Selection Text: SO_MATNR = Article
Selection Text: P_TRSTO = Stock information
Selection Text: P_TRCON = Consumption data
Selection Text: P_TASKS = D .
Selection Text: P_SYDEST = D .
Selection Text: P_SVRGR = D .
Selection Text: P_STGEN = General transfer
Selection Text: P_PARAL = D .
Selection Text: P_INIT = Consumption initial load
Selection Text: P_DIRECT = D .
Selection Text: P_BLOCK = D .
Title: Transfer consumption data and stock information to F&R
Text Symbol: YAS = Make at least one selection in area kind of data!
Text Symbol: T03 = Warning: Lock on table FRE_DB_ART_SITE failed at least for one site!
Text Symbol: T02 = (For details use report FRE_MESSAGE_UI)
Text Symbol: T01 = ******* Processing completed! *******
Text Symbol: P04 = Consumption data selection with no. of periods for initial load
Text Symbol: P03 = Transfer data general (including unchanged data since last transfer)
Text Symbol: P02 = Consumption data
Text Symbol: P01 = Stock information
Text Symbol: F04 = Transfer settings
Text Symbol: F03 = Parallel Processing Options
Text Symbol: F02 = Transfer settings
Text Symbol: F01 = Selection settings
Text Symbol: C02 = Additional settings:
Text Symbol: C01 = Kind of data:






Terms of Service     Contact Us     Privacy Policy     Useful SAP related sites