Pricing Conditions

[Former Member]

The business group needs the ability to query pricing condition records to check the applied price condition(s) given the information on an order in BW. For this to happen, I need to join 33 'A' tables (with condition types) with KONH where match exists for KNUMH. I will also be joining table KONP and 2 other Ztables and then load the data to a DSO in BW. I can't find a standard datasource that can help me achieve this goal since the closest one, 0WS_CONDREC_ATTR has a FM WS_BIW_CONDREC_GET which has 3 table joins (KONP,KONH, & KONA-we don't need this table). Since I have to build a custom extractor and FM, does anyone know how I can get the delta records and how I can improve performance since the logic will be reading over 30 tables? Thanks in advance..

[MGrob · Accepted solution]

Hi

We have build up the condition schema based on orders and used the DS 2LIS_11_VAKON for the exact business scenario you described.

If you really need to join all these tables I would recommend create programm filling you a SAP Z Table whcih you extract with a FM module to actually get a reasonable performance.

hope it helps

Martin

[Former Member]

Hi Jim,

are you creating your generic datasource based on view or function module? if you are using a view you can use ale delta for A table changes

[anshu_lilhori]

Hi,

Are you only referring to sales order if yes then you may try with the following datasource

2LIS_13_VDKON

IF its related to MM then check this document

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/403b299b-94e5-2c10-a3b4-e2cecb8ee...

Hope this gives some idea.

Regards,

AL

[Former Member]

Anshu,

Yes it is Sales but the DS you have mentioned will  not help either. Looks like I will have to create custom DS and FM to achieve this which I would rather avoid since there are too many tables involved. Any ideas are welcome.. thanks