Vandor Payment

[Former Member]

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 :

BSEG,

BKPF,

VBRK,

VBKD,

t052,

LFA1

Thnaks

Bhavesh Panchal

[Former Member]

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 :

BSEG,

BKPF,

VBRK,

VBKD,

t052,

LFA1

Thnaks

Bhavesh Panchal

[rvinod1982]

Hi,

Use table BSIK.

Regards,

Vinod