SAP FI Reporting Tool

, In ,

 


FI Module Reporting Tools:

OKSA : Genegate reports


FSI0 : Balance Sheet Report
FSI1 - Create report FI - Information System
FSI4 - Create Form FI - Information System
FXI4 - Create Form FI - Information System
FXI0 - Execute report FI - Information System
FXI2 - Change report FI - Information System
FDI0 - Execute report FI - Information System

FDI5 : Change FI Forms
FI-AP Module Reporting Tools:



VENDOR
FKI5 - Formular FI - Information System
FKI1 - Create report FI - Information System
FKI2 - Change report FI - Information System
FGI4 - Create Form FI - Information System
FGI1 - Create report FI - Information System

 

FICO :


KE34 - Create form CO - Profitability Analysis
KKRV - Data Collection Product drilldown CO - Product Cost Controlling Information System
KE35 - Change form CO - Profitability Analysis
KE3E - Maintain Global Variables CO - Profitability Analysis
KKO0 - Run drilldown report CO - Product Cost Controlling Information System
OKN0 - Control of CO-PC Information System CO - Product Cost Controlling Information System
MCBG - INVCO: MRP Cntrlr Analysis Selection MM - Inventory Controlling

Others:


GCRE1 - Activate drilldown rep. for SL table FI - Basic Functions
KE81 - EC-PCA: Create Drill-Down report Enterprice Controlling - Profit Center Accounting
OKQ3 - Define Reference Character. (Orders) CO - Product Cost Controlling Information System
KKO3 - Display drilldown report CO - Product Cost Controlling Information System

 

Reference:
http://scn.sap.com/community/erp/financials/blog/2013/02/22/vendor-aging-analysis-through-sap-report-painter
https://scn.sap.com/thread/1371715
https://wiki.scn.sap.com/wiki/display/ABAP/Create+t.codes+for+Drilldown+reports+in+FGI0+transaction

https://sites.google.com/a/sapland.com/main/sap-business-processes/fi-modules/internal-order-tcode

Adjust value flow from FI to CO-PA?

, In , , ,

 
 How to adjust value flow from FI to CO-PA?

Is it done via KEU5, reverse and execute KEU5 again.

Is it from FI posting, reverse the CO-PA document and post it again (KE4SFI).

Is it from CO-object settlement, reverse the settement and settle again (eg KO88).

GO with KE21N.... Calculate the net adjustment to be made in an excel and then pass a correction entry from KE21N to increase / decrease the value

SAP create bank key tcode

, In

FI12 - Change House banks/bank Accounts FI - Master Data
FI01 - create bank Cross Application - Bank
FI02 - Change bank Cross Application - Bank
OY17 - Countries - field checks Cross Application - Bank
FBKP - Maintain Accounting Configuration FI - Basic Functions
FI06 - Set Flag to Delete bank Cross Application - Bank
FI03 - Display bank Cross Application - Bank
BAUP - bank Data Transfer Cross Application - Bank
BA01 - Table T005BU Cross Application - Bank
OY01 - Customize: set up countries Cross Application - Global Organization Customizing
OBD3 - C FI Maintain Table T077K FI - Basic Functions
SPACKAGE - Package Builder Basis - Package Tools
OB23 - C FI Maintain Table T078K FI - Basic Functions
OBR4 - Delete banks FI - Basic Functions
OX15 - Define internal trading partner FI - Basic Functions

 

Read more: http://www.sapland.com

SapLand

 

The focus of this site will be on the SAP functional configuration of Material Management, Sales and Distribution, Production Planning and Control, Controlling, Financial Accounting, Basis Components as well as in ABAP/4 query, SAPscripts, Smartform and Abap programming.

"SAP is a matter of consistent and unending learning. One should be prepared to Learn, Unlearn and Relearn."

Message no. VL224 : There are still batch split items with quantity xxxxxx for item yyy

, In

 

Last day , I received error when delete outbound ( not yet invoiced / good issue )

image004   

Not sure the root cause of this error, I think maybe something wrong with configuration of batch splitting but I can not duplicate this error .

image001

Document flow show only 2 relevant doc ( Sale Order –> Outbound ) and invoice status of outbound is C . ???

AT first , I try to update outbound status by program RVDELSTA , this run successfully and change invoice status of outbound to A but the problem still not solved.

After try many solutions, I found one script here can solve the problem:

This ABAP script update outbound quantity to the correct one

 

REPORT ZZLIPS01.
TABLES: LIPS, *LIPS, VBUK, VBUP.
PARAMETERS: VBELN LIKE LIPS-VBELN.
PARAMETERS: POSNR LIKE LIPS-POSNR.
SELECT SINGLE * FROM LIPS WHERE VBELN = VBELN
                            AND POSNR = POSNR.
CHECK SY-SUBRC = 0.
CLEAR: LIPS-KCMENG, LIPS-KCBRGEW, LIPS-KCNTGEW, LIPS-KCVOLUM.
SELECT * FROM LIPS INTO *LIPS WHERE VBELN = VBELN
                                AND UECHA = POSNR.
  LIPS-KCMENG  = LIPS-KCMENG + *LIPS-LGMNG.
  LIPS-KCBRGEW = LIPS-KCBRGEW + *LIPS-BRGEW.
  LIPS-KCNTGEW = LIPS-KCNTGEW + *LIPS-NTGEW.
  LIPS-KCVOLUM = LIPS-KCVOLUM + *LIPS-VOLUM.
  WRITE:/ LIPS-POSNR, LIPS-KCMENG.
ENDSELECT.
IF SY-SUBRC = 0.
  CLEAR LIPS-CHARG. CLEAR LIPS-BWTAR.
ENDIF.
UPDATE LIPS.

Thanks god . 1 full day to delete one outbound .

Blog Archive