biuan SAP® BUSINESS ONE SDK
DTW Administration / Setup / Inventory / Item Groups
API OITB / / Item Groups
OITB - Item Groups Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
ItmsGrpCod KEY UNIQUENumberInt
6
PRIMARYYes
ItmsGrpNam KEY UNIQUEGroup NamenVarChar
20
GROUP_NAMEYes
LockedLockedVarChar
N) Changeable
Y) Locked
1
N
DataSourceData SourceVarChar
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
UserSignUser SignatureInt
6OUSR
Users
BalInvntAcInventory AccountnVarChar
15OACT
G/L Accounts
SaleCostAcCost of Goods Sold AccountnVarChar
15OACT
G/L Accounts
TransferAcAllocation AccountnVarChar
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
CycleCodeCycle CodeInt
6OCYC
Cycle
AlertAlertVarChar
N) No
Y) Yes
1
N
PriceDifAcPrice Difference AccountnVarChar
15OACT
G/L Accounts
ExchangeAcExchange Rate Differences AccountnVarChar
15OACT
G/L Accounts
BalanceAccGoods Clearing AccountnVarChar
15OACT
G/L Accounts
PurchaseAcPurchase AccountnVarChar
15OACT
G/L Accounts
PAReturnAcPurchase Return AccountnVarChar
15OACT
G/L Accounts
PurchOfsAcPurchase Offset AccountnVarChar
15OACT
G/L Accounts
ShpdGdsActShipped Goods AccountnVarChar
15OACT
G/L Accounts
VatRevActVAT in Revenue AccountnVarChar
15OACT
G/L Accounts
DecresGlAcG/L Decrease AccountnVarChar
15OACT
G/L Accounts
IncresGlAcG/L Increase AccountnVarChar
15OACT
G/L Accounts
InvntSysInventory SystemVarChar
A) Moving Average
S) Standard
F) FIFO
1
PlaningSysPlanning MethodVarChar
M) MRP
N) None
1
N
PrcrmntMtdProcurement MethodVarChar
B) Buy
M) Make
1
B
OrdrIntrvlOrder IntervalInt
6OCYC
Cycle
OrdrMultiOrder MultipleNum
20
MinOrdrQtyMinimum Order QuantityNum
20
LeadTimeLead TimeInt
11
StokRvlActInventory Revaluation AccountnVarChar
15OACT
G/L Accounts
StkOffsActInventory Revaluation Offset AccountnVarChar
15OACT
G/L Accounts
WipAcctWIP Inventory AccountnVarChar
15OACT
G/L Accounts
WipVarAcctWIP Inventory Variance AccountnVarChar
15OACT
G/L Accounts
CostRvlActCOGS Revaluation AccountnVarChar
15OACT
G/L Accounts
CstOffsActCOGS Revaluation Offset AcctnVarChar
15OACT
G/L Accounts
ExpClrActExpense Clearing AccountnVarChar
15OACT
G/L Accounts
ExpOfstActExpense Offset AccountnVarChar
15OACT
G/L Accounts
ObjectObject Type - HistorynVarChar
20
52
logInstancLog Instance - HistoryInt
11
createDateCreation Date - HistoryDate
8
userSign2Updating User - HistoryInt
6OUSR
Users
updateDateDate of Update - HistoryDate
8
ARCMActSales Credit AccountnVarChar
15OACT
G/L Accounts
ARCMFrnActSales Credit Account - ForeignnVarChar
15OACT
G/L Accounts
ARCMEUActSales Credit Account - EUnVarChar
15OACT
G/L Accounts
ARCMExpActTax Exempt Credit AccountnVarChar
15OACT
G/L Accounts
APCMActPurchase Credit AccountnVarChar
15OACT
G/L Accounts
APCMFrnActPurchase Credit Account - ForeignnVarChar
15OACT
G/L Accounts
APCMEUActPurchase Credit Account - EUnVarChar
15OACT
G/L Accounts
RevRetActRevenue Returns AccountnVarChar
15OACT
G/L Accounts
ItemClassService or MaterialVarChar
1) Service
2) Material
1
2
OSvcCodeOutgoing Service CodeInt
11OSCD
Service Code Table
-1
ISvcCodeIncoming Service CodeInt
11OSCD
Service Code Table
-1
ServiceGrpService GroupInt
11OSGP
Service Group for Brazil
-1
NCMCodeNCM CodeInt
11ONCM
NCM Code
-1
MatTypeMaterial TypenVarChar
3OMTP
Material Type
1
MatGrpMaterial GroupInt
11OMGP
Material Group
-1
ProductSrcProduct SourcenVarChar
2OPSC
Product Source Code
0
NegStckActNegative Inventory Adjustment AcctnVarChar
15OACT
G/L Accounts
StkInTnActStock In Transit AccountnVarChar
15OACT
G/L Accounts
PurBalActPurchase Balance AccountnVarChar
15OACT
G/L Accounts
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
UgpEntryDefault UoM Group EntryInt
11OUGP
UoM Group
IUoMEntryDefault Inventory UoMInt
11OUOM
UoM Master Data
ToleranDayTolerance DaysInt
11
RuleCodeChecking Rule CodenVarChar
2ODCR
Checking Rule
CompoWHComponent WarehouseVarChar
B) From Bill of Materials Line
P) From Parent Item Document Line
1
B
FreeChrgSAFree of Charge Sales AccountnVarChar
15OACT
G/L Accounts
FreeChrgPUFree of Charge Purchase AccountnVarChar
15OACT
G/L Accounts

Table relationship map

SELECT statement

SELECT OITB.ItmsGrpCod AS 'Number', OITB.ItmsGrpNam AS 'Group Name', OITB.Locked AS 'Locked', OITB.DataSource AS 'Data Source', OITB.UserSign AS 'User Signature', OITB.BalInvntAc AS 'Inventory Account', OITB.SaleCostAc AS 'Cost of Goods Sold Account', OITB.TransferAc AS 'Allocation Account', OITB.RevenuesAc AS 'Revenue Account', OITB.VarianceAc AS 'Variance Account', OITB.DecreasAc AS 'Inventory Offset - Decrease Account', OITB.IncreasAc AS 'Inventory Offset - Increase Account', OITB.ReturnAc AS 'Sales Returns Account', OITB.ExpensesAc AS 'Expense Account', OITB.EURevenuAc AS 'Revenue Account - EU', OITB.EUExpensAc AS 'Expense Account - EU', OITB.FrRevenuAc AS 'Revenue Account - Foreign', OITB.FrExpensAc AS 'Expense Account - Foreign', OITB.ExmptIncom AS 'Exempt Revenue Account', OITB.CycleCode AS 'Cycle Code', OITB.Alert AS 'Alert', OITB.PriceDifAc AS 'Price Difference Account', OITB.ExchangeAc AS 'Exchange Rate Differences Account', OITB.BalanceAcc AS 'Goods Clearing Account', OITB.PurchaseAc AS 'Purchase Account', OITB.PAReturnAc AS 'Purchase Return Account', OITB.PurchOfsAc AS 'Purchase Offset Account', OITB.ShpdGdsAct AS 'Shipped Goods Account', OITB.VatRevAct AS 'VAT in Revenue Account', OITB.DecresGlAc AS 'G/L Decrease Account', OITB.IncresGlAc AS 'G/L Increase Account', OITB.InvntSys AS 'Inventory System', OITB.PlaningSys AS 'Planning Method', OITB.PrcrmntMtd AS 'Procurement Method', OITB.OrdrIntrvl AS 'Order Interval', OITB.OrdrMulti AS 'Order Multiple', OITB.MinOrdrQty AS 'Minimum Order Quantity', OITB.LeadTime AS 'Lead Time', OITB.StokRvlAct AS 'Inventory Revaluation Account', OITB.StkOffsAct AS 'Inventory Revaluation Offset Account', OITB.WipAcct AS 'WIP Inventory Account', OITB.WipVarAcct AS 'WIP Inventory Variance Account', OITB.CostRvlAct AS 'COGS Revaluation Account', OITB.CstOffsAct AS 'COGS Revaluation Offset Acct', OITB.ExpClrAct AS 'Expense Clearing Account', OITB.ExpOfstAct AS 'Expense Offset Account', OITB.Object AS 'Object Type - History', OITB.logInstanc AS 'Log Instance - History', OITB.createDate AS 'Creation Date - History', OITB.userSign2 AS 'Updating User - History', OITB.updateDate AS 'Date of Update - History', OITB.ARCMAct AS 'Sales Credit Account', OITB.ARCMFrnAct AS 'Sales Credit Account - Foreign', OITB.ARCMEUAct AS 'Sales Credit Account - EU', OITB.ARCMExpAct AS 'Tax Exempt Credit Account', OITB.APCMAct AS 'Purchase Credit Account', OITB.APCMFrnAct AS 'Purchase Credit Account - Foreign', OITB.APCMEUAct AS 'Purchase Credit Account - EU', OITB.RevRetAct AS 'Revenue Returns Account', OITB.ItemClass AS 'Service or Material', OITB.OSvcCode AS 'Outgoing Service Code', OITB.ISvcCode AS 'Incoming Service Code', OITB.ServiceGrp AS 'Service Group', OITB.NCMCode AS 'NCM Code', OITB.MatType AS 'Material Type', OITB.MatGrp AS 'Material Group', OITB.ProductSrc AS 'Product Source', OITB.NegStckAct AS 'Negative Inventory Adjustment Acct', OITB.StkInTnAct AS 'Stock In Transit Account', OITB.PurBalAct AS 'Purchase Balance Account', OITB.WhICenAct AS 'Incoming CENVAT Account (WH)', OITB.WhOCenAct AS 'Outgoing CENVAT Account (WH)', OITB.WipOffset AS 'WIP Offset P&L Account', OITB.StockOffst AS 'Inventory Offset P&L Account', OITB.UgpEntry AS 'Default UoM Group Entry', OITB.IUoMEntry AS 'Default Inventory UoM', OITB.ToleranDay AS 'Tolerance Days', OITB.RuleCode AS 'Checking Rule Code', OITB.CompoWH AS 'Component Warehouse', OITB.FreeChrgSA AS 'Free of Charge Sales Account', OITB.FreeChrgPU AS 'Free of Charge Purchase Account' FROM OITB AS OITB

Related information


Item Groups ItemGroups Object· Table: OITB
ItemGroups is a business object that represents the item groups definition in the Inventory and Production module. This object enables you to: Add an item group. Retrieve an item group by its key. Update an item group details. Remove an...

OITB SQL 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



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