topic Re: SQVI Query in Application Development and Automation Discussions

SQVI Query

Former Member — Thu, 22 Feb 2007 20:29:38 GMT

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

Re: SQVI Query

Former Member — Thu, 22 Feb 2007 20:34:08 GMT

Hi,

Please try to link this instead.

FPLT-AFDAT = VBKD-FKDAT.

Regards,

Ferry Lianto

Re: SQVI Query

Former Member — Thu, 22 Feb 2007 21:02:19 GMT

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