Taw10_1

(1)

TAW10_ 1 1 of 161

MESSAGE Y123.

MESSAGE E123(9999).

MESSAGE ID 'AT' TYPE 'S' NUMBER 100 MESSAGE E123 by Fielda Fieldb

2 of 161

redundant data is not returned to the resultant set redundant data from the outer table is included run time error

redundant data from the inner table is included 3 of 161 data element domain values nothing

TAW 10_1

(2)

4 of 161

row count of the current line height of the current line width of the current line

size of vertical bars in your list 5 of 161

CARRIER CONNECTION FLIGHTDATE

10 AA FFF Jan 2 20 AA FFF Jan 3 30 DL FFF Jan 5 All rows will cause a break

20

30

NO rows will cause a break 6 of 161

REPORT ZPGM NO STANDARD PAGE HEADING. DO 8 TIMES. WRITE / ' '. ENDDO. SKIP. WRITE 'AAAA'. 9 2 1 10

(3)

7 of 161

The first field is mandt with a external data type CLNT and specified as a key field

Depends how Basis has configured the client The option 'Client Specified' is added to the Select

statement

The first field is mandt with a domain CLNT but not specified as a key field

8 of 161

(More than one answer is correct)

The primary index is automatically created when the table is activated

The key fields of the table make up the primary index

The primary index ID is designated by the Database Adminstrator

The developer designates the fields to be used as the primary index

9 of 161

All lists

Basic

(4)

10 of 161 fieldcat catalog alv_catalog lcv_t_fcat 11 of 161

Program A becomes active in the same internal session of Program B

Program B becomes active in the same internal session of Program A

User Context is flushed

Program B runs in a new internal session 12 of 161

(More than one answer is correct) Write: 'Hello'(001)

Write: TEXT-001

Write: 001(Hello) Write: TEXT-001'Hello'

(5)

13 of 161

Select * from mytable for all entries in my_itab

where key1 = my_itab-key1. Run time error

All entries are retrieved Only distinct values for key1 No entries are retrieved 14 of 161 Back Overtype Reserve Write:/ 1 15 of 161

Only 'Or' can be used as a logical operator in the ON condition

A Left Outer Join is not permitted in OPEN SQL A join statement is found to the right of the join

operator

At least one field frorm the table on the right is required for comparison in the ON condition

(6)

16 of 161

Consistent and flexible user interface

A method to access the data in a random manner Centrally defined authorization checks

Central performance improvements for update accesses

17 of 161

same data type only is required for check field and referenced field

all key fields MUST have domain equality between check table and foreign key table

same domain is required for check field and referenced field

same data element is required for check field and referenced field 18 of 161 Sales Order Country Keys Cost Centres Vendors

(7)

19 of 161

Header Label Length Fixed Values Type 20 of 161

Share the same roll area They run in their own roll area They run in the roll area of the caller

(8)

21 of 161

To insulate the ABAP/4 developer from the database

To provide data security at the application level To connect to the operating system

To support the creation and management of metadata

22 of 161

Users can access only the fields which are assigned to a functional group

A user master record is generated when the query is defined

SAP user can be assigned to only one user groups Functional Area can be a special view of a logical

database 23 of 161

SAP Memory

Tables

(9)

24 of 161

Insert ITAB

Append

Read Table ITAB

Select * into Table ITAB from dbtab.

Collect

25 of 161

No Standard Heading No Standard Page Heading Suppress Standard

System>List>Save 26 of 161

Page Number

User

Program title

Date

(10)

27 of 161

Data in the table is automatically deleted and must be reloaded

The table in the database is renamed and eventually deleted

The indexes for the table needs to manually be reconstructed in the ABAP Dictionary

The revised table in the ABAP/4 Dictionary is activated

The table in the database is recreated 28 of 161

Nothing, the data remains in the hidden area The hide data is restored to shared memory The Hide data is not available to the program It is transferred back to the fields defined in the

program 29 of 161

REPORT ZPGM1.

WRITE: 'Basic List: List Number =', SY-LSIND. AT LINE-SELECTION.

WRITE: 'Secondary List'. IF SY-LSIND = 2.

SY-LSIND = SY-LSIND - 1.

WRITE: 'SY-LSIND=’, SY-LSIND. ENDIF.

REPORT ZPGM2.

(11)

WRITE: 'SY-LSIND=’, SY-LSIND. REPORT ZPGM3.

WRITE: 'Secondary List'. IF SY-LSIND = 1.

WRITE: 'SY-LSIND=’, SY-LSIND. ENDIF.

ZPGM3

ZPGM2

ZPGM1

30 of 161

Data element documentation Domain short text

Search help

Domain Help values 31 of 161

Type S Function Codes Type T Functions Codes Normal Function Codes

(12)

32 of 161

Starting at Column 10, Row 20 Ending at Column 20, Row 30

Starting at Column 10, Row 30 Ending at Column 20, Row 20

Starting at Row 10, Column 20 Ending at Row 20, Column 30

33 of 161

Appends a new line

adds the numeric fields to an existing entry Creates a new entry

34 of 161

buffers are always used buffers are always bypassed

the choice can be made to use or bypass buffers 35 of 161

SUBMIT ZTST USING SELECTION-SET 'VAR1'

SUBMIT ZTST VIA SELECTION-SCREEN

SUBMIT ZTST AND RETURN

SUBMIT ZTST VIA SELECTION-SCREEN USING SELECTION-SET 'VAR1'

(13)

36 of 161

When you programatically increment it At the end of an interactive processing block At the beginning of an interactive processing block 37 of 161

Decimals must be defined in the domain The field must be numeric

The field must be linked to another field of type CUKY

No other requirement exists 38 of 161

For Global Master Data

When the most current data is not required When the most current data is required For Small Static non volatile tables 39 of 161

(More than one answer is correct) A view contains data

Maintenance Views are not updateable

A view is aurtomatically created on the database upon activation

(14)

40 of 161

SY-CUROW

SY-PAGNO

SY-CPAGE

SY-INDEX

41 of 161

When you activate a transparent table in the ABAP Workbench

When you create a transparent table

When Basis creates the tablespace at the OS layer When you activate a transparent table in the

Dictionary 42 of 161

The header line and contents of the internal table are stored

You cannot EXPORT an internal table with a header line.

Only the header line is stored

Only the contents of the internal table is stored 43 of 161

Scroll LIST Index 3 to Page 5 Scroll LIST sy-index 3 to Page 5 Scroll LIST sy-lsind 3 to Page 5 Scroll LIST 3 5

(15)

44 of 161 Get Initialization At Selection-Screen End-Of-Selection Put 45 of 161

Sort Itab Ascending

Sort ITAB

Sort ITAB BY (fieldname) Sort itab by keys

46 of 161

Read Table

Get node

Native SQL

ABAP/4 Open SQL

(16)

47 of 161 In Memory In an Internal Table SY-LISTI SY-LISEL 48 of 161

You can sort an extract dataset even without a header

The extract dataset is typically sorted in the Start-of-Selection processing block

The sequence of the control breaks in the Loop does not have to correspond to the extract dataset sort sequence

The extract dataset must be sorted for processing to begin

49 of 161

When the Top-Of-Page event is encountered in sequence

After Number of lines per page, as specified in the REPORT, have been wriiten to the list buffer When the report starts

(17)

50 of 161

Points to cluster tables

Indicates the nodes from the logical database Specifies the logical database

Sets up an address pointer to the nodes in the shared memory buffers

51 of 161

The program ends

The remainder of the current processing block is executed

The output list is displayed

the system leaves the processing block and

branches to the processing block of the next event. 52 of 161

The type of foreign key field defined must be "No Key /Candidates"

The key of the text table consists of the key of the check table plus an additional language key Cardinality must be defined as 1:1

53 of 161

Put

Read

Get

(18)

54 of 161

data is filtered in the sapgui

data is filtered at the application server data is filtered in the database

data is filtered on the network 55 of 161

Data: datum type d. Datum = sy-datum.

Write:/ datum mm/dd/yyyy.

01/15/1999

1999/01/15

19990115

1999.01.15

56 of 161

Begin of Block, End of Block

Begin of Selection, End of Selection Begin of Frame, End of Frame Begin of Box, End of Box 57 of 161

100

1000

1001

(19)

58 of 161

Add an elementary search help to the standard search help

Add a collective search help to the standard search help

Perform a modification to the standard search help Enhance the standard search help with an append

search help 59 of 161 S_Query S_Program S_Query_All S_Maintain 60 of 161 At Selection-Screen on sales. If sales-low < 500. Message E046. Endif.

Field Sales is open for input and all other fields are not available for input

The program ends

All fields are open for input and cursor is positioned on field sales

(20)

61 of 161

contains all entries from both tables contains all entries from the left table contains only entries that match

contains all entries from the right table 62 of 161 structured type table type structure table 63 of 161 Print Specifications Variant Language Mandatory Fields 64 of 161 LFA1,LFBK,LFB1.LFC1 LFA1, LFBK, LFB1 LFA1 and LFB1

(21)

65 of 161

Next time user signs on

Immediately, providing the object is activated After Database is re-organized

Next time program is re-generated 66 of 161 START-OF-SELECTION END-OF-SELECTION Initialization No Processing Block 67 of 161

NEW-PAGE PRINT ON

Function SET_PRINT_PARAMETERS

Function GET_PRINT_PARAMETERS

(22)

68 of 161

domain built-in type table type check table table field 69 of 161 administration data Export

restrict value range

Import

70 of 161

specify conditions in the WHERE clause

There is no way to omit records from the left table specify conditions in the ON clause

specify conditions in the FROM clause 71 of 161

T1

T3 from the dictionary

(23)

72 of 161

Program

Joined Tables

Sequential Data Set

LDB

Search Help

73 of 161

A Reporting Tool

A method to update data

Defintion of a Relational Data Model

An ABAP/4 Reading Program used to read and process data 74 of 161 Memory ID Parameter ID Value Default Parameter ID 75 of 161 SY-INDEX SY-LISTI SY-LSIND SY-TABIX

(24)

76 of 161

Buffering Data Class Field Name Size Category Status 77 of 161

(More than one answer is correct) It is an event

Requires at least one write statement before it can be executed

Increments the page counter Used to generate a blank page 78 of 161

At Selection-Screen on value-request for sales.

Call screen 100.

When the user presses F1, Screen 100 is displayed in addition to the normal help screen

When the user presses F1, Screen 100 is displayed instead of the normal possible values search help

When the user presses F4, Screen 100 is displayed instead of the normal possible values search help

When the user presses F4, Screen 100 is displayed in addition to the normal help screen

(25)

79 of 161

10 Report rpgm1

20 data: fielda type c value ‘A’,

30 fieldb type c value ‘B’. 40 write: / fielda,

50 new-page. 60 write: / fieldb

70 top-of-page. 80 write: / 'This is the title'.

40, 50, 60, 70, 80 40, 80, 50, 80, 60 80, 40, 50, 80, 60 80 of 161

Data Base Modify All database access Data Base Retrieval

Data Base Updates

81 of 161

Local File to the application server

SAPOFFICE

HTML Format on local PC

ABAP Editor

(26)

82 of 161

Initialization. ZFLIGHTS-CARRID = 'AA'. Start-of-Selection. ZFLIGHTS-CARRID = 'AA'. SELECT-OPTIONS AIRLINE FOR

ZFLIGHTS-CARRID MEMORY ID CAR.

SELECT-OPTIONS AIRLINE FOR ZFLIGHTS-CARRID DEFAULT 'AA'.

83 of 161

When the END GET statement is encountered When the next keyword event is encountered When all data has been retrieved for the Get After each PUT in the LDB

84 of 161

contains all entries from the left table

contains only entries that match in the on clause fields from unmatched rows in the right table are

null filled

fields from unmatched rows in the left table are null filled

(27)

85 of 161

The user interface allows actions to trigger interactive list type events

Corresponding interactive events are programmed The Hide command is programmed into the report 86 of 161

(More than one answer is correct) All secondary lists are deleted

The basic and secondary lists are deleted the basic list is overwritten with the current

secondary list

The original basic list is re-displayed 87 of 161 Input NO-GAP No-Zero As RadioBox Centered Under

(28)

87 of 161 Input NO-GAP No-Zero As RadioBox Centered Under 88 of 161

Table

Structure

Node

File

Complex Data Object

89 of 161

Program Execution Ends User sign off

Free Memory

(29)

89 of 161

Program Execution Ends User sign off

Free Memory

When you Flush the SPA/GPA memory 90 of 161 Statistics Ranked lists Percentage Basic lists 91 of 161

(More than one answer is correct) Double Click a line on a list Function Code P+

F2

Function Code PICK

Menu Option EDIT>Choose

(30)

92 of 161

SAP Memory is overwritten

ABAP memory sets up a new default area The ABAP memory is completely overwritten 93 of 161

DO. Read Line SY-INDEX. ENDDO. Read Line 3 of Current Page

Read Line 3 of Next Page

Read Current Line of Table ITAB 94 of 161

Tables

All of the answers are correct

Structures

Data Elements

(31)

95 of 161

Search Helps DB Program Tables Structure Selection Screen 96 of 161

One record of the check table is assigned to many records of the foreign key table

Many records of the check table are assigned to one record of the foreign key table

One record of the foreign key table is assigned to one record in the check table

97 of 161

When the database administrator physically creates the table

At the end of the table creation after it is saved When the table is activated

At the beginning of the table creation It does not correspond to an object in the

(32)

98 of 161 10 Start-of-Selection 20 End-of-Selection 30 Initialization 40 Get 50 At Selection-Screen 30 50 10 40 20 50 10 40 10 20 30 10 50 40 20 99 of 161 table table field type check table data element 100 of 161

_{Table Types}

_{Data Models}

_Structures

_{Data definitions}

(33)

101 of 161

_{Remove this record} _{function modules}

_{Parameter Ids}

_transactions

_{reports called with SUBMIT and Return} 102 of 161 ₁₀ _Unlimited ₉ ₁ 103 of 161

(More than one answer is correct) _{Used to create Footers}

Occurs when the page break has been triggered by the New-Page statement

Automatically creates a footer on the last page of a list

Works only if you reserve space in the Report Statement using the line-count statement

(34)

104 of 161

The variable appears on the current line as indicated by sy-linno

The system stores the field name and values for each field hidden

The fields are invisible and cannot be written to the list 105 of 161 _Insert _Append _{Delete Duplicates} _Collect 106 of 161

When explicitly changed using the Format statement

_{All answers are correct}

_{At any New Event}

_{Using the Reset option of the Format statement} 107 of 161

_{Your user defined Program Name}

_SAPMZF1S

_SAPDBF1S

(35)

108 of 161

The queries of a user group belong only to the person that created the query

The user can access only designated queries in a given user group

Users belonging to the same authorization group have the same query privilege

A Functional area can be assigned to several user groups

Several Functional areas can be assigned to one user group

109 of 161

(More than one answer is correct) _{Reading Secondary Lists} _{Reading the Basic List} _{Reading Database Tables} _{Reading Internal Tables} 110 of 161

_{When a table is linked to check tables} _{When a table is read infrequently}

When a table is read frequently and the data seldom changes

When a table is read frequently and the data is always changing

(36)

111 of 161 _Repository _{Data Element} _{Value Table} _Dictionary _Domain 112 of 161

_{Scroll List Left} _{Scroll List PS+<10>}

_{Set Left Scroll-Boundary Column 10} _{Set Right Scroll-Boundary Column 10} 113 of 161

_Line-Width

_Line-Count

_{Report Size}

(37)

114 of 161

Text elements cannot be used in a Write statement

_{The text element is missing from the program} Your logon language is different than the original

language

The text element does not contain the value 'Hello'

115 of 161

After the next data record for the same node is read and before all subordinate nodes have been processed

_{After the END GET}

_{At the end of all Get events}

After all subordinate nodes have been processed and before the next data record for the same node is read

(38)

116 of 161

_Low _Between _Option _High _Sign _Operator 117 of 161

An extract dataset may consist of records with different structures

More than one Extract Dataset is allowed per program

The Header Must be defined as one of the field groups

The field group HEADER is part of each extract record

Definition of a field group immediately reserves storage space for the fields

118 of 161

_T006

_TVAR

_TVARV

(39)

119 of 161 _{Data Statement} _{Program Attributes} _{Get Statement} _{Tables Statement} 120 of 161 _Top-of-page

_{Top-of-page During Line-Selection}

_New-page _{At line-selection} 121 of 161 _{in the dictionary} _{in work processes} _{in structures} _{in table "nametab"} 122 of 161

_{Data Models}

_Tables

_{Data Elements}

_{Documentation}

(40)

123 of 161

_{The Function Type is set to T} _{The Function Type is set to S} _{The Transaction Type is set to T} _{The Function Code is left blank} 124 of 161 DO 4 TIMES. IF SY-INDEX = 2. CONTINUE. ENDIF. WRITE SY-INDEX. ENDDO. _{1 3 4} ₂ _{1 2 3 4} 125 of 161

When the database administrator physically creates the table

_{At the end of the table creation after it is saved.} _{When the table is activated}

_{At the beginning of the table creation} It does not correspond to an object in the

(41)

126 of 161

report ztest. …

Data: begin of itab_structure,

carrier like sflight-carrid, connection like sflight-connid, seats like sflight-seatsmax, end of itab_stucture.

Data: itab type standard table of itab_structure with header line.

loop at itab. at new carrier. sum. endat. endloop. AAFFF10 *****30 AAFFF30 AA***30 127 of 161

_{After Initialization event} _{Prior to Initialization event} _{Before the Report Statement} _{At Start-of-Selection event}

(42)

128 of 161

_{Views are not created with the dictionary} _{a view named v_zmyview}

_{Views do not get created on the database}

_{a view named zmyview}

129 of 161

The STRUCTURES statement is used to define a structure in a program

Structures contain data beyond the runtime of a program.

The TABLES statement is used to define a structure in a program

A physical database table is created for a structure 130 of 161 _SY-UCOMM _SY-KEY _SY-GUI _SY-FCODE

(43)

131 of 161 _{List Status} _{Dialog Box} _{Context Menu} _{Online Status} 132 of 161 report rsbbb11b. Tables: zmytab. data: F1. F1 = ‘1’.

submit RSCCC11D and Return.

export F1 zmytab to memory id 'XYZ'.

report rsccc11d. Tables: zmytab. data: F1. _SPACE ₂ ₁

_{Run Time Error will occur} 133 of 161

Buffering can be turned off on the application server by the programmer using the ABAP Workbench

Add the BYPASSING BUFFER clause on the select statement

(44)

134 of 161 _{Master Data} _{Organizational Data} _{System data} _{Project Data} 135 of 161

The selection screen will not display selection criteria for the higher tables

The selection screen will display selection criteria for the higher tables

The selection screen will display selection criteria for the higher tables at the time of the Get for the lower level tables

The selection screen will display selection criteria for the higher tables only if you issue a Get for the higher level table

136 of 161

_{In Screens only}

_{When a SQL Insert is performed} _{When a SQL Update is performed} _{When user presses F1 - Technical info}

(45)

137 of 161

_{New-Page followed by a Write}

Line Count is exceeded as defined in the Report statement

_{Double Click on the line}

_{The first encountered Write Statement} 138 of 161

_{Ranked lists} _Statistics _{Basic lists} _{Select Lists} _Summary 139 of 161

_SY-LINSZ

_SY-TITLE

_SY-LINNO

_SY-COLNO

(46)

140 of 161

_{As much as the roll area allows}

₂₀

_Unlimited

₁₀

141 of 161

Any Node that is accessed requires the Node to be defined in the NODES statement

The Put Statement in the LDB provides data for the Get Event in the report program

Get Event in the report program requests data from the Put Statement

You can access hierarchically higher tables in your program even though there is no tables statement for the table

142 of 161

_{Random Function Keys}

_{Suggested Function Keys}

_{Recommended Function Keys}

_{Freely Assigned Function Keys} _{Reserved Function Keys}

(47)

143 of 161

_{The Functional Area}

The tables for which a corresponding Node statement exists

_{The nodes in the Selections Include Program} _{The Parameters defined in the report program} 144 of

161

10 get spfli

20 * Processing of SPFLI records

30 write: spfli-carrid, spfli-connid. 40 counter = counter + 1.

60 if counter > 1.

70 stop.

81 endif.

90 write:/ 'No more processing for this carrier' 100 get sflight

110 write: sflight-fldate, spfli-price 120 end-of-selection.

130 write: / text-002, text-003.

130

100

120

(48)

145 of 161

_X

_Space

₁

₀

_{Any Alpha Character} 146 of 161

_{Transparent Table} _{Internal table} _View _Structure 147 of 161 _{Standard Toolbar} _{Menu Bar} _{Application Toolbar} _{Title Bar}

(49)

148 of 161

_{Admin data} _DPOS _SPOS _LPOS _{Value Range} 149 of 161

_{Call Function}

_Submit

_{Call Transaction} _{Leave To Transaction} 150 of 161

_{Small Static tables} _{Internal Tables} _{Transaction Tables} _{Tables with generic Keys}

(50)

151 of 161

_SY-LSIND

_{None of the answers are correct}

_SY-LISEL

_SY-LINNO

152 of 161

10 get spfli.

20 * Processing of SPFLI records

30 write: spfli-carrid, spfli-connid. 40 counter = counter + 1.

60 if counter > 1. 70 Exit.

80 endif.

90 write:/ ‘No more processing for this Carrier' .

100 get sflight.

110 write: sflight-fldate, spfli-price. 120 end-of-selection.

130 write: / text-002, text-003.

80

Exits the Program

120

100

(51)

153 of 161

_{the interface of the search help} _{dialog behaviour}

_{user master record parameters}

the selection method that determines the values to be displayed 154 of 161 _{Access Type} _{Key Defintion} _{Key Uniqueness} _{Key length} 155 of 161

When the standard tables are activated, the append structure is automatically appended to the standard table

All append structures are deleted. A new append structure must be created and then appended to the standard table

The append fields are automatically appended to the table upon activation but you must still convert the table

The standard table is returned to

standard.Therefore, the append structure must be manually re-applied

(52)

156 of 161 _Top-of-Page _{Start-of-Selection} _{At Line-Selection} _{At Selection-Screen} 157 of 161

Check table fields can accept only values which exist in the check table

Foreign key fields can accept any values regardless of the check table

Foreign key fields can accept only values which exist in the check table

158 of 161 _{Database View} _{Transparent Table} _SearchHelp _{Help Query} 159 of 161 _{S_NODE} _{S_PROGRAM} _{S_EXECUTE} _{S_DEVELOP} _{S_TREE}

(53)

160 of 161 _{Business Object} _{Semantic Domain} _{Physical Definition} _{Technical Domain} 161 of 161

REPORT ZTEST LINE-SIZE 0.

_{This will produce a syntax check} _{You will have to program scrolling} _{No Lines are written to a report}