BPC 11.1 BW4 HANA BPF Performer/ Reviewer Deadline field value

[SAPSupport]

Hello,

We are using SAP BPC 11.1 BW4/HANA Standard configuration.
We are creating customize ABAP report similar to process monitor with additional fields. We need help with backend BW table details where BPC BPF deadline values are stored. We have checked below tables :

UJB_STEP_RGN, UJB_INST, UJB_STEPT, UJB_RGN_ACC,

In Table UJB_STEP_RGN we found field OWNER_DLINE_OFFSET & REVIEWER_DLINE_OFFSET , but unable to get the correct value from these as dates set in BPF. Please help in conversion for of these fields to correct date format.
Kindly share the table name where Deadline for performer & Reviewer gets stored when BPF instance is created.

Thanks in advance !

------------------------------------------------------------------------------------------------------------------------------------------------
Learn more about the SAP Support user and program here.

[SAPSupport · Accepted solution]

You can check which tables are related to a certain BPC activity via TCode ST05. Detailed steps can be found in KBA 1626980 - How to check which tables are used for a specific BPC activity.

Regarding the deadline of the BPC instance, the corresponding field is OWNER_DLINE_OFFSET & REVIEWER_DLINE_OFFSET of table UJB_STEP_RGN. Please check it along with the BPC online help: https://help.sap.com/docs/SAP_BPC_VERSION_BW4HANA/d1711b4a86b447c38415629229003c02/f7db57786a0e4787a...

For example,

• you choose "manual start", enable with deadline End of day = 18:00, performer deadline offset = 2, OWNER_DLINE_OFFSET in UJB_STEP_RGN is 151200 (= (2 days*24 hours -6 hours)*3600s).
• you choose "start process immediately" on 08.12.2023, enable with deadline End of day = 15:00, performer deadline = 09.12.2023, OWNER_DLINE_OFFSET in UJB_STEP_RGN is 140400 (=((1day)*24hours +15 hours )*3600s).

[adwilaa · Accepted solution]

correction:

• you choose "start process immediately" on 08.12.2023, enable with deadline End of day = 15:00, performer deadline = 10.12.2023, OWNER_DLINE_OFFSET in UJB_STEP_RGN is 140400 (=(1 days*24hours +15 hours )*3600s or = (2 days*24 hours - 9 hours)*3600s).

[adwilaa]

Hi Sayali,

I captured the ST05 trace of submitting an activity. From the ST05 trace, I can see the timestamp in feild TIMESTAMP of the table UJB_STEP_RGN_O.

When reopening an activity, the corresponding entry in UJB_STEP_RGN_O will be deleted so the timestamp cannot be found.

I strongly recommend you to find a user that has access to ST05 so you can find the related tables of any activity in the ST05 trace as per KBA 1626980.

Best regards,
Amy

[sawari1]

Hello Amy,

Thank you for above details. We have one more query on this-

If any instance activity is reopened or rejected (basically status changed), do we have any table & field where we can get the timestamp when status is changed.

Thanks & Regards,

Sayali Awari

[adwilaa]

Hi Sayali,

The logic of the reviewer deadline is as we assumed:

• you choose "start process immediately" on 08.12.2023, enable with deadline End of day = 15:00, performer deadline = 10.12.2023, reviewer deadline = 10.12.2023; OWNER_DLINE_OFFSET in UJB_STEP_RGN is 140400 (=(1 days*24hours +15 hours )*3600s or = (2 days*24 hours - 9 hours)*3600s). REVIEWER_DLINE_OFFSET is 86400 (1day*24hours*3600s).

Your new questions can also be answered by tracing in ST05. I will test it and get back to you tomorrow.

Best regards,
Amy