[go: up one dir, main page]

0% found this document useful (0 votes)
149 views6 pages

6 - Data Conversion Specification - ROUTING Template

This document provides a functional specification for data conversion. It outlines extraction rules to pull data from legacy systems as well as purging actions. It also describes conversion tables that contain mapping information to transform extracted data into the new format. Finally, the document lists over 60 different views, fields, and their descriptions to include in the conversion.

Uploaded by

venkay1123
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOC, PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
149 views6 pages

6 - Data Conversion Specification - ROUTING Template

This document provides a functional specification for data conversion. It outlines extraction rules to pull data from legacy systems as well as purging actions. It also describes conversion tables that contain mapping information to transform extracted data into the new format. Finally, the document lists over 60 different views, fields, and their descriptions to include in the conversion.

Uploaded by

venkay1123
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOC, PDF, TXT or read online on Scribd
You are on page 1/ 6

Creator :

DATA CONVERSION FUNCTIONAL SPECIFICATION Date : 23/01/02

ROUTING Version : 1.0

522317187.doc Page : Page 1 of 6

DATA CONVERSION FUNCTIONAL SPECIFICATION

ROUTING
522317187.doc Page 2 of 6
LEGACY EXTRACTION & PURGING RULES
1. GENERAL INFORMATION
1.1.

2. EXTRACTION RULES
2.1.

3. PURGING ACTIONS
3.1.

LS CLEANING

X-REF and CONVERSION TABLES

NAME RESPONSIBLE DESC

RULES

1 - GENERAL RULES

ID RULE
G001
G002

2 - VIEW FIELDS RULES

ID View View_Block Field_Desc Table Field Type Len RULE


2 Initial Screen Initial Screen Material number RC27M MATNR Char 18
3 Plant RC27M WERKS Char 4
4 Sales document RC271 VBELN Char 18
5 Sales document item RC271 POSNR NumC 6
6 Work breakdown structure element (WBS element) RC271 PSPNR NumC 8
7 Key for task list group RC271 PLNNR Char 8
8 Validity Change number RC271 AENNR Char 12

522317187.doc Page 3 of 6
ID View View_Block Field_Desc Table Field Type Len RULE
9 Key date RC271 STTAG Dats 8
10 Revision level RC271 REVLV Char 2
11 Further data Profile RC271 PROFIDNETZ Char 7
12 Header Task List Group counter PLKOD PLNAL Char 2
13 Task list description PLKOD KTEXT Char 40
14 Plant PLKOD WERKS Char 4
15 Indicator: long text exists RC270 TXTKZ Char 1
16 Production Line Line hierarchy PLKOD LINE Char 8
17 General Data Indicator: Delete completely in reorganization run PLKOD DELKZ Char 1
18 Task list usage PLKOD VERWE Char 3
19 Status PLKOD STATU Char 3
20 Responsible planner group/department PLKOD VAGRP Char 3
21 Work center for capacity planning PLKOD KAP_ARBPL Char 8
22 Recalculate standard values at order creation using PLKOD FLG_CAPO Char 1
CAPP
23 From lot size PLKOD LOSVN Num 13.3
24 To lot size PLKOD LOSBS Num 13.3
25 Task list unit of measure PLKOD PLNME Char 3
26 Old number PLKOD PLNNR_ALT Char 20
27 Parameters for Identification for the inspection point field PLKOD SLWBEZ Char 3
dynamic combination
modification/inspection
points
28 Indicator: partial lot assignment in the insp. during PLKOD PPKZTLZU Char 1
prod.
29 Sample-drawing procedure PLKOD QPRZIEHVER Char 8
30 Level at which dynamic modification parameters are PLKOD QDYNHEAD Char 1
defined
31 Dynamic modification rule PLKOD QDYNREGEL Char 3
32 Further QM data Indicator: external numbering of units to be PLKOD EXTNUM Char 1
inspected
33 Sequence details Sequence Sequence description PLFLD LTXA1 Char 40
34 Alignment key for scheduling PLFLD AUSCHL Char 1
35 Operations Operation Operation/activity number PLPOD VORNR Char 4
36 Sub-operation PLPOD UVORN Char 4
37 Work center PLPOD ARBPL Char 8
38 Plant PLPOD WERKS Char 4
39 Control key PLPOD STEUS Char 4
40 Standard text key PLPOD KTSCH Char 7
41 Operation short text PLPOD LTXA1 Char 40
42 Indicator: long text exists RC270 TXTKZ Char 1
43 Operation details Standards values Base quantity PLPOD BMSCH Num 13.3
44 Unit of mesures Numerator for converting task list and oper. un. of PLPOD UMREZ Num 5
conversion measure
45 Denominator for converting rtg and op units of PLPOD UMREN Num 5
measure
46 Standards values Unit of measure for operation PLPOD MEINH Char 3
47 Break PLPOD ZMERH Num 9.3
48 Unit for the break time PLPOD ZEIER Char 3
49 Standard value PLPOD VGW01 Num 9.3
50 Unit of measure for the standard value PLPOD VGE01 Char 3

522317187.doc Page 4 of 6
ID View View_Block Field_Desc Table Field Type Len RULE
51 Activity Type PLPOD LAR01 Char 6
52 Standard value PLPOD VGW02 Num 9.3
53 Unit of measure for the standard value PLPOD VGE02 Char 3
54 Activity Type PLPOD LAR02 Char 6
55 Standard value PLPOD VGW03 Num 9.3
56 Unit of measure for the standard value PLPOD VGE03 Char 3
57 Activity Type PLPOD LAR03 Char 6
58 Standard value PLPOD VGW04 Num 9.3
59 Unit of measure for the standard value PLPOD VGE04 Char 3
60 Activity Type PLPOD LAR04 Char 6
61 Standard value PLPOD VGW05 Num 9.3
62 Unit of measure for the standard value PLPOD VGE05 Char 3
63 Activity Type PLPOD LAR05 Char 6
64 Standard value PLPOD VGW06 Num 9.3
65 Unit of measure for the standard value PLPOD VGE06 Char 3
66 Activity Type PLPOD LAR06 Char 6
67 Business Process Number PLPOD PRZ01 Char 12
68 Transfer to orders Cumulation type PLPOD VERDART Char 1
69 Suboper. do not apply to order PLPOD UAVO_AUFL Char 1
70 Std value calculation Type of standard value calculation PLPOD ZERMA Char 5
71 Date when the standard value was calculated PLPOD ZGDAT Char 4
72 Basis for standard value calculation PLPOD ZULNR Char 5
73 Reference number for standard value code PLPOD ZCODE Char 6
74 CAPP Type of CAPP calculation at order creation PLPOD CAPOC NumC 1
75 Interoperation times Reduction strategy per operation/activity PLPOD RSTRA Char 2
76 Indicator: simultaneous teardown and wait PLPOD ABLIPKZ Char 1
77 Maximum wait time PLPOD ZLMAX Num 9.3
78 Unit for the maximum wait time PLPOD ZEILM Char 3
79 Minimum wait time PLPOD ZLPRO Num 9.3
80 Unit for the required wait time PLPOD ZEILP Char 3
81 Standard queue time PLPOD ZWNOR Num 9.3
82 Unit for the standard queue time PLPOD ZEIWN Char 3
83 Minimum queue time PLPOD ZWMIN Num 9.3
84 Unit for the minimum queue time PLPOD ZEIWM Char 3
85 Standard move time PLPOD ZTNOR Num 9.3
86 Unit for the standard move time PLPOD ZEITN Char 3
87 Minimum move time PLPOD ZTMIN Num 9.3
88 Unit for the minimum move time PLPOD ZEITM Char 3
89 Splitting Required splitting PLPOD SPMUS Char 1
90 Maximum number of splits PLPOD SPLIM Num 3
91 Minimum processing time PLPOD ZMINB Num 9.3
92 Unit for the minimum processing time PLPOD ZEIMB Char 3
93 Overlapping Required overlapping PLPOD UEMUS Char 1
94 Optional overlapping PLPOD UEKAN Char 1
95 Indicator: continuous flow production PLPOD FLIES Char 1
96 No overlapping PLPOD UENICHT Char 1
97 Minimum overlap time PLPOD ZMINU Num 9.3
98 Unit for the minimum overlap time PLPOD ZEIMU Char 3

522317187.doc Page 5 of 6
ID View View_Block Field_Desc Table Field Type Len RULE
99 Minimum send-ahead quantity PLPOD MINWE Num 13.3
100 General Data Scrap factor PLPOD AUFAK Num 5.3
101 Number of time tickets PLPOD LOANZ Num 3
102 Number of confirmation slips PLPOD RSANZ Num 3
103 Wage group PLPOD LOGRP Char 3
104 Wage type PLPOD LOART Char 4
105 Suitability PLPOD QUALF Char 2
106 Number of employees PLPOD ANZMA Num 5.2
107 Setup type key PLPOD RASCH Char 2
108 Setup group category PLPOD RFGRP Char 10
109 Setup group key PLPOD RFSCH Char 10
110 Indicator for relevancy to costing PLPOD CKSELKZ Char 1
111 Indicator for non-value-added operations PLPOD NVADD Char 1
112 Qualification regarding Capacity category PLPOD QLKAPAR Char 3
113 Qualification Radio button for qualifications requirements PDORQ QSEL1 Char 1
114 Radio button for qualifications requirements PDORQ QSEL2 Char 1
115 Radio button for qualifications requirements PDORQ QSEL3 Char 1
116 Search criterion for qualification requirements PDORQ QL_SEARCH Char 12
117 Extrenal processing Indicator: Externally processed op. with PLPOD FRDLB Char 1
subcontracting
118 Number of purchasing info record PLPOD INFNR Char 10
119 Purchasing organization PLPOD EKORG Char 4
120 Purchasing document number PLPOD EBELN Char 10
121 Item number of purchasing document PLPOD EBELP NumC 5
122 Sort string for non-stock info records PLPOD SORTL Char 10
123 Material group PLPOD MATKL Char 9
124 Purchasing group for external processing PLPOD EKGRP Char 3
125 Account number of the vendor or creditor PLPOD LIFNR Char 10
126 Planned delivery time in days PLPOD PLIFZ Num 3
127 Price unit PLPOD PEINH Num 5
128 Cost element PLPOD SAKTO Char 10
129 Net price in purchasing info record PLPOD PREIS Num 11.2
130 Currency key PLPOD WAERS Char 5
131 Inspection type PLPOD QPART Char 8
132 QM genral Recording view PLPOD ERFSICHT Char 2
133 User defined key Key word ID for user-defined fields PLPOD SLWID Char 7
134 Component allocation Allocation (LSM fields) Material number BIMPL MATNR Char 18
135 Plant BIMPL WERKS Char 4
136 Task list type BIMPL PLNTY Char 1
137 Key for task list group BIMPL PLNNR Char 8
138 Group counter BIMPL PLNAL Char 2
139 Vendor's account number BIMPL LIFNR Char 10
140 Account number of customer BIMPL KUNR Char 10
141 Sales document BIMPL VBELN Char 10
142 Sales document item BIMPL POSNR Char 6

522317187.doc Page 6 of 6

You might also like