SAP ABAP Class CL_SD_RATES_TRANSFER_TOOL (Download/Upload LE Freight Rates)
Hierarchy
BBPCRM (Software Component) BBPCRM
   LE-TRA-FC (Application Component) Freight Processing
     VFSC (Package) Scales
Meta Relationship - Using
# Relationship type Using Short Description Created on
1 Interface implementation (CLASS c. INTERFACES i_ref)  IF_SD_RATES Constants Interface for Freight Processing 20131125
Properties
Class CL_SD_RATES_TRANSFER_TOOL  
Short Description Download/Upload LE Freight Rates    
Super Class    
Instantiability of a Class 0  Private 
Final    
General Data
Message Class    
Program status     
Category 0   
Package VFSC   Scales 
Created 20130422   SAP 
Last change 20140121   SAP 
Shared Memory-enabled    
Fixed point arithmetic    
Unicode checks active    
Forward declarations
# Type group / Object type Type Type Description
1 IF_SD_RATES Forward declaration interface (INTERFACE i DEFINITION DEF...  Forward declaration interface (INTERFACE i DEFINITION DEF...
2 SOI Type group use (TYPE-POOLS tp)  Type group use (TYPE-POOLS tp)
3 VFSC0 Type group use (TYPE-POOLS tp)  Type group use (TYPE-POOLS tp)
Interfaces
# Interface Abstract Final Description Created on
1 IF_SD_RATES Constants Interface for Freight Processing 20131125
Friends
Class CL_SD_RATES_TRANSFER_TOOL has no friend class.
Attributes
# Attribute Level Visibility Read only Typing Associated Type Initial Value Description Created on
1 LV_DATAB Instance attribute Private Type reference (TYPE) KODATAB Validity Start Date of the Condition Record 20131125
2 LV_DATBI Instance attribute Private Type reference (TYPE) KODATBI Validity End Date of the Condition Record 20131125
3 LV_ORIGIN Instance attribute Private Type reference (TYPE) STRING 20131125
4 MR_CONTAINER Instance attribute Private Object reference (TYPE REF TO) CL_GUI_CUSTOM_CONTAINER Container for Custom Controls in Screen Area 20131125
5 MR_CONTROL Instance attribute Private Object reference (TYPE REF TO) I_OI_CONTAINER_CONTROL Document Container Control Interface 20131125
6 MR_DOCUMENT Instance attribute Private Object reference (TYPE REF TO) I_OI_DOCUMENT_PROXY General Document Interface 20131125
7 MR_RATES_TRANSFER Static Attribute Private Object reference (TYPE REF TO) CL_SD_RATES_TRANSFER_TOOL Download/Upload LE Freight Rates 20131125
8 MR_SPREADSHEET Instance attribute Private Object reference (TYPE REF TO) I_OI_SPREADSHEET Spreadsheet Interface 20131125
9 MS_CELLS Instance attribute Private Type reference (TYPE) SOI_CELL_ITEM 20131125
10 MS_CUBE Instance attribute Private Type reference (TYPE) VFSC0_CUBED 20131125
11 MS_ERRORS Instance attribute Private Type reference (TYPE) IF_SD_RATES~TY_S_ERRORS 20131125
12 MS_FORMATTABLE Instance attribute Private Type reference (TYPE) SOI_FORMAT_ITEM 20131125
13 MS_RAN Instance attribute Private Type reference (TYPE) SOI_RANGE_ITEM 20131125
14 MS_RANGE_TABLE Instance attribute Private Type reference (TYPE) SOI_FULL_RANGE_ITEM 20131125
15 MS_SCALE_DESCRIPTION Instance attribute Private Type reference (TYPE) IF_SD_RATES~TY_S_SCALE_DESCRIPTION 20131125
16 MT_CELLS Instance attribute Private Type reference (TYPE) SOI_CELL_TABLE 20131125
17 MT_CONT Instance attribute Private Type reference (TYPE) SOI_GENERIC_TABLE 20131125
18 MT_CONT_IM Instance attribute Private Type reference (TYPE) SOI_GENERIC_TABLE 20131125
19 MT_DATA_ACCESS Instance attribute Private Type reference (TYPE) IF_SD_RATES~TY_T_DATA_ACCESS 20131125
20 MT_DATA_ACCESS_IM Instance attribute Private Type reference (TYPE) IF_SD_RATES~TY_T_DATA_ACCESS 20131125
21 MT_DATA_ADMIN Instance attribute Private Type reference (TYPE) IF_SD_RATES~TY_T_DATA_ADMIN 20131125
22 MT_DATA_ADMIN_IM Instance attribute Private Type reference (TYPE) IF_SD_RATES~TY_T_DATA_ADMIN 20131125
23 MT_DATA_DIM1 Instance attribute Private Type reference (TYPE) IF_SD_RATES~TY_T_DATA_DIM1 20131125
24 MT_DATA_DIM2 Instance attribute Private Type reference (TYPE) IF_SD_RATES~TY_T_DATA_DIM2 20131125
25 MT_DATA_PRICING Instance attribute Private Type reference (TYPE) IF_SD_RATES~TY_T_DATA_PRICING 20131125
26 MT_DIM2_SLFNR Instance attribute Private Type reference (TYPE) IF_SD_RATES~TY_T_DIM2_SLFNR 20131125
27 MT_ERRORS Instance attribute Private Type reference (TYPE) IF_SD_RATES~TY_T_ERRORS 20131125
28 MT_FORMATTABLE Instance attribute Private Type reference (TYPE) SOI_FORMAT_TABLE 20131125
29 MT_RAN Instance attribute Private Type reference (TYPE) SOI_RANGE_LIST 20131125
30 MT_RANGE_TABLE Instance attribute Private Type reference (TYPE) SOI_FULL_RANGE_TABLE 20131125
31 MT_RAN_IM Instance attribute Private Type reference (TYPE) SOI_RANGE_LIST 20131125
32 MT_RATES Instance attribute Private Type reference (TYPE) IF_SD_RATES~TY_T_RATES 20131125
33 MT_SCALE Instance attribute Private Type reference (TYPE) VFSC0_SCALED_TAB 20131125
34 MT_SCALE_DESCRIPTION Instance attribute Private Type reference (TYPE) IF_SD_RATES~TY_T_SCALE_DESCRIPTION 20131125
35 MT_WSEL Instance attribute Private Type reference (TYPE) IF_SD_RATES=>WSEL 20131125
Methods
# Method Level Visibility Method type Description Created on
1 DOWNLOAD_RATES Instance method Public Method Download Freight Rates to Excel 20131125
2 GET_ACCESS_SEQUENCE Instance method Public Method Determine Fields of Access Sequence 20131125
3 GET_ADMIN_DATA Instance method Public Method Determine Technical Data (KSCHL, KNUMH, and so on) 20131125
4 GET_INSTANCE Static method Public Method Create Instance 20131125
5 GET_PRICING_INFORMATION Instance method Public Method Determine General Data (Currency and so on) 20131125
6 GET_RATE_INFORMATION Instance method Public Method Determine Scale Information 20131125
7 GET_SCALE_BASE_DESCRIPTION Instance method Public Method Determine Name of Scales Bases 20131125
8 GET_SCALE_LEVELS_DIM1 Instance method Public Method Determine Scale Levels for First Dimension 20131125
9 GET_SCALE_LEVELS_DIM2 Instance method Public Method Determine Scale Levels for Second Dimension 20131125
10 GET_VALIDITY_PERIOD Instance method Public Method Get Validity Period for SD 20131125
11 MAP_DATA_FOR_EXPORT Instance method Public Method Collect Data for Export to Excel 20131125
12 MAP_DATA_FOR_IMPORT Instance method Public Method Collect Data for Import from Excel 20131125
13 OPEN_DOCUMENT Instance method Public Method Open Excel Document for Upload 20131125
14 REFRESH_VALIDITY_PERIOD Instance method Public Method Delete Validity Period 20131125
15 SAVE_DOCUMENT Instance method Public Method Save Excel Document 20131125
16 SET_DATA_INTO_EXCEL_SHEET Instance method Public Method Write Data to Excel 20131125
17 SET_FORMAT Instance method Public Method Define Format 20131125
18 SET_RATES_INTO_ABAP Instance method Public Method Copy Freight Rates 20131125
19 SET_SPREADSHEET_INTERFACE Instance method Public Method Create Excel Document 20131125
20 SET_VALIDITY_PERIOD Instance method Public Method Read Validity Period from Excel 20131125
21 UPLOAD_RATES Instance method Public Method Upload Freight Rates to Excel 20131125
22 VALIDATE_DATA Instance method Public Method Check Data Before Transfer 20131125
Events
Class CL_SD_RATES_TRANSFER_TOOL has no event.
Types
# Type Visibility Typing Associated Type Description Created on Type Source
1 CL_CONTAINER Public Object reference (TYPE REF TO) CL_GUI_CUSTOM_CONTAINER Container for Custom Controls in Screen Area 20131125
2 CL_CONTROL Public Object reference (TYPE REF TO) I_OI_CONTAINER_CONTROL Document Container Control Interface 20131125
3 CL_DOCUMENT Public Object reference (TYPE REF TO) I_OI_DOCUMENT_PROXY General Document Interface 20131125
4 IF_SPREADSHEET Public Object reference (TYPE REF TO) I_OI_SPREADSHEET Spreadsheet Interface 20131125
Method Signatures

Method DOWNLOAD_RATES Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Exporting ET_ERRORS Call by reference Type reference (TYPE) IF_SD_RATES~TY_T_ERRORS 20131125
2 Importing LR_CUBE Call by reference Type reference (TYPE) VFSC0_CUBED 20131125
3 Importing LT_SCALE Call by reference Type reference (TYPE) VFSC0_SCALED_TAB 20131125

Method DOWNLOAD_RATES on class CL_SD_RATES_TRANSFER_TOOL has no exception.

Method GET_ACCESS_SEQUENCE Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Exporting ET_ACCESS_DATA Call by reference Type reference (TYPE) IF_SD_RATES=>TY_T_DATA_ACCESS 20131125

Method GET_ACCESS_SEQUENCE on class CL_SD_RATES_TRANSFER_TOOL has no exception.

Method GET_ADMIN_DATA Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Exporting ET_ADMIN_DATA Call by reference Type reference (TYPE) IF_SD_RATES=>TY_T_DATA_ADMIN 20131125

Method GET_ADMIN_DATA on class CL_SD_RATES_TRANSFER_TOOL has no exception.

Method GET_INSTANCE Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Exporting ER_RATES_TRANSFER Call by reference Object reference (TYPE REF TO) CL_SD_RATES_TRANSFER_TOOL Down-/Upload von LE-Frachtraten 20131125

Method GET_INSTANCE on class CL_SD_RATES_TRANSFER_TOOL has no exception.

Method GET_PRICING_INFORMATION Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Exporting ET_PRICING_DATA Call by reference Type reference (TYPE) IF_SD_RATES=>TY_T_DATA_PRICING 20131125

Method GET_PRICING_INFORMATION on class CL_SD_RATES_TRANSFER_TOOL has no exception.

Method GET_RATE_INFORMATION Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing IT_SCALE_DATA Call by reference Type reference (TYPE) VFSC0_SCALED_TAB 20131125
2 Importing LR_CUBE_DATA Call by reference Type reference (TYPE) VFSC0_CUBED 20131125

Method GET_RATE_INFORMATION on class CL_SD_RATES_TRANSFER_TOOL has no exception.

Method GET_SCALE_BASE_DESCRIPTION Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Exporting ET_SCALE_DESCRIPTION Call by reference Type reference (TYPE) IF_SD_RATES=>TY_T_SCALE_DESCRIPTION 20131125

Method GET_SCALE_BASE_DESCRIPTION on class CL_SD_RATES_TRANSFER_TOOL has no exception.

Method GET_SCALE_LEVELS_DIM1 Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Exporting ET_ACCESS_DATA Call by reference Type reference (TYPE) IF_SD_RATES=>TY_T_DATA_ACCESS 20131125
2 Exporting ET_DIM1_DATA Call by reference Type reference (TYPE) IF_SD_RATES=>TY_T_DATA_DIM1 20131125

Method GET_SCALE_LEVELS_DIM1 on class CL_SD_RATES_TRANSFER_TOOL has no exception.

Method GET_SCALE_LEVELS_DIM2 Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Exporting ET_ACCESS_DATA Call by reference Type reference (TYPE) IF_SD_RATES=>TY_T_DATA_ACCESS 20131125
2 Exporting ET_DIM2_DATA Call by reference Type reference (TYPE) IF_SD_RATES=>TY_T_DATA_DIM2 20131125
3 Exporting ET_DIM2_SLFNR Call by reference Type reference (TYPE) IF_SD_RATES~TY_T_DIM2_SLFNR 20131125

Method GET_SCALE_LEVELS_DIM2 on class CL_SD_RATES_TRANSFER_TOOL has no exception.

Method GET_VALIDITY_PERIOD Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Exporting EV_DATAB Call by reference Type reference (TYPE) KODATAB Gültigkeitsbeginn des Konditionssatzes 20131125
2 Exporting EV_DATBI Call by reference Type reference (TYPE) KODATBI Gültigkeitsende des Konditionssatzes 20131125

Method GET_VALIDITY_PERIOD on class CL_SD_RATES_TRANSFER_TOOL has no exception.

Method MAP_DATA_FOR_EXPORT Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Exporting ET_CONT Call by reference Type reference (TYPE) SOI_GENERIC_TABLE 20131125
2 Exporting ET_RAN Call by reference Type reference (TYPE) SOI_RANGE_LIST 20131125
3 Exporting ET_RANGE_TABLE Call by reference Type reference (TYPE) SOI_FULL_RANGE_TABLE 20131125
4 Importing IT_DATA_ACCESS Call by reference Type reference (TYPE) IF_SD_RATES=>TY_T_DATA_ACCESS 20131125
5 Importing IT_DATA_ADMIN Call by reference Type reference (TYPE) IF_SD_RATES=>TY_T_DATA_ADMIN 20131125
6 Importing IT_DATA_DIM1 Call by reference Type reference (TYPE) IF_SD_RATES=>TY_T_DATA_DIM1 20131125
7 Importing IT_DATA_DIM2 Call by reference Type reference (TYPE) IF_SD_RATES=>TY_T_DATA_DIM2 20131125
8 Importing IT_DATA_PRICING Call by reference Type reference (TYPE) IF_SD_RATES=>TY_T_DATA_PRICING 20131125
9 Importing IT_SCALE_DESCRIPTION Call by reference Type reference (TYPE) IF_SD_RATES=>TY_T_SCALE_DESCRIPTION 20131125

Method MAP_DATA_FOR_EXPORT on class CL_SD_RATES_TRANSFER_TOOL has no exception.

Method MAP_DATA_FOR_IMPORT Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Exporting ET_RATES Call by reference Type reference (TYPE) IF_SD_RATES~TY_T_RATES 20131125
2 Importing IT_CONT_IM Call by reference Type reference (TYPE) SOI_GENERIC_TABLE 20131125
3 Importing IT_DATA_ACCESS Call by reference Type reference (TYPE) IF_SD_RATES~TY_T_DATA_ACCESS 20131125
4 Importing IT_DATA_ADMIN Call by reference Type reference (TYPE) IF_SD_RATES~TY_T_DATA_ADMIN 20131125
5 Importing IT_RAN_IM Call by reference Type reference (TYPE) SOI_RANGE_LIST 20131125

Method MAP_DATA_FOR_IMPORT on class CL_SD_RATES_TRANSFER_TOOL has no exception.

Method OPEN_DOCUMENT Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Exporting EV_FULLPATH Call by reference Type reference (TYPE) STRING 20131125

Method OPEN_DOCUMENT on class CL_SD_RATES_TRANSFER_TOOL has no exception.

Method REFRESH_VALIDITY_PERIOD Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Exporting EV_DATAB Call by reference Type reference (TYPE) KODATAB Gültigkeitsbeginn des Konditionssatzes 20131125
2 Exporting EV_DATBI Call by reference Type reference (TYPE) KODATBI Gültigkeitsende des Konditionssatzes 20131125

Method REFRESH_VALIDITY_PERIOD on class CL_SD_RATES_TRANSFER_TOOL has no exception.

Method SAVE_DOCUMENT Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing IM_CONTAINER Call by reference Object reference (TYPE REF TO) CL_GUI_CUSTOM_CONTAINER Container fuer Custom Controls in der Dynpro Area 20131125
2 Importing IM_CONTROL Call by reference Object reference (TYPE REF TO) I_OI_CONTAINER_CONTROL Document-Container-Control-Schnittstelle 20131125
3 Importing IM_DOCUMENT Call by reference Object reference (TYPE REF TO) I_OI_DOCUMENT_PROXY allgemeine Dokument-Schnittstelle 20131125

Method SAVE_DOCUMENT on class CL_SD_RATES_TRANSFER_TOOL has no exception.

Method SET_DATA_INTO_EXCEL_SHEET Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing IT_CELLS Call by reference Type reference (TYPE) SOI_CELL_TABLE 20131125
2 Importing IT_CONT Call by reference Type reference (TYPE) SOI_GENERIC_TABLE 20131125
3 Importing IT_FORMATTABLE Call by reference Type reference (TYPE) SOI_FORMAT_TABLE 20131125
4 Importing IT_RAN Call by reference Type reference (TYPE) SOI_RANGE_LIST 20131125
5 Importing IT_RANGETABLE Call by reference Type reference (TYPE) SOI_FULL_RANGE_TABLE 20131125
6 Importing IT_SPREADSHEET Call by reference Object reference (TYPE REF TO) I_OI_SPREADSHEET Tabellenschnittstelle 20131125

Method SET_DATA_INTO_EXCEL_SHEET on class CL_SD_RATES_TRANSFER_TOOL has no exception.

Method SET_FORMAT Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Exporting ET_CELLS Call by reference Type reference (TYPE) SOI_CELL_TABLE 20131125
2 Exporting ET_FORMATTABLE Call by reference Type reference (TYPE) SOI_FORMAT_TABLE 20131125
3 Importing IT_CONT Call by reference Type reference (TYPE) SOI_GENERIC_TABLE 20131125
4 Importing IT_RAN Call by reference Type reference (TYPE) SOI_RANGE_LIST 20131125
5 Importing IT_RANGE_TABLE Call by reference Type reference (TYPE) SOI_FULL_RANGE_TABLE 20131125

Method SET_FORMAT on class CL_SD_RATES_TRANSFER_TOOL has no exception.

Method SET_RATES_INTO_ABAP Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Exporting ET_WSEL Call by reference Type reference (TYPE) IF_SD_RATES~WSEL 20131125
2 Importing IT_RATES Call by reference Type reference (TYPE) IF_SD_RATES~TY_T_RATES 20131125

Method SET_RATES_INTO_ABAP on class CL_SD_RATES_TRANSFER_TOOL has no exception.

Method SET_SPREADSHEET_INTERFACE Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Exporting ET_CONTAINER Call by reference Object reference (TYPE REF TO) CL_GUI_CUSTOM_CONTAINER Container fuer Custom Controls in der Dynpro Area 20131125
2 Exporting ET_CONTROL Call by reference Object reference (TYPE REF TO) I_OI_CONTAINER_CONTROL Document-Container-Control-Schnittstelle 20131125
3 Exporting ET_DOCUMENT Call by reference Object reference (TYPE REF TO) I_OI_DOCUMENT_PROXY allgemeine Dokument-Schnittstelle 20131125
4 Exporting ET_SPREADSHEET Call by reference Object reference (TYPE REF TO) I_OI_SPREADSHEET Tabellenschnittstelle 20131125
5 Importing IV_ORIGIN Call by reference Type reference (TYPE) STRING 20131125

Method SET_SPREADSHEET_INTERFACE on class CL_SD_RATES_TRANSFER_TOOL has no exception.

Method SET_VALIDITY_PERIOD Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Exporting EV_DATAB Call by reference Type reference (TYPE) KODATAB Gültigkeitsbeginn des Konditionssatzes 20131125
2 Exporting EV_DATBI Call by reference Type reference (TYPE) KODATBI Gültigkeitsende des Konditionssatzes 20131125
3 Importing IT_DATA_ACCESS Call by reference Type reference (TYPE) IF_SD_RATES~TY_T_DATA_ACCESS 20131125
4 Importing IT_DATA_ACCESS_IM Call by reference Type reference (TYPE) IF_SD_RATES~TY_T_DATA_ACCESS 20131125

Method SET_VALIDITY_PERIOD on class CL_SD_RATES_TRANSFER_TOOL has no exception.

Method UPLOAD_RATES Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Changing CS_CUBE Call by reference Type reference (TYPE) VFSC0_CUBED 20131125
2 Changing CS_WSEL Call by reference Type reference (TYPE) IF_SD_RATES~WSEL 20131125
3 Exporting ET_ERRORS Call by reference Type reference (TYPE) IF_SD_RATES~TY_T_ERRORS 20131125
4 Importing LR_CUBE Call by reference Type reference (TYPE) VFSC0_CUBED 20131125
5 Importing LT_SCALE Call by reference Type reference (TYPE) VFSC0_SCALED_TAB 20131125

Method UPLOAD_RATES on class CL_SD_RATES_TRANSFER_TOOL has no exception.

Method VALIDATE_DATA Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing IT_DATA_ACCESS Call by reference Type reference (TYPE) IF_SD_RATES~TY_T_DATA_ACCESS 20131125
2 Importing IT_DATA_ACCESS_IM Call by reference Type reference (TYPE) IF_SD_RATES~TY_T_DATA_ACCESS 20131125
3 Importing IT_DATA_ADMIN Call by reference Type reference (TYPE) IF_SD_RATES~TY_T_DATA_ADMIN 20131125
4 Importing IT_DATA_ADMIN_IM Call by reference Type reference (TYPE) IF_SD_RATES~TY_T_DATA_ADMIN 20131125
5 Importing IT_DATA_DIM1 Call by reference Type reference (TYPE) IF_SD_RATES~TY_T_DATA_DIM1 20131125
6 Importing IT_DATA_DIM2 Call by reference Type reference (TYPE) IF_SD_RATES~TY_T_DATA_DIM2 20131125
7 Importing IT_RAN_IM Call by reference Type reference (TYPE) SOI_RANGE_LIST 20131125

Method VALIDATE_DATA on class CL_SD_RATES_TRANSFER_TOOL has no exception.
History
Last changed by/on SAP  20140121 
SAP Release Created in