Question { Genpact, 30956 }

Give the syntax of Inner,outer Join?"

Answer

Effect
The join syntax represents a recursively nestable join
expression. A join expression consists of a left-hand and a
right- hand side, which are joined either by means of
[INNER] JOIN or LEFT [OUTER] JOIN. Depending on the type of
join, a join expression can be either an inner (INNER) or
an outer (LEFT OUTER) join. Every join expression can be
enclosed in round brackets. If a join expression is used,
the SELECT command circumvents SAP buffering.

The syntax of the join conditions join_cond is the same as
that of the sql_cond conditions after the addition WHERE,
with the following differences:

At least one comparison must be specified after ON.

Individual comparisons may be joined using AND only.

All comparisons must contain a column in the database table
or the view dbtab_right on the right-hand side as an
operand.

The following additions not be used: NOT, LIKE, IN.

No sub-queries may be used.

For outer joins, only equality comparisons (=, EQ) are
possible.

If an outer join occurs after FROM, the join condition of
every join expression must contain at least one comparison
between columns on the left-hand and the right-hand side.

In outer joins, all comparisons that contain columns as
operands in the database table or the view dbtab_right on
the right-hand side must be specified in the corresponding
join condition. In the WHERE condition of the same SELECT
command, these columns are not allowed as operands

Example INNER JOIN :

Join the columns carrname, connid, fldate of the database
tables scarr, spfli and sflight by means of two inner
joins. A list is created of the flights from p_cityfr to
p_cityto. Alternative names are used for every table.

PARAMETERS: p_cityfr TYPE spfli-cityfrom,
p_cityto TYPE spfli-cityto.

DATA: BEGIN OF wa,
fldate TYPE sflight-fldate,
carrname TYPE scarr-carrname,
connid TYPE spfli-connid,
END OF wa.

DATA itab LIKE SORTED TABLE OF wa
WITH UNIQUE KEY fldate carrname connid.

SELECT c~carrname p~connid f~fldate
INTO CORRESPONDING FIELDS OF TABLE itab
FROM ( ( scarr AS c
INNER JOIN spfli AS p ON p~carrid = c~carrid
AND p~cityfrom = p_cityfr
AND p~cityto = p_cityto )
INNER JOIN sflight AS f ON f~carrid = p~carrid
AND f~connid = p~connid ).

LOOP AT itab INTO wa.
WRITE: / wa-fldate, wa-carrname, wa-connid.
ENDLOOP.

Example OUTER JOIN:

PARAMETERS p_cityfr TYPE spfli-cityfrom.

DATA: BEGIN OF wa,
carrid TYPE scarr-carrid,
carrname TYPE scarr-carrname,
connid TYPE spfli-connid,
END OF wa,
itab LIKE SORTED TABLE OF wa
WITH NON-UNIQUE KEY carrid.

SELECT s~carrid s~carrname p~connid
INTO CORRESPONDING FIELDS OF TABLE itab
FROM scarr AS s
LEFT OUTER JOIN spfli AS p ON s~carrid = p~carrid
AND p~cityfrom =
p_cityfr.

LOOP AT itab INTO wa.
IF wa-connid = '0000'.
WRITE: / wa-carrid, wa-carrname.
ENDIF.
ENDLOOP.

Thank's and Regards,
Shreeshail Diggi
SAP Technical Consultant Infinite India

Question { 5728 }

Sort statement?

Answer

This statement sorts an internal table itab. As standard,
numeric and byte-type components are sorted by their value
and character-type components according to their binary
representation code page). Textual sorting of character-
type components is performed using the addition AS TEXT.

Syntax
SORT itab [STABLE]
{ { [ASCENDING|DESCENDING]
[AS TEXT]
[BY {comp1 [ASCENDING|DESCENDING] [AS TEXT]}
{comp2 [ASCENDING|DESCENDING] [AS TEXT]}
... ] }
| { [BY (otab)] } }.

Thank's and Regards,
Shreeshail Diggi
SAP Technical Consultant Infinite India

Question { 6796 }

difference between structure and append structure

Answer

structure :
Either a structured type in the ABAP Dictionary or a name
for a structured data object in an ABAP program. You can
access whole structures or merely by component. In ABAP,
structures that contain only character-type, flat
components can also be treated as elementary data objects
in ABAP


Append Structure :
Structure in the ABAP Dictionary that is appended to
another structure or a database table so as to add further
components. Standard structures and database tables
delivered by SAP can be enhanced by means of append
structures in customer systems.

Thank's and Regard's
Shreeshail Diggi
SAP Technical Consultant Infinite India

Question { 5911 }

What are domains and data element?

Answer

Domain :

Repository object in the ABAP Dictionary that describes
properties of data elements, such as data type, value
range, and so on. A domain can be linked with an arbitrary
number of data elements.

data element
Repository object in the ABAP Dictionary that defines an
elementary data type in the In addition to the technical
attributes, it also describes the semantic meaning of a (
database) field (for example, heading for tabular displays
or documentation text). The attributes such as data type,
length, and so on, are either defined directly in the data
element or copied from a domain.

Thank's and Regards,
Shreeshail Diggi
SAP Technical Consultant IBM Pune

Question { Bristle Cone, 13394 }

what r the main events that r used in alv?

Answer

List processing events :

TOP_OF_LIST
END_OF_LIST
END_OF_PAGE
TOP_OF_PAGE
TOP_OF_COVERPAGE
END_OF_COVERPAGE

Thank's and Regards
Shreeshail Diggi
SAP Technical Consultant Infinite India

Question { 6174 }

What is the significance of keyword " H I D E"

Answer

This statement stores the content of a variable dobj
together with the current list line whose line number is
contained in sy-linno in the hide area of the current list
level. The data type of the variables dobj must be flat and
no field symbols can be specified that point to rows of
internal tables, and no class attributes can be specified
Ex:
DATA: A TYPE i,
B TYPE i.

START-OF-SELECTION.
FORMAT HOTSPOT.
DO 10 TIMES.
A = sy-index ** 2.
B = sy-index ** 3.
WRITE / sy-index.
HIDE: A, B.
ENDDO.

AT LINE-SELECTION.
WRITE: A, B.

Thank's and Regard's

Shreeshail Diggi
SAP Technical Consultant IBM

Question { IBM, 5282 }

What are the views when we are creating Material ?

Answer

Basic Data 1
Basic Data 2
Classification
Sales: Sales Org. Data 1
Sales: Sales Org. Data 2
Sales: General/Plant Data
Foreign Trade: Export Data
Sales Text
Purchasing
Foreign Trade: Import Data
Purchase Order Text
MRP 1
MRP 2
MRP 3
MRP 4
Forecasting
General Plant Data / Storage 1...and Many more

Thanks and Regard's
Shreeshail Diggi
SAP Technical Consultant IBM

Question { 6963 }

what is the full form of ECC 5.0?

Answer

ECC 5.0: Means ERP Center Component
Thank's and Regards

Shreeshail Diggi
SAP Technical Consultant IBM Pune

Question { Accenture, 15389 }

what is the functionality of data class?

Answer

Data class in technical settings:

The data class defines the physical area of the database
(for ORACLE the TABLESPACE) in which your table is
logically stored. If you choose a data class correctly,
your table will automatically be assigned to the correct
area when it is created on the database.

The most important data classes are (other than the system
data):

APPL0 Master data
APPL1 Transaction data
APPL2 Organizational and customizing data

Master data is data which is frequently read, but rarely
updated. Transaction data is data which is frequently
updated. Organizational und customizing data is data which
is defined when the system is initialized and then rarely
changed.

There are two more data classes available, USR and USR1.
These are reserved for user developments. The tables
assigned to these data classes are stored in a tablespace
for user developments.

Note:The data class only has an effect on table storage for
the database systems ORACLE and INFORMIX.

Thank's and Regards
Shreeshail Diggi
SAP Technical Consultant Infinite India