biuan SAP® BUSINESS ONE SDK
SQL Others / Gross Profit Adjustment
API OGPA
OGPA - Gross Profit Adjustment Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AbsEntry KEY UNIQUEInternal KeyInt
11
PRIMARYYes
NameGross Profit Adjustment NamenVarChar
100
CreateDateCreate DateDate
8
UserSignUser SignatureInt
6
StatusStatusVarChar
R) Saved Recommendations
S) Simulation
E) Executed
P) Saved Parameters
1
RemarksDescriptionnVarChar
127
WizTypeWizard TypeVarChar
A) Gross Profit Adjustment Wizard
R) Product Cost Recalculation Wizard
1
A
nGPAdjNumber of Gross Profits RecalculatedInt
11
nPCAdjNumber of Product Costs RecalculatedInt
11
nGPFailNumber of Gross Profit Recalculations FaInt
11
nPCFailNumber of Failed Product Cost RecalculatInt
11
nJECreateNumber of Journal Entries CreatedInt
11
nMRVCreateNumber of MRV CreatedInt
11

SELECT statement

SELECT OGPA.AbsEntry AS 'Internal Key', OGPA.Name AS 'Gross Profit Adjustment Name', OGPA.CreateDate AS 'Create Date', OGPA.UserSign AS 'User Signature', OGPA.Status AS 'Status', OGPA.Remarks AS 'Description', OGPA.WizType AS 'Wizard Type', OGPA.nGPAdj AS 'Number of Gross Profits Recalculated', OGPA.nPCAdj AS 'Number of Product Costs Recalculated', OGPA.nGPFail AS 'Number of Gross Profit Recalculations Fa', OGPA.nPCFail AS 'Number of Failed Product Cost Recalculat', OGPA.nJECreate AS 'Number of Journal Entries Created', OGPA.nMRVCreate AS 'Number of MRV Created' FROM OGPA AS OGPA

Related information


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