Wednesday, March 31, 2010

Short dump while doing init from ODS to Cube

If you delete data from the Cube ( Various Resons) and  again load data from ODS by choosing " Updata ODS data in data target"  and then try to do an init again, The system is gives a short dump as there are multiple init entries in ROOS* tables. follow this OSS note to solve the issue
OSS note 852443

Wednesday, March 24, 2010

How to delete data records from a table even if you dont have edit authorization !!

1) Goto se11 -> go to the table ->  see the content... from this window mark the check box for relevant  entries in the first column and click on Display button (F7)

2) enter "/h" in the command prompt and press enter.
3) Click the top most green button to execute.
4) From the debugging screen, double click on variable "CODE" change the value to "DELE" (from "SHOW") and save (by pressing enter in bi7 and by clicking pencil icon in bw 3.x ).
5) Press F8
6) In the result screen you will find the delete entry in the application bar
7) Delete one by one after ensuring the record content.

Tuesday, March 9, 2010

Error occurred while deciding partition number

I got this error while loading data for 0MATERIAL_ATTR .

Solution: 1) Check in RSCUSTV9 tcode . The update mode should be set to  "Create master data if not avaialble ( auto_sid)

               2) check  if  the "control parameters for data transfer from source system" is maintained  in source system .( Tcode : SBIW)

Problem 2: error RSDMD 194 -  Data record '    ' & with the key '0000100438 &' is invalid in value....

 Solution: 1) Check in OMSL tcode . The "material number format" should be maintained to lexicographical.
               2) Maintain special characters in RSKC.

Friday, March 5, 2010

SAP NetWeaver 7.0 - ERP and BI in one System

The scenario where BI and ECC on the same system is called MCOS(Multiple components on one system) which is an extension to MCOD(Multiple components on one database). both ECC & BI can be installed on a single system, however  separate clients needs to be there. Actually, MCOS is an  extension to MCOD. that means both ECC & BI would be in a single database MCOD layout.  so the restrictions for MCOD applies to this also.

A good document link : SAP NetWeaver 7.0 - ERP and BI in one System

What is SAP Netweaver

SAP NetWeaver is the open integration and application platform that integrates people, information and processes into one hub, across technologies and organizations, to reduce the total cost of ownership (TCO).

Here is what Wikipedia tells :  SAP NetWeaver

Thursday, March 4, 2010

What is SAP ECC 6.0 in brief?

These are the telchnology platforms which provide complete administration ,development and runtime environment for SAP applications as their technology :

SAP R/3 4.7 is based on Web AS 6.20
ECC 5 is based on Web AS 6.40 (Netweaver 04)
ECC 6 is based on Netweaver 7.0

SAP ECC 6.0 is the core part or main instance of SAP ERP 6.0. It contains the main ABAP components of ERP 6.0. Next to this core SAP ERP product contains more additional components as BI Content, SRM Server and Java Components. the Netweaver provides ECC 6.0, The inbuilt functionality of open integration of processes (via XI) and information (via BI, MDM) across a heterogeneous landscape.

Excellent blog on changes from R/3 to ECC:

http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/12876

IDOC issue while creating source system in SCM 5.10

I faced this issue while creating a source system in SCM5.10 .

Solution :
           1 )  Goto tcode WE30:
            2  The IDOC type ZSNA022 does not exist in the system .
                 so , create it as a copy of type RSSEND.
           3) Afterwards, Check the following:
                 i) goto view EDIMSG (tcode SM30): see if  Message type RSSEND is linked to the IdocType   as specified above.


                ii) Also make sure your entries are in  RSBASIDOC table .

Monday, March 1, 2010

Background of drivers installed for BO integration kit

Installing  BO integration kit on a SAP system is basically importing some transports into the sap system.

What exactly does the transports contain?

the main contents of these transports are:

1) Function groups ( ex: /CRYSTAL/ODS_REPORT)
2) Table definitions ( /CRYSTAL/MDX_STREAM_LAYOUT)
3) Class (ABAP Objects)
4) Domain ( /CRYSTAL/RSZVNAM)
5) Data Element ( /CRYSTAL/RSZPVNAM)
6) Table ( /CRYSTAL/RSZ_X_VAR)
7) Table Type ( /CRYSTAL/MDX_AXIS_LEVELS)
8) Message Class ( ex: /CRYSTAL/CA_MSG)

9) Program /CRYSTAL/CE_SYNCH_FORMS
10) Authorization object class( ZSSI)
11) Authorization object (ZCNTADMCES)
12) Transaction (/CRYSTAL/RPTADMIN)