Sales Performance Report

[Former Member]

Hi,

I am working on Sales Performance Report,where i have to join A984 table and KONP Table to meet my Client report requirement. A984 tabe consists of Material Number and Condition Record Number, KONP table consists of Material Price. A984 tables data, I extracted separately creating Datasouce in R/3. From KONP table i am not able to extract the data. For that i enhanced datasource field KBETR into 2LIS_11_VAKON. Now I can Join A984 and enhanced DataSource 2LIS_11_VAKON, but my Functional Consultant told that we can not Join A984 and 2LIS_11_VAKON, because A984 is MasterData and 2LIS_11_VAKON is Transaction data.

Please guide me other ways to invoke KBETR field in to BW.

Points will be assigned.

Thanks

Narender

Email: nnaren2004@rediffmail.com

[Former Member · Accepted solution]

Hi,

I think 2LIS_11_VAKON DS is sufficient to bring all Condition data of all sales Orders. I am wondering why do you need to look in to the table A984.

0KNVAL and 0KPRICE are very useful IO of the standard ODS 0SD_O05.

With rgds,

Anil Kumar Sharma .P