Yes, that’s the question somebody asks me other day. Well in my opinion it has never been a good time for print media to maximize their profit. Newspapers over the world have shown decrease in terms of advertisement revenue from past few years. However just blaming internet won’t help those news daily’s, they need to evolve from the primitive methods and look at alternative method of making content available to users. To be successful and make your content read and available to users, print media needs to move to alternative methods like news on mobile, RSS, dynamic websites, kiosk etc.

Is Internet a is a threat to print media? Is internet an enemy of friend? Let us know your thoughts….

Some of the Tcode related to Financial management

FGRP                                 Report Writer screen

FM12                                 View blocked documents by user

FST2                                  Insert language specific name for G/L account.

FST3                                  Display G/L account name.

KEA0                                 Maintain operating concern.

KEKE                                Activate CO-PA.

KEKK                               Assign operating concern.

KL04                                 Delete activity type.

KS04                                  Delete a cost centre.

KSH2                                 Change cost centre group – delete.

OBR2                                 Deletion program for customers, vendors, G/L accounts.

OKC5                                Cost element/cost element group deletion.

OKE1                                Delete transaction data.

OKE2                                Delete a profit centre.

OKI1                                 Determine Activity Number: Activity Types (Assignment of material number/service to activity type)

OMZ1                                Definition of partner roles.

OMZ2                                Language dependent key reassignment for partner roles

How do you connect to the remote server if you are working from the office for the client in remote place.

WAS web application server or ITS are generally used for this purpose. If you are sitting at your office with a server which is in the system and the other server is at the clients place you can generate IDOC, intermidiate documents which carry the data you want to transfer or the documents you want to transfer, these IDOC are interpretted by the system at the recieving end with the message class with which it is bound with. If you want to logon a system which is very distant..then remote login can be used this depends on the internet speed.

Explain about roll area , Dispatcher, ABAP-Processor.

Roll area is nothing but memory allocated by work process. It holds the information needed by R/3 about programs execution such as value of the variables.

Dispatcher :All the requests that come from presentation server will be directed first to dispatcher. Further dispatcher sends this requests to work process on FIFO(First In and First Out) basis. Dispatcher recieves the request from client and assigns the request to one of the work process.

Roll area: Each workprocess works in a particular memory that memory is known as Role Area, which consists of User context and session data. ABAP- Processor :is an interpretor which can execute logic

From Excel to ABAP – Is batch mode possible ?

DATA w_file TYPE string.
* Convert the file path into string
w_file = p_input.

* Internal Table should have same field sequence as EXL File.

CLEAR t_upload.
REFRESH t_upload.

* Call function to upload the data into internal table
CALL FUNCTION ‘GUI_UPLOAD’
EXPORTING
filename = w_file
filetype = ‘ASC’
has_field_separator = ‘X’
TABLES
data_tab = t_upload
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 NE 0.
* MESSAGE ID sy-msgid TYPE sy-msgty NUMBER sy-msgno
* WITH sy-msgv1 sy-msgv2 sy-msgv3 sy-msgv4. ELSE.
* Delete the first row of heading from the uploaded table
DELETE t_upload INDEX 1.
ENDIF. ” IF sy-subrc EQ 0.

About internal tables

An internal table is a run time instance. It get created when program starts execution. It get destroyed when program terminates. It has two different parts: HeaderLine(optional) and Body(Compulsory). Any value that comes to or goes from interanal table, that travels through headerline.

Explain row type and line type concept

Line type refers to the structure of an internal table,whereas row type is the actual part that contains the data and it refers to the table body.creating internal table using line type and row type concept is for reusability purpose.Line type and Row type are defined at DDIC LEVEL.

What happens “Update” command is used without where clause ?

It will update all the records with same name in the particular field of the table.

If we dont mention “WHERE” clause in the UPDATE statement, it will update all records satisfying the given condition (if given any ) in the table !

Based on query condition. it will update all the fields which are mentioned in the query.
ex: update employee set firstname= @firstname,lastname=@lastname where employee_id =@employee_id.
so in the above case nothing wil be happen if you used where clause or not.
if you have many statements in the query you need to use the where clause.