Skip to Content
author's profile photo Former Member
Former Member

Check Client exists in system or not

hello,

how to check given input client number exists in system or not?

Any FM or function we have to write?

Wishes

Prince.

Add a comment
10|10000 characters needed characters exceeded

Related questions

5 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jan 07, 2005 at 07:41 AM

    Table <b>T000</b> has relevant information that you are looking for.

    Regards,

    Subramanian V.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 07, 2005 at 07:57 AM

    If by client you mean customer (sold-to-party, ship-to-party, bill-to-party, payer)), then you can check if the customer number exists in the system by making a

    SELECT SINGLE *

    FROM KNA1 WHERE

    KUNNR = inputed_number.

    IF SY-SUBRC NE 0.

    • that means 0 (zero) corresponding records found

    • do something

    ENDIF.

    If you want to do this check automatically, in a selection screen, use MATCHCODE 'debi'. See documentation on SELECT-OPTIONS for details.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 11, 2005 at 09:37 AM

    hai,

    do we have any FM to check given client exists or not?

    I know table T000 contains values. but how to check client exists or not?

    Chandra.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      A client of an SAP system exists by virtue of appearing in table T000.

      Whether the client contains data can only be determined by reading tables for data in that client. For example, to see whether user IDs exist in client 300:

        SELECT COUNT(*) UP TO 1 ROWS
          FROM USR02 CLIENT SPECIFIED
         WHERE MANDT EQ '300'.
      

      To know whether a client has been populated with data from another client, then it is probably best to use transaction SCC3 to check the client copy logs. Usually when creating a new client, a client copy will be used to copy standard configuration and security profiles.

      If a client defined in table T000 does not contain any user IDs, then it is possible to logon to that client using the special user ID SAP*.

      Scott

  • author's profile photo Former Member
    Former Member
    Posted on Jan 11, 2005 at 11:09 AM

    Thanks for your assistance.

    our requirement is just to check whether

    the giving input client exists in system or not.

    Is it worth only checking with Table T000.Pls confirm.

    if u can give me select query would be great.

    Chandra

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 12, 2005 at 12:55 PM

    Hey

    I want to reward point for this question and close this ticket.I cant see Reward point star in this reply message.

    Could you pls tell how to reward point here.

    Chandra kumar

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hello Chandra,

      Since you were not the person who started this thread / topic (It was Prince Devraj), you will not be able to reward any points. Only the person who starts a thread and marks it as a question can reward the points.

      Regards,

      Anand Mandalika.

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.