biuan SAP® BUSINESS ONE SDK
API GPA2
GPA2 - Gross Profit Adjustments - Parameters Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AbsEntry KEY UNIQUEInternal KeyInt
11
PRIMARYYes
NameWizard Parameters NamenVarChar
100
DescriptWizard Parameters DescriptionnVarChar
100
PostDateFrSales Doc. Posting Date FromDate
8
PostDateToSales Doc. Posting Date ToDate
8
ItemCodeFrItem No. FromnVarChar
20
ItemCodeToItem No. TonVarChar
20
ItmsGrpCodItem GroupInt
6OITB
Item Groups
100
AdditFiltAdditional FiltersVarChar
1
SearchCondFind Items Search ConditionVarChar
1
PropListItem Properties ListnVarChar
100
DisplInactDisplay Inactive ItemsVarChar
1
UseGroupsFind items with only the selected properVarChar
1

SELECT statement

SELECT GPA2.AbsEntry AS 'Internal Key', GPA2.Name AS 'Wizard Parameters Name', GPA2.Descript AS 'Wizard Parameters Description', GPA2.PostDateFr AS 'Sales Doc. Posting Date From', GPA2.PostDateTo AS 'Sales Doc. Posting Date To', GPA2.ItemCodeFr AS 'Item No. From', GPA2.ItemCodeTo AS 'Item No. To', GPA2.ItmsGrpCod AS 'Item Group', GPA2.AdditFilt AS 'Additional Filters', GPA2.SearchCond AS 'Find Items Search Condition', GPA2.PropList AS 'Item Properties List', GPA2.DisplInact AS 'Display Inactive Items', GPA2.UseGroups AS 'Find items with only the selected proper' FROM GPA2 AS GPA2

Related information


Item Groups OITB 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