Comments

Post a Comment

Popular posts from this blog

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 , ...
Read more

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
Read more