how to match net value in stat currency data from bi report to vbrk table?

[Former Member]

Hi experts,

I was testing the SAP BI report  based on quality ecc data.

The data for net value in stat currency  data on report is just coming double for all customer as referring to VBRK TABLE DATA.

I checked in 0sd_c03  cube level same net value data as in report but at PSA level net value for( 2LIS_13_VDHDR) DATASOURCE,

since I checked in (2LIS_13_VDITM) DATASOURCE net value field and data is there but when I am checking for same CUSTOMER with some billing type filter for (ZEXI,ZCSI,ZDOI,ZDSC,ZRTI,ZCMI) then i cant find any data.

According to my observation net value is coming from (2lis_13_vditm )data source and at RSA3 LEVEL (NET  VALUE IS SAME AS ON REPORT)

if net value data is coming from (2lis_13_vditm) then which table in source system we have to refer ?

please help me in analysing why  net value is doubled on sap bi final report with respect to vbrk table?

what can I  do next?

please reply me?

Thanks and regards,

Jyotsna singh

[Former Member]

hi,

Net value(0net_val_s) is from 2lis_12_vditm.. you can check NETWR in VBRK table.

may be you might have loaded data twice, any way try to compare it with above source field

[Former Member]

Hi jyothi,

I already compared with VBRK TABLE FOR NET VALUE.

Net value data on report is just double of the data in VBRK TABLE .

One doubt when I check the mapping for net value in( 2lis_13_vdhdr)  and (2LIS_12_VDITM)datasource then net value field(NETWR ) IS NOT MAPPED but mapping is done for net value in (2LIS_13_VDITM) DATASOURCE.

1)Does it possible without mapping we can have data on report?

2)What correction to be made in the load.?

[Former Member]

. 1st image is of net value data in VBRK TABLE  for cust 40041 and 2nd image is of  report.

[KodandaPani_KV]

Hi,

2LIS_13_VDITM -   data sources get data form the VBRK table, those are billing related tables (VBRK AND VBRP)

1. already have mapping from 2lis_13_vditm - to net values

2. have you fill the setup table multiple times for particular sales order?

pls check

if it is dev system pls delete the data form particular sales order and ECC side delete the setup tables and reload it again

check the results for object

Thanks,

Phani.

[Former Member]

Hi,

net values should be mapped from 2lis_13_vditm (if you didn't do any changes to the mapping post business content instalation , then this keyfigure should have mapped )

no need to map it from 2lis_12*

please check again, your cube might have both dev and qa data for this customer, if so, please set a filter on request id (QA data) and then check the report.

if not, try to do selective deletion of this customer alone from, then filter this customer in 2lis_13_vditm DTP and load again (as you said, you have correct data in PSA).

[Former Member]

Hi jyothi,I already put filter on request id on  report its fetching from quality data,and also iI deleted the request and loaded the data again but same result no change.

what can I do further?

Thanks and regards,

jyotsna singh

[Former Member]

Hi,

you have double data in 0sd_c03? if yes, then can you go to PSA table (data source --> goto (from Menu bar) -->technical attributes-->psa table), then check data for this customer first.

[Former Member]

Hi jyothi ,

I have double data in cube and multi provider both .In psa (2lis_13_vditm )data is not availabe after filtering the billing type.

What can i do next?

Thanks

[Former Member]

why don't you just drop cube and psa data, then load data again from source? if you dont want to load all data, just full load only for specific customer.

if you have process chain which updates data to 0sd_c03, then run it instead of loading data manually.

Note: if you drop cube data and reload it from 11, 12 and 13 datasource,  make sure you drop PSA data as well and reload from scratch..

[Former Member]

Hi jyothi,

I dropped all cube and (psa) data and loaded again but no changes .

at (psa) level net value is same as (vbrk) table's net value ,but at cube and multi provider its doubling.

I really don't knew what to do?

Thanks

[Former Member]

Hi,

what all DTP's (both 12 and 13 item and header)  did you run to load data to 0sd_c03?

[Former Member]

H jyothi,

yes all DTP'S  I executed and loaded data to 0sd_c03.

[Former Member]

hmm.. ok I suspect you map net value from two different data sources which is data is getting summarized, please see my previous suggestion below.

net values should be mapped from 2lis_13_vditm (if you didn't do any changes to the mapping post business content instalation , then this keyfigure should have mapped )

no need to map it from 2lis_12*

[Former Member]

jyothi,

NET VALUE is not mapped in (2lis_13_vdhdr) data source.Standard mapping is there for  net value(2lis_13_vditm) data source.so it cant summed I think so.what do do now?

Thanks

[Former Member]

Hi all,

For net value in vbrk table its there from 2015 but in report its fetching from 2014 to 2015 thats why values for net value is getting doubled .please help me some body what can I do next I am waiting.

Thanks and regards ,

jyotsna singh

[Former Member]

Hi all,

I tried my best as you guys suggested me but still the problem is not yet solve ,please help me what can I do?do anybody have the solution please guide me.

Thanks and regards ,

Jyotsna singh

[Former Member]

Please some body help me .What can I do  next ,I am waiting.

Thanks and regards,

jyotsna singh

[karthik_vasudevan]

Hi Jyotsna

Would you please check if the fiscal year is available in report. As you have mentioned net value is showing for both years, then even debit in local currency should also show double. So there is something else missing here.

Please take a look at the data in cube split by year and do the same in report level.

May be there is a restricted keyfigure created for Debit in LC and not for Net value. Compare both the KFs and come to a conclusion

Regards

Karthik

[Former Member]

Thanku so much Karthik for replying me .I will do as you suggested and get back to you .

Thanks and regards,

jyotsna singh