Reply from john.louk on Dec 11 at 10:51 AM I am looking at this a bit more today.
I am asking the questions because if you look at ht SAP it goes like this. VL10A and VL10B both execute transaction VL10X and send it a value in field SZENARIO. In my system VL10A sends "0001" and VL10B sends "0002". VL10X executes program "RVV50R10_PRESTEP" which simply has a parameter ""SZENARIO" and call a funciton module, "SHP_VL10_PRESTEP". In this function module, it decides which of 5 programs (RVV50R10A, RVV50R10B, RVV50R10C, RVV50R10D, and RVV50R10E) to run. It appears that the only difference in these is the presentation of the selection screen (i.e., frames, tabs, etc.). There are comments in the function module that says it uses the users profile to determine which to run.
When I run either transaction in my system, it executes program "RVV50R10C". Some of the tabs on the selection screen are different for the two transactions
So, I assume that you are not going to be using a CALL TRANSACTION in your Z program.
My development system does not give me a lot of results. When I run VL10A for the date of 12/11/2012 (CalcRuleDefltDlvCrDt = 2), I get one row with a goods issue date of 12/13/2012. I change on the the delivery creation date to 12/01/2012 - 12/11/2012, it gives me 6 rows with GI dates of 12/05/2012, 12/06/2012, and 12/13/2012. All have red lights except for the 12/13/2012 row which is yellow. This list can then be selected/marked/checked and the Delivery creation is executed (dialog or background) from this report (ALV).
Since this is a decision, I am even more puzzled.
Also, I noticed that the ALV has a field (Description) that does not display. But, I can change the layout and include it. The issue is my development box does not give me data in it. So, I cannot say what the field actually is.
Note: There are other criteria defaulted that I have not included for Sales Order tab in VL10A and User Role in both transactions.
When I directly execute the program "RVV50R10C" (or even "RVV50R10A"), I get the Sales order choices and not the Purchase Order choices.
So, I do not think you can go directly to these programs. This means that you would have to back up to "RVV50R10_PRESTEP" and specify the scenario "0001" for Sales Orders or "0002" for Purchase Orders.
Now, I would say the Z program solution is getting quite tougher.
Where is your client (country)? This could impact reading data from the report especially around the period and thousand separator editing.
Sorry so verbose/wordy.
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. __.____._ |   _.____.__ |
