Skip to Content
avatar image
Former Member

Filling all DSO registers with activating

Hi lads,

For sure you know how to do in the following problem.

I have a DSO which receives data from two PSAs.  DSO has two keys which are Doc.Numb and Position

From first PSA, I receive data from header and positions, and so many registers as header + positions there are.

Doc.Num (key)     Position (key)   Value     Approver    

10000                   #                         #                   

10000                   1                         10

10000                   2                         20       

From second PSA, I receive just "approver" data and Doc. Num, a single register per Doc.Numb. For example:

Doc.Num (key)     Position (key)     Value     Approver

10000                                                          zzzzzz

When loading and activating, approver is just filled in header line.

Doc.Num (key)     Position (key)   Value     Approver    

10000                   #                         #         zzzzzzz     

10000                   1                         10

10000                   2                         20       

What I need is that Approver is filled in all registers, both header and positions.  I know that this can be make with an easy End-routine, the problem is that I don't have Abap knowledge.

Do you have an example of the code I should put?

Thanks in advance

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Oct 16, 2015 at 07:30 AM

    Hi,

    If you want to report on top of this data then there is no to fill approver in each row.

    Drag Approver characterstic into the kpi in Bex and do a constant selection.

    Now when you will run the report you will see the same approver in each of the rows for a particular document number.

    Regards,

    Amit

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Amit,

      What you say is a good solution for a very simple query BEx, but in my case this is not feasible as there are many restrictions and KPIs in BEx, so it will be a mess in any change I had to do in the future.

      Thanks anyway for sharing your option!

  • Oct 16, 2015 at 11:47 AM

    i suppose a doc can have only one approver... the best approach would then be to add approver as an attribute of doc num and load via master data.

    if  you want to go for end routine, search SCN, there are a least a million examples....

    M.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 16, 2015 at 12:09 PM

    Hi,

    You should not map directly approver which is loading from the 2nd PSA.

    First load the data from the PSA.

    Activate the request.

    Load the data from the 2nd PSA.

    Prefer start routine. Read the data from the DSO which is loaded from the 1st PSA with, source package (Load from 2nd load)

    Check the 2 keys and fill the approver value.

    Regards,

    M Priya

    Add comment
    10|10000 characters needed characters exceeded