CUTS_TABLE_SELECT_SINGLE SAP Function module

CUTS_TABLE_SELECT_SINGLE 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 CUTS_TABLE_SELECT_SINGLE into the relevant SAP transaction such as SE37 or SE80.

Associated Function Group: CUTS
Released Date: Not Released
Processing type: Normal fucntion module

Pattern for FM CUTS_TABLE_SELECT_SINGLE - CUTS TABLE SELECT SINGLE

CALL FUNCTION 'CUTS_TABLE_SELECT_SINGLE' "
  EXPORTING
    table =                     " cuvtab-vtint
    date =                      " sy-datum
  TABLES
    query =                     " cusl_01
    match =                     " cusl_02
  EXCEPTIONS
    NOT_FOUND = 1               "
    NO_CHARACTERISTICS = 2      "
    NO_QUERY = 3                "
    NO_ENTRY_FOUND = 4          "
    MULT_ENTRIES_FOUND = 5      "
    INTERNAL_ERROR = 6          "
    DERIVATION_UNDEFINED = 7    "
    .  "  CUTS_TABLE_SELECT_SINGLE

ABAP code example for Function Module CUTS_TABLE_SELECT_SINGLE

The ABAP code below is a full code listing to execute function module CUTS_TABLE_SELECT_SINGLE 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).

DATA:
it_query  
 
 TYPE STANDARD TABLE OF CUSL_01,"TABLES PARAM
wa_query
 
 LIKE LINE OF it_query
,
it_match  
 
 TYPE STANDARD TABLE OF CUSL_02,"TABLES PARAM
wa_match
 
 LIKE LINE OF it_match
.

 

SELECT single VTINT 
  FROM CUVTAB 
  INTO @DATA(ld_table).


DATA(ld_date) = '20210129'.
 

"populate fields of struture and append to itab
append wa_query to it_query.
 

"populate fields of struture and append to itab
append wa_match to it_match.
.

CALL FUNCTION 'CUTS_TABLE_SELECT_SINGLE'
  EXPORTING
    table =                      ld_table
    date =                       ld_date
  TABLES
    query =                      it_query
    match =                      it_match
  EXCEPTIONS
    NOT_FOUND =                  1
    NO_CHARACTERISTICS =         2
    NO_QUERY =                   3
    NO_ENTRY_FOUND =             4
    MULT_ENTRIES_FOUND =         5
    INTERNAL_ERROR =             6
    DERIVATION_UNDEFINED =       7
    .  "  CUTS_TABLE_SELECT_SINGLE

IF SY-SUBRC EQ 0.
  "All OK
ELSEIF SY-SUBRC EQ 1. "Exception
  "Add code for exception here
ELSEIF SY-SUBRC EQ 2. "Exception
  "Add code for exception here
ELSEIF SY-SUBRC EQ 3. "Exception
  "Add code for exception here
ELSEIF SY-SUBRC EQ 4. "Exception
  "Add code for exception here
ELSEIF SY-SUBRC EQ 5. "Exception
  "Add code for exception here
ELSEIF SY-SUBRC EQ 6. "Exception
  "Add code for exception here
ELSEIF SY-SUBRC EQ 7. "Exception
  "Add code for exception here
ENDIF.

ABAP code to compare 7.40 inline data declaration with original syntax

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_table
 
 TYPE CUVTAB-VTINT ,
it_query
 
 TYPE STANDARD TABLE OF CUSL_01 ,
wa_query
 
 LIKE LINE OF it_query,
ld_date
 
 TYPE SY-DATUM ,
it_match
 
 TYPE STANDARD TABLE OF CUSL_02 ,
wa_match
 
 LIKE LINE OF it_match.



SELECT single VTINT 
  FROM CUVTAB 
  INTO ld_table.
 

"populate fields of struture and append to itab
append wa_query to it_query.
ld_date = '20210129'. 

"populate fields of struture and append to itab
append wa_match to it_match.