|
|
API FRC1
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | CatId | Numerator | Int | 6 |
|---|---|---|---|---|---|---|---|---|
| TemplateId KEY UNIQUE | Template | Int | 11 | OFRT Financial Report Templates | PRIMARY | Yes | ||
| AcctCode KEY | Account Code | nVarChar | 15 | OACT G/L Accounts | ACCNT_CODE | No | ||
| VisOrder | Display Order | Int | 6 | |||||
| CFWId | Cash Flow Line Item ID | Int | 11 | OCFW Cash Flow Line Item | ||||
| CalcMethod | Calculation Method | nVarChar | BOP) Beginning of Period EOP) End of Period CPID) Current Period In Debit CPIC) Current Period In Credit CPIB) Current Period In Both | 30 | ||||
| SlpCode | Sales Unit Code | Int | 11 | OSLP Sales Employee | ||||
| PrcCode | Cost Center Code | nVarChar | 8 | OPRC Cost Center | ||||
| CalMethod2 | Calculation Method 2 | nVarChar | 30 | |||||
| CalMethod3 | Calculation Method 3 | nVarChar | 30 | |||||
| Linked | Linked | VarChar | B) Balance D) Debit C) Credit | 1 | B | |||
| Sign | Sign | VarChar | E) P) Positive N) Negative | 1 | E |
Table relationship map
SELECT statement
SELECT
FRC1.CatId AS 'Numerator',
FRC1.TemplateId AS 'Template',
FRC1.AcctCode AS 'Account Code',
FRC1.VisOrder AS 'Display Order',
FRC1.CFWId AS 'Cash Flow Line Item ID',
FRC1.CalcMethod AS 'Calculation Method',
FRC1.SlpCode AS 'Sales Unit Code',
FRC1.PrcCode AS 'Cost Center Code',
FRC1.CalMethod2 AS 'Calculation Method 2',
FRC1.CalMethod3 AS 'Calculation Method 3',
FRC1.Linked AS 'Linked',
FRC1.Sign AS 'Sign'
FROM FRC1 AS FRC1
Related information
G/L Accounts OACT SQL Table
Cash Flow Line Item OCFW SQL Table
Cost Center OPRC SQL Table
Sales Employee OSLP SQL Table
Financial Report Templates OFRT SQL Table
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates