cancel
Showing results for 
Search instead for 
Did you mean: 

DOGBOY49 This is for you

deepu_p2
Active Participant
0 Kudos

I saw in one of your posts that you are able to upload routing successfully through direct input methode.

I am trying to upload routing through Batch input methode but it is not picking my operation information.

When it goes to this screen it says no relevent information is provided for this screen.

Can you provide me your structure relation ship and field mapping information.

Regards

Deepu P.

Edited by: deepu p on Jan 23, 2009 12:12 AM

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Deepu,

Program is RCPTRA02. It is probably possible to do this more than

one way, but this is the way we do it, in part because of the structure

of the data that our manufacturing group is able to give to us.

We never use teardown, we generally ONLY use setup time for fixed time

operations, We don't have multiple sequences. We use one routing for

all lot sizes.

First I do an inital pass, as follows. Creates the header and one fixed time

operation. Machine time is blank in the input file for fixed time ops. First

pass, PLNNR will be blank. Name of the file is ROUTING.CSV and

Structure is ROUTING

Input file fields

WERKS C(004) plant

KTEXT C(040) Name

ARBPL C(008) work center

VORNR C(004) Operation Number

PLNNR C(008) Routing Group

LTXA1 C(030) Operation Name

BMSCH N(010) Base Quantity

VGW01 N(010) Setup Time Std

VGE01 C(003) Setup Time Unit

VGW02 N(010) Machine Time Std

VGE02 C(003) Machine Time Unit

Field Mapping

SFC - ROUTING Create Routing (inital data plus admin Operation)

RC271_DS Work center structure for direct input (for datasets)

Fields

TCODE Transaction code

Rule : Constant

Coding: RC271_DS-TCODE = 'CA01'.

STTAG Character field length = 10

Coding: RC271_DS-STTAG = '01/01/2006'.

AENNR Change number

REVLV Revision level

WERKS Plant

PROFIDNETZ Profile

PLNNR Key for task list group

PLNAL Group counter

Rule : Constant

Coding: RC271_DS-PLNAL = '01'.

STATU Status

VAGRP Responsible planner group/department

VBELN Sales document

POSNR Character field of length 6

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

Rule : Constant

Coding: PLKO_DI_DS-ACTTYP = 'H'.

PLNAL Group counter

Rule : Constant

Coding: PLKO_DI_DS-PLNAL = '01'.

VERWE Use by user or system

Rule : Constant

Coding: PLKO_DI_DS-VERWE = '1'.

WERKS Plant

Source: ROUTING-WERKS (plant)

Rule : Transfer (MOVE)

Coding: PLKO_DI_DS-WERKS = ROUTING-WERKS.

STATU Status

Rule : Constant

Coding: PLKO_DI_DS-STATU = '4'.

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

Rule : Constant

Coding: PLKO_DI_DS-PLNME = 'EA'.

LOSVN From lot size (BTCI)

LOSBS To lot size (BTCI)

Rule : Constant

Coding: PLKO_DI_DS-LOSBS = '99999999'.

VAGRP Responsible planner group/department

Rule : Constant

Coding: PLKO_DI_DS-VAGRP = '001'.

KTEXT Task list description

Source: ROUTING-KTEXT (Name)

Rule : Transfer (MOVE)

Coding: PLKO_DI_DS-KTEXT = ROUTING-KTEXT.

TXTSP Single-character flag

QDYNREGEL Dynamic Modification Rule

QDYNHEAD Level at Which Dynamic Modification Parameters Are Defined

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

Fields

ACTTYP Processing type for objects to be imported

Rule : Constant

Coding: PLPO_DI_DS-ACTTYP = 'H'.

PLNAL Group counter

Rule : Constant

Coding: PLPO_DI_DS-PLNAL = '01'.

PLNFL Sequence

Rule : Constant

Coding: PLPO_DI_DS-PLNFL = '000000'.

VORKN Node number (batch input)

VORNR Operation Number

Source: ROUTING-VORNR (Operation Number)

Rule : Transfer (MOVE)

Coding: PLPO_DI_DS-VORNR = ROUTING-VORNR.

  • Attention: Source field is longer than target field!

UVOKN Node number (batch input)

UVORN Sub-operation

STEUS Control key

Rule : Constant

Coding: PLPO_DI_DS-STEUS = '0009'.

ARBID Object ID (batch input)

OBJTY Object types of the CIM resource

ARBPL Work center

Source: ROUTING-ARBPL (work center)

Rule : Transfer (MOVE)

Coding: PLPO_DI_DS-ARBPL = ROUTING-ARBPL.

WERKS Plant

Source: ROUTING-WERKS (plant)

Rule : Transfer (MOVE)

Coding: PLPO_DI_DS-WERKS = ROUTING-WERKS.

KTSCH Standard text key

LTXA1 Short text

Source: ROUTING-LTXA1 (Operation Name)

Rule : Transfer (MOVE)

Coding: PLPO_DI_DS-LTXA1 = ROUTING-LTXA1.

VPLTY Type of the referenced task list

VPLNR Group of the referenced task list

VPLAL Group counter of the referenced task list

VPLFL Referenced sequence in routing

VINTV Operation interval

MEINH Quantity unit for operation (batch input)

Rule : Constant

Coding: PLPO_DI_DS-MEINH = 'EA'.

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

Rule : Constant

Coding: PLPO_DI_DS-UMREN = '1'.

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

Rule : Constant

Coding: PLPO_DI_DS-UMREZ = '1'.

BMSCH Base quantity (Batch input)

Source: ROUTING-BMSCH (Base Quantity)

Rule : Transfer (MOVE)

Coding: PLPO_DI_DS-BMSCH = ROUTING-BMSCH.

ZMERH Break time (batch input)

ZEIER Unit for break time (batch input)

LAR01 Activity Type

ZEIER Unit for break time (batch input)

LAR01 Activity Type

VGE01 Unit for the standard value (batch input)

Source: ROUTING-VGE01 (Setup Time Unit)

Rule : Transfer (MOVE)

Coding: PLPO_DI_DS-VGE01 = ROUTING-VGE01.

  • Attention: Source field is longer than target field!

VGW01 Standard value (batch input)

Source: ROUTING-VGW01 (Setup Time Std)

Rule : Transfer (MOVE)

Coding: PLPO_DI_DS-VGW01 = ROUTING-VGW01.

LAR02 Activity Type

VGE02 Unit for the standard value (batch input)

Source: ROUTING-VGE02 (Machine Time Unit)

Rule : Transfer (MOVE)

Coding: PLPO_DI_DS-VGE02 = ROUTING-VGE02.

VGW02 Standard value (batch input)

Source: ROUTING-VGW02 (Machine Time Std)

Rule : Transfer (MOVE)

Coding: PLPO_DI_DS-VGW02 = ROUTING-VGW02.

LAR03 Activity Type

Remaining fields unmapped.

The first operation in our routings is always '0010' and is always a non-capacity consuming op (fixed time). Our Control key is always 0009.

Next, we add cap-consuming ops, one at a time, using another LSMW. So,

all operation 0020 one pass; all routings. all operation 0030, one pass, all routings;

etc etc.

Input file fields same as above, except in this case we generally leave the setup time blank and

instead enter the machine time. Name of the file is ROUTING1.CSV and structure is ROUTING1.

YOU HAVE TO HAVE THE ROUTING NUMBER GENERATED IN THE FIRST LSMW RUN and

insert it into PLNNR.

Mapping:

- SFC - ROUTING1 Change Routing (add cap based WCs)

Fielddmapping and conversion rules

RC271_DS Work center structure for direct input (for datasets)

Fields

TCODE Transaction code

Coding: RC271_DS-TCODE = 'CA02'.

STTAG Character field length = 10

Coding: RC271_DS-STTAG = '01/01/2006'.

AENNR Change number

REVLV Revision level

WERKS Plant

PROFIDNETZ Profile

PLNNR Key for task list group

Source: ROUTING1-PLNNR (Routing Group)

Rule : Transfer (MOVE)

Coding: RC271_DS-PLNNR = ROUTING1-PLNNR.

PLNAL Group counter

Rule : Constant

Coding: RC271_DS-PLNAL = '01'.

STATU Status

VAGRP Responsible planner group/department

VBELN Sales document

POSNR Character field of length 6

PSPNR Work Breakdown Structure Element (WBS Element)

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

Fields

ACTTYP Processing type for objects to be imported

Rule : Constant

Coding: PLPO_DI_DS-ACTTYP = 'H'.

PLNAL Group counter

Rule : Constant

Coding: PLPO_DI_DS-PLNAL = '01'.

PLNFL Sequence

Rule : Constant

Coding: PLPO_DI_DS-PLNFL = '000000'.

VORKN Node number (batch input)

VORNR Operation Number

Source: ROUTING1-VORNR (Operation Number)

Rule : Transfer (MOVE)

Coding: PLPO_DI_DS-VORNR = ROUTING1-VORNR.

  • Attention: Source field is longer than target field!

UVOKN Node number (batch input)

UVORN Sub-operation

STEUS Control key

Rule : Constant

Coding: PLPO_DI_DS-STEUS = '0009'.

ARBID Object ID (batch input)

OBJTY Object types of the CIM resource

ARBPL Work center

Source: ROUTING1-ARBPL (work center)

Rule : Transfer (MOVE)

Coding: PLPO_DI_DS-ARBPL = ROUTING1-ARBPL.

WERKS Plant

Source: ROUTING1-WERKS (plant)

Rule : Transfer (MOVE)

Coding: PLPO_DI_DS-WERKS = ROUTING1-WERKS.

KTSCH Standard text key

LTXA1 Short text

Source: ROUTING1-LTXA1 (Operation Name)

Rule : Transfer (MOVE)

Coding: PLPO_DI_DS-LTXA1 = ROUTING1-LTXA1.

VPLTY Type of the referenced task list

VPLNR Group of the referenced task list

VPLAL Group counter of the referenced task list

VPLFL Referenced sequence in routing

VINTV Operation interval

MEINH Quantity unit for operation (batch input)

Rule : Constant

Coding: PLPO_DI_DS-MEINH = 'EA'.

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

Rule : Constant

Coding: PLPO_DI_DS-UMREN = '1'.

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

Rule : Constant

Coding: PLPO_DI_DS-UMREZ = '1'.

BMSCH Base quantity (Batch input)

Source: ROUTING1-BMSCH (Base Quantity)

Rule : Transfer (MOVE)

Coding: PLPO_DI_DS-BMSCH = ROUTING1-BMSCH.

ZMERH Break time (batch input)

ZEIER Unit for break time (batch input)

LAR01 Activity Type

VGE01 Unit for the standard value (batch input)

Source: ROUTING1-VGE01 (Setup Time Unit)

Rule : Transfer (MOVE)

Coding: PLPO_DI_DS-VGE01 = ROUTING1-VGE01.

  • Attention: Source field is longer than target field!

VGW01 Standard value (batch input)

Source: ROUTING1-VGW01 (Setup Time Std)

Rule : Transfer (MOVE)

Coding: PLPO_DI_DS-VGW01 = ROUTING1-VGW01.

LAR02 Activity Type

VGE02 Unit for the standard value (batch input)

Source: ROUTING1-VGE02 (Machine Time Unit)

Rule : Transfer (MOVE)

Coding: PLPO_DI_DS-VGE02 = ROUTING1-VGE02.

VGW02 Standard value (batch input)

Source: ROUTING1-VGW02 (Machine Time Std)

Rule : Transfer (MOVE)

Coding: PLPO_DI_DS-VGW02 = ROUTING1-VGW02.

LAR03 Activity Type

VGE03 Unit for the standard value (batch input)

VGW03 Standard value (batch input)

LAR04 Activity Type

VGE04 Unit for the standard value (batch input)

VGW04 Standard value (batch input)

LAR05 Activity Type

VGE05 Unit for the standard value (batch input)

VGW05 Standard value (batch input)

LAR06 Activity Type

VGE06 Unit for the standard value (batch input)

VGW06 Standard value (batch input)

ZERMA Type of standard value calculation

ZGDAT Date when the standard value was calculated

ZCODE Reference number for standard value code

ZULNR Basis for standard value calculation

RSANZ Number of confirmation slips (batch input)

LOANZ Number of time tickets (batch input)

LOART Wage type

QUALF Suitability

ANZMA Number of employees (Batch-input)

RFGRP Setup group category

RFSCH Setup group key

RASCH Setup type key

AUFAK Scrap factor (batch input)

LOGRP Wage group

UEMUS Required overlapping

UEKAN Optional overlapping

FLIES Indicator: continuous flow production

ZEIMU Unit for minimum overlap time (batch input)

ZMINU Minimum overlap time (batch input)

MINWE Minimum send-ahead quantity (batch input)

SPMUS Required splitting

Rule : Constant

Coding: PLPO_DI_DS-SPMUS = 'X'.

Remaining fields unmapped.

Finally, we add the remaining fixed time operations. Same input fields, name of structure is ROUTING2

Field Mapping:

Fieldmapping and conversion rules

RC271_DS Work center structure for direct input (for datasets)

Fields

TCODE Transaction code

Coding: RC271_DS-TCODE = 'CA02'.

STTAG Character field length = 10

Coding: RC271_DS-STTAG = '01/01/2006'.

AENNR Change number

REVLV Revision level

WERKS Plant

PROFIDNETZ Profile

PLNNR Key for task list group

Source: ROUTING2-PLNNR (Routing Group)

Rule : Transfer (MOVE)

Coding: RC271_DS-PLNNR = ROUTING2-PLNNR.

PLNAL Group counter

Rule : Constant

Coding: RC271_DS-PLNAL = '01'.

STATU Status

VAGRP Responsible planner group/department

VBELN Sales document

POSNR Character field of length 6

PSPNR Work Breakdown Structure Element (WBS Element)

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

Fields

ACTTYP Processing type for objects to be imported

Rule : Constant

Coding: PLPO_DI_DS-ACTTYP = 'H'.

PLNAL Group counter

Rule : Constant

Coding: PLPO_DI_DS-PLNAL = '01'.

PLNFL Sequence

Rule : Constant

Coding: PLPO_DI_DS-PLNFL = '000000'.

VORKN Node number (batch input)

VORNR Operation Number

Source: ROUTING2-VORNR (Operation Number)

  • Attention: Source field is longer than target field!

UVOKN Node number (batch input)

UVORN Sub-operation

STEUS Control key

Rule : Constant

Coding: PLPO_DI_DS-STEUS = '0009'.

ARBID Object ID (batch input)

OBJTY Object types of the CIM resource

ARBPL Work center

Source: ROUTING2-ARBPL (work center)

Rule : Transfer (MOVE)

Coding: PLPO_DI_DS-ARBPL = ROUTING2-ARBPL.

WERKS Plant

Source: ROUTING2-WERKS (plant)

Rule : Transfer (MOVE)

Coding: PLPO_DI_DS-WERKS = ROUTING2-WERKS.

KTSCH Standard text key

LTXA1 Short text

Source: ROUTING2-LTXA1 (Operation Name)

Rule : Transfer (MOVE)

Coding: PLPO_DI_DS-LTXA1 = ROUTING2-LTXA1.

VPLTY Type of the referenced task list

VPLNR Group of the referenced task list

VPLAL Group counter of the referenced task list

VPLFL Referenced sequence in routing

VINTV Operation interval

MEINH Quantity unit for operation (batch input)

Rule : Constant

Coding: PLPO_DI_DS-MEINH = 'EA'.

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

Rule : Constant

Coding: PLPO_DI_DS-UMREN = '1'.

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

Rule : Constant

Coding: PLPO_DI_DS-UMREZ = '1'.

BMSCH Base quantity (Batch input)

Source: ROUTING2-BMSCH (Base Quantity)

Rule : Transfer (MOVE)

Coding: PLPO_DI_DS-BMSCH = ROUTING2-BMSCH.

ZMERH Break time (batch input)

ZEIER Unit for break time (batch input)

LAR01 Activity Type

VGE01 Unit for the standard value (batch input)

Source: ROUTING2-VGE01 (Setup Time Unit)

Rule : Transfer (MOVE)

Coding: PLPO_DI_DS-VGE01 = ROUTING2-VGE01.

  • Attention: Source field is longer than target field!

VGW01 Standard value (batch input)

Source: ROUTING2-VGW01 (Setup Time Std)

Rule : Transfer (MOVE)

Coding: PLPO_DI_DS-VGW01 = ROUTING2-VGW01.

LAR02 Activity Type

VGE02 Unit for the standard value (batch input)

Source: ROUTING2-VGE02 (Machine Time Unit)

Rule : Transfer (MOVE)

Coding: PLPO_DI_DS-VGE02 = ROUTING2-VGE02.

VGW02 Standard value (batch input)

Source: ROUTING2-VGW02 (Machine Time Std)

Rule : Transfer (MOVE)

Coding: PLPO_DI_DS-VGW02 = ROUTING2-VGW02.

LAR03 Activity Type

VGE03 Unit for the standard value (batch input)

Remaining fields unmapped.

That's it.

Regards,

DB49

Answers (1)

Answers (1)

deepu_p2
Active Participant
0 Kudos

thanks

I will get back to you if i face any error.

deepu_p2
Active Participant
0 Kudos

thanks.

its working