|
|
API AGAR
AGAR - G/L Account Advanced Rules - History Table
G/L Accounts OACT SQL Table
Card Groups OCRG SQL Table
Business Partner OCRD SQL Table
Items OITM SQL Table
Item Groups OITB SQL Table
Countries OCRY SQL Table
States OCST SQL Table
Usage of Nota Fiscal OUSG SQL Table
Users OUSR SQL Table
Tax Definition OVTG SQL Table
Warehouses OWHS 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 | ||||
| ItemCode | Item No. | nVarChar | 20 | OITM Items | ||||
| ItmsGrpCod | Item Group | Int | 6 | OITB Item Groups | ||||
| WhsCode | Warehouse Code | nVarChar | 8 | OWHS Warehouses | ||||
| BPGrpCod | BP Group | Int | 6 | OCRG Card Groups | ||||
| LicTradNum | Federal Tax ID | nVarChar | !^|) All !^|E) Empty !^|F) Filled Enter Tax ID) Enter Tax ID | 32 | !^| | |||
| ShipCountr | Ship-to Country | nVarChar | 3 | OCRY Countries | ||||
| ShipState | Ship-To State | nVarChar | 3 | OCST States | ||||
| 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) Item 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 | |||||
| DfltExpn | Expense Account | nVarChar | 15 | OACT G/L Accounts | ||||
| DfltIncom | Revenue Account | nVarChar | 15 | OACT G/L Accounts | ||||
| ExmptIncom | Tax Exempt Revenue Account | nVarChar | 15 | OACT G/L Accounts | ||||
| StockAct | Inventory Account | nVarChar | 15 | OACT G/L Accounts | ||||
| COGM_Act | Cost of Goods Sold Account | nVarChar | 15 | OACT G/L Accounts | ||||
| AlocCstAct | Allocation Account | nVarChar | 15 | OACT G/L Accounts | ||||
| VariancAct | Variance Account | nVarChar | 15 | OACT G/L Accounts | ||||
| PricDifAct | Price Difference Account | nVarChar | 15 | OACT G/L Accounts | ||||
| NegStckAct | Negative Inventory Adj. Acct | nVarChar | 15 | OACT G/L Accounts | ||||
| DfltLoss | Inventory Offset - Decr. Acct | nVarChar | 15 | OACT G/L Accounts | ||||
| DfltProfit | Inventory Offset - Incr. Acct | nVarChar | 15 | OACT G/L Accounts | ||||
| RturnngAct | Sales Returns Account | nVarChar | 15 | OACT G/L Accounts | ||||
| ECIncome | Revenue Account - EU | nVarChar | 15 | OACT G/L Accounts | ||||
| ECExepnses | Expense Account - EU | nVarChar | 15 | OACT G/L Accounts | ||||
| ForgnIncm | Revenue Account - Foreign | nVarChar | 15 | OACT G/L Accounts | ||||
| ForgnExpn | Expense Account - Foreign | nVarChar | 15 | OACT G/L Accounts | ||||
| PurchseAct | Purchase Account | nVarChar | 15 | OACT G/L Accounts | ||||
| PaReturnAc | Purchase Return Account | nVarChar | 15 | OACT G/L Accounts | ||||
| PaOffsetAc | Purchase Offset Account | nVarChar | 15 | OACT G/L Accounts | ||||
| ExDiffAct | Exchange Rate Differences Acct | nVarChar | 15 | OACT G/L Accounts | ||||
| BalanceAct | Goods Clearing Account | nVarChar | 15 | OACT G/L Accounts | ||||
| DecresGlAc | G/L Decrease Account | nVarChar | 15 | OACT G/L Accounts | ||||
| IncresGlAc | G/L Increase Account | nVarChar | 15 | OACT G/L Accounts | ||||
| WipAcct | WIP Inventory Account | nVarChar | 15 | OACT G/L Accounts | ||||
| WipVarAcct | WIP Inventory Variance Account | nVarChar | 15 | OACT G/L Accounts | ||||
| WipOffset | WIP Offset P&L Account | nVarChar | 15 | OACT G/L Accounts | ||||
| StockOffst | Inventory Offset P&L Account | nVarChar | 15 | OACT G/L Accounts | ||||
| StockRvAct | Inventory Revaluation Account | nVarChar | 15 | OACT G/L Accounts | ||||
| StkRvOfAct | Inventory Reval. Offset Acct | nVarChar | 15 | OACT G/L Accounts | ||||
| CostRevAct | COGS Revaluation Acct | nVarChar | 15 | OACT G/L Accounts | ||||
| CostOffAct | COGS Revaluation Offset Acct | nVarChar | 15 | OACT G/L Accounts | ||||
| ExpClrAct | Expense Clearing Account | nVarChar | 15 | OACT G/L Accounts | ||||
| ExpOfstAct | Expense Offset Account | nVarChar | 15 | OACT G/L Accounts | ||||
| StkInTnAct | Stock In Transit Account | nVarChar | 15 | OACT G/L Accounts | ||||
| ShpdGdsAct | Shipped Goods Account | nVarChar | 15 | OACT G/L Accounts | ||||
| VatRevAct | VAT in Revenue Account | nVarChar | 15 | OACT G/L Accounts | ||||
| ARCMAct | Sales Credit Account | nVarChar | 15 | OACT G/L Accounts | ||||
| APCMAct | Purchase Credit Account | nVarChar | 15 | OACT G/L Accounts | ||||
| ARCMExpAct | Tax Exempt Credit Account | nVarChar | 15 | OACT G/L Accounts | ||||
| ARCMFrnAct | Sales Credit Account - Foreign | nVarChar | 15 | OACT G/L Accounts | ||||
| APCMFrnAct | Purchase Credit Acct - Foreign | nVarChar | 15 | OACT G/L Accounts | ||||
| ARCMEUAct | Sales Credit Account - EU | nVarChar | 15 | OACT G/L Accounts | ||||
| APCMEUAct | Purchase Credit Account - EU | nVarChar | 15 | OACT G/L Accounts | ||||
| PurBalAct | Purchase Balance Account | nVarChar | 15 | OACT G/L Accounts | ||||
| WhICenAct | Incoming CENVAT Account (WH) | nVarChar | 15 | OACT G/L Accounts | ||||
| WhOCenAct | Outgoing CENVAT Account (WH) | nVarChar | 15 | OACT G/L Accounts | ||||
| Active | Is Rule Active | VarChar | Y) Yes N) No | 1 | Y | |||
| CmpPrivate | Company/Private/Government | VarChar | A) All C) Company I) Private G) Government | 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 | ||||
| FreeChrgSA | Free of Charge Sales Account | nVarChar | 15 | OACT G/L Accounts | ||||
| FreeChrgPU | Free of Charge Purchase Account | nVarChar | 15 | OACT G/L Accounts |
Table relationship map
SELECT statement
SELECT
AGAR.AbsEntry AS 'Internal Number',
AGAR.PeriodCat AS 'Period Category',
AGAR.FinancYear AS 'Beginning of Financial Year',
AGAR.Year AS 'Financial Year',
AGAR.PeriodName AS 'Period Name',
AGAR.SubType AS 'Sub-Period Type',
AGAR.PeriodNum AS 'Number of Periods',
AGAR.F_RefDate AS 'Posting Date From',
AGAR.T_RefDate AS 'Posting Date To',
AGAR.F_DueDate AS 'Due Date From',
AGAR.T_DueDate AS 'Due Date To',
AGAR.F_TaxDate AS 'Document Date From',
AGAR.T_TaxDate AS 'Document Date To',
AGAR.LogInstanc AS 'Log Instance',
AGAR.UpdateDate AS 'Date of Update',
AGAR.UserSign AS 'User Signature',
AGAR.UserSign2 AS 'Updating User',
AGAR.ItemCode AS 'Item No.',
AGAR.ItmsGrpCod AS 'Item Group',
AGAR.WhsCode AS 'Warehouse Code',
AGAR.BPGrpCod AS 'BP Group',
AGAR.LicTradNum AS 'Federal Tax ID',
AGAR.ShipCountr AS 'Ship-to Country',
AGAR.ShipState AS 'Ship-To State',
AGAR.Comments AS 'Remarks',
AGAR.CreateDate AS 'Creation Date',
AGAR.RuleCode AS 'Advanced Rule Code',
AGAR.GLMethod AS 'Get G/L Account By',
AGAR.Transfered AS 'Year Transfer [Y/N]',
AGAR.FromDate AS 'From Date',
AGAR.ToDate AS 'To Date',
AGAR.DfltExpn AS 'Expense Account',
AGAR.DfltIncom AS 'Revenue Account',
AGAR.ExmptIncom AS 'Tax Exempt Revenue Account',
AGAR.StockAct AS 'Inventory Account',
AGAR.COGM_Act AS 'Cost of Goods Sold Account',
AGAR.AlocCstAct AS 'Allocation Account',
AGAR.VariancAct AS 'Variance Account',
AGAR.PricDifAct AS 'Price Difference Account',
AGAR.NegStckAct AS 'Negative Inventory Adj. Acct',
AGAR.DfltLoss AS 'Inventory Offset - Decr. Acct',
AGAR.DfltProfit AS 'Inventory Offset - Incr. Acct',
AGAR.RturnngAct AS 'Sales Returns Account',
AGAR.ECIncome AS 'Revenue Account - EU',
AGAR.ECExepnses AS 'Expense Account - EU',
AGAR.ForgnIncm AS 'Revenue Account - Foreign',
AGAR.ForgnExpn AS 'Expense Account - Foreign',
AGAR.PurchseAct AS 'Purchase Account',
AGAR.PaReturnAc AS 'Purchase Return Account',
AGAR.PaOffsetAc AS 'Purchase Offset Account',
AGAR.ExDiffAct AS 'Exchange Rate Differences Acct',
AGAR.BalanceAct AS 'Goods Clearing Account',
AGAR.DecresGlAc AS 'G/L Decrease Account',
AGAR.IncresGlAc AS 'G/L Increase Account',
AGAR.WipAcct AS 'WIP Inventory Account',
AGAR.WipVarAcct AS 'WIP Inventory Variance Account',
AGAR.WipOffset AS 'WIP Offset P&L Account',
AGAR.StockOffst AS 'Inventory Offset P&L Account',
AGAR.StockRvAct AS 'Inventory Revaluation Account',
AGAR.StkRvOfAct AS 'Inventory Reval. Offset Acct',
AGAR.CostRevAct AS 'COGS Revaluation Acct',
AGAR.CostOffAct AS 'COGS Revaluation Offset Acct',
AGAR.ExpClrAct AS 'Expense Clearing Account',
AGAR.ExpOfstAct AS 'Expense Offset Account',
AGAR.StkInTnAct AS 'Stock In Transit Account',
AGAR.ShpdGdsAct AS 'Shipped Goods Account',
AGAR.VatRevAct AS 'VAT in Revenue Account',
AGAR.ARCMAct AS 'Sales Credit Account',
AGAR.APCMAct AS 'Purchase Credit Account',
AGAR.ARCMExpAct AS 'Tax Exempt Credit Account',
AGAR.ARCMFrnAct AS 'Sales Credit Account - Foreign',
AGAR.APCMFrnAct AS 'Purchase Credit Acct - Foreign',
AGAR.ARCMEUAct AS 'Sales Credit Account - EU',
AGAR.APCMEUAct AS 'Purchase Credit Account - EU',
AGAR.PurBalAct AS 'Purchase Balance Account',
AGAR.WhICenAct AS 'Incoming CENVAT Account (WH)',
AGAR.WhOCenAct AS 'Outgoing CENVAT Account (WH)',
AGAR.Active AS 'Is Rule Active',
AGAR.CmpPrivate AS 'Company/Private/Government',
AGAR.VatGroup AS 'Tax Definition',
AGAR.CardCode AS 'Customer/Vendor Code',
AGAR.Usage AS 'Usage Code for Document',
AGAR.FreeChrgSA AS 'Free of Charge Sales Account',
AGAR.FreeChrgPU AS 'Free of Charge Purchase Account'
FROM AGAR AS AGAR
Related information
G/L Accounts OACT SQL Table
Card Groups OCRG SQL Table
Business Partner OCRD SQL Table
Items OITM SQL Table
Item Groups OITB SQL Table
Countries OCRY SQL Table
States OCST SQL Table
Usage of Nota Fiscal OUSG SQL Table
Users OUSR SQL Table
Tax Definition OVTG SQL Table
Warehouses OWHS SQL Table
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
