SAPF070_NACC SAP ABAP Report - Reconcile Documents and Account Transaction Figures

SAP T-Codes / Example ABAP code
ABAP OO / SAP Function Modules
ABAP reports / SAP Error Messages
SAP Tables / SAP Video Training

SAPF070_NACC is a standard Executable ABAP Report available within your SAP system (depending on your version and release level). It is used for This program compares debit and credit transaction figures in customer, vendor, and G/L accounts with the debit and credit totals from documents posted in the corresponding posting period (accounting reconciliation)...see full standard documentation available for this report. Also check out the submitted Comments related to this SAP report and the details below to see which OBJECTS it interacts with such as TABLES, FUNCTION MODULES, INCLUDES ETC.

If you would like to execute this report or see the full code listing simply enter SAPF070_NACC 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 SAPF070_NACC. "Basic submit
SUBMIT SAPF070_NACC AND RETURN. "Return to original report after report execution complete
SUBMIT SAPF070_NACC 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: AR_READ = Read Archives
Selection Text: BR_BUKRS = Company Code
Selection Text: DB_READ = Read Database
Selection Text: DKONTO = Customer Account
Selection Text: KKONTO = Vendor Account
Selection Text: KOARD = Customer Section
Selection Text: KOARK = Vendor Section
Selection Text: KOARS = G/L Account Section
Selection Text: LIST_OLD = Use Classic List
Selection Text: LSEP = List Separation
Selection Text: PABISMON = Upper Limit
Selection Text: PAVONMON = Fiscal Periods Lower Limit
Selection Text: POPER = Fiscal Periods
Selection Text: PR_GJAHR = Fiscal Year
Selection Text: SKONTO = G/L Account
Selection Text: WAERS10 = Company Code Currency
Selection Text: WAERS11 = Comp. Code Crcy (Grp Val.)
Selection Text: WAERS12 = Comp. Code Currency (PCA Val.)
Selection Text: WAERS30 = Group Currency
Selection Text: WAERS31 = Group Crcy (Group Valuation)
Selection Text: WAERS32 = Group Currency (PCA Valuation)
Selection Text: WAERS40 = Hard Currency
Selection Text: WAERS50 = Index-Based Currency
Selection Text: WAERS60 = Global Company Currency
Title: Reconcile Documents and Account Transaction Figures
Text Symbol: 410 = Recon. in Company Code Currency
Text Symbol: 400 = Reconcil.
Text Symbol: 161 = No Data Exists
Text Symbol: 160 = Result of Reconciliation of Transaction Figures with Documents (SAPF070)
Text Symbol: 153 = Program termination due to posting during run
Text Symbol: 152 = Local currency balance; a line item may be missing
Text Symbol: 151 = Parallel local curr.: Amounts and doc. header inconsistent
Text Symbol: 150 = Local currency balance; a line item may be missing
Text Symbol: 122 = Ex.rte type empty
Text Symbol: 121 = Exch.rate type not defined in comp.code
Text Symbol: 120 = No ledger is managed for this ex.rate type
Text Symbol: 100 = Output Control
Text Symbol: 090 = Fiscal year variant incorrect in company code

Text Symbol: 089 = Selections contradict one another
Text Symbol: 068 = T Crcy FP Item Master Difference
Text Symbol: 067 = A CoCd Local FY FP Sales Sales Debit
Text Symbol: 064 = Account
Text Symbol: 411 = Reconcil. in Company Code Currency (Group Valuation)
Text Symbol: 412 = Reconcil. in Company Code Currency (Profit Center Valuation)
Text Symbol: 430 = Reconciliation in Group Crcy
Text Symbol: 431 = Reconciliatn in Group Currency (Group Valuation)
Text Symbol: 432 = Reconcil. in Group Currency (Profit Center Valuation)
Text Symbol: 440 = Reconcil. in Hard Currency
Text Symbol: 450 = Reconciliatn in Index Crcy
Text Symbol: 460 = Recon. in Global Company Currency
Text Symbol: 510 = Differences in Company Code Currency &1 for Fiscal Year &2
Text Symbol: 511 = Differences in Company Code Currency (Group Valuation) &1 for Fiscal Year &2
Text Symbol: 512 = Differences in Company Code Currency (Profit Center Valuation) &1 for Fiscal Year &2
Text Symbol: 530 = Differences in Group Currency &1 for Fiscal Year &2
Text Symbol: 531 = Differences in Group Currency (Group Valuation) &1 for Fiscal Year &2
Text Symbol: 532 = Differences in Group Currency (Profit Center Valuation) &1 for Fiscal Year &2
Text Symbol: 540 = Differences in Hard Currency &1 for Fiscal Year &2
Text Symbol: 550 = Differences in Index-Based Currency &1 for Fiscal Year &2
Text Symbol: 560 = Differences in Global Company Currency &1 for Fiscal Year &2
Text Symbol: 033 = Differences exist in the subledgers
Text Symbol: 032 = Differences arose in the General Ledger
Text Symbol: 031 = Caution! Determination of incorrect customers and vendors terminated
Text Symbol: 030 = Caution! Determination of incorrect documents terminated
Text Symbol: 029 = Documents that might be incorrect:
Text Symbol: 028 = No differences exist
Text Symbol: 026 = Accts with Differences
Text Symbol: 023 = No archive files exist
Text Symbol: 022 = Run File Number of Documents
Text Symbol: 021 = The following archiving files were considered:
Text Symbol: 020 = Company Code &, Fiscal Year &, Document Number &
Text Symbol: 019 = Run terminated since postings being made
Text Symbol: 018 = Run terminated since posting continuing! Document no.:
Text Symbol: 017 = Overview of Selected Segments:
Text Symbol: 016 = Differences exist in the following accounts:
Text Symbol: 015 = G/L Accts: Totals Across Company Code &BUKRS
Text Symbol: 014 = Vendors: Totals Across Company Code &BUKRS
Text Symbol: 013 = Customers: Totals Across Company Code&BUKRS

Text Symbol: 012 = G/L Accts: Totals Across All Company Codes
Text Symbol: 011 = Vendors: Totals Across All Company Codes
Text Symbol: 010 = Customers: Totals Across All Company Codes
Text Symbol: 008 = T Crcy FP Total Total Difference Total Total Difference
Text Symbol: 007 = A CoCd Local FY FP Debit Item Debit Master Debit Credit Item Credit Master Credit
Text Symbol: 006 = T Forgn Crcy Total Total Difference Total Total Difference
Text Symbol: 005 = A CoCd Acct No. BusA FY FP Debit Item Debit Master Debit Credit Item Crdit Master Credit
Text Symbol: 004 = G/L accts
Text Symbol: 003 = Vendors
Text Symbol: 002 = Customers
Text Symbol: 001 = Bals Master Does Not Exist
Text Symbol: 034 = Incorrect Documents Exist
Text Symbol: 063 = Curr.Diff.
Text Symbol: 062 = Currency (Differen.)
Text Symbol: 061 = Sales Dif.
Text Symbol: 060 = Sales Difference
Text Symbol: 059 = Sales Figs
Text Symbol: 058 = Sales/Purchases Items Account Difference
Text Symbol: 057 = Sale/Prchs;
Text Symbol: 056 = Sales Trans. Figures
Text Symbol: 055 = Sales Item
Text Symbol: 054 = Sales Item
Text Symbol: 053 = Cred. Dif.
Text Symbol: 052 = Credit Difference
Text Symbol: 051 = Cr.Tr.Figs
Text Symbol: 050 = Credit Transac. Figs
Text Symbol: 049 = Cred. Item
Text Symbol: 048 = Credit Items
Text Symbol: 047 = Debit Dif.
Text Symbol: 046 = Debit Difference
Text Symbol: 045 = Deb.Tr.Fig
Text Symbol: 044 = Debit Transac. Figs
Text Symbol: 043 = Debit Item
Text Symbol: 042 = Debit Items
Text Symbol: 041 = Variances
Text Symbol: 040 = No Errors
Text Symbol: 039 = &1(&2), Result: &3
Text Symbol: 038 = Sales Listing
Text Symbol: 037 = Company Code &1:

Text Symbol: 036 = Fin. Accounting Recon.
Text Symbol: 035 = Reports Exist for the Program

INCLUDES used within this REPORT SAPF070_NACC

INCLUDE RKASMAWF. " NECESSARY FOR WORKFLOW

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:

MESSAGES_INITIALIZE CALL FUNCTION 'MESSAGES_INITIALIZE' EXPORTING COLLECT_AND_SEND = COLLECT_AND_SEND I_IDENTIFICATION = MESSAGE_IDENTIFICATION IMPORTING E_IDENTIFICATION = MESSAGE_IDENTIFICATION.

MESSAGE_STORE CALL FUNCTION 'MESSAGE_STORE' "ALV EXPORTING ARBGB = 'FR' MSGTY = 'E' MSGV1 = SAPF070 TXTNR = '480'.

GET_EUROCODES_CONVERSION_40 CALL FUNCTION 'GET_EUROCODES_CONVERSION_40' IMPORTING EUROWAERS = CUR_EUR EXCEPTIONS CUSTOMIZING_NOT_CONFIRMED = 1 OTHERS = 2.

MESSAGE_STORE CALL FUNCTION 'MESSAGE_STORE' "ALV EXPORTING ARBGB = 'FR' MSGTY = 'E' MSGV1 = BELNR_FOR_MESSAGE MSGV2 = BUKRS_FOR_MESSAGE MSGV3 = GJAHR_FOR_MESSAGE TXTNR = 825. "overlapping periods

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.