FI Posting

[Former Member]

Hi all,

Apparently, I have a invoice (doc type Z4) was 1900003225 for an amount of 828.38 in BSEG table, against which I made a partial payment of 500 (doc number 1500000022, doc type KZ).

Do any of you knows how to retrieve partial payment document number (1500000022) from my invoice doc number (1900003225) over BSEG table? Any table or tricks?

Thanks and regards,

Patrick

[Former Member · Accepted solution]

not from the BSEG , but u have to get it from Customer data BSID,BSAD.

Bcos BSID or BSAD-VBELN = UR Billing Document

Regards

Prabhu

[Former Member]

either check BSID or BSAD tables....

[former_member181962]

Prabhu is right.

YOu have to go to the table BSID for open items for an accounting document.

You can get the clearing document AUGBL from this table.

YOu can pass the AUGBL to the table PAYR to get the payment document number: VBLNR.

Regards,

Ravi