biuan SAP® BUSINESS ONE SDK
SQL Reports / ECD Wizard - Rows 1
API ECDW1
ECDW1 - ECD Wizard - Rows 1 Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AbsEntry KEY UNIQUEInternal NumberInt
11
PRIMARYYes
DocTypeTemplate TypeVarChar
B) Balance Sheet
P) Profit and Loss
1
ExNumData1Extra Numeric Data 1Int
11
ExNumData2Extra Numeric Data 2Int
11
ExNumData3Extra Numeric Data 3Int
11
ExStrData1Extra String Data 1nVarChar
127
ExStrData2Extra String Data 2nVarChar
127
ExStrData3Extra String Data 3nVarChar
127

SELECT statement

SELECT ECDW1.AbsEntry AS 'Internal Number', ECDW1.DocType AS 'Template Type', ECDW1.ExNumData1 AS 'Extra Numeric Data 1', ECDW1.ExNumData2 AS 'Extra Numeric Data 2', ECDW1.ExNumData3 AS 'Extra Numeric Data 3', ECDW1.ExStrData1 AS 'Extra String Data 1', ECDW1.ExStrData2 AS 'Extra String Data 2', ECDW1.ExStrData3 AS 'Extra String Data 3' FROM ECDW1 AS ECDW1

Related information
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