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.

To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply