Query development for Vendar details

[Former Member]

Dear All,

We want to develop an query for the below mentioned requirement.

As we have not familiar (not worked) with SAP Query development process,can any one guide us how to proceed with detail steps.

The input will be the Vendor Code ( with selection range )

The output requirement are as follows

Vendor Code

Vendor Name

Vendor Address

(We need a selection field in the input screen for vendor code)

Thanks for your time and patience

Regards

[Former Member]

Hi,

If your requirement is to get only details like Code, name and address, you can pull directly from table LFB1 using Tcode SE16.

tables of vendor master :

Vendor Master (General Section) u2013 LFA1

Vendor Master (Company Code) u2013 LFB1

rgds,

Neha

[Former Member]

Dear Neha,

Thanks for the reply,but i want a report which can be used by the USERs for their daily requirement.

So we were looking for creating a query.

Do revert

Thanks & Regards

[Former Member]

Hi all,

Any idea about my requirement......kindly suggest.

Regards

[Former Member]

Hi.

In SQ02 create info-set. You need table. Choose Table join... (Table LFA1).

ThanDrag and drop requared fields from left to right(to field gruop).

You can use button Join to join some more tables(LFB1 etc)

Save it and generate.

After that go SQ01,enter name of query and click Create, while doing it select Created infoset.Save...

Than choose buton InfosetQuery and select which fields do you want in selection and output list.

Than go QUERY-MORE function-Generate program. Mantion this name.

Go se93, create transaction with this name of program