Report prog small help plz

[Former Member]

Hi,

This is Ravinder.

Selection Screen

Sales Org: VKORG

Distribution Channel: VTWEG

Division: SPART

Billing Type: FKART

Plant: WERKS

Payment Terms: ZTERM

Sold-to Party: KUNAG

Billing Date: FKDAT

Now Using the above Selection screen inputs, I want to generate the following fields in the output.

Output Screen

Invoice No: VBELN

Invoice Date: FKDAT

Customer Number: KUNNR

Customer Name: NAME1

Material Description: MAKTX

Payment Terms: ZTERM

Net Value: NETWR

Ship-to City: ORT01

Sold-to party: KUNAG

Ship-to party: KUNNR

Tables Used:

Delivery: LIKP, LIPS

Invoice:VBRK, VBRP

Customer: KNA1

Material: MARA

Material Description: MAKT

Now the Problem what I got is....How to link between these tables...ie., what common fields can be used between these tables so that I can use FOR ALL ENTRIES and retrieve the above output fields.

Can anyone please help me out in giving a REPORT program or a pseudo code for the above data.

[Former Member]

I think this was already answered. Again, I dont know you want LIKP, and LIPS, if you are not using it in the program. All you need if VBRK, and VBRP

select VBRK_{VBELN VBRK}FKDAT ..... your fields

from ( VBRK

inner join VBRP

on VBRP_{VBELN = VBRK}VBELN

inner join VBPA

on VBPA_{VBELN = VBRP}VBELN

inner join KNA1

on KNA1_{KUNNR = VBPA}KUNNR

inner join MAKT

on MAKT_{MATNR = VBRP}MATNR)

where VBRK~VKORG in S_VKORG

and VBRK~VTWEG in S_VTWEG

and VBRK~FKART in S_FKART

and VBRK~FKDAT in S_FKDAT

and VBPA~PARVW in ('AG', 'WE').