Loading Master Data using Flat file
1. Create info object for ZTES_MATL with Type Char and length 18.
2. Add attributes like 0MAT_TYPE, 0GROSS_WT ETC based on your file structure.
3. Insert your newly created object as info provider under your Info Area.
4. Now choose Data Sources option from left side and Create the data source structure by entering the info object in the sequence of your file for PC_FILE.
For this choose option under Modeling of AWB-Data sources- Flat file-File as source
Insert info objects Attributes from your newly created Info object under Template column so that you get all technical details are copied . First row should be your newly created Info object.
5. Save your EXCEL File as .CSV( Comma Delimited ). Make sure all your data is in CAPTITOL unless otherwise required, then change your Info Object to accept the SMALL letters.
6.. Give this file Path under Extraction Tab and change the entries for DATA SEPARATOR TO ' ,'. and enter the no of rows to be excluded like Headers etc.
7 .Activate the data Source.
8.You can see the preview of your data by choosing PREVIEW Tab.
9 If everything is fine then you will see the entries like as below.
10. Choose Create Transformation from Context Menu of Test Material Attributes
11.Choose FLAT File as source and Master Data attributes from respective selections , and select your Data Source created above.
13.If you need to change the rule instead of direct assignment , then choose the appropriate function from RULE
14. Create info package from Context menu of Data Source and execute the same choosing Schedule Tab. See the Progress by choosing Monitor from the Toll bar. Once you see the Success light then your extraction is completed.
15. Create DTP and execute the same. Once you get POPUP , choose YES to see the progress.
Here also you will GREEN LIGHT FOR success.
1. Create info object for ZTES_MATL with Type Char and length 18.
2. Add attributes like 0MAT_TYPE, 0GROSS_WT ETC based on your file structure.
3. Insert your newly created object as info provider under your Info Area.
4. Now choose Data Sources option from left side and Create the data source structure by entering the info object in the sequence of your file for PC_FILE.
For this choose option under Modeling of AWB-Data sources- Flat file-File as source
Insert info objects Attributes from your newly created Info object under Template column so that you get all technical details are copied . First row should be your newly created Info object.
5. Save your EXCEL File as .CSV( Comma Delimited ). Make sure all your data is in CAPTITOL unless otherwise required, then change your Info Object to accept the SMALL letters.
6.. Give this file Path under Extraction Tab and change the entries for DATA SEPARATOR TO ' ,'. and enter the no of rows to be excluded like Headers etc.
7 .Activate the data Source.
8.You can see the preview of your data by choosing PREVIEW Tab.
9 If everything is fine then you will see the entries like as below.
10. Choose Create Transformation from Context Menu of Test Material Attributes
11.Choose FLAT File as source and Master Data attributes from respective selections , and select your Data Source created above.
12.Complete the mapping by creating link between left and right structures.
Since Both source and Target are same , you don't need to anything as system proposes mapping unless if you want to change.
Since Both source and Target are same , you don't need to anything as system proposes mapping unless if you want to change.
13.If you need to change the rule instead of direct assignment , then choose the appropriate function from RULE
14. Create info package from Context menu of Data Source and execute the same choosing Schedule Tab. See the Progress by choosing Monitor from the Toll bar. Once you see the Success light then your extraction is completed.
15. Create DTP and execute the same. Once you get POPUP , choose YES to see the progress.
Here also you will GREEN LIGHT FOR success.
16. Finally the data can be viewed by choosing the option Display Data from Context menu of your Info Object. Also choose the objects you need to display by choosing option Field selection for output. choose the column names , click F8 and again F8.
