Announcement:
wanna exchange links? contact me at sapchatroom@gmail.com.
Posted by
Admin at
Reply from pamela79 on Dec 8 at 10:10 AM 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
| | | ---------------Original Message---------------
From: john.louk
Sent: Friday, November 30, 2012 10:34 AM
Subject: Extracting data of VL10A in Internal Table
Why do you want to extract one field from another report?
Would it not be easier to get the functional requirements and write a new program?
What is it you are trying to do?
What field are you after?
Cheers
John |
| Reply to this email to post your response. __.____._ |   _.____.__ |
