topic Client specific in Application Development and Automation Discussions

Client specific

Former Member — Mon, 19 Nov 2007 07:04:13 GMT

hello.

can any one tell me what is the use of 'CLIENT SPECIFIC ' in select query. and when to make use of it.

Re: Client specific

Former Member — Mon, 19 Nov 2007 07:08:38 GMT

if u want to access data from specific client. ( MANDT field in table)

by default ABAP will access data client specific if u don specify.

Re: Client specific

Former Member — Mon, 19 Nov 2007 07:09:38 GMT

http://help.sap.com/saphelp_nw04/helpdata/en/3d/ad5b264ebc11d182bf0000e829fbfe/content.htm

http://help.sap.com/saphelp_nw2004s/helpdata/en/1b/9dc2d6e59911d184810000e8a57770/content.htm

Re: Client specific

Former Member — Mon, 19 Nov 2007 07:25:19 GMT

Hi Shalu,

Consider the case, you have on SAP System called SAP-HR6, in this system you have 3 clients, say 100, 200, 300.

Example in HR module the transparent tables like PA0000, PA0001.....etc are client dependent because they contain field called MANDT.

Now if you are writing any select query and you want that this query should fetch data only from client 300, then in where condition you can specify MANDT = 300,

But doing so is not permissible because by doing this your program will become client specific, if you want to write client specific program that cannot be used in other clients, in that case you can use MANDT in where clause.

EXAMPLE:

Note : objects in SE38 are always cross client

In Client 300 , you are writing

Report ZXY

Select * from PA0000

into itab

where MANDT = 300.

In Client 200, if u run the report ZXY,

It will show no data found, because in this client the MANDT value is 200.

Hope you are clear with this, do revert back for further doubts.

<b>Kindly Reward If Useful

Rohit G </b>

Re: Client specific

Former Member — Mon, 19 Nov 2007 07:53:17 GMT

1) In table if the first field is CLNT then we call it as client dependent otherwise we call it as client independent.

2) Client dependent or independent transfer requirements include client specific or cross client objects in the change requests. Workbench objects like SAPscripts are client specific, some entries in customizing are client independent. If you display the object list for one change request, and then for each object the object attributes, you will find the flag client specific. If one object in the task list has this flag on, then that transport will be client dependent.

>>>Why Sap script is client dependent and smartform is client independent

B'coz if we develop SAP Script in one client say for example in 100, & if we want to access it in other ciient say 110 , it won't be available . This is CLIENT DEPENDANT.

In case of smartforms, if we develop it in 100 client & if I want 2 access the same smartform in 110 , it wil be available. This is CLIENT INDEPENDANT.

Report programs are CLIENT INDEPENDANT.