|
|
API AITW
AITW - Items - Warehouse - History Table
G/L Accounts OACT SQL Table
Bin Location OBIN SQL Table
Inventory Counting OINC SQL Table
Items OITM SQL Table
Users OUSR SQL Table
Warehouses OWHS SQL Table
SBO SQL database table details
| Field | Description | Type | Constraints | Size | Related | Default | Primary_Key | Unique | ItemCode KEY | Item No. | nVarChar | 20 | OITM Items | ITEM | No |
|---|---|---|---|---|---|---|---|---|
| WhsCode KEY | Warehouse Code | nVarChar | 8 | OWHS Warehouses | WHS | No | ||
| OnHand | In Stock | Num | 20 | |||||
| IsCommited | Defined | Num | 20 | |||||
| OnOrder | Ordered | Num | 20 | |||||
| Consig | Consignment Goods WH | Num | 20 | |||||
| Counted | Counted Quantity | Num | 20 | |||||
| WasCounted KEY | Counted Yes/No | VarChar | Y) Yes N) No | 1 | N | COUNTED | No | |
| UserSign | User Signature | Int | 6 | OUSR Users | ||||
| MinStock | Min. Stock | Num | 20 | |||||
| MaxStock | Max. Stock | Num | 20 | |||||
| MinOrder | Min. Order | Num | 20 | |||||
| AvgPrice | Average Price | Num | 20 | |||||
| Locked | Locked | VarChar | Y) Yes N) No | 1 | N | |||
| BalInvntAc | Inventory Acc. | nVarChar | 15 | OACT G/L Accounts | ||||
| SaleCostAc | Cost Acc. | nVarChar | 15 | OACT G/L Accounts | ||||
| TransferAc | Transfers Acc. | nVarChar | 15 | OACT G/L Accounts | ||||
| RevenuesAc | Revenues Acct | nVarChar | 15 | OACT G/L Accounts | ||||
| VarianceAc | Variance Acc. | nVarChar | 15 | OACT G/L Accounts | ||||
| DecreasAc | Inventory Offset - Decrease Account | nVarChar | 15 | OACT G/L Accounts | ||||
| IncreasAc | Inventory Offset - Increase Account | nVarChar | 15 | OACT G/L Accounts | ||||
| ReturnAc | Sales Returns | nVarChar | 15 | OACT G/L Accounts | ||||
| ExpensesAc | Expenses Acct. | nVarChar | 15 | OACT G/L Accounts | ||||
| EURevenuAc | Sales Revenue - EU | nVarChar | 15 | OACT G/L Accounts | ||||
| EUExpensAc | EU Expenses Acc. | nVarChar | 15 | OACT G/L Accounts | ||||
| FrRevenuAc | Sales Revenue - Foreign | nVarChar | 15 | OACT G/L Accounts | ||||
| FrExpensAc | Foreign Expenses Acc. | nVarChar | 15 | OACT G/L Accounts | ||||
| ExmptIncom | Exempt Revenues Account | nVarChar | 15 | OACT G/L Accounts | ||||
| PriceDifAc | Price Differences Acc. | nVarChar | 15 | |||||
| ExchangeAc | Exchange Rate Differences Acc. | nVarChar | 15 | |||||
| BalanceAcc | Goods Clearing Acc. | nVarChar | 15 | |||||
| PurchaseAc | Purchase Acc. | nVarChar | 15 | |||||
| PAReturnAc | PA Return Acc. | nVarChar | 15 | |||||
| PurchOfsAc | Purchase Offset Acc. | nVarChar | 15 | |||||
| ShpdGdsAct | Shipped Goods Account | nVarChar | 15 | |||||
| VatRevAct | VAT in Revenue Account | nVarChar | 15 | |||||
| StockValue | Stock Value | Num | 20 | |||||
| DecresGlAc | Decrease GL Acc. | nVarChar | 15 | |||||
| IncresGlAc | Increase GL Acc. | nVarChar | 15 | |||||
| StokRvlAct | Stock Inflation Adjust Account | nVarChar | 15 | |||||
| StkOffsAct | Stock Inflation Offset Account | nVarChar | 15 | |||||
| WipAcct | WIP Material Account | nVarChar | 15 | |||||
| WipVarAcct | WIP Material Variance Account | nVarChar | 15 | |||||
| CostRvlAct | Cost Inflation Account | nVarChar | 15 | |||||
| CstOffsAct | Cost Inflation Offset Account | nVarChar | 15 | |||||
| ExpClrAct | Expenses Clearing Account | nVarChar | 15 | OACT G/L Accounts | ||||
| ExpOfstAct | Expense Offsetting Account | nVarChar | 15 | OACT G/L Accounts | ||||
| Object | Object Type - History | nVarChar | 20 | 31 | ||||
| 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 | |||||
| ARCMFrnAct | Sales Credit Foreign Acct | nVarChar | 15 | |||||
| ARCMEUAct | Sales Credit EU Acct | nVarChar | 15 | |||||
| ARCMExpAct | Exempted Credits | nVarChar | 15 | |||||
| APCMAct | Purchase Credit Acct | nVarChar | 15 | |||||
| APCMFrnAct | Foreign Purchase Credit Acct | nVarChar | 15 | |||||
| APCMEUAct | EU Purchase Credit Acct | nVarChar | 15 | |||||
| RevRetAct | Revenue Returns Account | nVarChar | 15 | |||||
| NegStckAct | Negative Stock Adjustment Acct | nVarChar | 15 | OACT G/L Accounts | ||||
| StkInTnAct | Stock In Transit Acct | nVarChar | 15 | |||||
| PurBalAct | Purchase Balance Account | nVarChar | 15 | |||||
| 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 | ||||
| DftBinAbs | Default Bin Internal Number | Int | 11 | OBIN Bin Location | ||||
| DftBinEnfd | Default Bin Enforced [Y/N] | VarChar | Y) Yes N) No | 1 | N | |||
| Freezed | Item Frozen in Warehouse | VarChar | Y) Yes N) No | 1 | N | |||
| FreezeDoc | INC Document Frozen By | Int | 11 | OINC Inventory Counting | ||||
| FreeChrgSA | Free of Charge Sales Account | nVarChar | 15 | |||||
| FreeChrgPU | Free of Charge Purchase Account | nVarChar | 15 |
Table relationship map
SELECT statement
SELECT
AITW.ItemCode AS 'Item No.',
AITW.WhsCode AS 'Warehouse Code',
AITW.OnHand AS 'In Stock',
AITW.IsCommited AS 'Defined',
AITW.OnOrder AS 'Ordered',
AITW.Consig AS 'Consignment Goods WH',
AITW.Counted AS 'Counted Quantity',
AITW.WasCounted AS 'Counted Yes/No',
AITW.UserSign AS 'User Signature',
AITW.MinStock AS 'Min. Stock',
AITW.MaxStock AS 'Max. Stock',
AITW.MinOrder AS 'Min. Order',
AITW.AvgPrice AS 'Average Price',
AITW.Locked AS 'Locked',
AITW.BalInvntAc AS 'Inventory Acc.',
AITW.SaleCostAc AS 'Cost Acc.',
AITW.TransferAc AS 'Transfers Acc.',
AITW.RevenuesAc AS 'Revenues Acct',
AITW.VarianceAc AS 'Variance Acc.',
AITW.DecreasAc AS 'Inventory Offset - Decrease Account',
AITW.IncreasAc AS 'Inventory Offset - Increase Account',
AITW.ReturnAc AS 'Sales Returns',
AITW.ExpensesAc AS 'Expenses Acct.',
AITW.EURevenuAc AS 'Sales Revenue - EU',
AITW.EUExpensAc AS 'EU Expenses Acc.',
AITW.FrRevenuAc AS 'Sales Revenue - Foreign',
AITW.FrExpensAc AS 'Foreign Expenses Acc.',
AITW.ExmptIncom AS 'Exempt Revenues Account',
AITW.PriceDifAc AS 'Price Differences Acc.',
AITW.ExchangeAc AS 'Exchange Rate Differences Acc.',
AITW.BalanceAcc AS 'Goods Clearing Acc.',
AITW.PurchaseAc AS 'Purchase Acc.',
AITW.PAReturnAc AS 'PA Return Acc.',
AITW.PurchOfsAc AS 'Purchase Offset Acc.',
AITW.ShpdGdsAct AS 'Shipped Goods Account',
AITW.VatRevAct AS 'VAT in Revenue Account',
AITW.StockValue AS 'Stock Value',
AITW.DecresGlAc AS 'Decrease GL Acc.',
AITW.IncresGlAc AS 'Increase GL Acc.',
AITW.StokRvlAct AS 'Stock Inflation Adjust Account',
AITW.StkOffsAct AS 'Stock Inflation Offset Account',
AITW.WipAcct AS 'WIP Material Account',
AITW.WipVarAcct AS 'WIP Material Variance Account',
AITW.CostRvlAct AS 'Cost Inflation Account',
AITW.CstOffsAct AS 'Cost Inflation Offset Account',
AITW.ExpClrAct AS 'Expenses Clearing Account',
AITW.ExpOfstAct AS 'Expense Offsetting Account',
AITW.Object AS 'Object Type - History',
AITW.logInstanc AS 'Log Instance - History',
AITW.createDate AS 'Creation Date - History',
AITW.userSign2 AS 'Updating User - History',
AITW.updateDate AS 'Update Date - History',
AITW.ARCMAct AS 'Sales Credit Acct',
AITW.ARCMFrnAct AS 'Sales Credit Foreign Acct',
AITW.ARCMEUAct AS 'Sales Credit EU Acct',
AITW.ARCMExpAct AS 'Exempted Credits',
AITW.APCMAct AS 'Purchase Credit Acct',
AITW.APCMFrnAct AS 'Foreign Purchase Credit Acct',
AITW.APCMEUAct AS 'EU Purchase Credit Acct',
AITW.RevRetAct AS 'Revenue Returns Account',
AITW.NegStckAct AS 'Negative Stock Adjustment Acct',
AITW.StkInTnAct AS 'Stock In Transit Acct',
AITW.PurBalAct AS 'Purchase Balance Account',
AITW.WhICenAct AS 'Incoming CENVAT Account (WH)',
AITW.WhOCenAct AS 'Outgoing CENVAT Account (WH)',
AITW.WipOffset AS 'WIP Offset P&L Account',
AITW.StockOffst AS 'Inventory Offset P&L Account',
AITW.DftBinAbs AS 'Default Bin Internal Number',
AITW.DftBinEnfd AS 'Default Bin Enforced [Y/N]',
AITW.Freezed AS 'Item Frozen in Warehouse',
AITW.FreezeDoc AS 'INC Document Frozen By',
AITW.FreeChrgSA AS 'Free of Charge Sales Account',
AITW.FreeChrgPU AS 'Free of Charge Purchase Account'
FROM AITW AS AITW
Related information
G/L Accounts OACT SQL Table
Bin Location OBIN SQL Table
Inventory Counting OINC SQL Table
Items OITM SQL Table
Users OUSR 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
