biuan SAP® BUSINESS ONE SDK
SQL Marketing Documents and Receipts / Predefined Text / Predefined Text
DTW Predefined Text
API Predefined Texts Service / Predefined Text
OPDT - Predefined Text Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AbsEntry KEY UNIQUEInternal NumberInt
11
PRIMARYYes
TextCode KEY UNIQUEText CodenVarChar
20
CODEYes
TextTEXTText
16

SELECT statement

SELECT OPDT.AbsEntry AS 'Internal Number', OPDT.TextCode AS 'Text Code', OPDT.Text AS 'TEXT' FROM OPDT AS OPDT

Related information


Predefined Text PredefinedText Object· Table: OPDT
Represents a predefined text. Source table: OPDT Mandatory properties: TextCode
   Parent: Predefined Texts Service PredefinedTextsService Service· Table: OPDT

Predefined Texts Service PredefinedTextsService Service· Table: OPDT
The PredefinedTextsService service enables you to add, look up and remove predefined texts in the predefined texts master data table. Predefined texts are stored text strings that can be added as remarks in marketing documents. To see the...
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