How to maintain price condition record for the following senario

[Former Member]

Hi Gurus,

Can somebody help me how to maintain price condition records for the following records.

1. Price varies from origin city to destination city of the material.

2. For Ex:- Price per pallet is 100 when transported from place X to Y and 150 when transported from X to Z.

Note - volume should not exeed ex:- 1.5 CBM/pallet or 800 kg on weight which ever is applicable. On exeeding this it falls into next slab below.

3.If the pallet is 1.6 to 2 CBM/pallet or 1000kg on weight Price per pallet which ever is applicable Ex:-Price per pallet should be automatically determined as 150 when transported from place X to Y and 200 when transported from X to Z.

can somebody tell me how we can automatically determine using condition record.

thanks in advance.

RR

[Former Member]

Hi

You can maintain a new condition table which should have access seq. Ship to /Inco2.

Maintain scale in condition record as 0-1.5 100 City A 100

1.6- 2 City A rater 150

again u have to maintian this record for all destiantion and scales.You can arrange columns in excel in sequence and can copy it from there for easy entry.

Make Inco term required filed in incompletion log.

Hope this helps

Regards

Mandar

[Former Member]

Hi raja ,

Please select the table or create a table with Plant or Depature zone ( to represent the source of the material ) and tranportation zone of the ship to party along with required key field ,- This will solve your first issue

For the second issue , make sure the scale setting is maintained for the condition type with ascending sequence , the you can maintain price like below

0 - 800 Kgs - 100

800- 1600 - 150

Thanks

Jagadeeshwaran.s

[Former Member]

Hi,

Price varies from origin city to destination city of the material.

For this you have to create a new CONDITION TABLE in V/03 with the Destination countryof SHIP TO as one of the Parameter , Then add this table in the ACCESS SEQUENCE in V/07 & and now maintain this Access sequence in V/06.

While maintaining the CONDITION RECORDS system will propose the Key combination to select and maintain as per the COUNTRY in the VK11.

This will serve your purpose.

If the pallet is 1.6 to 2 CBM/pallet or 1000kg on weight Price 
  per pallet which ever is applicable Ex:-Price per pallet should be 
  automatically determined as 150 when transported from place 
    X to Y and 200 when transported from X to Z.

Maintain the scales for this CONDITION TYPE in VK11 for Volumes, then this will be determined while processing the order.

Revert back if you need further details,

thanks,

santosh

Edited by: Lakshmipathi on Oct 25, 2009 4:39 PM

Coded sentence were splitted to fit into page

[Former Member]

Hi,

But my requirement is it is fixed from a place to place. Here the sending place is is not related to the place of Sold to party. But from sender defined as a partner function and the receiving place is place of Ship to party. Can some body help me how to maintain rates between these 2 places. Are there any independent condition fields to maintain condition records which i can use and then do an abap work out if standard functionality does not support.

Thanks,

RR

[reazuddin_md]

As per your req:

Price is fixed from departure location to destination location ( Ship to party location).

Create a Zfield in Field catelog as "Destination Zone" ( maintian in KOMG structure, KOMK/KOMP) Write in Include:MV45AFZZ/RV60AFZZ Userexit(USEREXIT_PRICING_PREPARE_TKOMP /USEREXIT_PRICING_PREPARE_TKOMK) to fetch the receiving zone from Ship to party.

( Little bit coding is required here, declare newly Created Ztable is equal to Transportation zone of the ship to party. to get this provide logic to abaper such as, fetch all the partners from CMR sold to party:KNVP with partner function:WE, now go to table:KNA1, enter the customer number(ship to party) fetch, the Destination zone ( transportation zone).

Take the help of ABAPer.