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