Modifiying the Drill Down Reports !!

By Suren

This post is to simply list down some basic steps on how to modify the drill down reports that are built in SAP to reflect the Vendor and Customer balances. The report shows balances in a vertical format, but most often the clients want them in a horizontal format with the balances shown separately under each day range.

For this you simply need to do the following, however I would recommend that you first do this in a sandbox client and then try this in the production client, remember however that once the form is changed, all users would see the new horizontal form.

- Go to FKI2 if you want to change the report parameters. This is how the form would initially look like:

- Go to FKI5 to change the form. These changes can be done in the path in SPRO, under Info System under the AP/AR main node.

- Go to the “Define Form” and choose to “Change. If the client don’t want to see the Not Due and Total OI column in every time intervals then select the “Not Due” column and the “Total OI” column and go to extras “Drill down Display -> Undo Selection”. Then delete these columns from the form.

- After this just rename the date ranges to calculate the balance different for the day ranges that the clients wants to see. Finally the form would look like this:

And voila the report when generated would look like this :

That's about it. Just a few simple steps to change the form in SAP to a more readable format, and in case you want to bring back the old report format then you can overwrite this report by selecting the Environment -> Import Report, option in FKI5.

All the best !!

FICO Certification Exam KIT !!

Dear Friends,

We have introduced a FICO certification practice software. It has been priced at a nominal $5 to cover our costs. This will certainly help all those preparing for the SAP certification exams. Currently it's available for FI and CO modules. We will release other modules in future. Software can be purchased at

http://store.payloadz.com/details/784249-Software-Training-Passmaster.html

Note : This download version is not supported on Windows 7, the new compatible version will be out soon !!

For more information on software visit : http://www.azione-group.com/

Would appreciate your feedback.

mySAP FI NEW GL - Useful Info

Less known functional enhancements in New G/L

Coding Block

User specific account assignment object (e.g. “Region” to support geographic segment reporting) can be created in FI using the Coding Block concept. One of my previous post explains this area: Click Here.

However, they cannot be posted to directly in other application components (Logistics, Controlling) è need to define automatic derivation rules.

Post Processing

Post processing of work lists now becomes relevant (similar to, for example, CATS transfers) as transfer posting errors may arise (e.g. if the FI period is closed when the CO entry is posted) – use transaction FAGLCOFIFLUP

Hide the Old G/L Node

Once you have become familiar with the paths for New General Ledger Accounting, you can run

Program “RFAGL_SWAP_IMG_OLD” to hide the classic Financial Accounting paths.


Segment Derivation

When using Segments in New G/L, the segments are picked from the profit center to which it is assigned. If there is not assignment the segment account assignment does not trigger.

But a custom development can be done using a user exit (BadI): FAGL_DERIVE_SEGMENT

Drill-down Reporting

Transaction FGI0 displays a list of defined program variants, which you can then run instantly.

Technical Info on New G/L

A new totals table is now available which can be used as a template in creating user specific totals tables as well.

FAGLFLEXT – Totals Table

With SAP New G/L, line item entries (ledger specific) are updated in a new set of tables:

FAGLFLKEXA – Actual Line Item

FAGLFLEXP – Planned Line Item

A new table is used to capture the documents posted in relation to the selected parallel ledger valuations carried out at the year-end closing.

BSEG_ADD

Useful Notes in New G/L

If at any time there is (though there never should be) a balance in the “Zero-balance clearing account” when document splitting is used, the following note needs to be implemented:

New GL Clearing Account Balance – 1049224

For any queries you can mail me at ssurenlk@msn.com

Authorization Group usage in SAP Financials !!

Introduction

This post details out the steps to cater to the requirement of a client to be able to control the duties of accounting clerks to a specific vendor.

E.g.

Accounting Clerk 1 should be able to access only Vendor 1 (e.g. VENDSTY)

Accounting Clerk 2 should be able to access only Vendor 2

Process

We can use the Authorization group concept available in the vendor master in order to do this.

Step 1

Define an Authorization Group

1. Go to SE54
2. Enter the table “LFA1”
3. Select the radio button “Authorization Group”

4. Click on “Create/Change”
5. Create a “New Authorization Group”
6. Save

Step 2

Enter the relevant Authorization Group in the Vendor master.

1. Go to XK02
2. Enter the Vendor No, select the tab “Accounting Info”
3. Enter the “Authorization Group”

4. Save

Step 3

Enter the relevant Authorization Group in the role that is assigned to the Accounting Clerk

1. Go to PFCJ
2. Enter the Role that has been assigned to the relevant Accounting Clerk

3. Click on “Change”
4. Go to “Authorization Tab”
5. Click on “Change Authorization”

6. Go to “Financial Accounting -> Vendor : Account Authorization”
7. Specify the Activity “Change”
8. Specify the “Authorization Group ”

This means that the Accounting clerk attached to this role can only change the vendor account whom have been assigned this “Authorization Group” in the master (as shown in Step 2 above), do the same for the other roles of the other Accounting Clerk with their respective Vendors Authorization Group.

For any queries or feedback, drop me an email at : ssurenlk@msn.com

Have a nice day !!

SAP FI Coding Block Config !!

Coding Blocks

In the coding block of the system you can create your own fields. The new coding fields can then be used in FI General Ledger accounts, MM Inventory Management and MM Purchasing, and are also updated in the line items created in the Controlling applications.

These fields can then be used to input data you want to record when entering documents in SAP.

Activity Edit Coding Block
Path IMG -> Financial Accounting (NEW) -> Financial Account Basic Setting (New) -> Ledgers -> Fields -> Customer Fields (OXK3)

In the below example, we are going to be adding a field to record the “Users HR ID”. This will be updated by the user when entering the document in the user, with his/her own HR ID.

Note : It is vital that the fields to be added in the Coding Block be decided before hand and the relevant modification made before other customization efforts, since adding a new field will update the tables in SAP.

Step 1 : Add Field

Step 2 : Enter the Development Class and the Field attributes.

Step 3 : Execute in “Test Run” to check for any errors.

Step 4: Create a Coding Block Field and save the Transport Request ID. This would be a workbench request.

Step 5 : Next make the FIELD as Optional/ Mandatory in the Field Status of the Posting Key and the Field Group.

And that’s it, now you would get this field every time you enter a transaction for this posting key and the account with the field status group to which this field has been made available.

Hope this you found this post informative. Feel free to drop me an email on the below address for any quick clarifications.

Have a nice day !!

suren@erparena.com

SAP AFS Split Valuation

By S.Suren

What is Split Valuation?

Split Valuation means managing a material as several partial stocks. Each partial stock is valuated separately.

Split Valuation in AFS

In the apparel industry one of the main reasons behind using Split Valuation would be to valuate the RMs differently based on their SKU levels.

For instance, the various sizes of men’s pants have significant differences in their material input (e.g. zippers). Therefore, the large, medium and small sizes should be valuated and costed separately.

Activate Split Valuation

Path : IMG -> Material Management -> Valuation & Account Assignment -> AFS Split Material Valuation

TCode :OMWC

AFS uses its own special valuation category X for split valuation. Valuation types are not maintained in Customizing but separately for each material in the material master´s AFS Valuation view.

Quick 3 Steps Setup Process

1. Define the global valuation type

2. Define the global categories - This is where we mention which valuation category is to be linked to which valuation types as default.

Note: Activate the valuation type to valuation category.

3. Assign the Valuation Category: Valuation Type combination to Category to Organisational Unit.

Note: Activate the valuation category to the plant.

And thats it, those are the simple steps to setup split valuation characteristics and definition. Once this is done you need to maintain the material master accordingly, this is detailed out

below :

Steps to use Split Valuation in SAP AFS Material

1. Create a Material with a Grid and specify the ”Valuation Category“ as “X“ in the Accounting 1 tab.

2. In the “AFS Valuation“ tab you need to now enter the “Valuation Type“ code for the relevant “SKU“ .

In the above example, my requirement is to valuate the material based on 3 main sizes, i.e. XS, M and L.

Using the Preferred SKU option, I have decided that :

• Size XS and S will be valued similarly

• Size M will be valued seperately

• Size L,XL and XXL will be valued similarly.

3. Save.

Thats about it. Now you could valuate materials different based on their special characteristics, known as Valuation Types in Split Valuation.

Hope you found this post informative. For any queries, suggestions and comments feel free to email me on suren@erparena.com.

Have a nice day !!

SAP New G/L Document Splitting

Document splitting is a new feature in the new General Ledger that enables you to create balanced financial statements for entities such as profit centers and segments.

The predefined splitting method (0000000012) covers the majority of business scenarios but some cases still require you to go beyond the standard splitting functions. With document splitting activated, the system splits accounting line items according to splitting rules.

Setting in Document Splitting

• Splitting Method : Standard method used 0000000012, Modifiable
• Splitting Rule : Combination of Document Splitting Method, Business Transactions and Variants – Modifiable
• Item Categories – System Defined
• Standard Variants – Standard 0001, Modifiable

Document Splitting Structure :

Steps 1 :

The system checks if the entry for the account has been maintained in the document splitting setting : “Classify G/L Accounts for Document Splitting”, the “Category” defined for the relevant account is then identified.

Steps 2 :

The system then checks the “Classify Document Types for Document Splitting” for the document type setting as per the document type that was entered. In this case it is “KR”.

Steps 3:

The system then checks the “Define Document Splitting Rule” to check for the transaction “0300” :

The system then checks the “Item categories assigned to this (higher level)” in the same window to the left:

The system then checks the “Base item categories” under the above item category, and if this category has been specified in the first setting in Step 1, this is taken as the base in calculating how the Vendor value should be splitted.

The above was a brief on how the Document Splitting functionality works in SAP. Hope you found this post useful, for more information with examples on this functionality, feel free to drop me an email.

suren@erparena.com

Have a nice day !!