Field transport from screen to ABAP is delayed if you have a FIELD statement
Name equivalence is imperative for field transport between ABAP and screen
Field transport from ABAP to screen generally takes place before the first PBO module of the screen
For the screen fields from Dictionary tables or structures you need to create data object in ABAP using TABLES keyword
With Function Code 'E' causes program termination
On a screen always have a corresponding function key
In application toolbar always have corresponding function key
In application toolbar always have function code
Select single * into wa from tab. ………. EndSelect.
Select * from tab into it_tab.
Select * from tab into corresponding fields of wa. ......... EndSelect.
Select * from tab into table it_tab.
Select single * into corresponding fields of wa from tab
Select statement retrieves only one row from database
Select statement syntax is wrong, Select single should have been used
New line statement should be added to the write
In the where clause in operator should be used instead of =.
SAP System uses this Authorization concept for individual Database to provide access security.
Each application in SAP System is protected by Authorization.
Using Authorization critical data and parts of functional scope of the SAP system can be protected from unauthorized access
Authorizations are combined into profiles
If the user running the program does not have display access on 'AA' as defined in his profile, internal table it_sflight would be empty
If the user running the program does not have display access on 'AA' as defined in his profile, internal table it_sflight still would contain all records of carrier 'AA'
If the user running the report has 01,02, and 03 access to AA in his profile, then only the rows be fetched into the internal table
A database table can have more than one index.
A primary index consists of the primary key fields of the database table.
An Index can be assigned to several tables.
Using indexes speed up the data retrieval from table
Using Indexes speeds up the transaction process for the table.
All the records from spfli will be displayed in the list
No rows will be displayed as user haven't entered the value in selection screen
Instead of IN operator in where clause, if = operator is used it will display only one row
AT SELECTION-SCREEN OUTPUT
AT SELECTION-SCREEN INPUT
AT SELECTION-SCREEN ON REQUEST
By declaring same name data object in ZPROG and ZREP, as the name is same value gets automatically copied.
Using ABAP memory
By passing parameters using additions in submit statement e,g submit zrep with
Using SET/GET parameter ID
A key field in database table uniquely identifies the data record
A secondary index for non key fields generally works like a primary index of key fields
The client field is selective field and should always be specified in WHERE condition of SELECT statement
You can select from several tables using database view or joins in your program
OPEN SQL statement are converted into database specific statements by the database interface
A MESSAGE I ... statement
An AUTHORITY-CHECK statement which returns sy-subrc NE 0
A MESSAGE E .... statement.
With SELECT .... ENDSELECT access,at any particular time you have one data record maximum.
With SELECT .... INTO TABLE access, the result is 1 data record maximum.
With SELECT SINGLE * access, the result is 1 data record maximum
SELECT statement will always load data into SAP memory
SELECT statement supports the return code (sy-subrc)
Submit ... and return
Not possible, as the tools are only available for BASIS administrators
LEAVE SCREEN .
LEAVE TO SCREEN
The module must output an E type message or W message
The check module must be calling using : FIELD fileldname MODULE check_module
The check module must be calling using : FIELD fileldname MODULE check_module message Exxx
An I type message must be output
Yes, if at least one PAI module exist in subscreen container
Yes, if at least one required entry field exists on one of the tab pages
There is no way to do this; required entry fields must always be filled first
No special actions are required.
The "CANCEL" function must have function code "BACK"
The "CANCEL" function must be type "E" and be handled in a module with AT EXIT-COMMAND.
You must temporarily switch of the required entry of the field within LOOP at SCREEN.. ENDLOOP.
Module first AT EXIT-COMMAND
Field fname Module first ON INPUT
CHAIN. FIELDS: fnames Module first on CHAIN-REQUEST ENDCHAIN.
Field fname Module first ON REQUEST.
Statement LEAVE TO SCREEN is not allowed in Subscreens PBO/PAI
You can call subscreen using screen command CALL SUBSCREEN
You can call subscreen using ABAP command CALL SUBSCREEN
Subscreens have their own OK CODE field
An Internal table
Structured Work Area (line)
Generic Buffering is always done using generic keys
Generic keys can be any columns of the table
All fully buffered client dependent tables are generically buffered on mandt
All Fully buffered tables are generically buffered by primary key.
Generic keys for Generic buffering should be less than number of Primary Keys
If you have client independent table with one column as primary key, it is not possible to do generic buffering on such tables
Key Fields of text table
Key Fields of Primary Table
No Key Fields/Candidates
Field of the foreign key table to be checked is called Check field.
Field of the Primary Key Table is called check field.
For Check field and referenced key field Data Element should be exactly same.
For Check field and referenced key field Data Element can be different but domain should be exactly same.
If the table already contains data, this changes need to be executed first in the database by the database administrator, afterwards you can reactivate your table in ABAP dictionary
Type changes in Dictionary are only supported for key fields only, in case of non key fields such changes has to be done manually in database by the database administrator
If the table already contain data, SAP either make such changes using ALTER TABLE or using the conversion process
If the table does not contain any data, SAP drops and recreates the table with new definition
Outer Join View
Atleast one import parameter
Atleast one export parameter
One import and one export parameter minimum
Both import and export parameters are optional
Yes, however the table must be empty
Yes, irrespective of whether table has data or not
No, key changes are not allowed once activated
Search Help for Field, Check Table, Search Help for Dataelement
Search Help for Field, Check Table, Fixed Values
Process on Value-Request,Domain Fixed Value, check table
Check Table, Search help for Field, Search Help for Dataelement, Fixed Values