Mapping Bill Types to G/L's

[Former Member]

Greetings SD Guru's,

Many thanks in advance for any help you can provide

We have a request to provide a mapping of certain Bill Types used for a specific Sales Org, to each of the G/L accounts used.

Can you tell me where I can go to inside SAP to understand where each bill type is directing items to inside the G/L accounts?   I am looking for a mapping.  If bill type is ZF8 then the debit entry goes here and the corresponding credit entry goes there.

Does anyone know if there is a t-code or table that can handle this mapping?

[eduardo_hinojosa · Accepted solution]

Hi

Go to transaction VKOA.

Regards

Eduardo

[Former Member · Accepted solution]

Thank you, Eduardo!

This is a good start for us.

However, it looks like the mapping is showing the G/L to the Sales Type for each Sales Org....but, we still need to see the mapping of each Billing Type to G/L if possible

Like when a certain Bill Type is used...what G/L account is for debits and credits, ect..

Do you know if there is another area that mapping specifically?

[former_member212707 · Accepted solution]

Shane,

We assign the account determination procedure to the billing types in IMG. Typically clients use the standard procedure given by SAP,

The actual mapping as to which account is being hit is controlled by VKOA as Eduardo pointed out. The mapping depends on the parameters that you will see listed in the above transaction,

To achieve your requirement you could explore the following options.

1. 1. The account key comes from pricing condition types assigned in the pricing procedure that is determined in your sales order. You can have custom account keys for the condition types and base your G/L mapping off of these keys.
2. You can create custom condition tables with fields specific to your business case and use it to map to the G/l account. This will involve adding fields to the field catalog if it is not available and then using them to create new tables.

Hope this gives you some direction,

The path to check the Account assignment settings is

IMG > SD > Basic Function > Account Assignment > Account Assignment/Costing -
Revenue Account Determination

Thanks,

Ravin

[eduardo_hinojosa · Accepted solution]

Hi

See note 777996 - Account settings for revenue recognition process for further information

Regards

Eduardo

PD: In this note there isn't mention to these details

Go to tcode VOFA and check these entries

and look for the settings in this area of IMG

Other precision, compare this two points of IMG

The last is VKOA, but when you see it, you see the order in lexicographic order, but the actual order is in the first note.

[Lakshmipathi]

Adding to my above comments, you should be aware, all FI postings from SD would happen based on the Account Key you assign to a condition type in a pricing procedure.  This Account Key, would in turn, integrate with the respective G/Ls.  This means, if you maintain the same Account Key in multiple pricing procedures, then the other billing types also post to same G/L Account in which case, you cannot differentiate the FI postings based on Billing Type.

G. Lakshmipathi

[Lakshmipathi]

If there is only one billing document type against that specific Sales Organisation, then you can very well get via FBL5N where you have the option "Search help ID".  Here press F4 and select the option 'Customers per sales group' and execute. 

G. Lakshmipathi