Skip to Content

Business partner

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

Add a comment
10|10000 characters needed characters exceeded

  • 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

Assigned Tags

Related questions

1 Answer

  • Best Answer
    Posted on Sep 16 at 10:09 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.