I need to derive below columns(marked in yellow) based on Reserve Quantity and Transaction Quantity. Records are Sorted based on Transaction Date and calculations has to be repeated for every material.
Here is the Sample Data.
1. Previous Res...
Hi Experts,How can we access the data in RealTime (i.e. Real Time Reporting) in BW4HANA without using any Enterprise HANA objects(HANA Views) but using only BW objectsAs per I know, BW4HANA supports only ADSO, Info Objects, Composite Providers and Op...
Hi Experts,I am applying filter on a column using a input parameters but facing an error as shown belowFilter condition: if('$$In_Opr_System_Status$$' !='*',in("SYS_STATUS",'$$In_Opr_System_Status$$'), match("SYS_STATUS",'$$In_Opr_System_Status$$') ...
Hi Experts,I have a requirement to populate the row number for the data set that comes out of the graphical CVAssume that output of the CV will be as shown belowCompanyCodeGLAccountFiscalYearMeasure1US99500082015200US99603472015140US99503472015666US9...
Hi Experts,I have created a FM based generic DataSource to fetch data same as TCode: MD04. I have used the BAPI_MATERIAL_STOCK_REQ_LIST inside the FM to get MD04 data.Issue is I am not getting values for Sell By Date and Expiration Date which we can ...
Hi Lars,Thank you for your inputs. Since records need to be processed row by row, would not it be performance intensive to insert record by record into DB table compared to inserting into a table variable/temp table? Also to avoid partial inert into ...
Hi,I assume you are looking for an option to automatically populate unique IDs in an existing column,please refer this blog IDENTITY column in SAP HANAThanks
Hi Sreekanth,I tested it and found that, ADD_MONTHS_LAST will provide last day of the month(next month/previous month) only if the input date is last day of the month, else ADD_MONTHS_LAST will behave same as ADD_MONTHSRegards,Nag
