Changes to BP

[Former Member]

Hi experts,

0bpartner in BW is updating on daily basis from ERP.

Standard datasource 0BPARTNER_ATTR is always sending actual state of partners, valid to the current date.

My problem is historical changes to the partner. Lets have:

ERP state to current date: 1.1.2015

0bpartner	date from	date to	value
partner1	1.1.1000	31.12.2012	a
partner1	1.1.2013	31.12.9999	b

transported to BW with two different current states:

1.

0bpartner	date from	date to	value
partner1	1.1.1000	31.12.2012	a

2.

0bpartner	date from	date to	value
partner1	1.1.2013	31.12.9999	b

BW state to 1.1.2015 is this:

0bpartner	date from	date to	value
partner1	1.1.1000	31.12.2012	a
partner1	1.1.2013	31.12.9999	b

then ERP changes (a->c)

0bpartner	date from	date to	value
partner1	1.1.1000	31.12.2012	c
partner1	1.1.2013	31.12.9999	b

but as I receive just this from ERP, historical change is not projected

0bpartner	date from	date to	value
partner1	1.1.2013	31.12.9999	b

and BW is still like this:

0bpartner	date from	date to	value
partner1	1.1.1000	31.12.2012	a
partner1	1.1.2013	31.12.9999	b

Does this problem have any conceptual solution?

Thank you

[RamanKorrapati]

Hi Pavel,

How your updating daily data to bw? thru full info pack or delta info pack?

if its thru delta info pack then you can reload Value C record thru repair full request and use selections on Value = C. that will be loaded to bw and later run attribute change run, that will be update your old record in bw side.

Master data always overwrites.

Thanks

[Former Member]

Hi, I use full infopack

Thx

[RamanKorrapati]

is that sure, above info pack shows 2012 date. Aru daily running the same info pack?

Lets try to run full info pack with selections. one time only. Later check the loaded requst data at PSA.

if its value as c then move to info object. run attribute change run.

in selections use values as below

0BP            From Date                    Todate

Partner1     01.01.1000                      31.12.2012

[Former Member]

I shooted InfoPack from DEV system, the one on production is identical and its running indeed every day. Due to my DataSource setting I can select only partner in Infopacket and if I do select Partner1 I have just:

0BP            From Date                    Todate               Value

Partner1     01.01.2013                      31.12.9999      b

ERP DS settings might be helpful. Simulation of Partner1 gives me again just that one record.

Thx

[RamanKorrapati]

Hi,

so your using full load info pack. Fine.

If your BP pulls only one reocrd then there migth something wrong at source side.

Are you able to see Value C record at RSA3 thru extraction? if not then take CRM team help and track the changes that Value C.

How they entered that value into system?

Normall standard data source pulls the data from source which maintained/entered in standard method.

If they entered Value C data directly to tables then standard data source won't pull it,

Thanks