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

how to find the table for the field displayed in a transaction xk03

Posted on Jan 31, 2005 at 11:04 AM 14 Views

Hi,

How to find table from the field displayed in transaction xk03(vendor details). and get the relationship of the table.

I want to display the email id and address of the vendors the structure which displays the email id is SZA1_D0100

and how to use it in the basic list report.

Advance Thanks and regards

Guhapriyan (A) Dinesh.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

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

    Hi,

    Address info in SAP is stored in several tables. But you can easily get the info you need with FM 'ADDR_GET_COMPLETE'. Just supply the addressnumber of the vendor (table LFA1) and you get all info.

    Regards,

    John.

    Add a comment
    10|10000 characters needed characters exceeded

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

    Hello Dinesh,

    1. In case of a Vendor, the master table is LFA1. You will have to fetch the ADRNR (ADDRESS NUMBER) for the vendor from this field.

    2. Use the value obtained above for the Function Module ADDR_GET (there are quite a few FMs that I think can be used, but this is what I know to be the most generic) with the address number.

    As always, get back if you have any doubts.

    Regards,

    Anand Mandalika.

    Add a comment
    10|10000 characters needed characters exceeded

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.