biuan SAP® BUSINESS ONE SDK
API Alternative Items / Alternative Item
OALI - Alternative Items 2 Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
OrigItem KEY UNIQUEOriginal Item No.nVarChar
20OITM
Items
PRIMARYYes
AltItemAlternative Item No.nVarChar
20OITM
Items
MatchMatch FactorNum
20
RemarksItem RemarksnVarChar
50

SELECT statement

SELECT OALI.OrigItem AS 'Original Item No.', OALI.AltItem AS 'Alternative Item No.', OALI.Match AS 'Match Factor', OALI.Remarks AS 'Item Remarks' FROM OALI AS OALI

Related information


Alternative Item AlternativeItem Object· Table: OALI
A data structure object related to the AlternativeItemsService service. Source table: OALI.
   Parent: Alternative Items AlternativeItems Collection

Alternative Items Service AlternativeItemsService Service· Table: OALI
This service manages alternative items in SAP Business One (add, delete, get by key, and update). Source table: OALI.

Items OITM 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