Fiori App Utility: Bulk Upload of Journal Entries

PROBLEM STATEMENT

Financial journal entries are typically limited to being created a single document at a time. There are occasions where the need arises to allow for the upload of multiple (or large numbers of) documents at a time. 

Customers may deploy various techniques to accomplish this like making using of Win Shuttle to upload spreadsheets or other 3rd party applications. 

THIS SOLUTION - JE Fiori Upload

Category: Bulk Journal Entry upload utility leveraging SAP Fiori

Read all the details here...

SAP FI/CO Table Relationship Mapping

Below is a diagram showing all the main SAP FICO tables and their relationships with each other. Check it out and see if I have missed any.

Click the image to see a larger version - You may have to save the file to your hard drive to zoom in.
(Download PDF version)



BPC & FICO Configuration

Read full article at BPC Consultant Blog: "SAP BPC is handling, by default, the so-called Bottom-Up planning by using the hierarchy capabilities of the Dimensions. It is normal planning scenario where departments plan on the lowest level and later it is aggregated to a company and group level. It is nothing special and nobody will be surprised by that. However, sometimes you might be asked how to do a Top-Down Planning in SAP BPC. Top-Down Planning is characterized by setting a target budget of a Company or Sub-Group level which is later allocated to the business units underneath. By default, SAP BPC can hold data only …"

FICO Configuration

FICO Configuration: A list of basic tutorials for configuration of the SAP FICO modeule. From my point of view, it is better to make a full SAP FICO Configuration from A to Z and then to dive into the details. In this way, you will start to understand much faster what you will see in the advanced books. These tutorials are part of my learning of SAP and my search for valuable materials which will help you to become a SAP FICO Consultant.

Miscellaneous

• Define Countries | OY01 & OY07
• Setting Country-Specific Checks | OY17
• Create a New Currency | OY03
• Set Decimal Places for Currencies | OY04
• Check Exchange Rate Types | OB07
• Ratios for Currency Translations | OBBS

To continue with the full list of tutorials go to FICO Configuration on etcircle.com.

Settling detailed manufacturing variances to cost based CO-PA

If you are using cost based CO-PA you may find it useful to be able to identify the detail of exactly where the cost variances are occurring. 

TIP: For Production Orders -> Make use of the PA Transfer Structure to assign settlement variance categories to CO-PA value fields. Furthermore you should leverage the relevant Cost Element groups to provide additional insight in to the origin of the variance. Let me explain how this works...

TIP: Seeing what views are missing from your material master

When you create a material master you may not have all the information available to generate all the required views. The nice thing is that there is a table in SAP that stores an entry for each view that has not been created. It would be a simply thing to write a report or better still, create a workflow to ensure that all the required views for you materials have been created before they are made available for use. To review this tables details let's run through an example.

Report to check if finance or sales view missing for a customer master record

ISSUE

You find that your master data process leads to customer records that occasionally have missing sales or finance views. How can we easily find these records and address them.

SOLUTION

1. I like to use Workflow to manage the creation of master data to ensure proactive maintenance of master data views - i.e. When a customer is created and it's missing the sales or finance view then send a work item to the sales or finance team in order to have them create it. The workflow is only terminated once the view has been created. Businesses that need to follow a compliance process often use this technique and have the QA team be the last in the process to release the master data object for general use.

Changing master data in mass

Use transaction MASSD to change attributes of your various master data elements. The following master data objects can be changed using this transaction:

1. BUS0015    Profit center
2. BUS1001    Materials (industry)
3. BUS1001001    Materials (retail)
4. BUS1006    Business Partner
5. BUS1133    Rental units
6. BUS1178001    Mass Maintenance Mat
7. BUS2012    Purchase orders
8. BUS2013    Purch. Sched. Agrmt
9. BUS2014    Purchase Contract
10. BUS2031    Customer Quotation
11. BUS2032    Sales orders
12. BUS2034    Customer Contract
13. BUS2104    Appropriation Req.
14. BUS2105    Purchase Requisition
15. BUS3003    Purchasing Info Rec.
16. BUS3006    G/L Account
17. CA_CONTACC    Contract Account
18. FORCE_LS    ForceEl (Log. Syst.)
19. KNA1    Customers
20. LFA1    Vendors

Direct Activity Allocation

STEP-1: Create allocation cost element

Accounting>>Controlling>>Cost Element Accounting>>Master Data>>Cost Element>>Individual Processing>> Create Secondary

FI Parked Documents

Transaction codes

• FBV0 : Post parked document
• FBV2 : Change
• FBV3 : Display
• FBV4 : Change Header
• FBV5 : Display Changes
• FBV6 : Refuse
• FV50 : Post / Delete : Single Screen Transaction

Tables

Parked document header data goes to bkpf table but item level data does NOT go to bseg table. Instead the tables below are used:

• VBSEGA - Assets parked document detail
• VBSEGD - Customers parked document detail
• VBSEGK - Suppliers parked document detail
• VBSEGS - General Ledger  parked document detail