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

Report prog small help plz

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.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Dec 01, 2007 at 12:50 PM

    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 VBRKVBELN VBRKFKDAT ..... your fields

    from ( VBRK

    inner join VBRP

    on VBRPVBELN = VBRKVBELN

    inner join VBPA

    on VBPAVBELN = VBRPVBELN

    inner join KNA1

    on KNA1KUNNR = VBPAKUNNR

    inner join MAKT

    on MAKTMATNR = VBRPMATNR)

    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').

    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.