Skip to Content
author's profile photo Former Member
Former Member

Sales Performance Report

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

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Oct 27, 2006 at 06:35 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.