Skip to Content

Delivery Schedule lines extraction in Excel format

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • Best Answer
    May 21, 2015 at 07:52 AM

    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 Add the field User Name in various Purchasing report's output ALV list

    Add comment
    10|10000 characters needed characters exceeded

    • 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

  • May 20, 2015 at 04:58 PM

    Hi Kumar,

    Use ME3M with scope of list RAHM.

    Let me know if it resolves your issue.

    Regards

    Rahul

    Add comment
    10|10000 characters needed characters exceeded

    • 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

  • May 20, 2015 at 04:47 PM

    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.

    Add comment
    10|10000 characters needed characters exceeded