Master data Routine

[Former Member]

Hi Friends,

I need to write an End routine at DSO level to populate an Info object( List amount)  with Master data Info object (0BPARTNER) from its Q Table,

Key fields are  0Bpartner,Objver and Date to.Can somebody please give me the code.

Thanks,

Sahasra

[Former Member · Accepted solution]

Hi Sahasra,

You can directly assign the objects in the transformation and use option "Read from master Data".

However you can write the code as below:

data: i_tab type standard table of /BI0/QBPARTNER,

        wa_tab type /BI0/QBPARTNER.

Select * from /BI0/QBPARTNER into table i_tab

for all enteries in result_package

where bppartner  = result_package-bpartner and

          objver = 'A' and

           date_to = result_package-date_to.

loop at result_package assigning <result_fields>.

read table i_tab into wa_tab with key

               bpartner = <result_fields>-bpartner

               date_to = <result_fields>-date_to.

if sy-subrc = 0.

<result_field>-list amount = wa_tab-list amount.

endif.

endloop.

Hope it helps.

Regards,

Satyam

[Former Member · Accepted solution]

Thanks  Satyam

[Former Member · Accepted solution]

Satyam, there is already a Select statement and a loop in the End routine.where do i need to write my code in the End routine.Can i write other select and loop?

Thanks,

Sahasra

[Former Member · Accepted solution]

Hi Sahasra,

You can write the select statement outside the loop and use the exsisting loop statement (if the loop is on Result_Package) to write your read statement.

Reards,

satyam

[Former Member · Accepted solution]

Thanks will try this