SAP Function Modules

comments icon Comments

DD_FKEYS_GET SAP Function module - Determines the current valid foreign key for a table







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

Associated Function Group: SINT
Released Date: Not Released
Processing type: Normal fucntion module
Normal function module settings


Pattern for FM DD_FKEYS_GET - DD FKEYS GET 





CALL FUNCTION 'DD_FKEYS_GET' "Determines the current valid foreign key for a table
  EXPORTING
    name =                      " dcobjdef-name  Table Name
*   state = 'A'                 " dcobjdef-state  Read status
*   langu = ' '                 " sy-langu
* TABLES
*   dd03p_tab =                 " dd03p
*   dd05m_tab =                 " dd05m         Foreign key fields of the table
*   dd08v_tab =                 " dd08v
  EXCEPTIONS
    ILLEGAL_INPUT = 1           "               Value not allowed for parameter
    NOT_FOUND = 2               "               Table does not exist in the ABAP Dictionary
    EXPAND_FAILURE = 3          "
    .  "  DD_FKEYS_GET

ABAP code example for Function Module DD_FKEYS_GET





The ABAP code below is a full code listing to execute function module DD_FKEYS_GET 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_dd03p_tab    TYPE STANDARD TABLE OF DD03P,"TABLES PARAM
wa_dd03p_tab  LIKE LINE OF it_dd03p_tab
,
it_dd05m_tab    TYPE STANDARD TABLE OF DD05M,"TABLES PARAM
wa_dd05m_tab  LIKE LINE OF it_dd05m_tab
,
it_dd08v_tab    TYPE STANDARD TABLE OF DD08V,"TABLES PARAM
wa_dd08v_tab  LIKE LINE OF it_dd08v_tab
.





DATA(ld_name) = some text here


DATA(ld_state) = some text here

DATA(ld_langu) = 'Check type of data required'.
 

"populate fields of struture and append to itab
append wa_dd03p_tab to it_dd03p_tab.
 

"populate fields of struture and append to itab
append wa_dd05m_tab to it_dd05m_tab.
 

"populate fields of struture and append to itab
append wa_dd08v_tab to it_dd08v_tab.
.

CALL FUNCTION 'DD_FKEYS_GET'
  EXPORTING
    name =                       ld_name
*   state =                      ld_state
*   langu =                      ld_langu
* TABLES
*   dd03p_tab =                  it_dd03p_tab
*   dd05m_tab =                  it_dd05m_tab
*   dd08v_tab =                  it_dd08v_tab
  EXCEPTIONS
    ILLEGAL_INPUT =              1
    NOT_FOUND =                  2
    EXPAND_FAILURE =             3
    .  "  DD_FKEYS_GET

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
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_name  TYPE DCOBJDEF-NAME ,
it_dd03p_tab  TYPE STANDARD TABLE OF DD03P ,
wa_dd03p_tab  LIKE LINE OF it_dd03p_tab,
ld_state  TYPE DCOBJDEF-STATE ,
it_dd05m_tab  TYPE STANDARD TABLE OF DD05M ,
wa_dd05m_tab  LIKE LINE OF it_dd05m_tab,
ld_langu  TYPE SY-LANGU ,
it_dd08v_tab  TYPE STANDARD TABLE OF DD08V ,
wa_dd08v_tab  LIKE LINE OF it_dd08v_tab.





ld_name = some text here 

"populate fields of struture and append to itab
append wa_dd03p_tab to it_dd03p_tab.

ld_state = some text here 

"populate fields of struture and append to itab
append wa_dd05m_tab to it_dd05m_tab.
ld_langu = 'Check type of data required'. 

"populate fields of struture and append to itab
append wa_dd08v_tab to it_dd08v_tab.

Contribute (Add Comments)

Please help keep this info upto date and use the comments section below to add useful hints, tips and information specific to this SAP function. This will then be available for you and other users to easily find by simply searching on the object name DD_FKEYS_GET or its description.


   
 

DD_FKEYS_GET - Determines the current valid foreign key for a table
DD_FIELDINFO_SET_GET - 
DD_F4_START_INIT_INDX - 
DD_F4_INIT_INDX - 
DD_F4_GET_TRIGGER_BODY - 
DD_F4_GET_TABLE_TRIGGER -