Question:
Hi Gurus ( el, ....)
I am working on BW v21c on top of an IS Media Soln. I am facing 2 problems
OBJECTIVE1
I am trying to load the attributes in the customer master table ( infoobject=0ME_PARTNER).There are 3 navigation attributes that i am trying to load data against a customer namely city ( 0ME_CITY01) , region (0REGION) and country (0COUNTRY).
Mind you 0ME_CITY01 was a display attribute with lowercases before i changed it to a navigation attribute.It did not have the conversion routine "ALPHA" in its infoobject definition.
PROBLEM 1
The upload into the PSA was no issue.
A further dataupload from the PSA into the cube gave an error.I analysed the error and the impression i have got is that all the city data is coming in lowercase letters.
The data is not converted to uppercase and thus an error .The conversion exit is switched on in the infopackage
QUESTIONS ON PROBLEM 1
1 How do i upload the attributes successfully?What could be wrong
2 Should i put ALPHA in the definition of city and then it will work
3 Should i try and get the ALPHA in the transfer structure?How do you do that
4 Is there any other way?
OBJECTIVE2
I am trying to upload the " purchase order no" field in the data target.But the field is not uploaded due to the alpha conversion not working ( lowercase to uppercase conversion is not happening)
The infobject defn has a ALPHA in it,the infopackage has conversion exit has switched on
PROBLEM 2
1 How do i enable alpha conversion for this txn field? What am i not doing
Sincerely
SINCERUS
Answer:
what about just adding "translate to upper case" in a transfer rule for the object giving problems ?
Ch
_________________
_
There are only 10 types of people in the world :
those who understand binary and those who don't.
Answer:
Hi chc
OBJECTIVE 1
Thanks a ton.I was able to fix my master data problem by attaching a " translate to uppercase" code in the transfer rule.
OBJECTIVE 2
As far as the txn data field " purchase order no" which was to be converted to uppercase for alphanumeric values. We were controlling this conversion through a user exit as " purchase order no field" was appended to the standard datasource.
PROBLEM
However now i am getting the error for numeric value numbers in the purchase order number field (INFOOBJECT=RO_NUMBER) in the monitor
The error message is as follows
" INFOBJECT /BIC/RO_NUMBER CONTAINS VALUE 410702, WHICH IS NOT CONVERSION EXIT COMPLIANT"
QUESTION
1 How do i solve this in the most proper way?
2 Should i switch off the conversion exit
3 Activate the checkbox in the transfer rule? Why is it there
4 Write a routine in the infobject definition
5 Write a tranfer structure routine
SINCERUS
Answer:
objective 2
in your user-exit, try concatening enough leading zeroes to your number to completely fill the field
Ch
_________________
_
There are only 10 types of people in the world :
those who understand binary and those who don't.
Answer:
THANKS CHC! THANKS A LOT