Grants Master data and Line item update to DSO

[Former Member]

Hi All,

In am working on Grants Management. I have activated the standard grants line item & Budget DataSource and DSO's

We have a master data table GMGR which has key as Grant Number(0GRANT_NBR) but the standard DSO's as mentioned above, do not have Grant number as keys but have Ledger number, and Ledger Item Number as keys.

I have 2518 line item records and 16 master data records. When I am combining both into a DSO with key as 0Grant_NBR. Only 16 records are getting updated as master Grant numbers are only 16 and the line items are not being updated can some one suggest, what is going wrong.

Appreciate your time.

Kind Regards

James

[anshu_lilhori · Accepted solution]

Hi,

You need to check the key fields of your DSO.Because based on the unique combination of value only it is going to update a new record and with same combination its going to overwrite.

Please try to make a proper selection of keyfields and after that everything will fall in place.

Hope it helps.

Regards,

AL

[Former Member · Accepted solution]

Hi AL,

Thanks for the response. I have used a few combination of keys to load data but could not get the items data loaded fully.

The Keys in Standard DSO for Line Items are as below

1. Ledger Document Number : 0GM_DOCNR

2. Ledger Line Item Document Number : 0GM_DOCLN

3. Document Category : 0GM_DOCCT

4. Currency Type : 0CURTYPE

5. Source System ID : 0SOURSYSTEM

6. Fiscal Year Varient : 0FISCVARNT

7. Fiscal Year / Period : 0FISCPER

While the master data table does not have any of the above. The key being

1. Grant Number : 0GRANT_NBR.

I don't seem to get the relevant fields updated but have 2 separate loads. I have also used Grants as key but still get 2 loads.

Kind Regards

James

[anshu_lilhori · Accepted solution]

Hi,

Check out this.Load line item dso seperately with the key mentioned that will be updated with transactional datasource.

Load 0grant_nbr from master datasource.GIVE More inputs on your requirement like what exactly are you trying to do

http://help.sap.com/saphelp_sm32/helpdata/EN/ea/86d3e37a324c09a37e619f232b05bd/content.htm

Regards,

AL

[Former Member · Accepted solution]

Hi All,

Thanks for your help. Grants does not seem to have a Header DataSource but has a line item DataSource . The header info is stored in ERP table GMGR.

I have created a generic DataSource on this table and have extracted data into a DSO, There are 16 records all appear in BI DSO.

Likewise the line item DSO is a standard DSO (0GM_DO01) which has all records from ERP (2518 Records) loaded into standard DSO.

Now the problem is I need Line Item and header data in a report on a single line. I am trying to combine the data from the 2 DSO's into a single DSO. But the keys do not match and I have only 0GRANT_NBR as key from the master data table GMGR.

I have also used a few combinations to test but have not been sucessfull in loading the line Item & master on a single line.

using 0GRANT_NBR as key is causing the line item data to be striped to 16 records as their are only 16 unique grant numbers.

Please suggest how I could combine the master & line items into the DSO so that they appear on a single line.

Appreciate your time

Kind Regards

James

[former_member182343 · Accepted solution]

Harrison,

why don't you use Multiprovider and use constant selection functionality.

Upadate ur status.

[anshu_lilhori · Accepted solution]

Hi,

Now i understand your issue you have master data loaded in one dso which has key 0GRANT_NBR,

You have another line item dso which has differnet set of key fields.Now you want to combine the header and line item details into one.

You cannot combine the data into one unless the keyfields of both the dso are same.

I need to ask one thing what all details you are trying to fetch from master datasource and is there any relation between master and line item datasource.I mean to say any common keyfield is there because based on that we are going to do the lookup on master DSO to line item DSO to fetch the values from Master DSO.

I hope you are aware of look up concept and all.

HOpe it helps.

Regards,

AL

[Former Member · Accepted solution]

Hi AL,

Spot on! you are right, apologies if I have been giving confused messages.

The common field between the Master & Line items data is the grant number(0GRANT_NBR) which can be used for look up.

I have around 36 fields which need to be updated to the line item data and look up looked a bit long winding approach.

I could load line item data activate the data and while loading master do a look up by grant number and update the fields.

Could I do this as per below

1. Load line item data activate it.

2. Before the master data load, can I write a start routine in the transformation to check if the master data Grant Number is equal to Line item grant Number then the transformation is executed. I have only mapped the master data required in the transformation.

What do you suggest.

Kind Regards

James

[anshu_lilhori · Accepted solution]

Hi,

I am just thinking to do it this way,Lets see how feasible the solution is:

Why dont you create a master data infoobject for GMR Instead of loading to DSO and make each field as an attribute of it.Lets say as navigational attribute to all the fields and load the data to them w.r.t GRant number.

Now in line item dso you can select all the navigational attributes which you for that master data infoobject.

At report level you can easily make use of all these navigational attributes.

It looks easy i guess.Am i missing something or some connections.

Another approach can be to load the line item dso into other dso and add all those fields from master infoobject which you need and map all those with Grant number and use rule type as read master data option and choose the corresponding attributes.

Looks logical give a try to it and let me know if in case i am missing something.

Regards,

AL

[Former Member · Accepted solution]

Hi AL,

I had added a couple of ZFields to Grant Number as Nav attributes but it does not show the data. I went to maintain master data but could not find data under data maintenance. Do I have to create DataSource for the fields.

James

[anshu_lilhori · Accepted solution]

Hi,

Yes you have to load the data to those fields using transformation in the same fashion as you did for master load dso only thing is this time your target is master data infoobject.

Hope it helps.

REgards,

AL

[Former Member · Accepted solution]

Hi AL,

Thanks a lot I used the navigations attributes and the issue is resolved. Appreciate your help.

Kind Regards

James

[former_member182343]

Check the field map for 0GRANT_NBR.

What is delta mode for that datasource in ROOSOURCE. If it ABR - change update property of DSO KF to Summation instead of Aggregation.

Check rule groups at transformation level.

Check weather data arrived to PSA or not.

Plz update the status.