Entering the Master Data,Text,and Hierarchy Manually - SAP BW

Using the procedure given in Section 3.5,we can not only display characteristic data,but also enter new data and change existing data. In this section,we use a different technique. First,we show how to enter master data and texts for characteristic IO_SREG. Then,we describe how to create a hierarchy for IO_SREP.

Master Data and Text

Work Instructions
Step 1. Select InfoObjects under Modelling in the left panel,right-click Sales region,and then select Maintain master data in the right panel.
Work Instructions

Step 2. ClickWork Instructions to display master data.
Characterstic IO_SREG maintain master data selection

Step 3. ClickWork instructions to create a record.
Characterstic IO_SREG maintain master data list

Step 4. Enter data in the fields and click Work Instructionsto continue.
Characterstic IO_SREG maintain master data list

Step 5. Repeat Steps 3 and 4 to enter two more records,and then clicksave to save the data into the database.
ave the data into the database.

Result:You have entered data into IO_SREG. A status message Data has been saved will appear at the bottom of Screen.Repeat the same procedure to enter data into IO_SOFF.

Hierarchy:
Table is actually a hierarchy. It should look like the hierarchy depicted in Figure when we visualize the table data.
TIME-DEPENDENT HIERARCHY STRUCTURES
TIME-DEPENDENT HIERARCHY STRUCTURES

This hierarchy indicates the Denver office was in the Midwest region before January 1,2000. On and after January 1,2000,the Denver office was part of the West region. In BW,a hierarchy such as the one in Figure is called a time-dependent hierarchy structure. "InfoCube Design Alternative III— Time-Dependent Entire Hierarchies," will discuss another type of hierarchy called a time-dependent entire hierarchy.

The following procedure describes how to create a time-dependent hierarchy structure for IO_SREP.

Work Instructions
Step 1. To create a hierarchy for IO_SREP,we must specify hierarchy properties in the IO_SREP definition. To modify the IO_SREP definition, double-click InfoObject Sales representative ID.
Work Instructions

Step 2. Under the Hierarchy tab,select the option with hierarchies,and then select the option Hierarchy structure time-dependent.

Next,click Work Instructionsto check it. If it is valid,clickWork Instructions to activate the modification.

Note:The activation will create three database tables for this hierarchy: /BIC/HIO_SREP (hierarchy table),/BIC/KIO_SREP (hierarchy SID table),and /BIC/IIO_SREP (SID hierarchy structure).Besides DataSources for master data (IO_SREP_ATTR) and texts (IO_SREP_TEXT),IO_SREP will work with a third DataSource,IO_SREP_HIER. With IO_SREP_HIER,we can use an InfoPackage to load hierarchy data as well.

"InfoCube Design Alternative III— Time-Dependent Entire Hierarchies," gives an example of Entire hierarchy is time-dependent.
Change Characterstics IO_SREP: detail

Step 3. In the Administrator Workbench: Modelling window,right-click the characteristic InfoObject Sales representative ID,and then select Create hierarchy….
Administrator workbench Modelling

Step 4. Enter a name and a description,and then click Work Instructionsto continue.
Create Hierarchy

Step 5. Right-click IO_SREP hierarchy,and then select Insert characteristic node….
Maintain Hierarchy

Step 6. Enter IO_SREG,and then clickWork Instructions to continue. Here we use IO_SREG data to create the hierarchy nodes.

Create Char node Multiple selection.

Step 7. Select all three regions,and then click Work Instructionsto continue.
Sales Region

Step 8. Three regions are displayed under IO_SREP hierarchy.To assign offices to each region,right-click one of the regions and repeat Steps 5,6 (enter IO_SOFF instead of IO_SREG),and 7. This screen shows that Denver,Los Angeles,and Seattle will be assigned to the West region.
Maintain Hierarchy IO_SREP hierarchy Modified version

Step 9. Because the Denver office is already assigned to the Midwest region,we see this message. As noted,the Denver office was part of the Midwest region before January 1,2000. For this reason,we need to put the Denver office in two places.

Select the option Copy duplicated node,and then clickWork Instructions to continue.
to continue.

Step 10. Now we need to specify the valid date periods for the Denver office. Right-click the first Denver in the Midwest region,and then select Change node(s)….
Maintain Hierarchy IO-SREP hierarchy

Step 11. Enter dates in Valid from and To,and then clickWork Instructions to continue.
Maintain Hierarchy IO-SREP hierarchy Modified version

Step 12. Repeat Steps 10 and 11 to specify valid dates for the Denver office in the West region.
Maintain Hierarchy IO-SREP hierarchy Modified version

Step 13. Next,we assign sales representatives to each sales office.At the hierarchy leaf level,we can either insert IO_SREP values following the previous steps or right-click an IO_SOFF value,such as Atlanta in the East region,and then select Sales rep. ID insert…. We take the second approach.
SCREEN 3.45
Maintain Hierarchy IO-SREP hierarchy Modified version

Step 14. After assigning sales representatives to each sales office,click saveto save the hierarchy. Now we need to activate the hierarchy before we can use it.
Maintain Hierarchy IO-SREP hierarchy Modified version

Step 15. In the Administrator Workbench: Modelling window,right-click the newly created hierarchy IO_SREP hierarchy,and then select Activate.
Administrator work bench modelling

Result:
You have created the hierarchy. Its color will change from gray to green.Now that we have loaded and entered all characteristic data,it is time to load the transaction data.


All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd DMCA.com Protection Status

SAP BW Topics