Filling all DSO registers with activating

[Former Member]

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

[Former Member]

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

[former_member186445]

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.

[former_member220624]

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

[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!