Using KNVV table in report against 2LIS_11_VAITM

[Former Member]

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

[Former Member · Accepted solution]

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

[Former Member · Accepted solution]

hello

thanks for the answer martin.

but what do you mean by stamp them in your transactional data record? how do you do that?

tosin

[Former Member · Accepted solution]

Hi,

either you do it in R/3 with an enhancement to your data source and then add the field to the record at that point. Or in the update rules or transfer rules you look up the attributes from the master data table for 0CUST_SALES and write them to your record in the cube. It will in these 2 cases have the values at load time, whereas if you use a navigational attribute you will have that values at query run-time.

This could be significant how you want to see your data.

Kind regards

/martin

[Former Member · Accepted solution]

Thanks again MArtin

I have resolved to do at R/# level.

But can you tell me please steps to take and transaction codes on how to add KNVV fields to the 2LIS_11_VAITM datasource using LO extraction and enhancement?

I believe with this, it will solve my problem completely

Thank you once again as you get more points.

Tosin

[Former Member · Accepted solution]

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