Data Modelling Question .

[Former Member]

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

[Former Member · Accepted solution]

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 · Accepted solution]

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 · Accepted solution]

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 · Accepted solution]

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

[Former Member]

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

Ravi Thothadri

[Former Member]

use import paramater to get month end date

Eg:

day_in = comm_structure-doc_date.

Cheers

Praveen

[Former Member]

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]

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