biuan SAP® BUSINESS ONE SDK
SQL Marketing Documents and Receipts / Product Cost Adjustment - MRV Document Lines
API GPA8
GPA8 - Product Cost Adjustment - MRV Document Lines Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AbsEntry KEY UNIQUEInternal KeyInt
11OGPA
Gross Profit Adjustment		PRIMARYYes
LineIdRow No.Int
11
ProdCodeProduct CodenVarChar
20
ProdDescrProduct DescriptionnVarChar
100
DistNumberBatch NumbernVarChar
36
SnBAbsSnB Abs. EntryInt
11
ManagedByManaged ByInt
10000044) Batch Numbers
10000045) Serial Numbers
-1)
11
-1
IncrAcctG/L Increase AccountnVarChar
15
DecrAcctG/L Decrease AccountnVarChar
15
DebCredAmtDebit/Credit AmountNum
20

SELECT statement

SELECT GPA8.AbsEntry AS 'Internal Key', GPA8.LineId AS 'Row No.', GPA8.ProdCode AS 'Product Code', GPA8.ProdDescr AS 'Product Description', GPA8.DistNumber AS 'Batch Number', GPA8.SnBAbs AS 'SnB Abs. Entry', GPA8.ManagedBy AS 'Managed By', GPA8.IncrAcct AS 'G/L Increase Account', GPA8.DecrAcct AS 'G/L Decrease Account', GPA8.DebCredAmt AS 'Debit/Credit Amount' FROM GPA8 AS GPA8

Related information


Gross Profit Adjustment OGPA 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