Sales and Distribution in One Exposure from Operations
You can integrate forecasted cash from sales order items and scheduling agreement items into One Exposure from Operations. Creating sales orders or scheduling agreements leads to forecasted cash that is adjusted by subsequent billing processes. In this integration scenario, the source application Sales and Distribution and One Exposure run in the same system (one-system scenario).
The following business processes in Sales and Distribution can be integrated into One Exposure:
Sales Orders and Scheduling Agreements with the following:
Price and quantity changes
Billing plans (periodic and milestone billing) including
Invoice and down payment items
Down payment requests and down payments
Consignment-, third party-, rush- and cross-company sales orders
Billing with the following:
Order-related invoice
Delivery-related invoice
Invoice splits
Separate invoices
Collective invoices
Invoices according to an invoice calendar
Credit/debit memo
Complaints with the following:
Returns
Credit/debit memo requests
Invoice correction requests
Note
Scheduling agreements with release are not incorporated.
Forecasted cash contains the following information from the sales document:
Reference to Sales Document and item of the Sales Document
Account Assignments:
Business Area
Profit Center
Cost Center
WBS Element or a Project
Segment
Company
Material
Business Partner (filled with the payer of the sales order or scheduling agreement)
Date and Amount
The transaction date is determined based on the expected billing date or dates of the item of the sales order or scheduling agreement, and considers the payment terms of the sales order or scheduling agreement. Regarding cash discount, the system uses the latest possible date to get the maximum possible cash discount (independent of anything else, for example, payment history of the customer).
The system creates two separate flows; one for the forecasted cash from the net amount of an item, and one for the forecasted cash of the tax amount of an item.
Other condition types such as cash discount, freight, or other discounts are not shown separately. They are merged in the forecasted cash for the net amount. Regarding cash discount, the system calculates the cash forecast amount with the maximum possible cash discount (on the corresponding date from the payment terms).
Certainty Level
One Exposure derives cash forecasts for items representing sales orders and scheduling agreements. It stores this information with the following certainty levels:
Certainty Level | Description | Meaning |
|---|---|---|
| Sales Order | Cash forecast from sales orders |
| Sales Scheduling Agreement | Cash forecast from scheduling agreements |
Flow Type
The system uses the following flow types for forecasts in One Exposure:
Cash | Default Flow Types |
|---|---|
Cash forecast of a net amount | 900000 - Incoming Bank Cash 900001 - Outgoing Bank Cash |
Cash forecast of a tax amount | 900018 - Incoming Bank Cash (Tax) 900019 - Outgoing Bank Cash (Tax) |
If errors occur during data upload, the system collects these errors in an application log. You can access it with transaction code FQM_APPLICATION_LOG
.
Planning Group
The system uses the planning group that is defined in the company code section of the master data of the payer of the sales order or scheduling agreement. If the master data of the payer does not contain the company code section, the system uses the planning group from the Customizing activity Define Planning Levels for Logistics
.
Activities
IMG Customizing Activities
Activate Individual Source Applications
andActivate Multiple Source Applications
You can activate the source application SDCM - Sales and Distribution (CM) in this Customizing activity. Data coming from SD is only updated in One Exposure, if the application is activated and successfully initialized.
Define Queries for Liquidity Item Derivation
This offers the possibility to enter derivation rules for data coming from Sales and Distribution. The liquidity item derivation is based on a subset of information available in One Exposure (origin X).
NoteIt is possible to derive separate liquidity items for forecasted cash from net amount and forecasted cash from tax amount based on the flow type.
End of the note.If no liquidity item can be determined, the system updates the flow with an empty liquidity item.
Define Planning Levels for Logistics
You can define the planning level for Sales and Distribution with this Customizing activity. The system takes the planning level that is assigned to the internal ID 101 - Order
Customers upgrading from the classic cash management can use the existing settings for the planning level when integrating SD into One Exposure.
Load Transaction Data from Source Applications into One Exposure from Operations Hub
If you want to integrate transaction data that was already created before the source application Sales and Distribution (SDCM) was activated, you use this Customizing activity.
Delete Data from One Exposure from Operations Hub
If you want to use a new starting point within an implementation project, you can use this Customizing activity to delete all existing data or the source application SDCM from One Exposure. You do this for each company code and source application.
Effects on Data Transfer
If cash forecasts from the obsolete source application SDSO - Sales Orders exist in One Exposure, users have to delete this data by using the report FQM_DELETE_OBSOLETE_SO_ENTRIES
.
More Information
The following cash management apps consume the information coming from SD:
Cash Position
Cash Position Details
Check Cash Flow Items
Liquidity Forecast
Liquidity Forecast Details
Develop Liquidity Plans
Liquidity Plans
For further information, see One Exposure from Operations