[ABAP] Parameters of the XXL_FULL_API Function Module

Parameters of the XXL_FULL_API Function Module

Table Parameters

• List data DATA, any structure

• Please note that the data table can contain both rows and columns, which are not intended to be used in the list object. You can restrict the rows to be transferred with the parameters DATA_STARTING/ENDING_AT (see below). Which columns are transferred and in which order they are to appear in the list object, is controlled by table SEMA (see also
Table SEMA )
• Please note that the data table must not be transferred empty; it must always contain at least one row.

• Titles of the vertical keys VKEY

Number of the key column (INT2)

Text (domain SCRTEXT_L)

• Characteristics of the horizontal keys HKEY
  (see also
Table HKEY )

Hierarchy level (INT2)

Number of the column (INT2)

Text (domain SCRTEXT_L)

• Semantic information SEMA

Column number (INT2)

Type (C 3, value supply)

Standard aggregattion (C 3, value supply)

Origin of the column, i.e. number of the column in DATA (INT2)

Assigned currency column (from Release 2.1B)

• Printed texts PRINT_TEXT

HeaderFooter (C, value supply: H/F)

LeftCenterRight (C, value supply: L/C/R)

Line number (INT2)

Text (C 60)

• Online texts ONLINE_TEXT

Line number (INT2)

Key text (domain SCRTEXT_L)

Value text (C 60)

 

Scalar Input Parameters

• File name for the list object FILENAME (C 8)

• Title row HEADER_1 (C 60)

• Subtitle HEADER_2 (C 60)

• First row to be transferred in the data table DATA_STARTING_AT (N)

• Last row to be transferred in the data table DATA_ENDING_AT (N)

• By supplying the parameters DATA_STARTING/ENDING_AT it is possible to identify a range of consecutive lines in the data table. If one of the two parameters does not have its default value, only the range defined by the two values is transferred. Please note that the range to be transferred from the table DATA must not be empty. For the same reason, the data table as a whole must never be empty.

• No. of V keys N_VRT_KEYS (N)

• No. of H keys N_HRZ_KEYS (N)

• No. of attribute columns (i.e. columns in the actual data range) N_ATT_COLS (N)

• Switch for string conversions SEMA_TYPE (C, value supply: 'blank'/X)

• Default title for storing the list object in SAPoffice (domain SO_OBJ_DES)

• Flag to determine the default processing option NO_START (C, value supply: 'blank'/X)

• Flag to suppress the selection screen NO_DIALOG (C, value supply: 'blank'/X)

• If both NO_DIALOG = ‘X’ and NO_START = ‘X’, the selection screen of XXL is suppressed. The list object will automatically be stored in SAPoffice under the title determined by SO_TITLE (in case SO_TITLE is empty, an artificial title will be created). In every other combination of the two parameters (including the default one), the selection screen will be displayed. In this case, the value in NO_START will only determine which option is given as the default when the selection screen i displayed for the first time, whereas NO_DIALOG will have no effect at all.
• In case XXL_FULL_API is called during background processing, it behaves as if both NO_DIALOG = ‘X’ and NO_START = ‘X’.

 

ABAP/4 Dictionary Support

For most of the above fields, special data elements and domains were entered in the ABAP/4 Dictionary. The structures of the table parameters - except the table DATA - are stored in the ABAP/4 Dictionary. This means that the automatic checks and other services of the ABAP/4 Dictionary are available when programming the XXL connection.

The table parameter DATA is an exception. As the structure of this parameter is variable, no structure can be assigned.

Some fields of the XXL interface reference the ABAP/4 Dictionary domain SCRTEXT_L. This is the domain for the longest of the three standard key words, which the ABAP/4 Dictionary saves for each data element. Referencing this domain ensures that all the key words stored in the ABAP/4 Dictionary can be used as titles etc. in XXL list objects.

데이터 파일을 엑셀로 저장시 유용.
출처: SAP Help

DATA : BEGIN OF IT_DATA OCCURS 0,

         MATNR  LIKE  MARA-MATNR, “자재번호

         MAKTX  LIKE  MAKT-MAKTX, “SVC 품명

         LGPBE  LIKE  MARD-LGPBE, “저장 Bin

         FRLAB(20) TYPE C,        “접수처재고

         LGORT(20) TYPE C,        “청구저장위치

         GIREM(20) TYPE C,        “출고예정수량

       END OF IT_DATA.

DATA : XMPLT_O TYPE TABLE OF GXXLT_O WITH HEADER LINE,

       XMPLT_P TYPE TABLE OF GXXLT_P WITH HEADER LINE,

       XMPLT_H TYPE TABLE OF GXXLT_H WITH HEADER LINE,

       XMPLT_V TYPE TABLE OF GXXLT_V WITH HEADER LINE,

       XMPLT_S TYPE TABLE OF GXXLT_S WITH HEADER LINE.

XMPLT_V-COL_NO = 1 .

XMPLT_V-COL_NAME = '자재번호' .

APPEND XMPLT_V .

XMPLT_V-COL_NO = 2 .

XMPLT_V-COL_NAME = 'SVC품명' .

APPEND XMPLT_V .

XMPLT_V-COL_NO = 3 .

XMPLT_V-COL_NAME = '저장BIN' .

APPEND XMPLT_V .

XMPLT_V-COL_NO = 4 .

XMPLT_V-COL_NAME = '접수처재고' .

APPEND XMPLT_V .

XMPLT_V-COL_NO = 5 .

XMPLT_V-COL_NAME = '청구저장위치' .

APPEND XMPLT_V .

XMPLT_H-COL_NO = 1 .

XMPLT_H-ROW_NO = 1 .

XMPLT_H-COL_NAME = '출고예정수량' .

APPEND XMPLT_H .

XMPLT_S-COL_NO = 1 .

XMPLT_S-COL_TYP = 'STR' .

XMPLT_S-COL_OPS = 'DFT' .

XMPLT_S-COL_SRC = 0 .

XMPLT_S-COL_CUR = 0 .

APPEND XMPLT_S .

XMPLT_S-COL_NO = 2 .

XMPLT_S-COL_TYP = 'STR' .

XMPLT_S-COL_OPS = 'DFT' .

XMPLT_S-COL_SRC = 0 .

XMPLT_S-COL_CUR = 0 .

APPEND XMPLT_S .

XMPLT_S-COL_NO = 3 .

XMPLT_S-COL_TYP = 'STR' .

XMPLT_S-COL_OPS = 'DFT' .

XMPLT_S-COL_SRC = 0 .

XMPLT_S-COL_CUR = 0 .

APPEND XMPLT_S .

XMPLT_S-COL_NO = 4 .

XMPLT_S-COL_TYP = 'STR' .

XMPLT_S-COL_OPS = 'DFT' .

XMPLT_S-COL_SRC = 0 .

XMPLT_S-COL_CUR = 0 .

APPEND XMPLT_S .

XMPLT_S-COL_NO = 5 .

XMPLT_S-COL_TYP = 'STR' .

XMPLT_S-COL_OPS = 'DFT' .

XMPLT_S-COL_SRC = 0 .

XMPLT_S-COL_CUR = 0 .

APPEND XMPLT_S .

XMPLT_S-COL_NO = 6 .

XMPLT_S-COL_TYP = 'NUM' .

XMPLT_S-COL_OPS = 'ADD' .

XMPLT_S-COL_SRC = 0 .

XMPLT_S-COL_CUR = 0 .

APPEND XMPLT_S .

CALL FUNCTION 'XXL_FULL_API'

  EXPORTING

    N_VRT_KEYS        = 5

    N_ATT_COLS        = 1

    N_HRZ_KEYS        = 1

    SEMA_TYPE         = 'X'

    FILENAME          = 'TEST'

    HEADER_1          = 'DATA'

    HEADER_2          = 'PIVOT'

    NO_DIALOG         = ' '

  TABLES

    VKEY              = XMPLT_V

    HKEY              = XMPLT_H

    DATA              = IT_DATA

    SEMA              = XMPLT_S

    ONLINE_TEXT       = XMPLT_O

    PRINT_TEXT        = XMPLT_P

  EXCEPTIONS

    CANCELLED_BY_USER = 01

    DATA_TOO_BIG      = 02

    DIM_MISMATCH_DATA = 03

    DIM_MISMATCH_SEMA = 04

    DIM_MISMATCH_VKEY = 05

    ERROR_IN_HKEY     = 06

    ERROR_IN_SEMA     = 07

    FILE_OPEN_ERROR   = 08

    FILE_WRITE_ERROR  = 09

    OTHERS            = 10.

* 주의

※ COL_TYP

   - ‘STR’ : String

   - ‘DAT’ : Date

   - ‘MON’ : Month

   - ‘PCT’ : Percent

   - ‘NUM’ : Numeric

※ COL_OPS

   - ‘DFT’ : Default

   - ‘ADD’ : Additional

※ N_VRT_KEYS + N_ATT_COLS는 Internal Table의 Field 수와 동일해야 한다.