RE:[sap-log-sd] How to join tables VBAK,VBAP,VBREVE,VBREVK,VEDA

Posted by LCC352 (Sr. Mgr, ERP/Financial Systems)
on Jun 1 at 10:13 AM
There are no logical databases that contain VBREVE. There is only one that has VBREVK in it, but that is joined to VBREVR.

The condition that has to be met is that there would need to be only one record in the VBREVK/VBREVE combination that satisfies a given combination of sales order/line item. I don't know your particular data, but that's probably not going to be true. Each sales order row will repeat on the second and subsequent combinations of VBREVK/VBREVE. I don't know how you will satisfy the requirements, given the nature of the data. - Lou

---------------Original Message---------------
From: rajivvarma
Sent: Tuesday, May 24, 2011 6:03 AM
Subject: How to join tables VBAK,VBAP,VBREVE,VBREVK,VEDA

Hi Experts,

I have requirement to use VBAK,VBAP,VBREVE,VBREVK,VEDA.Could you please tell me how to join these tables in right manner to avoid duplicates.

I have tried linking all the tables to VBAK but it is creating duplicates so please guide me right join condition to use these tables.

Thanks & Regards,
Rajiv.
__.____._
Copyright © 2011 Toolbox.com and message author.

Toolbox.com 4343 N. Scottsdale Road Suite 280, Scottsdale, AZ 85251
Mark as helpful
View this online
  
Popular White Papers
In the Spotlight
Which response to your Toolbox.com Groups post was the most helpful? Use 'Best Answer' to mark highest quality content.
_.____.__