|
|
API AITB
AITB - Item Groups - History Table
G/L Accounts OACT SQL Table
Cycle OCYC SQL Table
Service Code Table OSCD SQL Table
UoM Master Data OUOM SQL Table
Material Group OMGP SQL Table
Material Type OMTP SQL Table
NCM Code ONCM SQL Table
Product Source Code OPSC SQL Table
Checking Rule ODCR SQL Table
Service Group for Brazil OSGP SQL Table
UoM Group OUGP SQL Table
Users OUSR SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | ItmsGrpCod KEY UNIQUE | Number | Int | 6 | PRIMARY | Yes |
|---|---|---|---|---|---|---|---|---|
| ItmsGrpNam KEY UNIQUE | Group Name | nVarChar | 20 | GROUP_NAME | Yes | |||
| Locked | Locked | VarChar | N) Changeable Y) Locked | 1 | N | |||
| DataSource | Data Source | VarChar | N) Unknown I) Interface U) Update M) Import O) DI API A) Doc. Generation Wizard D) Restore Wizard P) Partner Implementation T) Year Transfer | 1 | N | |||
| UserSign | User Signature | Int | 6 | OUSR Users | ||||
| BalInvntAc | Inventory Account | nVarChar | 15 | OACT G/L Accounts | ||||
| SaleCostAc | Cost Of Goods Sold | nVarChar | 15 | OACT G/L Accounts | ||||
| TransferAc | Allocation Acct | nVarChar | 15 | OACT G/L Accounts | ||||
| RevenuesAc | Revenue Account | nVarChar | 15 | OACT G/L Accounts | ||||
| VarianceAc | Variance Acct | nVarChar | 15 | OACT G/L Accounts | ||||
| DecreasAc | Inventory Offset - Decrease | nVarChar | 15 | OACT G/L Accounts | ||||
| IncreasAc | Inventory Offset - Increase | nVarChar | 15 | OACT G/L Accounts | ||||
| ReturnAc | Sales Returns | nVarChar | 15 | OACT G/L Accounts | ||||
| ExpensesAc | Expense Account | nVarChar | 15 | OACT G/L Accounts | ||||
| EURevenuAc | Sales Revenue - EU | nVarChar | 15 | OACT G/L Accounts | ||||
| EUExpensAc | EU Expense Acct | nVarChar | 15 | OACT G/L Accounts | ||||
| FrRevenuAc | Sales Revenue - Foreign | nVarChar | 15 | OACT G/L Accounts | ||||
| FrExpensAc | Foreign Expense Acct | nVarChar | 15 | OACT G/L Accounts | ||||
| ExmptIncom | Exempt Revenue Account | nVarChar | 15 | OACT G/L Accounts | ||||
| CycleCode | Cycle Code | Int | 6 | OCYC Cycle | ||||
| Alert | Alert | VarChar | N) No Y) Yes | 1 | N | |||
| PriceDifAc | Price Difference Account | nVarChar | 15 | OACT G/L Accounts | ||||
| ExchangeAc | Exchange Rate Differences Account | nVarChar | 15 | OACT G/L Accounts | ||||
| BalanceAcc | Goods Clearing Acct | nVarChar | 15 | OACT G/L Accounts | ||||
| PurchaseAc | Purchase Acct | nVarChar | 15 | OACT G/L Accounts | ||||
| PAReturnAc | PA Return Acct | nVarChar | 15 | OACT G/L Accounts | ||||
| PurchOfsAc | Purchase Offset Acct | 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 | ||||
| DecresGlAc | G/L Decrease Acct | nVarChar | 15 | OACT G/L Accounts | ||||
| IncresGlAc | G/L Increase Acct | nVarChar | 15 | OACT G/L Accounts | ||||
| InvntSys | Inventory System | VarChar | A) Moving Average S) Standard F) FIFO | 1 | ||||
| PlaningSys | Planning Method | VarChar | M) MRP N) None | 1 | N | |||
| PrcrmntMtd | Procurement Method | VarChar | B) Buy M) Make | 1 | B | |||
| OrdrIntrvl | Order Interval | Int | 6 | OCYC Cycle | ||||
| OrdrMulti | Order Multiple | Num | 20 | |||||
| MinOrdrQty | Minimum Order Quantity | Num | 20 | |||||
| LeadTime | Lead Time | Int | 11 | |||||
| StokRvlAct | Inventory Revaluation Account | nVarChar | 15 | OACT G/L Accounts | ||||
| StkOffsAct | Inventory Revaluation Offset Account | nVarChar | 15 | OACT G/L Accounts | ||||
| WipAcct | WIP Material Account | nVarChar | 15 | OACT G/L Accounts | ||||
| WipVarAcct | WIP Material Variance Account | nVarChar | 15 | OACT G/L Accounts | ||||
| CostRvlAct | Cost of Sale Revaluation Acct | nVarChar | 15 | OACT G/L Accounts | ||||
| CstOffsAct | Cost of Sales Reval. Offs. Acct | nVarChar | 15 | OACT G/L Accounts | ||||
| ExpClrAct | Expenses Clearing Account | nVarChar | 15 | OACT G/L Accounts | ||||
| ExpOfstAct | Expense Offset Account | nVarChar | 15 | OACT G/L Accounts | ||||
| Object | Object Type - History | nVarChar | 20 | 52 | ||||
| logInstanc | Log Instance - History | Int | 11 | |||||
| createDate | Creation Date - History | Date | 8 | |||||
| userSign2 | Updating User - History | Int | 6 | OUSR Users | ||||
| updateDate | Update Date - History | Date | 8 | |||||
| ARCMAct | Sales Credit Acct | nVarChar | 15 | OACT G/L Accounts | ||||
| ARCMFrnAct | Sales Credit Foreign Acct | nVarChar | 15 | OACT G/L Accounts | ||||
| ARCMEUAct | Sales Credit EU Acct | nVarChar | 15 | OACT G/L Accounts | ||||
| ARCMExpAct | Exempted Credits | nVarChar | 15 | OACT G/L Accounts | ||||
| APCMAct | Purchase Credit Acct | nVarChar | 15 | OACT G/L Accounts | ||||
| APCMFrnAct | Foreign Purchase Credit Acct | nVarChar | 15 | OACT G/L Accounts | ||||
| APCMEUAct | EU Purchase Credit Acct | nVarChar | 15 | OACT G/L Accounts | ||||
| RevRetAct | Revenue Returns Account | nVarChar | 15 | OACT G/L Accounts | ||||
| ItemClass | Service or Material | VarChar | 1) Service 2) Material | 1 | 2 | |||
| OSvcCode | Outgoing Service Code | Int | 11 | OSCD Service Code Table | -1 | |||
| ISvcCode | Incoming Service Code | Int | 11 | OSCD Service Code Table | -1 | |||
| ServiceGrp | Service Group | Int | 11 | OSGP Service Group for Brazil | -1 | |||
| NCMCode | NCM Code | Int | 11 | ONCM NCM Code | -1 | |||
| MatType | Material Type | nVarChar | 3 | OMTP Material Type | 1 | |||
| MatGrp | Material Group | Int | 11 | OMGP Material Group | -1 | |||
| ProductSrc | Product Source | nVarChar | 2 | OPSC Product Source Code | 0 | |||
| NegStckAct | Negative Inventory Adjustment | nVarChar | 15 | OACT G/L Accounts | ||||
| StkInTnAct | Stock In Transit Acct | 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 | ||||
| WipOffset | WIP Offset P&L Account | nVarChar | 15 | OACT G/L Accounts | ||||
| StockOffst | Inventory Offset P&L Account | nVarChar | 15 | OACT G/L Accounts | ||||
| UgpEntry | Default UoM Group Entry | Int | 11 | OUGP UoM Group | ||||
| IUoMEntry | Default Inventory UoM | Int | 11 | OUOM UoM Master Data | ||||
| ToleranDay | Tolerance Days | Int | 11 | |||||
| RuleCode | Checking Rule Code | nVarChar | 2 | ODCR Checking Rule | ||||
| CompoWH | Component Warehouse | VarChar | B) From Bill of Materials Line P) From Parent Item Document Line | 1 | B | |||
| FreeChrgSA | Free of Charge Sales Account | nVarChar | 15 | |||||
| FreeChrgPU | Free of Charge Purchase Account | nVarChar | 15 |
Table relationship map
SELECT statement
SELECT
AITB.ItmsGrpCod AS 'Number',
AITB.ItmsGrpNam AS 'Group Name',
AITB.Locked AS 'Locked',
AITB.DataSource AS 'Data Source',
AITB.UserSign AS 'User Signature',
AITB.BalInvntAc AS 'Inventory Account',
AITB.SaleCostAc AS 'Cost Of Goods Sold',
AITB.TransferAc AS 'Allocation Acct',
AITB.RevenuesAc AS 'Revenue Account',
AITB.VarianceAc AS 'Variance Acct',
AITB.DecreasAc AS 'Inventory Offset - Decrease',
AITB.IncreasAc AS 'Inventory Offset - Increase',
AITB.ReturnAc AS 'Sales Returns',
AITB.ExpensesAc AS 'Expense Account',
AITB.EURevenuAc AS 'Sales Revenue - EU',
AITB.EUExpensAc AS 'EU Expense Acct',
AITB.FrRevenuAc AS 'Sales Revenue - Foreign',
AITB.FrExpensAc AS 'Foreign Expense Acct',
AITB.ExmptIncom AS 'Exempt Revenue Account',
AITB.CycleCode AS 'Cycle Code',
AITB.Alert AS 'Alert',
AITB.PriceDifAc AS 'Price Difference Account',
AITB.ExchangeAc AS 'Exchange Rate Differences Account',
AITB.BalanceAcc AS 'Goods Clearing Acct',
AITB.PurchaseAc AS 'Purchase Acct',
AITB.PAReturnAc AS 'PA Return Acct',
AITB.PurchOfsAc AS 'Purchase Offset Acct',
AITB.ShpdGdsAct AS 'Shipped Goods Account',
AITB.VatRevAct AS 'VAT in Revenue Account',
AITB.DecresGlAc AS 'G/L Decrease Acct',
AITB.IncresGlAc AS 'G/L Increase Acct',
AITB.InvntSys AS 'Inventory System',
AITB.PlaningSys AS 'Planning Method',
AITB.PrcrmntMtd AS 'Procurement Method',
AITB.OrdrIntrvl AS 'Order Interval',
AITB.OrdrMulti AS 'Order Multiple',
AITB.MinOrdrQty AS 'Minimum Order Quantity',
AITB.LeadTime AS 'Lead Time',
AITB.StokRvlAct AS 'Inventory Revaluation Account',
AITB.StkOffsAct AS 'Inventory Revaluation Offset Account',
AITB.WipAcct AS 'WIP Material Account',
AITB.WipVarAcct AS 'WIP Material Variance Account',
AITB.CostRvlAct AS 'Cost of Sale Revaluation Acct',
AITB.CstOffsAct AS 'Cost of Sales Reval. Offs. Acct',
AITB.ExpClrAct AS 'Expenses Clearing Account',
AITB.ExpOfstAct AS 'Expense Offset Account',
AITB.Object AS 'Object Type - History',
AITB.logInstanc AS 'Log Instance - History',
AITB.createDate AS 'Creation Date - History',
AITB.userSign2 AS 'Updating User - History',
AITB.updateDate AS 'Update Date - History',
AITB.ARCMAct AS 'Sales Credit Acct',
AITB.ARCMFrnAct AS 'Sales Credit Foreign Acct',
AITB.ARCMEUAct AS 'Sales Credit EU Acct',
AITB.ARCMExpAct AS 'Exempted Credits',
AITB.APCMAct AS 'Purchase Credit Acct',
AITB.APCMFrnAct AS 'Foreign Purchase Credit Acct',
AITB.APCMEUAct AS 'EU Purchase Credit Acct',
AITB.RevRetAct AS 'Revenue Returns Account',
AITB.ItemClass AS 'Service or Material',
AITB.OSvcCode AS 'Outgoing Service Code',
AITB.ISvcCode AS 'Incoming Service Code',
AITB.ServiceGrp AS 'Service Group',
AITB.NCMCode AS 'NCM Code',
AITB.MatType AS 'Material Type',
AITB.MatGrp AS 'Material Group',
AITB.ProductSrc AS 'Product Source',
AITB.NegStckAct AS 'Negative Inventory Adjustment',
AITB.StkInTnAct AS 'Stock In Transit Acct',
AITB.PurBalAct AS 'Purchase Balance Account',
AITB.WhICenAct AS 'Incoming CENVAT Account (WH)',
AITB.WhOCenAct AS 'Outgoing CENVAT Account (WH)',
AITB.WipOffset AS 'WIP Offset P&L Account',
AITB.StockOffst AS 'Inventory Offset P&L Account',
AITB.UgpEntry AS 'Default UoM Group Entry',
AITB.IUoMEntry AS 'Default Inventory UoM',
AITB.ToleranDay AS 'Tolerance Days',
AITB.RuleCode AS 'Checking Rule Code',
AITB.CompoWH AS 'Component Warehouse',
AITB.FreeChrgSA AS 'Free of Charge Sales Account',
AITB.FreeChrgPU AS 'Free of Charge Purchase Account'
FROM AITB AS AITB
Related information
G/L Accounts OACT SQL Table
Cycle OCYC SQL Table
Service Code Table OSCD SQL Table
UoM Master Data OUOM SQL Table
Material Group OMGP SQL Table
Material Type OMTP SQL Table
NCM Code ONCM SQL Table
Product Source Code OPSC SQL Table
Checking Rule ODCR SQL Table
Service Group for Brazil OSGP SQL Table
UoM Group OUGP SQL Table
Users OUSR SQL Table
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates