Dear All Experts.
i am making a vendor payment report, my Query is form BSEG table as follows.
SELECT * FROM BSEG INTO TABLE IT_BSEG WHERE LIFNR IN P_VEND. * AND KOART = 'D' * AND AUGBL = ' ' " Document No. of the Clearing Document * AND AGZEI NOT IN (1, 2) * AND BSCHL NOT IN ('09', 19).
i wnt to report whose payment pending by document. But it disaply all payment details including payment done earlier. i wn to data pending payment only.
Please help me which field i can use for it.
I am USING Foll Tables :