SAP ABAP IMG Activity BWCRM_STAT_0002 (Process User Status)
Hierarchy
PI_BASIS (Software Component) Basis Plug-In
   CA (Application Component) Cross-Application Components
     CRM_KAPX (Package) BW Extraction Status from CRM
IMG Activity
ID BWCRM_STAT_0002 Process User Status  
Transaction Code S_AEC_66000628   (empty) 
Created on 20010410    
Customizing Attributes BWCRM_STAT_0002   Process User Status 
Customizing Activity BWCRM_STAT_0002   Process User Status 
Document
Document Class SIMG   Hypertext: Object Class - Class to which a document belongs.
Document Name BWCRM_STAT_0002    

Use

The status concept allows status objects to be displayed in BW. The system can transfer to BW the delivered system statuses as well as the user statuses that you have defined.

In this activity, you assign status objects (user status) created by you to a BW status object.

Background Information

All statuses that are currently active for an object are usually displayed in the Business Patner and Product master data as well as in other CRM master data and transaction data. Any number of statuses can be active at the same time.

However, there are a number of status values that exclude each other. In such cases, only one of these statuses can be active (for example, "In process" and "Completed").

You can combine these statuses in a BW status object and assign a BW status to each of the individual user statuses. The status that is active in the source system at the point when data is extracted is then transferred to SAP BW using the BW status object.

To arrange the BW status objects semantically, you can combine them in BW status object groups.

Requirements

Standard settings

Activities

Perform the following steps for this activity:

  1. Create one or several BW status object groups, depending on whether you want to arrange your status objects semantically. They could be grouped by application component, for example.
  2. Create a BW status object.

    The data is later extracted into SAP BW using the three-character name of the BW status object group and the four-character name of the BW status object.

  3. Use the possible entries function to select a combination of user status and status profile.
  4. In the BW Status field, assign a status number (not equal to 0) to this combination. You can use the status numbers in this way to order the statuses in BW semantically within a BW status object.

For the current value of each status object to be transferred to SAP BW, you need to perform the following steps:

  1. Extract into SAP BW the texts for the BW status and generate a Text DataSource for BW Status Objects.
  2. Extend the DataSource that you want to use to extract into SAP BW the object to which the status belongs. Proceed as follows:
    1. In Customizing for the settings for SAP BW, choose Settings for Extractors and Business Content -> Follow-Up Processing of DataSources -> Edit DataSources.
    2. Select the DataSource to be edited.
    3. Extend the extract structure by adding a field of the data type CRMBWST with the technical name BWSTYYYXXXX, where YYY stands for the BW status object group and XXXX for the BW status object.
    4. Ensure that the field for the extraction is selected. Use the pen icon to switch to the mode for changing the DataSource. The Selection and Hide Field indicators must not be set. The Field only known in exit indicator must be set.

      During extraction, the extended field is automatically filled with the status number for the status active at the time of the extraction.

  3. In SAP BW, create an InfoObject in which the value of the BW status object is to be set. It makes sense to use a naming convention of the form ZSTAYYYXXXX (see above). You can use the InfoObject 0STAMKTSYS0 as a template for technical settings such as data type and length.
  4. Assign this InfoObject as an attribute to the InfoObject that the status belongs to.
  5. Use the transfer structure to check the assignment between the extract structure field and the BW InfoObject.

Example

Business Attributes
ASAP Roadmap ID 207   Establish Reporting 
Mandatory / Optional 2   Optional activity 
Critical / Non-Critical 2   Non-critical 
Country-Dependency A   Valid for all countries 
Assigned Application Components
Documentation Object Class Documentation Object Name Current line number Application Component Application Component Name
SIMG BWCRM_STAT_0002 0 HLB0100455 BW Service API 
Maintenance Objects
Maintenance object type C   Customizing Object 
Assigned objects
Customizing Object Object Type Transaction Code Sub-object Do not Summarize Skip Subset Dialog Box Description for multiple selections
VC_CRMBWUSSTATGR C - View cluster SM34  
History
Last changed by/on SAP  20030213 
SAP Release Created in 30A