04-23-2008 5:32 AM
Do any one of u have a similar program for this detailed functional specification:-
Selection Screen:
Sales Org:
Sales document number:
YearPeriod: (Range) ( Mandatory) YYYYMM to YYYYMM
Output (Radio button)
- Screen
- Download
Report Output:
Sales Org:
Sales Doc number:
Forcast ID number:
Sales Document Type:
Net Value:
Currency:
Program Flow:
1) Read Function modules FIRST_DAY_IN_PERIOD_GET and LAST_DAY_IN_PERIOD_GET to ge the first and last dates of the periods entered on the selection screen. Here Year = First 4 characters and Period = Next two characters of YearPeriod field of the selection screen.
2) Read VBAK and filter all the sales documents where VBAK - AUART is ZJE or ZJR and VBAK AUDAT in the first and last dates of the periods detrmined from the above step.
3) For Each of the sales documents disply the following on the output
- Sales Org: VBAK VKORG ( Display on the output)
- Forcast ID Number: Read function module READ_TEXT where ID = Z001, Object = VBBK to get the Forcast ID. Display it on the output.
- Sales Document Type: VBAK-AUART
- Net Value: VBAK-NETWR
- Currency : VBAK-WAERK
3) For Each of the sales documents with VBAK-AURT = ZJE check the Revenue amount in TC in ZBLRV. Replace the vlaue VBAK-NETWR with REVTC and display the value in the report output.
- Sales Org: VBAK VKORG ( Display on the output)
- Forcast ID Number: Read function module READ_TEXT where ID = Z001, Object = VBBK to get the Forcast ID. Display it on the output.
- Sales Document Type: VBAK-AUART
- Net Value: VBAK-NETWR
- Currency : VBAK-WAERK
plz help me out gurus ...its really urgent!!
will reward full points..
thanks
04-23-2008 5:39 AM
Hi Daneil
Welcome toe SDN.. this forum is to help ppl who are stuck with a problems.. not to teach ABAP and write code...
first start creating a program... and do some codeing.. then there will be many guru's waiting to help you...
looks like you need to get data from VBAK and VBAP based on the conditions given.. start working... see u soon..
04-23-2008 5:46 AM
hi jack and jay,
yes i'm new to coding so if u knw how to code do reply wid
solutions...
04-23-2008 5:48 AM
its not hard to code ur program in less than an hr.
check this skeleton of ur code:
select-options: so_sales org,
so_vbeln
so_period.
parameters: p_screen as radiobutton group g1,
p_dwl as radiobutton group g2.
select ur fields from vbak
"I hope u know to code a select statment..
to get the long text call the function read_text
with D = Z001, Object = VBBK to get the Forcast ID
if p_screen = 'X'.
call the reuse_alv8 fm
else.
call gui_dowload.
endif.
Edited by: Jackandjay on Apr 23, 2008 12:53 AM