Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Flag for business partner to be deleted

Hello friends,

My question is brief, I would like to know if there's a flag, database field or nested query to check if a business partner can be deleted from SAP. I know Balance and UpdateDate give not enough information.

Thank you in advance.

Tags:
Former Member
replied

Hi,

1. Try this query to get list of BP with no transactions:

SELECT T0.[CardCode], T0.[CardName], T0.[Balance] FROM OCRD T0 WHERE T0.[CardType]  = 'c' and  T0.[Balance]  = '0' and  T0.[CardCode]  not in ( select t0.cardcode from ORDR t0) and T0.[CardCode]  not in ( select t0.cardcode from ODLN t0) and T0.[CardCode]  not in ( select t0.cardcode from OINV t0) and T0.[CardCode]  not in ( select t0.cardcode from ORCT t0) and T0.[CardCode]  not in ( select t0.cardcode from PWZ5 t0)

2. There is no one table to find BP to delete.

3. To know list of transaction for BP, in BP master data, right click and choose inventory posting list.

4. There was discussion in this forum, even with zero balance  and no transactions, still system not allowed to delete. SAP fix this issue by query. You may refer this thread Cannot Remove Business Partner, Linked Payment Wizard Exists

Thanks & Regards,

Nagarajan

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question