Skip to Content
0
Former Member
Jul 11, 2007 at 03:51 PM

Probelm inverntory

1568 Views

Hi Experts

Here i am posting what i did and wht anlayized,

I am getting some problem in report that is data inconsistancy.

if you did any mistake make help.

1st i filled BX,BF and UM

2) i loaded BX data (opening stock) to ZINV_C03 cube, i did compersion normally and after that I loaded data BF to ODS ZINVD03 after that i loaded this data to ZINV_C03 after that in comperessed data with "No markeup update" flag on.

i prepared a report that in rows matrial and matrial docment in column 1 non cumulate key figer and one cumlative key figer

when i excuted that report with matrial and matiral doc.

Matrial--


matrial doc
non-culmulative KF
--


cum KF

A--


X
10
--


10

A--


Y
10
--


10

A--


#
20
--


Now i removed Martrial document and excuted that report

Matrial--


non-culmulative KF--


cum KF

A--


40--


20

i got some inconsistance value for non cumlative KF, it have to come 20 instead of 40.

Cube level data is ok.

I look into the request BX and BF data of PSA

I saw BX request in PSA with A without matarial document for inflow keyfiger contian 20(1 row)

and history data BF data in PSA with matiral , two matrial document numbers inflow keyfiger contain each one 10 value(2rows)

in cube level showing after compression it showing

matiral , two matrial document numbers inflow keyfiger contain each one 10 value(2rows)

this thing

i did this any...

i read some where else

<b>Don’t update InfoCube 0IC_C03 from an ODS layer. See composite note 586163

(chapter 5.c, Inventory Management and ODS) why it is recommended.</b>

if it is necessary what procedure i have to follow

IF ANY BODY HAVE THIS note 586163 PLEASE SEND

<b>in report it have to show 20 only for non cumlative keyfigure also.</b>

Thanks

Sudha