Mathematical Functions in ABAP

 When library functions are used in calculations, at least one SPACE must be provided after the 1st bracket and before the last bracket of the function.

maths

Example:

K = SQRT (16).       Now K contains a value 4

P = trunc( '34.567').    Now P contains a value 34

 

 

Comments

Post a Comment

Popular posts from this blog

Qlikview not able to fetch all data from Multiprovider

Image
 There is a scenario which I encountered recently in my project where Qlikview was not able to see complete data from the Multiprovider from SAP BW. The Multiprovider consisted of few standard DSOs with the setting : " SID generation during Activation " and " Set Quality Status to OK automatically " checkbox checked. Thus, even though all the settings are in place, the Qlik was not able to see all the data in the raw layer.
Read more

How to extract data using BI Content Datasource in SAP BW

 This video and post is about how to extract data from SAP ECC to BW system using Business content standard Datasources. The video outlines step by step approach on how to create the data model and schedule the delta loads in the BW system. https://www.youtube.com/watch?v=Iggsfa7_eho Aim Data extraction / Acquisition from SAP R/3 ECC (OLTP) to SAP Netweaver BI (OLAP) using Business Content Datasources Tcodes SBIW, RSA9, RSA5, RSA6, RSA3, RSA7, RSA1, RSA2, RSA13, RSA14, RSDS, RSD1, RSD5, RSDCUBE, RSORBCT, RSORMDR, SE11, SE16, RSPC, RSPC1, RSPCM, RSMO, RSMON, LISTCUBE... Part I - Data Modeling Step 1: Logon to SAP R/3 ECC Step 2 : Activate / transfer application component hierarchy (need to be performed once) (RSA9 or SBIW) Step 3: Install and activate the required Datasource
Read more

How to create tables in SAP System-I

Image
 There are three ways to create a table in SAP- Using Built in type or pre-defined type Using top-down approach (Table, Table properties, fields, data elements, domains, check fields, currency fields, technical settings,...) Using bottom-up approach (data, domains, data elements, table, table properties, fields with data element assignments, technical settings) Creation of table: Master data table creation using built-in type/pre-defined type- Structure of the table
Read more