Creating Routings via LSMW

[David]

Hi all,

Can anyone give me some pointers when creating Routings via LSMW. I see there are two standard uploads in RCPTRA01 and RCPTRA02. However, the mapping structures seem to be different between the two.

I need to add PRT's material assignments and long texts to the routing.

Any help greatly appreciated.

[former_member525851]

Hi,

Use standard batch/Direct input : RCPTRA02

Source Fields

        MATERIAL_ROUTING          Material

            PLNAL                          C(002)    Group Counter

            MATNR                          C(018)    Article Number

            WERKS                          C(004)    Site

            OPERATION_ROUTING         Operations

                PLNAL                          C(002)    Group Counter

                VORNR                          C(004)    Operation/Activity Number

                STEUS                          C(004)    Control Key

                ARBPL                          C(008)    Work center

                WERKS                          C(004)    Site

                LTXA1                          C(040)    Operation short text

                MEINH                          C(003)    Quantity unit for operation (batch input)

                BMSCH                          C(017)    Base quantity (Batch input)

                LAR02                          C(006)    Activity Type

                VGE02                          C(003)    Unit for the standard value (batch input)

                VGW02                          C(011)    Standard Value (Batch Input)

                LAR03                          C(006)    Activity Type

                VGE03                          C(003)    Unit for the standard value (batch input)

                VGW03                          C(011)    Standard Value (Batch Input)

            COMPONENT_ROUTING         Components

                PLNAL                          C(002)    Group Counter

                VORNR                          C(004)    Operation/Activity Number

                POSNR                          C(004)    BOM Item Number

                MATNR                          C(018)    Article Number

                WERKS                          C(004)    Site

Field Mapping and Rule

       RC271_DS                       Work center structure for direct input (for datasets)

           Fields

               TCODE                        Transaction Code

                                   Rule :   Constant

                                   Code:    RC271_DS-TCODE = 'CA01'.

               STTAG                        Character Field Length = 10

                                   Rule :   Constant

                                   Code:    RC271_DS-STTAG = '18.03.2014'.

               AENNR                        Change Number

               REVLV                        Revision Level

               WERKS                        Site

                                   Rule :   Transfer (MOVE)

                                   Code:    RC271_DS-WERKS = MATERIAL_ROUTING-WERKS.

               PROFIDNETZ                   Profile

               PLNNR                        Key for Task List Group

               PLNAL                        Group Counter

                                   Rule :   Transfer (MOVE)

                                   Code:    RC271_DS-PLNAL = MATERIAL_ROUTING-PLNAL.

               STATU                        Status

                                   Rule :   Constant

                                   Code:    RC271_DS-STATU = '4'.

               VAGRP                        Responsible Planner Group/Department

                                   Rule :   Constant

                                   Code:    RC271_DS-VAGRP = 'KD1'.

               VBELN                        Sales Document

               POSNR                        Character field of length 6

               PSPNR                        Work Breakdown Structure Element (WBS Element)

MAPL_DI_DS                     Assign routing to article for direct input (for datasets)

    Fields

        ACTTYP                       Processing type for objects to be imported

                            Code:    MAPL_DI_DS-ACTTYP = 'H'.

        MATNR                        Article Number

                            Rule :   Transfer (MOVE)

                            Code:    MAPL_DI_DS-MATNR = MATERIAL_ROUTING-MATNR.

        WERKS                        Site

                            Rule :   Transfer (MOVE)

                            Code:    MAPL_DI_DS-WERKS = MATERIAL_ROUTING-WERKS.

        PLNAL                        Group Counter

                            Rule :   Transfer (MOVE)

                            Code:    MAPL_DI_DS-PLNAL = MATERIAL_ROUTING-PLNAL.

        LIFNR                        Vendor Account Number

        KUNR                         Account Number of Customer

        SUCHFELD                     Search Field for Customer-Specific Task List Selection

        VBELN                        Sales Document

        POSNR                        Sales Document Line Item (Batch Input Field)

        PSPNR                        Work Breakdown Structure Element (WBS Element)

PLKO_DI_DS                     Header structure for direct input (for datasets)

    Fields

        ACTTYP                       Processing type for objects to be imported

                            Code:    PLKO_DI_DS-ACTTYP = 'H'.

        PLNAL                        Group Counter

                            Rule :   Transfer (MOVE)

                            Code:    PLKO_DI_DS-PLNAL = MATERIAL_ROUTING-PLNAL.

        VERWE                        Use by user or system

                            Rule :   Constant

                            Code:    PLKO_DI_DS-VERWE = '1'.

        WERKS                        Site

                            Rule :   Transfer (MOVE)

                            Code:    PLKO_DI_DS-WERKS = MATERIAL_ROUTING-WERKS.

        STATU                        Status

                            Rule :   Constant

                            Code:    PLKO_DI_DS-STATU = '4'.

        PLNME                        Unit of measure for the task list (batch input)

                            Rule :   Constant

                            Code:    PLKO_DI_DS-PLNME = 'KG'.

        LOSVN                        From lot size (BTCI)

                            Rule :   Constant

                            Code:    PLKO_DI_DS-LOSVN = '0'.

        LOSBS                        To lot size (BTCI)

                            Rule :   Constant

                            Code:    PLKO_DI_DS-LOSBS = '999999999'.

        VAGRP                        Responsible planner group/department

                            Rule :   Constant

                            Code:    PLKO_DI_DS-VAGRP = 'KD1'.

        KTEXT                        Task list description

                            Rule :   Constant

                            Code:    PLKO_DI_DS-KTEXT = 'Article Routing'.

        TXTSP                        Single-Character Indicator

PLPO_DI_DS                     Routing/item structure for direct input (for datasets)

    Fields

        ACTTYP                       Processing type for objects to be imported

                            Code:    PLPO_DI_DS-ACTTYP = 'H'.

        PLNAL                        Group Counter

                            Rule :   Transfer (MOVE)

                            Code:    PLPO_DI_DS-PLNAL = OPERATION_ROUTING-PLNAL.

        PLNFL                        Sequence

                            Rule :   Constant

                            Code:    PLPO_DI_DS-PLNFL = '000000'.

        VORKN                        Node number (batch input)

        VORNR                        Operation/Activity Number

                            Rule :   Transfer (MOVE)

                            Code:    PLPO_DI_DS-VORNR = OPERATION_ROUTING-VORNR.

        UVOKN                        Node number (batch input)

        UVORN                        Suboperation

        STEUS                        Control key

                            Rule :   Transfer (MOVE)

                            Code:    PLPO_DI_DS-STEUS = OPERATION_ROUTING-STEUS.

        ARBID                        Object ID (batch input)

        OBJTY                        Object types of the CIM resource

        ARBPL                        Work center

                            Rule :   Transfer (MOVE)

                            Code:    PLPO_DI_DS-ARBPL = OPERATION_ROUTING-ARBPL.

        WERKS                        Site

                            Rule :   Transfer (MOVE)

                            Code:    PLPO_DI_DS-WERKS = OPERATION_ROUTING-WERKS.

        KTSCH                        Standard text key

        LTXA1                        Operation short text

                            Rule :   Transfer (MOVE)

                            Code:    PLPO_DI_DS-LTXA1 = OPERATION_ROUTING-LTXA1.

MEINH                        Quantity unit for operation (batch input)

                    Rule :   Transfer (MOVE)

                    Code:    PLPO_DI_DS-MEINH = OPERATION_ROUTING-MEINH.

UMREN                        Denominator for conversion from unit to base unit (BTCI)

                    Rule :   Constant

                    Code:    PLPO_DI_DS-UMREN = '1'.

UMREZ                        Numerator for converting from unit to base unit (BTCI)

                    Rule :   Constant

                    Code:    PLPO_DI_DS-UMREZ = '1'.

BMSCH                        Base quantity (Batch input)

                    Rule :   Transfer (MOVE)

                    Code:    PLPO_DI_DS-BMSCH = OPERATION_ROUTING-BMSCH.

ZMERH                        Break time (batch input)

ZEIER                        Unit for break time (batch input)

LAR01                        Activity Type

VGE01                        Unit for the standard value (batch input)

VGW01                        Standard Value (Batch Input)

LAR02                        Activity Type

VGE02                        Unit for the standard value (batch input)

                    Rule :   Transfer (MOVE)

                    Code:    PLPO_DI_DS-VGE02 = OPERATION_ROUTING-VGE02.

VGW02                        Standard Value (Batch Input)

                    Rule :   Transfer (MOVE)

                    Code:    PLPO_DI_DS-VGW02 = OPERATION_ROUTING-VGW02.

LAR03                        Activity Type

VGE03                        Unit for the standard value (batch input)

                    Rule :   Transfer (MOVE)

                    Code:    PLPO_DI_DS-VGE03 = OPERATION_ROUTING-VGE03.

VGW03                        Standard Value (Batch Input)

                    Rule :   Transfer (MOVE)

                    Code:    PLPO_DI_DS-VGW03 = OPERATION_ROUTING-VGW03.

PLMZ_DI_DS                     Article component allocation for direct input(for datasets)

    Fields

        ACTTYP                       Processing type for objects to be imported

                            Rule :   Constant

                            Code:    PLMZ_DI_DS-ACTTYP = 'H'.

        PLNAL                        Group Counter

                            Rule :   Transfer (MOVE)

                            Code:    PLMZ_DI_DS-PLNAL = COMPONENT_ROUTING-PLNAL.

        PLNFL                        Sequence

                            Rule :   Constant

                            Code:    PLMZ_DI_DS-PLNFL = '000000'.

        PLNKN                        Node number (batch input)

        VORNR                        Operation/Activity Number

                            Rule :   Transfer (MOVE)

                            Code:    PLMZ_DI_DS-VORNR = COMPONENT_ROUTING-VORNR.

        STLTY                        BOM category

                            Rule :   Constant

                            Code:    PLMZ_DI_DS-STLTY = 'M'.

        STLNR                        Bill of material

                            Rule :   Constant

                            Code:    PLMZ_DI_DS-STLNR = '00000005'.

        STLAL                        Alternative BOM

                            Rule :   Constant

                            Code:    PLMZ_DI_DS-STLAL = '01'.

        STLKN                        Node number (batch input)

        POSNR                        BOM Item Number

                            Rule :   Transfer (MOVE)

                            Code:    PLMZ_DI_DS-POSNR = COMPONENT_ROUTING-POSNR.

WERKS                        Site

                    Rule :   Transfer (MOVE)

                    Code:    PLMZ_DI_DS-WERKS = COMPONENT_ROUTING-WERKS.

BOMAT                        Article Number

                    Rule :   Transfer (MOVE)

                    Code:    PLMZ_DI_DS-BOMAT = COMPONENT_ROUTING-MATNR.

STLST                        Order level

STLWG                        Order path

STLTY_W                      BOM category

                    Rule :   Constant

                    Code:    PLMZ_DI_DS-STLTY_W = 'M'.

STLNR_W                      Bill of material

                    Rule :   Constant

                    Code:    PLMZ_DI_DS-STLNR_W = '00000005'.

STLAL_W                      Alternative BOM

                    Rule :   Constant

                    Code:    PLMZ_DI_DS-STLAL_W = '01'.

Map the extra fields according to your requirement. Hope you'll find the code helpful.

[Former Member]

Dear David,

Can u help me with the routing i need to enter sequence number,operations, sub operations, material assignment.can i hav the format of input file.

[former_member188685]

David will be busy, so open a new thread , for quick response. how many steps you finished..?

[Former Member]

Hi Vijay,

I created LSMW by using RCPTRA02. When i start direct input program it is saying that group cannot be determined. Actually group was an internal assignment number.

Ramu

[former_member188685]

maintaining the structure relations and Maintaining the fieldmapping is the crucial step, check both the steps. and also check any unassigned fields in mapping. try to assign them to correct fields.

[Former Member]

Dear Vijay,

Caould you tell me how many sources tructures should we cretae as iam using one source structure, to popluate the values for sequence,operation and suboperation.But i checked structures and field mapping.Iam getting an error sequence not valid.Can i have u r mail id or phno i can talk to u on this.

Ramu

[Former Member]

Hi Ramu,

i have the same problem with the RCPTRA02, that the program can't create the internal numbering.

Do you solved the problem?

kind regards

Alex

[Former Member]

Dear Alex,

I could n't solve the problem but i had used BAPI, to create the routings.IF you want i could help in that is more easy than LSMW

Ramu

[Former Member]

The RCPTRA02 problem is solved.

If you wanna INTERNAL NUMBERING then you dont have to relat to the Structure RC27M_DS.

This Structure should be not mapped.

If you do this, then everything will work.

kind regards

Alex

[Former Member]

Hi All,

I have 100 materials assigned to a routing group in the "material assignment" screen. I need to select 10 of them and delete them through LSMW. Can some one tell me if it is possible and if possible, how?

[edgar_almonte]

i try to do a upload of routings too , but in my case i will have more that one operation , and a sequence parallel , the field like PLPOD-VORNR and other when you create the second operation and the parallel sequence , so i don't know how make the upload file ( the field order in the upload file ) , i try the 0bject 0170 and method 0002 , i select the structure

RC271_DS RC27M_DS PLKO_DI_DS PLFL_DI_DS PLPO_DI_DS , but back to initial problem i dont known what do withe repeat field and how mapping it.

Thanks

[RichHeilman]

For material assignment you will need to use structures RC271_DS and MAPL_DI_DS. I am using program RCPTRA02

My input structure looks like this. THere is two input files.

MATASSIGN                 Material Assignment File                                                                                
GROUP                          C(008)    Group                     
 5  MATASSIGND                Material Assignment Detail File                                                                                
GROUP                          C(008)    Group                 
        GROUPCOUNTER                   C(002)    Group Counter         
        PLANT                          C(004)    Plant                 
        MATERIAL                       C(018)    Material                                                                                

The mappings look like this.

     5  RC271_DS                       Work center structure for direct input (for datasets)                                                                                
5  Fields                                                                                
TCODE                        Transaction code                                                                                
Rule :   Constant                                                                                
Coding:  RC271_DS-TCODE = 'CA02'.                                          


                STTAG                        Character field length = 10                                          
                                    Coding:  DATA: TDATE(10).                                                                                
CONCATENATE SY-DATUM+4(2) '/' SY-DATUM+6(2) '/' SY-DATUM(4) INTO     
                                             RC271_DS-STTAG = TDATE.                                              
                AENNR                        Change number                                                        
                REVLV                        Revision level                                                       
                WERKS                        Plant                                                                                
PROFIDNETZ                   Profile                                                              
                PLNNR                        Key for task list group                                                                                
Source:  MATASSIGN-GROUP (Group)                                                                                
Rule :   Transfer (MOVE)                                                                                
Coding:  RC271_DS-PLNNR = MATASSIGN-GROUP.                                    
                PLNAL                        Group counter                                                        
                STATU                        Status                                                                                
VAGRP                        Responsible planner group/department                                 
                VBELN                        Sales document                                                       
                POSNR                        Character field of length 6                                          
                PSPNR                        Work Breakdown Structure Element (WBS Element)                                                                                
5  MAPL_DI_DS                     Assign routing to material for direct input (for datasets)                                                                                
5  Fields                                                                                
ACTTYP                       Processing type for objects to be imported                       
                                        Rule :   Constant                                                                                
Coding:  MAPL_DI_DS-ACTTYP = 'H'.                                         
                    MATNR                        Material number                                                                                
Coding:  MAPL_DI_DS-MATNR = MATASSIGND-MATERIAL.                          
                    WERKS                        Plant                                                                                
Coding:  MAPL_DI_DS-WERKS = MATASSIGND-PLANT.                             
                    PLNAL                        Group counter                                                                                
Coding:  MAPL_DI_DS-PLNAL = MATASSIGND-GROUPCOUNTER.                      
                    LIFNR                        Vendor's account number                                          
                    KUNR                         Account number of customer                                       
                    SUCHFELD                     Search Field for Customer-Specific Task List Selection           
                    VBELN                        Sales document                                                   

If you need some more help, please get back.

Regards,

Rich Heilman

[David]

Cheers Rich, can you confirm that I need to map my routing operations to structure PLPO_DI_DS? I have done this but none of my records ever read in properly. I have de-bugged the read program and it does the following:

loop at ROUTING_HEADER.

loop at ROUTING_OPERATION

where PLNAL = ROUTING_HEADER-PLNAL and

PLNNR = ROUTING_HEADER-PLNNR and

WERKS = ROUTING_HEADER-WERKS.

endloop.

endloop.

I have the following structure for my input files:

5 ROUTING_HEADER Routing Header

5 ROUTING_OPERATION Routing Operation

ROUTING_PRT Routing PRT's

ROUTING_MATERIAL Routing Material

and the following relationships:

5 RC271_DS Work center structure for direct input (for datasets) <<<< ROUTING_HEADER Routing Header

Select Target Structure RC271_DS .

RC27M_DS Material master view DIRECT INPUT routing for datasets

MAPL_DI_DS Assign routing to material for direct input (for datasets) <<<< ROUTING_MATERIAL Routing Material

PLKO_DI_DS Header structure for direct input (for datasets)

PLFL_DI_DS Sequence structure for direct input (for datasets)

PLPO_DI_DS Routing/item structure for direct input (for datasets) <<<< ROUTING_OPERATION Routing Operation

PLMZ_DI_DS Material component allocation for direct input(for datasets)

PLFH_DI_DS PRTs routings for direct input (for datasets) <<<< ROUTING_PRT Routing PRT

5 TXT_OBJ_DS Text Object in DIRECT INPUT process (for Datasets)

TLINE_DS SAPscript: Text lines (for datasets)

5 RCUOB1_DS Assignment of dependencies in DIRECT INPUT (datasets)

RCUOB2_DS API structure for dependency assignments (for datasets)

OBJ_NF_DS DIRECT INPUT: Fields that are not to be copied (datasets)

[RichHeilman]

In my example, I am doing material assignment against existing routings. You are creating new routings right? I have another example for that. I'll get back.

Regards,

Rich Heilman

[David]

Yeah, new routings with operations, material assignments and long texts. The operations have PRT's assigned also.

[RichHeilman]

Ok, in my "create" routine, it is only adding operations, but you may get some hints from it.

REgards,

Rich Heilman

[David]

Could you show me that then, because operations are the only thing that won't read in on my LSMW at the moment.

Cheers.

[RichHeilman]

You will need to move values into the PL<b>K</b>O_DI_DS structure. I think this is contributing to your problem.

Regards,

Rich Heilman

[Former Member]

Hello all/Rich,

Could you plz tell me how to upload longtext for routings?

currently wats happening is

when we create routings, we r unable to tick flag for longtext exists, so after this routing create, we have done recording for activating (ticking) that flag and then written program using function modules :read_text and save_text to upload longtext data.

plz tell us some other eazy way of doing this.

Reg,

P_S

[Former Member]

I Rich, I am facing a similar problem, can you please help me out.

for the transcation change routing (CA02), i have to create lsmw, which uploads

à MAPL-PLNNR (Group)

à MAPL-PLNAL (Group counter)

à MAPL-MATNR (Material)

à MAPL-WERKS (Plant)

out of it three fields are in table control in ca02.

when i create a recording and upload the data the first line item is getting upated not second becaue the line no is not getting chaged, and hence the second line item is trying to replace the first, that is the prob

Thank you