SAP ABAP Data Element DSOSA (Current Balance)
Hierarchy
☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ FBAS (Package) Financial accounting 'Basis'
Basic Data
Data Element DSOSA
Short Description Current Balance  
Data Type
Category of Dictionary Type D   Domain
Type of Object Referenced     No Information
Domain / Name of Reference Type WRTV8    
Data Type CURR   Currency field, stored as DEC 
Length 15    
Decimal Places 2    
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 10 Balance 
Medium 15 Balance 
Long 20 Balance 
Heading 20 Balance 
Documentation

Definition

Current or average balance in the company code or accumulated across all company codes belonging to the credit control area ("*").

You can define the procedure parameters for calculating the days sales outstanding (DSO) in the client-specific settings for credit management. Either the current or the average balance is displayed here depending on these settings.

Example

Days sales outstanding calculation on 08/25/1997 with the following conditions:

  • Procedure parameter "Number of months": n = 3.
  • Current period: 08
  • Current fiscal year: 1997
  • Period which was current 3 months ago: 05
  • Fiscal year of period 05: 1997
  • Beginning of period 05: 05/01/1997
  • Balance in period 05/1997: 600
  • Balance in period 06/1997: 200
  • Balance in period 07/1997: 400
  • Current balance in period 08: 8000
  • Sales in period 05/1997 : 500
  • Sales in period 06/1997 : 200
  • Sales in period 07/1997 : 300
  • Sales in period 08/1997 : 160

  1. Procedure parameter for calculating the days sales outstanding:

  • "Current balance": Yes

To calculate the days sales outstanding figure, the current balance is then compared with the sales from all periods (including the current one) which were made in the last three months, in other words:

  • DSO days = number of past days = 08/25/1997 - 05/01/1997 = 116
  • Sales/day = 1160 / 116 = 10
  • DSO = 8000 / 10 = 80.

  1. Procedure parameter for calculating the days sales outstanding:

  • "Current balance": No

To calculate the days sales outstanding figure, the average balance from all periods is then compared with the sales from all periods (not including the current one) which were made in the last three months, in other words:

  • DSO days = number of past days = 08/01/1997 - 05/01/1997 = 92
  • Average balance: ( 600 + 200 + 400 ) / 3 = 400
  • Sales/day = 1000 / 92 = 10.87.
  • DSO = 400 / 10.87 = 37.

Note:

Note that in the case of fiscal year variants which do not correspond to the calendar year, the number of periods to be considered does not have to correspond to the "Number of months" procedure parameter.

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