Sales orders and outbound deliveries are key inputs for demand sensing (short-term forecasting) in SAP Integrated Business Planning. Four new template tasks are now available in SAP HANA Cloud Integration (HCI) to support the transfer of sales order and outbound delivery data from SAP ERP to IBP:
- IBP_MD_SalesOrder_InitialLoad
- IBP_MD_SalesOrder_DeltaLoad
- IBP_MD_Deliveries_InitialLoad
- IBP_MD_Deliveries_DeltaLoad
You can use these tasks as templates to create your own tasks for integrating sales order and outbound delivery data in your system.
You'll find information about creating your own task based on the template task in the note box of the task's data flow.
The extended version of the Integration Guide for SAP Integrated Business Planning 5.0, Using SAP HANA Cloud Integration is now also available at http://help.sap.com/ibp50 to support you in using the newly published template tasks.
Let me outline some important background information about the integration of sales order and outbound delivery data.
Modeling of Sales Orders and Outbound Deliveries
In SAP ERP, sales orders and outbound deliveries are considered transactional data.
However, in IBP you need a planning area that contains the sales order and the outbound delivery as master data types, such as the SAP6 sample planning area.
| Sales Order | Outbound Delivery |
|---|
| Master Data Type | S6SALESORDER | S6DELIVERY |
| Planning Levels | SALESORDERDAILY, SALESORDERUOMTODAILY | DELIVERYDAILY, DELIVERYUOMTODAILY |
| Key Figures | REQQTY (Requested Quantity), CONFQTY (Confirmed Quantity) | DELIVQTY (Delivered Quantity) |
The REQQTY and CONFQTY attributes of the sales order master data type and the DELIVQTY attribute of the outbound delivery master data type are assigned as Attributes as Key Figures to the planning area.
DataSources in SAP ERP
The templates use the 2LIS11_VASL (for sales orders) and 2LIS_12_VCITM (for outbound deliveries) DataSources in SAP ERP. You have to activate these DataSources.
For the InitialLoad tasks, delete and rebuild the BW setup data.
For the DeltaLoad tasks, schedule a recurring job for extracting BW setup data. To get the most up-to-date data in your system with each delta load, schedule the DeltaLoad tasks in HCI to start after the BW data extraction job in SAP ERP has completed.
For more information, see the Integration Guide.
Delta Queue Handling
The InitialLoad tasks transfer the current status of all sales orders or outbound deliveries that have been created up to a certain point in time in SAP ERP.
The DeltaLoad tasks transfer the current status of all sales orders and outbound deliveries that have been created or changed since the last data transfer. For example, if a sales order has been changed several times since the last data transfer, only the current status is imported in IBP, the interim change records not. Sales orders and outbound deliveries that have been deleted in SAP ERP will stay in IBP, only the relevant key figure value is set to 0.
When you import your DataSource in SAP HCI, you define a subscriber ID. With that, you subscribe to a DataSource.
In SAP ERP, a delta queue - also called setup tables - of the DataSource keeps track of new/changed/deleted sales orders and outbound deliveries for each subscriber.
When HCI reads data from a DataSource in SAP ERP, the subscriber ID is passed to the DataSource. With that, the delta queue determines which data has already been read by the given subscriber, and returns the unread data only.
Scheduling the Tasks in HCI
Before you run a task, make sure the necessary master data records (for customers, locations, and products) already exist in IBP.
If you haven't done so already, make an initial load of the master data records before you run the InitialLoad tasks.
Also, before you run the DeltaLoad tasks, synchronize the master data between SAP ERP and IBP to have the changes and the newly created records in IBP so that the transfer of sales orders or outbound deliveries can be executed.
Template tasks are available to support you in transferring the master data records to IBP. For more information, see the Integration Guide.
InitialLoad tasks: Probably, you will run these tasks only once. Would you need to run these tasks again, make sure you complete all the steps that are described in the Integration Guide for the specific task, including deleting and rebuilding BW setup data.
DeltaLoad tasks: We recommend that you schedule these tasks for a recurring run.
To have the most up-to-date data in your system with each delta load, schedule the DeltaLoad tasks in HCI to start after the BW data extraction job in SAP ERP has completed.
