Is there a way we can upload pricing condition records from an Excel to SAP

[Former Member]

Hi Masters,

Could you please suggest if there is a way we can have a functionality of automatic upload of Pricing condition records in an Excel to SAP.

Please suggest.

Regards

Montee

[Former Member]

LSMW will work, but the interface is a bit technical for end users. If you need a more user friendly Excel pricing upload, you can try the product below. It supports sales and purchase prices.

[Excel Pricing Tool for SAP|http://cohesion.biz/store/index.php?main_page=product_info&cPath=25&products_id=115]

John Carpinelli

[Former Member]

Dear,

You can use the T.Code LSMW for upload pricing procedure.

Uploading the condition records via LSMW.

1.Go to the Tcode LSMW

2.Create the project , Subproject and Object with the description

3.Change Object attributes-maintain the object type standard as 070 Condition record

4.Goto change source field and position the curson on your condition and create new fields..

KOTABN

KSCHL

VAKEY

DATBI

DATAB

KBETR C(010) Amount

KONWA C(005) Rate Unit of Currenc

KMEIN C(002) Condition Units eg E

5.Maintain Structure Relations-Click on the relation ship button on the top against the Records BGR00 , BKOND1 and BKOND2.

6.Maintain Field Mapping and Conversion Rules as follows.

BGR00 Batch Input Structure for Session Data

Fields

XKEEP Indicator: Keep Batch Input Session After Processing ?

Rule : Default Settings Modified

Code: BGR00-XKEEP = 'X'.

BKOND1 Batch input structure for header data

Fields

TCODE Transaction Code

Code: BKOND1-TCODE = 'VK15'.

KVEWE Usage of the condition table

Rule : Constant

Code: BKOND1-KVEWE = 'A'.

KOTABNR Condition table batch input

Source: CONDITIONS-KOTABNR ()

Rule : Transfer (MOVE)

Code: BKOND1-KOTABNR = CONDITIONS-KOTABNR.

KAPPL Application

Rule : Constant

Code: BKOND1-KAPPL = 'V'.

KSCHL Condition type

Source: CONDITIONS-KSCHL ()

Rule : Transfer (MOVE)

Code: BKOND1-KSCHL = CONDITIONS-KSCHL.

BKOND2 Batch input structure for main data

Fields

PRICING - STANDARD UK Pricing Conditions - BAS and CON

Fields

VAKEY Variable key 100 bytes

Source: CONDITIONS-VAKEY ()

Code: BKOND2-VAKEY = CONDITIONS-VAKEY.

DATBI Validity end date of the condition record

Source: CONDITIONS-DATBI ()

Rule : Transfer (MOVE)

Code: BKOND2-DATBI = CONDITIONS-DATBI.

• Caution: Source field is longer than target field

DATAB Validity start date of the condition record

Source: CONDITIONS-DATAB ()

Rule : Transfer (MOVE)

Code: BKOND2-DATAB = CONDITIONS-DATAB.

• Caution: Source field is longer than target field

KBETR Amount field for batch input

Source: CONDITIONS-KBETR (Amount)

Rule : Transfer (MOVE)

Code: BKOND2-KBETR = CONDITIONS-KBETR.

KONWA R/2 table

Source: CONDITIONS-KONWA (Rate Unit of Currency)

Rule : Transfer (MOVE)

Code: BKOND2-KONWA = CONDITIONS-KONWA.

KPEIN R/2 table

KMEIN 3-Byte field

Rule : Constant

Code: BKOND2-KMEIN = 'EA'.

MWSK1 Tax on Sales/Purchases Code

KONMS Condition scale unit of measure

MXWRT Amount field for batch input

GKWRT Amount field for batch input

STFKZ Scale Type

KZNEP Condition exclusion indicator

LOEVM_KO Deletion Indicator for Condition Item

SKONWA R/2 table

Maintain Fixed Values, Translation

7 Specify Files - Specify the path where you are going to keep the load files (flat files in Notepad) for the legacy data

8 Assign Files - assign the files

Once you are done with all the above steps jsut execute the following steps....

9 Read Data

10 Display Read Data

11 Convert Data

12 Display Converted Data

13 Create Batch Input and Finally

14. Run Batch Input session...

Regards,

Sandip

[Former Member]

hei,

i think you can use upload tools like LSMW..

best regard,

Hendry