SAP Reports / Programs | Financial Accounting | General Ledger Accounting | Information System(FI-GL-IS) SAP FI
SAPF101A SAP ABAP Report - Balance Sheet Supplement - OI - Analysis by ........ (Old)
SAPF101A is a standard Executable ABAP Report available within your SAP system (depending on your version and release level). It is used for This program displays receivables and payables in the following order in accordance with EU guideline 4...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 SAPF101A 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 SAPF101A. "Basic submit
SUBMIT SAPF101A AND RETURN. "Return to original report after report execution complete
SUBMIT SAPF101A 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-BLART = Posting document type
Selection Text: B-BUDAT = Posting date of the posting
Selection Text: B-BUPEM = Posting period
Selection Text: B-INPUT = Batch input session required
Selection Text: B-NAME = Session name
Selection Text: BELNR = Document number
Selection Text: BUKRS = Company code
Selection Text: DKONTO = Customer account number
Selection Text: GESBER = Business area
Selection Text: INV_KZ = Display investments
Selection Text: INV_ONLY = Only select investments
Selection Text: KKONTO = Vendor account number
Selection Text: KONTOART = Account Type (D/K/S)
Selection Text: LISTSEP = List separation requested
Selection Text: MIKFICHE = Print Microfiche Line
Selection Text: P_BWBER = Valuations
Selection Text: P_CURTP1 = Valuation in curr.type
Selection Text: XALTKT = Alternative account number
Selection Text: WV_BWERT = Bill/exchange usage indicator
Selection Text: VERBUND = Trading partner
Selection Text: VD-STUF1 = Print cust/vendor accounts
Selection Text: VD-STUF0 = Print individual documents
Selection Text: UMSATZKZ = Special G/L indicator
Selection Text: UMBWM = Use valuations
Selection Text: TITLE = Additional heading
Selection Text: ST_BLART = Reversal document type
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: P_ZBUKRS = Target Company Code
Selection Text: P_SSALDO = G/L accounts grouping
Selection Text: P_KSALDO = Vendor grouping
Selection Text: P_DSALDO = Customer grouping
Title: Balance Sheet Supplement - OI - Analysis by ........ (Old)
Text Symbol: 257 = Vend.Cust.RLf 1-5
Text Symbol: 258 = Vend.Cust.RLf >5
Text Symbol: 259 = Cust.rec.RLf >1
Text Symbol: 260 = Cust.Vend.RLf <1
Text Symbol: 261 = Cust.Vend.RLf >1
Text Symbol: 262 = -Rvrse--
Text Symbol: 263 = Changed rec.acct
Text Symbol: 264 = Inv. Trnsfr Pstng
Text Symbol: 310 = In local currency
Text Symbol: 330 = In group currency
Text Symbol: 340 = In hard currency
Text Symbol: 350 = In company currency
Text Symbol: 360 = In index-based currency
Text Symbol: 401 = Error opening the BI session. Termination.
Text Symbol: 402 = Incorrect posting
Text Symbol: 444 = Error log:
Text Symbol: 256 = Vend.Cust.RLf <1
Text Symbol: 071 = Currency type:
Text Symbol: 070 = Valuation Area
Text Symbol: 056 = Payable > 5 years
Text Symbol: 055 = Payable 1-5 years
Text Symbol: 054 = Payable 1 year
Text Symbol: 053 = Receivable > 1 year
Text Symbol: 052 = Receivable 1 year
Text Symbol: 051 = BS value from:
Text Symbol: 049 = BS value to:
Text Symbol: 046 = I CoCd I Cons. I A I G/L I BusA I Old cnsI Old G/L I Curr. I Amount in LC I
Text Symbol: 040 = Transf.postings of changed G/L account/partner
Text Symbol: 030 = Only single values permitted
Text Symbol: 027 = Following entries from table T030 do not exist:
Text Symbol: 022 = Old recon. account:
Text Symbol: 020 = SAPF101 rev.posting
Text Symbol: 019 = SAPF101 bal.sheet adj.
Text Symbol: 018 = (The required adjustment postings could not be entered in the batch input session.)
Text Symbol: 017 = Following entries from table T030U do not exist:
Text Symbol: 015 = Correct table T030U
Text Symbol: 014 = CoCd Account
Text Symbol: 010 = Following G/L accounts from table T030U do not exist:
Text Symbol: 007 = Receivables
Text Symbol: 006 = Payables
Text Symbol: 005 = Foreign curr. listing
Text Symbol: 004 = Total of valuations
Text Symbol: 000 = General selections
Text Symbol: 255 = Vend.pybl.RLf >5
Text Symbol: 254 = Vend.pybl.RLf 1-5
Text Symbol: 253 = Cust.G/L RLf >1
Text Symbol: 252 = Vend. GL RLf >5
Text Symbol: 251 = Vend. GL RLf 1-5
Text Symbol: 250 = Cust.G/L RLf <1
Text Symbol: 249 = Vend. G/L RLf <1
Text Symbol: 243 = Name of sess'n:
Text Symbol: 242 = Posting proposal
Text Symbol: 241 = Postings generated
Text Symbol: 240 = I CoCd I Pstg date I Debit acct I Credit act I Cons. I BusA I Crcy I Amount in LC I LC I Text I
Text Symbol: 121 = Inv. Trnsfr Pstng
Text Symbol: 120 = of which invest.
Text Symbol: 118 = I CoCd I BusA I Curr. I OI(FC) posted I BookVal. (LC) I OI(LC) evaluatedI Val.difference I
Text Symbol: 117 = I BusA I Crcy I OI(FC) posted I BookVal. (LC) I OI(LC) evaluatedI Val.difference I
Text Symbol: 115 = I CoCd I BusA I Curr. I OI(FC) posted I Amount in LC I OI(LC) evaluatedI RLf <= 1 year I RLf > 1 year I
Text Symbol: 113 = I CoCd I BusA I Curr. I OI(FC) posted I Amount in LC I OI(LC) evaluatedI RLf < 1 year I RLf 1 - 5 years I RLf > 5 years I
Text Symbol: 112 = CoCd Cons. A
Text Symbol: 111 = CoCd Cons. A G/L no. Description
Text Symbol: 110 = CoCd Cons.
Text Symbol: 105 = I BusA I Curr. I OI(FC) posted I Amount in LC I OI(LC) evaluated I RLf <= 1 year I RLf > 1 year I
Text Symbol: 103 = I BusA I Curr. I OI(FC) posted I Amount in LC I OI(LC) evaluated I RLf < 1 year I RLf 1 <= 5 years I RLf > 5 years I
Text Symbol: 101 = BA S Curr. FrDate Days ToDate Doc.no. Itm Amount in FC BookVal. (LC) Val.amnt in LC Val.diff.
Text Symbol: 100 = CoCd Cons. A G/L no. Acct.no. Description
Text Symbol: 080 = Folloving entries missing in table T030D
Text Symbol: 073 = Valuation in alternative valuation area
INCLUDES used within this REPORT SAPF101A
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:
BUKRS_AUTHORITY_CHECK CALL FUNCTION 'BUKRS_AUTHORITY_CHECK' EXPORTING XDATABASE = 'B' TABLES XBUKREIS = BUKRS.
READ_SACHKONTO_ALTKT CALL FUNCTION 'READ_SACHKONTO_ALTKT' EXPORTING BUKRS = SKB1-BUKRS SAKNR = SKB1-SAKNR 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'.
DETERMINE_DUE_DATE CALL FUNCTION 'DETERMINE_DUE_DATE' EXPORTING I_FAEDE = X_FAEDE IMPORTING E_FAEDE = X_FAEDE EXCEPTIONS OTHERS = 1.
VALUATION_GET_OLD_VALUE CALL FUNCTION 'VALUATION_GET_OLD_VALUE' EXPORTING I_BWBER = P_BWBER I_UMBWM = UMBWM_TAB I_CURTP = T033-CURTP I_KUNNR = BSID-KUNNR X_CURR = 'X' X_CURR_VALUE = WR_DIFF I_BELNR = BKPF-BELNR I_BUKRS = BSEG-BUKRS I_GJAHR = BKPF-GJAHR I_BUZEI = BSEG-BUZEI IMPORTING OLD_DIFFERENCE = OLD_DIFF EXCEPTIONS NOTHING_FOUND = 1 OTHERS = 2.
POSTING_INTERFACE_START CALL FUNCTION 'POSTING_INTERFACE_START' EXPORTING I_FUNCTION = 'B' I_GROUP = B-NAME I_KEEP = KEEP I_MODE = 'N' I_USER = USER EXCEPTIONS OTHERS = 4.
POSTING_INTERFACE_DOCUMENT CALL FUNCTION 'POSTING_INTERFACE_DOCUMENT' EXPORTING I_TCODE = TCODE IMPORTING * e_subrc = sy-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.
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.
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.
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 SAPF101A or its description.
SAPF101A - Balance Sheet Supplement - OI - Analysis by ........ (Old) SAPF101A - Balance Sheet Supplement - OI - Analysis by ........ (Old) SAPF101 - Balance Sheet Supplement - OI - Analysis per & SAPF101 - Balance Sheet Supplement - OI - Analysis per & SAPF100_SLDATA - SAPF100SLDATA SAPF100_SBEW - SAPF100SBEW