|
|
API SCM2
SCM2 - Special Ledger - Analytical Accounting Configuration Rule Goals: Material Table
G/L Accounts OACT SQL Table
Distribution Rule OOCR SQL Table
Special Ledger - Analytical Accounting Configuration Rules: Material OSCM SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | RuleID KEY UNIQUE | Rule Identification Number | Int | 6 | OSCM Special Ledger - Analytical Accounting Configuration Rules: Material | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| GoalNum | Rule Goal Number | nVarChar | 6 | |||||
| TransTpVal | Transaction Type Number | Int | 6 | |||||
| TransTpFld | Transaction Type Table Field | nVarChar | 20 | |||||
| PrfCntVal | Distribution Rule Code | nVarChar | 8 | OOCR Distribution Rule | ||||
| PrfCntFld | Distribution Rule Table Field | nVarChar | 20 | |||||
| DebitAct | Debit Account | nVarChar | 15 | OACT G/L Accounts | ||||
| CreditAct | Credit Account | nVarChar | 15 | OACT G/L Accounts | ||||
| RevSides | Revert Debit/Credit Sides | VarChar | N) No Y) Yes | 1 | N | |||
| SrcTable | Main Source Table | nVarChar | 10 | |||||
| SrcField | Main Source Table Field | nVarChar | 20 | |||||
| SrcFieldFC | Source Field, Foreign Currency | nVarChar | 20 | |||||
| SrcFieldSC | Source Field, System Currency | nVarChar | 20 | |||||
| Calc | Calculation Expression | nVarChar | 127 | |||||
| CalcFC | Expression for Foreign Calculation | nVarChar | 127 | |||||
| CalcSC | Expression for System Calculation | nVarChar | 127 | |||||
| CalcCond | Calculation Condition | nVarChar | 127 | |||||
| CalcCondFC | Condition for Foreign Calculation | nVarChar | 127 | |||||
| CalcCondSC | Condition for System Calculation | nVarChar | 127 | |||||
| CurrFld | Table Field with Currency | nVarChar | 20 | |||||
| CallProc | Recalculation Stored Procedure Name | nVarChar | 50 | |||||
| ExtCond | Extended Special Data | nVarChar | 127 |
Table relationship map
SELECT statement
SELECT
SCM2.RuleID AS 'Rule Identification Number',
SCM2.GoalNum AS 'Rule Goal Number',
SCM2.TransTpVal AS 'Transaction Type Number',
SCM2.TransTpFld AS 'Transaction Type Table Field',
SCM2.PrfCntVal AS 'Distribution Rule Code',
SCM2.PrfCntFld AS 'Distribution Rule Table Field',
SCM2.DebitAct AS 'Debit Account',
SCM2.CreditAct AS 'Credit Account',
SCM2.RevSides AS 'Revert Debit/Credit Sides',
SCM2.SrcTable AS 'Main Source Table',
SCM2.SrcField AS 'Main Source Table Field',
SCM2.SrcFieldFC AS 'Source Field, Foreign Currency',
SCM2.SrcFieldSC AS 'Source Field, System Currency',
SCM2.Calc AS 'Calculation Expression',
SCM2.CalcFC AS 'Expression for Foreign Calculation',
SCM2.CalcSC AS 'Expression for System Calculation',
SCM2.CalcCond AS 'Calculation Condition',
SCM2.CalcCondFC AS 'Condition for Foreign Calculation',
SCM2.CalcCondSC AS 'Condition for System Calculation',
SCM2.CurrFld AS 'Table Field with Currency',
SCM2.CallProc AS 'Recalculation Stored Procedure Name',
SCM2.ExtCond AS 'Extended Special Data'
FROM SCM2 AS SCM2
Related information
G/L Accounts OACT SQL Table
Distribution Rule OOCR SQL Table
Special Ledger - Analytical Accounting Configuration Rules: Material OSCM SQL Table
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
