DOWNLOAD_TO_EXCEL SAP Method Download the RFQ to an excel









Below is documentation, parameters and attributes of ABAP Method DOWNLOAD_TO_EXCEL within SAP class /SCMTMS/CL_CARR_RFQ_EXCEL. There is also a number of example ABAP code snipts to help you use the functionality of this method.

This method is available within SAP systems depending on your version and release level, you can view further information by entering the class name /SCMTMS/CL_CARR_RFQ_EXCEL into the relevant SAP transactions such as SE24 or SE80, and then selecting the method you are interested in.


Method Type - Instance

This is an Instance Method so needs to be instantiated first before you can access any of the methods. I.e. you need to create a local variable of TYPE ref to the class.

The following technical details of method DOWNLOAD_TO_EXCEL can also be found below:

  • Importing parameters
  • Exporting parameters
  • Changing parameters
  • Returning parameters
  • Exceptions
  • Coding Examples


Parameters of Method DOWNLOAD_TO_EXCEL

.

NameTypeData TypeDescriptionDefault Value
IS_RFQ_KEYImportingTYPE
/BOBF/S_FRW_KEY
Node Key
IT_FAG_ITEMImportingTYPE
/SCMTMS/T_FAG_ITEMS_K
Filter the Agreement and RFQ items
IT_FAG_ITEM_KEYImportingTYPE
/BOBF/T_FRW_KEY
Filter the Agreement and RFQ items
IV_AWARD_CONFIRMATIONImportingTYPE
BOOLEAN
Boolean Variable (X=True, -=False, Space=Unknown)
IV_DISABLE_AGREEMENTImportingTYPE
BOOLEAN
Boolean Variable (X=True, -=False, Space=Unknown)
IV_DISABLE_DROPDOWNImportingTYPE
BOOLEAN
Boolean Variable (X=True, -=False, Space=Unknown)
IV_DOWNLOAD_CAPACITYImportingTYPE
BOOLEAN
Boolean Variable (X=True, -=False, Space=Unknown)
IV_DOWNLOAD_DESCRIPTIONImportingTYPE
BOOLEAN
Boolean Variable (X=True, -=False, Space=Unknown)
IV_DOWNLOAD_NOTESImportingTYPE
BOOLEAN
Boolean Variable (X=True, -=False, Space=Unknown)
IV_DOWNLOAD_OPTIONImportingTYPE
STRING
IV_FAG_RELEASEDImportingTYPE
BOOLEAN
Boolean Variable (X=True, -=False, Space=Unknown)
IV_MAINTAINED_RATEImportingTYPE
BOOLEAN
Boolean Variable (X=True, -=False, Space=Unknown)
IV_RATE_VALIDITY_PERIODImportingTYPE
STRING
Boolean Variable (X=True, -=False, Space=Unknown)
IV_EXCEL_FORMATImportingTYPE
/SCMTMS/CARRIER_EXCEL_FORMAT
Carrier Excel Format for RFQ
EO_CHANGEExportingTYPE REF TO
/BOBF/IF_TRA_CHANGE
Interface for transaction change objects
EO_MESSAGEExportingTYPE REF TO
/BOBF/IF_FRW_MESSAGE
Interface of Message Object
EV_DOC_IDExportingTYPE
STRING
EV_FILE_NAMEExportingTYPE
STRING
EV_REJECTED_AGREEMENTExportingTYPE
BOOLEAN
EV_REJECTED_CARR_RESPExportingTYPE
BOOLEAN
Boolean Variable (X=True, -=False, Space=Unknown)
EV_REJECTED_ITEM_NUMExportingTYPE
BOOLEAN
Boolean Variable (X=True, -=False, Space=Unknown)
EV_RESULTExportingTYPE
XSTRING
CO_EXCELChangingTYPE REF TO
/SCMTMS/CL_EXCEL07_ADAPTER
Excel 2007 adapter



Exceptions of Method DOWNLOAD_TO_EXCEL

DOWNLOAD_CANCELLED - Download cancelled by the user

Example ABAP coding


DATA: lo_class TYPE REF TO /SCMTMS/CL_CARR_RFQ_EXCEL.
DATA: lv_CO_EXCEL TYPE /SCMTMS/CL_EXCEL07_ADAPTER,
lv_EO_CHANGE TYPE /BOBF/IF_TRA_CHANGE,
lv_EO_MESSAGE TYPE /BOBF/IF_FRW_MESSAGE,
lv_EV_DOC_ID TYPE STRING,
lv_EV_FILE_NAME TYPE STRING,
lv_EV_REJECTED_AGREEMENT TYPE BOOLEAN,
lv_EV_REJECTED_CARR_RESP TYPE BOOLEAN,
lv_EV_REJECTED_ITEM_NUM TYPE BOOLEAN,
lv_EV_RESULT TYPE XSTRING,
lv_IS_RFQ_KEY TYPE /BOBF/S_FRW_KEY,
lv_IT_FAG_ITEM TYPE /SCMTMS/T_FAG_ITEMS_K,
lv_IT_FAG_ITEM_KEY TYPE /BOBF/T_FRW_KEY,
lv_IV_AWARD_CONFIRMATION TYPE BOOLEAN,
lv_IV_DISABLE_AGREEMENT TYPE BOOLEAN,
lv_IV_DISABLE_DROPDOWN TYPE BOOLEAN,
lv_IV_DOWNLOAD_CAPACITY TYPE BOOLEAN,
lv_IV_DOWNLOAD_DESCRIPTION TYPE BOOLEAN,
lv_IV_DOWNLOAD_NOTES TYPE BOOLEAN,
lv_IV_DOWNLOAD_OPTION TYPE STRING,
lv_IV_FAG_RELEASED TYPE BOOLEAN,
lv_IV_MAINTAINED_RATE TYPE BOOLEAN,
lv_IV_RATE_VALIDITY_PERIOD TYPE STRING,
lv_IV_EXCEL_FORMAT TYPE /SCMTMS/CARRIER_EXCEL_FORMAT,
lv_other TYPE c.

CALL METHOD lo_class=>DOWNLOAD_TO_EXCEL(
EXPORTING
IS_RFQ_KEY = lv_IS_RFQ_KEY
IT_FAG_ITEM = lv_IT_FAG_ITEM
IT_FAG_ITEM_KEY = lv_IT_FAG_ITEM_KEY
IV_AWARD_CONFIRMATION = lv_IV_AWARD_CONFIRMATION
IV_DISABLE_AGREEMENT = lv_IV_DISABLE_AGREEMENT
IV_DISABLE_DROPDOWN = lv_IV_DISABLE_DROPDOWN
IV_DOWNLOAD_CAPACITY = lv_IV_DOWNLOAD_CAPACITY
IV_DOWNLOAD_DESCRIPTION = lv_IV_DOWNLOAD_DESCRIPTION
IV_DOWNLOAD_NOTES = lv_IV_DOWNLOAD_NOTES
IV_DOWNLOAD_OPTION = lv_IV_DOWNLOAD_OPTION
IV_FAG_RELEASED = lv_IV_FAG_RELEASED
IV_MAINTAINED_RATE = lv_IV_MAINTAINED_RATE
IV_RATE_VALIDITY_PERIOD = lv_IV_RATE_VALIDITY_PERIOD
IV_EXCEL_FORMAT = lv_IV_EXCEL_FORMAT
IMPORTING
EO_CHANGE = lv_EO_CHANGE
EO_MESSAGE = lv_EO_MESSAGE
EV_DOC_ID = lv_EV_DOC_ID
EV_FILE_NAME = lv_EV_FILE_NAME
EV_REJECTED_AGREEMENT = lv_EV_REJECTED_AGREEMENT
EV_REJECTED_CARR_RESP = lv_EV_REJECTED_CARR_RESP
EV_REJECTED_ITEM_NUM = lv_EV_REJECTED_ITEM_NUM
EV_RESULT = lv_EV_RESULT
CHANGING
CO_EXCEL = lv_CO_EXCEL ).

Links to Related Class(s)

/SCMTMS/...
Full list of available SAP object classes

Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!