biuan SAP® BUSINESS ONE SDK
SQL Finance / Special Ledger - Analytical Accounting Configuration Rule Additional Calculations: Revenues & Ex
API SCR3
SCR3 - Special Ledger - Analytical Accounting Configuration Rule Additional Calculations: Revenues & Expenses Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
RuleID KEY UNIQUERule Identification NumberInt
6OSCR
Special Ledger - Analytical Accounting Configuration Rules: Revenues & Expenses		PRIMARYYes
FldNumResult Field NumberInt
6
SrcTableMain Source TablenVarChar
20
SrcFieldMain Source Table FieldnVarChar
20
CalcCaseAdditional Calcul. ExpressionnVarChar
127
CalcTableMain Calculation ExpressionnVarChar
127
CondCaseAdditional Calcul. ConditionnVarChar
127
CondTableMain Calculation ConditionnVarChar
127
GroupingGroup by ClausenVarChar
100
CallProcRecalculation Stored Procedure NamenVarChar
50
ExtCondExtended Special DatanVarChar
127

SELECT statement

SELECT SCR3.RuleID AS 'Rule Identification Number', SCR3.FldNum AS 'Result Field Number', SCR3.SrcTable AS 'Main Source Table', SCR3.SrcField AS 'Main Source Table Field', SCR3.CalcCase AS 'Additional Calcul. Expression', SCR3.CalcTable AS 'Main Calculation Expression', SCR3.CondCase AS 'Additional Calcul. Condition', SCR3.CondTable AS 'Main Calculation Condition', SCR3.Grouping AS 'Group by Clause', SCR3.CallProc AS 'Recalculation Stored Procedure Name', SCR3.ExtCond AS 'Extended Special Data' FROM SCR3 AS SCR3

Related information


Special Ledger - Analytical Accounting Configuration Rules: Revenues & Expenses OSCR SQL Table
SAP® Business One is the trademark(s) or registered trademark(s) of SAP AG in Germany and in several other countries. Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates