Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

SQVI Query

Former Member

‎2007 Feb 22 8:29 PM

0 Likes
708

Hi All

We are currently working on getting an SQVI report together at work for a QA Analsys for our sales contracts on SAP. Currently having trouble finding the correct relationship to get the Billing date in the report from the billing plan.

We've tried linking

FPLT to VBAK with AFDAT to get the billing date of the related contract but had no luck. Does any one have experience with this and could help on this.

Many Thanks

Avi

Hi All

We are currently working on getting an SQVI report together at work for a QA Analsys for our sales contracts on SAP. Currently having trouble finding the correct relationship to get the Billing date in the report from the billing plan.

We've tried linking

FPLT to VBAK with AFDAT to get the billing date of the related contract but had no luck. Does any one have experience with this and could help on this.

Many Thanks

Avi

Reply
2 REPLIES 2
Read only

Former Member

‎2007 Feb 22 8:34 PM

0 Likes
612

Hi,

Please try to link this instead.

FPLT-AFDAT = VBKD-FKDAT.

Regards,

Ferry Lianto

Read only

Former Member

‎2007 Feb 22 9:02 PM

0 Likes
612

Thanks

Will try this. Will this get the sales doc related to the billing date. How does this relationship work? We do get a billing plan number and i was thinking we get the billing date from that billing number. The end results needs to be the sales doc that relates to the billing date.

Not sure how these relationships link to each other cause we tried overriding them but the SQVI program didnt allow this.

Thanks