MANDATORY TABLE

1. If a table does not have MANDT as part of the primary key, it is ____.

A: A structure

B: Invalid

C: Client-independent

D: Not mandatory

When you create a field in ABAP whether it’s using SELECT-OPTIONS or PARAMETERS and want to make the field to be mandatory, then you can use the keywords WITH OBLIGATORY.

Here’s the ABAP sample code to implement this keyword.

Z_REPORT_MANDATORY_FIELD.

tables:
kna1.

data:
t_kna1 type TABLE OF kna1 WITH HEADER LINE.

SELECT-OPTIONS:
p_kunnr for kna1-kunnr OBLIGATORY.

START-OF-SELECTION.

select * into table t_kna1 from kna1 where
kunnr in p_kunnr.

LOOP AT t_kna1.

WRITE :/ t_kna1-name1, t_kna1-land1.

ENDLOOP.

When you run the program and execute it without selecting the KUNNR field then it will prompt you the message to “Fill in all required entry fields”

Definition: The primary key of a relational table uniquely identifies each record in the table. It can either be a normal attribute that is guaranteed to be unique (such as Social Security Number in a table with no more than one record per person) or it can be generated by the DBMS (such as a globally unique identifier, or GUID, in Microsoft SQL Server). Primary keys may consist of a single attribute or multiple attributes in combination.

Confused? Feel free to ask

Your feedback is always appreciated.I will try to reply Ur queries as soon as time allows.
Regards,
SAPhelpdesk