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 0   
Medium 15 DSO days 
Long 20 DSO days 
Heading 0   
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