Skip to Content

problem using tblfinancelock

Hi Expert,

I have an issue using BPF process, I just know that when I updated the work status to be "Submitted" fo finance apllication using BPF process through BPC Web, then the input schedule report never send data into DB. It's known from the window of warning message. After that the SAP application inserted the new record into the table "tblfinancelock". The SAP application will set the field "StatusCode" be "2".

That process run normally and I never get the error or something like that, but When I've tried to insert the new record directly into the table "tblfinancelock" similar with the above process and set the value of "StatusCode" to be "2", After that I send data through Input Schedule into DB. Unfortunely, That data inserted into DB and appearing the window that contains the sucess information.

Could you give the suggestion why it's happen, maybe I lose the step to do that ?


Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Sep 03, 2008 at 07:25 AM


    First of all I have a few questions about your question:

    -Do I understand correct that you try to insert records with a query yourself into tblfinancelock? Why are you trying to do this? Because you say via the usual way it works fine.

    -You state that you have a problem using BPF, but if I understand correct you don't have a problem with BPF but with the Work Status mechanism.

    Inserting records directly into the tblfinancelock is a bit tricky. Most of the columns will give not much problems, but I think you get into trouble with the field "LastUpdate", which is a time notation. When you send data the work status mechanism is also looking at this LastUpdate column and if this is not in the correc format I guess it ignores the record and therefore the data send is not blocked. Can you post the query how you insert the records to let me test a bit with it?


    Add comment
    10|10000 characters needed characters exceeded

  • Sep 05, 2008 at 03:53 AM

    thanks joost

    Add comment
    10|10000 characters needed characters exceeded