Scribd
Upload
109 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

HowTo Evaluate Where Master Data Is Being Used PDF

Uploaded by

Ranjith Reddy
109 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
109 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 1/ 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