A Job Shared Variable  allows you to store data for use by
each process instance. A separate copy of the variable is
created for each new process instance. This resource is
useful for passing data to and from sub-processes without
creating an input or output schema for the called process. 
You can use the Get Shared Variable and Set Shared Variable
activities to access the data instead of mapping data to a
called processes input or output schemas. New process
instances receive a copy of the variable, so data cannot be
shared across process instances.

Scope of the job shared variable is with in the process
instance i.e the values which was set in one process
instance ,can not be avaible in other process.
If job shared variable in Process definition-1  set to 5
then the same value will not exist in process definition -2
.This means a separate copy of instance is maintained in
each process instance.

use relational operator 
(a > b)
this is not a arithematic operator.

or you can use conditional operator
(a>b)?a:b;

1. Functions can used with Select statement
   SP are not
2. If we have a syntax error or bug in SP it ignore it at
   execution. In case of Function it won't.
3. Function should return atlease one value. 
   SP may or maynot return values.
4. Function cannot include in other function.
   We can execute one SP in other.

UDF
1. Must return a value – a single result set
2. Directly used in select, order by,where, from
3. UDF can’t use nondeterministic function Such as
getdate(), rand()
4. Can’t change server enviroment variables
5. Stops execution of T-SQL code when error occurs
6. Can’t use temp table in UDF

Stored Procedure
1. Can return value – multiple result set
2. Can’t use in select
3. Can use nondeterministic functions
4. Can change server enviroment variables
5. Stored procedure move to the next instruction if you used
proper error handling,
6. Can use temp table in SP

store procedure takes less time to execute the statement 
than functions, also we can create loops inside the store 
procedure.

function does have update or delete statment.

a stored procedure is like a subroutine. It is used to 
perform tasks within the database, whether it be to INSERT, 
UPDATE, DELETE, SELECT, send return values, send output 
parameters, send e-mail, call command line arguments, 
encapsulate business logic, enforce data integrity, or any 
combination thereof. Here is a fictitious example: 
 
CREATE PROCEDURE dbo.doStuff 
    @dt SMALLDATETIME 
AS 
BEGIN 
    SET NOCOUNT ON 
 
    DECLARE     @un SYSNAME, 
        @now SMALLDATETIME 
 
    SET @un = SUSER_SNAME() 
    SET @now = GETDATE() 
 
    BEGIN TRANSACTION 
 
    INSERT dbo.myLog 
    ( 
        ProcName, 
        UserName, 
        dt 
    ) 
    SELECT 
        'doStuff', 
        @un, 
        @now 
 
    DELETE dbo.myLog 
        WHERE dt < (@now-7) 
 
    UPDATE dbo.Users 
        SET LastActivity = @now 
        WHERE UserName = @un 
 
    COMMIT TRANSACTION 
 
    SELECT TOP 3 ProcName, dt 
        FROM MyLog 
        WHERE UserName = @un 
        ORDER BY dt DESC 
 
    DECLARE @subject VARCHAR(255) 
    SET @subject = @un + ' used the doStuff procedure.' 
 
    EXEC master..xp_smtp_sendmail 
        @from = 'foo@bar.com', 
        @to = 'bar@foo.com', 
        @server = 'mail.myserver.com', 
        @subject = @subject 
 
    DECLARE @cmd VARCHAR(255) 
    SET @cmd = 'del c:\users\'+@un+'\archive\*.log' 
    EXEC master..xp_cmdshell @cmd, NO_OUTPUT 
 
    RETURN 0 
END 
GO
 
Stored procedures accept parameters, and are the preferred 
method of both manipulating data and simply returning data. 
They are compiled when first run, and the query plans are 
stored and cached by SQL Server's optimizer, and those 
cached plans are swapped out depending on frequency of 
usage. Generally, a stored procedure will perform faster 
than an ad hoc query, but there are certain cases (e.g. 
when a bad plan is cached) that this is not the case. 

User-Defined Functions (UDFs) 

In general, UDFs can be a serious source of performance 
issues. Also, UDFs cannot be used for DML operations 
(INSERT/UPDATE/DELETE), cannot use non-deterministic 
functions ,cannot use dynamic SQL, and cannot have error-
handling (e.g. RAISERROR).

FUnction use when you want to return any value only
but SP is best for all

Make my future prosporous.
my mother's health.
wish about my family's happiness

I would not get three wishes from god, I,ll get only one 
single wish. always helthy and happy because health in 
wealth........... so I dont need three for wishes.........

my first wish is healthy life to everyone
   and  the second peaceful mind 
   the last one is high salary with job satisfaction
these three things makes a person happy and innovative so he/she rule the field where they are in

1st wish - Good Health

2nd wish - Wealth

3rd wish - Ask for 3 more wishes

1) Oh lord of this world make my life better hear and 
hereafter.
2) Make my all friends and family members life as well.
3) Oh creator of this world stop violence in this world, I 
mean make peace every where.

At this stage you need to become diplomatic.
Just say:
1.A great frame of mind for everyone.
2.The automatic problem rectifier.
3.Three more wishes so that i can add something more.

there are deploying the two ways but i suggest the only one
of the easyist way that is there are several steps
steps:
1)   first create the one of the own directory name
         example: owapp
   next step
2)  in this directory static resousrce are store the in (owapp) 
        example: html code
3)  next step in owapp directory create the two
subdirectories that is one is LIB directory in this
directory store the XML files and  create the second
subdirectory CLASSES directory in this directory store the
sevletclasses and jar files 
4)after above processes completed then this total directory
copy to the total directory of (owapp) one the web server
for example i take the tomcat server in this server one of
the directory is WAPP store the total directory of OWAPP
store the in the WAPP folder 
5) after completed deployement then we type the url name on
one of the browser i am using the browser netscafe navigator
whenever we press the enter button after enter the enter
button first we call XML file

There are tow types of deployments. 
1. Hard deployment
2. Soft deployment

After compling the code, copy and past the foder structure directly in the server (Ex webapps folder in tomcat) is called Hard deploment.

Creating the folder as .war file and deploying it through admin console is the Soft deployment. 

Later one is the most perferable one.

there is no facts in the fact table.that table is called 
factless fact table

A fact table which is having only foreign keys.There is no
measures

A fact table contains only the keys ie foreign keys but no 
measures(numerics) is known as factless fact table.





A Fact Table having no Facts is known as Factless Fact 
Table.

Fact less fact table is  without any Numerical 
measurement , only  contain key value like Foreign key

There can be only two aggregate functions in a fact less fact table....count and distinct count on the foreign keys.

dependent fiscal year represents april to march or from 
september to august.generally two years are involved in 
dependent fiscal year.

for eg:april 2008 to march 2009

       september 2008 to august 2009.

default is dependent fiscal year in sap.

INDEPENDENT fiscal year is usually from JAN - DEC.generally 
one year is involved in this type.ITS ALSO CALLED CALENDAR 
FISCAL YEAR.

there is one more fiscal year which is shortend fiscal year.
its usually for less then 12months.this fiscal is used for 
a newly formed company..

Hi,
In IMG go to financial accounting global setting then go to
fiscal year variant and set the fiscal year variant on year
dependent year and follow the following procedure:

1.  enter name of month started from may and end on april
2.  enter the number of days in a month you want to close
for example in may number of days is 28 instead of 31 
3.  enter period from 01 to 12 started from may to april
4.  enter -1 against the month from jan to april

For Example :

  Month       Number of Days       Period        Year Shift
  May08          28                01                 0
  June           35                02                 0
  July           28                03                 0
  Aug            28                04                 0
  Sep            35                05                 0
  Oct            28                06                 0
  Nov            28                07                 0
  Dec            35                08                 0
  Jan09          28                09                -1
  Feb            28                10                -1
  Mar            35                11                -1
  Apr            31                12                -1 

Year Independent: the financial year is different from
calendar year Starting from 1st April to 31st March (where
the posting period months are not equal to calendar year months)

For Example :

  Month       Number of Days       Period        Year Shift
  Jan09          31                10               -1
  Feb            29                11               -1
  Mar            31                12               -1
  April08        30                01                0
  May            31                02                0
  Jun            30                03                0
  July           31                04                0
  Aug            30                05                0
  Sep            31                06                0
  Oct            30                07                0
  Nov            31                08                0
  Dec            30                09                0

Hope this would definitely help you out.
Thank you.

can you guys clarify why we use -1 for jan09 and 0 for 
apr08 in year shift whereas the logical conclusion from the 
definition of year shift should be +1 for jan09 and 0 for 
apr08

If the fiscal year is later than the calendar year, +1.
If the fiscal year is before calendar year, -1.

At the time of Maintain controling area we give company 
code currencey 10

Inthe currency field we give 10 all basic setting comes 
automatically

Both are the same

In the maintain controlling area we shoulg be give the 
company code currency

controlling curreny and company code current are same.

Company code and Controlling area both are the different
organizational Units.

where Company code is using for external reporting purpose.

Where controlling area is using for internal reporting area.

Hi FZs,

For Currency their are two case are their:

Case I :-
 if Cocode =  Coarea then Currency of Cocode is equal to    
Controlling Area. 

Case II :-

If Cocode is not Equl to Coarea then it is called as cross 
company code. in this case u can assign one or more 
currency . 

coarea currency should be different  than in cocode currency

select max(salary) from tablename
fetch first 10 rows only

Sorry.. Answer 1 given by me is incorrect.

Correct Query is 

select disntinct salary from tablename
Order by salary
Fetch first 10 rows only

select top 10 salary from table name order by salary;

The query will be like this:

Select distinct salary from table
order by salary desc
fetch first 10 rows only

select distinct  salary from table name hwre rownum <=10

A written report which quantitatively describes the 
financial health of a company. This includes an income 
statement and a balance sheet, and often also includes a 
cash flow statement. Financial statements are usually 
compiled on a quarterly and annual basis.

financial statement shows the financial position of the 
company this statement includes P&L a/c and Balance sheet 
of the company

it is a statement which states the financial possion of the 
company by cosadearing p\l & balance sheet.

the staement which can furnished the detail about the 
income and expenditure and assets and liability position of 
the company or an organisation

The Statement which shows all the financial position of the 
company like Income & Expenditure, Cash flow, Fund flow etc.

In British English, including United Kingdom company law, 
financial statements are often referred to as accounts, 
although the term financial statements is also used, 
particularly by accountants.

Financial statements provide an overview of a business' 
financial condition in both short and long term. All the 
relevant financial information of a business enterprise, 
presented in a structured manner and in a form easy to 
understand, are called the financial statements

Fnancial statement includes P/L account and Balance sheet 
of the company, the P/L A/C shows profit or loss of the 
company and balance sheet shows financial position of the 
company.

The main purpose of preparing a Profit and Loss 
Appropriation account is "Distribution of profits".

In partnership firm "p\L A\C approciatoin" will prepare to 
distribution of profit or loss

In corporated company prepare to adjust the suspence a\c 
amount or transfer to next year it will happn in the case 
of while preparing final accounts any  difference will come 
transfered to suspense a\c it will happen at that time 
suspense amt will rectify with preparing p\L Appropriation 
A\C

to check wheather the firm ascrtain the profit or loss... 
during the curent accounting period

The main purpose of preparing a profit and loss 
appropriation account is Distribution of profits.

The purpose of preparing profit&loss appropriation account
is "how the company has been utilized its profits.this word
better to use in company form of accounting than partnership.

In concern is built to many department or products  in a 
business for we better result we also keen to know the 
actually performance of various department or product, It 
is necesary prepare  P & L A/c appropriation.

In respect of Companies , P & L Appropriation is made to
show how the profits of companies have been appropriated (
To set apart for a specific use ).
For example - Net Profit transffered to General Reserve ,
proposed dividend etc.
These items show how the profit is assigned to different
purposes .

1.what happend to the previous and curren profits
2.how these profits had been distributed can be known from 
profitor loos appropriation account

The profit & Loss a/c appropriation a/c is prepared to show 
how the profit of a company are allocated.

The main purpose of preparing a profit and loss 
appropriation account is to distribution of profits.

the main purpose of prepare p&l apprn. a/c is to 
distribution of profits

is it neccessary to prepare?

The main purpose of preparing a profit and loss 
appropriation account is to distribution of profits

Actally Profit and loss appropriation account is prepared to
accertain the balance of net profit for distribution after
making due enteries of general reserve, proposed dividend,
partners salary, comm, interest and taxes like fbt....

Using Java Debugger "jdb" one gets information about
which thread currently executing threads

but if I want check/findout within my program itself 
How do I do that ?

You can check by putting following code in your program

Thread t = Thread.currentThread();
System.out.println("Current Thread: "+t);

Check executing/running current thread by

currentThread() [Method]

public static Thread currentThread() 

Find the currently executing thread. 

Returns: 

the currently executing thread

by using currentThread() Method ,we can find which thread 
is runing

We can check the current Thread name as 
Thread t= new Thread.currentThread();
System.out.println(t.getName());

currentThread() method is static method, so don't need to 
create the thread object to call the method..

Below is the correct way ..

Thread t=Thread.currentThread();
System.out.println(t.getName());