Question:
On extract to BW 0MATERIAL_TEXT appears to only have the internal number from SAP R/3.
When you view this datasource in R/3 with RSA3 the correct external number appears in the column labelled 'material' but on transfer to BW this column contains the R/3 internal number.
This makes material useless as no-one knows internal material numbers.
(Internal numbers are those contained in table MATERIALID field MATNR_INT as opposed to those in MATNR_EXT in this table which is how material number is normally shown in R/3.)
Answer:
table MATERIALID
don't have this table in our system...
anyway, BW does the same conversion as R/3... in the tables data is stored in internal format and on screen (in the reporting) you'll get the external format
don't see your problem
Answer:
? Table MATERIALID is in R/3
"... in the tables data is stored in internal format and on screen (in the reporting) you'll get the external format"
Thats what I don't get reports/queries etc. show internal format
Answer:
? Table MATERIALID is in R/3
here it isn't (4.6C)...
Thats what I don't get reports/queries etc. show internal format
weird... where are you getting your data from in R/3? How did you set up the transfer rules? Can you give some more details, please? Which versions are you on (R/3 and BW)?
Answer:
I'm confused
R/3 4.6C
BW 2.0B
0MATERIAL_TEXT is the latest business content.
Answer:
On extract to BW 0MATERIAL_TEXT appears to only have the internal number from SAP R/3.
When you view this datasource in R/3 with RSA3 the correct external number appears in the column labelled 'material' but on transfer to BW this column contains the R/3 internal number.
This makes material useless as no-one knows internal material numbers.
(Internal numbers are those contained in table MATERIALID field MATNR_INT as opposed to those in MATNR_EXT in this table which is how material number is normally shown in R/3.)
Don't want to discuss about the concerns around the table name (while I am also surprised by the name you gave), but :
with 0material_text, it is normal that you only see the internal number, as this infoobject is only intended to show the TEXT linked to the material, not it's (external) number
when showing on a report, the (external) number will be picked up from 0material
So, as El Belgio stated, I also don't understand your problem.
_________________
_
There are only 10 types of people in the world :
those who understand binary and those who don't.