Report prog small help plz

27 Views

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.