biuan SAP® BUSINESS ONE SDK
API SCM3
SCM3 - Special Ledger - Analytical Accounting Configuration Rule Additional Calculations: Material Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
RuleID KEY UNIQUERule Identification NumberInt
6OSCM
Special Ledger - Analytical Accounting Configuration Rules: Material
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 SCM3.RuleID AS 'Rule Identification Number', SCM3.FldNum AS 'Result Field Number', SCM3.SrcTable AS 'Main Source Table', SCM3.SrcField AS 'Main Source Table Field', SCM3.CalcCase AS 'Additional Calcul. Expression', SCM3.CalcTable AS 'Main Calculation Expression', SCM3.CondCase AS 'Additional Calcul. Condition', SCM3.CondTable AS 'Main Calculation Condition', SCM3.Grouping AS 'Group by Clause', SCM3.CallProc AS 'Recalculation Stored Procedure Name', SCM3.ExtCond AS 'Extended Special Data' FROM SCM3 AS SCM3

Related information


Special Ledger - Analytical Accounting Configuration Rules: Material OSCM 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