SAPFK100 SAP ABAP Report - Open item foreign currency valuation at key date
SAPFK100 is a standard Executable ABAP Report available within your SAP system (depending on your version and release level). It is used for trados = docu -> fi -> fica This report carries out the
If you would like to execute this report or see the full code listing simply enter SAPFK100 into the relevant SAP transactions such as SE38 or SE80
Transaction Code(s):
Below is a list of transaction codes which are relevant to this SAP report
FPW1 - Foreign Currency Valuation
ABAP code to call this SAP report using the submit statement
This report can be called from another progam/report simply by using the ABAP SUBMIT statement, see below for example ABAP code snipts of how to do this.
SUBMIT SAPFK100. "Basic submit
SUBMIT SAPFK100 AND RETURN. "Return to original report after report execution complete
SUBMIT SAPFK100 VIA SELECTION-SCREEN. "Display selection screen of submitted report to user
See more syntax options for the ABAP SUBMIT statement
Text pool values
Selection Text: ALVLIST = ALV Display
Selection Text: BUKRS = Company Code
Selection Text: BWMET10 = Company code currency method
Selection Text: BWMET30 = Group currency method
Selection Text: BWMET40 = Hard currency method
Selection Text: BWMET50 = Index-based currency method
Selection Text: BWMET60 = Global company currency method
Selection Text: B_INPUT = Postings requested
Selection Text: GPART = Business Partner
Selection Text: HKONT = Reconciliation account
Selection Text: LISTSEP = Separate list
Selection Text: MIKFICHE = Print microfiche line
Selection Text: NOREVERS = Do not create inverse postings
Selection Text: OPBEL = Document Number
Selection Text: P_BWV = Valuation Variant
Selection Text: P_CUCONV = Currency Conversion Desired
Selection Text: STICHTAG = Balance sheet key date
Selection Text: VKONT = Contract Account
Selection Text: WAEHRUNG = Currency Key
Selection Text: P_FIKEY = D .
Selection Text: RLDNR = D .
Title: Open item foreign currency valuation at key date
Text Symbol: HMS = Gen.Ledger BsAr Segment Profit Ctr BsAr Segment Profit Ctr Crcy FC Amount LC Amount ValuationDifference
Text Symbol: HMM = Acct Assgmt Bal.Sheet Adj. Acct Assgmt I/S Adj.
Text Symbol: HDS = G. Ledger BA Segment Crcy FC Amount LC Amount Valuation Difference
Text Symbol: HDE = Doc. Crcy Acct BA Segment G. Ledger FC Amount LC Amount of Valuation Diff. at Valu. Rate
Text Symbol: H4S = G/L BA Segment ProfitCenter Crcy FC Amount LC Amount Valuation Difference
Text Symbol: H4E = Doc. Crcy Acct BA Segment ProfitCtr G/L FC Amount LC Amount Val. Difference Val. Exch.Rate
Text Symbol: GPA = Business partner:
Text Symbol: 603 = Val.Exch.Rate
Text Symbol: 602 = Comparison Key Dte
Text Symbol: 601 = Use comparison date for valuation?
Text Symbol: 000 = General selections
Text Symbol: 002 = Error in select option: only individual values are permitted
Text Symbol: 021 = Errors occurred with the following conversions
Text Symbol: 023 = (The relevant items have been valued with the local currency amount)
Text Symbol: 024 = Type FC LC Translation date
Text Symbol: 044 = Error log:
Text Symbol: 080 = Error in account determination
Text Symbol: 101 = Postiing of Valuation Differences for &1
Text Symbol: 102 = Total Valuation for &1
Text Symbol: 103 = Valuation of Open Items for &1
Text Symbol: 240 = | Bukr | DType| PstgDate | Doc No. | Dr Acct | Cr Acct | BA | Segment | TC | Amount in LC | LC | CTyp |
Text Symbol: 241 = Postings generated
Text Symbol: 242 = Posting proposal
Text Symbol: 243 = Postings Supported
Text Symbol: 244 = | CoCd | Pst.Date | Doc. No. | DebitAcct | CreditAcct | BA | Segment | ProfitCtr | TC | Amount in LC LC | CT |
Text Symbol: 245 = | CoCd | PstgDate | Doc. No. | DebitAcct | BsAr | Segment | ProfitCtr | TC | Amount in LC | LC | CT |
Text Symbol: 246 = | | | | CreditAcct | | | | | | | |
Text Symbol: 400 = Posting valuation
Text Symbol: 410 = Valuation in company code crcy
Text Symbol: 411 = Comp. code currency
Text Symbol: 430 = Valuation in group currency
Text Symbol: 431 = Group currency
Text Symbol: 440 = Valuation in hard currency
Text Symbol: 441 = Hard currency
Text Symbol: 450 = Valuation in index-based currency
Text Symbol: 451 = Index-based currency
Text Symbol: 460 = Valuation in global comp.currency
Text Symbol: 461 = Global Company Curr.
Text Symbol: 501 = Further selections
Text Symbol: 502 = Output control
Text Symbol: 503 = Posting Parameters
Text Symbol: 600 = Valuation Acc. to Lowest Val. Prn.
INCLUDES used within this REPORT SAPFK100
INCLUDE SAPFK100TOP.
INCLUDE FK100_P01.
INCLUDE FK100_PBO.
INCLUDE FK100_PAI.
TABLES used within REPORT and the associated SELECT statement:
No SAP DATABASE tables are accessed within this REPORT code!
Function Modules used within report and the associated call statement:
FKK_GET_APPLICATION CALL FUNCTION 'FKK_GET_APPLICATION' EXPORTING i_no_dialog = 'X' IMPORTING e_applk = fkkpdo-applk.
FKK_DB_TFK044E_SINGLE CALL FUNCTION 'FKK_DB_TFK044E_SINGLE' IMPORTING e_tfk044e = l_tfk044e EXCEPTIONS no_data_found = 1 OTHERS = 2.
FKK_DB_TFK044 CALL FUNCTION 'FKK_DB_TFK044' EXPORTING i_applk = fkkpdo-applk TABLES et_tfk044 = gt_tfk044 EXCEPTIONS no_data_found = 1 no_input = 2 OTHERS = 3.
CALL FUNCTION 'GET_ACCESSIBILITY_MODE' IMPORTING accessibility = xaccessible EXCEPTIONS OTHERS = 0.
FKK_FUNC_MODULE_DETERMINE CALL FUNCTION 'FKK_FUNC_MODULE_DETERMINE' EXPORTING i_fbeve = '1113' i_applk = fkkpdo-applk TABLES t_fbstab = t_fbstab_1113 EXCEPTIONS error_message = 1.
FKK_ENHANCEMENT_STATUS_CHECK CALL FUNCTION 'FKK_ENHANCEMENT_STATUS_CHECK' EXPORTING I_TABLE = 'DFKKOP' I_FIELD = 'LDGRP' IMPORTING E_ACTIVE = X_ENH_LDGRP.
FKK_FUNC_MODULE_DETERMINE CALL FUNCTION 'FKK_FUNC_MODULE_DETERMINE' EXPORTING i_fbeve = '0119' i_applk = fkkpdo-applk TABLES t_fbstab = t_fbstab_0119 EXCEPTIONS error_message = 1.
FKK_ENHANCEMENT_STATUS_CHECK CALL FUNCTION 'FKK_ENHANCEMENT_STATUS_CHECK' EXPORTING i_table = 'DFKKOP' i_field = 'GSBER_MIG' IMPORTING e_active = x_enh_gsber_mig.
FKK_ENHANCEMENT_STATUS_CHECK CALL FUNCTION 'FKK_ENHANCEMENT_STATUS_CHECK' EXPORTING i_table = 'DFKKOP' i_field = 'SEGMT_MIG' IMPORTING e_active = x_enh_segmt_mig.
FKK_ENHANCEMENT_STATUS_CHECK CALL FUNCTION 'FKK_ENHANCEMENT_STATUS_CHECK' EXPORTING i_table = 'DFKKOP' i_field = 'PRCTR_MIG' IMPORTING e_active = x_enh_prctr_mig.
FKK_FUNC_MODULE_DETERMINE CALL FUNCTION 'FKK_FUNC_MODULE_DETERMINE' EXPORTING i_fbeve = '0945' i_applk = fkkpdo-applk TABLES t_fbstab = t_fbstab_0945 EXCEPTIONS error_message = 1.
FKK_GET_LEDGER_INFO CALL FUNCTION 'FKK_GET_LEDGER_INFO' EXPORTING I_RLDNR = rldnr IMPORTING E_LDGRP_X = ldgrp_post ET_LDGRP = ldgrptab.
FKK_FUNC_MODULE_DETERMINE CALL FUNCTION 'FKK_FUNC_MODULE_DETERMINE' EXPORTING i_fbeve = '0580' i_applk = fkkpdo-applk TABLES t_fbstab = t_fbstab EXCEPTIONS error_message = 1.
FKK_FIKEY_CHECK CALL FUNCTION 'FKK_FIKEY_CHECK' EXPORTING i_fikey = p_fikey EXCEPTIONS non_existing = 1 OTHERS = 2.
FKK_SAMPLE_1113 CALL FUNCTION 'FKK_SAMPLE_1113'.
FKK_CHECK_VALUATION_KEY_DATE CALL FUNCTION 'FKK_CHECK_VALUATION_KEY_DATE' EXPORTING i_bwdat = stichtag i_bukrs = par_bukrs i_applk = fkkpdo-applk IMPORTING e_bwdat_last = l_bwdat_last e_bwdat_next = l_bwdat_next EXCEPTIONS no_valuation_plan = 1 wrong_key_date = 2 OTHERS = 3.
FI_PERIOD_DETERMINE CALL FUNCTION 'FI_PERIOD_DETERMINE' EXPORTING I_BUDAT = stichtag I_BUKRS = par_bukrs IMPORTING E_GJAHR = lv_gjahr EXCEPTIONS FISCAL_YEAR = 1 PERIOD = 2 PERIOD_VERSION = 3 POSTING_PERIOD = 4 SPECIAL_PERIOD = 5 VERSION = 6 POSTING_DATE = 7 OTHERS = 8.
FIRST_DAY_IN_PERIOD_GET CALL FUNCTION 'FIRST_DAY_IN_PERIOD_GET' EXPORTING I_GJAHR = lv_gjahr I_PERIV = tab001-periv I_POPER = '001' IMPORTING E_DATE = gv_gjstart EXCEPTIONS INPUT_FALSE = 1 T009_NOTFOUND = 2 T009B_NOTFOUND = 3 OTHERS = 4.
POPUP_TO_CONFIRM CALL FUNCTION 'POPUP_TO_CONFIRM' EXPORTING titlebar = text-600 text_question = text-601 IMPORTING answer = answer EXCEPTIONS text_not_found = 1 OTHERS = 2.
POPUP_GET_VALUES_DB_CHECKED CALL FUNCTION 'POPUP_GET_VALUES_DB_CHECKED' EXPORTING popup_title = text-602 TABLES fields = loc_fields EXCEPTIONS error_in_fields = 1 OTHERS = 2.
FKK_SAMPLE_0945 CALL FUNCTION 'FKK_SAMPLE_0945'.
FKK_OPEN_ITEM_CHANGE_PROC_CURR CALL FUNCTION 'FKK_OPEN_ITEM_CHANGE_PROC_CURR' EXPORTING I_PROCID = '03' I_FKKOP = ls_fkkop * I_ONLY_TO_LOCAL_CURR = IMPORTING E_FKKOP_CPRC = ls_fkkop_cprc.
FKK_CLEARING_HISTORY_READ CALL FUNCTION 'FKK_CLEARING_HISTORY_READ' EXPORTING i_opbel = ls_dfkkop-opbel i_opupk = ls_dfkkop-opupk i_datum = stichtag.
FKK_CLEARING_HISTORY_APPLY CALL FUNCTION 'FKK_CLEARING_HISTORY_APPLY' EXPORTING i_key_date = stichtag CHANGING c_fkkop = ls_fkkop EXCEPTIONS no_change = 1.
FKK_SAMPLE_0580 CALL FUNCTION 'FKK_SAMPLE_0580'.
FKK_CORRECT_VBUND CALL FUNCTION 'FKK_CORRECT_VBUND' EXPORTING I_KEYDATE = stichtag IMPORTING E_X_NEW_HKONT = x_new_hkont *<< note 1657815 E_X_ERROR_ACC_DET = x_error_acc_det *>> note 1657815 TABLES IT_FKKOP = t_fkkop.
FIMA_DAYS_AND_MONTHS_AND_YEARS CALL FUNCTION 'FIMA_DAYS_AND_MONTHS_AND_YEARS' EXPORTING I_DATE_FROM = stichtag I_DATE_TO = beltab_gp-faedn IMPORTING E_MONTHS = lv_months EXCEPTIONS OTHERS = 1.
FKK_READ_FOREIGN_CURR_VAL CALL FUNCTION 'FKK_READ_FOREIGN_CURR_VAL' EXPORTING i_bwdat = vgl_dat i_curtp = curtyp i_rldnr = rldnr TABLES it_fkkcl = t_fkkcl et_fkkopbew = t_fkkopbew EXCEPTIONS not_found = 1 OTHERS = 2.
FKK_READ_FOREIGN_CURR_VAL CALL FUNCTION 'FKK_READ_FOREIGN_CURR_VAL' EXPORTING i_curtp = curtyp i_bwvar = p_bwv i_rldnr = rldnr TABLES it_fkkcl = t_fkkcl et_fkkopbew = t_fkkopbew EXCEPTIONS not_found = 1 OTHERS = 2.
FI_CURRENCY_INFORMATION CALL FUNCTION 'FI_CURRENCY_INFORMATION' EXPORTING i_bukrs = bukrs IMPORTING e_x001 = x001 EXCEPTIONS currency_2_not_defined = 1 currency_3_not_defined = 2 OTHERS = 6.
FI_CURRENCY_INFORMATION CALL FUNCTION 'FI_CURRENCY_INFORMATION' EXPORTING i_bukrs = bukrs IMPORTING e_x001 = x001 EXCEPTIONS currency_2_not_defined = 1 currency_3_not_defined = 2 OTHERS = 6.
FKK_BWMET_BWBER_DETERMINE CALL FUNCTION 'FKK_BWMET_BWBER_DETERMINE' EXPORTING i_tfk044d = l_tfk044d TABLES et_tfk044d = lt_tfk044d EXCEPTIONS no_entry = 1 wrong_input = 2 OTHERS = 3.
FKK_READ_FOREIGN_CURR_VAL_RUN CALL FUNCTION 'FKK_READ_FOREIGN_CURR_VAL_RUN' EXPORTING i_bwvar = p_bwv i_rldnr = rldnr TABLES it_bukrs = lt_bukrs it_curtp = lt_curtp et_protdat = lt_protdat EXCEPTIONS wrong_input = 1 not_found = 2 OTHERS = 3.
FKK_ACCOUNT_DETERMINE CALL FUNCTION 'FKK_ACCOUNT_DETERMINE' EXPORTING i_tfk033d = tfk033d IMPORTING e_tfk033d = tfk033d EXCEPTIONS error_message = 4 OTHERS = 4.
FKK_ACCOUNT_DETERMINE_0070 CALL FUNCTION 'FKK_ACCOUNT_DETERMINE_0070'.
FKK_ACCOUNT_DETERMINE_0071 CALL FUNCTION 'FKK_ACCOUNT_DETERMINE_0071'.
CONVERT_TO_LOCAL_CURRENCY CALL FUNCTION 'CONVERT_TO_LOCAL_CURRENCY' EXPORTING foreign_amount = f_amount foreign_currency = f_curr local_currency = h_curr type_of_rate = tcurr-kurst date = stichtag IMPORTING local_amount = par_diffb exchange_rate = loc_kursr EXCEPTIONS no_rate_found = 1 overflow = 2 no_factors_found = 3 no_spread_found = 4.
FKK_FKKKO_COMPLETE_CHECK CALL FUNCTION 'FKK_FKKKO_COMPLETE_CHECK' EXPORTING i_fkkko = fkkko i_mass_postings = 'X' EXCEPTIONS error_message = 1.
FKK_COMP_CODE_DATA CALL FUNCTION 'FKK_COMP_CODE_DATA' EXPORTING i_bukrs = buctab-bukrs IMPORTING e_t001 = t001.
FKK_FKKOPK_ADD_CO_DEFAULT_DATA CALL FUNCTION 'FKK_FKKOPK_ADD_CO_DEFAULT_DATA' EXPORTING i_fkkko = fkkko CHANGING c_fkkopk = xfkkopk EXCEPTIONS error_message = 1.
FKK_FKKOPK_COMPLETE_CHECK CALL FUNCTION 'FKK_FKKOPK_COMPLETE_CHECK' EXPORTING i_fkkko = fkkko i_fkkopk = xfkkopk EXCEPTIONS error_message = 1.
FKK_CREATE_DOC_MASS CALL FUNCTION 'FKK_CREATE_DOC_MASS' EXPORTING i_fkkko = fkkko IMPORTING e_opbel = fkkko-opbel e_fikey = fkkko-fikey TABLES t_fkkopk = xfkkopk EXCEPTIONS error_message = 1.
FKK_FIKEY_OPEN CALL FUNCTION 'FKK_FIKEY_OPEN' EXPORTING i_fikey = p_fikey.
FKK_CREATE_DOC_MASS_START CALL FUNCTION 'FKK_CREATE_DOC_MASS_START' EXPORTING i_fikey_extern = 'X'.
FKK_CREATE_DOC_MASS_STOP CALL FUNCTION 'FKK_CREATE_DOC_MASS_STOP' EXCEPTIONS error_message = 1.
FKK_FIKEY_DELETE CALL FUNCTION 'FKK_FIKEY_DELETE' EXPORTING i_fikey = p_fikey EXCEPTIONS not_found = 1 not_possible = 2 OTHERS = 3.
FI_MESSAGE_CHECK CALL FUNCTION 'FI_MESSAGE_CHECK' EXCEPTIONS no_message = 1.
FI_MESSAGE_SORT CALL FUNCTION 'FI_MESSAGE_SORT'.
FI_MESSAGE_PRINT CALL FUNCTION 'FI_MESSAGE_PRINT' EXPORTING i_msort = ' ' i_xausn = 'X' i_xeaus = ' ' i_xskip = 'X'.
FKK_FIKEY_DEQUEUE CALL FUNCTION 'FKK_FIKEY_DEQUEUE' EXPORTING i_fikey = p_fikey.
DDIF_FIELDINFO_GET CALL FUNCTION 'DDIF_FIELDINFO_GET' EXPORTING tabname = 'FKK100' TABLES dfies_tab = lt_dfies_tab EXCEPTIONS not_found = 1 internal_error = 2 OTHERS = 3.
DDIF_FIELDINFO_GET CALL FUNCTION 'DDIF_FIELDINFO_GET' EXPORTING tabname = 'FKK100_0119' TABLES dfies_tab = lt_dfies_tab_0119 EXCEPTIONS not_found = 1 internal_error = 2 OTHERS = 3.
FKK_SAVE_FOREIGN_CURR_VAL_RUN CALL FUNCTION 'FKK_SAVE_FOREIGN_CURR_VAL_RUN' EXPORTING i_store = store_modus i_rldnr = rldnr TABLES t_protdat = protdat t_beltab = beltab_neu EXCEPTIONS save_error_fwbew = 1 save_error_opbew = 2 OTHERS = 3.
HELP_OBJECT_SHOW CALL FUNCTION 'HELP_OBJECT_SHOW' EXPORTING dokclass = 'NA' dokname = name msg_var_1 = wa_liste-msgv1 msg_var_2 = wa_liste-msgv2 msg_var_3 = wa_liste-msgv3 msg_var_4 = wa_liste-msgv4 TABLES links = tline EXCEPTIONS object_not_found = 1 sapscript_error = 2 OTHERS = 3.
Contribute (Add Comments)
Although this basic information may have limited use it does provide an easy to find location to store any knowledge about this program/report.
The contribute/comments section below therefore offer's an opportunity for anyone to add additional information. This can be anything from useful hints, tips and screen shots to relevant SAP notes or anything else you feel is relevant to this report.
This will then be available for everyone to easily find by simply searching on the report name SAPFK100 or its description.
SAPFK100 - Open item foreign currency valuation at key date SAPFK100 - Open item foreign currency valuation at key date SAPFK00B - documentation and ABAP source code SAPFK00B - documentation and ABAP source code SAPFJYSD - IS-M/SD: Collection of INCLUDEs for Reps to Standard SAPFJYSD - IS-M/SD: Collection of INCLUDEs for Reps to Standard