biuan SAP® BUSINESS ONE SDK
SQL Reports / Korean Summary Report
API OSRT
OSRT - Korean Summary Report Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AbsId KEY UNIQUEAbstract IDInt
11
PRIMARYYes
SumRptId KEY UNIQUESummary Report IDnVarChar
100
SUM_RPT_IDYes
SumRptDateSummary Report DateDate
8
BPLIdBusiness Place IDInt
11
FromDateFrom DateDate
8
ToDateTo DateDate
8
RptTypeReport TypeVarChar
V) Vendor
C) Customer
1
C
versionReport Generation VersionnVarChar
50
SumSubIdSummary Report Sub IDnVarChar
127
SumRptTypeSummary Report TypenVarChar
127

SELECT statement

SELECT OSRT.AbsId AS 'Abstract ID', OSRT.SumRptId AS 'Summary Report ID', OSRT.SumRptDate AS 'Summary Report Date', OSRT.BPLId AS 'Business Place ID', OSRT.FromDate AS 'From Date', OSRT.ToDate AS 'To Date', OSRT.RptType AS 'Report Type', OSRT.version AS 'Report Generation Version', OSRT.SumSubId AS 'Summary Report Sub ID', OSRT.SumRptType AS 'Summary Report Type' FROM OSRT AS OSRT

Related information


OSRT 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