Creating a central scheduling tool for project planning
Project duration: 1 month
Brief description
SAP BW-BPS is used to develop a tool to enable a responsible person to schedule specific types of services by hour for recipient types: projects, internal orders or cost centers. To enable this, planning screens are created for the VS1 planning campaign and, in summarized form, for the VS2, UPL, GP1 and GP2 planning campaigns. This is differentiated according to recipient or sender view. Hours scheduled by a recipient can be accepted in the sender screen by the cost-center agent. The dataset consists of a transactional cube that contains the planning data for several years.
Supplement
The basis of the transaction data in the SAP BW test system consists of a transactional cube that backs up planning data additively; i.e. a reversing data record is saved when a data record is deleted. The master data is retained in BW in the corresponding property info objects and it is updated from the source system by means of loading processes. The planning data entered is then saved in key figure info objects. The technical environment in BPS is made up of the planning area, planning levels, planning packages and planning layouts. The user interfaces of the planning screens are generated in the planning layouts and data restrictions are made in the planning levels. To perform the necessary calculations and checks, the FOX formula language and ABAP function modules are used in the planning functions. Defined data slices can be used as needed to block planning data that has already been entered.
Subject description
Scheduling hours for projects, cost centers and internal orders as a service recipient is performed twice a year. In April, a preview (VS1) of the current financial year is created, based on actual data from the first three months. In October, a further preview (VS2) of the current financial year is created, based on actual data from the first nine months. At the same time, enterprise planning for the next financial year is created (UPL) and for the two years following the next financial year, in the form of a rough plan (GP1 and GP2). The budgeting always involves the available service types from the sending cost centers. The controlling department uses the hourly schedule as the basis for planning overheads.