biuan SAP® BUSINESS ONE SDK
SQL Service / Service Call Solutions
API OSLT / / Knowledge Base Solutions
OSLT - Service Call Solutions Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
SltCode KEY UNIQUESolution CodeInt
11
PRIMARYYes
ItemCodeItem No.nVarChar
20OITM
Items
StatusNumStatusInt
11OSST
Service Call Solution Statuses
OwnerOwnerInt
11OUSR
Users
CreatedByCreated ByInt
11OUSR
Users
DateCreateCreation DateDate
8
UpdateByLast Update byInt
11OUSR
Users
DateUpdateLast Update DateDate
8
SubjectSubjectnVarChar
127
SymptomSymptomnVarChar
127
CauseCausenVarChar
127
DescriptioDescriptionText
16
AttachmentAttachmentsText
16
AtcEntryAttachment EntryInt
11
TransferedYear TransferVarChar
1
N
InstanceInstanceInt
6
0

Table relationship map

SELECT statement

SELECT OSLT.SltCode AS 'Solution Code', OSLT.ItemCode AS 'Item No.', OSLT.StatusNum AS 'Status', OSLT.Owner AS 'Owner', OSLT.CreatedBy AS 'Created By', OSLT.DateCreate AS 'Creation Date', OSLT.UpdateBy AS 'Last Update by', OSLT.DateUpdate AS 'Last Update Date', OSLT.Subject AS 'Subject', OSLT.Symptom AS 'Symptom', OSLT.Cause AS 'Cause', OSLT.Descriptio AS 'Description', OSLT.Attachment AS 'Attachments', OSLT.AtcEntry AS 'Attachment Entry', OSLT.Transfered AS 'Year Transfer', OSLT.Instance AS 'Instance' FROM OSLT AS OSLT

Related information


Knowledge Base Solutions KnowledgeBaseSolutions Object· Table: OSLT
KnowledgeBaseSolutions is a business object that represents the knowledge base solutions in the Service module. This object enables you to: Add a solution to the knowledge base. Retrieve a solution from the knowledge base by its key....

OSLT SQL Table

Users OUSR SQL Table

Items OITM SQL Table

Service Call Solution Statuses OSST 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