|
|
API OGRS
OGRS - G/L Account Advanced Rules for Resources Table
Business Partner OCRD SQL Table
Resources ORSC SQL Table
G/L Accounts OACT SQL Table
Resource Groups ORSB SQL Table
Usage of Nota Fiscal OUSG 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 | AbsEntry KEY UNIQUE | Internal Number | Int | 11 | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| PeriodCat | Period Category | nVarChar | 10 | |||||
| FinancYear | Beginning of Financial Year | Date | 8 | |||||
| Year | Financial Year | Int | 6 | |||||
| PeriodName | Period Name | nVarChar | 20 | |||||
| SubType | Sub-Period Type | VarChar | Y) Year Q) Quarters M) Months D) Days | 1 | Y | |||
| PeriodNum | Number of Periods | Int | 11 | |||||
| F_RefDate | Posting Date From | Date | 8 | |||||
| T_RefDate | Posting Date To | Date | 8 | |||||
| F_DueDate | Due Date From | Date | 8 | |||||
| T_DueDate | Due Date To | Date | 8 | |||||
| F_TaxDate | Document Date From | Date | 8 | |||||
| T_TaxDate | Document Date To | Date | 8 | |||||
| LogInstanc | Log Instance | Int | 11 | |||||
| UpdateDate | Date of Update | Date | 8 | |||||
| UserSign | User Signature | Int | 6 | OUSR Users | ||||
| UserSign2 | Updating User | Int | 6 | OUSR Users | ||||
| ResCode | Resource No. | nVarChar | 20 | ORSC Resources | ||||
| ResGrpCod | Resource Group | Int | 6 | ORSB Resource Groups | ||||
| WhsCode | Warehouse Code | nVarChar | 8 | |||||
| BPGrpCod | BP Group | Int | 6 | |||||
| LicTradNum | Federal Tax ID | nVarChar | !^|) All !^|E) Empty !^|F) Filled Enter Tax ID) Enter Tax ID | 32 | !^| | |||
| ShipCountr | Ship-To Country | nVarChar | 3 | |||||
| ShipState | Ship-To State | nVarChar | 3 | |||||
| Comments | Remarks | nVarChar | 127 | |||||
| CreateDate | Creation Date | Date | 8 | |||||
| RuleCode | Advanced Rule Code | nVarChar | 20 | |||||
| GLMethod | Get G/L Account By | VarChar | A) General W) Warehouse C) Resource Group | 1 | A | |||
| Transfered | Year Transfer [Y/N] | VarChar | Y) Yes N) No | 1 | N | |||
| FromDate | From Date | Date | 8 | |||||
| ToDate | To Date | Date | 8 | |||||
| ResRevAct | Resource Revenue Account | nVarChar | 15 | OACT G/L Accounts | ||||
| ResExpAct | Resource Expense Account | nVarChar | 15 | OACT G/L Accounts | ||||
| ResSaleAct | Resource Sales Credit Account | nVarChar | 15 | OACT G/L Accounts | ||||
| ResPurAct | Resource Purchase Credit Acct | nVarChar | 15 | OACT G/L Accounts | ||||
| ResNInvAct | Resource Received Not Inv. Acct | nVarChar | 15 | OACT G/L Accounts | ||||
| ResStdExp1 | Resource Std. Cost Expense 1 | nVarChar | 15 | OACT G/L Accounts | ||||
| ResStdExp2 | Resource Std. Cost Expense 2 | nVarChar | 15 | OACT G/L Accounts | ||||
| ResStdExp3 | Resource Std. Cost Expense 3 | nVarChar | 15 | OACT G/L Accounts | ||||
| ResStdExp4 | Resource Std. Cost Expense 4 | nVarChar | 15 | OACT G/L Accounts | ||||
| ResStdExp5 | Resource Std. Cost Expense 5 | nVarChar | 15 | OACT G/L Accounts | ||||
| ResStdExp6 | Resource Std. Cost Expense 6 | nVarChar | 15 | OACT G/L Accounts | ||||
| ResStdExp7 | Resource Std. Cost Expense 7 | nVarChar | 15 | OACT G/L Accounts | ||||
| ResStdExp8 | Resource Std. Cost Expense 8 | nVarChar | 15 | OACT G/L Accounts | ||||
| ResStdExp9 | Resource Std. Cost Expense 9 | nVarChar | 15 | OACT G/L Accounts | ||||
| ResStdEx10 | Resource Std. Cost Expense 10 | nVarChar | 15 | OACT G/L Accounts | ||||
| ResWipAct | Resource WIP Account | nVarChar | 15 | OACT G/L Accounts | ||||
| ResScrapAc | Scrap Account | nVarChar | 15 | OACT G/L Accounts | ||||
| WipOffPlAc | WIP Offset P&L Account | nVarChar | 15 | OACT G/L Accounts | ||||
| ResOffPlAc | Resource Offset P&L Account | nVarChar | 15 | OACT G/L Accounts | ||||
| Active | Is Rule Active | VarChar | Y) Yes N) No | 1 | Y | |||
| CmpPrivate | Company/Private | VarChar | A) All C) Company I) Private | 1 | A | |||
| VatGroup | Tax Definition | nVarChar | 8 | OVTG Tax Definition | ||||
| CardCode | Customer/Vendor Code | nVarChar | 15 | OCRD Business Partner | ||||
| Usage | Usage Code for Document | Int | 11 | OUSG Usage of Nota Fiscal |
Table relationship map
SELECT statement
SELECT
OGRS.AbsEntry AS 'Internal Number',
OGRS.PeriodCat AS 'Period Category',
OGRS.FinancYear AS 'Beginning of Financial Year',
OGRS.Year AS 'Financial Year',
OGRS.PeriodName AS 'Period Name',
OGRS.SubType AS 'Sub-Period Type',
OGRS.PeriodNum AS 'Number of Periods',
OGRS.F_RefDate AS 'Posting Date From',
OGRS.T_RefDate AS 'Posting Date To',
OGRS.F_DueDate AS 'Due Date From',
OGRS.T_DueDate AS 'Due Date To',
OGRS.F_TaxDate AS 'Document Date From',
OGRS.T_TaxDate AS 'Document Date To',
OGRS.LogInstanc AS 'Log Instance',
OGRS.UpdateDate AS 'Date of Update',
OGRS.UserSign AS 'User Signature',
OGRS.UserSign2 AS 'Updating User',
OGRS.ResCode AS 'Resource No.',
OGRS.ResGrpCod AS 'Resource Group',
OGRS.WhsCode AS 'Warehouse Code',
OGRS.BPGrpCod AS 'BP Group',
OGRS.LicTradNum AS 'Federal Tax ID',
OGRS.ShipCountr AS 'Ship-To Country',
OGRS.ShipState AS 'Ship-To State',
OGRS.Comments AS 'Remarks',
OGRS.CreateDate AS 'Creation Date',
OGRS.RuleCode AS 'Advanced Rule Code',
OGRS.GLMethod AS 'Get G/L Account By',
OGRS.Transfered AS 'Year Transfer [Y/N]',
OGRS.FromDate AS 'From Date',
OGRS.ToDate AS 'To Date',
OGRS.ResRevAct AS 'Resource Revenue Account',
OGRS.ResExpAct AS 'Resource Expense Account',
OGRS.ResSaleAct AS 'Resource Sales Credit Account',
OGRS.ResPurAct AS 'Resource Purchase Credit Acct',
OGRS.ResNInvAct AS 'Resource Received Not Inv. Acct',
OGRS.ResStdExp1 AS 'Resource Std. Cost Expense 1',
OGRS.ResStdExp2 AS 'Resource Std. Cost Expense 2',
OGRS.ResStdExp3 AS 'Resource Std. Cost Expense 3',
OGRS.ResStdExp4 AS 'Resource Std. Cost Expense 4',
OGRS.ResStdExp5 AS 'Resource Std. Cost Expense 5',
OGRS.ResStdExp6 AS 'Resource Std. Cost Expense 6',
OGRS.ResStdExp7 AS 'Resource Std. Cost Expense 7',
OGRS.ResStdExp8 AS 'Resource Std. Cost Expense 8',
OGRS.ResStdExp9 AS 'Resource Std. Cost Expense 9',
OGRS.ResStdEx10 AS 'Resource Std. Cost Expense 10',
OGRS.ResWipAct AS 'Resource WIP Account',
OGRS.ResScrapAc AS 'Scrap Account',
OGRS.WipOffPlAc AS 'WIP Offset P&L Account',
OGRS.ResOffPlAc AS 'Resource Offset P&L Account',
OGRS.Active AS 'Is Rule Active',
OGRS.CmpPrivate AS 'Company/Private',
OGRS.VatGroup AS 'Tax Definition',
OGRS.CardCode AS 'Customer/Vendor Code',
OGRS.Usage AS 'Usage Code for Document'
FROM OGRS AS OGRS
Related information
Business Partner OCRD SQL Table
Resources ORSC SQL Table
G/L Accounts OACT SQL Table
Resource Groups ORSB SQL Table
Usage of Nota Fiscal OUSG 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
