Skip to Content
author's profile photo Former Member
Former Member

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

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    Posted on Jan 21, 2013 at 06:19 AM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Anshu Lilhori

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

  • Posted on Jan 21, 2013 at 04:57 AM

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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.