The fixed value date is empty and not displayed in the VA05 report

[Former Member]

Hi SD Gurus,

With in the Sales Order in the line item level in the billing tab we have the fixed value date (VBKD - VALDT) were entered.

But when we try to execute the report VA05 were the fixed value date column shows empty (i.e without the date it shows the blank). Can you any one help me with regard.

We would like to fix this problem.

Thanks in advance for providing solution to this query.

Thanks and Regards,

SAP-SD group

[Former Member]

Do u need more inputs..

[Former Member]

Hi jananartham,

Please check whetther the fixed value date was entered for all the Orders Concerned.

As the List VA05 doesnot have this field in display u will not be able to see it here.

U can view it using another method ,using a SAP Quickviewer.

SAP Quickviewer is method of viewing a table , a table join ,etc ,in a desired layout OR exporting

it out of SAP in various formats like word ,excel,flat file ,etc.

If u want i could provide u with the steps for fetching data using a SAP Quickviewer.

Thanks,

Umesh.

[Former Member]

Dear Umesh,

Thanks for your message.

Can you please let me know the steps. So that i will check from my end.

[Former Member]

Hi janarthanam,

Ok.

Goto t-code SQVI,SAP Quickviewer.

Give a name to your query and enter description ,etc.

Next enter the table from which you want to fetch data,ie,VBKD .

Select "Layout mode" for displaying data on the SAP screen or "Basis mode " if you want to extract the data to a word doc,excelsheet or a flat file.

Next you can select the fields you want to display into your report,their position and ascending/descending order,Here make sure u select

the field u need to display ie. the fixed value date ( VALDT) .

also select the fields u wish to have in the selection criteria.

Enter these required information and u would get a report on the SAP screen or in your desired format.

Hope it will suffice you.

For any queries ,your are welcomed.

Thanks,

Umesh.

[Former Member]

Hi janarthanam,

Hope your issue is resolved or do u need more inputs.

Thanks,

Umesh.

[Former Member]

Hi Umesh

Thanks for the stpes you have provided. And the issue was resolved now.

Thanks.

J

[Former Member]

Please mark this question as answered giving points ,if problem is resolved.

Thanks ,

Umesh Karane

[Former Member]

Problem is solved by implementing the changes in the Program

[Former Member]

Hi,

In VA05 , SAP standard layout does not have Fixed value date field. which u field u r refering to....

check it out once again...U dont find tat field in standard layout.

Thanks & Regards,

Shaik Hussain