• Terms of Use
  • Privacy Policy
  • SAP ERP Solutions
  • What does SAP stands for

ETCircle.com SAP FI and CO consultant information

Materials: account assignment groups | ovk5.

In this configuration activity we are able to define account assignment groups for materials used in Sales and Distribution Module ( SD ).

Transaction: OVK5

IMG Path: Sales and Distribution -> Basic Functions -> Account Assignment/Costing -> Revenue Account Determination ->  Check Master Data Relevant For Account Assignment

Tables:  TVKM, TVKMT

If you use the IMG Menu, you will have to choose the first option on the pre-selection screen.

On the main screen there is a list of Account Assignment Groups for Materials. You can create new here if you need.

Tags Account Assignment OVK5 TVKM TVKMT

About Emiliyan Tanev

Related articles, assign g/l accounts | vkoa, customers: account assignment groups | ovk8, define automatic credit control | ova8, configure automatic postings | omwb.

In this FICO configuration activity we are able to define account determination for automatic postings …

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Notify me of followup comments via e-mail. You can also subscribe without commenting.

G/L Account Determination in SAP SD

light

Most of the transactions in SAP are recorded against the GL account. During creation of billing document form a sales order , an accounting document is created where material value is posted against a G/L account. The post describes how the system determines the G/L account for a material sold to a particular customer by the GL account determination technique.

Lets try to create a sales order for a customer with some material and then creating a billing document from the sales order which also generated the accounting document.

To create sales order go to Tx- Va01

1

Lets create a debit memo request for the sales area 1000/10/10.

2

Provide the customer number and few materials and its quantity and double click on the first material to see the item details.

3

From the pricing procedure – for the pricing condition type- PR00 material value is calculated as 175.50 EUR.

4

For the second material  for the pricing condition type- PR00 material value is calculated as 1598.00 EUR. Go back.

5

Select the header button.

6

In the header section, in the Conditions tab, the total price is the sum of two materials.

7

Save  and DMR is created.

8

Go to Tx- VA02 and  from the menu choose Billing.

9

Select Save button to create a billing document. mark billing document type is determined as – L2.

10

Go to Tx- VF03 and display the billing document. Choose Accounting button.

11

Choose Accounting document.

12

Here is the accounting doc with few lines.

First entry is for the customer as we used the customer – 491000, the account becomes 491000 for the customer.

For the second line, the GL account calculated as 502000. Let’s figure it out how this g/L account is determined.

13

Go to Tx- VF02 and edit the billing document.

14

From menu, navigate along the highlighted path.

15

Well, it says the Account Determination procedure is KOFI00 and for the first item , for the pricing condition type PR00, the G/L account as 502000.

16

Same for the second item.

17

The G/L account determination requires few customizing steps.

First check what is the chart of account assigned to the company code. In SPRO IMG structure navigate along the highlighted path to see the chart of account assigned to the company code. 

19

For the demo we use company code- 1000

20

The chart of account is – YIKR

21

Next step , the customizing in the Sales&Distribution section for the Account Assignment/Costing.

First execute – Check master data relevant for account assignment.

22

Select first option- Materials : Account Assignment Groups.

23

Here Material account assignment group is created which is assigned to the material master when created in Tx- MM01

24

Select second  option- Customer : Account Assignment Groups.

25

Here Cusomter account assignment group is created which is assigned to the customer master when created in Tx- XD01

26

For our used material in sales order- H11, open this material in Tx- MM03 and in the Sales: sales org.2 tab, the material account assignment group is assigned to the material.

27

Similarly for another material used in sales order, it is assigned to the material account assignment group.

28

For our customer – 491000, open this customer in Tx- XD03 and go to the sales area data & in the billing document tab, customer account assignment group is assigned to the customer.

29

This customer and material account assignment group will help to determine the GL account.

GL account determination uses the condition technique. Now the next step is to define the condition tables. So choose option- Define Dependencies of Revenue Account Determination.  If you want to create new tables you can choose Create Table option. For this demo we are leaving this as already we have few condition tables.

30

Next is defining the access sequence and the condition type. So choose the highlighted opton.

31

Access Sequence is defined as – KOFI( a new access sequence can be created bu New Entries button ).  Select the access sequence and choose Accesses from left hand section to see all the access lines with condition table.

32

Well this access sequence KOFI has five access line each refers to one condition table.

Select one access line and choose Fields button to see all the fields included in the condition table to form the access line 10.

33

Access line-10 with condition table 001 has 4 fields.

34

Similarly for other access lines with condition tables other fields are there.

35

For access line 30.

36

For access line 40.

37

Choose Define Account Determination type.

39

Here Condition type- KOFI is created which is assigned to the access sequence KOFI which has 5 access lines with different condition tables.

40

Choose the option as pointed to create account determination procedure.

41

Procedure KOFI00 is created and assigned to the account condition types. Choose the procedure and select Control data from left side.

42

Here the account determination procedure is assigned to the condition type.

43

Choose the option – Assign account determination procedure.

44

Here the account determination procedure is assigned to the billing type.

45

Next step is to define account key. Choose the marked option.

51

For different types like revenue, tax and other different account keys are defined. For revenue its ERL.

52

Next step is to assign the account key to the pricing procedure – condition type PR00.

53

Here for the pricing procedure ZVAA01 and condition type PR00, the account key is assigned as ERL.

54

In the above created sales order, item we can check the pricing procedure as below bu selecting the Analysis button in the conditions tab of the item detailed screen.

46

Next time is to assign the G/L account. Choose the marked option.

55

Here we have five options. as account condition type KOFI of the account determination procedure KOFI00 is assigned to the access sequence – KOFI with five access lines.

This is like maintaining the condition records. During the GL account determination process, it checks to find the GL account by taking all the values from the billing document and checking against the condition records for table 001. If found it calculated the G/L account and if not found then checks for the condition records for the second table and so on upto 005 until it finds a G/L account.

Choose/double click on the first line.

56

Here we have maintained for V-Sales, KOFI- account condition type, YIKR as the chart of account and other four fields like sales org, customer account group, material account group and account key comes from the condition table, for our demo purpose we have assigned the G/L account as- 502000.

( Before assigning to the G/L account here it should be created first).

57

For our demo

  • From Billing Type L2 it derives the account determination procedure as- KOFI00
  • From account determination procedure- KOFI00 it find the account condition type as – KOFI
  • During creation of billing its finds for the item, pricing procedure and the condition type as PR00
  • Then it finds the account key for the pricing procedure with condition type PR00 as ERL
  • The customer account assignment group is – 03
  • The material account assignment group is – 01
  • The chart of account as- YIKR fot the company code- 1000
  • By taking all these values, the G/l account number calculated as – 502000

58

  • Click to share on Twitter (Opens in new window)
  • Click to share on Facebook (Opens in new window)
  • Click to share on LinkedIn (Opens in new window)
  • Click to share on WhatsApp (Opens in new window)

12 comments

Very well explained

Can you please explain me how to assign different GL account while creating accounting document? What changes do I have to make?

is there any way to do a mass analysis on how account assignment has been done over a period of time? ie which tables were used with with criteria? We want tot clean up the SD account assigment tables which currently have over 100.000 entries and are not manageble anymore.

It’s truly a nice and useful piece of info. I’m happy that you shared this useful info with us. Please keep us up to date like this. Thank you for sharing.

Hi. I have an inquiry regarding the classification of ERL account group. In my current company, there are two GL accounts which are currently tagged to ERL (Revenue) – one is cash and another is VAT adjustment (based on their description). My question is, are those two accounts valid to be determined under ERL? If so, what is the impact if this matter is unresolved? Hope someone can take up and provide me a good input. Many thanks in advance.

this is how the fucking a document must be. excellent!

Thank you so much, detail explanation. Appreciate the hard work

Could you add little detail on ” how does the pricing procedure ZVAA01 and condition type PR00 linked/determined for an item”

Pricing procedure is not determined on the item level. Pricing Procedure is determined on the header level. In tx- OVKK , the determination of pricing procedure customizing are maintained. The sales area, document pricing procedure and the customer pricing procedure determines the pricing procedure. When an order is created we know the sales area(sales org, dist channel and division), the document pricing procedure derived from the document type and from the sold-to-party (customer) the customer pricing procedure is derived. With all these information, Pricing procedure is derived.

The pricing procedure contains condition types like PR00 and others. In Tx- VK11/VK12/Vk13 we can maintain pricing condition records against each condition types. When we enter a material in an item, from the already determined pricing procedure it gets the condition types and tries to find the pricing condition record for the material. This is how the price is found for that item condition type.

Hope this helps!

Like Liked by 1 person

Thanks to you Siva and Manish, I am not in to SD but was trying to have extended understanding between FI-SD integration and found your tutorial, its really help full. I was going through with the tutorial and played your videos as well in you tube. It helps me to understand the process and bridge the gaps from SD side. Really appreciate your effort on preparing and sharing the knowledge

Thanks for the details .suggest reading the note on account-determination helpful things are described there

execellent..well done..thank you

Leave a Reply Cancel reply

' src=

  • Already have a WordPress.com account? Log in now.
  • Subscribe Subscribed
  • Copy shortlink
  • Report this content
  • View post in Reader
  • Manage subscriptions
  • Collapse this bar

SAPHANATUTOR.COM

SAP ECC | SAP S/4 Hana Tutorials

Revenue Account Determination in SAP SD: A Comprehensive Guide

Revenue Account Determination in SAP SD , is a crucial integration point between the SD and Financial modules. It ensures that when a billing document is created, the system accurately identifies and posts revenues, taxes, and sales deductions to the appropriate accounts. This process, deeply rooted in the condition technique of SAP, requires a collaborative effort between the SD and Finance teams. Here’s a step-by-step guide to understanding and implementing revenue account determination in SAP SD .

Table of Contents

Revenue Account Determination in SAP SD

Revenue Account Determination in SAP SD involves 6 configuration steps they are

  • Check Master Data Relevant for Account Assignment
  • Define Dependencies for Revenue Account Determination
  • Access Sequence and Account Determination Types
  • Define and Assign Account Determination Procedure
  • Define and Assign Account Keys
  • Assign G/L Accounts

Revenue account determination in SAP SD 2023-12-18 at 7.28.22 PM

Step 1: Master Data Relevance in Account Assignment

Path : SPRO -> Sales and Distribution -> Basic Functions -> Account assignment/Costing -> Revenue Account Determination -> Check Master Data Relevant for Account Assignment.

The first step involves checking the master data relevant for account assignment. This includes:

  • Material Account Assignment Group : This groups materials to post related revenues into specific accounts. For instance, revenues from laptop sales might be posted to one account, while desktop sales go to another. This grouping is maintained in the Material Master ( MM03 ) under the Sales org data 2 view.

Revenue account determination in SAP SD

  • Customer Account Assignment Group : Similar to materials, customers are grouped to direct revenues into designated accounts. This could differentiate between domestic and international customer revenues. This grouping is found in the Customer master ( VD03) under the Sales area view/Billing tab.

Revenue account determination in SAP SD

Step 2: Defining Dependencies

Path : SPRO -> Sales and Distribution -> Basic Functions -> Account assignment/Costing -> Revenue Account Determination -> Define dependencies of Revenue account determination.

The second step is about defining dependencies for revenue account determination. This involves creating field catalogs and condition tables , which are essential for setting up the account determination tables.

Step 3: Access Sequence and Account Determination Types

Path : SPRO -> Sales and Distribution -> Basic Functions -> Account assignment/Costing -> Revenue Account Determination -> Define Access Sequences And Account Determination Types.

This step focuses on setting up the access sequence for account determination and defining the account determination types. The access sequence dictates the order in which tables are accessed, while the account determination type functions like a condition type in the pricing procedure.

Detailed Configuration Steps

Step 4: account determination procedure.

Path : SPRO -> Sales and Distribution -> Basic Functions -> Account assignment/Costing -> Revenue Account Determination -> Define and Assign account determination procedure.

Revenue account determination in SAP

Step 5: Account Keys Definition and Assignment

Path : SPRO -> Sales and Distribution -> Basic Functions -> Account assignment/Costing -> Revenue Account Determination -> Define and Assign Account keys

Account keys play a pivotal role in account determination. They are linked to pricing condition types and are critical in linking the pricing procedure with the account key. Different pricing conditions have distinct account keys, like “ERS” for discounts, “ERL” for price, and “MWS” for taxes.

Step 6: Assigning G/L Accounts

Path : SPRO -> Sales and Distribution -> Basic Functions -> Account assignment/Costing -> Revenue Account Determination -> Assign G/L accounts.

The final step involves assigning General Ledger (G/L) accounts. This is akin to maintaining condition records for pricing condition types. The G/L account determination is a combination of the application, account determination condition type, chart of accounts, and account keys

Role of Account Keys in Pricing Procedure

Learn about role of account keys in pricing procedure here.

revenue account determination

Related posts:

  • Role of Account Keys in SAP Pricing Procedure
  • How to configure material determination in SAP?
  • SAP SD Partner Determination: Configuration Guide
  • Exploring SD Pricing in SAP -Detailed Explaination
  • How Customer Account Groups in SAP SD are created | Saphanatutor.com

SAP Materials, Documents, Tutorials

Automatic Account Assignment in SAP SD

During goods issue in the sales cycle, the system is usually configured to update the relevant GL accounts automatically and to create the relevant accounting documents. This customization in IMG is also called material account assignment and is achieved through a number of steps as detailed below:

  • Determine ‘valuation level’ (Company Code or plant).
  • Activate ‘valuation grouping code’ and link it with the ‘chart of accounts’ for each ‘valuation area.’
  • Link ‘valuation class’ with ‘material type’ (FERT, HAWA, HALB, etc.) with the ‘account category reference’ (combination of valuation classes).
  • Maintain ‘account modification codes’ for ‘movement types.’
  • Link ‘account modification codes’ with ‘process keys’ (transaction/event keys).
  • Maintain a GL account for a given combination of ‘chart of accounts’+ ‘valuation grouping code ‘+’ account modification code ‘+’ valuation classes.’

The process of Automatic Account Determination is as follows:

  • Depending on the ‘plant’ entered during goods issue (GI), the ‘Company Code’ is determined by the system which in turn determines the relevant ‘Chart of Accounts.’
  • The plant thus entered in goods issue determines the ‘valuation class’ and then the ‘valuation grouping code.’
  • The ‘valuation class’ is determined from the ‘material master.’
  • Since the ‘account modification code’ is assigned to a ‘process key’ which is already linked to a ‘movement type,’ the ‘transaction key’ (DIF, GBB, AUM, BSX, etc.) determines the ‘GL account’ as posting transactions are predefined for each ‘movement type’ in ‘inventory management.’

You might also be interested in these posts

  • SAP Automatic Account Assignment Configuration Guide
  • MM-FI Integration in SAP R/3
  • Inter Company Billing Tutorial: Automatic Posting To Vendor Account in SAP
  • Automatic Creation of Primary and Secondary Cost Elements
  • Goods Movement Types in SAP MM

3 thoughts on “Automatic Account Assignment in SAP SD”

Technical updation of documents are necessary

how we can assign two ship to party to one sold to party

Hi Nayak, As per my knowledge, if you have not created ship-to-parties yet, you have to create it through XD01/VD01 by selecting ship-to-party account group. Then execute XD02/ VD02 with the required sold-to-party, under Sales Ares/ Partner Function you can include the created two ship-to-party here. Hope this helps. Cheers~

Leave a Comment

{{#message}}{{{message}}}{{/message}}{{^message}}Your submission failed. The server responded with {{status_text}} (code {{status_code}}). Please contact the developer of this form processor to improve this message. Learn More {{/message}}

{{#message}}{{{message}}}{{/message}}{{^message}}It appears your submission was successful. Even though the server responded OK, it is possible the submission was not processed. Please contact the developer of this form processor to improve this message. Learn More {{/message}}

Submitting…

ERProof - Blog about All Things SAP

Blog about all things SAP

ERProof » SAP SD » SAP SD Training » SAP SD Material Master

SAP SD Material Master

sap sd material master

The importance of Master Data can be understood by this example that many companies have experienced and dedicated Master Data Management resources in their Master Data Management team meaning, there are set of employees who are dedicated and solely look after Master Data they are usually called the Master Data Management (MDM) team. They carefully consider the Master Data, responsible for entering accurate data in prescribed fields. They also closely observe, look vigilantly and check thoroughly if there’s any repetition, duplication and redundancy of the Master Data.

Material master in SAP is used by different modules. Here you can find tutorials about using SAP material master in other modules:

  • SAP PP Material Master
  • SAP MM Material Master

Introduction to SAP SD Material Master

SAP SD Material Master is a centrally shared data used by all logistics modules. Information captured in the Material Master record can be descriptive or can have functional control depending on the usage. This information can be maintained across several organization levels or can be maintained for specific organization level (e.g., plant, storage location, sales organization, etc.)

SAP SD Material Master Data in SAP has several material types. Each material type has its own set of ‘Views’. By ‘Views’ in SAP Material Master data we mean areas (tabs) and their fields which are required to be filled up or populated for smooth processing of transaction and processes.

Material Master in SAP is used by following modules:

  • Material Master
  • Production Planning
  • Quality Management
  • Plant Maintenance
  • Controlling
  • Warehouse Management

Each view has its own functionality and their fields have their own meaning. If any of the view is not maintained, the respective module cannot perform their activity. E.g., to make a material salable, Sales and Distribution Views must be maintained. Similarly, to carry out quality check on the received material, Quality Management View in SAP material must be maintained with accurate settings.

Material Types

The Material Type groups materials with similar characteristics and attributes. It also determines whether the material will be valued at a standard price or at a moving average price. It also maintains which screens are to be maintained depending upon the screen sequence assigned. Once a material has been maintained in the SAP system and if any change is needed, the Material Master record can either be:

  • Extended : SAP SD Material Master extension is done when organizational level data or departmental data has not been maintained. The extension process allows the user to define these levels (e.g., the purchasing data view has not been maintained or the material has not been extended for a certain storage location)
  • Changed : If the data maintained needs to be altered, the record can be changed using the material master change transaction

SAP Material Master Data for Sales & Distribution

Sales processing is based on the following basic structures:

  • In Sales and Distribution, products are sold to Customers and / or services are performed for them. Related Master Data about the products and services are maintained in the SAP SD Material Master Data. Sales processing with the SAP System require that the master data has been stored in the system.
  • The processing of business transactions in Sales and Distribution is based on the Master Data. In the SAP System, business transactions are stored in the form of documents. These Sales and Distribution documents are structured in such a way that all necessary information in the document is stored in a systematic way.

A Material Master record is either created or extended when:

  • No Material Master Data record exists for the material in the first place.
  • Material master record exists for the material but has not been created for a certain organizational level, e.g. Plant, Sales Organization or Storage Location.

When an end user in the Sales department needs to sell a material, this user will search for the Material in the SAP. If the material is not available, the user will raise a request with the concerned department or a person responsible for Master Data creation/maintenance, so that the material master record is created in the system. The department/ person responsible for creating SAP Material Master will create Master Data by selecting correct material type and entering all the relevant information.

Master data relevant to materials is more specifically pertaining to the Materials Management (MM) module’s domain. However, each salable material is extended to a combination of Sales Organization and Distribution Channel (sales line), for carrying out sales.

Unless a material is not extended to at least one sales line, the system will not allow the user to record sales in the SAP. Material Master can be extended to multiple combinations of Sales Organizations and Distribution Channels (sales lines) by maintaining sales related views.

The following ‘Sales Views’ are relevant for all salable materials:

  • Basic sales relevant data, tax classifications, delivering plant, units of measure (e.g., base & sales unit of measure)
  • Account Assignment Group of Material, Material groupings (e.g., product hierarchy, material group)
  • Sales and Shipping data (e.g., gross and net weight, availability check strategy, transportation group, loading group), profit centre can also be entered here

Important SAP SD Material Master Transactions

Following are the key transaction related to SAP SD Material Master:

  • MM01 – Create Material Master
  • MM02 – Change Material Master
  • MM03 – Display Material Master
  • MM06 – Flag for Deletion
  • MM60 – Material Master List

How to Create SAP SD Material Master

There are two options to start the transaction for creating a new material.

  • Enter MM01 in Transaction Command Field or executing Material Master – Creation Transaction / Screen

Enter MM01 Transaction

  • Navigate through ‘Tree’

Find MM01 in the SAP Menu Tree

SAP SD Material Master Data – Sales & Distribution ‘Views’

As a responsible for SAP SD module, chances are likely that Material Master’s basic information will be maintained by a person from SAP MM team and the material number will be generated. You will be responsible for maintaining SAP Sales & Distribution relevant data in the Master Master’s Sales Views.

Let’s look at SAP’s Material Master Data Views related to Sales & Distribution Module. In the main screen of Material Master transaction (MM01), enter the material you wish to maintain SD’s views and press Enter.

Material Master – Initial Screen

Once you press Enter a dialog box will appear to select the views you wish to maintain, change or display.

Material Master – Initial Screen with ‘Views’ Selection Dialog Box

In this case, we will select Basic Data 1 and SD’s Views and press Enter .

Material Master – Initial Screen with ‘Views’ Selected in the Dialog Box

Once you press Enter, another dialog box will appear. Enter relevant Plant, Sales Organization and Distribution Channel for which you wish to maintain, change and display SD’s Material Master values and press Enter.

Material Master – Initial Screen with Organizational Levels Selection Window

Once you press Enter , you will reach the view which you have selected.

Material Master – Basic Data 1

In the Basic Data tab, as the name suggests, it contains information basic information about the product. Product’s description, Base Unit of Measure / stock keeping unit, Material Group to which it belongs, old material number, Division, Weight, Volume, Dimensions, etc. When you press Enter , after maintaining, changing or viewing the data in the tab, the system will take you to the next tab which you have selected in the previous screen.

Material Master – Sales: sales org. 1

On the screenshot above is the Sales: sales org. 1 screen. The header part contains the information which you have selected initially.

Material Master – Sales: sales org. 1 > Header

Below is the General data part:

Material Master – Sales: sales org. 1 > General data

It contains basic information like the Base Unit of Measure which have been selected by the warehouse as the lowest stock keeping unit.

Sales Unit which can be same or different to Base unit of measure. Example: warehouse stocks a material in Pieces whereas the Sales is carried out in boxes or cartons. For this, an alternate unit of measure shall be maintained which we will have a look at the later part of this tutorial.

Unit of Measure Group is the option that you can use for grouping several units of measure.

Division – the product line or group of materials to which this material belongs.

Delivering Plant – the plant from where the said material is shipped to a customer.

Material Group – option to group materials and services due to their distinct nature.

Conditions – takes you to the pricing master where you can maintain the base price of the selected material.

Material Master – Sales: sales org. 1 > Tax data

Tax Data contains the taxation details for the material country wise. A material can either be non-taxed material, half tax, full tax or exempted.

Material Master – Sales: sales org. 1 > Tax data options

Quantity stipulations contain information regarding the minimum order and delivery quantity that the customer should order so that goods can be shipped.

Delivery Unit – specific multiples in which goods can be shipping.

After you are done with Sales: sales org. 1 view, press Enter and the system will take you to the second view Sales: sales org. 2 provided that you have selected the said view on the initial views selection dialog box.

Material Master – Sales: sales org. 2

Grouping terms allows to group the material on certain criteria

Material Master – Sales: sales org. 2 > Grouping terms

Material statistics grp – is required for SIS (LIS) reporting.

Material pricing grp – is used for pricing condition purposes. Example, if you want to have a certain set of materials with the same base price or discounts, etc.

Volume rebate group – group used for rebate settlement.

Account assignment grp – used for account determination and selection relevant G/L at the time of posting Sales invoice.

Gen. item cat. grp – grouping materials to define item categories and selection of relevant item categories during sales order processing.

Item category group – used for selection of relevant item category in the Sales Order automatically.

Pricing Ref. Matl – master record that the system uses as a reference for pricing purposes.

Product Hierarchy – for grouping together materials by combining different characteristics. It is used for analyses and price determination.

Material Master – Sales: sales org. 2 > Material Groups

Material Groups are used to classify the material based on its different attributes, e.g. size, packaging, color, etc. for analysis purposes.

Once you are done with Sales: sales org. 2 view, press Enter  and the system will take you to the third view Sales: General/Plant view provided that you have selected the said view on the initial views selection dialog box.

Material Master – Sales: General / Plant

Base Unit of Measure, Gross and Net Weight – will be copied from the Basic Data screen, if they were populated there.

Availability Check – check group which defines whether and how the system checks the material’s availability and generates requirements for materials planning.

Batch Management – if the material is managed, stored and shipped in batches.

Material freight grp – is used to group materials so that they can be classified according the shipping and freight requirements.

Material Master – Sales: General / Plant > Shipping data

Shipping data contains information which is relevant for shipping and should be maintained in the material master for smooth shipping activities at the Distribution Center.

Material Master – Sales: General / Plant > Packaging material data

Packaging Material Data contains information if this material requires packaging and what type of packaging at the time of shipment / dispatch.

Material Master – Sales: General / Plant > General plant parameters

General Plant Parameters contain information if the negative of the material is all allowed. Profit Center to which this material belongs to. It is important for Profit Center Accounting in Controlling.

Additional Data – Alternate Units of Measure

As discussed briefly above, if your stock keeping unit at warehouse is different than your sales unit, the conversion of the same can be maintained in the Alternate Units of Measure. It contains, for example, ‘X’ number of Base Unit of Measure contains ‘Y’ number of Sales Unit.

material account assignment group in sap sd

Did you like this tutorial? Have any questions or comments? We would love to hear your feedback in the comments section below. It’d be a big help for us, and hopefully it’s something we can address for you in improvement of our free SAP SD tutorials.

Navigation Links

Go to next lesson: SAP Customer-Material Info Record

Go to previous lesson: SAP Customer Master Data

Go to overview of the course: Free SAP SD Training

2 thoughts on “SAP SD Material Master”

Love the clarity of this.. I had gone through so many training’s but nothing do very well structured , Simple and clear.

could provide relevant interview questions

Leave a Reply Cancel reply

Do you have a question and want it to be answered ASAP? Post it on our FORUM here --> SAP FORUM !

Your email address will not be published. Required fields are marked *

Save my name, email, and website in this browser for the next time I comment.

Online Tutorials & Training Materials | STechies.com

  • What is SAP SD?
  • SAP SD Training Tutorials for Beginners
  • SAP SD T-codes
  • SAP SD User Exit for Billing Document
  • SAP SD User Exits for Sales Order
  • SAP Customer Down Payment Configuration
  • SAP PGI (Post Goods Issue)
  • SAP IS-Retail Module
  • SAP Incoterms
  • SAP SD Variant Configuration Steps
  • SAP SD Configuration Step by Step Guide
  • SAP SD Credit Management Interview Questions
  • Account Assignment Group In SAP
  • Subcontracting Process In SAP SD
  • Rebate Processing In SAP SD
  • Difference Between Rebate And Discount
  • Movement Type In SAP
  • SAP SD Availability Check Configuration
  • Debit And Credit Note in SAP
  • Sales Documents List
  • Intercompany vs Intracompany
  • SAP SD Pricing Routines & User Exit
  • Shipping Condition In Sales Order
  • SAP SD Invoice Table
  • SAP SD Certification & Course Fees
  • SAP SD Interview Questions

Define Account Assignment Group

Updated May 18, 2018

Field found in Material Master Sales Organization 2. To define the General Ledger Posting:- IMG -> Sales and Distribution -> Account Assignment/Costing -> Revenue Account Determination -> Assign G/L Accounts With this link, the material that used this account assignment group will be posted with the desired G/L accounts during Billing. User will not be able to Release the billing document to Accounting if this is not setup. If you happened to assign it via Cust.Grp/MaterialGrp/AcctKey, then you can let your user use this report to check the material assignment. * Transaction code VKOA REPORT ZMATNR_AC_ASSIGN LINE-SIZE 132 NO STANDARD PAGE HEADING LINE-COUNT 044(001).

  • 05 Apr 2010 6:12 am Manzoor Ahmad Its very good and helpful for SD Trainee.
  • 08 Oct 2010 8:24 am Guest very nice.....

Explaining SD Billing

After completing this lesson, you will be able to:

  • Describe basic processes in sales and distribution billing .
  • Understand document integration between SD and Convergent Invoicing .

Lesson Overview

SAP Convergent Invoicing creates invoices by consolidating multiple billing streams.

In this lesson, we show how to integrate the SAP Sales and Distribution billing stream into convergent invoicing.

Business Example

A company has a rating system for usage-related charges. Hardware components and services are delivered using SAP Sales and Distribution, because material management is covered in SAP Materials Management.

Usage charges for data loads, for example, are processed from SAP Convergent Charging to convergent invoicing.

The company wants to process, post, and print SD billing documents together with usage-related charges in one invoice. Therefor, you have to integrate invoicing with sales and distribution.

This is a business example for convergent invoicing, because the billing stream for service and material from sales and distribution is brought together with the billing stream from rating and charging.

material account assignment group in sap sd

Choose Enter .

The Create Standard Order CI screen appears.

In the customer order header, enter the following:

In the table on the Sales tab page, enter the following:

As there is only one contract account for customer BP##, this is selected automatically. If two contract accounts were available, you would need to select one in the sales order.

Save the order.

Result: You have entered a sales order in the system with number:______________

Task 2: Create a Billing Document for the Sales Order

Create a billing document in SAP Sales and Distribution with reference to the sales order you entered in task 1.

In the SAP Fiori launchpad search section Sales&Distribution and choose the tile Create Billing Documents (Corresponding back-end transaction VF01).

Write down the billing document number: ______________

In the SAP Fiori launchpad search section Sales&Distribution and choose the tile Create Sales Order (Corresponding back-end transaction VF01).

From the menu, choose Billing Document → Save .

The system outputs the message: Document ________ has been saved .

Write down the order number.

Task 3: Check the CI Invoicing Order

Find your SD billing document as an invoicing order in CI. In the SAP Fiori launchpad choose tile Display Invoicing Requests in section Invoicing (Corresponding back-end transaction FKKINV_MON).

Find your SD billing document as an invoicing order in CI.

In the SAP Fiori launchpad choose tile Display Invoicing Requests in section Invoicing (Corresponding back-end transaction FKKINV_MON).

DocCat :VBRK
Source Doc:Billing Document Number

Task 4: Create a Convergent Invoice in FI-CA Convergent Invoicing Together with Other CI Billing Documents with the Invoicing SD Billing VBRK Function (INV-VBRK_DOC)

Create a CI invoice together with other billing documents.

In the SAP Fiori launchpad search section Invoicing and choose the tile Execute Invoicing - Business Partner (Corresponding back-end transaction FKKINV_S).

Create invoicing documents for your contract account CA## with the following parameters:

Invoicing ProcessZ1
Reconciliation KeyEither proposed or generated
Contract AccountCA##

Process the invoicing order with the Invoicing SD Billing VBRK function

Write down the invoice document number:______________

Refer to the task description.

Task 5: Check the Document Flow

In the SAP Fiori launchpad search section Sales&Distribution and choose the tile Manage Sales Orders (Corresponding back-end transaction VA03).

Enter your sales order and navigate to the details screen.

Choose Environment → Display Document Flow . You will find the invoicing document number from convergent invoicing.

Choose Document Flow . You will find the invoicing document number from convergent invoicing.

Log in to track your progress & complete quizzes

IMAGES

  1. Define Account Assignment Group

    material account assignment group in sap sd

  2. Materials: Account Assignment Groups

    material account assignment group in sap sd

  3. 009 Defining Material Groups in SAP SD

    material account assignment group in sap sd

  4. OVT3 SAP Tcode : C SD Table 023 Material Groups Transaction Code

    material account assignment group in sap sd

  5. SAP MM

    material account assignment group in sap sd

  6. How to Create Account Group in SAP

    material account assignment group in sap sd

VIDEO

  1. SAP SD-Class 3: Material master || Your's Yuga SAP SD

  2. 112- Material Group In SAP MM

  3. Assignment SD DISTRIBUTION CHANNEL TO SALES ORGANIZATION

  4. SD- Missing Master Data

  5. GL Configuration Steps #23 Define Account Group

  6. #2 Material Account-2 માલસામાન ના હિસાભો

COMMENTS

  1. Materials: Account Assignment Groups

    In this configuration activity we are able to define account assignment groups for materials used in Sales and Distribution Module (SD).Transaction: OVK5 IMG Path: Sales and Distribution -> Basic Functions -> Account Assignment/Costing -> Revenue Account Determination -> Check Master Data Relevant For Account Assignment Tables: TVKM, TVKMT If you use the IMG Menu, you will have to choose the ...

  2. G/L Account Determination in SAP SD

    Here Cusomter account assignment group is created which is assigned to the customer master when created in Tx- XD01. For our used material in sales order- H11, open this material in Tx- MM03 and in the Sales: sales org.2 tab, the material account assignment group is assigned to the material. Similarly for another material used in sales order ...

  3. Revenue Account Determination in SAP SD: A Comprehensive Guide

    Table of Contents. Revenue Account Determination in SAP SD. Step 1: Master Data Relevance in Account Assignment. Step 2: Defining Dependencies. Step 3: Access Sequence and Account Determination Types. Detailed Configuration Steps. Step 4: Account Determination Procedure.

  4. Automatic Account Assignment in SAP SD

    This customization in IMG is also called material account assignment and is achieved through a number of steps as detailed below: ... 3 thoughts on "Automatic Account Assignment in SAP SD" ... you have to create it through XD01/VD01 by selecting ship-to-party account group. Then execute XD02/ VD02 with the required sold-to-party, under ...

  5. Account Assignment

    The account assignment category determines: The nature of the account assignment (cost center, sales order, and so on) Which accounts are to be charged when the incoming invoice or goods receipt is posted. Which account assignment data you must provide. Account Assignment Categories. Description. Required account assignment data.

  6. Account Assignment Group

    Account Assignment Group. Technical name: 0ACCNT_ASGN. Use. The account assignment groupto which the customer is assigned. Available as from Release. 2.0. Reference Characteristic. N/A. External hierarchy.

  7. SAP SD Material Master

    SAP SD Material Master Data and Master Data Management is of core importance in SAP. Learn how to work with the part of SAP Material Master related to SD. ... Account Assignment Group of Material, Material groupings (e.g., product hierarchy, material group) Sales: General/Plant Data: ... Account assignment grp - used for account determination ...

  8. Account Assignment Group in SAP

    Definitions by Module. A collection of debit cost elements that are settled under the same settlement cost element. Account Assignment Group in SAP - Everything you need to know about Account Assignment Group; definition, explanation, tcodes, tables, wiki, relevant SAP documents, PDFs, and useful links.

  9. Define Account Assignment Group

    Here are the codes for defining Account Assignment Group in SAP SD, User will not be able to Release the billing document to Accounting if this is not setup. ... TOP-OF-PAGE. FORMAT COLOR COL_TOTAL. WRITE: / SY-DATUM, SY-UZEIT, SY-REPID, 050 'Material Sales Account Assignment', 120 SY-UNAME, SY-PAGNO. SKIP. WRITE: /001 'Material', 020 'Cust Grp ...

  10. Working with Account Assignment

    Working with Account Assignment; Media Product Sales and Distribution. 6.0 SP32. Available Versions: 6.0 EHP8 SP21 ; 6.0 EHP8 SP20 ; 6.0 EHP8 SP19 ; 6.0 EHP8 SP18 ; 6.0 EHP8 SP17 ; 6.0 EHP8 SP16 ; ... If you do not have an SAP ID, you can create one for free from the login page. Log on

  11. SAP SD

    SAP ERPSALES AND DISTRIBUTION MODULE IN SAP ERPSAP ERPSALES AND DISTRIBTION MODULE IN SAP ERPACCOUNT ASSIGNMENTSetting up account assignment,material account...

  12. Explaining SD Billing

    In customizing, the account group is assigned to the FI-CA role MKK. This is necessary for mapping the SD customer and account group to the FI-CA business partner in the role MKK. ... Create a sales order of type ZCI for business partner BP## and contract account CA## for the material P-Repair in SAP Sales and Distribution. Use sales ...

  13. Material Account Assignment Group TCodes in SAP

    Logistics - Material Master: 8 : OMS2: Maintain material Types Logistics - Material Master: 9 : ME21N: Create Purchase Order MM - Purchasing: 10 : OKB9: Change Automatic account assignment: CO - Overhead Cost Controlling: 11 : VKOA: Accnt Determination SD - Conditions: 12 : SE16 Data Browser Basis - Workbench Utilities: 13 : MMBE Stock Overview ...