BW Content 7.0.3 For Campus Management

Jeroen Boeracker
Campus Management
Version: 1.0
Guideline
BW Content 7.0.3 for Campus Management
10 January 2007
Distribution: Public
Guideline
Change history
Date Author Change

10.01.2007 JB Version 1.0
C:\Documents and Settings\C5090968\Desktop\Production and CSS\upload.doc Seite 2

Guideline
Table of contents:
1 Introduction ....................................................................................................................6
2 Content Activation..........................................................................................................6
2.1 Replication of DataSources .......................................................................................................................6
2.2 Activation of the Content ...........................................................................................................................7
3 DTP ..................................................................................................................................7
4 Transformations .............................................................................................................9
4.1 Academic Structure ....................................................................................................................................9
4.1.1 Academic Period Unit (Text) ....................................................................................................................9
4.1.2 Event ......................................................................................................................................................10
4.1.3 Event Package .......................................................................................................................................10
4.1.4 Event Package Texts .............................................................................................................................11
4.1.5 Event Texts ............................................................................................................................................11
4.1.6 Event Type .............................................................................................................................................11
4.1.7 Event Type Texts ...................................................................................................................................12
4.1.8 Module....................................................................................................................................................12
4.1.9 Module Texts..........................................................................................................................................13
4.1.10 Module Hierarchy ............................................................................................................................13
4.1.11 Object Type .....................................................................................................................................14
4.2 Student Master Data .................................................................................................................................15

4.2.1 Academic Scale Identification ................................................................................................................15
4.2.2 Academic Level ......................................................................................................................................15
4.2.3 Alternative assessment method .............................................................................................................15
4.2.4 Alternative assessment method Texts ...................................................................................................15
4.2.5 Appraisal Remark...................................................................................................................................15
4.2.6 Appraisal Type .......................................................................................................................................16
4.2.7 Appraisal completed...............................................................................................................................16
4.2.8 Appraisal status......................................................................................................................................16
4.2.9 Appraisal type.........................................................................................................................................16
4.2.10 Booking reason ...............................................................................................................................17
4.2.11 Calculation point..............................................................................................................................17
4.2.12 Cancellation reason ........................................................................................................................17
4.2.13 Ceremony category.........................................................................................................................17
4.2.14 Conditional Booking ........................................................................................................................17
4.2.15 Delivery mode .................................................................................................................................18
4.2.16 Due date schedule ..........................................................................................................................18
4.2.17 Event Package Category ................................................................................................................18
4.2.18 Exclusion Indicator for Module Bookings ........................................................................................18
4.2.19 Exclusion Indicator for Module Bookings texts ...............................................................................18
4.2.20 External Academic Work or Qualification Transferred....................................................................19

Guideline
4.2.21 Grade Assignment Category...........................................................................................................19

4.2.22 Graduation reason ..........................................................................................................................19
4.2.23 Graduation status............................................................................................................................19
4.2.24 Module Booking Status ...................................................................................................................19
4.2.25 Module Category.............................................................................................................................20
4.2.26 Module Fee Category......................................................................................................................20
4.2.27 No credit assignment ......................................................................................................................20
4.2.28 Performance index ..........................................................................................................................20
4.2.29 Processing Status for Academic Event Planning............................................................................20
4.2.30 Progression Category .....................................................................................................................21
4.2.31 Progression Result Status...............................................................................................................21
4.2.32 Qualification not achieved ...............................................................................................................21
4.2.33 Repetition type ................................................................................................................................21
4.2.34 Session pattern ...............................................................................................................................21
4.2.35 Special Fee Category......................................................................................................................22
4.2.36 Teaching method ............................................................................................................................22
4.2.37 Waitlist Booking...............................................................................................................................22
4.3 Module Booking ........................................................................................................................................23

4.3.1 Mapping of DataSource to InfoSource ...................................................................................................23
4.3.2 Mapping of InfoSource to DSO ..............................................................................................................24
4.4 Event Offering ...........................................................................................................................................24

4.5 Program Completions ..............................................................................................................................25

4.6 Stage Completions ...................................................................................................................................26

4.7 Program Type Progression......................................................................................................................27

4.8 Performance Indices.................................................................................................................................28

4.8.2 Concatenation of Year and Session (Rule details) ................................................................................28
5 Data Loading.................................................................................................................29
6 Queries ..........................................................................................................................31
6.1 Queries for Module Booking....................................................................................................................31
6.2 Queries for Event Offering .......................................................................................................................31

Guideline
6.3 Queries for Program Completions ..........................................................................................................31
6.4 Queries for Stage Completions ...............................................................................................................31
6.5 Queries for Program Type Progression .................................................................................................31
7 Various ..........................................................................................................................32
7.1 Instructor for Event Offering....................................................................................................................32
7.2 How to extract extra customer fields ......................................................................................................32

7.2.1 Enhance the DataSource .......................................................................................................................32
7.2.2 Implement the BAdI RSU5_SAPI_BADI ................................................................................................34
7.2.3 Modify the DSO object 0HE_DS06 and the InfoSource 0HE_SLC_MBK_1..........................................36
7.3 Unit of Measurement ................................................................................................................................36

Guideline
1 Introduction
This document only contains information regarding the 7.0.3 Content. For the 3.5.3 Content a separate
cookbook is available.
The BW Content 7.0.3 contains several additional areas to the 3.53 Content. Following areas are new:
• Module Booking MBK
• Module Offering MOF
• Program Completions PCP
• Stage Completion SCP
• Program Type Progression PTP
• Performance Indices PI
Listed above are some abbreviations that are used in the naming conventions for this content. The 7.0.3
Content is available as of Feature Pack 4 (read support package 4). Some corrections were made to this
content afterwards. Therefore, make sure that when you are using the Content on a 7.0.3 basis, that you
have support package 5 as the latest level.
At the time of writing, Performance Indices backend functionality (in CM) is only available in ERP2005s. You
currently cannot use PI’s in ERP2005 (CM 6.0). Furthermore, for the Performance Indices (PI) some
additional corrections were done in BW. If you want to use Performance Indices, make sure that you have
support package 6 as the latest level.
The extractors have been delivered with ERP2005 (CM 6.0) Support Package 8. Availability is March 2007.
2 Content Activation
To be able to use the Campus Management Business Content as delivered by SAP, it first has to be
activated. A pre-requisite of this is that the source system from which you want to load the data, is connected
to the BW system. Only then you will be able to replicate the DataSources and to load the data.
2.1 Replication of DataSources

To replicate the DataSources that are delivered for Campus Management, proceed with the steps given
below:
Activate the DataSources in the Source System
In the OLTP (read Source) System, run Transaction RSA9 (Transfer Application Components). When that
has run, start Transaction RSA5 and find the Node 0IS_HER. Mark it with F9, and activate the DataSources
by hitting the Button ‘Transfer DataSources’.
Replicate the DataSources in the BW System
• Start the BW Administrator Workbench (RSA1).
• In the left navigation panel, choose DataSources.
• Select the source system from which you want to replicate the DataSources

Guideline
• Reload the entire tree containing the DataSources from this source system.
• To find the DataSources for Campus Management, navigate as follows: SAP Æ Higher Education
and Research.
• If you cannot find the node in the tree, make sure that you show the empty folders as well.
• Right click on the entry for Higher Education and Research. Choose ‘Replicate Metadata’ to replicate
the DataSources. All DataSources delivered by SAP for CM will now be replicated. This will take a
few minutes.
2.2 Activation of the Content

To activate the Content that is delivered for Campus Management, proceed with the steps given below:
• Start the BW Administrator Workbench (RSA1).
• In the left panel, choose Business Content.
• You can choose the InfoProviders and activate the DataStore Objects (ODS) 0HE_DS06,
0HE_DS07, 0HE_DS08, 0HE_DS09 and 0HE_DS10. Make sure you use the Data Flow before and
after. When activating it is usefull to do it in the background. Sometimes you may get a time-out
when you activate it in foreground.
When activating the content, it is possible that you get an error message that a certain object is not
known/active. Since a lot of objects are activated, it could be that an InfoObject has a attribute that has not
been activated yet. This will result in an error since the InfoObject cannot be activated due to depending
objects. This is not a problem. The depending object will be activated somewhere along the line. When it is
actived, the InfoObject with the error can be activated as well.
3 DTP
With the new BW 7.0 Basis, transfer rules and update rules are not valid anymore. A new process is used to
load data from the InfoPackage to the InfoObject or from the InfoPackage to the InfoSource and from the
InfoSource to the DSO. This process is called DTP (Data Transfer Process).
DTP’s are delivered with the content. You can easily create them yourself if you choose not to use the SAP
delivered ones. If you want to activate the DTPs, go to the BI Content in the navigation panel and choose

Guideline
Data Transfer Process (DTPA). All the ones relevant for Campus Management start with 0HE_ in the
description. Find those and activate them.

Guideline
4 Transformations
The processing for mapping the fields has been changed as well. Now you can use transformations to
graphically map the fields. You can choose to use the transformations as they have been defined in the 7.0.3
content. In that case, goto the BI Content in the navigation panel and choose Transformation (TRFN). All the
ones relevant for Campus Management start with 0HE_ in the description. Find those and activate them.
In case you do not want to use the content transformation, or are having problems in doing so, this chapter
lists all transformations as they were defined in the content.
4.1 Academic Structure

In the BW Administrator Workbench, open the InfoSources for Campus Management (InfoSources Æ SAP
Application Components Æ SAP Sectors Æ Higher Education and Research Æ Academic Structure
(Campus Management).
Your replicated DataSources should be displayed there. A difference to the 3.53 Content is that the
DataSources have to be activated before you can use them. To activate one, double click on it, choose
‘display/change’ and then ‘activate’.
4.1.1 Academic Period Unit (Text)

Assign the DataSource 0HE_YSUNIT_TEXT to the InfoObject 0HE_YSUNIT. You can do this by right
clicking on the DataSource and choosing ‘Create Transformation’. Following will be the dialog. The subtype
here is ‘TEXT’.

Guideline
When confirming this, you can map the fields.
4.1.2 Event
Transformation between DataSource 0HE_EVENT_ATTR and InfoObject 0HE_EVENT. Subtype ATTR.
4.1.3 Event Package

Transformation between DataSource 0HE_EVPACK_ATTR and InfoObject 0HE_EVPACK. Subtype ATTR.

Guideline
4.1.4 Event Package Texts

Transformation between DataSource 0HE_EVPACK_TEXT and InfoObject 0HE_EVPACK. Subtype TEXT.
4.1.5 Event Texts

Transformation between DataSource 0HE_EVENT_TEXT and InfoObject 0HE_EVENT. Subtype TEXT.
4.1.6 Event Type

Transformation between DataSource 0HE_EVTYPE_ATTR and InfoObject 0HE_EVTYPE. Subtype ATTR.

Guideline
4.1.7 Event Type Texts

Transformation between DataSource 0HE_EVTYPE_TEXT and InfoObject 0HE_EVTYPE. Subtype TEXT.
4.1.8 Module
Transformation between DataSource 0HE_MODULE_ATTR and InfoObject 0HE_MODULE. Subtype ATTR.

Guideline
4.1.9 Module Texts

Transformation between DataSource 0HE_MODULE_TEXT and InfoObject 0HE_MODULE. Subtype TEXT.
4.1.10 Module Hierarchy

A hierarchy was developed to enable the display of the Organizational Unit, Program and Module Group that
a module is linked to. An evaluation path PIQBWSM has been defined to determine the various relationships:
The hierarchy is extracted via two function modules:

• HRIQ_BW_HIERARCHY_CATALOG_SM Hierarchy description
• HRIQ_BW_HIERARCHY_TRANSFER_SM Hierarchy itself
The DataSource mapping of the hierarchy is as follows:
Hierarchy Header

Guideline
Hierarchy Node
4.1.11 Object Type

Transformation between DataSource 0HE_OTYPE_TEXT and InfoObject 0HE_OTYPE. Subtype TEXT.

Guideline
4.2 Student Master Data

In the BW Administrator Workbench, open the InfoSources for Campus Management (InfoSources Æ SAP
Application Components Æ SAP Sectors Æ Higher Education and Research Æ Student Master Data
(Campus Management).
Your replicated DataSources should be displayed there. To activate one, double click on it, choose
‘display/change’ and then ‘activate’.
4.2.1 Academic Scale Identification

Transformation between DataSource 0HE_GRADSC_TEXT and InfoObject 0HE_GRADSC. Subtype TEXT.
4.2.2 Academic Level

Transformation between DataSource 0HE_ACLEVL_TEXT and InfoObject 0HE_ACLEVL. Subtype TEXT.
4.2.3 Alternative assessment method

Transformation between DataSource 0HE_AWRAT_ATTR and InfoObject 0HE_AWRAT. Subtype ATTR.
4.2.4 Alternative assessment method Texts

Transformation between DataSource 0HE_AWRAT_TEXT and InfoObject 0HE_AWRAT. Subtype TEXT.
4.2.5 Appraisal Remark

Transformation between DataSource 0HE_APRMRK_TEXT and InfoObject 0HE_APRMRK. Subtype TEXT.

Guideline
4.2.6 Appraisal Type

Transformation between DataSource 0HE_AGRTYP_TEXT and InfoObject 0HE_AGRTYP. Subtype TEXT.
4.2.7 Appraisal completed

Transformation between DataSource 0HE_APCOMP_TEXT and InfoObject 0HE_APCOMP. Subtype TEXT.
4.2.8 Appraisal status

Transformation between DataSource 0HE_APSTAT_TEXT and InfoObject 0HE_APSTAT. Subtype TEXT.
4.2.9 Appraisal type

Transformation between DataSource 0HE_APTYPE_TEXT and InfoObject 0HE_APTYPE. Subtype TEXT.

Guideline
4.2.10 Booking reason

Transformation between DataSource 0HE_MBKRSN_TEXT and InfoObject 0HE_MBKRSN. Subtype TEXT.
4.2.11 Calculation point

Transformation between DataSource 0HE_CLCPNT_TEXT and InfoObject 0HE_CLCPNT. Subtype TEXT.
4.2.12 Cancellation reason

Transformation between DataSource 0HE_MBKCRS_TEXT and InfoObject 0HE_MBKCRS. Subtype TEXT.
4.2.13 Ceremony category

Transformation between DataSource 0HE_CRMCAT_TEXT and InfoObject 0HE_CRMCAT. Subtype TEXT.
4.2.14 Conditional Booking

Transformation between DataSource 0HE_COBOK_TEXT and InfoObject 0HE_COBOK. Subtype TEXT.

Guideline
4.2.15 Delivery mode

Transformation between DataSource 0HE_DELMOD_TEXT and InfoObject 0HE_DELMOD. Subtype TEXT.
4.2.16 Due date schedule

Transformation between DataSource 0HE_DDSCHD_TEXT and InfoObject 0HE_DDSCHD. Subtype TEXT.
4.2.17 Event Package Category

Transformation between DataSource 0HE_SECAT_TEXT and InfoObject 0HE_SECAT. Subtype TEXT.
4.2.18 Exclusion Indicator for Module Bookings

Transformation between DataSource 0HE_ANNULM_TEXT and InfoObject 0HE_ANNULM. Subtype ATTR.
4.2.19 Exclusion Indicator for Module Bookings texts

Transformation between DataSource 0HE_ANNULM_TEXT and InfoObject 0HE_ANNULM. Subtype TEXT.

Guideline
4.2.20 External Academic Work or Qualification Transferred

Transformation between DataSource 0HE_TRNSFW_TEXT and InfoObject 0HE_TRNSFW. Subtype TEXT.
4.2.21 Grade Assignment Category

Transformation between DataSource 0HE_NOGRD1_TEXT and InfoObject 0HE_NOGRD1. Subtype TEXT.
4.2.22 Graduation reason

Transformation between DataSource 0HE_GRDRSN_TEXT and InfoObject 0HE_GRDRSN. Subtype TEXT.
4.2.23 Graduation status

Transformation between DataSource 0HE_GRDST_TEXT and InfoObject 0HE_GRDST. Subtype TEXT.
4.2.24 Module Booking Status

Transformation between DataSource 0HE_MBKST_TEXT and InfoObject 0HE_MBKST. Subtype TEXT.

Guideline
4.2.25 Module Category

Transformation between DataSource 0HE_SMCAT_TEXT and InfoObject 0HE_SMCAT. Subtype TEXT.
4.2.26 Module Fee Category

Transformation between DataSource 0HE_SMFCAT_TEXT and InfoObject 0HE_SMFCAT. Subtype TEXT.
4.2.27 No credit assignment

Transformation between DataSource 0HE_NOCRD_TEXT and InfoObject 0HE_NOCRD. Subtype TEXT.
4.2.28 Performance index

Transformation between DataSource 0HE_PINDEX_TEXT and InfoObject 0HE_PINDEX. Subtype TEXT.
4.2.29 Processing Status for Academic Event Planning

Transformation between DataSource 0HE_EVPRST_TEXT and InfoObject 0HE_EVPRST. Subtype TEXT.

Guideline
4.2.30 Progression Category

Transformation between DataSource 0HE_PGCAT_TEXT and InfoObject 0HE_PGCAT. Subtype TEXT.
4.2.31 Progression Result Status

Transformation between DataSource 0HE_PGSTAT_TEXT and InfoObject 0HE_PGSTAT. Subtype TEXT.
4.2.32 Qualification not achieved

Transformation between DataSource 0HE_CQFAIL_TEXT and InfoObject 0HE_CQFAIL. Subtype TEXT.
4.2.33 Repetition type

Transformation between DataSource 0HE_REPTYP_TEXT and InfoObject 0HE_REPTYP. Subtype TEXT.
4.2.34 Session pattern

Transformation between DataSource 0HE_OFFPAT_TEXT and InfoObject 0HE_OFFPAT. Subtype TEXT.

Guideline
4.2.35 Special Fee Category

Transformation between DataSource 0HE_SMLVCT_TEXT and InfoObject 0HE_SMLVCT. Subtype TEXT.
4.2.36 Teaching method

Transformation between DataSource 0HE_TCHMTH_TEXT and InfoObject 0HE_TCHMTH. Subtype TEXT.
4.2.37 Waitlist Booking

Transformation between DataSource 0HE_WTLBK_TEXT and InfoObject 0HE_WTLBK. Subtype TEXT.

Guideline
4.3 Module Booking
4.3.1 Mapping of DataSource to InfoSource

Guideline
4.3.2 Mapping of InfoSource to DSO
4.4 Event Offering

Guideline
4.5 Program Completions

Guideline
4.6 Stage Completions

Guideline
4.7 Program Type Progression

Guideline
4.8 Performance Indices
4.8.2 Concatenation of Year and Session (Rule details)

Define the formula “CONCATENATE( ACAD_YEAR, ACAD_SESSION )” to concatenate the year and session into one
field.

Guideline
5 Data Loading
For each of the DataSources you have now created/replicated the transformations and the DTPs. The idea is
now to create an InfoPackage for each of these object. This can be done via the context menu in the
DataSource view.
When creating InfoPackages for the objects of the academic structure and student master data, please
beware that for some objects you can specify the validity in the InfoPackage. It is recommended to always
load from 01.01.1800 to 31.12.9999.
When creating InfoPackages for the transactional data you have the option to use the delta mechanism. The
advantage is that once an initial load has been done, only changed records will be loaded to BW.
Delta loading is possible for the following objects:
• Module Booking
• Program Completion
• Stage Completions
• Program Type Progression
Once you have create the InfoPackage and specified all attributes of it, you can start the loading on the last
tab.
Once the loading has finished you will have to start the Data Transfer Process (this is valid for all objects).

Guideline
If this is finished, you might have to activate the data. This can be done via the context menu on the DSO
(can be found under the DTP).
After this, you should be able to run queries.

Guideline
6 Queries
With the delivery of the BW 7.03/7.12 Content Add-On, Campus Management delivers a number of queries.
The queries are split up over each of the DataStore Object (ODS) that they analyze. These queries serve as
an example / implementation accelerator.
6.1 Queries for Module Booking

• Module Bookings by Booking Status 0HE_DS06_Q0001
• Module Bookings by Student & Period 0HE_DS06_Q0002
• Student Course Report 0HE_DS06_Q0003
6.2 Queries for Event Offering

• Event Offers 0HE_DS07_Q0001
6.3 Queries for Program Completions

• Program Completions by Qualification and Status 0HE_DS08_Q0001
6.4 Queries for Stage Completions

• Stage Completions by Program, Student and Grade 0HE_DS09_Q0001
6.5 Queries for Program Type Progression

• Progression Results by Program Type, Category and Result 0HE_DS10_Q0001

Guideline
7 Various
7.1 Instructor for Event Offering

The instructor (0HE_INSTRC) is a reference InfoObject on the attribute 0EMPLOYEE. To determine whether
the instructor is a Person (P), External Person (H) or a Student (ST) the extractor delivers the field OTYPE
for the object id of the instructor.
Currently it is not possible to modify/enhance the InfoObject 0EMPLOYEE as it is a HR object. In future it will
be possible for Industry Solutions to append these objects with Industry specific fields. Currently it is not the
case, therefore following enhancement should be made.
The InfoObject 0EMPLOYEE has to have OHE_OTYPE as a compounded field. In the transformation the
field INSTRC_OTYPE from the extract structure has to be mapped to 0HE_OTYPE. This way the object id of
the instructor is always linked with the otype that was determined at extraction.
7.2 How to extract extra customer fields

If you want to extract extra/missing fields for a given extractor, a BAdI exists that you can use for this. As
example we will enhace the extractor for Module Booking. It currently has only one Program for the Program
Usage. In case there is a need to have more than one Program there, following needs to be done.
7.2.1 Enhance the DataSource

Start transaction RSA6 and mark the DataSource you want to extend. Choose ‘Enhance Extraction
Structure’.
Enter a name for the DDIC structure you want to create.

Guideline
In the following screen, define the fields you want to extract additionally and active the structure.
Activate the structure. The DataSource has now been enhanced with the customer field.

Guideline
7.2.2 Implement the BAdI RSU5_SAPI_BADI

Start transaction SE18. Enter the BAdI name and choose from the pull-down menu Implementation Æ
Create:
Give a name for the implementation.
The method DATA_TRANSFORM should be implemented in case you want to extract extra fields for master-
and transactional data.
This BAdI is called after the load of the data has been done. The table C_T_DATA contains all the extracted
data. Via a loop over that table you can easily enhance the data. Here is the example coding for the
implementation:

Guideline
METHOD if_ex_rsu5_sapi_badi~data_transform.
DATA: ls_data TYPE piqbw_mbk.

DATA: lt_p1724 TYPE TABLE OF hrp1724.
DATA: ls_p1724 TYPE hrp1724.
DATA: lt_studies TYPE piqstudies_t.
DATA: ls_studies TYPE piqstudies.
CASE i_datasource.
WHEN cl_hrpiq00bwconst=>c_datasource_mbk.
* In this example we assume that there is more than one program
* usage per module booking. The default implementation of the
* extractor needs to be enhanced.
LOOP AT c_t_data INTO ls_data.
CLEAR: lt_p1724[], ls_p1724, lt_studies[], ls_studies.
SELECT * FROM hrp1724 INTO TABLE lt_p1724
WHERE plvar = cl_hrpiq00const=>c_plvar_active AND
modreg_id = ls_data-modreg_id.
IF sy-subrc = 0.
READ TABLE lt_p1724 INTO ls_p1724 INDEX 1.

IF sy-subrc = 0.
ls_studies-plvar = ls_p1724-plvar.
ls_studies-cs_otype = cl_hrpiq00const=>c_otype_cs.
ls_studies-cs_objid = ls_p1724-objid.
APPEND ls_studies TO lt_studies.
CALL FUNCTION 'HRIQ_STUDIES_ST_SC_READ'

EXPORTING
iv_read_sc = 'X'
iv_read_st = space
TABLES
ct_studies = lt_studies
EXCEPTIONS
invalid_parameters = 0
technical_error = 0
OTHERS = 0.
IF lt_studies IS NOT INITIAL.

READ TABLE lt_studies INDEX 1 INTO ls_studies.
IF sy-subrc = 0.
ls_data-program_objectid = ls_studies-sc_objid.
ENDIF.
READ TABLE lt_studies INDEX 2 INTO ls_studies.
IF sy-subrc = 0.
ls_data-zzprogr_objid2 = ls_studies-sc_objid.
ENDIF.
ENDIF.
ENDIF.
ENDIF.
MODIFY TABLE c_t_data FROM ls_data.
ENDLOOP.
WHEN OTHERS.
ENDCASE.
ENDMETHOD.

Guideline
7.2.3 Modify the DSO object 0HE_DS06 and the InfoSource 0HE_SLC_MBK_1
The last step is to modify the DataStore Object, the InfoSource and the Transformations. Create an
InfoObject (RSD1) ZHE_PRUS2 (Program Usage 2). Via RSA1, goto the InfoProvider view, look up
0HE_DS06 and change it.
Add the ZHE_PRUS2 as a data field. Activate.
Goto the InfoSource view. Look up the InfoSource 0HE_SLC_MBK_1 and add the field ZHE_PRUS2 to the
InfoSource. Activate.
Goto the DataSource view and replicate the DataSource 0HE_SLC_MBK_1. Activate it.
Goto the InfoProvider view. You might have to delete the existing Transformation. You can create them with
the mapping as given previously. Additionally, map your created field.
That should be it.
7.3 Unit of Measurement

Make sure that if you extract data that uses the unit CRH that this is available in the BW system. If not, you
might get errors when processing the DTP.

Guideline
Copyright
© Copyright 2007 SAP AG. All rights reserved.
No part of this publication may be reproduced or transmitted in any form or for any purpose without the express permission of SAP AG.
The information contained herein may be changed without prior notice.
Some software products marketed by SAP AG and its distributors contain proprietary software components of other software vendors.
Microsoft, Windows, Outlook, and PowerPoint are registered trademarks of Microsoft Corporation.
IBM, DB2, DB2 Universal Database, OS/2, Parallel Sysplex, MVS/ESA, AIX, S/390, AS/400, OS/390, OS/400, iSeries, pSeries, xSeries,
zSeries, z/OS, AFP, Intelligent Miner, WebSphere, Netfinity, Tivoli, Informix, i5/OS, POWER, POWER5, OpenPower and PowerPC are
trademarks or registered trademarks of IBM Corporation.
Adobe, the Adobe logo, Acrobat, PostScript, and Reader are either trademarks or registered trademarks of Adobe Systems
Incorporated in the United States and/or other countries.
Oracle is a registered trademark of Oracle Corporation.
UNIX, X/Open, OSF/1, and Motif are registered trademarks of the Open Group.
Citrix, ICA, Program Neighborhood, MetaFrame, WinFrame, VideoFrame, and MultiWin are trademarks or registered trademarks of
Citrix Systems, Inc.
HTML, XML, XHTML and W3C are trademarks or registered trademarks of W3C®, World Wide Web Consortium, Massachusetts
Institute of Technology.
Java is a registered trademark of Sun Microsystems, Inc.
JavaScript is a registered trademark of Sun Microsystems, Inc., used under license for technology invented and implemented by
Netscape.
MaxDB is a trademark of MySQL AB, Sweden.
SAP, R/3, mySAP, mySAP.com, xApps, xApp, SAP NetWeaver, and other SAP products and services mentioned herein as well as their
respective logos are trademarks or registered trademarks of SAP AG in Germany and in several other countries all over the world. All
other product and service names mentioned are the trademarks of their respective companies. Data contained in this document serves
informational purposes only. National product specifications may vary.
These materials are subject to change without notice. These materials are provided by SAP AG and its affiliated companies ("SAP
Group") for informational purposes only, without representation or warranty of any kind, and SAP Group shall not be liable for errors or
omissions with respect to the materials. The only warranties for SAP Group products and services are those that are set forth in the
express warranty statements accompanying such products and services, if any. Nothing herein should be construed as constituting an
additional warranty.
These materials are provided “as is” without a warranty of any kind, either express or implied, including but not limited to, the implied
warranties of merchantability, fitness for a particular purpose, or non-infringement.
SAP shall not be liable for damages of any kind including without limitation direct, special, indirect, or consequential damages that may
result from the use of these materials.
SAP does not warrant the accuracy or completeness of the information, text, graphics, links or other items contained within these
materials. SAP has no control over the information that you may access through the use of hot links contained in these materials and
does not endorse your use of third party web pages nor provide any warranty whatsoever relating to third party web pages.
Any software coding and/or code lines/strings (“Code”) included in this documentation are only examples and are not intended to be
used in a productive system environment. The Code is only intended better explain and visualize the syntax and phrasing rules of
certain coding. SAP does not warrant the correctness and completeness of the Code given herein, and SAP shall not be liable for errors
or damages caused by the usage of the Code, except if such damages were caused by SAP intentionally or grossly negligent.

BW Content 7.0.3 For Campus Management

Uploaded by

Copyright:

Available Formats

BW Content 7.0.3 For Campus Management

Uploaded by

Document Information

Original Title

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

BW Content 7.0.3 For Campus Management

Uploaded by

Copyright:

Available Formats

Jeroen Boeracker

Date Author Change

C:\Documents and Settings\C5090968\Desktop\Production and CSS\upload.doc Seite 2

2.2 Activation of the Content ...........................................................................................................................7

4.2 Student Master Data .................................................................................................................................15

C:\Documents and Settings\C5090968\Desktop\Production and CSS\upload.doc Seite 3

4.2.21 Grade Assignment Category...........................................................................................................19

4.3 Module Booking ........................................................................................................................................23

4.4 Event Offering ...........................................................................................................................................24

4.5 Program Completions ..............................................................................................................................25

4.6 Stage Completions ...................................................................................................................................26

4.7 Program Type Progression......................................................................................................................27

4.8 Performance Indices.................................................................................................................................28

6.2 Queries for Event Offering .......................................................................................................................31

C:\Documents and Settings\C5090968\Desktop\Production and CSS\upload.doc Seite 4

6.3 Queries for Program Completions ..........................................................................................................31

6.4 Queries for Stage Completions ...............................................................................................................31

6.5 Queries for Program Type Progression .................................................................................................31

7.2 How to extract extra customer fields ......................................................................................................32

7.3 Unit of Measurement ................................................................................................................................36

C:\Documents and Settings\C5090968\Desktop\Production and CSS\upload.doc Seite 5

2.1 Replication of DataSources

C:\Documents and Settings\C5090968\Desktop\Production and CSS\upload.doc Seite 6

2.2 Activation of the Content

C:\Documents and Settings\C5090968\Desktop\Production and CSS\upload.doc Seite 7

C:\Documents and Settings\C5090968\Desktop\Production and CSS\upload.doc Seite 8

4.1 Academic Structure

4.1.1 Academic Period Unit (Text)

C:\Documents and Settings\C5090968\Desktop\Production and CSS\upload.doc Seite 9

When confirming this, you can map the fields.

4.1.3 Event Package

C:\Documents and Settings\C5090968\Desktop\Production and CSS\upload.doc Seite 10

4.1.4 Event Package Texts

4.1.5 Event Texts

4.1.6 Event Type

C:\Documents and Settings\C5090968\Desktop\Production and CSS\upload.doc Seite 11

4.1.7 Event Type Texts

C:\Documents and Settings\C5090968\Desktop\Production and CSS\upload.doc Seite 12

4.1.9 Module Texts

4.1.10 Module Hierarchy

The hierarchy is extracted via two function modules:

C:\Documents and Settings\C5090968\Desktop\Production and CSS\upload.doc Seite 13

4.1.11 Object Type

C:\Documents and Settings\C5090968\Desktop\Production and CSS\upload.doc Seite 14

4.2 Student Master Data

4.2.1 Academic Scale Identification

4.2.2 Academic Level

4.2.3 Alternative assessment method

4.2.4 Alternative assessment method Texts

4.2.5 Appraisal Remark

C:\Documents and Settings\C5090968\Desktop\Production and CSS\upload.doc Seite 15

4.2.6 Appraisal Type

4.2.7 Appraisal completed

4.2.8 Appraisal status

4.2.9 Appraisal type

C:\Documents and Settings\C5090968\Desktop\Production and CSS\upload.doc Seite 16

4.2.10 Booking reason

4.2.11 Calculation point

4.2.12 Cancellation reason