SAP SD FI Integration and Account Determination
SAP Sales & Distribution deals with sales to customers. So it a process where sales is made to customer against sales order and revenue is realized. That,s why SD is also called O2C (Order to Cash).
Table of Contents
1. Preparation for SD-FI Integration
We will create the sales order first . Then on the basis of sales order, we will create outbound delivery. At the time of goods issue to outbound delivery, system posts the respective amount to the corresponding GL account. This is SD-FI integration area.
1.1 Creation of Sales Order & Outbound Delivery
In the below post the process of sales order creation, Outbound delivery creation & subsequently PGI (Post Goods Issue) has been explained step by step.
2. SD-FI Integration starts From PGI of OBD
In the above post we have explained that since SD-FI configuration is still not done, so as soon as we tried to post goods issue to outbound delivery, system throws the below error.
2.1 Accounting entries at PGI
At the time of goods issue , stock is lessened by the quantity & value equal to the quantity & value of goods issue.
The offsetting entry is done on COGS (Cost of Goods Sold) account
As soon as we tried to post goods issue system throws the error due to absence of SD-FI integration configuration
2.1.1 First Error M8147 -Account determination for entry PPIN GBB not possible
This error is coming because of absence of configuration of inventory offsetting. We need to configure account determination of VAX key
VAX: for goods issues for sales orders without account assignment object (the account is not a cost element)
COGS account at the time of goods issue is determined based on this key.
For our car business GBB-VAX posting is done on GL 550200000 (PPIN-Cost of Goods Sold (Trade w/o Cost Element).
Please click HERE to check the creation of GL 550200000 step by step
Start OBYC and double click on GBB
3. Now try to post Goods Issue again
After GBB VAX configuration now try to post PGI again
3.1 Error NR751
3.1.1 Number Range 49 Maintenance for object RF_BELEG
Try PGI now
PGI is done successfully this time
Material document & accounting document is generated
3.2 FI Postings (SD-FI Integration OBD PGI Part)
System creates a material document to update the quantity in the Plant/SLOC. On the back of it, system generates an accounting document to post the values on the respective GL accounts.
3.2.1 Reminder -Check the FI document above in light of the Material Pricing
Check the material price i the material master “Accounting 1” view.
4. Account Determination in SD
Account determination in SD is also called revenue account determination
We have configured our own customized pricing procedure in the post below
The Ultimate SAP S4 HANA Sales Pricing Guide with FAQ
Account Keys (for example ERL, ERS, MWS etc. in the above screenshot) are assigned to the different conditions in the pricing procedures.
4.1 Account Assignment Groups for Materials
Account assignment groups are used to classify a material as a product, service, or equipment for the purpose of GL account differentiation.
SPRO –> IMG –> Sales and Distribution –> Basic Functions –> Account Assignment/Costing –> Revenue Account Determination –> Check Master Data Relevant For Account Assignment –> Define Account Assignment Groups for Materials
We have defined below account assignment groups for materials.
Account keys are assigned to the material master record on the material sales org 2 view.
4.2 Account Assignment Groups for Customers
Account assignment groups for customers are useful if we want to post let,s say domestic sales revenue into different account while international sales revenue should be posted into different account.
SPRO –> IMG –> Sales and Distribution –> Basic Functions –> Account Assignment/Costing –> Revenue Account Determination –> Check Master Data Relevant For Account Assignment –> Define Account Assignment Groups for Customers
4.3 Define Access Sequences and Account Determination Types
The Standard SAP has two condition types: KOFI (account determination) and KOFK (account determination with CO).
For our car business we will use the standard condition type KOFI, which uses the access sequence with the key KOFI.
The KOFI access sequence has five condition tables assigned to it
S PRO –> IMG –> Sales and Distribution –> Basic Functions –> Account Assignment/Costing –> Revenue Account Determination –> Define Access Sequences and Account Determination Types –> Define Access Sequences for Revenue Account Determination
S PRO –> IMG –> Sales and Distribution –> Basic Functions –> Account Assignment/Costing –> Revenue Account Determination –> Define Access Sequences and Account Determination Types –> Define Account Determination Types
We can now allocate our chosen access sequence KOFI to the relevant account determination type (condition type) of our pricing procedure.
4.4 Define & Assign Account Determination Procedures
Here we define account determination procedures and allocate them to the billing types.
In an account determination procedure, we define the sequence in which the system should read the account determination types (condition types).
S PRO –> IMG –> Sales and Distribution –> Basic Functions –> Account Assignment/Costing –> Revenue Account Determination –> Define And Assign Account Determination Procedures –> Define account determination procedure
S PRO –> IMG –> Sales and Distribution –> Basic Functions –> Account Assignment/Costing –> Revenue Account Determination –> Define And Assign Account Determination Procedures –> Assign Account Determination Procedure
Here we will assign our account determination procedure YPPIN0 to our customized billing type YF2
Please click HERE to check the configuration of our billing type “YF2”
4.5 Define And Assign Account Keys
We define account keys here and allocate them to the condition types in the pricing procedures. We have already defined and assigned account keys to our pricing procedure PPIN01
S PRO –> IMG –> Sales and Distribution –> Basic Functions –> Account Assignment/Costing –> Revenue Account Determination –> Define And Assign Account Keys –> Assign Account Keys
With the account keys, we group together similar accounts in financial accounting.
Using the account key, system finds the relevant GL account.
4.6 Assign G/L Accounts (VKOA)
Here based on the access sequence of tables for KOFI, we will select the table “001” Cust.Grp/MaterialGrp/AcctKey. Here we will assign all the relevant GL accounts.
Below are the components for GL assignment
S PRO –> IMG –> Sales and Distribution –> Basic Functions –> Account Assignment/Costing –> Revenue Account Determination –> Assign G/L Accounts
We have created GL account corresponding to the every key of our pricing determination.
Now assign all the three GL accounts to the respective keys
4.7 Assign G/L Accounts For Tax Posting
Here we first create the tax account for output tax and assign this to the respective key (MWS)
GL 222000000 – PPIN-Output Tax (MWS) will be used to post tax amount.
Please see HERE to see the step by step GL 222000000 account creation
Assign the GL for tax posting as per the below
SPRO –> IMG –> Financial Accounting Global Settings –> Tax on Sales/Purchases –> Posting –> Define Tax Accounts
4.8 Tax Accounts Keys MW1, MW2 & MW3
Since tax keys MW1, MW2 & MW3 are given in our output tax determination schema so system will post the tax amounts on the GL accounts corresponding to these three keys
We have given GL 222000000 for all the three tax keys
5. Create Billing
now the next part of the O2C cycle is to post the billing. At the time of billing system will post the respective values onto the determined & assigned GL accounts as per the revenue account determination procedure.
start VF01 and input our Outbound delivery number
Create the billing and click on
Billing Documents –> Release to Accounting
system throws the below error
5.1 Error KI235 -GL requires an account assignment relevant to cost accounting
system throws the below error.
To resolve this error we need to activate profit center accounting as well as cost center accounting for our controlling area.
5.1.1 Profit Center Accounting
First we need to set our controlling area PPIN to set up Profit Center Accounting.
Then we need to maintain the global settings for Profit Center Accounting in our controlling area PPIN.
5.1.1.1 Controlling Area setting for Profit Center Accounting
We will set our controlling area PPIN
SPRO –> IMG –> Controlling –> Profit Center Accounting –> Profit Center Accounting –> Set Controlling Area
5.1.1.2 Maintain Controlling Area setting
Maintain the PPIN controlling area setting as below
SPRO –> IMG –> Controlling –> Profit Center Accounting –> Controlling Area Settings–> Maintain Controlling Area Settings
5.1.2 Create Profit Center
Run KE51 and created profit center “SALES”
5.1.3 Cost Center Accounting
we need to first activate cost center accounting on our controlling area.
SPRO –> IMG –> Controlling –> Cost Center Accounting –> Activate Cost Center Accounting in Controlling Area
activate for our controlling area PPIN
5.3.1.1 Create Cost Center
Start KS01 and create cost center “Cost”
5.2 Error KI235 -Resolution (OKB9)
Since now we have created profit center & cost center so assign them to the respective cost element under OKB9 to resolve this error
6. Create Billing – Retry after Error Resolution
Start VF01 and input outbound delivery number and press enter
Billing document is successfully posted to accounting
6.1 Accounting Entries at Billing
Billing is now created and released to accounting
Display accounting document
SD-FI integration completes here.
Picture Courtesy : Inter vector created by rawpixel.com – www.freepik.com
Join the discussion Cancel reply
Further reading.
Configure SAP S4 HANA SD Output Tax in 6 Quick Steps
An Ultimate guide to Sales Order in SAP S4 HANA SD
Configure SAP S4 HANA Sales Documents in 10 Minutes
G/L Account Determination in SAP SD
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
Lets create a debit memo request for the sales area 1000/10/10.
Provide the customer number and few materials and its quantity and double click on the first material to see the item details.
From the pricing procedure – for the pricing condition type- PR00 material value is calculated as 175.50 EUR.
For the second material for the pricing condition type- PR00 material value is calculated as 1598.00 EUR. Go back.
Select the header button.
In the header section, in the Conditions tab, the total price is the sum of two materials.
Save and DMR is created.
Go to Tx- VA02 and from the menu choose Billing.
Select Save button to create a billing document. mark billing document type is determined as – L2.
Go to Tx- VF03 and display the billing document. Choose Accounting button.
Choose Accounting document.
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.
Go to Tx- VF02 and edit the billing document.
From menu, navigate along the highlighted path.
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.
Same for the second item.
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.
For the demo we use company code- 1000
The chart of account is – YIKR
Next step , the customizing in the Sales&Distribution section for the Account Assignment/Costing.
First execute – Check master data relevant for account assignment.
Select first option- Materials : Account Assignment Groups.
Here Material account assignment group is created which is assigned to the material master when created in Tx- MM01
Select second option- Customer : Account Assignment Groups.
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, it is assigned to the material account assignment group.
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.
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.
Next is defining the access sequence and the condition type. So choose the highlighted opton.
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.
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.
Access line-10 with condition table 001 has 4 fields.
Similarly for other access lines with condition tables other fields are there.
For access line 30.
For access line 40.
Choose Define Account Determination type.
Here Condition type- KOFI is created which is assigned to the access sequence KOFI which has 5 access lines with different condition tables.
Choose the option as pointed to create account determination procedure.
Procedure KOFI00 is created and assigned to the account condition types. Choose the procedure and select Control data from left side.
Here the account determination procedure is assigned to the condition type.
Choose the option – Assign account determination procedure.
Here the account determination procedure is assigned to the billing type.
Next step is to define account key. Choose the marked option.
For different types like revenue, tax and other different account keys are defined. For revenue its ERL.
Next step is to assign the account key to the pricing procedure – condition type PR00.
Here for the pricing procedure ZVAA01 and condition type PR00, the account key is assigned as ERL.
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.
Next time is to assign the G/L account. Choose the marked option.
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.
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).
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
- 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
- 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
Blog about all things SAP
ERProof » SAP CO » SAP CO Training » SAP CO Account Assignment
SAP CO Account Assignment
Normally, when a financial document is entered in SAP FI module , user has the option of entering the cost center in the financial document. However, when documents are entered from different modules or a cross-module financial transaction occurs, such as from MM or SD , there is no option of entering the cost center in the document. In this situation, the SAP system will derive the cost center through automatic SAP CO account assignment, substitutions, or through default settings made in the primary cost element.
Automatic SAP CO Account Assignment
The automatic account assignment has to be configured in the transaction code OKB9 . For posting made in external accounting, such as for price differences, exchange rate differences, etc., the SAP system automatically checks entries in the OKB9 settings and derives the cost center.
If you do not enter a CO object (order, cost center, or project) in external accounting postings made in FI, MM or SD modules and the posting is cost relevant, then the automatic account assignment checks the relevant cost center and makes the posting.
Here are examples of automatic account assignments:
- Banking fees, exchange rate differences and discounts in FI
- Minor differences and price differences in MM
The account assignment objects that can be maintained in the transaction OKB9 are:
- Cost center
- Profit center (profitability segment)
Normally, the automatic account assignment runs on the company code level along with the CO object. However, if the user wants to make the posting on the business area level, valuation area level or profit center level, it is also available in OKB9 settings. So basically it includes the following levels:
- Company code level
- Business area level
- Valuation area level
- Profit center level
The above 3 excluding the company code level are used in cases when the account assignment is needed below the company code level.
Prerequisites
Here are the prerequisites of activating automatic SAP CO account assignment:
- Activation of the cost center accounting
- Creation of cost centers
- Maintenance of cost elements
Additionally, you can also create orders and profit centers as per the business requirements.
Settings in Transaction OKB9
Let’s discuss settings that are possible for automatic SAP CO account assignment in OKB9 transaction.
Start SPRO transaction and navigate to the following path:
Controlling – Cost Center Accounting – Actual Postings – Manual Actual Postings – Edit Automatic Account Assignment (OKB9)
Alternatively, you can start OKB9 transaction directly from the command bar.
- If you want to have the setting on the company code level only, then enter the company code and the cost element along with the corresponding CO object, i.e. a cost center, an order or a profit center.
- If you want to have the settings on the valuation area level, then enter the company code and the cost element and chose the ‘valuation area’ option in the account assignment detail as ‘1’.
- Similarly, if you want to have the settings on the business area or profit center level, then choose the option ‘2’ or ‘3’ respectively.
If you have chosen account assignment detail ‘1’ or ‘2’, then click on ‘Detail per business area/valuation area’ on the left sidebar.
Default SAP CO Account Assignment
In order to determine the correct CO account assignment, the SAP system performs several checks in the following sequence. First it checks the document which a user is posting. If the cost center is empty in the document, then the system checks if any substitutions are maintained for the particular G/L account . Next, if the substitution is also missing, then the system moves on to the OKB9 settings for automatic SAP CO account assignments. Finally, if these settings are also missing, the SAP system checks master data of the primary cost element (G/L Account) under the tab of Default Account Assignment . You can display this master data using the transaction KA03 .
You can maintain the cost center and the order in the master data of the primary cost element.
So, basically the order of checks the system makes is:
- Financial document – Cost center
- Substitutions – transaction OKC9
- Automatic account assignments – transaction OKB9
- Default account assignments – transaction KA03 / KA02
Lastly, if any of the above is not maintained, then the SAP system throws an error ‘Account X requires an assignment to a CO Object’ and doesn’t allow posting of a document.
SAP CO Account Assignment using Substitution
In cases where you don’t need OKB9 or default account assignment, the user can go for user exits where a specific G/L account is mentioned under the company and the value in the cost center is substituted by the cost center given in the substitution.
The transaction for maintaining the substitution is GGB1 .
Usage of substitutions for SAP CO account assignment is justified by the business requirement and usually SAP CO account assignment requirements are fulfilled by OKB9 or default account assignments.
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 CO tutorials.
Navigation Links
Go to next lesson: SAP Adjustment Postings
Go to previous lesson: SAP Profit Center
Go to overview of the course: Free SAP CO Training
4 thoughts on “SAP CO Account Assignment”
it is helpful material i ask for more clear details for using substitution method for Account Assignment. thanks in advance
Sir, I am not receiving the training mails from yesterday 7/1/2019. I have completed my training till here(SAP CO Account Assignment) please do send the rest of the training emails for SAP CO. Hope you will do the needful.
I am getting the same error “Account 500911 requires an assignment to a CO object”. In OKB9, we have given company code, Cost element and ticked the check box ‘Indicator: Find profitability segment using substitution’ (V_TKA3A-BSSUBST) and not filled anything like cost center, order and profit center. in OKC9 we have created substitution. All the process happening through Idoc Message Type SINGLESETTRQS_CREATE and inside BAPI BAPI_SINGLESETTREQS_CREATEMULT triggering and raising this error. Cost center is not maintained in 1. Financial document – Cost center 2. Automatic account assignments – transaction OKB9 and 3. Default account assignments – transaction KA03/KA02 But we have substitution in transaction OKC9 to determine cost centre.
Where woulbe be the issue?
good explanation
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.
In this topic, we described about the Customer Account Group and Create Customer Account Group process along with technical information.
Account group is the highest level of customer master data. Customers are classified into various account groups.
Account Group functionalities -
- Controls the field of customer master.
- Classifies customers to use for various functions.
- Links the partner functions.
Create Customer Account Group: -
Below process is to create the customer account group TCAG (Test Customer Account Group).
Step-1: Enter the transaction code OBD2 in the SAP command field and click Enter to continue.
Enter the transaction code SPRO in the SAP command field and click Enter to continue.
Click on SAP Reference IMG .
Expand SAP Customizing Implementation Guide → Financial Accounting → Accounts Receivables and Accounts Payables → Customer Accounts → Master Data → Preparations for creating customer master data → Define Account Groups with screen layout (Customers) . Click on Execute .
Step-2: In the next screen, click on New Entries on the application bar.
Step-3: Enter the below details.
- Customer Account Group − 4-digit account group.
- Field Status
Step-4: Select the respective Field Status and click on Edit Field Status .
Step-5: In the next screen, Select the Group of fields for which want to maintain Field Status.
Step-6: In the next screen, select the radio buttons for the Field Status of the selected Group.
Repeat the above process until all the groups are edited.
Step-7: Once all the details entered, click on the Save button to save the changes.
Step-8 It prompt for the Change Request. Click on tick mark .
Step-9: Status bar displays the below message once the Customer Account Group saved successfully.
Use the below transaction to create Vendor Account Groups - OBD3 - Create Vendor Account Groups .
Technical details: -
- Transaction: OBD2
- Menu Path: SPRO → SAP Reference IMG → SAP Customizing Implementation Guide → Financial Accounting → Accounts Receivables and Accounts Payables → Customer Accounts → Master Data → Preparations for creating customer master data → Define Account Groups with screen layout (Customers)
SAP SD Tutorials
Introduction.
- Introduction to SAP SD
- Enterprise Structure
- Company code
- Sales Organisation
- Distribution Channel
- Plants in SAP
- Storage Location in SAP
- Shipping Point
- Loading Point
Master Data
- S/4 Hana Business Partner
- Material Master
- Customer Material Info
Sales Documents
- Overview of Sales Document
- SalesDocument Configuration
- Sales Document Determination
Item Categories
- Overview of Item Categories
- Item Category Configuration
- Item Category Determination
Schedule Line Categories
- Schedule Line Category
Copy Control
- Copy Control for Sales Documents
- Condition Types
- Understanding Pricing Scales in SAP S/4HANA
- Defining Condition Tables
- Configuring Access Sequences
Basic Functions
- Free Goods Determination
- Material Determination
- Listing/Execution
- Cross Selling
- Incompletion Log
- Item Proposal
- Revenue Account Determination
- Reconciliation Account
- Cash Account Determination
- Delivery Scheduling
- Availability Check
- Back Order Processing
- Rescheduling
- Transfer Of Requirements
- Credit Management
- Output Determination
- Text Determination
- Copy Controls
SAP SD Business Processes
- Standard Business Process
- Consignment Process
- Third Party Business Process
- Individual Purchase Order (IPO)
- Make To Order Process
- Stock Transport Order (STO)
- STO Returns Process
- Inter Company STO Process
- Inter Company Sales & Billing
How Customer Account Groups in SAP SD are created | Saphanatutor.com
Introduction to customer account groups in sap sd.
Customer Account groups in SAP SD are essential for effectively managing and organizing customer and vendor data. They play a key role in defining the structure and attributes of customer and vendor master records. Below are some of their critical functions:
Table of Contents
- Field Selection Control : Account groups determine which fields in the master record are mandatory, optional, or hidden. This standardization ensures consistency and completeness in data entry.
- Number Range Definition : Account groups assign specific number ranges to customer or vendor accounts. This assignment dictates whether account numbers are generated automatically by the system or entered manually.
- Master Data Management : These groups control the maintenance of master data for customers or vendors. This includes creating, modifying, and viewing master records.
- Customer/Vendor Classification : Account groups classify customers or vendors into distinct categories, simplifying management and analysis. For example, they can differentiate between domestic and international customers.
In SAP S/4HANA Sales, standard customer account groups are essential for managing customer master data, each serving specific roles in sales transactions. These include:
- Sold-To Party (SP) : Customers who receive goods or services.
- Ship-To Party (SH) : Customers to whom goods or services are delivered.
- Bill-To Party ( BP ) : Customers responsible for invoice payments.
- Payer (PY) : Customers who make the actual payments.
- Contact Person (CP) : Individuals serving as contact points at customer locations.
These account groups organize customer data efficiently, catering to different aspects of sales and distribution processes in SAP S/4HANA. These standard account groups are designed to address typical business scenarios in SAP systems. They can be adjusted or augmented with new groups to align better with specific business processes and needs.
Step by step process to create Customer Account Groups in SAP SD
In this SAP Sd tutorial , we are creating a new customer account group called “ SAHT ” with a number range “ ZS ” . In SAP SD creating Account groups are like setting up a new category in your customer database. You’ll give it a name, maybe a description that explains it’s for customers related to products, and then assign a unique code “ ZS ” to identify customers in this group.
- Create Number range intervals for customer Account groups.
- Create Customer Account Groups and assign the number ranges intervals.
Creating Customer Account Groups in SAP SD (OVT0)
First, log into the SAP system using your credentials. Then, go to the section where you manage customer account groups, using a specific code (like OVT0 ). Here, you’ll add a new entry for your “SAHT” group.
- Transaction code : OVT0
- Img path : SPRO => Logistics general => Business partner => Customer control => define a/c group and field selection for customer.
Select the Standard Account Group “0001” (Sold to party) and define your own Account Group (SHT) as shown below.
As shown below, enter your desired Account name and select the number ranges that created earlier.
Save the Settings.
Customer Account Group is SAP SD has been created Successfully.
To check open the transaction code XD01 to create Customer Account Groups in Sales and Distribution.
In this SAP SD tutorial, we successfully covered how to create an Account Group within the Customer Master, a key step for managing customer data effectively in SAP. Next up, we’re preparing an in-depth, step-by-step guide on the Partner Determination Procedure in SAP SD.
Related posts:
- Most used SAP SD Transaction codes in Realtime
- SAP SD TCodes List
- Revenue Account Determination in SAP SD: A Comprehensive Guide
- Defining Number Ranges for Customer Account Group | XDN1
- Comprehensive Guide to SAP Customer Master
- TutorialKart
- SAP Tutorials
- Salesforce Admin
- Salesforce Developer
- Visualforce
- Informatica
- Kafka Tutorial
- Spark Tutorial
- Tomcat Tutorial
- Python Tkinter
Programming
- Bash Script
- Julia Tutorial
- CouchDB Tutorial
- MongoDB Tutorial
- PostgreSQL Tutorial
- Android Compose
- Flutter Tutorial
- Kotlin Android
Web & Server
- Selenium Java
- SAP SD Tutorials
- SAP SD Enterprise Structure
- SAP SD - Define Sales Organization
- SAP SD - Define Distribution Channel
- SSAP SD - AP SD - Define Division
- SAP SD - Maintain Sales office
- SAP SD - Define Sales Group
- SAP SD - Define Sales Area
- SAP SD - Define Company Code
- SAP SD - Define Shipping Point
- SAP SD - Assignment of Organizational Units
- SAP SD - Assigning a Sales Organization to a Company Code
- Assigning a Distribution Channel to a Company Code
- SAP SD - Assigning a Division to a Sales Organization
- SAP SD - Assigning a Sales office to a Sales Area
- SAP SD - Assigning a Sales Group to a Sales Office
- SAP SD - Assigning a Sales Area to Credit Control Area
- SAP SD - Define sales area
- SAP SD Customer Master Data
- SAP SD - Create customer account groups
- SAP SD - Maintain number ranges for customer account groups
- SAP SD - Assign number ranges to customer account groups
- SAP SD - Define tolerance group for Customers
- SAP SD - Create sundry debtors accounts
- SAP SD - Partner determination procedures
- SAP SD - Create Customer Master Record
- SAP SD Pricing & Tax Determination
- SAP SD - What is pricing
- SAP SD - Maintain condition tables
- ADVERTISEMENT
- SAP SD - Maintain access sequences
- SAP SD - Maintain condition types
- SAP SD - Maintain pricing procedure
- SAP SD - Define pricing procedure determination
- SAP SD Sales Documents
- SAP SD - Define order reasons
- SAP SD - Define purchase order types
- SAP SD - Define item categories
- SAP SD - Assign item categories
- SAP SD - Define item category groups
- SAP SD - Define schedule line categories
- SAP SD - Assign schedule line categories
- SAP SD - Define sales document type
- SAP SD - Credit and Risk Management
- SAP SD - Maintain credit control area
- SAP SD - Assign credit control area to company code
- SAP SD - Define risk categories
- SAP SD - Define credit groups
- SAP SD - Assign sales documents & delivery documents
- SAP SD - Credit limit for customers
- SAP SD TCodes
- ❯ SAP SD Tutorials
- ❯ SAP SD - Partner determination procedures
Setup Partner Determination Procedure in SAP SD
In this tutorial, you will learn how to define partner functions and setup partner determination procedure in SAP SD step by step using Tcode VOPAN.
How to setup partner determination procedure in SAP
In order to get the required partner functions into customer master data, we have to define partner determination procedure in SAP SD .
Partner determination procedure configuration steps
Step 1 : – Execute tocde “VOPAN” in the SAP command field.
Step 2 : – On maintain partner determination screen, choose partner object customer master and click on change button.
Step 3 : – Define partner functions
For each partner function you have to specify a corresponding partner type which controls the functionality of partner. For a partner function, if the partner type is “KU” it becomes customer and if partner type is “IS” it becomes vendor. For a partner function if we check the fields unique, than we can have only partner of that function within a customer master. “SP” is always unique.
From partner determination procedures overview screen, click on new entries to create new partner determination procedure entries as per the requirements of client.
Under dialog structure, choose partner functions option.
From change view partner functions overview screen, click on new entries button to define the new partner functions in SAP.
On new entries partner functions screen, enter the following details.
- Partner : – Enter the key that defines as partner function in SAP
- Name : – Description name of partner functions in SAP
- Partner type : – Update the partner type key from the list, KU represents as customer.
- Error : – It automatically updates by the system, when you press enter from keyboard.
Click on save button and save the configured partner functions in SAP.
Step 4 : – Assign partner function to account group
Choose Account groups -Function assignment and click on new entries button as shown below image.
From new entries account group function assignment screen, enter the following details.
- Partner function : – Enter the partner function key “TC” in the field.
- Account Grp : – Enter the account group key for assignment of partner functions to the required customer account group .
Click on save button and save the details.
Step 5 : – Define partner determination procedure
Under dialog structure, choose the partner determination procedure and click on new entries button for creation of new partner determination procedure in SAP SD module.
On new entries partner determination procedures screen, update the following details.
- Part.Det.Proc : – Update four digits key that identifies as partner determination procedures in SAP.
- Name : – Enter the description of partner determination procedure key.
Click on save button and save the configured details.
Step 6 : – Partner functions in Procedure
Choose defined partner determination procedure key and double click on partner functions in procedure.
On change view partner functions in procedure overview screen, choose new entries button for assignment of partner functions to partner determination procedure.
On new entries assignment screen, assign the partner functions for partner determination procedure key and choose the check box for not modifiable, mandatory function if required.
After maintaining all the required details, choose save button and save the details.
Successfully we have created partner functions and partner determination procedures in SAP.
Popular Courses by TutorialKart
App developement, web development, online tools.
IMAGES
VIDEO
COMMENTS
Now, create the account determination procedure. IMG -> SD -> Basic fncs -> Account Assignment >> Revenue account determination >> Define and assign account determination procedures [std = KOFI00 - KOFI, KOFK] The account determination procedure is then assigned to a billing type. The column described as "CaAc" represents the cash allocation ...
SD Account Assignment. Can anyone tell me if it is possible to have cost centre as an account assignment object in a sales order item and if so, which configuration table can be used to control this. This may seem like an unusual question, but this is for a process where costs collected in a cost centre are recharged using a sundry sales process.
SAP SDACCOUNT ASSIGNMENTAccount assignment configuration steps,Creating condition tables,Defining an access sequence,maintaining account determination types ...
Item Category. Purchase Order - Single-Screen Transaction (ME21N, ME22N, and ME23N) Creating a Purchase Order (ME21) Account Assignment. Specifying Single Account Assignment. Specifying Multiple Account Assignment. Units of Measure in Purchase Orders. Incoterms and Shipping/Delivery Instructions. Goods-Receipt-Based Invoice Verification.
Account assignment is used to find. the revenue accounts to which prices are posted. the sales deduction accounts to which surcharges and discounts are posted. In the standard version of the SAP System, all billing types are defined in such a way that the offsetting entry is made to the customer account.
SAP ERPSALES AND DISTRIBUTION MODULE IN SAP ERPSAP ERPSALES AND DISTRIBTION MODULE IN SAP ERPACCOUNT ASSIGNMENTSetting up account assignment,material account...
The Standard SAP has two condition types: KOFI (account determination) and KOFK (account determination with CO). For our car business we will use the standard condition type KOFI, which uses the access sequence with the key KOFI. The KOFI access sequence has five condition tables assigned to it. S PRO -> IMG -> Sales and Distribution ...
Step-2: In the next screen, Click on New Entries button. Step-3: Enter the below details and click on Enter. ActKy -- Enter 3-digit alphanumeric account key. Name -- Enter the account description. Step-4: Once all the details entered, click on the Save button to save the changes. Step-5: It prompt for the Change Request.
The term Account Assignment has different meanings depending on the context and Application. Here are the definitions by Application Component or Module. The accounting objects and/or accounts that are posted for a business transaction. The accounting object and/or the general ledger account to which items are posted in a document row.
In SAP S4HANA / ECC we can assign different GL accounts in SD to different Customers and Materials using the Account Assignment Groups, this video explains t...
G/L Account Determination in SAP SD 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. ... Here Material account assignment group is created which is assigned to the material master ...
SAP SD Partner Determination in Customer Master. ... Select the folder "Account Group - Function Assignment" and enter the partner function before assigning it to the correct account group. After that, double click on the folder "Partner Determination Procedure Assignment". Here, you will need to assign the partner determination ...
This tutorial is part of our free SAP CO training. You will learn how account assignment works in SAP ERP and what are different sources of information about account assignment that the SAP system uses. Normally, when a financial document is entered in SAP FI module, user has the option of entering the cost center in the financial document.
SAP ABAP FM (Function Module) : SD_DOCUMENT_ACCOUNT_ASSIGNMENT - Pr. The sales document to which you want to refer is based on sales document 10000003 and item 000010.
Click on Execute. Step-2: In the next screen, click on New Entries on the application bar. Step-3: Enter the below details. Customer Account Group − 4-digit account group. Name. Field Status. Step-4: Select the respective Field Status and click on Edit Field Status. Step-5: In the next screen, Select the Group of fields for which want to ...
In SAP S4HANA We can assign different GL accounts to different Sales Conditions using the Account Keys, this video explains the configuration stepsSupport th...
Creating Customer Account Groups in SAP SD (OVT0) First, log into the SAP system using your credentials. Then, go to the section where you manage customer account groups, using a specific code (like OVT0 ). Here, you'll add a new entry for your "SAHT" group. Transaction code : OVT0.
Use. You can assign one or more account assignments to an item. Multiple account assignment allows you to apportion the costs covered by a purchase order partly to your own cost center and partly to others, for example. You specify which account assignment object is to be charged via the account assignment category.
This client creates a work/service order to detail infomation about work that has to be done at the field or customer site. The customer costs are charged through SD. However, they want to be able to transfer some of the costs from the SD billing document to the work order to reflect the project costs that were charged to the customer. Like 0.
Partner determination procedure configuration steps. Step 1 : - Execute tocde "VOPAN" in the SAP command field. Step 2 : - On maintain partner determination screen, choose partner object customer master and click on change button. ADVERTISEMENT. Step 3 : - Define partner functions. For each partner function you have to specify a ...
The account group controls: The type of number assignment used for the account number. A number interval from which the account number is chosen. The system uses the account number to identify the customer. Which fields are displayed when you enter or change customer master data and whether or not an entry must be made in these fields (field ...
Assignment. A value that defines the level of authorization or permission to access a resource or system. An assignment contains details regarding the requesting user, group, or object and the requested authorization, system, or permission. In an access control scenario, a user can request access to resources, systems, and role assignments ...
The account assignment category indicates whether an item is to be assigned to an auxiliary account such as a cost center. It also determines which account assignment details are required for the item, for example, cost center or account number. This CDS view provides the data to answer the following business questions: