cancel
Showing results for 
Search instead for 
Did you mean: 

Custom Logic addition to display Sales order Report

Former Member
0 Kudos

Hi Gurus,

I need the list of sales order which are open on the given date.

I have copied the Standard Transaction VA05 to ZVA05N and added a custom field 'Open at key date' to enter the date.

Now my requirement is : I need the list of sales order which are open on the given date.

I am not able to find the logic/data flow for this case.

How to fetch the data ? how will be the data flow ? Which tables should I use ?

please help me out.

Thanks,

-Naren

Edited by: narenovernet on Oct 13, 2011 12:19 PM

Edited by: Csaba Szommer on Oct 13, 2011 8:53 AM

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member209761
Active Contributor
0 Kudos

Dear ,

You can use the tables VBAK & VBUK

VBUK has field for completion status.

In the selection of your Zreport, select DATE / SALES ORDER TYPE

based on the above selection system will fetch the values from VBAK and input the same in VBUK with COMPLETION STATUS = OPEN.

The same list displayed will give you the list of open orders on the key date.

Thanks & Regards,

Hegal K Charles

Edited by: Hegal . K . Charles on Oct 13, 2011 1:39 PM

Former Member
0 Kudos

Hi

I have copied VA05N to ZVA05N. We have some other requirements also so needed to copy the transaction.

VA05N contains the dates, but these date are the date of creation of sales orders.

We need the list of open sales order on the given date.

Thanks

Former Member
0 Kudos

Dear Naren,

You are saying that you all ready copied VA05N to ZVA05N,there you can add one more filed like Status ,for this status fetch the data from VBAKUK table LFSTK,where the LFSTK is "A" you can get all records with that status.

At the initial screen ZVA05N in status you will give "A" then system will pick all the records matches with A.

Take ABAPer help.

Regards

Ram

Former Member
0 Kudos

Hi,

I doubt if you could have open orders on a given date?

You can check CDHDR/CDPOS tables if they capture a change when the delivery is created.

But even these tables do not capture such delivery creation.

The best you can do is check the delivery date creation and before that would be the date of change in status or something like that..?

Regards,

Raghu.

Former Member
0 Kudos

HI Ram,

Client's requirement is to list the docuemtns on the given date.

So, I will have just a date which we have to used further fetching logic.

Thanks,

-Naren

Former Member
0 Kudos

Hi Raghu,

Could you please explain the last line with some more details ?

Thanks,

-Naren

Former Member
0 Kudos

Naren,

what are open orders..? they're open until all items are delivered? or not yet billed?

So if you want to find all open orders on 10th Oct: 1) you'll have to first pick up all orders from VBAK created on or before 10th oct. 2) See in VBFA if corresponding deliveries or billing is not yet created and filter those for which billing is already done on or before10th oct etc..

However, you're trying to build what VA05 does.. so see if you could copy VA05 and modify the logic based on the above logic.

I hope this helps.

Regards,

Raghu.

Former Member
0 Kudos

Hi Raghu,

Thanks, It's a helpful answer for me.

Regards,

-Naren

former_member209761
Active Contributor
0 Kudos

Dear Naren,

Just add a new field in your ZVA05 and ask your ABAPer to map DATUM.

Write the logic in such a way that the list of orders will be displayed from 00/00/0000 to DATUM (which we enter in the selection date).

Thanks & Regards,

Hegal K Charles