biuan SAP® BUSINESS ONE SDK
API SCM1
SCM1 - Special Ledger - Analytical Accounting Configuration Rule Conditions: Material Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
RuleID KEY UNIQUERule Identification NumberInt
6OSCM
Special Ledger - Analytical Accounting Configuration Rules: Material
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 SCM1.RuleID AS 'Rule Identification Number', SCM1.CondNum AS 'Condition Number', SCM1.Value1 AS 'Static Value', SCM1.Table1 AS 'Table Name', SCM1.Field1 AS 'Table Field Name', SCM1.Cond1 AS 'Value Selection Condition', SCM1.Group1 AS 'Group by Clause', SCM1.Relation AS 'Comparison Operator', SCM1.Value2 AS 'Static Value', SCM1.Table2 AS 'Table Name', SCM1.Field2 AS 'Table Field Name', SCM1.Cond2 AS 'Comparison Operator', SCM1.Group2 AS 'Group by Clause', SCM1.ExtCond1 AS 'Extended Special Data', SCM1.ExtCond2 AS 'Extended Special Data' FROM SCM1 AS SCM1

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