Bill against payment

[ESAITEJA]

Hai all

I have a one doubt. how to identified in table(BSEG,BSID and BSAD) level. Bill(RV) against payment (DZ). Not for document type wise if any way identification is possible in sap system.

Please explain below cases without document type and Bill wise not for customer wise.

Types	Bill	Credit note	Advance Payment	Incoming payment
Fully Paid	100	20	30	50
Partially paid	100	20	10	20
Not paid	100	0	0	0

[Santosh_Jha1]

Hello Esaiteja,

The link at the table level can be established via the clearing document information. The table ACDOCA will have the DZ/RV documents as well as the clearing document. But the table BSE_CLR will have the information to establish the payment (clearing document) and the cleared billing (RV) document. We need to also check if the payment document itself is the clearing document, or there is a separate document which has cleared payment against the bill.  

Thank you!