LSMW upload Sales Order using VA01/VA02

[Former Member]

Hi All,

I need to upload Sales Order data from legacy system to SAP.

I read some post here said that LSMW in two steps,

1. Create the Sales Order header using VA01 without any detail line

2. Modify the Sales Order detail lines using VA02.

I've try LSMW, no problem for the Header, but no idea how to upload the detail,

it only upload line 1 of each Sales Order.....

Is it possible to complete this task by LSMW with RECORDING method?

(not BDC, BAPI, Batch/Direct Input....I don't have such knowledge)

Can anyone post some steps here showing how to map the fields for the detail?

Thank you very much.

Terry

[Lakshmipathi · Accepted solution]

"Date / / is not valid"

Date should be 05.10.09 and not 05/10/09

thanks

G. Lakshmipathi

[Former Member · Accepted solution]

Hi Lakshmipathi,

I don't think it is a format problem, even I remove all date field in my structure,

and set the CONSTANTS to 20090930 at the Field mapping steps, its still prompt me the same

"Date / / invaid',

so I think I've missing some MANDATORY date field have been assigned to the structure....

Does anyone know which date fields are the mandatory?

Thanks.

Terry

Edited by: Kin Hang, Terry NGAI on Oct 5, 2009 2:38 PM

[Lakshmipathi · Accepted solution]

CONSTANTS to 20090930 at the Field

No system will accept year only for the last two digits which means, it should have been 30.09.09. Year 2009 will not be recognised by the system during LSMW. Maintain for two records like this, test the data and update the forum.

thanks

G. Lakshmipathi

[Former Member · Accepted solution]

Hi All,

Date problem solved, as our system use the date 2009/09/30 display, and save 20090930 is ok.

The problem coz some date which are MANDATORY but not prompt for input in the LSMW Standard Batch / Direct input.

I'm now facing another problem

"Please enter sold-to party or ship-to party",

I've already set the BVBPAKOM for SP (Customer) and SH (Ship-to-party) in the Structure relation.

but still have this error message.

Terry

[Former Member · Accepted solution]

Hi All,

All problem solved, I add ZERO in front of the customer and ship-to number, and solved.

Thanks.

Terry

[Former Member · Accepted solution]

Hi Terry.

i have the same problem with the date format, how did you fixed? im a little bit confused, and my english is awful.

Thanks to everyone.

Edited by: JELR87 on Oct 21, 2010 11:46 PM

[shivakrishna_esakoila]

Hi Terry,

I have the same problem 'Date - - is not valid' and how did you solve the Sold-to-party and ship-to-party

problem...Please explain in brief.

Thanks,

Shivakrishna.

[Former Member]

Hi ALL, I was going through this thread. It seems that I am also facing the same issue: Date / / is not valid. I am also using the SAP standard program RVINVB10 to upload the Scheduling Agreement data in SAP (Transaction VA31) & during the uploading we have used the following date fields (VDATU,BSTDK & PRSDT) in the format YYYYMMDD, it is seen we are encountering the following issue: Date / / is not valid. Any inputs how to get rid of it. BR, Tanmoy

[Lakshmipathi]

in the format YYYYMMDD

How the date is flowing when you create scheduling agreement individually ??  If it is not in the above format, then you will face this issue.  Your LSMW recording should be same as how system is accepting currently.  Most probably, it should have been DD/MM/YYYY

G. Lakshmipathi

[shivakrishna_esakoila]

Hi Lakshmipathi,

When I am uploading Sales orders with multiple items through Direct input method in LSMW...Iam facing the below mentioned problem... Iam hardcoding date to PRSDT.

' Exchange rate of 1 in GBP 2 for date 08/09/2012 3 could not be determined '.

When I am creating Sales orders manually...I am able to do it.

Thanks,

Shivakrishna.

[shivakrishna_esakoila]

Hi Lakshmipathi,

When I am uploading Sales orders with multiple items through Direct input method in LSMW...Iam facing the below mentioned problem... Iam hardcoding date to PRSDT.

' Exchange rate of 1 in GBP 2 for date 08/09/2012 3 could not be determined '.

When I am creating Sales orders manually...I am able to do it.

[Former Member]

Hi,

Please check the Data format whether it is separated by the "/" or .

I hope the date format used in your legacy system is not same as the SAP format.

Check this and revert back

regards,

santosh

[Former Member]

Hi All,

Now I'm trying the Standard Batch/direct input

with object 0090

Method 0000

Program Name RVINVB10

Program Type D

After I start the batch, it show

"Date / / is not valid"

But I check there is nothing wrong in the Step "Display Converted Data".

I've the following date field in the header

1. Requested delivery date (VDATU)

2. Customer purchase order date (BSTDK)

3. Date for pricing and exchange rate (PRSDT)

Please Help.

Terry