|
|
API RCR1
RCR1 - Recurring Postings - Rows Table
Business Place OBPL SQL Table
Distribution Rule OOCR SQL Table
Project Codes OPRJ SQL Table
Recurring Postings ORCR SQL Table
Sales Tax Authorities OSTA SQL Table
Sales Tax Authorities Type OSTT SQL Table
Sales Tax Codes OSTC SQL Table
Users OUSR SQL Table
Tax Definition OVTG SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | RcurCode KEY UNIQUE | Recurring Postings Code | nVarChar | 8 | ORCR Recurring Postings | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| LineId | Row Number | Int | 11 | 0 | ||||
| AcctCode | Account Code | nVarChar | 15 | |||||
| AcctDesc | Account Description | nVarChar | 100 | |||||
| Debit | Debit | Num | 20 | |||||
| Credit | Credit | Num | 20 | |||||
| Currency | Currency | nVarChar | 3 | |||||
| Instance | Instance | Int | 6 | |||||
| VatGroup | Tax Group | nVarChar | 8 | OVTG Tax Definition | ||||
| UserSign | User Signature | Int | 6 | OUSR Users | ||||
| VatLine | VAT Row | VarChar | Y) Yes N) No | 1 | N | |||
| CtrlAcct | Control Account | nVarChar | 15 | |||||
| OcrCode | Distr. Rule | nVarChar | 8 | OOCR Distribution Rule | ||||
| TaxType | Tax Type | Int | 6 | 0 | ||||
| TaxPostAcc | Tax Posting Account | VarChar | N) R) Sales Tax Account P) Purchasing Tax Account | 1 | N | |||
| StaCode | Authority Code | nVarChar | 8 | OSTA Sales Tax Authorities | ||||
| StaType | Authority Type | Int | 11 | OSTT Sales Tax Authorities Type | ||||
| TaxCode | Tax Code | nVarChar | 8 | OSTC Sales Tax Codes | ||||
| OcrCode1 | Costing Code 1 | nVarChar | 8 | OOCR Distribution Rule | ||||
| OcrCode2 | Costing Code 2 | nVarChar | 8 | OOCR Distribution Rule | ||||
| OcrCode3 | Costing Code 3 | nVarChar | 8 | OOCR Distribution Rule | ||||
| OcrCode4 | Costing Code 4 | nVarChar | 8 | OOCR Distribution Rule | ||||
| OcrCode5 | Costing Code 5 | nVarChar | 8 | OOCR Distribution Rule | ||||
| WtLiable | WTax-Liable | VarChar | Y) Yes N) No | 1 | ||||
| WTaxLine | WTax Row | VarChar | Y) Yes N) No | 1 | N | |||
| GrossValue | Gross Value | Num | 20 | |||||
| Project | Project Code | nVarChar | 20 | OPRJ Project Codes | ||||
| BPLId | Branch | Int | 11 | OBPL Business Place |
Table relationship map
SELECT statement
SELECT
RCR1.RcurCode AS 'Recurring Postings Code',
RCR1.LineId AS 'Row Number',
RCR1.AcctCode AS 'Account Code',
RCR1.AcctDesc AS 'Account Description',
RCR1.Debit AS 'Debit',
RCR1.Credit AS 'Credit',
RCR1.Currency AS 'Currency',
RCR1.Instance AS 'Instance',
RCR1.VatGroup AS 'Tax Group',
RCR1.UserSign AS 'User Signature',
RCR1.VatLine AS 'VAT Row',
RCR1.CtrlAcct AS 'Control Account',
RCR1.OcrCode AS 'Distr. Rule',
RCR1.TaxType AS 'Tax Type',
RCR1.TaxPostAcc AS 'Tax Posting Account',
RCR1.StaCode AS 'Authority Code',
RCR1.StaType AS 'Authority Type',
RCR1.TaxCode AS 'Tax Code',
RCR1.OcrCode1 AS 'Costing Code 1',
RCR1.OcrCode2 AS 'Costing Code 2',
RCR1.OcrCode3 AS 'Costing Code 3',
RCR1.OcrCode4 AS 'Costing Code 4',
RCR1.OcrCode5 AS 'Costing Code 5',
RCR1.WtLiable AS 'WTax-Liable',
RCR1.WTaxLine AS 'WTax Row',
RCR1.GrossValue AS 'Gross Value',
RCR1.Project AS 'Project Code',
RCR1.BPLId AS 'Branch'
FROM RCR1 AS RCR1
Related information
Business Place OBPL SQL Table
Distribution Rule OOCR SQL Table
Project Codes OPRJ SQL Table
Recurring Postings ORCR SQL Table
Sales Tax Authorities OSTA SQL Table
Sales Tax Authorities Type OSTT SQL Table
Sales Tax Codes OSTC SQL Table
Users OUSR SQL Table
Tax Definition OVTG SQL Table
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
