SAP ABAP Data Element RR_SUDSO (DSO days)
Hierarchy
BBPCRM (Software Component) BBPCRM
   CRM (Application Component) Customer Relationship Management
     CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       FBD (Package) Customers
Basic Data
Data Element RR_SUDSO
Short Description DSO days  
Data Type
Category of Dictionary Type D   Domain
Type of Object Referenced     No Information
Domain / Name of Reference Type DECV15_5    
Data Type DEC   Counter or amount field with comma and sign 
Length 15    
Decimal Places 5    
Output Length 20    
Value Table      
Further Characteristics
Search Help: Name    
Search Help: Parameters    
Parameter ID   
Default Component name    
Change document    
No Input History    
Basic direction is set to LTR    
No BIDI Filtering    
Field Label
  Length  Field Label  
Short  
Medium 15 DSO days 
Long 20 DSO days 
Heading  
Documentation

Definition

The DSO ("Days Sales Outstanding") identifier represents a customer's balance compared with that customer's sales. It specifies how many day's sales a customer owes a company.
There are two procedures for calculating DSO days. You can define these on the selection screen using the "DSO calculation type" parameter.

Calculation type 1: Average balance / one day's sales

With this calculation type, the average balance of x closed periods is divided by one day's sales (average sales from the corresponding x
periods):

average balance average balance

DSO = ----------------------- = ----------------- * 30

one day's sales average sales from x periods

Calculation type 2: Actual balance / one day's sales

This calculation type divides the actual balance by one day's sales (average of x periods):

actual balance actual balance

DSO = ---------------------------- = ---------------- * 30

one day's sales average sales of x periods

Example

x = 3 Balance Sales

Key date 02.15.1997 18,000 8,000

Period 01/1997 10,000 8,000

Period 12/1996 5,000 2,000

Period 11/1996 3,000 5,000

The variable x and the key date can be specified when initiating the evaluation.

Calculation type 1:
-------------------------
Average balance = (10,000 + 5,000 + 3,000) / 3 = 6,000
Average sales = (8,000 + 2,000 + 5,000) / 3 = 5,000

6,000
DSO = ---------- * 30 = 36
5,000

Result: The customer owes the value of 36 day's sales.

Calculation type 2:
-------------------------
Actual balance = 18,000
Average sales = (8,000 + 8,000 + 2,000) / 3 = 6,000

18,000
DSO = ----------- * 30 = 90
6,000

Result: The customer owes the value of 90 day's sales.

History
Last changed by/on SAP  19940827 
SAP Release Created in