Function Modules for Format Date, Month Name and Quarter value.

Advertisement
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
Advertisement

Replay

Hi ,
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
MONTH_NAMES_GET
3.For Quarters you can use the following FM:
TSTR_PERIODS_QUARTERS
hope it helps...
regards,
Raju

Function Module for Discount Date

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

Error while activation Function module for generic data extraction

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

FUNCTION MODULE FOR MICROSOFT WORD

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

Function Module for creating Functional Location BOM and Equipment BOM

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_

Function module for  Fiscal period ( monat field name)

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

Functional module for Getting Material classification data.

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

Function module to conver date to internal format

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 format

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

Function module for Delivery and billing based on sales order

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

Function modules for the following

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

Z function modules for OLE

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

How to create ENQUEUE function module for s567 table

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

Error in function module  for inbound processingwhile testing from we19

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

Function modules for Individual Work maintenance

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

Function module for BSEG table

Hi Guru's,   SELECT bukrs          belnr          gjahr          budat          monat          waers          awkey     FROM bkpf     INTO TABLE i_bkpf_data     WHERE  bukrs EQ pa_bukrs AND            budat IN so_budat. SORT i_bkpf_data BY bukrs beln

Function Module for open Purchase Order & Sales Order?

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

Function module for uploading file in background

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

Function module for the Inbound Delivery

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

Function module for custom report for cost center group

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