Skip to main content

Posts

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)
Post a Comment
Read more
Recent posts

CLEARED INDICATOR CODING3

coding for Cleared indicator:- Cleared_Indicator If "AUGBL" is blank then 'Y' else 'N'
Post a Comment
Read more

PHONE OPPORTUNITY CODING2

Coding for Phone Opportunity:- Phone_Opportunity (a)  Take maximum value from "ZBD1P" and "ZBD2P" Field   (b) , Multiply it "WRBTR" © devide it by 100  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 Less  than step (d) then its 'Y' otherwise 'N'
Post a Comment
Read more

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" © devide it by 100  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'
Post a Comment
Read more

Import Data From Local Files:- DATA MAPPING IMAGE

FLIES(CVS MS-DOS) - IMPORT - (SELECT) SAP HANA CONTENT - DATA FROM LOCAL FILES - SYSTEM USER NAME(EX: BWHANA) - DEFINE IMPORT PROPERTIES - FINISH.
Post a Comment
Read more

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

Post a Comment
Read more

GENERAL LAYOUT OF PROCEDURE FOR TABLE FUNCTION.

Post a Comment
Read more