|
|
DTW Administration / Setup / Inventory / Item Groups
API OITB / Item Groups
OITB - Item Groups Table
Item Groups ItemGroups Object· Table: OITB
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
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 Account | nVarChar | 15 | OACT G/L Accounts | ||||
| TransferAc | Allocation Account | 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 | ||||
| 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 Account | nVarChar | 15 | OACT G/L Accounts | ||||
| PurchaseAc | Purchase Account | nVarChar | 15 | OACT G/L Accounts | ||||
| PAReturnAc | Purchase Return Account | nVarChar | 15 | OACT G/L Accounts | ||||
| PurchOfsAc | Purchase Offset Account | 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 Account | nVarChar | 15 | OACT G/L Accounts | ||||
| IncresGlAc | G/L Increase Account | 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 Inventory Account | nVarChar | 15 | OACT G/L Accounts | ||||
| WipVarAcct | WIP Inventory Variance Account | nVarChar | 15 | OACT G/L Accounts | ||||
| CostRvlAct | COGS Revaluation Account | nVarChar | 15 | OACT G/L Accounts | ||||
| CstOffsAct | COGS Revaluation Offset Acct | nVarChar | 15 | OACT G/L Accounts | ||||
| 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 | 52 | ||||
| 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 | OACT G/L Accounts | ||||
| ARCMFrnAct | Sales Credit Account - Foreign | nVarChar | 15 | OACT G/L Accounts | ||||
| ARCMEUAct | Sales Credit Account - EU | nVarChar | 15 | OACT G/L Accounts | ||||
| ARCMExpAct | Tax Exempt Credit Account | nVarChar | 15 | OACT G/L Accounts | ||||
| APCMAct | Purchase Credit Account | nVarChar | 15 | OACT G/L Accounts | ||||
| APCMFrnAct | Purchase Credit Account - Foreign | nVarChar | 15 | OACT G/L Accounts | ||||
| APCMEUAct | Purchase Credit Account - EU | 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 Acct | nVarChar | 15 | OACT G/L Accounts | ||||
| StkInTnAct | Stock In Transit Account | 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 | OACT G/L Accounts | ||||
| FreeChrgPU | Free of Charge Purchase Account | nVarChar | 15 | OACT 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
ItemGroups
Method
Object
Property
Alert
DTW DB
CostAccount
DTW DB
CostInflationAccount
DTW DB
CostInflationOffsetAccount
DTW DB
CycleCode
DTW DB
DecreaseGLAccount
DTW DB
DecreasingAccount
DTW DB
EUExpensesAccount
DTW DB
EUPurchaseCreditAcc
DTW DB
EURevenuesAccount
DTW DB
ExemptedCredits
DTW DB
ExemptRevenuesAccount
DTW DB
ExpenseClearingAct
DTW DB
ExpenseOffsetAccount
DTW DB
ExpensesAccount
DTW DB
ForeignExpensesAccount
DTW DB
ForeignPurchaseCreditAcc
DTW DB
ForeignRevenuesAccount
DTW DB
GoodsClearingAccount
DTW DB
GroupName
DTW DB
IncreaseGLAccount
DTW DB
IncreasingAccount
DTW DB
InventoryAccount
DTW DB
InventorySystem
DTW DB
LeadTime
DTW DB
MinimumOrderQuantity
DTW DB
Number
DTW DB
OrderInterval
DTW DB
OrderMultiple
DTW DB
PAReturnAccount
DTW DB
PlanningSystem
DTW DB
PriceDifferencesAccount
DTW DB
ProcurementMethod
DTW DB
PurchaseAccount
DTW DB
PurchaseCreditAcc
DTW DB
PurchaseOffsetAccount
DTW DB
ReturningAccount
DTW DB
RevenuesAccount
DTW DB
SalesCreditAcc
DTW DB
SalesCreditEUAcc
DTW DB
SalesCreditForeignAcc
DTW DB
ShippedGoodsAccount
DTW DB
StockInflationAdjustAccount
DTW DB
StockInflationOffsetAccount
DTW DB
StockInTransitAccount
DTW DB
TransfersAccount
DTW DB
VarianceAccount
DTW DB
VATInRevenueAccount
DTW DB
WHIncomingCenvatAccount
DTW DB
WHOutgoingCenvatAccount
DTW DB
WIPMaterialAccount
DTW DB
WIPMaterialVarianceAccount
DTW DB
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates
