Scribd Logo
Upload

Welcome to Scribd!

  • 101 views

    HowTo Evaluate Where Master Data Is Being Used PDF

    Uploaded by

    Ranjith Reddy
    Howto evaluate where master data is being used in BW infoproviders. Based on OSS note 1305595 which deserves much more appreciation.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd

    HowTo Evaluate Where Master Data Is Being Used PDF

    Uploaded by

    Ranjith Reddy
    101 views4 pages
    Howto evaluate where master data is being used in BW infoproviders. Based on OSS note 1305595 which deserves much more appreciation.

    Original Title

    HowTo evaluate where master data is being used ...pdf

    Copyright

    © © All Rights Reserved

    Available Formats

    PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    Howto evaluate where master data is being used in BW infoproviders. Based on OSS note 1305595 which deserves much more appreciation.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    101 views4 pages

    HowTo Evaluate Where Master Data Is Being Used PDF

    Uploaded by

    Ranjith Reddy
    Howto evaluate where master data is being used in BW infoproviders. Based on OSS note 1305595 which deserves much more appreciation.

    Copyright:

    © All Rights Reserved
    Download as PDF, TXT or read online from Scribd
    Download as pdf or txt
    You are on page 1of 4

    2/6/2015

    HowToevaluatewheremasterdataisbeingused...|SCN

    GettingStarted Newsletters

    Hi,Ranjith

    LogOut

    Products

    Services&Support

    AboutSCN

    Downloads

    Industries

    Training&Education

    Partnership

    DeveloperCenter

    Activity

    LinesofBusiness

    UniversityAlliances

    Events&Webinars

    Innovation

    Browse

    HowToevaluatewheremasterdataisbeing
    usedinBWinfoproviders

    Store

    SearchtheCommunity

    6points

    Communications

    Actions

    Create

    Version1

    createdbyEdoMeinemaonSep27,201212:05PM,lastmodifiedbyEdoMeinemaonOct3,20127:43AM

    Share

    Tweet

    Like

    Introduction
    Everyonceinawhileyouneedtodeletemasterdataforwhichtransactionaldatastillexists.Mostlikely
    result:themasterdatacannotbedeleted.Todeletethemasterdata,theremustbenotransactionaldata
    whichisbeingbyreferencedbythismasterdata.Itmustbenolongerbeusedasattributevalue,usedin
    hierarchiesanditmustnotbeusedinaquery.Usingthewhereusedlistintransaction<RSD1>foranInfo
    objectprovidesyouwithalistofInfoproviderslikeInfocubes,Datastoreobjectsetc.butitdoesnotprovide
    thedetailsofaparticularmasterdatainthatInfoobjectwhichisbeingusedintheseInfoprovidersThis
    documentdescribesthestepsthathavetobeperformedtofindoutwhereaparticularmasterdatavalueis
    beingused.ItisbasedonOSSnote1305595whichdeservesmuchmoreappreciation.Hencethis
    document...

    Audience
    SAPBWAdministrators/Developers.

    TableofContents
    Introduction
    Audience
    TableofContents
    1.FindtheSIDofthemasterdatavalue
    2.Findtherelatedinfoproviders

    Your

    1.FindtheSIDofthemasterdatavalue
    ThischapterdescribesthestepstofindtheSIDofthemasterdatavaluethatwillbeusedinthenextchapter.
    AsanexampleIwilltakearandommaterialnumberofinfoobject0MATERIAL:41458MilkshakeStrawberry
    Step1:LogontotheBWsystem.
    Step2:Executetransaction<RSD1>,fillouttheinfoobject0MATERIALandclick<Display>.

    Step3:DoubleclicktheentryforthefieldSIDtabletoswitchtothetableviewforthistable.

    http://scn.sap.com/docs/DOC31968

    1/4

    2/6/2015

    HowToevaluatewheremasterdataisbeingused...|SCN

    Step4:ClicktheContentsbutton.

    Step5:EnterthematerialnumberandpresstheExecutebutton.

    Step6:NotedowntheSID(8361).

    2.Findtherelatedinfoproviders
    Step7:Executetransaction<SE37>,filloutthefunctionmodule<RSDDCVER_USAGE_MDATA_BY_SID>
    andclicktheTest/Executebutton(F8).

    Step8:FillouttheparameterI_IOBJNMwiththeinfoobject0MATERIAL.

    Step9:ClickonthetablepictureforparameterI_T_SID_CHECKandfillouttheSIDthatwasretrievedin

    http://scn.sap.com/docs/DOC31968

    2/4

    2/6/2015

    HowToevaluatewheremasterdataisbeingused...|SCN

    step6.YoucanentermultiplevaluesusingtheNewLinebutton.

    Step10:Gobacktothepreviousscreenandexecutethefunctionmodule(F8).

    Theentriesconsistofinformationonwherethespecificmaterialnumberisbeingused.Forexamplethebelow
    valueE_T_ULIST_ATR_NAVshowsthatthismaterialnumberisalsobeingusedasanattributevalueforthe
    infoobjectCRMProduct(0CRM_PROD)

    1830Views
    Topics:business_intelligenceTags:deletion,delete,list,master_data,entry,entries,sid,masterdata,cubes,whereused,
    where_used,in_use

    AverageUserRating

    MyRating:

    (1rating)

    Share

    Tweet

    http://scn.sap.com/docs/DOC31968

    Like

    3/4

    2/6/2015

    HowToevaluatewheremasterdataisbeingused...|SCN

    0Comments
    Therearenocommentsonthisdocument.

    SiteIndex
    Privacy

    ContactUs
    TermsofUse

    http://scn.sap.com/docs/DOC31968

    SAPHelpPortal
    LegalDisclosure

    Copyright

    FollowSCN

    4/4

    You might also like