biuan SAP® BUSINESS ONE SDK
SQL Reports / Document Type List / Document Type List
DTW Document Type List
API Report Types Service / Report Type
RTYP - Document Type List Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
CODE KEY UNIQUEReport TypenVarChar
4
PRIMARYYes
NAMEType NamenVarChar
127
DEFLT_REPStandard ReportnVarChar
8
ADD_NAMEAddon NamenVarChar
127
FRM_TYPEAdd-On Form TypenVarChar
127
MNU_IDMenu IdnVarChar
127
IS_SYSIs sytem type or notVarChar
Y) Yes
N) No
1
Y
DEFLT_SEQStandard SequenceInt
11
TYPETypeVarChar
L) Layout
P) Print Sequence
1
L

SELECT statement

SELECT RTYP.CODE AS 'Report Type', RTYP.NAME AS 'Type Name', RTYP.DEFLT_REP AS 'Standard Report', RTYP.ADD_NAME AS 'Addon Name', RTYP.FRM_TYPE AS 'Add-On Form Type', RTYP.MNU_ID AS 'Menu Id', RTYP.IS_SYS AS 'Is sytem type or not', RTYP.DEFLT_SEQ AS 'Standard Sequence', RTYP.TYPE AS 'Type' FROM RTYP AS RTYP

Related information


Report Type ReportType Object· Table: RTYP
Represent the report type to which a layout is assigned. You can insert report types for add-on forms. Source table: RTYP.
   Parent: Report Types Service ReportTypesService Service· Table: RTYP

Report Types Service ReportTypesService Service· Table: RTYP
The ReportTypesService service enables you to add, look up, and delete the report types in SAP Business One. Source table: RTYP.
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