Skip to Content
avatar image
Former Member

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

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Jul 16, 2010 at 04:58 PM

    hei,

    i think you can use upload tools like LSMW..

    best regard,

    Hendry

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 17, 2010 at 03:31 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 15, 2010 at 05:13 PM

    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∏ucts_id=115]

    John Carpinelli

    Add comment
    10|10000 characters needed characters exceeded