Skip to Content
author's profile photo Former Member
Former Member

Basics...

Hi gurus - I have a long chain of questions.. (possibly dumb ones. But please clariy for me..

q1.

I am trying to set-up a bw sandbox. The basis team says they have established all the RFCs for bw and r/3 and settings for the flat-files from pc too. I want to know what are the steps I should be following in bw for making it possible to to extract data from flat files and r/3.

This is a fresh install so we don't have the luxury of having a production copy data for this.

What's the step-by-step procedure to set up extraction for SD,FI & MM.

(In BW data sources, what is the difference between

SAP APPLICATION COMPONENTS & SAP R/3 APPLICATION COMPONENTS.. (some fields show up in more than one node)

q2.

I am trying to load an object Zdistr_chan from 0distr_chan(from r/3). I have created an direct update infosource

and tried to assign a r/3 datasource. It listed out all the available datasources but 0distr_chan wasn't found ?

How should I proceed ?

q3.

What is the significance of a '+'/'-'/'Mark' mark against a datasource.

q4.

I find master attr in more than one place. Where and how should I check if this datasource has been assigned to another

user ?

0material_attr:

\SAP\Application Components\Application Components\Logistics\Master data Logistics in general

\SAP\SAP Application Components\Logistics - General\Logistics Master Data

what is the difference between the above two ?

q5.

If I make an inofobject as an infoprovider will I be able to make it again as an infoobject ?

q6.

I have created a infoobject IOMAT with no attributes (with medium text). I am trying to load it with r/3 data. I have created the infosource and while trying to assign the datasource (attr & text), there is a message:

ConvExits for assigned InfoObjects inconsistent

ALPHA (KS) - MATN1(TS)

Where can I look for conversion exits and the explanation of the error ?

In transfer rules, how do I specify if it's a direct transfer without any modifications of if it's not direct transfer requiring more manipulation.

q7.

I am trying to assign a r/3 datasource for an object I have created (IOMAT with content attributes 0matl_cat,0matl_type & 0Division) and medium text.

When I give the two datasources 0material_attr & text,

everything goes fine for 0material_attr. But for 0material_text, there is an error message "Error when writing routines"

Is there something I am missing.

Please let me know how should I go about it.

Thanks.

Add a comment
10|10000 characters needed characters exceeded

Related questions

6 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Oct 16, 2005 at 09:08 AM

    Hi,

    1.http://help.sap.com/bp_biv135/BBLibrary/documentation/B84_BB_ConfigGuide_EN_DE.doc

    2.for getiing displayed the R/3 data sources, goto the particular source system right click then select replicate.. Once u assigned a data source to the Infosource then it will not be seen in the available datasource list.. If u want remove the assignment goto the infosource maintenance screen menu Infosource->remove source system assignment...

    4.Go to where used list in the under business content pushbutton select ur data source it will display the details..

    Or Go to the metadta repository select ur data source it will display in a graphical format...

    6.Flag check box lower case letters in general tab of IOMAT and select the conversion routine ALPHA..

    Click on the infoobject icon in transfer rules u will get a pop up there the first option fields r copied from TS & not modified..

    Regards-

    Siddhu

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 14, 2005 at 08:12 AM

    1. If the source systems were installed, you have to replicate the datasources (for SAP sourcesystems). Flat-file datasources have to be created manually in BW

    2. Probably, the datasource 0DISTR_CHAN_ATTR was assigned to infoobject 0DISTR_CHAN. You will have to release this assignment.

    3. What do you mean exactly???

    4. There is no difference. Infoobjects can be assigned to more than one infoarea

    5. An inofobjects remains being an infoobject. The definition as dataprovider just enables you to create queries against the infoobject and to use it in multiproviders

    6. Inconsistent conversion rules have (usually) no effect, if the source system was a SAP system. You can resolve it by changing the conversion rule for your target infoobject in infoobject definition.

    The mapping method in transfer rules is displayed by the icon between source and target infoobject.

    7. Check the mapping, if it's correct, leave the administration of the infosource, reopen it and activate again for the text datasource assignment.

    Add a comment
    10|10000 characters needed characters exceeded

    • T-Codes: In SE16 look at table TSTCT.

      What exactly do you mena by release: Are you talkign about transporting the datasource-infosource assignment? If yes, then you just need to make sure that the data source has been replicated in the target system.

      The level you can see when you open up the collected objects hierarchy: Like InfoArea > Cube > Update Rules > InfoObjects > Attributes etc...

      You can have common or separate files. I prefer to keep them separate. The name be loaded as an attr.

      Hope this helps...

  • author's profile photo Former Member
    Former Member
    Posted on Oct 14, 2005 at 05:00 PM

    Q6: Conversion routines are specified in the infoobject.

    ALPHA conversion means that numbers will be left-filled with '0' and characters will be right filled with spaces.

    MATN1 conversion is specifically for material id's.

    There is a white paper about the conversion routines in www.service.sap.com/bi -> media library -> howto.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 14, 2005 at 04:53 PM

    Q4: An infoobject can occur in several infoobject-catalogs. Don't worry, there is only one infoobject 0MATERIAL. All references point to the same infoobject.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 14, 2005 at 04:55 PM

    Q5: No. An infoobject can ALSO be an infoprovider. But it still remains an infoobject.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Oct 14, 2005 at 05:03 PM

    Q7: I get the impression that you added 'short description' as an attribute to your master data. Is that correct? This is not needed since the needed table for masterdata text is automatically generated.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Bhanu Gupta

      Hi - There was an observation from Maik at teh beginning of the topic given below..

      *****

      2. Probably, the datasource 0DISTR_CHAN_ATTR was assigned to infoobject 0DISTR_CHAN. You will have to release this assignment.

      So, if a datasource has been assigned to a infosource for one user, I should still see it under the available datasources, right ? But I don't see my datasource.

      Please let me know how I should proceed.

      Thank you.

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.