Thread manufacturer spins its future in the cloud

Sign in to queue

The Discussion

  • User profile image
    Radhey

    Hi There,

    Thank You so much for this blog. It helped me lot. I am a Technical Recruiter by profession and first time working on this technology was bit tough for me, this article really helped me a lot to understand the details to get started with.

    Hi there, I'm trying to build a query that identifies changes on item group this year. <a href="https://asha24.com/sap-hana-certification-training">SAP HANA training USA </a>
    I've got the data from table AITM and so far the query looks like below. The issue that I'm having is that the UpdateDate is picking up the whole table changes (and not only the item group code changes). Like I said as a result I want to see all the items that had the item group changed in the current year. Does anyone have any idea on how to get it?
    Thank you!

    SELECT DISTINCT
    T0."Code", T0."Name", T0."GroupCode", T1."GroupCode" , T0."UpdateDate"
    FROM (select "Code", "Name", "GroupCode", "UpdateDate" FROM AITM) T0
    INNER JOIN (select "Code", "Name", "GroupCode", "UpdateDate" FROM AITM) T1 ON T0."Code" = T1."Code"
    WHERE T0."GroupCode" <> T1."GroupCode" AND
    DAYS_BETWEEN( T0."UpdateDate", CURRENT_DATE) <= 80


    Anyways great write up, your efforts are much appreciated.

    Cheers,

    Radhey

Add Your 2 Cents