plz check

[Former Member]

hii,

please help me to solve this Q.s

good answers rewarded points.

thank u.

sweta.

1.Diff between matchcode & search help?

2.have u used parameter id in data dictionary? why?

3.how u define currency & qty fields in ddic? why u r using ref field & ref table?

4.whats u r roles& responsibilities?

5.explain about secondary indexes? have u worked? why?

6.value table?

7.whether variants ask for request or not? how u transport varients?

8. is it possible to transport z tables? if ...why?

9.luw concept?

10.how u upload excel flat file in int table?

11.how u execute the at exit command?

[Former Member]

hii,

please help me to solve this Q.s

good answers rewarded points.

thank u.

sweta.

1.Diff between matchcode & search help?

2.have u used parameter id in data dictionary? why?

3.how u define currency & qty fields in ddic? why u r using ref field & ref table?

4.whats u r roles& responsibilities?

5.explain about secondary indexes? have u worked? why?

6.value table?

7.whether variants ask for request or not? how u transport varients?

8. is it possible to transport z tables? if ...why?

9.luw concept?

10.how u upload excel flat file in int table?

11.how u execute the at exit command?

[Former Member]

hi,

<b>1.Diff between matchcode & search help?</b>

Matchcode is used to search for the details of something using a field which may not be the key values...For eg:

Suppose that I want to get the details of an employees...I don't remember all the employee numbers, but I know the employee names(which may not be a key value)... So searching for details using values which are not the key fields, you can use matchcode..

But in search helps, you can use any field for searching for values..

2<b>.have u used parameter id in data dictionary? why?</b>

Theory

To fill the input fields of a called transaction with data from the calling program, you can use the SPA/GPA technique. SPA/GPA parameters are values that the system stores in the global, user-specific SAP memory. SAP memory allows you to pass values between programs. A user can access the values stored in the SAP memory during one terminal session for all parallel sessions. Each SPA/GPA parameter is identified by a 20-character code. You can maintain them in the Repository Browser in the ABAP Workbench. The values in SPA/GPA parameters are user-specific.

ABAP programs can access the parameters using the SET PARAMETER and GET PARAMETER statements.

To fill one, use:

SET PARAMETER ID <pid> FIELD <f>.

This statement saves the contents of field <f> under the ID <pid> in the SAP memory. The code <pid> can be up to 20 characters long. If there was already a value stored under <pid>, this statement overwrites it. If the ID <pid> does not exist, double-click <pid> in the ABAP Editor to create a new parameter object.

To read an SPA/GPA parameter, use:

GET PARAMETER ID <pid> FIELD <f>.

Example.

DATA REPID like sy-repid VALUE 'RSPFPAR'.

SET PARAMETER ID 'RID' FIELD REPID.

In another program

Data f like sy-repid.

GET PARAMETER ID rid FIELD f.

The HIDE Technique

You use the HIDE technique while creating a list level to store line-specific information for later use. To do so, use the HIDE statement as follows:

HIDE <f>.

This statement places the contents of the variable <f> for the current output line (system field SYLINNO) into the HIDE area. The variable <f> must not necessarily appear on the current line. To make your program more readable, always place the HIDE statement directly after the output statement for the variable <f> or after the last output statement for the current line.

As soon as the user selects a line for which you stored HIDE fields, the system fills the variables in the program with the values stored. A line can be selected

by an interactive event.

For each interactive event, the HIDE fields of the line on which the cursor is positioned during the event are filled with the stored values.

by the READ LINE statement.

You can think of the HIDE area as a table, in which the system stores the names and values of all HIDE fields for each list and line number. As soon as they are needed, the system reads the values from the table.

<b>3.how u define currency & qty fields in ddic?</b>

currency / quantity fields allow to manipulate data according to their units or metric system used.

for instance if one field is in kgs and other in grams, if u specify dat dis is a quantity field den based on the knowlegde dey will be added.dat is after conversion of grams inot kgs or viceversa.same is with currency...

<b>5.explain about secondary indexes? have u worked? why?</b>

Under Indexes, you can create secondary indexes by using the context menu in order to improve the load and query performance of the ODS object. Primary indexes are created automatically by the system.

If the values in the index fields uniquely identify each record in the table, select Unique Index from the dialog box. The description of the indexes is specified by the system. To create a folder for the indexes, choose Continue from the dialog box. Now you can transfer the required key fields into the index folder using Drag&Drop.

You can create a maximum of 16 secondary indexes. These are also transported automatically.

<b>Value Table</b> is the DB table name Assigned in a Domain (in the Value Range Tab).

Advantage:

So whenever we create a Foreign key relation of a field with this Domain , the system will propose the Value Table as Check table. That means if the Domain does not have a Value table assigned then the Check table must be entered manually while creating Foreign key relation.

<b>8. is it possible to transport z tables? if ...why?</b>

Yes,possible.

LUW

LUW: Logical Unit of Work.

Means a series of transaction that have to be executed as a WHOLE.

That is either all the transaction have to be succesfull or none.

This works on the principle of ALL or NOTHING. That is Either SAVE all or NOTHING.

SO when you modify database tables as part of a sequence of transactions and if you SAVE all the changes only it make sense so either you COMMIT it at the end of the last transaction or you do ROLLBACK on the first failure.

We have SAP LUW and DB LUW.

SAP LUW for SAP Process steps and DB LUW for DB transactions.

-

---

<b>how u upload excel flat file in int table?</b>

tables : zzpublisher,

sscrfields.

data: it_publisher like standard table of zzpublisher,

wa_publisher like zzpublisher.

call function 'GUI_UPLOAD'

exporting

filename = 'C:\externalfiles\aravind.XLS'

• FILETYPE = 'ASC'

• HAS_FIELD_SEPARATOR = ' '

• HEADER_LENGTH = 0

• READ_BY_LINE = 'X'

• DAT_MODE = ' '

• IMPORTING

• FILELENGTH =

• HEADER =

tables

data_tab = it_publisher

• EXCEPTIONS

• FILE_OPEN_ERROR = 1

• FILE_READ_ERROR = 2

• NO_BATCH = 3

• GUI_REFUSE_FILETRANSFER = 4

• INVALID_TYPE = 5

• NO_AUTHORITY = 6

• UNKNOWN_ERROR = 7

• BAD_DATA_FORMAT = 8

• HEADER_NOT_ALLOWED = 9

• SEPARATOR_NOT_ALLOWED = 10

• HEADER_TOO_LONG = 11

• UNKNOWN_DP_ERROR = 12

• ACCESS_DENIED = 13

• DP_OUT_OF_MEMORY = 14

• DISK_FULL = 15

• DP_TIMEOUT = 16

• OTHERS = 17

.

if sy-subrc <> 0.

• MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO

• WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.

endif.

loop at it_publisher into wa_publisher.

write: / wa_publisher-publishercode , wa_publisher-publishername ,

wa_publisher-city.

endloop.

<b>Reward points if you find this helpful</b>

Regards

Siva

Message was edited by:

SivaKumar

[Former Member]

hi

too many questions.

Match code object refers to a search help, u can use matchcode in selection screen to provide F4 help

A field can be filled with proposed values from SAP memory using a parameter ID

used as reference when calling transaction and passing a given field

CURR & QUAN, ref table is mandatory , dont know why.

Role is generally ur activities u must perform in ur org, this in SAP terms means what are ur responsibilities or authorized activities.

Secondary index is customised index to suit ur requirement, have created secondary index on MSEG,

Value table is attached to a domain , do that it allows only those values available in the value table, it acts as a check table

no request for variant, no idea how to transport

yes u can transport ztable , u need to run the prog which uses the table

LUW is one complete set of activities which consitute a process

like running a report or a request to read values frm a table

ALSM_EXCEL_TO_INTERNAL_TABLE used to upload excel to internal table

tc

saji