Sales and Distribution or SD in short is module for Sales, Delivery and Billing data for a company.
Every company does business in the following way – Quotation is sent to the interested customer. If customer wants to buy that item, quotation is converted to sales order. Item is then billed and invoice is generated.
Customer may decide to pay later or immediately. If payment is done later, this record goes to Account receivables. Finally, the product is shipped and delivered to the customer and the sales order status changes to ‘Delivered’.
There are many processes involved here like shipment of the package, returns, cancellation etc.
Below are some of the standard SAP data sources for extracting the data from the source tables. These can only be used if the source is SAP ECC standard tables.
Billing conditions – 2LIS_13_VDCON
Billing Items – 2LIS_13_VDITM
Sales order items – 2LIS_11_VAITM
Delivery items – 2LIS_12_VCITM
Here the status of the sales order can change like invoice, Billed, Delivered, Rejected etc.
You can visit SAP help for more details on this module by clicking on the link below-
http://help.sap.com/saphelp_nw73ehp1/helpdata/en/fa/1a1a1f51694a9d9b721a7495052bb6/content.htm?frameset=/en/d9/dc895360b93d58e10000000a174cb4/frameset.htm¤t_toc=/en/7a/5d8853f65d3d58e10000000a174cb4/plain.htm&node_id=355&show_children=false
SD BW queries can give very useful insights on how the business is performing. These queries can help users to see product sales in a given time period, how many orders were rejected and why, which territory recorded maximum sales, which orders are still open and not delivered, returns per customer, quotation success rate per sales area etc.
Common issues that users report and are created as tickets in a support project are-
- Sales order delivered but still appearing as ‘Open’ status in the query result.
- Sales order billing amount doubled in the query
These issues mainly result due to failure in the SD process chain running in the system.
If any of these issues occur, look for the process chain failures like PSA request uploaded twice, info package stuck due to which delta is incomplete etc.
Related Posts-
What is Material Master Data report in BW/BI?