biuan SAP® BUSINESS ONE SDK
DTW Inventory / Item Master Data
API Items
Items Object

Description

Items is a business object that represents the items master data in the Inventory and Production module.

This object enables you to:

  • Add an item details.
  • Retrieve an item by its key.
  • Update item details.
  • Save the object in XML format.

Source table: OITM.

Object Model

Remarks

Mandatory fields in SAP Business One: ItemCode and Manufacturer.

To display the Item Master Data window, from the SAP Business One Main Menu, choose Inventory --> Item Master Data.

SAP Business One also lets you manage all fixed assets in the asset master data. To access the Asset Master Data window, from the SAP Business One Main Menu, choose Financials --> Fixed Assets --> Asset Master Data.

Example

The following example shows how to use the GetByKey method to retrieve the object data from the database.
GetByKey Method (Visual Basic)
Name=Code_VB>
Dim vItem As SAPbobsCOM.Items Dim RetVal As Long Set vItem = vCmp.GetBusinessObject(oItems) 'Retrieve a record by its key from the database RetVal = vItem.GetByKey("A00043") 'Check errors If RetVal <> 0 Then vCmp.GetLastError ErrCode, ErrMsg MsgBox "Failed to Retrieve the record " & ErrCode & " " & ErrMsg Exit Sub End If

Example

See Also

SAP® B1 DI-API C# definition

public class ItemsClass : IItems, Items { public virtual string ApTaxCode { get; set; } public virtual string ArTaxCode { get; set; } public virtual string AssetClass { get; set; } public virtual string AssetGroup { get; set; } public virtual BoYesNoEnum AssetItem { get; set; } public virtual string AssetSerialNumber { get; set; } public virtual AssetStatusEnum AssetStatus { get; } public virtual int AttachmentEntry { get; set; } public virtual ItemsAttributeGroups AttributeGroups { get; } public virtual BoYesNoEnum AutoCreateSerialNumbersOnRelease { get; set; } public virtual double AvgStdPrice { get; set; } public virtual string BarCode { get; set; } public virtual ItemBarCodes BarCodes { get; } public virtual string BaseUnitName { get; set; } public virtual int BeverageCommercialBrandCode { get; set; } public virtual string BeverageGroupCode { get; set; } public virtual string BeverageTableCode { get; set; } public virtual DataBrowser Browser { get; } public virtual DateTime CapitalizationDate { get; set; } public virtual BoYesNoEnum Cession { get; set; } public virtual int ChapterID { get; set; } public virtual int CommissionGroup { get; set; } public virtual double CommissionPercent { get; set; } public virtual double CommissionSum { get; set; } public virtual BoMRPComponentWarehouse ComponentWarehouse { get; set; } public virtual BoInventorySystem CostAccountingMethod { get; set; } public virtual double CountingItemsPerUnit { get; } public virtual int CustomsGroupCode { get; set; } public virtual string DataExportCode { get; set; } public virtual BoYesNoEnum DeactivateAfterUsefulLife { get; set; } public virtual string DefaultCountingUnit { get; } public virtual int DefaultCountingUoMEntry { get; set; } public virtual int DefaultPurchasingUoMEntry { get; set; } public virtual int DefaultSalesUoMEntry { get; set; } public virtual string DefaultWarehouse { get; set; } public virtual string DepreciationGroup { get; set; } public virtual ItemsDepreciationParameters DepreciationParameters { get; } public virtual double DesiredInventory { get; set; } public virtual ItemsDistributionRules DistributionRules { get; } public virtual int DNFEntry { get; set; } public virtual string ECExpensesAccount { get; set; } public virtual string ECRevenuesAccount { get; set; } public virtual int Employee { get; set; } public virtual BoYesNoEnum EnforceAssetSerialNumbers { get; set; } public virtual BoYesNoEnum Excisable { get; set; } public virtual string ExemptIncomeAccount { get; set; } public virtual string ExpanseAccount { get; set; } public virtual BoYesNoEnum ForceSelectionOfSerialNumber { get; set; } public virtual string ForeignExpensesAccount { get; set; } public virtual string ForeignName { get; set; } public virtual string ForeignRevenuesAccount { get; set; } public virtual BoYesNoEnum Frozen { get; set; } public virtual DateTime FrozenFrom { get; set; } public virtual string FrozenRemarks { get; set; } public virtual DateTime FrozenTo { get; set; } public virtual int FuelID { get; set; } public virtual BoGLMethods GLMethod { get; set; } public virtual string GTSItemSpec { get; set; } public virtual string GTSItemTaxCategory { get; set; } public virtual string IncomeAccount { get; set; } public virtual int IncomingServiceCode { get; set; } public virtual BoYesNoEnum InCostRollup { get; set; } public virtual BoYesNoEnum IndirectTax { get; set; } public virtual ItemIntrastatExtension IntrastatExtension { get; } public virtual BoYesNoEnum InventoryItem { get; set; } public virtual string InventoryNumber { get; set; } public virtual string InventoryUOM { get; set; } public virtual int InventoryUoMEntry { get; set; } public virtual double InventoryWeight { get; set; } public virtual double InventoryWeight1 { get; set; } public virtual int InventoryWeightUnit { get; set; } public virtual int InventoryWeightUnit1 { get; set; } public virtual BoYesNoEnum IsPhantom { get; set; } public virtual BoIssueMethod IssueMethod { get; set; } public virtual IssuePrimarilyByEnum IssuePrimarilyBy { get; set; } public virtual ItemClassEnum ItemClass { get; set; } public virtual string ItemCode { get; set; } public virtual string ItemCountryOrg { get; set; } public virtual string ItemName { get; set; } public virtual int ItemsGroupCode { get; set; } public virtual ItemTypeEnum ItemType { get; set; } public virtual int LeadTime { get; set; } public virtual ItemLocalizationInfos LocalizationInfos { get; } public virtual int Location { get; set; } public virtual string Mainsupplier { get; set; } public virtual BoYesNoEnum ManageBatchNumbers { get; set; } public virtual BoYesNoEnum ManageByQuantity { get; } public virtual BoYesNoEnum ManageSerialNumbers { get; set; } public virtual BoYesNoEnum ManageSerialNumbersOnReleaseOnly { get; set; } public virtual BoYesNoEnum ManageStockByWarehouse { get; set; } public virtual int Manufacturer { get; set; } public virtual int MaterialGroup { get; set; } public virtual BoMaterialTypes MaterialType { get; set; } public virtual double MaxInventory { get; set; } public virtual double MinInventory { get; set; } public virtual double MinOrderQuantity { get; set; } public virtual double MovingAveragePrice { get; } public virtual int NCMCode { get; set; } public virtual BoYesNoEnum NoDiscounts { get; set; } public virtual string OrderIntervals { get; set; } public virtual double OrderMultiple { get; set; } public virtual int OutgoingServiceCode { get; set; } public virtual ItemsPeriodControls PeriodControls { get; } public virtual string Picture { get; set; } public virtual BoPlanningSystem PlanningSystem { get; set; } public virtual Items_PreferredVendors PreferredVendors { get; } public virtual Items_Prices PriceList { get; } public virtual BoProcurementMethod ProcurementMethod { get; set; } public virtual double ProdStdCost { get; set; } public virtual int ProductSource { get; set; } public virtual ItemsProjects Projects { get; } public virtual BoYesNoEnum Properties(int GroupNum) { get; set; } public virtual double PurchaseFactor1 { get; set; } public virtual double PurchaseFactor2 { get; set; } public virtual double PurchaseFactor3 { get; set; } public virtual double PurchaseFactor4 { get; set; } public virtual int PurchaseHeightUnit { get; set; } public virtual int PurchaseHeightUnit1 { get; set; } public virtual BoYesNoEnum PurchaseItem { get; set; } public virtual double PurchaseItemsPerUnit { get; set; } public virtual int PurchaseLengthUnit { get; set; } public virtual int PurchaseLengthUnit1 { get; set; } public virtual string PurchasePackagingUnit { get; set; } public virtual double PurchaseQtyPerPackUnit { get; set; } public virtual string PurchaseUnit { get; set; } public virtual double PurchaseUnitHeight { get; set; } public virtual double PurchaseUnitHeight1 { get; set; } public virtual double PurchaseUnitLength { get; set; } public virtual double PurchaseUnitLength1 { get; set; } public virtual double PurchaseUnitVolume { get; set; } public virtual double PurchaseUnitWeight { get; set; } public virtual double PurchaseUnitWeight1 { get; set; } public virtual double PurchaseUnitWidth { get; set; } public virtual double PurchaseUnitWidth1 { get; set; } public virtual string PurchaseVATGroup { get; set; } public virtual int PurchaseVolumeUnit { get; set; } public virtual int PurchaseWeightUnit { get; set; } public virtual int PurchaseWeightUnit1 { get; set; } public virtual int PurchaseWidthUnit { get; set; } public virtual int PurchaseWidthUnit1 { get; set; } public virtual double QuantityOnStock { get; } public virtual double QuantityOrderedByCustomers { get; } public virtual double QuantityOrderedFromVendors { get; } public virtual double SalesFactor1 { get; set; } public virtual double SalesFactor2 { get; set; } public virtual double SalesFactor3 { get; set; } public virtual double SalesFactor4 { get; set; } public virtual int SalesHeightUnit { get; set; } public virtual int SalesHeightUnit1 { get; set; } public virtual BoYesNoEnum SalesItem { get; set; } public virtual double SalesItemsPerUnit { get; set; } public virtual int SalesLengthUnit { get; set; } public virtual int SalesLengthUnit1 { get; set; } public virtual string SalesPackagingUnit { get; set; } public virtual double SalesQtyPerPackUnit { get; set; } public virtual string SalesUnit { get; set; } public virtual double SalesUnitHeight { get; set; } public virtual double SalesUnitHeight1 { get; set; } public virtual double SalesUnitLength { get; set; } public virtual double SalesUnitLength1 { get; set; } public virtual double SalesUnitVolume { get; set; } public virtual double SalesUnitWeight { get; set; } public virtual double SalesUnitWeight1 { get; set; } public virtual double SalesUnitWidth { get; set; } public virtual double SalesUnitWidth1 { get; set; } public virtual string SalesVATGroup { get; set; } public virtual int SalesVolumeUnit { get; set; } public virtual int SalesWeightUnit { get; set; } public virtual int SalesWeightUnit1 { get; set; } public virtual int SalesWidthUnit { get; set; } public virtual int SalesWidthUnit1 { get; set; } public virtual string ScsCode { get; set; } public virtual string SerialNum { get; set; } public virtual int Series { get; set; } public virtual int ServiceGroup { get; set; } public virtual int ShipType { get; set; } public virtual SpecialProductTypeEnum SpProdType { get; set; } public virtual BoManageMethod SRIAndBatchManageMethod { get; set; } public virtual BoYesNoEnum StatisticalAsset { get; set; } public virtual string SupplierCatalogNo { get; set; } public virtual string SWW { get; set; } public virtual BoTaxTypes TaxType { get; set; } public virtual int Technician { get; set; } public virtual int ToleranceDays { get; set; } public virtual BoItemTreeTypes TreeType { get; } public virtual TypeOfAdvancedRulesEnum TypeOfAdvancedRules { get; set; } public virtual ItemUnitOfMeasurements UnitOfMeasurements { get; } public virtual int UoMGroupEntry { get; set; } public virtual string User_Text { get; set; } public virtual SAPbobsCOM.UserFields UserFields { get; } public virtual BoYesNoEnum Valid { get; set; } public virtual DateTime ValidFrom { get; set; } public virtual string ValidRemarks { get; set; } public virtual DateTime ValidTo { get; set; } public virtual BoYesNoEnum VatLiable { get; set; } public virtual BoYesNoEnum VirtualAssetItem { get; set; } public virtual string WarrantyTemplate { get; set; } public virtual ItemWarehouseInfo WhsInfo { get; } public virtual BoYesNoEnum WTLiable { get; set; } public extern ItemsClass(); public virtual extern int Add(); public virtual extern int Cancel(); public virtual extern int Close(); public virtual extern string GetAsXML(); public virtual extern bool GetByKey(string ItemCode); public virtual extern int Remove(); public virtual extern void SaveToFile( string FileName); public virtual extern void SaveXML( ref string FileName); public virtual extern int Update(); public virtual extern int UpdateFromXML( string FileName); }

Related information


Items Prices Items_Prices Object· Table: ITM1
Items_Prices is a child object of the Items object that represents the items' prices in the Inventory and Production module. This object enables you to specify prices for various price lists. Source table: ITM1
   Parent: Items Items Object· Table: OITM

Item Warehouse Info ItemWarehouseInfo Object· Table: OITW
ItemWarehouseInfo is a child object of the Items object that represents the items in the warehouse. This object is part of the Inventory and Production module. This object enables you to add an item to the warehouse. Source table: OITW.
   Parent: Items Items Object· Table: OITM

Items Preferred Vendors Items_PreferredVendors Object· Table: ITM2
Items_PreferredVendors is a child object of the Items object that represents the preferred vendor for the item. Source table: ITM2
   Parent: Items Items Object· Table: OITM

Items Attribute Groups ItemsAttributeGroups Object· Table: ITM13
ItemsAttributeGroups is a child object of the Items object. You can manage the attributes of an asset. Source table: ITM13.
   Parent: Items Items Object· Table: OITM

Items Depreciation Parameters ItemsDepreciationParameters Object· Table: ITM7
ItemsDepreciationParameters is a child object of the Items object. You can specify depreciation parameters for a fixed asset. Source table: ITM7.
   Parent: Items Items Object· Table: OITM

Items Distribution Rules ItemsDistributionRules Object· Table: ITM6
ItemsDistributionRules is a child object of the Items object. You can assign distribution rules to an asset to facilitate cost accounting. Source table: ITM6.
   Parent: Items Items Object· Table: OITM

Items Period Controls ItemsPeriodControls Object· Table: ITM11
ItemsPeriodControls is a child object of the Items object. You can define the depreciation calculation factors for different periods when you depreciate an asset using the straight line period control method with individual period...
   Parent: Items Items Object· Table: OITM

Items Projects ItemsProjects Object· Table: ITM5
ItemsProjects is a child object of the Items object. You can assign projects to an asset to facilitate cost accounting. Source table: ITM5.
   Parent: Items Items Object· Table: OITM

Bo Procurement Method BoProcurementMethod Enumeration
Defines the procurement method of items.
   Parent: Items Items Object· Table: OITM

Item Type Enum ItemTypeEnum Enumeration
Item types.
   Parent: Items Items Object· Table: OITM


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