Announcement:
wanna exchange links? contact me at sapchatroom@gmail.com.
Posted by
Admin at
Reply from john.louk on Dec 10 at 4:43 PM I usually find that even though it seems like more work. It is usually better to figure out all of the requirements and write a program from scratch.
I am not sure I follow this whole process.
From your Z program, how do you plan to submit VL10A and VL10B in background? Both of these transactions are parameter transactions.
If you do submit these in the background, are they going to be run separate from your Z program?
Cheers
John
| | | ---------------Original Message---------------
From: Pamela79 Pilch
Sent: Saturday, December 08, 2012 10:10 AM
Subject: Extracting data of VL10A in Internal Table
Hi John,
Our client requirement is to send the extract of VL10A/VL10B in an excel sheet and to send the same in an email to transporter once a month for open SO/PO for any date range (delivery creation date field of VL10A/B). The excel sheet will have data like open SO/PO, material description, qty, ship to party, ship to location, material . The client wants to run the report by himself for any date range or it can be run by a batch job.
Since certain fields like material desc are not in VL10A/B and since we do not want to use user exits. we proposed a solution like below.
we have created a Z program with a selection screen with same selection screen fields as in VL10A/B plus another field for email id and then pass these fields(except mail id) in background to VL10A/B and then fetch open SO/PO in an internal table and fetch other data from VBAP /PO tables and to create an excel sheet and send an email
The issue there is "delivery date creation rule" field in VL10A/B and client wants to use any date range for 1 day, 2 days or 3 months. But the issue is we do not know which delivery date creation rule to use to satisfy the client requirement. for generating report for any date range.
Once we know this, we will pass the same delivery date creation rule from our Z selection screen to VL10A/B. Also when we go to VL10A/B, the system defaults the "delivery creation date rule" to 2 with date range of today's date and next day.
So which "delivery date creation rule " we can use in our Z selection screen so that we can pass the same to VL10A/B in background to get the report for any date range.
Pls note that our technicall team is not comfortable with using user exits of VL10A/B
regards
Pamela |
| Reply to this email to post your response. __.____._ |   _.____.__ |
