biuan SAP® BUSINESS ONE SDK
API GPA4
GPA4 - Gross Profit Adjustment - JE Details Accounts Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AbsEntry KEY UNIQUEInternal KeyInt
11OGPA
Gross Profit Adjustment
PRIMARYYes
LineIdRow No.Int
11
LineTypeLine TypeVarChar
T) Total
A) Account
1
T
CurrCogsCurrent COGSNum
20
CalcCogsCalculated COGSNum
20
CogsDebitCOGS DebitNum
20
CogsCreditCOGS CreditNum
20
CogsAcctCOGS AccountnVarChar
15
PrDiffAcctPrice Difference AccountnVarChar
15
AutoPostAutomatic PostingVarChar
Y) Yes
N) No
1
Y

SELECT statement

SELECT GPA4.AbsEntry AS 'Internal Key', GPA4.LineId AS 'Row No.', GPA4.LineType AS 'Line Type', GPA4.CurrCogs AS 'Current COGS', GPA4.CalcCogs AS 'Calculated COGS', GPA4.CogsDebit AS 'COGS Debit', GPA4.CogsCredit AS 'COGS Credit', GPA4.CogsAcct AS 'COGS Account', GPA4.PrDiffAcct AS 'Price Difference Account', GPA4.AutoPost AS 'Automatic Posting' FROM GPA4 AS GPA4

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. Icons by Icons8 Contact
This website is not affiliated with, maintained, authorized, endorsed or sponsored by SAP AG or any of its affiliates