cancel
Showing results for 
Search instead for 
Did you mean: 

How to create a query to show one specific article bought from a specific customer

former_member989880
Discoverer
0 Kudos

Hi,

how can I see in SAP B1 how many times and when one specific article has been bought by one specific customer?

Thanks

former_member186095
Active Contributor
0 Kudos

Hi,

has the specific article been invoiced or not ?

if it only has been sold by sales order, you can use these following tables:

1. sales order table : ORDR - RDR1

2. customer table : OCRD (Business Partner)

To join all tables, please use specific fields.

Rgds,

Jimmy

Accepted Solutions (0)

Answers (1)

Answers (1)

azizelmir
Contributor
0 Kudos

Hi Marcus,

Please check this Query:

SELECT Distinct T0.*
FROM ORDR T0 INNER JOIN RDR1 T1 ON T0.DocEntry = T1.DocEntry
WHERE T1.[ItemCode] ='[%0]' and T0.[CardCode]='[%1]' Thank you,

Aziz