The scenario is that users requirement is to look AR payment along with invoices against which payment recd including document header text.
I created one query related to AR invoice and recd payment (full payment). I joined 3 tables 1. bkpf 2. bsad and 3 kna1 and selected all required fields but i am not getting the document header text ( Cheque no) details in invoice line item which i put at the time of payment entry.
