Sap pm dates

[asdasdsasd]

Hi, I’ve tried but I’m having trouble figuring it out because there are so many dates to choose from. I’m working in Power BI using data from SAP, which is retrieved from a Snowflake database. I want to get the same results as when searching in SAP. My question is: which dates (columns and table) does SAP use for the search?
First, I’m wondering about Notification (IW28) – which table and column does it look at for:

1. Notification date – when I check the variant, it says DATUV (from date) and DATUB (to date).
   Next, I’m wondering about Work Order (IW38):

2. From date (DATUV) to To date (DATUB)

[RAHEEL_BABAR]

Hi,

For IW28 (Notifications), SAP filters by creation date ERDAT from table QMEL.
For IW38 (Work Orders), it filters by basic start date GSTRP from table AFKO.
Use these fields in Power BI to match SAP's DATUV/DATUB filtering.

Regards

[asdasdsasd]

Thanks for the reply, I have some more questions. IW28: Notification date = ERDAT from QMEL Created On = ? Notification Time = ? Malfunction start = ? Malfunction end = ? Start of Malfunctn (Time) = ? Malfunctn End (Time) = ? IW38: Period = GSTRP from AFKO Basic Start Date = ? Basic finish date = ?

[RAHEEL_BABAR]

Hi, In IW28, Notification Date and Created On = ERDAT, Notification Time = ERZET, Malfunction Start = AUSVN, Malfunction End = AUSBS, Start Time = AUZTV, End Time = AUZTB from QMEL. In IW38, Period and Basic Start Date = GSTRP, Basic Finish Date = GLTRP from AFKO. Use these fields to match SAP report behavior in Power BI.