‎2007 Aug 21 8:40 AM
1.How can we check whether a field has a conversion routine attached to it?What is meant by a conversion routine?can you site one example of a field which has a conversion routine attached to it?
2.WHAT IS THE WAY U FOLLOW TO COMBINE INFORMATION FROM TWO ABAP DICTIONARY TABLE INTO A SINGLE INTERNAL TABLE (EXCEPT JOINING)?
‎2007 Aug 21 8:49 AM
Hi!
1. Go to SE11. Check the fields's data element. In the data element, you'll see the domain. Double click on the domain. In the domain you can see, is there a conversion routine or not. (best example MARA table MATNR field - MATNR data element - MATNR domain - MATN1 conversion routine).
2. The best way for frequently used tables - I think - to create a view in SE11 transaction. Of course it is using a JOIN technology.
Regards
Tamá
‎2007 Aug 21 8:51 AM
Hi
1 . check the field domain......
2. use for all entries.....
reward points to all helpful answers
kiran.M
‎2007 Aug 21 8:52 AM
conversion converts data from display format to sap format vice versa u fin these routines in domain ex : alpha
‎2007 Aug 21 9:09 AM
Hi..Debanjan.
<b>Conversion Routine</b>
It is used to Convert data from SAP internal format to Display format and Vice versa.
Every Conversion Routine is a Set of Two Function modules
Naming:
CONVERSION_EXIT_<name>_INPUT
This FM converts the Data from External display format to internal Storage Format. (For eg Adding with LEADING ZERO)
CONVERSION_EXIT_<name>_OUTPUT
This FM converts the Data from internal Storage Format TO External display format (For eg Removing LEADING ZERO)
For Eg: Conversion Routine ALPHA.
CONVERSION_EXIT_ALPHA_INPUT
CONVERSION_EXIT_ALPHA_OUTPUT
We can find the Conversion Routine of any field in its Domain.
For eg : MARA-MATNR
Open its domain MATNR .
You can find the Conversion routine MATN1 is assigned here.
Two access data from 2 or more tables you can search for a view in Data dictionary. You can create a view if u don't find a suitable one.
View type : database view
<b>Reward if Helpful</b>