topic Re: SQVI Query Help in Application Development and Automation Discussions

SQVI Query Help

Former Member — Thu, 22 Oct 2009 15:21:32 GMT

Hi,

A SQVI issue, needs a little help.

Not so advanced, so apologies first of all.

The task - to create a report for not delivered articles to selected customer, for selected period, including the % discount for each article.

The (attempt for) decision so far: prepare a query, containing list fields: Customer ( Sold to party), Purchase Order Date; Article (Material), RejectionReason ( ABGRU), COndition Type(CnTy - KBETR), Rate (KBETR), Standard Order EDI.

When I tried to create a query, using SQVI, and logical dabatases ( I tried first "SD_Order", and "AAV" also...) because there I found all the tables and fields I need.

The problem is that the result was no data.

May be the problem is with incorrect table relations...in tables VBAP, KONV, VBPA

Appropriate help would be really ...helpful.

A. Emilov

Re: SQVI Query Help

Former Member — Thu, 22 Oct 2009 16:26:04 GMT

VBAP-VBPA-VBAK for all these link is vbeln

for VBAK - KONV the link is

VBAKVBAK-KNUMV = KONV-KNUMV

Re: SQVI Query Help

Former Member — Fri, 23 Oct 2009 06:47:24 GMT

Thanks for this,

Considering KONV and KNUMV are cluster tables, which transparent tables should be used instead ?

Regards

Re: SQVI Query Help

GauthamV — Fri, 23 Oct 2009 06:59:00 GMT

Use KONP,KONH tables.