Posts

Showing posts from February, 2021

CDS Views

Image
Benefits of CDS views Currency/ Unit Conversion No Semantic Gap Reusable SQL Limitations of Dictionary Views No Outer Join No Complex Joins No inline comments No Unions No View on View CDS Views WithOut Parameters With Parameters with Parameters Session Variables Aggregate functions String Functions LPAD:- in above ex. 20 is the total length, if url is less than 20 then the difference length is filled with 'x' on left side i.e at the begining.  Substring: Starting from 2nd character in url copy the next 3 characters. Currency Conversion Date Function Numeric Function Union Annotations ABAP Annotations:-  Evaluated by ABAP runTime environment. Component Annotations: Evaluated  where it is comsumed, eg OData. Annotation Element Annotation

Enhcnaced SQL

Image
  Case Statement "disbable returns which are have active audit case, @field selectable, and pre select eligible returns @a_chkbox    CONSTANTS :  lc_check       TYPE  boolean  VALUE  abap_true,                  lc_uncheck     TYPE  boolean  VALUE  abap_false,                                                lc_open        TYPE  fbsta_ps  VALUE  'IP014',                  lc_no_case     TYPE  fbsta_ps    VALUE  IS  INITIAL .    SELECT  taxpayer  AS  a_tp_tin , ...

Internal Tables

 Internal tables store data in rows and columns To Read data from internal table we need a work area. An internal table can be read by index or key.