Ansicht
Dokumentation

BC430_FKEY_COMP - Comparison of Two Foreign Keys

BC430_FKEY_COMP - Comparison of Two Foreign Keys

CL_GUI_FRONTEND_SERVICES - Frontend Services   BAL_S_LOG - Application Log: Log header data  
This documentation is copyright by SAP AG.
SAP E-Book

Functionality

Compares two foreign keys. The function module is part of the course software for the course BC430 (ABAP Dictionary).

Two pairs are passed from the foreign key table and the check table. The system checks whether the relationship for both pairs is identical (that is, exists or does not exist for both pairs). It also checks whether or not the field assignment is structurally identically in both foreign keys - that is, whether identically-typed fields have been assigned. Generic and constant foreign key relationships are also taken into account here.

The following comments pertain to the use of the function module within the BC430 course environment.

Input parameter:

  • M_FS_TAB: Name of the predefined foreign key table.
  • M_PT_TAB: Name of the predefined check table.
  • T_FS_TAB: Name of the foreign key table created by the participant.
  • T_PT_TAB: Name of the check table for T_FS_TAB.

Exceptions:

  • T_TAB_NOT_ACTIVE: The participant's foreign key table is not active.
  • M_TAB_NOT_ACTIVE: The template is not active. This indicates that the course environment has not been set up correctly.
  • SYSTEM_INCONSISTENT: Error in the Dictionary interface (DDIF_TABL_GET). This exception should not occur.

Results returned in the ERRORS table:

The results of the comparison are written to the ERRORS table. If ERRORS is blank, the foreign keys match. Otherwise, the name of the participant's foreign key is stored in ERRORS-TABNAME; the cause of the error is stored in ERRORS-ERROR.

FK_NOT_EX: Participant's foreign key does not exist.

FK_STR_NOT_OK: The field assignment in the predefined foreign key is different from the one in the participant's foreign key. This may indicate, for example, that a field pair in one of the foreign keys is generic but not in the other. Alternatively, the check table in the predefined foreign key is structured differently than in the participant's check table (that is, if has differently-typed key fields or more or fewer key fields).

MUST_BE_TEXT: The template foreign key is a text foreign key but the participant's foreign key is not.

SHOULD_NOT_BE_TEXT: The participant's foreign key is a text foreign key, but the template's is not.

Example

Notes

This function module can only be used for training course purposes.

Further information

Documentation on the Report BC430_CHECK.





Parameters

ERRORS
M_FS_TAB
M_PT_TAB
T_FS_TAB
T_PT_TAB

Exceptions

M_TAB_NOT_ACTIVE
SYSTEM_INCONSISTENT
T_TAB_NOT_ACTIVE

Function Group

BC430

General Material Data   CL_GUI_FRONTEND_SERVICES - Frontend Services  
This documentation is copyright by SAP AG.

Length: 3089 Date: 20240523 Time: 172353     sap01-206 ( 58 ms )