2 Revenue accounts for one material at billing?

[former_member619039]

Hi Gurus

We have a material activated with "split valuation" (Inhouse/ trading). Based on split valuation we could assing different GL accounts for 2 valuation types in OBYC.

Now we have the requirement at billing as well to split Revenue based on valuation type. If material is inhouse, it should hit one Revenue account and if material is trading it should hit another Revenue account. Since Revenue account determination for materials is determined based on "Material account assignment group" and each material can have only "Acct Assnmt group" how can we acheive different GL(Revenue) assignment for one material in VKOA?

Appreciate any responses

Thanks

Aleem

[former_member266852]

Hiii

As per my understanding you have split valuation, that means for two different valuation for two differnt plant e.g. Plant X have XX valuation and Plant Y have YY valuation and you want to post the revenue in SD accordingly.

Now you can create condition table for account Assignment with Plant.

SPRO---Sales & Distribution --Basic Function --- Account Assignment and costing -

---

Revenue Account determination ---Define Depandencies of Revenue account Determination. Here create one condition table with Plant and assign this table in Access sequence of Account determination if very first. Now maintain the G/L account according to plant (attached valuation class)

Now according to plant assignment with G/L system will identiy revenue account as per plant of document.

Hope it will solve the issue.

Regards

Shambhu Sarkar

[jpfriends079]

Following are the fields available in field catalog for

Header

KOMKCV-Determination header

AUGRU-Order reason (reason for the business transaction)

KTGRD-Account assignment group for this customer

LIFNR-Account Number of Vendor or Creditor

LLAND-Destination country

VKORG-Sales Organization

VTWEG-Distribution Channel

Item

KOMPCV-Determination item

KSCHA-Condition type

KTGRM-Account assignment group for this material

KVSL1-Account key

MWSKZ-Sales Tax Code

SPART-Division

WERKS-Plant

So, account determination config, you can maintain a table with field Plant or Valuation class(from material) in Define Dependencies Of Revenue Account Determination. And subsequent add a step in access sequence.

For Valuation class you need add it to field catalog for account determination. Check [How To Add New Fields To Field Catalog|www.sap-basis-abap.com/.../how-to-add-new-fields-to-field-catalog.htm]

For config for Account determination, explore following SPRO path:

IMG - SD - Basic function - Account Assignment/Costing - [Revenue Account Determination|http://wiki.sdn.sap.com/wiki/pages/viewpage.action?spaceKey=ERPLO&title=Account+Determination&decorator=printable]

Thanks & Regards

JP

[former_member619039]

Thanks JP and Shambhu for your responses

I guess it can be done through Access Sequnece, but we decided not to use split valuation for SD account determination.

Thanks

Aleem