Standard Data Source usinG tables KONH & KONP .

[#1]

Dear Friends,

I need to extract data from KONP table.Basically i want to see data of VK13 . Is there any standard data source which is using these tables ?

OR will these following datasources will give the required data :

1) 2lis_11_vakon

2) 2lis_13_vdkon

Thanks & Regards

Ashutosh Singh

Edited by: DEADLOCKS on Oct 15, 2010 11:10 AM

[Former Member]

those datasources will give conditions related information...they are the closest to your requirements.

however these datasources give multiple entries per document...it's a vertical view not a horizontal view, so you might need to transpose the data in bw.

M.

[Former Member]

Dear Pal,

This 2lis_11_vakon is related to sales order & 2lis_13_vdkon is related to both billing document & sales document . But if we execute VK13 tcode, the output is related to material only. I dont find any reference of sales order or billing document in this TCODE.

So are we missing some link here or would it be advisable to got with generic data source considering that KONP table has huge amount of data . Additionaly i found one more table A520 related to VK13.

So any suggestions on your part on this matter ?

Thanks & Regards,

Ashutosh Singh

[Former Member]

Hi,

As I understand, you are trying to fetch the pricing condition details existing in your system. VK13 tcode which gives pricing condition details will not refer to any sales orders because it only displays you the price values for the different materials. Now when the Sales Orders are created, they refer to these pricing values in order to derive the prices for the line items of Sales Orders.

2LIS_11_VAKON & 2LIS_13_VDKON will not serve your purpose because these datasources will merely give you detail about Sales Order line item prices and pricing condition which contributed to derive the price of thes line items.

For your purpose, I dont think that there would be any standard datasource provided.

You would need to create a generic datasource based on function module. As every pricing condition can have multiple key combination in its access sequence, there would be multiple tables from which you would have to pull out data.

For the list of tables from which you would have to pull the data, please follow the path in your R/3 system

SPRO-> SAP Reference IMG-> Sales & Distribution-> Basic Function-> Pricing-> Pricing control-> Define Condition Types-> Maintain Condition types

Here, select your pricing condition name(which you would be using in VK13), anc click on Details.In the next screen, check what the Access Sequence name is. Next, copy this access sequence and go back to below path

SPRO-> SAP Reference IMG-> Sales & Distribution-> Basic Function-> Pricing-> Pricing control->Define Access Sequence-> Maintain Access Sequences.

Here, select your Access Sequence name and then click on Accesses. Now, you would get some table numbers like

507

508

506

You need to prefix A before all these numbers to get the table names e.g. A506, A507 etc. These are the table names that are used for maintaining pricing conditions for this condition type. You need to first fetch the data from tehse tables into internal table in function module and then based on the Condition record number that you get here, you need to fetch the Amount data for these conditions from KONP.

These details you need to fetch into BI to get the complete details on pricing conditions.

Hope this was helpful.

[Former Member]

Hi Rahul....

Your suggestions were helpfull. I'll look into SPRO and the path sequence that you mentioned .

Thanks & Regards,

Ashutosh Singh