biuan SAP® BUSINESS ONE SDK
API GPA5
GPA5 - Product Cost Adjustment - Recalculation of Product Cost Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AbsEntry KEY UNIQUEInternal KeyInt
11OGPA
Gross Profit Adjustment
PRIMARYYes
LineIdRow No.Int
11
SelectedChooseVarChar
Y) Yes
N) No
1
Y
LnTypeChooseVarChar
P) Product Serial/Batch Line
O) Production Order Line
1
O
ProdCodeProduct CodenVarChar
20
ProdDescrProduct DescriptionnVarChar
100
PODocAbsPO Document Abs. EntryInt
11
PODocNumPO Document NumberInt
11
DocTypeChooseVarChar
I) Issue for Production
R) Receipt from Production
1
I
DocAbsDocument Abs. EntryInt
11
DocNumDocument NumberInt
11
DocLineNumDocument Line NumberInt
11
PostDatePosting DateDate
8
ItemCodeItem No.nVarChar
20
ItemDescrItem DescriptionnVarChar
100
DistNumberBatch NumbernVarChar
36
SnBAbsSnB Abs. EntryInt
11
ManagedByManaged ByInt
10000044) Batch Numbers
10000045) Serial Numbers
-1)
11
-1
LnQtyLine QuantityNum
20
SnBQtySerial/Batch QuantityNum
20
LnCostLine CostNum
20
DebCredDebited or CreditedVarChar
D) Debited
C) Credited
1
D
LnTotalLine TotalNum
20
SnBTotalSnB TotalNum
20
SBAccTotalSerial/Batch Accumulated TotalNum
20
SBAccQtySerial/Batch Accumulated QuantityNum
20
ACAccTotalActual Cost Accumulated TotalNum
20
ACAccQtyActual Cost Accumulated QuantityNum
20
AppliedApplied AdjustmentNum
20
VarianceVariance to ApplyNum
20
MRVAdjustMRV AdjustmentNum
20

SELECT statement

SELECT GPA5.AbsEntry AS 'Internal Key', GPA5.LineId AS 'Row No.', GPA5.Selected AS 'Choose', GPA5.LnType AS 'Choose', GPA5.ProdCode AS 'Product Code', GPA5.ProdDescr AS 'Product Description', GPA5.PODocAbs AS 'PO Document Abs. Entry', GPA5.PODocNum AS 'PO Document Number', GPA5.DocType AS 'Choose', GPA5.DocAbs AS 'Document Abs. Entry', GPA5.DocNum AS 'Document Number', GPA5.DocLineNum AS 'Document Line Number', GPA5.PostDate AS 'Posting Date', GPA5.ItemCode AS 'Item No.', GPA5.ItemDescr AS 'Item Description', GPA5.DistNumber AS 'Batch Number', GPA5.SnBAbs AS 'SnB Abs. Entry', GPA5.ManagedBy AS 'Managed By', GPA5.LnQty AS 'Line Quantity', GPA5.SnBQty AS 'Serial/Batch Quantity', GPA5.LnCost AS 'Line Cost', GPA5.DebCred AS 'Debited or Credited', GPA5.LnTotal AS 'Line Total', GPA5.SnBTotal AS 'SnB Total', GPA5.SBAccTotal AS 'Serial/Batch Accumulated Total', GPA5.SBAccQty AS 'Serial/Batch Accumulated Quantity', GPA5.ACAccTotal AS 'Actual Cost Accumulated Total', GPA5.ACAccQty AS 'Actual Cost Accumulated Quantity', GPA5.Applied AS 'Applied Adjustment', GPA5.Variance AS 'Variance to Apply', GPA5.MRVAdjust AS 'MRV Adjustment' FROM GPA5 AS GPA5

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