sitemap
| SapMaterial.com |
 | |  | |  | |  | |  | |  | |  | |  | |  |
Excel-SAP-Manual Phrase Conversion
This example has 3 sections..
1)functional specs.
2)technical specs.
3)upload excel file.
1st section you can see below. 2nd & 3rd sections we have given for ur download in the same page at the bottom.
Thanks for S.Kumar for contributing this example with allsaplinks.com
1)functional specs.
2)technical specs.
3)upload excel file.
1st section you can see below. 2nd & 3rd sections we have given for ur download in the same page at the bottom.
Thanks for S.Kumar for contributing this example with allsaplinks.com
Functional specs.
Description
Phrases are standardized text. These texts are used on labels, shipping documentation. Currently I2R and 3E have various “free text”
phrases. These phrases are chemical category dependent and usage relevant. These phrases are printed on the labels which are used
during various movements of goods such as goods reciept, goods issue at permi(legasy system).
In DTE2, these phrase will be used not only by Fermi but also by all other plants. All the phrases will be collected on an Excel Spreadsheet.
This excel spreadsheet is populated manually by the EH&S (including chemical, envionmental, safety and waste) users from various plants.
These phrases needs to be converted into SAP Phrases. These phrases will be grouped into phrase groups which will be according to
chemical category and/or application usage.
There are standard SAP transactions for importing phrase data into SAP. You use this function to import the following data into the SAP
system:·
Phrase library·
Phrase groups·
Phrases·
Assignments to phrase sets
Data extracted from legacy systems such as I2R, from the 3E system, or provided on Excel spreadsheets needs to be converted into a
standard SAP file format for phrase import. The SAP system checks if the data can be transferred correctly from this transfer file and
determines the phrases to be changed or created. The SAP system writes a log for the file check. You use this log to correct any errors
that occur.
For this CDD, the conversion will be from one consolidated spreadsheet which will include all possible phrases and their assignments. The
conversion is dependent on the creation of the phrase sets in SAP.
For conversion, steps will be as follows:
1) Cleanse free text “phrases” from I2R and 3E systems as well as those identified by business users -- Done by Users/Programmer
2) Collect data on Excel spreadsheet -- Done by Users/Programmer
3) Data Cleansing occurs – Done by Data Cleansing Team
4) Convert Excel spreadsheet to standard SAP phrase import format -- Done by programmer
5) Import phrases and report on errors -- Done by programmer
6) Test and Verify the uploaded data in SAP -- Done by Users
Business Drivers
This conversion is needed to support substance master creation and their subsequent output documents and regulatory reporting
requirements.This conversion is also needed to:·
Standardize the Environmental Health and Safety data entry across the enterprise·
Support the Industrial Health and Safety module
Source System(s)
Excel (data gathered from I2R-BOM, 3E, user input)Other phrases to be defined and created by the business group.After phrases are
imported into SAP, they can be exported and re-imported to other SAP system/clients.
Target System / Object
SAP
Data Type
Master
Data Formatting
SAP provides a standard data format for importing phrase data. Additional information related to the data format is attached to the end of
this document.
The format for importing phrase data is the same as for exporting phrase data. To export a sample phrase perform the following steps:
1. Goto transaction CG12, Edit Phrase
2. Press the Hit List Button (F8)
3. Select a Phrases to be exported. Note: only phrases that begin with an alpha character will be able to be imported into another SAP
system/client.
4. Select the menu path Phrase>Data Exchange>Export
5. In the Export Phrase Management, enter the file path, such as: /usr/sap/UR4/DVEBMGS00/work/phrases.dat
and also select to export from Phrase set assignments
6. Press the Export Button
7. Goto transaction CG3B, Job Overview
8. Check the job log for the phrase export
9. Follow the SAP menu to Logistics>Environment, Health and Safety>Basic Data>Tools>Data Transfer>Download File
10. Enter the file path to the file source, such as /usr/sap/UR4/DVEBMGS00/work/phrases.dat which is also listed in the job log
11. Enter the file path of where the file should be placed on the front end such as c:\temp\phrases.dat
12. The file can be down loaded as ASCII
13. The File is downloaded and can be viewed in Notepad
Legacy System Data Cleansing
Phrase data maintained manually in Nuclear Generation’s I2R system. The free text of this data needs to be identified and loaded into a
manual spreadsheet.3E also maintains phrase type data for substances and it needs to be identified, cleansed, and loaded into a manual
spreadsheet.Duplicate phrases across systems should be consolidated and merged wherever possible.
Duplication
Phrases are maintained manually within Nuclear Generation’s I2R System, some duplication may exist. Phrases from Nuclear Generation,
Fossil Generation, Energy Distribution, MICHCON, and the non-regulated businesses will be collected on an excel spreadsheet and loaded
manually into SAP.
Other
To import a phrase perform the following steps:
1. Follow the SAP menu to Logistics>Environment, Health and Safety>Basic Data>Tools>Data Transfer> Upload File
2. Enter the front end file path of the source file, such as c:\temp\phrases.dat
3. Enter the file path for the application server, such as /usr/sap/UR4/DVEBMGS00/work/phrases.dat
4. The file can be down loaded as ASCII
5. The File is uploaded
6. Goto transaction CG31, Import Phrases
7. Enter the file path on the application server, where you previously placed the uploaded file
8. Enter the Character Standard such as ISO-R/3. (Need to check if Unicode UTF-8 is supported. If so the configuration needs to be
changed and the file can be ran using UTF-8)
9. Select to import from phrase set assignments. If it is a first time load select full import.
10. Check the file (F5). . Note: only phrases that begin with an alpha character will be able to be imported.
11. Press the Transfer/Start Time (F6)
12. Schedule the job or start immediately
13. Press the Direct Input button
14. Press the execute button on the Manage Data Transfer page (transaction BMV0)
15. View the job log for the EH&S-IMP-PHR job
Volume & Frequency of creation/updates
Approximately 10,000 chemical purchases per year.Approximately 100 phrase sets to be created in SAP.Estimated 1,000 – 3,000 phrases to
be created.Ongoing updates estimated 5 – 20 per month.
EBS Transaction(s)/Application(s)
CG12 (edit phrase), CG1B (edit phrase set), CGAB (edit phrase set assignment), CG31 (import phrases)
EBS Menu PathLogistics--> Environmental, Health & Safety--> Basic Data and Tools--> Phrases -->Edit Phrases (CG12)/Edit Phrase Sets
(CG1B)/Edit Phrase Set-Attribute Assignments (CGAB)Logistics--> Environmental, Health & Safety--> Basic Data and Tools--> Tools -->
Data Transfer --> Import Phrases (CG31)
Technical specification for this example
Excel sheet to be uploaded in this example
Phrases are standardized text. These texts are used on labels, shipping documentation. Currently I2R and 3E have various “free text”
phrases. These phrases are chemical category dependent and usage relevant. These phrases are printed on the labels which are used
during various movements of goods such as goods reciept, goods issue at permi(legasy system).
In DTE2, these phrase will be used not only by Fermi but also by all other plants. All the phrases will be collected on an Excel Spreadsheet.
This excel spreadsheet is populated manually by the EH&S (including chemical, envionmental, safety and waste) users from various plants.
These phrases needs to be converted into SAP Phrases. These phrases will be grouped into phrase groups which will be according to
chemical category and/or application usage.
There are standard SAP transactions for importing phrase data into SAP. You use this function to import the following data into the SAP
system:·
Phrase library·
Phrase groups·
Phrases·
Assignments to phrase sets
Data extracted from legacy systems such as I2R, from the 3E system, or provided on Excel spreadsheets needs to be converted into a
standard SAP file format for phrase import. The SAP system checks if the data can be transferred correctly from this transfer file and
determines the phrases to be changed or created. The SAP system writes a log for the file check. You use this log to correct any errors
that occur.
For this CDD, the conversion will be from one consolidated spreadsheet which will include all possible phrases and their assignments. The
conversion is dependent on the creation of the phrase sets in SAP.
For conversion, steps will be as follows:
1) Cleanse free text “phrases” from I2R and 3E systems as well as those identified by business users -- Done by Users/Programmer
2) Collect data on Excel spreadsheet -- Done by Users/Programmer
3) Data Cleansing occurs – Done by Data Cleansing Team
4) Convert Excel spreadsheet to standard SAP phrase import format -- Done by programmer
5) Import phrases and report on errors -- Done by programmer
6) Test and Verify the uploaded data in SAP -- Done by Users
Business Drivers
This conversion is needed to support substance master creation and their subsequent output documents and regulatory reporting
requirements.This conversion is also needed to:·
Standardize the Environmental Health and Safety data entry across the enterprise·
Support the Industrial Health and Safety module
Source System(s)
Excel (data gathered from I2R-BOM, 3E, user input)Other phrases to be defined and created by the business group.After phrases are
imported into SAP, they can be exported and re-imported to other SAP system/clients.
Target System / Object
SAP
Data Type
Master
Data Formatting
SAP provides a standard data format for importing phrase data. Additional information related to the data format is attached to the end of
this document.
The format for importing phrase data is the same as for exporting phrase data. To export a sample phrase perform the following steps:
1. Goto transaction CG12, Edit Phrase
2. Press the Hit List Button (F8)
3. Select a Phrases to be exported. Note: only phrases that begin with an alpha character will be able to be imported into another SAP
system/client.
4. Select the menu path Phrase>Data Exchange>Export
5. In the Export Phrase Management, enter the file path, such as: /usr/sap/UR4/DVEBMGS00/work/phrases.dat
and also select to export from Phrase set assignments
6. Press the Export Button
7. Goto transaction CG3B, Job Overview
8. Check the job log for the phrase export
9. Follow the SAP menu to Logistics>Environment, Health and Safety>Basic Data>Tools>Data Transfer>Download File
10. Enter the file path to the file source, such as /usr/sap/UR4/DVEBMGS00/work/phrases.dat which is also listed in the job log
11. Enter the file path of where the file should be placed on the front end such as c:\temp\phrases.dat
12. The file can be down loaded as ASCII
13. The File is downloaded and can be viewed in Notepad
Legacy System Data Cleansing
Phrase data maintained manually in Nuclear Generation’s I2R system. The free text of this data needs to be identified and loaded into a
manual spreadsheet.3E also maintains phrase type data for substances and it needs to be identified, cleansed, and loaded into a manual
spreadsheet.Duplicate phrases across systems should be consolidated and merged wherever possible.
Duplication
Phrases are maintained manually within Nuclear Generation’s I2R System, some duplication may exist. Phrases from Nuclear Generation,
Fossil Generation, Energy Distribution, MICHCON, and the non-regulated businesses will be collected on an excel spreadsheet and loaded
manually into SAP.
Other
To import a phrase perform the following steps:
1. Follow the SAP menu to Logistics>Environment, Health and Safety>Basic Data>Tools>Data Transfer> Upload File
2. Enter the front end file path of the source file, such as c:\temp\phrases.dat
3. Enter the file path for the application server, such as /usr/sap/UR4/DVEBMGS00/work/phrases.dat
4. The file can be down loaded as ASCII
5. The File is uploaded
6. Goto transaction CG31, Import Phrases
7. Enter the file path on the application server, where you previously placed the uploaded file
8. Enter the Character Standard such as ISO-R/3. (Need to check if Unicode UTF-8 is supported. If so the configuration needs to be
changed and the file can be ran using UTF-8)
9. Select to import from phrase set assignments. If it is a first time load select full import.
10. Check the file (F5). . Note: only phrases that begin with an alpha character will be able to be imported.
11. Press the Transfer/Start Time (F6)
12. Schedule the job or start immediately
13. Press the Direct Input button
14. Press the execute button on the Manage Data Transfer page (transaction BMV0)
15. View the job log for the EH&S-IMP-PHR job
Volume & Frequency of creation/updates
Approximately 10,000 chemical purchases per year.Approximately 100 phrase sets to be created in SAP.Estimated 1,000 – 3,000 phrases to
be created.Ongoing updates estimated 5 – 20 per month.
EBS Transaction(s)/Application(s)
CG12 (edit phrase), CG1B (edit phrase set), CGAB (edit phrase set assignment), CG31 (import phrases)
EBS Menu PathLogistics--> Environmental, Health & Safety--> Basic Data and Tools--> Phrases -->Edit Phrases (CG12)/Edit Phrase Sets
(CG1B)/Edit Phrase Set-Attribute Assignments (CGAB)Logistics--> Environmental, Health & Safety--> Basic Data and Tools--> Tools -->
Data Transfer --> Import Phrases (CG31)
Technical specification for this example
Excel sheet to be uploaded in this example
| ||||||||||
All the best for your future..
All of the product names here are trademarks of their respective companies. The site
www.allsaplinks.com no way affiliated with SAP AG. We have made every effort for the content
integrity. Information used on this site is at your own risk.
www.allsaplinks.com no way affiliated with SAP AG. We have made every effort for the content
integrity. Information used on this site is at your own risk.
ABAP TECHNICAL
SAP Introduction
sap abap faq
sap Tables
SAP Transaction codes
Internal tables
data dictionary
performance tuning
transports & Requests
Sap scripts
Smartforms
lsmw
reports
sap Workflow
module pool/ dialog
programming
table control
user exits
sap memory
abap memory
alv reports
ABAP ADVANCED
IDOC
ALE
BAPI
BADI
RFC
FUNCTIONAL SIDE
Materials Management
FICO
Human Resources
BIW / BW / SEM
Free Documentation
Abap Material
Ale Material
BAPI Material
BC Material
IDOC Material
R/3 Database Management
SAP material
RFC
Transport
Sales & Distribution Material
Basic Data and Function
Material
Basis (BC) Material
Billing Material
CA Material
CATT : Computer Aided Test
Tool
Capacity Evaluation and
leveling Material
Capacity Planning Material
Cross Application Material
Countries
Customer Service Material
Enterpise Material
Financial / Controlling (FICO)
Internet Time Sheet
Inspection Material
HR Material
Material Management
Material
Payments Material
Payroll Material
Pension Fund
Production Planning and
Control
Plant Maintenance
Quality Management Material
Real Estate Material
SAP material
Wage Types
SAP Introduction
sap abap faq
sap Tables
SAP Transaction codes
Internal tables
data dictionary
performance tuning
transports & Requests
Sap scripts
Smartforms
lsmw
reports
sap Workflow
module pool/ dialog
programming
table control
user exits
sap memory
abap memory
alv reports
ABAP ADVANCED
IDOC
ALE
BAPI
BADI
RFC
FUNCTIONAL SIDE
Materials Management
FICO
Human Resources
BIW / BW / SEM
Free Documentation
Abap Material
Ale Material
BAPI Material
BC Material
IDOC Material
R/3 Database Management
SAP material
RFC
Transport
Sales & Distribution Material
Basic Data and Function
Material
Basis (BC) Material
Billing Material
CA Material
CATT : Computer Aided Test
Tool
Capacity Evaluation and
leveling Material
Capacity Planning Material
Cross Application Material
Countries
Customer Service Material
Enterpise Material
Financial / Controlling (FICO)
Internet Time Sheet
Inspection Material
HR Material
Material Management
Material
Payments Material
Payroll Material
Pension Fund
Production Planning and
Control
Plant Maintenance
Quality Management Material
Real Estate Material
SAP material
Wage Types