2009 Oct 22 4:21 PM
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
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
2009 Oct 22 5:26 PM
VBAP-VBPA-VBAK for all these link is vbeln
for VBAK - KONV the link is
VBAKVBAK-KNUMV = KONV-KNUMV
2009 Oct 23 7:47 AM
Thanks for this,
Considering KONV and KNUMV are cluster tables, which transparent tables should be used instead ?
Regards
2009 Oct 23 7:59 AM
| User | Count |
|---|---|
| 5 | |
| 3 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |