The Purpose of this Technical solution is to obtain an understanding of extraction of POS sales data to BI system and to develop the BI reporting with custom fields to be enhanced in standard data source 0RT_PA_TRAN_CONTROL. Please note that this is a working document, and will change as solution
transforms.
Focus is to explain custom developments and enhancements that were made to provide the best possible solution for users.
Document Objective –
The objective is to provide the overview for a requirement accomplishment with minimum POS interferance to enhance standard SAP data source 0RT_PA_TRAN_CONTROL with custom fields tax code value for an example.
Document Details –
The requirement is to enhance SAP standard data source 0RT_PA_TRAN_CONTROL with custom fields such as tax code value as per snapshot given below:
Append structure with custom fields –
POS Sales Data source 0RT_PA_TRAN_CONTROL has extract structure /POSDW/BW_RETAIL_CONTROL. Standard fields are populated via this extract structure when task of “POS Sales data to be pulled to BI system ” is called up.
Firstly, Append extract structure with all customized fields which you need at reporting level and then activate the datasource using RSA5.
Custom BADI Implementation and definition of its interface –
Create custom BADI with name YCL_IM_ZCL_IM_BW_OUT using transaction SE14 as given in screenshot.
The method defined here will be /POSDW/IF_EX_OUT_BW.
Code designed to populate the tax code fields in POS structure is as below:
The IT_TRANSACTION table is sorted according to the following keys:
- RETAILSTOREID à BUSINESSDAYDATE à TRANSINDEX
The transactions in the extract tables have the same sequence. Hence, IT_TRANSACTION will contain RETAILLINEITEM table which will further subsequent internal tables pointing to custom field Tax Code.
Same transaction that has been processed from POS can be cross verified in RSA7 delta queue.
Map this field with newly created custom infoobject ‘Tax code’ and make available for reporting.