Linking F03b11 and F4211

i AM TRYING TO LINK BOTH THE TABLES TO compare how much is posted on AR ledger.
But in most cases the AR Amount is more than the amount in line of Sales order.How is it possible.

Join Condition ON SDKCOO = RPSKCO AND SDDOCO = RPSDOC
AND SDDCTO = RPSDCT
AND SDLNID = RPLNID
and summing of RPAG and comparing with sales order price but there is no match.

Is it the right way to process also there is no open amount on sales order.
 

JMast

Reputable Poster
I think you would drop the "AND SDLNID = RPLNID" to make that work. I have not used the SDOC,SDCT,SKCO columns, so I don't know how well they work. I would do this query with the following statement
Join Condition ON SDKCO = RPKCO AND SDDOC = RPDOC
AND SDDCT = RPDCT

It might come down to performance and indexing as to which is better.
 
Top