biuan SAP® BUSINESS ONE SDK
API SITM
SITM - Items Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
ItemCode KEY UNIQUEItem No.nVarChar
20
PRIMARYYes
ItemName KEYItem DescriptionnVarChar
100
ITEM_NAMENo
FrgnNameDescription in Foreign Lang.nVarChar
100
ItmsGrpCodItem GroupInt
6OITB
Item Groups
100
CstGrpCodeCustoms GroupInt
6OARG
Customs Groups
-1
VatGourpSaSales Tax DefinitionnVarChar
8OVTG
Tax Definition
CodeBarsBar CodenVarChar
127
VATLiableTax DefinitionVarChar
Y) Yes
N) No
1
Y
PrchseItem KEYPurchase Item [Yes/No]VarChar
Y) Yes
N) No
1
YPURCHASENo
SellItem KEYSales Item [Yes/No]VarChar
Y) Yes
N) No
1
YSALENo
InvntItem KEYInventory Item [Yes/No]VarChar
Y) Yes
N) No
1
YINVENTORYNo
OnHandIn StockNum
20
IsCommitedQty Ordered by CustomersNum
20
OnOrderQty Ordered from VendorsNum
20
IncomeAcctRevenue AccountnVarChar
15OACT
G/L Accounts
ExmptIncomExempt Revenue AccountnVarChar
15OACT
G/L Accounts
MaxLevelMaximum Inventory LevelNum
20
DfltWHDefault WarehousenVarChar
8
CardCodePreferred VendornVarChar
15OCRD
Business Partner
SuppCatNumMfr Catalog No.nVarChar
17
BuyUnitMsrPurchasing UoMnVarChar
100
NumInBuyNo. of Items per Purchase UnitNum
20
ReorderQtyPref. Qty in Purchase UnitsNum
20
MinLevelMinimum Inventory LevelNum
20
LstEvlPricLast Evaluated PriceNum
20
LstEvlDateDate of Last Reval. PriceDate
8
CustomPerCustoms RateNum
20
CanceledCanceled Item [Yes/No]VarChar
Y) Yes
N) No
1
N
MnufctTimeProduction Date in DaysInt
11
WholSlsTaxTax Rate for WholesalerVarChar
1
RetilrTaxSales Tax in %VarChar
1
SpcialDiscSpecial Discount %Num
20
DscountCodDiscount CodeInt
6
TrackSalesFollow-Up [Yes/No]VarChar
Y) Yes
N) No
1
N
SalUnitMsrSales UoMnVarChar
100
NumInSaleNo. of Items per Sales UnitNum
20
ConsigConsignment Goods WhseNum
20
QueryGroupPropertiesInt
11
0
CountedQuantity Counted in InventoryNum
20
OpenBlncInitial StockNum
20
EvalSystemValuation MethodVarChar
A) Moving Average
S) Standard
F) FIFO
B) Serial/Batch
1
UserSignUser SignatureInt
6OUSR
Users
FREEFree [Yes/No]VarChar
Y) Yes
N) No
1
N
PicturNamePicturenVarChar
127
TransferedYear Transfer [Y/N]VarChar
Y) Yes
N) No
1
N
BlncTrnsfrBalances transferred [Yes/No]VarChar
Y) Yes
N) No
1
N
UserTextItem RemarksText
16
SerialNumSerial NumbernVarChar
17
CommisPcnt% Commission for ItemNum
20
CommisSumTotal Commission for ItemNum
20
CommisGrp KEYCommission GroupInt
6OCOG
Commission Groups
0COM_GROUPNo
TreeType KEYBOM TypeVarChar
N) Not a BOM
A) Assembly
S) Sales
P) Production
T) Template
1
NTREE_TYPENo
TreeQtyNo. of UnitsNum
20
LastPurPrcLast Purchase PriceNum
20
LastPurCurLast Purchase CurrencynVarChar
3
LastPurDatLast Purchase DateDate
8
ExitCurIssue CurrencynVarChar
3
ExitPriceIssue PriceNum
20
ExitWHRelease WarehousenVarChar
8
AssetItemFixed AssetsVarChar
Y) Yes
N) No
1
N
WasCountedCountedVarChar
Y) Yes
N) No
1
N
ManSerNumSerial No. ManagementVarChar
Y) Yes
N) No
1
N
SHeight1Height 1 - Sales UnitNum
20
SHght1UnitHeight 1 - UoM for SalesInt
6
SHeight2Height 2 - Sales UnitNum
20
SHght2UnitHeight 2 - UoM for SalesInt
6
SWidth1Width 1 - Sales UnitNum
20
SWdth1UnitWidth 1 - UoM for SalesInt
6
SWidth2Width 2 - Sales UnitNum
20
SWdth2UnitWidth 2 - UoM for SalesInt
6
SLength1Length 1 - Sales UnitNum
20
SLen1UnitLength 1 - UoM for SalesInt
6
Slength2Length 2 - Sales UnitNum
20
SLen2UnitLength 2 - UoM for SalesInt
6
SVolumeVolume - Sales UnitNum
20
SVolUnitVolume - UoM for SalesInt
6
SWeight1Weight 1 - Sales UnitNum
20
SWght1UnitWeight 1 - UoM for SalesInt
6
SWeight2Weight 2 - Sales UnitNum
20
SWght2UnitWeight 2 - UoM for SalesInt
6
BHeight1Height 1 - Purchasing UnitNum
20
BHght1UnitHeight 1 - UoM for PurchasingInt
6
BHeight2Height 2 - Purchasing UnitNum
20
BHght2UnitHeight 2 - UoM for PurchasingInt
6
BWidth1Width 1 - Purchasing UnitNum
20
BWdth1UnitWidth 1 - UoM for PurchasingInt
6
BWidth2Width 2 - Purchasing UnitNum
20
BWdth2UnitWidth 2 - UoM for PurchasingInt
6
BLength1Length 1 - Purchase UnitNum
20
BLen1UnitLength 1 - UoM for PurchasingInt
6
Blength2Length 2 - Purchase UnitNum
20
BLen2UnitLength 2 - UoM for PurchasingInt
6
BVolumeQuantity - Purchasing UnitNum
20
BVolUnitVolume - UoM for PurchasingInt
6
BWeight1Weight 1 - Purchasing UnitNum
20
BWght1UnitWeight 1 - UoM for PurchasingInt
6
BWeight2Weight 2 - Purchasing UnitNum
20
BWght2UnitWeight 2 - UoM for PurchasingInt
6
FixCurrCmsCurrency of Fixed CommissionnVarChar
3
FirmCodeManufacturerInt
6OMRC
Manufacturers
-1
LstSalDateLast Sale DateDate
8
QryGroup1Property 1VarChar
Y) Yes
N) No
1
N
QryGroup2Property 2VarChar
Y) Yes
N) No
1
N
QryGroup3Property 3VarChar
Y) Yes
N) No
1
N
QryGroup4Property 4VarChar
Y) Yes
N) No
1
N
QryGroup5Property 5VarChar
Y) Yes
N) No
1
N
QryGroup6Property 6VarChar
Y) Yes
N) No
1
N
QryGroup7Property 7VarChar
Y) Yes
N) No
1
N
QryGroup8Property 8VarChar
Y) Yes
N) No
1
N
QryGroup9Property 9VarChar
Y) Yes
N) No
1
N
QryGroup10Property 10VarChar
Y) Yes
N) No
1
N
QryGroup11Property 11VarChar
Y) Yes
N) No
1
N
QryGroup12Property 12VarChar
Y) Yes
N) No
1
N
QryGroup13Property 13VarChar
Y) Yes
N) No
1
N
QryGroup14Property 14VarChar
Y) Yes
N) No
1
N
QryGroup15Property 15VarChar
Y) Yes
N) No
1
N
QryGroup16Property 16VarChar
Y) Yes
N) No
1
N
QryGroup17Property 17VarChar
Y) Yes
N) No
1
N
QryGroup18Property 18VarChar
Y) Yes
N) No
1
N
QryGroup19Property 19VarChar
Y) Yes
N) No
1
N
QryGroup20Property 20VarChar
Y) Yes
N) No
1
N
QryGroup21Property 21VarChar
Y) Yes
N) No
1
N
QryGroup22Property 22VarChar
Y) Yes
N) No
1
N
QryGroup23Property 23VarChar
Y) Yes
N) No
1
N
QryGroup24Property 24VarChar
Y) Yes
N) No
1
N
QryGroup25Property 25VarChar
Y) Yes
N) No
1
N
QryGroup26Property 26VarChar
Y) Yes
N) No
1
N
QryGroup27Property 27VarChar
Y) Yes
N) No
1
N
QryGroup28Property 28VarChar
Y) Yes
N) No
1
N
QryGroup29Property 29VarChar
Y) Yes
N) No
1
N
QryGroup30Property 30VarChar
Y) Yes
N) No
1
N
QryGroup31Property 31VarChar
Y) Yes
N) No
1
N
QryGroup32Property 32VarChar
Y) Yes
N) No
1
N
QryGroup33Property 33VarChar
Y) Yes
N) No
1
N
QryGroup34Property 34VarChar
Y) Yes
N) No
1
N
QryGroup35Property 35VarChar
Y) Yes
N) No
1
N
QryGroup36Property 36VarChar
Y) Yes
N) No
1
N
QryGroup37Property 37VarChar
Y) Yes
N) No
1
N
QryGroup38Property 38VarChar
Y) Yes
N) No
1
N
QryGroup39Property 39VarChar
Y) Yes
N) No
1
N
QryGroup40Property 40VarChar
Y) Yes
N) No
1
N
QryGroup41Property 41VarChar
Y) Yes
N) No
1
N
QryGroup42Property 42VarChar
Y) Yes
N) No
1
N
QryGroup43Property 43VarChar
Y) Yes
N) No
1
N
QryGroup44Property 44VarChar
Y) Yes
N) No
1
N
QryGroup45Property 45VarChar
Y) Yes
N) No
1
N
QryGroup46Property 46VarChar
Y) Yes
N) No
1
N
QryGroup47Property 47VarChar
Y) Yes
N) No
1
N
QryGroup48Property 48VarChar
Y) Yes
N) No
1
N
QryGroup49Property 49VarChar
Y) Yes
N) No
1
N
QryGroup50Property 50VarChar
Y) Yes
N) No
1
N
QryGroup51Property 51VarChar
Y) Yes
N) No
1
N
QryGroup52Property 52VarChar
Y) Yes
N) No
1
N
QryGroup53Property 53VarChar
Y) Yes
N) No
1
N
QryGroup54Property 54VarChar
Y) Yes
N) No
1
N
QryGroup55Property 55VarChar
Y) Yes
N) No
1
N
QryGroup56Property 56VarChar
Y) Yes
N) No
1
N
QryGroup57Property 57VarChar
Y) Yes
N) No
1
N
QryGroup58Property 58VarChar
Y) Yes
N) No
1
N
QryGroup59Property 59VarChar
Y) Yes
N) No
1
N
QryGroup60Property 60VarChar
Y) Yes
N) No
1
N
QryGroup61Property 61VarChar
Y) Yes
N) No
1
N
QryGroup62Property 62VarChar
Y) Yes
N) No
1
N
QryGroup63Property 63VarChar
Y) Yes
N) No
1
N
QryGroup64Property 64VarChar
Y) Yes
N) No
1
N
CreateDateProduction DateDate
8
UpdateDateDate of UpdateDate
8
ExportCodeData Export CodenVarChar
20
SalFactor1Sales Factor 1Num
20
SalFactor2Sales Factor 2Num
20
SalFactor3Sales Factor 3Num
20
SalFactor4Sales Factor 4Num
20
PurFactor1Purchasing Factor 1Num
20
PurFactor2Purchasing Factor 2Num
20
PurFactor3Purchasing Factor 3Num
20
PurFactor4Purchasing Factor 4Num
20
SalFormulaSales FormulanVarChar
40
PurFormulaPurchasing FormulanVarChar
40
VatGroupPuPurchase Tax DefinitionnVarChar
8OVTG
Tax Definition
AvgPriceItem CostNum
20
PurPackMsrPackaging UoM (Purchasing)nVarChar
30
PurPackUnQty per Packaging (Purchasing)Num
20
SalPackMsrPackaging UoM (Sales)nVarChar
30
SalPackUnQty per Packaging (Sales)Num
20
SCNCounterSCN CounterInt
6
ManBtchNumManage Batch No. [Yes/No]VarChar
Y) Yes
N) No
1
N
ManOutOnlyManage SN Only on ExitVarChar
Y) Yes
N) No
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
G) Fixed Assets Migration
1
N
validForActiveVarChar
Y) Yes
N) No
1
N
validFromActive FromDate
8
validToActive ToDate
8
frozenForInactiveVarChar
Y) Yes
N) No
1
N
frozenFromInactive FromDate
8
frozenToInactive ToDate
8
BlockOutForce selection of serial no.VarChar
Y) Yes
N) No
1
Y
ValidCommActive RemarksnVarChar
30
FrozenCommInactive RemarksnVarChar
30
LogInstancLog InstanceInt
11
0
ObjTypeObject TypenVarChar
20ADP1
Object Settings - History
4
SWWAdditional IdentifiernVarChar
16
DeletedDeletedVarChar
Y) Yes
N) No
1
N
DocEntryInternal NumberInt
11
ExpensAcctExpense AccountnVarChar
15OACT
G/L Accounts
FrgnInAcctRevenue Account - ForeignnVarChar
15OACT
G/L Accounts
ShipTypeShipping TypeInt
6OSHP
Delivery Types
GLMethodSet G/L Account byVarChar
W) Warehouse
C) Item Group
L) Item Level
1
W
ECInAcctRevenue Account - EUnVarChar
15
FrgnExpAccExpense Account - ForeignnVarChar
15
ECExpAccExpense Account - EUnVarChar
15
TaxTypeTax TypeVarChar
Y) Regular Tax
U) Use Tax
N) No Tax
1
Y
ByWhInventory Management by WhseVarChar
1
WTLiableWTax LiableVarChar
Y) Yes
N) No
1
Y
ItemTypeItem TypeVarChar
I) Items
L) Labor
T) Travel
F) Fixed Assets
1
I
WarrntTmplWarranty TemplatenVarChar
20OCTT
Contract Template
BaseUnitBase Unit NamenVarChar
20
CountryOrgCountry of OriginnVarChar
3
StockValueInventory ValueNum
20
PhantomPhantom ItemVarChar
Y) Yes
N) No
1
N
IssueMthdIssue MethodVarChar
B) Backflush
M) Manual
1
FREE1Yield in %VarChar
1
PricingPrcPricing PercentageNum
20
MngMethodManagement MethodVarChar
A) On Every Transaction
R) On Release Only
1
R
ReorderPntReorder PointNum
20
InvntryUomInventory UoMnVarChar
100
PlaningSysPlanning MethodVarChar
M) MRP
N) None
1
N
PrcrmntMtdProcurement MethodVarChar
B) Buy
M) Make
1
B
OrdrIntrvlOrder IntervalsInt
6OCYC
Cycle
OrdrMultiOrder MultipleNum
20
MinOrdrQtyMinimum Order QuantityNum
20
LeadTimeLead TimeInt
11
IndirctTaxIndirect TaxVarChar
Y) Yes
N) No
1
N
TaxCodeARTax Code (A/R)nVarChar
8OSTC
Sales Tax Codes
TaxCodeAPTax Code (A/P)nVarChar
8OSTC
Sales Tax Codes
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
ServiceCtgService CategoryInt
-1)
11OSCG
Service Category
-1
ItemClassService or MaterialVarChar
2) Material
1) Service
1
2
ExcisableExcisable [Yes/No]VarChar
Y) Yes
N) No
1
N
ChapterIDChapter IDInt
11OCHP
India Chapter ID
-1
NotifyASNNotification Availed SN.nVarChar
40
ProAssNumProvisional Assessment No.nVarChar
20
AssblValueAssessable ValueNum
20
DNFEntryDNF Code EntryInt
11ODNF
DNF Code
-1
UserSign2Updating UserInt
6OUSR
Users
SpecItem SpecificationnVarChar
30
TaxCtgTax CategorynVarChar
4
SeriesSeriesInt
6NNM1
Documents Numbering - Series
NumberNumberInt
11
FuelCodeFuelInt
11OBFI
Brazil Fuel Indexer
-1
BeverTblCBeverage TablenVarChar
2OBSI
Brazil String Indexer
BeverGrpCBeverage GroupnVarChar
2OBSI
Brazil String Indexer
BeverTMBeverage BrandInt
11OBNI
Brazil Numeric Indexer
-1
AttachmentAttachmentText
16
AtcEntryAttachment EntryInt
11
ToleranDayTolerance DaysInt
11
UgpEntryUoM GroupInt
11OUGP
UoM Group
PUoMEntryDefault Purchase UoMInt
11OUOM
UoM Master Data
SUoMEntryDefault Sales UoMInt
11OUOM
UoM Master Data
IUoMEntryInventory UoMInt
11OUOM
UoM Master Data
IssuePriByIssue Primarily By SnB or BinInt
0
1) Issue Primarily by Bin Location
6
AssetClassAsset ClassnVarChar
20OACS
Asset Classes
AssetGroupAsset GroupnVarChar
15OAGS
Asset Groups
InventryNoInventory Number of AssetnVarChar
12
TechnicianTechnician of Fixed AssetInt
11OHEM
Employees
EmployeeEmployee of Fixed AssetInt
11OHEM
Employees
LocationLocationInt
11OLCT
Location
StatAssetOwned by CompanyVarChar
Y) Yes
N) No
1
N
CessionCessionVarChar
Y) Yes
N) No
1
N
DeacAftULDeactivate After Useful LifeVarChar
Y) Yes
N) No
1
N
AsstStatusAsset StatusVarChar
N) New
A) Active
I) Inactive
1
N
CapDateCapitalization DateDate
8
AcqDateAcquisition DateDate
8
RetDateRetirement DateDate
8
GLPickMethG/L Account Pick MethodVarChar
A) General
W) Warehouse
C) Item Group
1
A
NoDiscountNo DiscountsVarChar
Y) Yes
N) No
1
N
MgrByQtyManage Asset by QuantityVarChar
Y) Yes
N) No
1
N
AssetRmk1Asset Remark 1nVarChar
100
AssetRmk2Asset Remark 2nVarChar
100
AssetAmnt1Asset Amount 1Num
20
AssetAmnt2Asset Amount 2Num
20
DeprGroupDepreciation GroupnVarChar
15OADG
Depreciation Groups
AssetSerNoAsset Serial NumbernVarChar
32
CntUnitMsrInventory Counting UoM NamenVarChar
100
NumInCntNo. of Items per Counting UnitNum
20
INUoMEntryInventory Counting UoM EntryInt
11OUOM
UoM Master Data
OneBOneRecOne Batch One ReceiptVarChar
Y) Yes
N) No
1
N
RuleCodeChecking Rule CodenVarChar
2ODCR
Checking Rule
ScsCodeScs CodenVarChar
10
SpProdTypeSpecial Product TypenVarChar
MT) Cellular Phones
IO) Integrated Circuits
2
IWeight1Weight 1 - InventoryNum
20
IWght1UnitWeight 1 - Inventory UnitInt
6
IWeight2Weight 2 - InventoryNum
20
IWght2UnitWeight 2 - Inventory UnitInt
6
CompoWHComponent WarehouseVarChar
B) From Bill of Materials Line
P) From Parent Item Document Line
1
B

Table relationship map

SELECT statement

SELECT SITM.ItemCode AS 'Item No.', SITM.ItemName AS 'Item Description', SITM.FrgnName AS 'Description in Foreign Lang.', SITM.ItmsGrpCod AS 'Item Group', SITM.CstGrpCode AS 'Customs Group', SITM.VatGourpSa AS 'Sales Tax Definition', SITM.CodeBars AS 'Bar Code', SITM.VATLiable AS 'Tax Definition', SITM.PrchseItem AS 'Purchase Item [Yes/No]', SITM.SellItem AS 'Sales Item [Yes/No]', SITM.InvntItem AS 'Inventory Item [Yes/No]', SITM.OnHand AS 'In Stock', SITM.IsCommited AS 'Qty Ordered by Customers', SITM.OnOrder AS 'Qty Ordered from Vendors', SITM.IncomeAcct AS 'Revenue Account', SITM.ExmptIncom AS 'Exempt Revenue Account', SITM.MaxLevel AS 'Maximum Inventory Level', SITM.DfltWH AS 'Default Warehouse', SITM.CardCode AS 'Preferred Vendor', SITM.SuppCatNum AS 'Mfr Catalog No.', SITM.BuyUnitMsr AS 'Purchasing UoM', SITM.NumInBuy AS 'No. of Items per Purchase Unit', SITM.ReorderQty AS 'Pref. Qty in Purchase Units', SITM.MinLevel AS 'Minimum Inventory Level', SITM.LstEvlPric AS 'Last Evaluated Price', SITM.LstEvlDate AS 'Date of Last Reval. Price', SITM.CustomPer AS 'Customs Rate', SITM.Canceled AS 'Canceled Item [Yes/No]', SITM.MnufctTime AS 'Production Date in Days', SITM.WholSlsTax AS 'Tax Rate for Wholesaler', SITM.RetilrTax AS 'Sales Tax in %', SITM.SpcialDisc AS 'Special Discount %', SITM.DscountCod AS 'Discount Code', SITM.TrackSales AS 'Follow-Up [Yes/No]', SITM.SalUnitMsr AS 'Sales UoM', SITM.NumInSale AS 'No. of Items per Sales Unit', SITM.Consig AS 'Consignment Goods Whse', SITM.QueryGroup AS 'Properties', SITM.Counted AS 'Quantity Counted in Inventory', SITM.OpenBlnc AS 'Initial Stock', SITM.EvalSystem AS 'Valuation Method', SITM.UserSign AS 'User Signature', SITM.FREE AS 'Free [Yes/No]', SITM.PicturName AS 'Picture', SITM.Transfered AS 'Year Transfer [Y/N]', SITM.BlncTrnsfr AS 'Balances transferred [Yes/No]', SITM.UserText AS 'Item Remarks', SITM.SerialNum AS 'Serial Number', SITM.CommisPcnt AS '% Commission for Item', SITM.CommisSum AS 'Total Commission for Item', SITM.CommisGrp AS 'Commission Group', SITM.TreeType AS 'BOM Type', SITM.TreeQty AS 'No. of Units', SITM.LastPurPrc AS 'Last Purchase Price', SITM.LastPurCur AS 'Last Purchase Currency', SITM.LastPurDat AS 'Last Purchase Date', SITM.ExitCur AS 'Issue Currency', SITM.ExitPrice AS 'Issue Price', SITM.ExitWH AS 'Release Warehouse', SITM.AssetItem AS 'Fixed Assets', SITM.WasCounted AS 'Counted', SITM.ManSerNum AS 'Serial No. Management', SITM.SHeight1 AS 'Height 1 - Sales Unit', SITM.SHght1Unit AS 'Height 1 - UoM for Sales', SITM.SHeight2 AS 'Height 2 - Sales Unit', SITM.SHght2Unit AS 'Height 2 - UoM for Sales', SITM.SWidth1 AS 'Width 1 - Sales Unit', SITM.SWdth1Unit AS 'Width 1 - UoM for Sales', SITM.SWidth2 AS 'Width 2 - Sales Unit', SITM.SWdth2Unit AS 'Width 2 - UoM for Sales', SITM.SLength1 AS 'Length 1 - Sales Unit', SITM.SLen1Unit AS 'Length 1 - UoM for Sales', SITM.Slength2 AS 'Length 2 - Sales Unit', SITM.SLen2Unit AS 'Length 2 - UoM for Sales', SITM.SVolume AS 'Volume - Sales Unit', SITM.SVolUnit AS 'Volume - UoM for Sales', SITM.SWeight1 AS 'Weight 1 - Sales Unit', SITM.SWght1Unit AS 'Weight 1 - UoM for Sales', SITM.SWeight2 AS 'Weight 2 - Sales Unit', SITM.SWght2Unit AS 'Weight 2 - UoM for Sales', SITM.BHeight1 AS 'Height 1 - Purchasing Unit', SITM.BHght1Unit AS 'Height 1 - UoM for Purchasing', SITM.BHeight2 AS 'Height 2 - Purchasing Unit', SITM.BHght2Unit AS 'Height 2 - UoM for Purchasing', SITM.BWidth1 AS 'Width 1 - Purchasing Unit', SITM.BWdth1Unit AS 'Width 1 - UoM for Purchasing', SITM.BWidth2 AS 'Width 2 - Purchasing Unit', SITM.BWdth2Unit AS 'Width 2 - UoM for Purchasing', SITM.BLength1 AS 'Length 1 - Purchase Unit', SITM.BLen1Unit AS 'Length 1 - UoM for Purchasing', SITM.Blength2 AS 'Length 2 - Purchase Unit', SITM.BLen2Unit AS 'Length 2 - UoM for Purchasing', SITM.BVolume AS 'Quantity - Purchasing Unit', SITM.BVolUnit AS 'Volume - UoM for Purchasing', SITM.BWeight1 AS 'Weight 1 - Purchasing Unit', SITM.BWght1Unit AS 'Weight 1 - UoM for Purchasing', SITM.BWeight2 AS 'Weight 2 - Purchasing Unit', SITM.BWght2Unit AS 'Weight 2 - UoM for Purchasing', SITM.FixCurrCms AS 'Currency of Fixed Commission', SITM.FirmCode AS 'Manufacturer', SITM.LstSalDate AS 'Last Sale Date', SITM.QryGroup1 AS 'Property 1', SITM.QryGroup2 AS 'Property 2', SITM.QryGroup3 AS 'Property 3', SITM.QryGroup4 AS 'Property 4', SITM.QryGroup5 AS 'Property 5', SITM.QryGroup6 AS 'Property 6', SITM.QryGroup7 AS 'Property 7', SITM.QryGroup8 AS 'Property 8', SITM.QryGroup9 AS 'Property 9', SITM.QryGroup10 AS 'Property 10', SITM.QryGroup11 AS 'Property 11', SITM.QryGroup12 AS 'Property 12', SITM.QryGroup13 AS 'Property 13', SITM.QryGroup14 AS 'Property 14', SITM.QryGroup15 AS 'Property 15', SITM.QryGroup16 AS 'Property 16', SITM.QryGroup17 AS 'Property 17', SITM.QryGroup18 AS 'Property 18', SITM.QryGroup19 AS 'Property 19', SITM.QryGroup20 AS 'Property 20', SITM.QryGroup21 AS 'Property 21', SITM.QryGroup22 AS 'Property 22', SITM.QryGroup23 AS 'Property 23', SITM.QryGroup24 AS 'Property 24', SITM.QryGroup25 AS 'Property 25', SITM.QryGroup26 AS 'Property 26', SITM.QryGroup27 AS 'Property 27', SITM.QryGroup28 AS 'Property 28', SITM.QryGroup29 AS 'Property 29', SITM.QryGroup30 AS 'Property 30', SITM.QryGroup31 AS 'Property 31', SITM.QryGroup32 AS 'Property 32', SITM.QryGroup33 AS 'Property 33', SITM.QryGroup34 AS 'Property 34', SITM.QryGroup35 AS 'Property 35', SITM.QryGroup36 AS 'Property 36', SITM.QryGroup37 AS 'Property 37', SITM.QryGroup38 AS 'Property 38', SITM.QryGroup39 AS 'Property 39', SITM.QryGroup40 AS 'Property 40', SITM.QryGroup41 AS 'Property 41', SITM.QryGroup42 AS 'Property 42', SITM.QryGroup43 AS 'Property 43', SITM.QryGroup44 AS 'Property 44', SITM.QryGroup45 AS 'Property 45', SITM.QryGroup46 AS 'Property 46', SITM.QryGroup47 AS 'Property 47', SITM.QryGroup48 AS 'Property 48', SITM.QryGroup49 AS 'Property 49', SITM.QryGroup50 AS 'Property 50', SITM.QryGroup51 AS 'Property 51', SITM.QryGroup52 AS 'Property 52', SITM.QryGroup53 AS 'Property 53', SITM.QryGroup54 AS 'Property 54', SITM.QryGroup55 AS 'Property 55', SITM.QryGroup56 AS 'Property 56', SITM.QryGroup57 AS 'Property 57', SITM.QryGroup58 AS 'Property 58', SITM.QryGroup59 AS 'Property 59', SITM.QryGroup60 AS 'Property 60', SITM.QryGroup61 AS 'Property 61', SITM.QryGroup62 AS 'Property 62', SITM.QryGroup63 AS 'Property 63', SITM.QryGroup64 AS 'Property 64', SITM.CreateDate AS 'Production Date', SITM.UpdateDate AS 'Date of Update', SITM.ExportCode AS 'Data Export Code', SITM.SalFactor1 AS 'Sales Factor 1', SITM.SalFactor2 AS 'Sales Factor 2', SITM.SalFactor3 AS 'Sales Factor 3', SITM.SalFactor4 AS 'Sales Factor 4', SITM.PurFactor1 AS 'Purchasing Factor 1', SITM.PurFactor2 AS 'Purchasing Factor 2', SITM.PurFactor3 AS 'Purchasing Factor 3', SITM.PurFactor4 AS 'Purchasing Factor 4', SITM.SalFormula AS 'Sales Formula', SITM.PurFormula AS 'Purchasing Formula', SITM.VatGroupPu AS 'Purchase Tax Definition', SITM.AvgPrice AS 'Item Cost', SITM.PurPackMsr AS 'Packaging UoM (Purchasing)', SITM.PurPackUn AS 'Qty per Packaging (Purchasing)', SITM.SalPackMsr AS 'Packaging UoM (Sales)', SITM.SalPackUn AS 'Qty per Packaging (Sales)', SITM.SCNCounter AS 'SCN Counter', SITM.ManBtchNum AS 'Manage Batch No. [Yes/No]', SITM.ManOutOnly AS 'Manage SN Only on Exit', SITM.DataSource AS 'Data Source', SITM.validFor AS 'Active', SITM.validFrom AS 'Active From', SITM.validTo AS 'Active To', SITM.frozenFor AS 'Inactive', SITM.frozenFrom AS 'Inactive From', SITM.frozenTo AS 'Inactive To', SITM.BlockOut AS 'Force selection of serial no.', SITM.ValidComm AS 'Active Remarks', SITM.FrozenComm AS 'Inactive Remarks', SITM.LogInstanc AS 'Log Instance', SITM.ObjType AS 'Object Type', SITM.SWW AS 'Additional Identifier', SITM.Deleted AS 'Deleted', SITM.DocEntry AS 'Internal Number', SITM.ExpensAcct AS 'Expense Account', SITM.FrgnInAcct AS 'Revenue Account - Foreign', SITM.ShipType AS 'Shipping Type', SITM.GLMethod AS 'Set G/L Account by', SITM.ECInAcct AS 'Revenue Account - EU', SITM.FrgnExpAcc AS 'Expense Account - Foreign', SITM.ECExpAcc AS 'Expense Account - EU', SITM.TaxType AS 'Tax Type', SITM.ByWh AS 'Inventory Management by Whse', SITM.WTLiable AS 'WTax Liable', SITM.ItemType AS 'Item Type', SITM.WarrntTmpl AS 'Warranty Template', SITM.BaseUnit AS 'Base Unit Name', SITM.CountryOrg AS 'Country of Origin', SITM.StockValue AS 'Inventory Value', SITM.Phantom AS 'Phantom Item', SITM.IssueMthd AS 'Issue Method', SITM.FREE1 AS 'Yield in %', SITM.PricingPrc AS 'Pricing Percentage', SITM.MngMethod AS 'Management Method', SITM.ReorderPnt AS 'Reorder Point', SITM.InvntryUom AS 'Inventory UoM', SITM.PlaningSys AS 'Planning Method', SITM.PrcrmntMtd AS 'Procurement Method', SITM.OrdrIntrvl AS 'Order Intervals', SITM.OrdrMulti AS 'Order Multiple', SITM.MinOrdrQty AS 'Minimum Order Quantity', SITM.LeadTime AS 'Lead Time', SITM.IndirctTax AS 'Indirect Tax', SITM.TaxCodeAR AS 'Tax Code (A/R)', SITM.TaxCodeAP AS 'Tax Code (A/P)', SITM.OSvcCode AS 'Outgoing Service Code', SITM.ISvcCode AS 'Incoming Service Code', SITM.ServiceGrp AS 'Service Group', SITM.NCMCode AS 'NCM Code', SITM.MatType AS 'Material Type', SITM.MatGrp AS 'Material Group', SITM.ProductSrc AS 'Product Source', SITM.ServiceCtg AS 'Service Category', SITM.ItemClass AS 'Service or Material', SITM.Excisable AS 'Excisable [Yes/No]', SITM.ChapterID AS 'Chapter ID', SITM.NotifyASN AS 'Notification Availed SN.', SITM.ProAssNum AS 'Provisional Assessment No.', SITM.AssblValue AS 'Assessable Value', SITM.DNFEntry AS 'DNF Code Entry', SITM.UserSign2 AS 'Updating User', SITM.Spec AS 'Item Specification', SITM.TaxCtg AS 'Tax Category', SITM.Series AS 'Series', SITM.Number AS 'Number', SITM.FuelCode AS 'Fuel', SITM.BeverTblC AS 'Beverage Table', SITM.BeverGrpC AS 'Beverage Group', SITM.BeverTM AS 'Beverage Brand', SITM.Attachment AS 'Attachment', SITM.AtcEntry AS 'Attachment Entry', SITM.ToleranDay AS 'Tolerance Days', SITM.UgpEntry AS 'UoM Group', SITM.PUoMEntry AS 'Default Purchase UoM', SITM.SUoMEntry AS 'Default Sales UoM', SITM.IUoMEntry AS 'Inventory UoM', SITM.IssuePriBy AS 'Issue Primarily By SnB or Bin', SITM.AssetClass AS 'Asset Class', SITM.AssetGroup AS 'Asset Group', SITM.InventryNo AS 'Inventory Number of Asset', SITM.Technician AS 'Technician of Fixed Asset', SITM.Employee AS 'Employee of Fixed Asset', SITM.Location AS 'Location', SITM.StatAsset AS 'Owned by Company', SITM.Cession AS 'Cession', SITM.DeacAftUL AS 'Deactivate After Useful Life', SITM.AsstStatus AS 'Asset Status', SITM.CapDate AS 'Capitalization Date', SITM.AcqDate AS 'Acquisition Date', SITM.RetDate AS 'Retirement Date', SITM.GLPickMeth AS 'G/L Account Pick Method', SITM.NoDiscount AS 'No Discounts', SITM.MgrByQty AS 'Manage Asset by Quantity', SITM.AssetRmk1 AS 'Asset Remark 1', SITM.AssetRmk2 AS 'Asset Remark 2', SITM.AssetAmnt1 AS 'Asset Amount 1', SITM.AssetAmnt2 AS 'Asset Amount 2', SITM.DeprGroup AS 'Depreciation Group', SITM.AssetSerNo AS 'Asset Serial Number', SITM.CntUnitMsr AS 'Inventory Counting UoM Name', SITM.NumInCnt AS 'No. of Items per Counting Unit', SITM.INUoMEntry AS 'Inventory Counting UoM Entry', SITM.OneBOneRec AS 'One Batch One Receipt', SITM.RuleCode AS 'Checking Rule Code', SITM.ScsCode AS 'Scs Code', SITM.SpProdType AS 'Special Product Type', SITM.IWeight1 AS 'Weight 1 - Inventory', SITM.IWght1Unit AS 'Weight 1 - Inventory Unit', SITM.IWeight2 AS 'Weight 2 - Inventory', SITM.IWght2Unit AS 'Weight 2 - Inventory Unit', SITM.CompoWH AS 'Component Warehouse' FROM SITM AS SITM

Related information


SITM SQL Table

Asset Classes OACS SQL Table

Asset Groups OAGS SQL Table

Brazil String Indexer OBSI SQL Table

Brazil Numeric Indexer OBNI SQL Table

Business Partner OCRD SQL Table

India Chapter ID OCHP SQL Table

Commission Groups OCOG SQL Table

Customs Groups OARG SQL Table

Depreciation Groups OADG SQL Table

DNF Code ODNF SQL Table

Employees OHEM SQL Table

G/L Accounts OACT SQL Table

Manufacturers OMRC SQL Table

Brazil Fuel Indexer OBFI SQL Table

UoM Master Data OUOM SQL Table

Service Code Table OSCD SQL Table

Item Groups OITB SQL Table

Location OLCT SQL Table

Material Group OMGP SQL Table

Material Type OMTP SQL Table

NCM Code ONCM SQL Table

Object Settings - History ADP1 SQL Table

Cycle OCYC SQL Table

Product Source Code OPSC SQL Table

Checking Rule ODCR SQL Table

Documents Numbering - Series NNM1 SQL Table

Service Category OSCG SQL Table

Service Group for Brazil OSGP SQL Table

Delivery Types OSHP SQL Table

Sales Tax Codes OSTC SQL Table

UoM Group OUGP SQL Table

Users OUSR SQL Table

Tax Definition OVTG SQL Table

Contract Template OCTT 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