biuan SAP® BUSINESS ONE SDK
API TGPA
TGPA - Gross Profit Adjustment - Log Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AbsEntry KEY UNIQUEInternal KeyIdentity
11
PRIMARYYes
ItemCodeItem No.nVarChar
20OITM
Items
ItemNameItem DescriptionnVarChar
100
LineIDLine IDInt
11
SelectedSelectedVarChar
1
N
DocTypeDocument TypenVarChar
20
DocNumDocument NumberInt
11
DocAbsDocument Abs. EntryInt
11
DocLineNumDocument Line NumberInt
11
ManagedByManaged ByInt
10000044) Batch Numbers
10000045) Serial Numbers
11
-1
SysNumberSystem NumberInt
11

SELECT statement

SELECT TGPA.AbsEntry AS 'Internal Key', TGPA.ItemCode AS 'Item No.', TGPA.ItemName AS 'Item Description', TGPA.LineID AS 'Line ID', TGPA.Selected AS 'Selected', TGPA.DocType AS 'Document Type', TGPA.DocNum AS 'Document Number', TGPA.DocAbs AS 'Document Abs. Entry', TGPA.DocLineNum AS 'Document Line Number', TGPA.ManagedBy AS 'Managed By', TGPA.SysNumber AS 'System Number' FROM TGPA AS TGPA

Related information


Items OITM SQL Table



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