Filter Orders which are set Complete Delivery!

[sangeun]

Hello,

We place orders with Complete delivery and no partial allows since around October.

But we want to filter orders with complete delivery setting only.

How can we do this?

Thank you 🙂

[jerryjanda]

Hi, sangeun:

Welcome to the SAP Community! We're glad you've come here to get answers to your questions. If you're also interested in connecting with community members, please pay a visit to our Welcome Corner. You'll need to sign up, but it's a great way to interact with peers and connect with other experts!

Since you're asking a question here for the first time, I'd like to offer some friendly advice on how to get the most out of your community membership and experience.

Please see https://community.sap.com/resources/questions-and-answers, as this resource page provides tips for preparing questions that draw responses from our members. Feel free to take our Q&A tutorial at https://developers.sap.com/tutorials/community-qa.html, as that will help you when submitting questions to the community. And connect with our SAP Champions for advice about asking questions.

You should also make sure your e-mail notifications are turned on for "Comments and answers to my questions and questions I follow" at #communications -- so you won't miss any replies to your question.

In addition, I recommend that you include a profile picture. By personalizing your profile, you encourage readers to respond: https://developers.sap.com/tutorials/community-profile.html.

Now for some specific suggestions on how you might improve your question:

* Outline what steps you took to find answers (and why they weren't helpful) -- so members don't make suggestions that you've already tried.

* Share screenshots of what you've seen/done (if possible), as images always help our members better understand your problem.

* Make sure you've applied the appropriate tags -- because if you don't apply the correct tags, the right experts won't see your question to answer it.

I hope you find this advice useful, and please let me know if you require any additional guidance!

All the best,

--Jerry

[Neeraj_Jain]

Hello sangeun,

You can get your data from table-VBAK. Go to SE16 or SE16N and enter your parameters.

Let say, if you want to fetch data for a date range then input your date range in "Created on" field and execute.

In the table you will get column "Complete Delivery" with your sale order# etc. The technical name of the field is AUTLF for complete delivery status. Refer screen shot.

Let me know if any question on it.

Regards,

Neeraj Jain

[Neeraj_Jain]

Hello sangeun,

Please confirm if solution works for you.