how to create query

[former_member696123]

Hi expert,

can you please guide me how to create query.

actually my requirment i want one report

1. billing document number

2. billing date

3. sales org.

4. profit center

here there two table vbrk and vbrp is reqiured to met the requirment. how two table can link

thanks and reguards

shashi

[od_manikandan]

Hai Shashi Singh,

Once query is created ask abaper to create a T CODE for the query in se93 and given authorization to the respective user

Regards,

Mani

[Lakshmipathi]

Please do some research by searching the forum or goole with the text How to table join so that you will get lot of inputs.

thanks

G. Lakshmipathi

[moazzam_ali]

Hi

You can also join VBRK and VBRP in SQVI.

SQVI is easy to use. Enter T code SQVI.

Enter Query Name and click on Create.

Give a title and select Table join in drop down list.

In new screen there are icons in top left menu. Click on second icon which is insert table. Enter table VBRK and do the same for VBRP.

System will make a join of VBELN (Billing document number).

Click on back button and here in left box in your screen select the fields which you want to display in selection screen and output screen.

Execute it and get your data

YOu can also do the same with SQ01,SQ02 and SQ03 as the Mr.Kapil has explained. The result will be the same.

[Former Member]

Hi,

you can join table in ABAP quires

Go to SQ03

Create user group and then do user group assignment

Then go to SQ02

Put Info set query name and click on create then tick-mark to LOGICAL DATABASE and put logical database as VFV and enter

Then select table VBRK & VBRP and enter

Then at right side screen you will see two groups billing document heder and item and same you will see at left side

Expand the left side billing document heder and item

Then DRAGE the field from left billing header filed and put in to right side billing header group

Do same for fields which you want and then last click on GENERATE icon and then save

Then on SQ02 screen slect generated infoset and click on role/user assignment and assign user which created in sq01

Then go to SQ01 and click on infoset query and execute

Kapil