biuan SAP® BUSINESS ONE SDK
API BOE Portfolios / BOE Portfolio
OPTF - BoE Portfolio Table

SBO SQL database table details

FieldDescriptionTypeConstraintsSizeRelatedDefaultPrimary_KeyUnique
AbsEntry KEY UNIQUEInternal NumberInt
11
PRIMARYYes
PtfId KEY UNIQUEInternal Portfolio IDnVarChar
3
IDYes
PtfCodePortfolio CodenVarChar
2
PtfNumPortfolio NumbernVarChar
4
PtfDesptDescriptionnVarChar
20

SELECT statement

SELECT OPTF.AbsEntry AS 'Internal Number', OPTF.PtfId AS 'Internal Portfolio ID', OPTF.PtfCode AS 'Portfolio Code', OPTF.PtfNum AS 'Portfolio Number', OPTF.PtfDespt AS 'Description' FROM OPTF AS OPTF

Related information


BOE Portfolio BOEPortfolio Object· Table: OPTF
A data structure object holding properties for the BOEPortfoliosService. Source table: OPTF.
   Parent: BOE Portfolios BOEPortfolios Collection

BOE Portfolios Service BOEPortfoliosService Service· Table: OPTF
This service manages Portfolios in SAP Business One. Mandatory properties: PortfolioCode, PortfolioDescription, PortfolioID, PortfolioNum. Source table: OPTF.



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