GET_AS_SPREADSHEET_TEXT SAP Method Transfer Table data into string for excel export









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

This is a private Method so can only be executed from within the class itself. I.e. You could access it from another method of the class.

This method is available within SAP systems depending on your version and release level, you can view further information by entering the class name CL_DPR_UI_LOG_RES_OVERVIEW 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 GET_AS_SPREADSHEET_TEXT can also be found below:

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


Parameters of Method GET_AS_SPREADSHEET_TEXT

.

NameTypeData TypeDescriptionDefault Value
IT_DIST_BUPAImportingTYPE
DPR_TT_API_BUPA_DIST		API: Table Type for Distribution to Bupa
IT_DIST_ROLEImportingTYPE
DPR_TT_API_PART_DIST		API: Table Type for Distribution to Role
IT_DIST_STAFFINGImportingTYPE
DPR_TT_API_BUPA_DIST		API: Table Type for Distribution to Bupa Link
IT_PERIODSImportingTYPE
DPR_TT_PERIODS		Time Frames
IT_TABLE_DATESImportingTYPE
DPR_TT_UI_RES_DATES		Table Data for Resource Overview Dates
IT_TABLE_DISTImportingTYPE
DPR_TT_UI_RES_DIST		UI structure for Resource view Distribution
IV_FORMATImportingTYPE
CHAR3		Format: CSV (Comma Separated); TAB (Tabulator Separated)
IV_PERIOD_FROMImportingTYPE
INT4		First visible period
IV_PERIOD_TOImportingTYPE
INT4		Last visible period
IV_VIEWImportingTYPE
STRING
IV_WITH_HEADERImportingTYPE
BOOLE_D		With Header
EV_TEXTExportingTYPE
STRING		Return as String



Exceptions of Method GET_AS_SPREADSHEET_TEXT

This method does not have any exceptions

Example ABAP coding

This is a private Method so the below code can only be executed from within the class itself. I.e. from another method of the class.

DATA: lo_class TYPE REF TO CL_DPR_UI_LOG_RES_OVERVIEW.
DATA: lv_EV_TEXT TYPE STRING,
lv_IT_DIST_BUPA TYPE DPR_TT_API_BUPA_DIST,
lv_IT_DIST_ROLE TYPE DPR_TT_API_PART_DIST,
lv_IT_DIST_STAFFING TYPE DPR_TT_API_BUPA_DIST,
lv_IT_PERIODS TYPE DPR_TT_PERIODS,
lv_IT_TABLE_DATES TYPE DPR_TT_UI_RES_DATES,
lv_IT_TABLE_DIST TYPE DPR_TT_UI_RES_DIST,
lv_IV_FORMAT TYPE CHAR3,
lv_IV_PERIOD_FROM TYPE INT4,
lv_IV_PERIOD_TO TYPE INT4,
lv_IV_VIEW TYPE STRING,
lv_IV_WITH_HEADER TYPE BOOLE_D,
lv_other TYPE c.

CALL METHOD lo_class=>GET_AS_SPREADSHEET_TEXT(
EXPORTING
IT_DIST_BUPA = lv_IT_DIST_BUPA
IT_DIST_ROLE = lv_IT_DIST_ROLE
IT_DIST_STAFFING = lv_IT_DIST_STAFFING
IT_PERIODS = lv_IT_PERIODS
IT_TABLE_DATES = lv_IT_TABLE_DATES
IT_TABLE_DIST = lv_IT_TABLE_DIST
IV_FORMAT = lv_IV_FORMAT
IV_PERIOD_FROM = lv_IV_PERIOD_FROM
IV_PERIOD_TO = lv_IV_PERIOD_TO
IV_VIEW = lv_IV_VIEW
IV_WITH_HEADER = lv_IV_WITH_HEADER
IMPORTING
EV_TEXT = lv_EV_TEXT ).

Links to Related Class(s)

CL_DPR_U...
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!