SAP Reports / Programs
SAPF100A SAP ABAP Report - Open Item - Foreign Currency - Valuation per ........ (Old)
SAPF100A is a standard Executable ABAP Report available within your SAP system (depending on your version and release level). It is used for This program carries out the
If you would like to execute this report or see the full code listing simply enter SAPF100A into the relevant SAP transactions such as SE38 or SE80
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 SAPF100A. "Basic submit
SUBMIT SAPF100A AND RETURN. "Return to original report after report execution complete
SUBMIT SAPF100A 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: 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 (D/K/S)
Selection Text: LISTSEP = List separation requested
Selection Text: MIKFICHE = Print Microfiche Line
Selection Text: XALTKT = Alternative account number
Selection Text: WAEHRUNG = Currency key
Selection Text: TITLE = Additional heading
Selection Text: STICHTAG = Balance sheet key date
Selection Text: ST-BUPEM = Reverse posting period
Selection Text: ST-BUDAT = Reversal posting date
Selection Text: SKONTO = G/L account number
Selection Text: RESET = Reset valuation
Selection Text: P_ZBUKRS = Target company code
Selection Text: P_SSALDO = G/L accounts grouping
Selection Text: P_REMSMT = Add.posting for translation
Selection Text: P_KSALDO = Vendor grouping
Selection Text: P_DSALDO = Customer grouping
Selection Text: POST_UPD = Bal.sheet preparation valuatn
Selection Text: PA_WERE = Evaluate GR/IR account
Title: Open Item - Foreign Currency - Valuation per ........ (Old)
Text Symbol: 302 = Sequential file cannot be opened
Text Symbol: 350 = Changed recon. account for:
Text Symbol: 351 = Postings made with the original reconciliation accounts:
Text Symbol: 360 = Exceptions during posting
Text Symbol: 361 = Account number not specified
Text Symbol: 362 = Company code not specified
Text Symbol: 364 = Posting key not specified
Text Symbol: 400 = SAPF100 MODE A
Text Symbol: 401 = Data was reset
Text Symbol: 402 = Code:
Text Symbol: 409 = Valuation in
Text Symbol: 410 = Valuation in company code crcy
Text Symbol: 430 = Valuation in group currency
Text Symbol: 440 = Valuation in hard curr.
Text Symbol: 450 = Val. in index-based crcy
Text Symbol: 460 = Valuation in global comp.currency
Text Symbol: 501 = Further selections
Text Symbol: 502 = Output control
Text Symbol: 503 = Posting params
Text Symbol: 504 = Currency Type and Valuation Method
Text Symbol: 301 = File name:
Text Symbol: 107 = I BA I Crcy I OI(FC) posted I BookVal. (LC) I OI(LC) valuated I Val.difference I Old val.diff. I Posting I
Text Symbol: 106 = Purch.ord.:
Text Symbol: 101 = BA S Curr. Rate DD.MM.YY DocDate Doc.no. Itm Amount in FC BookVal. (LC) Val.amnt in LC Val.differnce
Text Symbol: 100 = CC A SD G/L no. Acct no. Description
Text Symbol: 080 = Translation preparation
Text Symbol: 075 = Valuation in Crcy Type
Text Symbol: 074 = Method
Text Symbol: 073 = Valuation in alternative valuation area
Text Symbol: 072 = Internal revaluation:
Text Symbol: 071 = Update in crcy type:
Text Symbol: 070 = Valuation Area
Text Symbol: 060 = Group def.total
Text Symbol: 044 = Error log:
Text Symbol: 023 = (The relevant items have been valued with the loc. currency amount)
Text Symbol: 021 = Error in translation. See error log.
Text Symbol: 020 = Rev. posting SAPF100
Text Symbol: 019 = FC valuation SAPF100
Text Symbol: 018 = (The required adjustment postings could not be carried out)
Text Symbol: 010 = Valuation &BELNR &BUZEI
Text Symbol: 009 = Transfer pstg &BELNR &BUZEI
Text Symbol: 008 = &BUKRS &WAERS - Valuation by &STCHG
Text Symbol: 003 = Company Code
Text Symbol: 002 = Contains following accounts:
Text Symbol: 001 = Group def.
Text Symbol: 000 = General Selections
Text Symbol: 110 = CoCd
Text Symbol: 300 = Document valuation information was saved on a sequential file
Text Symbol: 288 = Missing entries in table T030. Termination.
Text Symbol: 282 = Processing terminated
Text Symbol: 281 = Block could not be made for company code:
Text Symbol: 260 = CoCde CT S .....Acct BusA Crcy Cons. F ......Amount in LC
Text Symbol: 259 = List of postings to be made
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 not successful. Batch input created
Text Symbol: 246 = No documents were changed.
Text Symbol: 245 = The valuation was updated in the documents. No. of documents:
Text Symbol: 244 = For translation
Text Symbol: 243 = Name of batch input session generated is:
Text Symbol: 242 = Posting proposal
Text Symbol: 241 = Postings generated
Text Symbol: 240 = I CoCd I Pst.date I Doc. no. I Debit acct I Credit act I BusA PartNo I Crcy I Amount in LC I LCrcy I
Text Symbol: 210 = &BUKRS &WAERS - Cleared items real. exch. rate diff. new
Text Symbol: 209 = &BUKRS &WAERS - Cleared items real. exch. rate diff. revers
Text Symbol: 208 = &BUKRS &WAERS - Cleared items exchange rate diff. valuation
Text Symbol: 151 = CoCd Tp S Account BusA Crcy Cons. T Amount OK
Text Symbol: 150 = Following postings are carried out
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
Text Symbol: 113 = Method:
Text Symbol: 112 = CoCd R
Text Symbol: 111 = CoCd R SD G/L no. Description
INCLUDES used within this REPORT SAPF100A
No INCLUDES are used within this REPORT code!
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:
BUKRS_AUTHORITY_CHECK CALL FUNCTION 'BUKRS_AUTHORITY_CHECK' EXPORTING XDATABASE = 'B' TABLES XBUKREIS = BUKRS.
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'.
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.
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.
DDUT_DOMVALUES_GET CALL FUNCTION 'DDUT_DOMVALUES_GET' EXPORTING NAME = DCOBJDEF-NAME LANGU = SY-LANGU * TEXTS_ONLY = ' ' TABLES DD07V_TAB = TDD07V EXCEPTIONS ILLEGAL_INPUT = 1 OTHERS = 2.
FI_CURRENCY_INFORMATION CALL FUNCTION 'FI_CURRENCY_INFORMATION' EXPORTING I_BUKRS = I_BUKRS IMPORTING E_X001 = X001 EXCEPTIONS CURRENCY_2_NOT_DEFINED = 1 CURRENCY_3_NOT_DEFINED = 2 OTHERS = 6.
CONVERT_TO_LOCAL_CURRENCY CALL FUNCTION 'CONVERT_TO_LOCAL_CURRENCY' EXPORTING FOREIGN_AMOUNT = S_GBETR FOREIGN_CURRENCY = S_WAERS LOCAL_CURRENCY = T_WAERS TYPE_OF_RATE = TCURR-KURST DATE = STICHTAG RATE = BSEG-KURSR "gesicherter k.
CONVERT_TO_LOCAL_CURRENCY CALL FUNCTION 'CONVERT_TO_LOCAL_CURRENCY' EXPORTING FOREIGN_AMOUNT = UWRSHB FOREIGN_CURRENCY = S_WAERS LOCAL_CURRENCY = T_WAERS TYPE_OF_RATE = TCURR-KURST DATE = STICHTAG IMPORTING LOCAL_AMOUNT = BSALDFW EXCHANGE_RATE = S_KURSR "verw.Kurs
FI_MESSAGE_COLLECT CALL FUNCTION 'FI_MESSAGE_COLLECT' EXPORTING I_FIMSG = FIMSG I_XAPPN = ' ' EXCEPTIONS MSGID_MISSING = 01 MSGNO_MISSING = 02 MSGTY_MISSING = 03.
OPEN_FI_PERFORM_00005010_P call function 'OPEN_FI_PERFORM_00005010_P' exporting i_chgtype = 'U' i_origin = 'SAPF100A UPDATE' i_tabname = 'BSID' i_where_bukrs = bseg-bukrs i_where_kunnr = bseg-kunnr i_where_umsks = bseg-umsks i_where_umskz = bseg-umskz i_where_augdt = bseg-augdt i_where_augbl = bseg-augbl i_where_zuonr = bseg-zuonr i_where_gjahr = bseg-gjahr i_where_belnr = bseg-belnr i_where_buzei = bseg-buzei exceptions others = 0.
OPEN_FI_PERFORM_00005010_P call function 'OPEN_FI_PERFORM_00005010_P' exporting i_chgtype = 'U' i_origin = 'SAPF100A UPDATE' i_tabname = 'BSAD' i_where_bukrs = bseg-bukrs i_where_kunnr = bseg-kunnr i_where_umsks = bseg-umsks i_where_umskz = bseg-umskz i_where_augdt = bseg-augdt i_where_augbl = bseg-augbl i_where_zuonr = bseg-zuonr i_where_gjahr = bseg-gjahr i_where_belnr = bseg-belnr i_where_buzei = bseg-buzei exceptions others = 0.
OPEN_FI_PERFORM_00005010_P call function 'OPEN_FI_PERFORM_00005010_P' exporting i_chgtype = 'U' i_origin = 'SAPF100A UPDATE' i_tabname = 'BSIK' i_where_bukrs = bseg-bukrs i_where_lifnr = bseg-lifnr i_where_umsks = bseg-umsks i_where_umskz = bseg-umskz i_where_augdt = bseg-augdt i_where_augbl = bseg-augbl i_where_zuonr = bseg-zuonr i_where_gjahr = bseg-gjahr i_where_belnr = bseg-belnr i_where_buzei = bseg-buzei exceptions others = 0.
OPEN_FI_PERFORM_00005010_P call function 'OPEN_FI_PERFORM_00005010_P' exporting i_chgtype = 'U' i_origin = 'SAPF100A UPDATE' i_tabname = 'BSAK' i_where_bukrs = bseg-bukrs i_where_lifnr = bseg-lifnr i_where_umsks = bseg-umsks i_where_umskz = bseg-umskz i_where_augdt = bseg-augdt i_where_augbl = bseg-augbl i_where_zuonr = bseg-zuonr i_where_gjahr = bseg-gjahr i_where_belnr = bseg-belnr i_where_buzei = bseg-buzei exceptions others = 0.
FI_CURRENCY_INFORMATION CALL FUNCTION 'FI_CURRENCY_INFORMATION' EXPORTING I_BUKRS = BKPF-BUKRS IMPORTING E_X001 = X001 EXCEPTIONS OTHERS = 1.
CONVERT_TO_FOREIGN_CURRENCY * call function 'CONVERT_TO_FOREIGN_CURRENCY' * exporting local_amount = bseg-dmbtr * foreign_currency = ekko-waers * local_currency = bkpf-waers * rate = ekko-wkurs * date = bkpf-budat * importing foreign_amount = bseg-wrbtr * exceptions no_rate_found = 1 * others = 1.
ME_READ_HISTORY CALL FUNCTION 'ME_READ_HISTORY' EXPORTING EBELN = BSEG-EBELN EBELP = BSEG-EBELP WEBRE = 'E' TABLES XEKBE = X_EKBE XEKBES = X_EKBES XEKBEZ = X_EKBEZ XEKBNK = X_EKBNK XEKBZ = X_EKBZ EXCEPTIONS OTHERS = 4.
FI_CURRENCY_INFORMATION CALL FUNCTION 'FI_CURRENCY_INFORMATION' EXPORTING I_BUKRS = BKPF-BUKRS IMPORTING E_X001 = X001 EXCEPTIONS OTHERS = 1.
CONVERT_TO_FOREIGN_CURRENCY CALL FUNCTION 'CONVERT_TO_FOREIGN_CURRENCY' EXPORTING LOCAL_AMOUNT = BSEG-DMBTR FOREIGN_CURRENCY = EKKO-WAERS LOCAL_CURRENCY = T001-WAERS TYPE_OF_RATE = T003-KURST RATE = EKKO-WKURS DATE = BKPF-BUDAT IMPORTING FOREIGN_AMOUNT = BSEG-WRBTR EXCEPTIONS NO_RATE_FOUND = 1 OTHERS = 1.
READ_SACHKONTO_ALTKT CALL FUNCTION 'READ_SACHKONTO_ALTKT' EXPORTING BUKRS = BELEGE-BUKRS SAKNR = MEMBERS-HKONT XTEXT = 'X' IMPORTING ALTKT = SKB1-ALTKT LTEXT = SKAT-TXT50 EXCEPTIONS OTHERS = 4.
READ_SACHKONTO_ALTKT CALL FUNCTION 'READ_SACHKONTO_ALTKT' EXPORTING BUKRS = BUKRS SAKNR = KONTO SPRAS = SY-LANGU XMASS = 'X' XSKAN = 'X' XTEXT = ' ' IMPORTING ALTKT = SKB1-ALTKT ALTKT_SAKAN = ERGEBNIS ALTKT_NOT_FOUND = ALTKT_NOT_FOUND * TEXT_NOT_FOUND = TEXT_NOT_FOUND * LTEXT = * KTEXT = EXCEPTIONS BUKRS_NOT_FOUND = 02 SAKNR_NOT_FOUND = 03.
FI_MESSAGE_COLLECT CALL FUNCTION 'FI_MESSAGE_COLLECT' EXPORTING I_FIMSG = FIMSG I_XAPPN = ' ' EXCEPTIONS MSGID_MISSING = 01 MSGNO_MISSING = 02 MSGTY_MISSING = 03.
FI_MESSAGE_COLLECT CALL FUNCTION 'FI_MESSAGE_COLLECT' EXPORTING I_FIMSG = FIMSG I_XAPPN = ' ' EXCEPTIONS MSGID_MISSING = 01 MSGNO_MISSING = 02 MSGTY_MISSING = 03.
FI_MESSAGE_COLLECT CALL FUNCTION 'FI_MESSAGE_COLLECT' EXPORTING I_FIMSG = FIMSG I_XAPPN = ' ' EXCEPTIONS MSGID_MISSING = 01 MSGNO_MISSING = 02 MSGTY_MISSING = 03.
POSTING_INTERFACE_START CALL FUNCTION 'POSTING_INTERFACE_START' EXPORTING I_FUNCTION = FUNC I_GROUP = B_MAPPE I_KEEP = 'X' I_MODE = MODE I_USER = USER * create batch input when update mode and error occurs I_XBDCC = POST_UPD EXCEPTIONS ERROR_MESSAGE = 1 OTHERS = 6.
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 ERROR_MESSAGE = 9 OTHERS = 9.
FI_MESSAGE_COLLECT CALL FUNCTION 'FI_MESSAGE_COLLECT' EXPORTING I_FIMSG = FIMSG I_XAPPN = 'X' EXCEPTIONS MSGID_MISSING = 01 MSGNO_MISSING = 02 MSGTY_MISSING = 03.
CONVERT_TO_LOCAL_CURRENCY CALL FUNCTION 'CONVERT_TO_LOCAL_CURRENCY' EXPORTING FOREIGN_AMOUNT = IBUCHUNG-BUBETR FOREIGN_CURRENCY = IBUCHUNG-HWAER LOCAL_CURRENCY = IBUCHUNG-HWAER2 TYPE_OF_RATE = TCURR-KURST DATE = STICHTAG IMPORTING LOCAL_AMOUNT = IBUCHUNG-DMBTR2 EXCEPTIONS ERROR_MESSAGE = 1 OTHERS = 2.
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.
FI_MESSAGE_COLLECT CALL FUNCTION 'FI_MESSAGE_COLLECT' EXPORTING I_FIMSG = FIMSG I_XAPPN = ' ' EXCEPTIONS OTHERS = 01.
FILE_VALIDATE_NAME CALL FUNCTION 'FILE_VALIDATE_NAME' EXPORTING logical_filename = gc_filename parameter_1 = sy-repid parameter_2 = stichtag CHANGING physical_filename = filename EXCEPTIONS OTHERS = 1.
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 SAPF100A or its description.
SAPF100A - Open Item - Foreign Currency - Valuation per ........ (Old) SAPF100A - Open Item - Foreign Currency - Valuation per ........ (Old) SAPF100 - Foreign Currency Valuation SAPF100 - Foreign Currency Valuation SAPF0_VC_AAACC_OBJ - Forms for Viewcluster VC_AAACC_OBJ SAPF0_VC_AAACC_OBJ - Forms for Viewcluster VC_AAACC_OBJ