cancel
Showing results for 
Search instead for 
Did you mean: 

Delivery Schedule lines extraction in Excel format

former_member219179
Contributor
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

former_member183424
Active Contributor
0 Kudos

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

former_member219179
Contributor
0 Kudos

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

Answers (2)

Answers (2)

RahulHanda
Active Contributor
0 Kudos

Hi Kumar,

Use ME3M with scope of list RAHM.

Let me know if it resolves your issue.

Regards

Rahul

former_member219179
Contributor
0 Kudos

Hi Rahul,

Executed Transaction ME3M with scope list RAHM but following details are missing,

Vendor Address

Fax Number

Deliver to

Notified Quantity

Delivered Quantity

Open Quantity

Supplier Delivery date

Please let me know your valuable input to proceed further.

Cheers,

Kumar S

RahulHanda
Active Contributor
0 Kudos

Hi Kumar,

Most of the stuff is there, click on change layout and you would see other columns also. If some are missing you need to check for exit to add fields in the report itself.

Hope this resolves your query.

Regards

Rahul

jagdeepsingh83
Active Contributor
0 Kudos

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.

former_member219179
Contributor
0 Kudos

Hi Jagdeep,

Tried in EKET but I couldn't able to find vendor field to execute the report.

Please suggest me alternate option.

Cheers,

Kumar