biuan SAP® BUSINESS ONE SDK
API SITW
SITW - Items - Warehouse Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
ItemCode KEY UNIQUEItem No.nVarChar
20OITM
Items
PRIMARYYes
WhsCode KEYWarehouse CodenVarChar
8OWHS
Warehouses
WHSNo
OnHandIn StockNum
20
IsCommitedDefinedNum
20
OnOrderOrderedNum
20
ConsigConsignment Goods WhseNum
20
CountedCounted QuantityNum
20
WasCountedCounted Yes/NoVarChar
Y) Yes
N) No
1
N
UserSignUser SignatureInt
6OUSR
Users
MinStockMinimum InventoryNum
20
MaxStockMaximum InventoryNum
20
MinOrderMin. OrderNum
20
AvgPriceAverage PriceNum
20
LockedLockedVarChar
Y) Yes
N) No
1
N
BalInvntAcInventory AccountnVarChar
15OACT
G/L Accounts
SaleCostAcCost of Goods Sold AccountnVarChar
15OACT
G/L Accounts
TransferAcTransfer AcctnVarChar
15OACT
G/L Accounts
RevenuesAcRevenue AccountnVarChar
15OACT
G/L Accounts
VarianceAcVariance AccountnVarChar
15OACT
G/L Accounts
DecreasAcInventory Offset - Decrease AccountnVarChar
15OACT
G/L Accounts
IncreasAcInventory Offset - Increase AccountnVarChar
15OACT
G/L Accounts
ReturnAcSales Returns AccountnVarChar
15OACT
G/L Accounts
ExpensesAcExpense AccountnVarChar
15OACT
G/L Accounts
EURevenuAcRevenue Account - EUnVarChar
15OACT
G/L Accounts
EUExpensAcExpense Account - EUnVarChar
15OACT
G/L Accounts
FrRevenuAcRevenue Account - ForeignnVarChar
15OACT
G/L Accounts
FrExpensAcExpense Account - ForeignnVarChar
15OACT
G/L Accounts
ExmptIncomExempt Revenue AccountnVarChar
15OACT
G/L Accounts
PriceDifAcPrice Differences AccountnVarChar
15
ExchangeAcExchange Rate Differences AccountnVarChar
15
BalanceAccGoods Clearing AccountnVarChar
15
PurchaseAcPurchase AccountnVarChar
15
PAReturnAcPurchase Return AccountnVarChar
15
PurchOfsAcPurchase Offset AccountnVarChar
15
ShpdGdsActShipped Goods AccountnVarChar
15
VatRevActVAT in Revenue AccountnVarChar
15
StockValueInventory ValueNum
20
DecresGlAcG/L Decrease AccountnVarChar
15
IncresGlAcG/L Increase AccountnVarChar
15
StokRvlActStock Inflation Adjust AccountnVarChar
15
StkOffsActStock Inflation Offset AccountnVarChar
15
WipAcctWIP Inventory AccountnVarChar
15
WipVarAcctWIP Inventory Variance AccountnVarChar
15
CostRvlActCost Inflation AccountnVarChar
15
CstOffsActCost Inflation Offset AccountnVarChar
15
ExpClrActExpense Clearing AccountnVarChar
15OACT
G/L Accounts
ExpOfstActExpense Offset AccountnVarChar
15OACT
G/L Accounts
ObjectObject Type - HistorynVarChar
20
31
logInstancLog Instance - HistoryInt
11
createDateCreation Date - HistoryDate
8
userSign2Updating User - HistoryInt
6OUSR
Users
updateDateDate of Update - HistoryDate
8
ARCMActSales Credit AccountnVarChar
15
ARCMFrnActSales Credit Account - ForeignnVarChar
15
ARCMEUActSales Credit Account - EUnVarChar
15
ARCMExpActTax Exempt Credit AccountnVarChar
15
APCMActPurchase Credit AccountnVarChar
15
APCMFrnActPurchase Credit Account - ForeignnVarChar
15
APCMEUActPurchase Credit Account - EUnVarChar
15
RevRetActRevenue Returns AccountnVarChar
15
NegStckActNegative Inventory Adj. AcctnVarChar
15OACT
G/L Accounts
StkInTnActStock In Transit AccountnVarChar
15
PurBalActPurchase Balance AccountnVarChar
15
WhICenActIncoming CENVAT Account (WH)nVarChar
15OACT
G/L Accounts
WhOCenActOutgoing CENVAT Account (WH)nVarChar
15OACT
G/L Accounts
WipOffsetWIP Offset P&L AccountnVarChar
15OACT
G/L Accounts
StockOffstInventory Offset P&L AccountnVarChar
15OACT
G/L Accounts
DftBinAbsDefault Bin Internal NumberInt
11OBIN
Bin Location
DftBinEnfdDefault Bin Enforced [Y/N]VarChar
Y) Yes
N) No
1
N
FreezedItem Frozen in WarehouseVarChar
Y) Yes
N) No
1
N
FreezeDocINC Document Frozen ByInt
11OINC
Inventory Counting
FreeChrgSAFree of Charge Sales AccountnVarChar
15
FreeChrgPUFree of Charge Purchase AccountnVarChar
15

Table relationship map

SELECT statement

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

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



SAP® Business One is the trademark(s) or registered trademark(s) of SAP AG in Germany and in several other countries. Icons by Icons8 Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates