on 01-23-2007 12:10 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
either check BSID or BSAD tables....
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
94 | |
11 | |
10 | |
6 | |
5 | |
5 | |
4 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.