MISSED OPPORTUNITY CODING1

Coding for Missed opportunity:-

Below Indicators Required in Report

Missed_Oppotunity:

(a) Take maximum value from "ZBD1P" and "ZBD2P" Field

(b) , Multiply it "WRBTR"

Round down the above three step calculation till two decimal Points.

(d) Take maximum value from "SKNTO " And "WSKTO"

Now if calculation of (a) , (b) ,© part is greater than step (d) then its 'Y' otherwise 'N'

Comments

SQL DATA TYPE

More importantly, the major HANA SQL data types you need to know to work on a real project. These will be enough for most of the scenarios you face. It mainly Effectes on the real time project as on the basis of the views we are creating.

How to convert SQL SCRIPT TO GRAPHICAL CALCULATION VIEW in "SAP HANA SP12"

PAYMENT DUE DATE CODING4

Coding for Payment Due Date :- 1}Create two new fields by using below Logic: 2} (1) Payment_due_date = if "SHKZG" ='S' then Date(ZFBDT) , else add days between Date(ZFBDT) and int(ZBD1T)

SAP HANA

Search This Blog