biuan SAP® BUSINESS ONE SDK
SQL Finance / Special Ledger - Analytical Accounting Configuration Rule Conditions: Revenues & Expenses
API SCR1
SCR1 - Special Ledger - Analytical Accounting Configuration Rule Conditions: 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
CondNumCondition NumberInt
6
Value1Static ValuenVarChar
127
Table1Table NamenVarChar
20
Field1Table Field NamenVarChar
127
Cond1Value Selection ConditionnVarChar
127
Group1Group by ClausenVarChar
100
RelationComparison OperatornVarChar
50
Value2Static ValuenVarChar
127
Table2Table NamenVarChar
20
Field2Table Field NamenVarChar
127
Cond2Comparison OperatornVarChar
127
Group2Group by ClausenVarChar
100
ExtCond1Extended Special DatanVarChar
127
ExtCond2Extended Special DatanVarChar
127

SELECT statement

SELECT SCR1.RuleID AS 'Rule Identification Number', SCR1.CondNum AS 'Condition Number', SCR1.Value1 AS 'Static Value', SCR1.Table1 AS 'Table Name', SCR1.Field1 AS 'Table Field Name', SCR1.Cond1 AS 'Value Selection Condition', SCR1.Group1 AS 'Group by Clause', SCR1.Relation AS 'Comparison Operator', SCR1.Value2 AS 'Static Value', SCR1.Table2 AS 'Table Name', SCR1.Field2 AS 'Table Field Name', SCR1.Cond2 AS 'Comparison Operator', SCR1.Group2 AS 'Group by Clause', SCR1.ExtCond1 AS 'Extended Special Data', SCR1.ExtCond2 AS 'Extended Special Data' FROM SCR1 AS SCR1

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