cancel
Showing results for 
Search instead for 
Did you mean: 

Data Modelling Question .

Former Member
0 Kudos
63

Hello Gurus,

I have an issue in data modelling. I am extracting some data from a non-SAP source system(SIEBEL) via XI (SOAP Data Source). We load data fortnightly to an ODS. From ODS we update the data to a Finance Cube for reporting.

In ODS, we have 2 Info Objects for dates.i.e. Document Date & Posting Date. We derive Finance billing period(0FISCPER) from Posting Date Info Object. But we are getting only Document Date from Source System(Becasue there is no Posting Date stored in the Source System). Initially we set the Posting Date to sytem date(sy-datum) in the transfer rules and loaded the data to the ODS. So far we have no problems.

Now we want to load some data for the previous periods. But, becasue the Posting Date is set to System Date all the previous periods data is showing under current period in reports.

Is there any way we can use a parameter to set the posting date to previous period date?? any other ways to solve this issue are also welcome. We are still testing in QA. So if there is a need to change the model pls advice .

Thanks in advance.

POPS

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Instead of setting the system date, map document date also to the posting date in update rules. Setting the system date does not make sense.

Ravi Thothadri

Former Member
0 Kudos

Ask your XI team, if they can hold any parameter on Posting Date??

As Ravi said, using system date makes no sense.

Cheers

Praveen

Former Member
0 Kudos

Hi Ravi,

thanks for your reply.

in a busiess perspective, we cannot map Doc Date with Posting Date. Is there any other way we can manually put some month end date while loading data to the ODS??

Praveen,

Thanks for your input. I will speak to XI guys and let u know.

Former Member
0 Kudos

Hi,

It is true that you should not use the doc date as the posting date...

Probably if there are some other external factor, like batch number, or some form of document batch control that you can tie manually to some dates in the backend, like a table, and you can look up the table in the routine to grab the corresponding posting date?

Alternatively, you can add in a column in your input file as posting date, and you will read this directly in as the posting date. The only problem is whether your reporting incorporates back posting in this case.

Hope this helps.

Cheers,

Gimmo

Answers (2)

Answers (2)

Former Member
0 Kudos

With that FM you need to update the positng date in the update rules.

Ravi Thothadri

Former Member
0 Kudos

use import paramater to get month end date

Eg:

day_in = comm_structure-doc_date.

Cheers

Praveen

Former Member
0 Kudos

You can if that makes business sense. There is a Function module" SLS_MISC_GET_LAST_DAY_OF_MONTH" .

Using this function module, you can update the positng date as the last day of the month.

Ravi Thothadri

Former Member
0 Kudos

Thanks for the help Ravi,

One more question.

with this function module we have to map DAY_IN field to Doc_Date or Sy-datum ??