biuan SAP® BUSINESS ONE SDK
API GPA1
GPA1 - Gross Profit Adjustment - Documents Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AbsEntry KEY UNIQUEInternal KeyInt
11OGPA
Gross Profit Adjustment
PRIMARYYes
LineIdRow No.Int
11
ItemCodeItem No.nVarChar
20OITM
Items
ItemNameItem DescriptionnVarChar
100
DocTypeDocument TypenVarChar
20
DocNumDocument NumberInt
11
DocAbsDocument Abs. EntryInt
11
DocLineNumDocument Line NumberInt
11
ManagedByManaged ByInt
10000044) Batch Numbers
10000045) Serial Numbers
-1)
11
-1
SelectedChooseVarChar
Y) Yes
N) No
1
Y
DistNumberBatch NumbernVarChar
36
PostDatePosting DateDate
8
WhsCodeWarehouse CodenVarChar
8
QuantityQuantityNum
20
CogsAcctCOGS Account CodenVarChar
15
CogsAmntCOGS AmountNum
20
SalesAmntSales AmountNum
20
GrssProfitRow Gross ProfitNum
20
COGSByCCCOGS By Current CostNum
20
GPByCCGross Profit By Current CostNum
20
DeltaGPDelta Gross ProfitNum
20
SalesPriceSales PriceNum
20
BatchQtBatch QuantityNum
20
SnBAbsSnB Abs. EntryInt
11
AccTotalAcct TotalNum
20
AccQtyAcct QtyNum
20
ActionTypeAction TypeInt
0
1) TRANSACTION_IN
2) TRANSACTION_OUT
3) TRANSACTION_SET
4) TRANSACTION_COMPLETE
5) EMPTY_TRANSACTION
6) TRANSACTION_REVALUATION
7) TRANSACTION_REVALUATION_INCREASE
8) TRANSACTION_REVALUATION_DECREASE
9) TRANSACTION_CLOSE_IN
10) TRANSACTION_CLOSE_OUT
11) TRANSACTION_NEGATIVE_REVALUATION
12) TRANSACTION_NULLIFY
13) TRANSACTION_RESERVE_CI_IN
14) TRANSACTION_RESERVE_CI_OUT
15) TRANSACTION_RESERVE_CI_REVAL_INC
16) TRANSACTION_RESERVE_CI_REVAL_DEC
17) TRANSACTION_REVAL_PRICE_CHANGE_INCREASE
18) TRANSACTION_REVAL_PRICE_CHANGE_DECREASE
11
5
SBAccTotalSnB Acct TotalNum
20
SBAccQtySnB Acct QtyNum
20
BaseTypeBase TypenVarChar
20
ExecuteExecuteVarChar
Y) Yes
N) No
1
Y
SBCogsAmntSnB COGS AmountNum
20
SBSaleAmntSnB Sales AmountNum
20
SBGrssProfSnB Gross ProfitNum
20
SBGrPrPercSnB Gross Profit PercentageNum
20
GrPrPercGross Profit PercentageNum
20
GPPercByCCGross Profit Percentage By Current CostNum
20
DeltaGPLnDelta gross profit calculated for the doNum
20
AppliedApplied AdjustmentNum
20
SBAccTtAdjSnB Acct Total AdjustmentNum
20
IsMixedIs Mixed Based DocumentVarChar
Y) Yes
N) No
1
N
CogsAmByCCTotal COGS Amount By Current CostNum
20
GrssPrByCCTotal Gross Profit By Current CostNum
20
LineTypeWizard Line TypeVarChar
N) Normal
C) Chained
I) Non Based Correction Invoice
1
N
ChDocTypeChained Document TypenVarChar
20
ChDocAbsChained Document Abs. EntryInt
11
WasQtyWas Line QuantityNum
20
WasCogsWas Line COGS AmountNum
20
WasSalesWas Line Sales AmountNum
20
WasPriceWas Line Sales PriceNum
20
WasGrProfWas Line Gross ProfitNum
20
BaseAbsBase Document Abs EntryInt
11
WasNewCogsWas Line New CogsNum
20
ChDocLineChained Document LineInt
11

Table relationship map

SELECT statement

SELECT GPA1.AbsEntry AS 'Internal Key', GPA1.LineId AS 'Row No.', GPA1.ItemCode AS 'Item No.', GPA1.ItemName AS 'Item Description', GPA1.DocType AS 'Document Type', GPA1.DocNum AS 'Document Number', GPA1.DocAbs AS 'Document Abs. Entry', GPA1.DocLineNum AS 'Document Line Number', GPA1.ManagedBy AS 'Managed By', GPA1.Selected AS 'Choose', GPA1.DistNumber AS 'Batch Number', GPA1.PostDate AS 'Posting Date', GPA1.WhsCode AS 'Warehouse Code', GPA1.Quantity AS 'Quantity', GPA1.CogsAcct AS 'COGS Account Code', GPA1.CogsAmnt AS 'COGS Amount', GPA1.SalesAmnt AS 'Sales Amount', GPA1.GrssProfit AS 'Row Gross Profit', GPA1.COGSByCC AS 'COGS By Current Cost', GPA1.GPByCC AS 'Gross Profit By Current Cost', GPA1.DeltaGP AS 'Delta Gross Profit', GPA1.SalesPrice AS 'Sales Price', GPA1.BatchQt AS 'Batch Quantity', GPA1.SnBAbs AS 'SnB Abs. Entry', GPA1.AccTotal AS 'Acct Total', GPA1.AccQty AS 'Acct Qty', GPA1.ActionType AS 'Action Type', GPA1.SBAccTotal AS 'SnB Acct Total', GPA1.SBAccQty AS 'SnB Acct Qty', GPA1.BaseType AS 'Base Type', GPA1.Execute AS 'Execute', GPA1.SBCogsAmnt AS 'SnB COGS Amount', GPA1.SBSaleAmnt AS 'SnB Sales Amount', GPA1.SBGrssProf AS 'SnB Gross Profit', GPA1.SBGrPrPerc AS 'SnB Gross Profit Percentage', GPA1.GrPrPerc AS 'Gross Profit Percentage', GPA1.GPPercByCC AS 'Gross Profit Percentage By Current Cost', GPA1.DeltaGPLn AS 'Delta gross profit calculated for the do', GPA1.Applied AS 'Applied Adjustment', GPA1.SBAccTtAdj AS 'SnB Acct Total Adjustment', GPA1.IsMixed AS 'Is Mixed Based Document', GPA1.CogsAmByCC AS 'Total COGS Amount By Current Cost', GPA1.GrssPrByCC AS 'Total Gross Profit By Current Cost', GPA1.LineType AS 'Wizard Line Type', GPA1.ChDocType AS 'Chained Document Type', GPA1.ChDocAbs AS 'Chained Document Abs. Entry', GPA1.WasQty AS 'Was Line Quantity', GPA1.WasCogs AS 'Was Line COGS Amount', GPA1.WasSales AS 'Was Line Sales Amount', GPA1.WasPrice AS 'Was Line Sales Price', GPA1.WasGrProf AS 'Was Line Gross Profit', GPA1.BaseAbs AS 'Base Document Abs Entry', GPA1.WasNewCogs AS 'Was Line New Cogs', GPA1.ChDocLine AS 'Chained Document Line' FROM GPA1 AS GPA1

Related information


Gross Profit Adjustment OGPA SQL Table

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