saikumar538
Registered user
Global user
Registered: 05-2007
Posts: 1
Karma: 0 (+0/-0)
|
|
Reply | Quote
|
|
Need help in the Report Program!!!
Hi,
This is SAI KUMAR.
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.
Thanks & Regards,
SAI KUMAR
ID: saikumar325@gmail.com
|
|
5/17/2007, 4:09 pm
|
Send Email to saikumar538
Send PM to saikumar538
|
saptrainee
Registered user
Global user
Registered: 11-2007
Posts: 1
Karma: 0 (+0/-0)
|
|
Reply | Quote
|
|
Re: Need help in the Report Program!!!
Hello sai....
did you get the report program...
iam also having same problem
so can u forword the same coding of ur program to me..
if anyone has the coding for above program please send it me..
my mail id : raghuraj.raj@gmail.com
Last edited by saptrainee, 11/14/2007, 3:25 pm
|
|
11/14/2007, 12:55 pm
|
Send Email to saptrainee
Send PM to saptrainee
|
srikanthnalluri
Registered user
Global user
Registered: 12-2007
Posts: 2
Karma: 0 (+0/-0)
|
|
Reply | Quote
|
|
Re: Need help in the Report Program!!!
hi sai i will provide some liks to that tables, try those.
Delivery: LIKP, LIPS---vbeln in those 2 tables.
Invoice:VBRK, VBRP-----vbeln in those 2 tables.
to combine delivery & invoice ---we hav two come fields those are VGBEL & VGPOS.
Customer: KNA1.---To join KUNNR kunnr is comman field any of above tables.
Material: MARA
Material Description: MAKT---to combine MARA &MAKT we hav field MATNR.
AT LAST WE WANT LINK B/W MATERIAL & INVOICE TRY VBELN.
|
|
12/3/2007, 1:53 pm
|
Send Email to srikanthnalluri
Send PM to srikanthnalluri
|
