Function Modules for Format Date, Month Name and Quarter value.
Hi All, 1. I am getting the date field from the Flatfile, so i need to format the date to YYYYMMDD. Is there any Function module for that in BW. 2. Based on the above Formated Date i have to find out the Name of the Month like JANUARY, FEBUARY etc. 3. Based on the same above Formated Date i need to find out the Quarter like 1, 2 etc. Could you please let me know if any function modules are there for the above questions in BW not in ABAP, why i mention is some Function modules are there in ABAP but not in BW. Thanks in advance. Regards, srinivas
1.If your input date format is MMDDYYYY then Use SDATE as conversion routine in trans strucutre to convert into YYYYMMDD.
2.By passing year as input parameter for the following FM you would get all the months with text.Using READ statement in routine you can get month name
3.For Quarters you can use the following FM:
hope it helps...
Hi, Can somebody tell me whether there is any function module for determining the Discount Date (DATS) and Payment Due Date(DATS) based on Payment Terms (ZTERM)? Thanks, John.FI_FIND_PAYMENT_CONDITIONS DETERMINE_DUE_DATERead other 2 answers
Hi, I have created a generic data source ZMATERIAL in which i have selected the Extraction by Function module. I copied the function module RSAX_BIW_GET_DATA_SIMPL to ZMATERIAL_FM, but when i activate this module it gives me error REPORT/PROGRAM stat
Is there any function module for getting data from Microsoft Word document? I had tried 'GUI_UPLOAD' but some data could not be recognized. Probably because of format in Microsoft Word.Hi use this fun module LXE_SP_MSWORD_TO_ITF and convert from MS w
Hi All, Is there any function module for creating and changing Functional Location BOM and Equipment BOM ???Hi, Tables for Eq., BOM: EQST, STKO, STPO. Tables fro Fun., Loc., BOM: TPST, STKO, STPO. You can use FMs: CS_BOM_EXPL_TPL_V1, CS_BOM_EXPL_EQU_
Hi , please suggest the function module for (monat) Fiscal period. our reqirement is default to previous accounting period from the current month. Thnks SrinivasHi, Refer to the following code: DATA: LV_FISCAL_YEAR_VAR(2) TYPE C, LV_PERIOD
Please tell me Functional module for Getting Material classification data like class type , class, characteristics and characteristics values for material.Dear, FM: CLAF_CLASSIFICATION_OF_OBJECTS Table KLAH Class Header Data - KSML Characteristics of
Can anybody say what is the function module used to convert the format of the date which is taken from excel sheet to the sap format. If so pls tell me how to use that function module.Currently my date is getting printed in format 05262005. I want th
function module to convert date format from yyyymmdd to mmddyyyy formatHi Rajitha, Do like this Data: Var1 type sy-datum, var2(8) type c. var1 = sy-datum. Concatanate var1+4(2) var1+6(2) var1+0(4) into var2. write var2. Reward Points if this
Hi Friends I am developing an object which has to create the sales order, delivery for that sales order and billing for it at the same time. I have tried for few function modules to create the delivery and billing but I am not able to achieve. Would
Hi, I want to know the function modules for the following purposes. 1) Check whether a date is valid or not 2) Calculate the no of days between two dates. Expecting an early response. Thanks n Regards, AmitHi, PARAMETERS: p_list LIKE t009b-bumon AS L
Hi all, Is there any Z function modules for OLE, which will download the data directly to Excel with 2 sheets. Regards, ShaliniHi Shalini Reddy there is no FM but code is there... u can see... *& Report YOLE_FOR_EXCEL REPORT yole_for_excel. *REPOR
Hi Experts, Anyone Plz tell the steps how to create a ENQUEUE function module for the table s567. Its somewht urgent, plz help me. <REMOVED BY MODERATOR> Mohana Edited by: Alvaro Tejada Galindo on Mar 10, 2008 4:21 PMHi, You can create a lock on a o
hi, I have developed a custom function module for processing inbound idoc for creating material using bdc...the problem is that when i am trying to test my idoc using we19 and calling my function module in debug mode an error is displayed showing 'in
Hi all, We're planning to use the functionality of individual work for our customer. And we're planning to use custom screens rather than GUI for creation, maintenance, deletion etc - as GUI screens seem to have some bugs (especially when you try to
Hi, commonly I read the data from tables and calculate the open quantity for sales order and purchase order, but I want to know, are there any standard function modules for getting the list of open "purchase order" and "sales order" re
hi friends i am working on Inbound IDOC interface where in which i am creating a function module for that, in which based on the idoc received , the interface has to choose the file from the shared folder and it has to move its contents to an interna
Dear ABAPers, I have created the Inbound Delivery in VL01N Transaction.I want to create the Post goods issue for the Delivery number.What is the Function module for the Post goods issue for the Delivery number and what all the Parameter needs
Hello all, I wonder, if there is any SAP function module for following query: We have got a custom program, which evaluates cost centers. We would like to evaluate a cost center group, like it is available within the report painter - the output scree