on 05-19-2008 6:25 AM
Dear all,
when iam going to enter sale order...it might be more than 100 line items...so Firest user wants to enter in Excel sheet ,then they need to copy Excel sheet to SAP.
All line items should copy from Excel to SAP as line items.
Is thr any solution...
Please need helpful..
Thanks in Advance
Regards
Luckky
1. call function BAPI_SALESORDER_CREATEFROMDAT2
2. it can import excel file to create new sales order
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Dear lucky,
Contact your ABAPer and write a prog to upload xl file to get a data into a internal table ,then
Go to trxn : SHDB and create one dummy sales order and record and give it to ABAPer for writting prog for BDC which is a easy method , in this case you can identify if any problem is there while populating the data on the screen , means in 100 items which item number has got the problem can be identified ,if required by taking into forground operation.
Reward if useful.
saravanan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
This can be done by scheduling jobs(background creation of orders). It takes the file (FTP) and creates the orders.
Thanks,
Ravi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
96 | |
11 | |
10 | |
6 | |
5 | |
5 | |
4 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.