on 05-20-2015 5:04 PM
Hi SAP Guru’s,
I have a requirement that is I need to extract the delivery schedule lines in a Excel format.
Is it possible via standard t code if so please provide the details of transaction where I can extract it.
I did search in forum but couldn’t able to get my requirement hence wanted to know from experts is there any standard t code available if so provide me.
The report should contain the following details,
Vendor
Fax Number
Deliver to
Material
Document
Item
Material Description
Base Unit
Document Quantity
Notified Quantity
Delivered Quantity
Open Quantity
Looking forward to your earliest response.
Regards,
Kumar S
1. Try report ME2N or ME3N with ALV format and then click 'Delivery Schedule'.
You may not able to get some details like Fax Number , Deliver to (can't understand what it is), Notified Quantity (Is it Scheduled quantity ?).
2. You can try SQVI query with table EKKO, EKPO, EKET, EKBE.
3. For rest of field in ME2L or ME3L report, you can try to add by using explicit enhancement . Look into the blog post for more details
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Patra,
Notified quantity is nothing but Delivered Qty.
Executed Transaction ME2N with ALV format and could able to achieve as similar what you have mentioned.Example some details like Fax Number, Deliver to are missing.
Anyway will check with my ABAPer and revert back you on this.
Thanks a lot for your valuable input.
Cheers,
Kumar.S
Hi Kumar,
Use ME3M with scope of list RAHM.
Let me know if it resolves your issue.
Regards
Rahul
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You can use table EKET to download the information but I do not think if there is any standard t-code to extract the information. I think you have to go with z development if this is regular requirement and users want to download the info using a t-code.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
90 | |
8 | |
7 | |
4 | |
4 | |
3 | |
3 | |
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.