How to find out which business partners were added in last six months.

[Former Member]

Is there a way of knowing which Business Partners were added in SAP in last six months or during any given time period.

Thanks.

[abdul_ranginwala · Accepted solution]

There is a field called "CreateDate" under OCRD. Try this query:

SELECT T0.[CardCode], T0.[CardName], T0.[CreateDate] FROM OCRD T0 WHERE T0.[CreateDate] between [%0] and [%1]

[KennedyT21]

Hi couldsia awan.....

The BP data stores in OCRD and you can check with createdate field .....

SELECT T0.[CardName], T0.[CardType], T0.[CardCode], T0.[CreateDate]

FROM OCRD T0

WHERE T0.[CreateDate] between [%0] and [%1] 

ORDER BY T0.[CreateDate] Desc

Hope helpful

Regards

Kennedy

[kothandaraman_nagarajan]

Hi,

Try this query:

SELECT T0.[CardName], T0.[CardType], T0.[CardCode], T0.[CreateDate] FROM OCRD T0 WHERE T0.[CreateDate] between [%0] and [%1] and  T0.[CardType] = [%3] GROUP BY T0.[CardName], T0.[CardType], T0.[CardCode], T0.[CreateDate] ORDER BY T0.[CreateDate] desc

Hope helpful.