Issue with Flat file --> DSO loading SAP BW/BI

[Former Member]

Hi Gurus,

Ours is SAP BI NW 7.3 version.I am loading data from flat file to PSA and from PSA to DSO with transformation.

My flat file fields were:

Key1

Description

Fical period/Year

Unit

Amount

Currency

I have mapped all the fields to the SAP BI as follows:

Key1 - ZXXX(custom infoobject with Numeric field)

Descrition - 0TXTLG

Fiscal period/Year - 0FISCPER , 0CALMONTH(with field routine),0FISYEAR(with field routine),0CALYEAR(with field routine)

Unit - 0UNIT

Amount- 0AMOUNT

Currency - 0CURRENCY

It is a CSV file and it has all data in PSA successfully with 1080 records.

I created as Standard DSO as follows:

ZXXX and 0FISCVARNT as Key fields and rest all the infoobjects as data fields.

In transformation the 0FISCVARANT doesn't have any mappings and its a constant "Z1".

My Issue:

The file is successfully loaded till PSA with 1080 records.When the DTP(Full load) is triggered it is loading only 90 records to the DSO New table for the FISCPER(2013012).

The trial&error which I tried:

I changed the DTP filter with FISPER field (2013001) and the 90 records are loaded successfully. I removed the filter and tried to load all the records but only 90 records(2013012) is getting loaded.Could you please help me in this issue. I want to see all my 1080 records in the New table( I really don't know which is stopping me to do that).Once I see the 1080 in the New table,I will activate the records latter. This is done in Development server.

Thanking you in advance,

Raja

[former_member182343 · Accepted solution]

Hi,

Can I expect answers for below questions. Helps to resolve issue.

What are the Key fields added in your DSO?

Check is there any duplicate records.

May be they are getting overwrite.

Check data for one customer first between Flat file and DSO.

Try to maintain unique Customers in Flat-file and keep Customer in DSO under Key-fields. Then you will get expected records.

Regards.

[Former Member · Accepted solution]

Hi Vijay,

Am using ZXXX and 0FISCVARIANT as Key fields.I will check them and update.

We are not using Customer field in the Flat file since these are Utility calculations.

Thanks,

Raja

[anshu_lilhori · Accepted solution]

Hi,

Make Vaersion,value type and fiscal year period as part of key field so that you get all the data.

In your case it was getting overwritten as proper combination of keyfield is not defined to get the unique value of set.

Hope this helps.

Regards,

AL

[Former Member · Accepted solution]

Thank you Suman and Vijay your answers were helpful.

Anshu your answer fixed the problem. I added 0FISCPER to the key field and left the Version & Value type in data fields as it is.

Thank you Anshu .

Thank you all Gurus!!!

[former_member182470]

Do you have any Start routine in your transformation? Please post a screen shot of your transformation mappings.

[Former Member]

Suman,

Thanks for the reply,Plz find the attached screenshot.No I don't have a start routine

[former_member182470]

How many Transferred/Added records shows in DSO manage? Is it showing 1080/90  ?

Un-check Handle duplicate records setting in DTP. If you use W-DSO, you will get all records irrespective of duplicate key records. You have to check "Do not check uniqueness of data" option in W-DSO.