biuan SAP® BUSINESS ONE SDK
SQL Administration / Can Be Archive
DTW Administration / Setup / Financials / Tax / Withholding Tax
API TDR1
TDR1 - Can Be Archive Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
Line_ID KEY UNIQUERow NumberInt
11
PRIMARYYes
KeySeg1Key Segment 1nVarChar
15
KeySeg2Key Segment 2nVarChar
15
KeySeg3Key Segment 3nVarChar
15
KeySeg4Key Segment 4nVarChar
15
KeySeg5Key Segment 5nVarChar
15
KeySeg6Key Segment 6nVarChar
15
KeySeg7Key Segment 7nVarChar
15
KeySeg8Key Segment 8nVarChar
15
KeySeg9Key Segment 9nVarChar
15
KeySeg10Key Segment 10nVarChar
15
DocAbsDocument Internal IDInt
11

SELECT statement

SELECT TDR1.Line_ID AS 'Row Number', TDR1.KeySeg1 AS 'Key Segment 1', TDR1.KeySeg2 AS 'Key Segment 2', TDR1.KeySeg3 AS 'Key Segment 3', TDR1.KeySeg4 AS 'Key Segment 4', TDR1.KeySeg5 AS 'Key Segment 5', TDR1.KeySeg6 AS 'Key Segment 6', TDR1.KeySeg7 AS 'Key Segment 7', TDR1.KeySeg8 AS 'Key Segment 8', TDR1.KeySeg9 AS 'Key Segment 9', TDR1.KeySeg10 AS 'Key Segment 10', TDR1.DocAbs AS 'Document Internal ID' FROM TDR1 AS TDR1

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