FRE_DATASET_READ_WRITE_DELETE is a standard SAP function module available within R/3 SAP systems depending on your version and release level. Below is the pattern details for this FM showing its interface including any import and export parameters, exceptions etc as well as any documentation contributions (Comments) specific to the object.
See here to view full function module documentation and code listing, simply by entering the name FRE_DATASET_READ_WRITE_DELETE into the relevant SAP transaction such as SE37 or SE80.
Associated Function Group:
FRE_ORDER_OUT
Released Date:
Not Released
Processing type: Normal fucntion module
CALL FUNCTION 'FRE_DATASET_READ_WRITE_DELETE' "Write, read and delete Datasets
EXPORTING
filename = " char30 File to be created, read or deleted
path_to_file = " pathintern Logical path name
modus = " fre_modus Modus for Database Access Function Modules
caller = " fre_con_interface Calling Program
* error = " xfeld Checkbox
* session_id = " char15 Char 15
* is_send_option = " fre_send_option Grundeinstellungen für Datenübertragung pflegen
* no_tab_del = " xfeld Checkbox
* TABLES
* header_if = " fre_op_header_if Header Structure for Communication with F&R
* item_if = " fre_op_item_if Item Structure for Communication with F&R
* loc_tty = " fre_bif_loc_tty F&R data interface: List of location data
* loct_tty = " fre_bif_loct_tty F&R Data Interface Location Text Data
* locadr_iso_tty = " fre_bif_locadr_iso_tty BIF: Location spec. address data incl. ISO fields
* loctel_iso_tty = " fre_bif_loctel_iso_tty Location spec. phone numbers incl. ISO fields
* locfax_iso_tty = " fre_bif_locfax_iso_tty location spec. fax numbers incl. ISO fields
* locsmtp_tty = " fre_bif_locsmtp_tty F&R data interface: List of location spec. internet address
* locuri_tty = " fre_bif_locuri_tty F&R data interface: List of location spec. commun. methods
* trprod2_tty = " fre_md_trprod2_tty F&R Data Interface Transportation Lane for Subranges
* trp2td_tty = " fre_md_trp2td_tty F&R Data Interface Transportation Lane for Subranges TD
* trprod_tty = " fre_md_trprod_tty Fre Transportation Lane for Products
* tpsrc_tty = " fre_md_tpsrc_tty fre External Procurement data incl ISO fields
* cscale_tty = " fre_md_cscale_tty Fre Price Information for external proc incl ISO fields
* matkey_iso_tty = " fre_bif_matkey_iso_tty F&R Product unit of measures data incl ISO fields
* mattxt_iso_tty = " fre_bif_mattxt_iso_tty F&R Product description data incl ISO fields
* marm_iso_tty = " fre_bif_marm_iso_tty F&R Product unit of measures data incl ISO fields
* matloc_iso_tty = " fre_bif_matloc_iso_tty F&R Location Product data incl ISO fields
* matloct_tty = " fre_bif_matloct_tty F&R Data Interface Time dependent Location Product data
* layout_tty = " fre_bif_layout_tty F&R Data Interface: Layout modules
* prodh = " fre_bif_prodh_tty Table Type for BAdI FRE_MCH_BEFORE_SEND
* locgrp_tty = " fre_bif_locgrp_tty Location Product data
* ekorg_assign_tty = " fre_bif_ekorg_ass_tty
* procyc_tty = " fre_md_procyc_tty Table type for transfer structure for procurement cycles
* procyctxt_tty = " fre_md_procyctxt_tty Table type for transfer structure for procurement cycle text
* difocc_tty = " fre_bif_difocc_tty F&R data interface DIF occurence input table
* difa_tty = " fre_bif_difa_tty F&R data interface DIF assignment input table
* difocct_tty = " fre_bif_difocct_tty F&R data interface DIF descriptions incl ISO fields
* abi_head_tty = " fre_db_abi_head_tty Table type for FRE_DB_ABI_HEAD
* abi_pos_tty = " fre_db_abi_pos_tty Table type for FRE_DB_ABI_POS
* proprl_tty = " fre_bif_proprl_tty release profile
* proprlt_tty = " fre_bif_proprlt_tty release profile description
* proprli_tty = " fre_bif_proprli_tty release profile detail
* profas_tty = " fre_bif_proprla_tty release profile
* laymod_tty = " fre_bif_bapi_layout_tty Interface table for layout modules to SAp F&R
* dif_no_sites_tty = " fre_dif_no_sites_tty DIF occurrence data
* contract = " fre_contract_51_tty Contact Data IF Structure
* it_lane = " fre_md_lane_tty Lanes Data for Comminication with FRE
* it_lane_td = " fre_md_lane_td_tty Time Dependent Lanes Data for Comminication with FRE
* it_pcost = " fre_md_pcost_tty Fre Price Information for external proc incl ISO fields
* it_sales_order = " standard table Sales Order Data to be transferred to F&R
* CHANGING
* ct_ts_tty = " fre_bif_tsd_exp_tty Expanded structure for Time Series Data
* ct_subst_switch_tty = " fre_subst_switch_if_tty
* ct_lanetd_tty = " fre_md_lanetd_tty
* ct_subst_assign_tty = " fre_subst_assign_if_tty
* ct_art_site = " fre_md_art_site_tty Table Type: Article Site Combinations
* ct_art_site_td = " fre_md_art_site_td_tty Table Type: Article Site Combinations Time Dependent Data
EXCEPTIONS
PATH_NOT_FOUND = 1 " No physical Path for logical Pathname maintained
FILE_NOT_FOUND = 2 " No file with found or File corrupted
NO_FILE_CREATED = 3 " File couldn't get created
. " FRE_DATASET_READ_WRITE_DELETE
The ABAP code below is a full code listing to execute function module FRE_DATASET_READ_WRITE_DELETE including all data declarations. The code uses the latest in-line data DECLARATION SYNTAX but I have included an ABAP code snippet at the end to show how declarations would look using the original method of declaring data variables up front. This will allow you to compare and fully understand the new inline method. Please note some of the newer syntax such as the @DATA is not available until a later 4.70 service pack (SP8).
| it_header_if | TYPE STANDARD TABLE OF FRE_OP_HEADER_IF,"TABLES PARAM |
| wa_header_if | LIKE LINE OF it_header_if , |
| it_item_if | TYPE STANDARD TABLE OF FRE_OP_ITEM_IF,"TABLES PARAM |
| wa_item_if | LIKE LINE OF it_item_if , |
| it_loc_tty | TYPE STANDARD TABLE OF FRE_BIF_LOC_TTY,"TABLES PARAM |
| wa_loc_tty | LIKE LINE OF it_loc_tty , |
| it_loct_tty | TYPE STANDARD TABLE OF FRE_BIF_LOCT_TTY,"TABLES PARAM |
| wa_loct_tty | LIKE LINE OF it_loct_tty , |
| it_locadr_iso_tty | TYPE STANDARD TABLE OF FRE_BIF_LOCADR_ISO_TTY,"TABLES PARAM |
| wa_locadr_iso_tty | LIKE LINE OF it_locadr_iso_tty , |
| it_loctel_iso_tty | TYPE STANDARD TABLE OF FRE_BIF_LOCTEL_ISO_TTY,"TABLES PARAM |
| wa_loctel_iso_tty | LIKE LINE OF it_loctel_iso_tty , |
| it_locfax_iso_tty | TYPE STANDARD TABLE OF FRE_BIF_LOCFAX_ISO_TTY,"TABLES PARAM |
| wa_locfax_iso_tty | LIKE LINE OF it_locfax_iso_tty , |
| it_locsmtp_tty | TYPE STANDARD TABLE OF FRE_BIF_LOCSMTP_TTY,"TABLES PARAM |
| wa_locsmtp_tty | LIKE LINE OF it_locsmtp_tty , |
| it_locuri_tty | TYPE STANDARD TABLE OF FRE_BIF_LOCURI_TTY,"TABLES PARAM |
| wa_locuri_tty | LIKE LINE OF it_locuri_tty , |
| it_trprod2_tty | TYPE STANDARD TABLE OF FRE_MD_TRPROD2_TTY,"TABLES PARAM |
| wa_trprod2_tty | LIKE LINE OF it_trprod2_tty , |
| it_trp2td_tty | TYPE STANDARD TABLE OF FRE_MD_TRP2TD_TTY,"TABLES PARAM |
| wa_trp2td_tty | LIKE LINE OF it_trp2td_tty , |
| it_trprod_tty | TYPE STANDARD TABLE OF FRE_MD_TRPROD_TTY,"TABLES PARAM |
| wa_trprod_tty | LIKE LINE OF it_trprod_tty , |
| it_tpsrc_tty | TYPE STANDARD TABLE OF FRE_MD_TPSRC_TTY,"TABLES PARAM |
| wa_tpsrc_tty | LIKE LINE OF it_tpsrc_tty , |
| it_cscale_tty | TYPE STANDARD TABLE OF FRE_MD_CSCALE_TTY,"TABLES PARAM |
| wa_cscale_tty | LIKE LINE OF it_cscale_tty , |
| it_matkey_iso_tty | TYPE STANDARD TABLE OF FRE_BIF_MATKEY_ISO_TTY,"TABLES PARAM |
| wa_matkey_iso_tty | LIKE LINE OF it_matkey_iso_tty , |
| it_mattxt_iso_tty | TYPE STANDARD TABLE OF FRE_BIF_MATTXT_ISO_TTY,"TABLES PARAM |
| wa_mattxt_iso_tty | LIKE LINE OF it_mattxt_iso_tty , |
| it_marm_iso_tty | TYPE STANDARD TABLE OF FRE_BIF_MARM_ISO_TTY,"TABLES PARAM |
| wa_marm_iso_tty | LIKE LINE OF it_marm_iso_tty , |
| it_matloc_iso_tty | TYPE STANDARD TABLE OF FRE_BIF_MATLOC_ISO_TTY,"TABLES PARAM |
| wa_matloc_iso_tty | LIKE LINE OF it_matloc_iso_tty , |
| it_matloct_tty | TYPE STANDARD TABLE OF FRE_BIF_MATLOCT_TTY,"TABLES PARAM |
| wa_matloct_tty | LIKE LINE OF it_matloct_tty , |
| it_layout_tty | TYPE STANDARD TABLE OF FRE_BIF_LAYOUT_TTY,"TABLES PARAM |
| wa_layout_tty | LIKE LINE OF it_layout_tty , |
| it_prodh | TYPE STANDARD TABLE OF FRE_BIF_PRODH_TTY,"TABLES PARAM |
| wa_prodh | LIKE LINE OF it_prodh , |
| it_locgrp_tty | TYPE STANDARD TABLE OF FRE_BIF_LOCGRP_TTY,"TABLES PARAM |
| wa_locgrp_tty | LIKE LINE OF it_locgrp_tty , |
| it_ekorg_assign_tty | TYPE STANDARD TABLE OF FRE_BIF_EKORG_ASS_TTY,"TABLES PARAM |
| wa_ekorg_assign_tty | LIKE LINE OF it_ekorg_assign_tty , |
| it_procyc_tty | TYPE STANDARD TABLE OF FRE_MD_PROCYC_TTY,"TABLES PARAM |
| wa_procyc_tty | LIKE LINE OF it_procyc_tty , |
| it_procyctxt_tty | TYPE STANDARD TABLE OF FRE_MD_PROCYCTXT_TTY,"TABLES PARAM |
| wa_procyctxt_tty | LIKE LINE OF it_procyctxt_tty , |
| it_difocc_tty | TYPE STANDARD TABLE OF FRE_BIF_DIFOCC_TTY,"TABLES PARAM |
| wa_difocc_tty | LIKE LINE OF it_difocc_tty , |
| it_difa_tty | TYPE STANDARD TABLE OF FRE_BIF_DIFA_TTY,"TABLES PARAM |
| wa_difa_tty | LIKE LINE OF it_difa_tty , |
| it_difocct_tty | TYPE STANDARD TABLE OF FRE_BIF_DIFOCCT_TTY,"TABLES PARAM |
| wa_difocct_tty | LIKE LINE OF it_difocct_tty , |
| it_abi_head_tty | TYPE STANDARD TABLE OF FRE_DB_ABI_HEAD_TTY,"TABLES PARAM |
| wa_abi_head_tty | LIKE LINE OF it_abi_head_tty , |
| it_abi_pos_tty | TYPE STANDARD TABLE OF FRE_DB_ABI_POS_TTY,"TABLES PARAM |
| wa_abi_pos_tty | LIKE LINE OF it_abi_pos_tty , |
| it_proprl_tty | TYPE STANDARD TABLE OF FRE_BIF_PROPRL_TTY,"TABLES PARAM |
| wa_proprl_tty | LIKE LINE OF it_proprl_tty , |
| it_proprlt_tty | TYPE STANDARD TABLE OF FRE_BIF_PROPRLT_TTY,"TABLES PARAM |
| wa_proprlt_tty | LIKE LINE OF it_proprlt_tty , |
| it_proprli_tty | TYPE STANDARD TABLE OF FRE_BIF_PROPRLI_TTY,"TABLES PARAM |
| wa_proprli_tty | LIKE LINE OF it_proprli_tty , |
| it_profas_tty | TYPE STANDARD TABLE OF FRE_BIF_PROPRLA_TTY,"TABLES PARAM |
| wa_profas_tty | LIKE LINE OF it_profas_tty , |
| it_laymod_tty | TYPE STANDARD TABLE OF FRE_BIF_BAPI_LAYOUT_TTY,"TABLES PARAM |
| wa_laymod_tty | LIKE LINE OF it_laymod_tty , |
| it_dif_no_sites_tty | TYPE STANDARD TABLE OF FRE_DIF_NO_SITES_TTY,"TABLES PARAM |
| wa_dif_no_sites_tty | LIKE LINE OF it_dif_no_sites_tty , |
| it_contract | TYPE STANDARD TABLE OF FRE_CONTRACT_51_TTY,"TABLES PARAM |
| wa_contract | LIKE LINE OF it_contract , |
| it_it_lane | TYPE STANDARD TABLE OF FRE_MD_LANE_TTY,"TABLES PARAM |
| wa_it_lane | LIKE LINE OF it_it_lane , |
| it_it_lane_td | TYPE STANDARD TABLE OF FRE_MD_LANE_TD_TTY,"TABLES PARAM |
| wa_it_lane_td | LIKE LINE OF it_it_lane_td , |
| it_it_pcost | TYPE STANDARD TABLE OF FRE_MD_PCOST_TTY,"TABLES PARAM |
| wa_it_pcost | LIKE LINE OF it_it_pcost , |
| it_it_sales_order | TYPE STANDARD TABLE OF STANDARD TABLE,"TABLES PARAM |
| wa_it_sales_order | LIKE LINE OF it_it_sales_order . |
The below ABAP code uses the older none in-line data declarations. This allows you to see the coding differences/benefits of the later inline syntax. It may also be useful if you are using an older version of SAP as some of the newer syntax above, such as the @DATA is not available until 4.70 EHP 8.
DATA:
| ld_ct_ts_tty | TYPE FRE_BIF_TSD_EXP_TTY , |
| it_header_if | TYPE STANDARD TABLE OF FRE_OP_HEADER_IF , |
| wa_header_if | LIKE LINE OF it_header_if, |
| ld_filename | TYPE CHAR30 , |
| it_item_if | TYPE STANDARD TABLE OF FRE_OP_ITEM_IF , |
| wa_item_if | LIKE LINE OF it_item_if, |
| ld_path_to_file | TYPE PATHINTERN , |
| ld_ct_subst_switch_tty | TYPE FRE_SUBST_SWITCH_IF_TTY , |
| ld_modus | TYPE FRE_MODUS , |
| ld_ct_lanetd_tty | TYPE FRE_MD_LANETD_TTY , |
| it_loc_tty | TYPE STANDARD TABLE OF FRE_BIF_LOC_TTY , |
| wa_loc_tty | LIKE LINE OF it_loc_tty, |
| ld_caller | TYPE FRE_CON_INTERFACE , |
| it_loct_tty | TYPE STANDARD TABLE OF FRE_BIF_LOCT_TTY , |
| wa_loct_tty | LIKE LINE OF it_loct_tty, |
| ld_ct_subst_assign_tty | TYPE FRE_SUBST_ASSIGN_IF_TTY , |
| it_locadr_iso_tty | TYPE STANDARD TABLE OF FRE_BIF_LOCADR_ISO_TTY , |
| wa_locadr_iso_tty | LIKE LINE OF it_locadr_iso_tty, |
| ld_ct_art_site | TYPE FRE_MD_ART_SITE_TTY , |
| ld_error | TYPE XFELD , |
| it_loctel_iso_tty | TYPE STANDARD TABLE OF FRE_BIF_LOCTEL_ISO_TTY , |
| wa_loctel_iso_tty | LIKE LINE OF it_loctel_iso_tty, |
| ld_session_id | TYPE CHAR15 , |
| ld_ct_art_site_td | TYPE FRE_MD_ART_SITE_TD_TTY , |
| ld_is_send_option | TYPE FRE_SEND_OPTION , |
| it_locfax_iso_tty | TYPE STANDARD TABLE OF FRE_BIF_LOCFAX_ISO_TTY , |
| wa_locfax_iso_tty | LIKE LINE OF it_locfax_iso_tty, |
| ld_no_tab_del | TYPE XFELD , |
| it_locsmtp_tty | TYPE STANDARD TABLE OF FRE_BIF_LOCSMTP_TTY , |
| wa_locsmtp_tty | LIKE LINE OF it_locsmtp_tty, |
| it_locuri_tty | TYPE STANDARD TABLE OF FRE_BIF_LOCURI_TTY , |
| wa_locuri_tty | LIKE LINE OF it_locuri_tty, |
| it_trprod2_tty | TYPE STANDARD TABLE OF FRE_MD_TRPROD2_TTY , |
| wa_trprod2_tty | LIKE LINE OF it_trprod2_tty, |
| it_trp2td_tty | TYPE STANDARD TABLE OF FRE_MD_TRP2TD_TTY , |
| wa_trp2td_tty | LIKE LINE OF it_trp2td_tty, |
| it_trprod_tty | TYPE STANDARD TABLE OF FRE_MD_TRPROD_TTY , |
| wa_trprod_tty | LIKE LINE OF it_trprod_tty, |
| it_tpsrc_tty | TYPE STANDARD TABLE OF FRE_MD_TPSRC_TTY , |
| wa_tpsrc_tty | LIKE LINE OF it_tpsrc_tty, |
| it_cscale_tty | TYPE STANDARD TABLE OF FRE_MD_CSCALE_TTY , |
| wa_cscale_tty | LIKE LINE OF it_cscale_tty, |
| it_matkey_iso_tty | TYPE STANDARD TABLE OF FRE_BIF_MATKEY_ISO_TTY , |
| wa_matkey_iso_tty | LIKE LINE OF it_matkey_iso_tty, |
| it_mattxt_iso_tty | TYPE STANDARD TABLE OF FRE_BIF_MATTXT_ISO_TTY , |
| wa_mattxt_iso_tty | LIKE LINE OF it_mattxt_iso_tty, |
| it_marm_iso_tty | TYPE STANDARD TABLE OF FRE_BIF_MARM_ISO_TTY , |
| wa_marm_iso_tty | LIKE LINE OF it_marm_iso_tty, |
| it_matloc_iso_tty | TYPE STANDARD TABLE OF FRE_BIF_MATLOC_ISO_TTY , |
| wa_matloc_iso_tty | LIKE LINE OF it_matloc_iso_tty, |
| it_matloct_tty | TYPE STANDARD TABLE OF FRE_BIF_MATLOCT_TTY , |
| wa_matloct_tty | LIKE LINE OF it_matloct_tty, |
| it_layout_tty | TYPE STANDARD TABLE OF FRE_BIF_LAYOUT_TTY , |
| wa_layout_tty | LIKE LINE OF it_layout_tty, |
| it_prodh | TYPE STANDARD TABLE OF FRE_BIF_PRODH_TTY , |
| wa_prodh | LIKE LINE OF it_prodh, |
| it_locgrp_tty | TYPE STANDARD TABLE OF FRE_BIF_LOCGRP_TTY , |
| wa_locgrp_tty | LIKE LINE OF it_locgrp_tty, |
| it_ekorg_assign_tty | TYPE STANDARD TABLE OF FRE_BIF_EKORG_ASS_TTY , |
| wa_ekorg_assign_tty | LIKE LINE OF it_ekorg_assign_tty, |
| it_procyc_tty | TYPE STANDARD TABLE OF FRE_MD_PROCYC_TTY , |
| wa_procyc_tty | LIKE LINE OF it_procyc_tty, |
| it_procyctxt_tty | TYPE STANDARD TABLE OF FRE_MD_PROCYCTXT_TTY , |
| wa_procyctxt_tty | LIKE LINE OF it_procyctxt_tty, |
| it_difocc_tty | TYPE STANDARD TABLE OF FRE_BIF_DIFOCC_TTY , |
| wa_difocc_tty | LIKE LINE OF it_difocc_tty, |
| it_difa_tty | TYPE STANDARD TABLE OF FRE_BIF_DIFA_TTY , |
| wa_difa_tty | LIKE LINE OF it_difa_tty, |
| it_difocct_tty | TYPE STANDARD TABLE OF FRE_BIF_DIFOCCT_TTY , |
| wa_difocct_tty | LIKE LINE OF it_difocct_tty, |
| it_abi_head_tty | TYPE STANDARD TABLE OF FRE_DB_ABI_HEAD_TTY , |
| wa_abi_head_tty | LIKE LINE OF it_abi_head_tty, |
| it_abi_pos_tty | TYPE STANDARD TABLE OF FRE_DB_ABI_POS_TTY , |
| wa_abi_pos_tty | LIKE LINE OF it_abi_pos_tty, |
| it_proprl_tty | TYPE STANDARD TABLE OF FRE_BIF_PROPRL_TTY , |
| wa_proprl_tty | LIKE LINE OF it_proprl_tty, |
| it_proprlt_tty | TYPE STANDARD TABLE OF FRE_BIF_PROPRLT_TTY , |
| wa_proprlt_tty | LIKE LINE OF it_proprlt_tty, |
| it_proprli_tty | TYPE STANDARD TABLE OF FRE_BIF_PROPRLI_TTY , |
| wa_proprli_tty | LIKE LINE OF it_proprli_tty, |
| it_profas_tty | TYPE STANDARD TABLE OF FRE_BIF_PROPRLA_TTY , |
| wa_profas_tty | LIKE LINE OF it_profas_tty, |
| it_laymod_tty | TYPE STANDARD TABLE OF FRE_BIF_BAPI_LAYOUT_TTY , |
| wa_laymod_tty | LIKE LINE OF it_laymod_tty, |
| it_dif_no_sites_tty | TYPE STANDARD TABLE OF FRE_DIF_NO_SITES_TTY , |
| wa_dif_no_sites_tty | LIKE LINE OF it_dif_no_sites_tty, |
| it_contract | TYPE STANDARD TABLE OF FRE_CONTRACT_51_TTY , |
| wa_contract | LIKE LINE OF it_contract, |
| it_it_lane | TYPE STANDARD TABLE OF FRE_MD_LANE_TTY , |
| wa_it_lane | LIKE LINE OF it_it_lane, |
| it_it_lane_td | TYPE STANDARD TABLE OF FRE_MD_LANE_TD_TTY , |
| wa_it_lane_td | LIKE LINE OF it_it_lane_td, |
| it_it_pcost | TYPE STANDARD TABLE OF FRE_MD_PCOST_TTY , |
| wa_it_pcost | LIKE LINE OF it_it_pcost, |
| it_it_sales_order | TYPE STANDARD TABLE OF STANDARD TABLE , |
| wa_it_sales_order | LIKE LINE OF it_it_sales_order. |
EXAMPLE
...See here for full SAP fm documentation
Please help keep this info upto date and use the comments section below to add useful hints, tips and information specific to this SAP function. This will then be available for you and other users to easily find by simply searching on the object name FRE_DATASET_READ_WRITE_DELETE or its description.
FRE_DATASET_READ_WRITE_DELETE - Write, read and delete Datasets FRE_CONVERT_TIMESTAMP_2_DATE - Converts Timestamp (15) into Date FRE_CONVERT_DATE_TO_TIMESTMP - Convert Date to Timestamp FRE_CONVERT_DATE_2_TIMESTAMP - Converts Date into Timestamp (15) FRE_CONTRACT_SEND - Transfer Contract Data to F&R FRE_CONTRACT_RESEND - Retransmission of Contract Data from Files