SAP Knowledge Base Article - Public

2871252 - What does AFL, APL, PAL stand for?


What does AFL, APL, PAL stand for?


  • SAP S/4HANA 1809+
  • SAP Predictive Analytics Library (APL)
  • Application Function Library (AFL)
  • Predictive Analysis Library (PAL)


AFL stands for Application Function Library

  • What's the meaning of Application Function Library (AFL)?
    • AFL is a group of functions which can be installed into HANA.
      It contains such as the Predictive Analysis Library (PAL) and the Business Function Library (BFL).
  • Why use Application Function Library (AFL)?
    • Complex calculation and computations can be executed by Application Server level, but it will be much more faster if it can be executed in Database level.
      AFL is the application functions which move application logic into HANA database.
    • Functions for a particular topic are grouped into an application function library (AFL), such as the Predictive Analysis Library (PAL) and the Business Function Library (BFL)
  • For more details on Application Function Library (AFL)
  • AFL-PAL related questions, can reach to HAN-DB-AFL-PAL component for Product Support assistance.

APL stands for SAP HANA Automated Predictive Library 

  • What's the meaning of SAP HANA Automated Predictive Library (APL) ?
    • APL is an AFL, which exposes the data mining capabilities of the Automated Analytics engine in SAP HANA through a set of functions.
  • For more details on SAP HANA Automated Predictive Library (APL)
    • Goto SAP help portal - APL -> Development -> SAP HANA Automated Predictive Library Reference Guide
    • Goto SAP help portal -> Search "SAP HANA Automated Predictive Library Reference Guide"
  • Related information on APL
  • APL related questions, can reach to BI-RA-PA-APL component for Product Support assistance.

Image picture


How Check APL Version

  • In SAPLogon GUI
    1. Open SAPLogon GUI of the backend system.
    2. Go to tcode /nDBACOCKPIT.
    3. Navigate to Current Status -> Overview.
    4. Click on the link beside Installed Plug-ins.
    5. Scroll down to SAP_AFL_SDK_APL section (if none then APL is not installed).
  • Or, in Hana Studio or IDE
    1. Open Administration.
    2. Navigate to Current Status -> Overview.
    3. Click on the link beside Installed Plug-ins.

Check PAi Versions

  1. Open a SQL console (or SQL Editor in DBACOCKPIT) and execute the following:


SDK libraries programming machine learning algorithms algor , KBA , HAN-DB-AFL-PAL , SAP HANA Predictive Analysis Library , BI-RA-PA-APL , Automated Predictive Library , How To


SAP S/4HANA Cloud 1911