Part – 2 ‘BW write type’ Planning – An Inside Story
Part 1 – ‘BW write type’ Planning of this blog series describes how to create simple planning writer functions and compare the 3 Model write types – Insert, Modify, Delete & Insert.
Writer function -> ACTIVATE:
Part – 2 describes the list of the objects that are generated automatically in the background when activating the Planning writer function.
- DDIC table
- HANA stored procedure
- SAP Business Warehouse (SAP BW) objects – Aggregation level, Filter, Planning function and Planning sequence
Technical information of these objects can be found in the Runtime Attributes of the writer.
The below generated objects which are discussed earlier in the blog post Part-2 of the Loading writer – Blog series remains relevant for the Planning ‘BW write type’ and are skipped here.
- DDIC table
- Stored procedure and
The objects that are specific for Planning ‘BW write type’ are discussed further.
SAP HANA PAK Procedure:
In addition to SAP HANA stored procedure, another PAK procedure is generated with tech. name suffix ‘_PAK’ which is used later in the planning function. These procedures can be accessed in SAP HANA studio under the NXI schema.
SAP Business Warehouse (SAP BW) objects
When the writer function is activated, it generates the SAP BW Planning objects necessary for writing data to ‘Model BW’ (ADSO) using SAP BW planning Engine.
- Aggregation level
- Planning function
- Planning sequence
- Process chain
SAP BW planning objects – Technical names:
Planning function tech. name found in the runtime attributes can be used to derive tech. name of other Planning objects. For example, if planning function is YF1004636 then tech. name of
Aggregation level: YA* (YA1004636)
Filter : YSO* (YSO1004636)
Planning Sequence: YS* (YS1004636)
These planning objects can be accessed in the Tcode RSPLAN (both from SAP PaPM client and SAP BW client). To view specific planning objects, select the object type and enter the tech. name.
By default, aggregation level is generated including all the fields/infoobjects of the Model BW(ADSO). Other planning objects such as Filter, planning function and planning sequence are generated on top of this aggregation level.
Default filter is generated with option ‘Standard’ and with no selections assigned.
It is generated with custom function type called as ‘Performance Management Planning Function Type’. This function type has the implementation of class /NXI/CL_P1_FW_PLFUNC_TYPE which executes the Y*_PAK stored procedure as per the Model writer type of the writer function.
Planning sequence is generated with aggregation level, filter & planning function of that writer. And this can be used directly in the SAP BW reporting tools such as Analysis for Office, Lumira etc.
Process chain is generated to automate & control the data from the Input function to ADSO. These Process chains can be accessed in the Tcode RSPC or RSPC1.
- Start process – This is included as first step to trigger the process chain
- Run FS-PER Function – This step executes the generated stored procedures which internally writes the data from Input function to the Output Model BW using SAP BW planning Engine.
Now you became familiar with
- Generated SAP BW planning objects
- Accessing these generated objects in SAP BW and SAP HANA Studio
In the Part – 3, we will discuss how to troubleshoot the planning sequence, known issues and solutions