Business partner

[former_member980646]

How can i bring business partners which are created today with the get date() function

[sveabecker]

Welcome and Thank you for visiting SAP Community to get answers to your questions. Please add more details to your question, e.g. you can also add a screenshot. With that, you can reach a broader range of experts to get your question answered. I also recommend to do this tutorial https://developers.sap.com/tutorials/community-qa.html

The more details you provide, the more likely it is that members will be able to assist you.

Regards, Svea

SAP Community moderator

[jitin_chawla · Accepted solution]

Hi,

Please in the question, mention whether it is required for HANA or SQL. Bot ave different functions for it.

FOR HANA


SELECT "CreateDate", "CardCode" FROM OCRD GROUP BY "CreateDate", "CardCode" HAVING "CreateDate" = CURRENT_DATE;


For SQL


select"CreateDate", "CardCode" from OCRD
where  "CreateDate" = cast(GETDATE() as date)

KR,

Jitin