Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

Can ERP such as SAP support Ledger viewing apart from All items category? Also is their any particular way for uploading Excel data into SAP?

Q.1 Which is the best way to retrieve data of a particular Ledger in SAP?

Q.2 Uploading an Excel data is usually through Batch Data Conversion/Legacy System Migration Workbench. Can we design a Transaction code for the same where the system recognizes exactly the same references (Eg: Invoice Numbers for Payment Allocation)

user-image
Question added by Subin Luckose , Team Leader , DSV Solutions FZE
Date Posted: 2016/12/09
Mahesh Kumar Vyas
by Mahesh Kumar Vyas , Senior Financial Analyst/ SAP FunctionaI Analyst. , Bader Al Mulla & Brothers Co. - Engineering Group.

Answer 1). There is standard report available in SAP system where you can see the general ledger balance (Line item and Display GL bal.). As per SAP terminology both the way is okay because one t-code shows line item wise report and another reports shows GL balance only.

Answer 2). As you know that Batch Data Communication (BDC) is the process of transferring data from one SAP System to another SAP system or from a non-SAP system to SAP System. LSMW on the other hand is a tool that helps migrate data from a legacy system (non-sap system ) to SAP system. There is not standard report available but yes, we can take ABAP helps to develop Z-Report to upload the data.

 

More Questions Like This