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

Using KNVV table in report against 2LIS_11_VAITM

Hello

My BW report on SD requires two fields payment terms and complete delivery indicator. I have found out that this fields are in Customer master sales data table - KNVV. How do I bring this fields to use in my Infocube design?

Do I enhance them against my saled document item data - 2LIS_11_VAITM or can i use them as masterdata characteristics. I am not sure if the customer master data table is a transactional table or a master data table, if it is, are the fields merely text of the characteristics customer master sales data?

Thank you

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 Apr 22, 2007 at 08:17 PM

    Hi,

    either you stamp them on your transaction data record when loading the cube or you get them from the info object 0CUST_SALES as navigation attributes. It's up to you and your customer to decide what view they want.

    Anyway.

    Use 0CUST_SALES and it's a master data table.

    Kind regards

    /martin

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi,

      sure, but you say that you have resloved it at R/3 level. I though that meant that you had enhanced your data source? What have you done?

      If you want to add a field to 2LIS_11_VAITM you enhance the extract structure using communication structure (MCVBAP) in SE11. You also have to add the new fields to the data source in LBWE and write your user exit in CMOD.

      Basically you take the customer number and the other fields from VBAP to read the key of KNVV and then select the field you want to add from KNVV to 2LIS_11_VAITM.

      There are many posts here on how to enhance your LO-data sources if you serach

      Good luck

      Kind regards

      /martin

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.