Skip to Content
avatar image
Former Member

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

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Apr 12, 2016 at 05:42 AM

    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

    Add comment
    10|10000 characters needed characters exceeded