biuan SAP® BUSINESS ONE SDK
SQL Inventory and Production / Package Types
API OPKG / / Packages Types
OPKG - Package Types Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
PkgCode KEY UNIQUECodeInt
11
PRIMARYYes
PkgType KEY UNIQUETypenVarChar
30
TYPEYes
Length1Length 1Num
20
Len1UnitUnit of Length 1Int
6
length2Length 2Num
20
Len2UnitUnit of Length 2Int
6
Width1Width 1Num
20
Wdth1UnitUnit of Width 1Int
6
Width2Width 2Num
20
Wdth2UnitUnit of Width 2Int
6
Height1Height 1Num
20
Hght1UnitUnit of Height 1Int
6
Height2Height 2Num
20
Hght2UnitUnit of Height 2Int
6
VolumeVolumeNum
20
VolUnitVolume UoMInt
6
Weight1Weight 1Num
20
WghtUnitWeight UoMInt
6
Weight2Weight 2Num
20
Wght2UnitUnit of Weight 2Int
6

SELECT statement

SELECT OPKG.PkgCode AS 'Code', OPKG.PkgType AS 'Type', OPKG.Length1 AS 'Length 1', OPKG.Len1Unit AS 'Unit of Length 1', OPKG.length2 AS 'Length 2', OPKG.Len2Unit AS 'Unit of Length 2', OPKG.Width1 AS 'Width 1', OPKG.Wdth1Unit AS 'Unit of Width 1', OPKG.Width2 AS 'Width 2', OPKG.Wdth2Unit AS 'Unit of Width 2', OPKG.Height1 AS 'Height 1', OPKG.Hght1Unit AS 'Unit of Height 1', OPKG.Height2 AS 'Height 2', OPKG.Hght2Unit AS 'Unit of Height 2', OPKG.Volume AS 'Volume', OPKG.VolUnit AS 'Volume UoM', OPKG.Weight1 AS 'Weight 1', OPKG.WghtUnit AS 'Weight UoM', OPKG.Weight2 AS 'Weight 2', OPKG.Wght2Unit AS 'Unit of Weight 2' FROM OPKG AS OPKG

Related information


Packages Types PackagesTypes Object· Table: OPKG
PackagesTypes is a business object that represents the list of package types for deliveries in the Inventory and Production module. This object enables you to: Add a package type. Retrieve a package type. Update a package type. Remove a...

OPKG 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