SQVI Query Help

[Former Member]

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

[Former Member]

VBAP-VBPA-VBAK for all these link is vbeln

for VBAK - KONV the link is

VBAKVBAK-KNUMV = KONV-KNUMV

[Former Member]

Thanks for this,

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

Regards

[GauthamV]

Use KONP,KONH tables.