SAP Reports / Programs | Financials | Financial Supply Chain Management | Transaction Manager(FIN-FSCM-TRM-TM) SAP FIN
SAPF109 SAP ABAP Report - OI Foreign Currency Valuation per DD.MM.YY
SAPF109 is a standard Executable ABAP Report available within your SAP system (depending on your version and release level). Below is the basic information available for this SAP report including which OBJECTS it interacts with such as TABLES, FUNCTION MODULES, INCLUDES ETC. Also check out the submitted Comments related to this SAP report or see any standard documentation available.
If you would like to execute this report or see the full code listing simply enter SAPF109 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
TB.5 - FC valuation of hedged documents
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 SAPF109. "Basic submit
SUBMIT SAPF109 AND RETURN. "Return to original report after report execution complete
SUBMIT SAPF109 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: AKONTO = Reconciliation Account Number
Selection Text: B-BUDAT = Posting Date of the Posting
Selection Text: B-BUPEM = Posting Period
Selection Text: B-INPUT = Postings Requested
Selection Text: BELNR = Document Number
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 Currency Method
Selection Text: BWMET60 = Global Company Currency Method
Selection Text: B_MAPPE = Postings in Batch Inp.Session
Selection Text: DKONTO = Customer Account Number
Selection Text: DK_UMSKZ = Customer Special G/L
Selection Text: FILENAME = File Name
Selection Text: KKONTO = Vendor Account Number
Selection Text: KK_UMSKZ = Vendor Special G/L
Selection Text: KONTOART = Account Type (C/V/GL)
Selection Text: KORRLAUF = Adjustment Run
Selection Text: LISTSEP = Separate List
Selection Text: MIKFICHE = Print Microfiche Line
Selection Text: PA_WERE = Evaluate GR/IR Account
Selection Text: POST_UPD = Bal.Sheet Preparation Valuatn
Selection Text: P_CDONLY = Only Value Hedged Documents
Selection Text: SKONTO = G/L Account Number
Selection Text: ST-BUDAT = Reverse Posting Date
Selection Text: ST-BUPEM = Reverse Posting Period
Selection Text: STICHTAG = Balance Sheet Key Date
Selection Text: S_DATUM = Hedged On
Selection Text: TITLE = Additional Heading
Selection Text: WAEHRUNG = Currency Key
Selection Text: XALTKT = Alternative Account Number
Title: OI Foreign Currency Valuation per DD.MM.YY
Text Symbol: M02 = but for parameter 'only value hedged documents', this is a prerequisite
Text Symbol: M01 = 'Use hedging' is not set for valuation method &BWM,
Text Symbol: KRS = Hedging
Text Symbol: 503 = Posting Parameters
Text Symbol: 502 = Output Control
Text Symbol: 501 = Further Selections
Text Symbol: 460 = Valuation in global comp.currency
Text Symbol: 450 = Valuation in index-based currency
Text Symbol: 440 = Valuation in hard currency
Text Symbol: 430 = Valuation in group currency
Text Symbol: 410 = Valuation in company code crcy
Text Symbol: 409 = Valuation in &
Text Symbol: 405 = Local Crcy &NO: &WAERS
Text Symbol: 403 =
Text Symbol: 402 = Code:
Text Symbol: 401 = Error occurred during posting
Text Symbol: 400 = SAPF100 MODE A
Text Symbol: 112 = CoCd R
Text Symbol: 111 = CoCd R SD G/L no. Description
Text Symbol: 110 = CoCd
Text Symbol: 107 = I BA I Crcy I OI(FC) posted I BookVal. (LC) I OI(LC) evaluated I Val.difference I Old val.diff. I Posting I
Text Symbol: 106 = Purch.Order:
Text Symbol: 101 = BA S Crcy Rate DD.MM.YY DocDate Doc.no. Itm Amount in FC BookVal. (LC) Val.amnt in LC Val.difference
Text Symbol: 100 = CC A SD G/L no. Acct no. Description
Text Symbol: 080 = Following entries do not exist in table T030D:
Text Symbol: 060 = Group Definition Total
Text Symbol: 051 = Not Hedged
Text Symbol: 050 = Hedged
Text Symbol: 044 = Error Log:
Text Symbol: 036 = session.
Text Symbol: 035 = Adjustment postings have been entered in the batch input
Text Symbol: 027 = Following entries from table T030 do not exist:
Text Symbol: 023 = (The relevant items have been valued with the local currency amount)
Text Symbol: 021 = Following exchange rate entries (table TCURR) do not exist
Text Symbol: 020 = Reverse Posting SAPF100
Text Symbol: 019 = FC Valuation SAPF100
Text Symbol: 018 = (The required adjustment postings could not be carried out)
Text Symbol: 017 = Following entries from table T030D do not exist:
Text Symbol: 009 = Transfer Posting
Text Symbol: 008 = &WAERS - Valuation by &STCHG
Text Symbol: 000 = General Selections
Text Symbol: 113 = Method:
Text Symbol: 351 = Postings made with the original reconciliation accounts:
Text Symbol: 350 = Changed recon. account for:
Text Symbol: 302 = Sequential file cannot be opened
Text Symbol: 301 = The name of the file is:
Text Symbol: 300 = Document valuation information was saved on a sequential file
Text Symbol: 291 = Adjustment Run
Text Symbol: 288 = Missing entries in table T030. Termination.
Text Symbol: 282 = Processing terminated
Text Symbol: 281 = Block could not be carried out for company code:
Text Symbol: 252 = CoCd G/L BusA Crcy Amount in local crcy
Text Symbol: 251 = Posting not successful. Manual transfer posting required
Text Symbol: 250 = Posting after document update was not successful. Correction run necessary:
Text Symbol: 246 = No documents were changed.
Text Symbol: 245 = The valuation was updated in the documents. Number of documents:
Text Symbol: 243 = The name of the batch input session generated is:
Text Symbol: 242 = Posting Proposal
Text Symbol: 241 = Postings Generated
Text Symbol: 240 = I CoCd I PstDate I Doc.no. I Debit acct I Cred.acct I BusA I Crcy I Amount in LC I LCrcy I I
Text Symbol: 220 = --- General Parameters --------------------------------------------------------
Text Symbol: 210 = --- Posting Parameters --------------------------------------------------------
Text Symbol: 208 = &WAERS - Cleared Line Items
Text Symbol: 151 = CoCd Tp S Account BusA Crcy Cons. T Amount OK
Text Symbol: 150 = Method:
Text Symbol: 117 = I CoCd I BA I Crcy I OI(FC) posted I BookVal. (LC) I OI(LC) evaluat.I Val.difference I Old val. diff. I Posting I
INCLUDES used within this REPORT SAPF109
INCLUDE SAPF10DD.
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:
TB_PROGRESS_INDICATOR CALL FUNCTION 'TB_PROGRESS_INDICATOR' EXPORTING ID = 'SELECTION' EXCEPTIONS OTHERS = 0.
READ_HAUPTBUCH CALL FUNCTION 'READ_HAUPTBUCH' EXPORTING BUCHUNGSKREIS = BSIS-BUKRS SACHKONTO = BSIS-HKONT IMPORTING SACHKONTO_WA = SKB1.
READ_HAUPTBUCH CALL FUNCTION 'READ_HAUPTBUCH' EXPORTING BUCHUNGSKREIS = BSIS-BUKRS SACHKONTO = BSIS-HKONT IMPORTING SACHKONTO_WA = SKB1.
TB_PROGRESS_INDICATOR CALL FUNCTION 'TB_PROGRESS_INDICATOR' EXPORTING ID = 'OUTPUT' EXCEPTIONS OTHERS = 0.
READ_SACHKONTO_ALTKT CALL FUNCTION 'READ_SACHKONTO_ALTKT' EXPORTING BUKRS = BELEGE-BUKRS SAKNR = BSEG-HKONT XTEXT = 'X' IMPORTING ALTKT = SKB1-ALTKT LTEXT = SKAT-TXT50 EXCEPTIONS OTHERS = 4.
POSTING_INTERFACE_END CALL FUNCTION 'POSTING_INTERFACE_END'.
FI_MESSAGE_CHECK CALL FUNCTION 'FI_MESSAGE_CHECK' EXCEPTIONS NO_MESSAGE = 04.
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'.
TB_COVR_FI_DOCUMENT_CHECK CALL FUNCTION 'TB_COVR_FI_DOCUMENT_CHECK' EXPORTING IMP_BELNR = BELEGE-BELNR IMP_BUKRS = BELEGE-BUKRS IMP_BUZEI = BELEGE-BUZEI IMP_GJAHR = BELEGE-GJAHR IMPORTING EXP_COVERED_AMOUNT = BELEGE-GBETR * exp_covered_rate = EXP_COVERED_AMOUNT_SIGN = VZ_GBETR * exp_covered_loc_amount = * exp_covered_loc_sign = * tables * EXP_VTBSIZU = * EXP_VTBSI = EXCEPTIONS DOCUMENT_NOT_ALLOCATED = 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 * wrong_company = 3 * wrong_country = 4 * wrong_global_company = 5 OTHERS = 3.
ENQUEUE_EFT001EX CALL FUNCTION 'ENQUEUE_EFT001EX' EXPORTING MANDT = SY-MANDT BUKRS = T001-BUKRS _SCOPE = '1' EXCEPTIONS FOREIGN_LOCK = 1 SYSTEM_FAILURE = 2 OTHERS = 2.
DEQUEUE_EFT001EX CALL FUNCTION 'DEQUEUE_EFT001EX' EXPORTING MANDT = SY-MANDT BUKRS = T001-BUKRS.
POSTING_INTERFACE_START CALL FUNCTION 'POSTING_INTERFACE_START' EXPORTING I_FUNCTION = FUNC I_GROUP = B_MAPPE * I_HOLDDATE = DATUM ?? I_MODE = MODE I_USER = USER.
POSTING_INTERFACE_DOCUMENT CALL FUNCTION 'POSTING_INTERFACE_DOCUMENT' EXPORTING I_TCODE = 'FBB1' IMPORTING E_SUBRC = SUBRC E_MSGID = SY-MSGID E_MSGTY = SY-MSGTY E_MSGNO = SY-MSGNO E_MSGV1 = SY-MSGV1 E_MSGV2 = SY-MSGV2 E_MSGV3 = SY-MSGV3 E_MSGV4 = SY-MSGV4 TABLES T_FTPOST = FTPOST T_BLNTAB = XBLNTAB T_FTTAX = XFTTAX EXCEPTIONS OTHERS = 4.
FI_FIELD_SELECTION_DETERMINE CALL FUNCTION 'FI_FIELD_SELECTION_DETERMINE' EXPORTING I_BSCHL = PA_BUSCHL I_BUKRS = PA_BUKRS I_SAKNR = PA_SAKNR IMPORTING E_FAUS1 = TBSL-FAUS1 E_FAUS2 = TBSL-FAUS2 EXCEPTIONS CUSTOMIZING = 1 OTHERS = 2.
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 SAPF109 or its description.
SAPF109 - OI Foreign Currency Valuation per DD.MM.YY SAPF109 - OI Foreign Currency Valuation per DD.MM.YY SAPF107_START - Start SAPF107 as a Report SAPF107_START - Start SAPF107 as a Report SAPF107V - FI Valuation Program (Individual Value Adjustment Discounting) SAPF107V - FI Valuation Program (Individual Value Adjustment Discounting)