Field found in Material Master Sales Organization 2.
To define the General Leger 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 happend 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
Friday, March 28, 2008
Wednesday, March 12, 2008
SAP Steps for Opening previous period in MM
If you want to open previous period for reversal entry or additional entry
The following are steps for Opening previous period in MM :
1. Go to TCode SU01 (see OSS NOTES 487381)
2. Choose "change" tab with your loging Name
3. Choose "Parameter" tab and give Parameters MMPI_READ_NOTE with date format as YYYYMMDD
4. SAVE.
5. Go to T-code MMPI
6. open the old periods which you want to post into
Note : the period opening will be valid for only for the particular day only.
7. Complete the posting you want to reverse or add
8. Go to MMPV to close the periods
Note : If we enter the date or month in MMPV means we are opening that date or month by closing previous date or month (Never use MMPV without completing the transaction in previous month)
The following are steps for Opening previous period in MM :
1. Go to TCode SU01 (see OSS NOTES 487381)
2. Choose "change" tab with your loging Name
3. Choose "Parameter" tab and give Parameters MMPI_READ_NOTE with date format as YYYYMMDD
4. SAVE.
5. Go to T-code MMPI
6. open the old periods which you want to post into
Note : the period opening will be valid for only for the particular day only.
7. Complete the posting you want to reverse or add
8. Go to MMPV to close the periods
Note : If we enter the date or month in MMPV means we are opening that date or month by closing previous date or month (Never use MMPV without completing the transaction in previous month)
Partial/residual clearing
Partial/residual clearing
Example :
$100 :Invoice (Open Item)
$ 80 :Paid(Open Item)
$ 20 :Balance
In Partial Clearing you can see $100 and $80 are cleared line items and $20 as balance
(it leaves the original invoice amount and creates new
line item for incoming amount)
In Residual Clearing you can only $30 as balance as it creates new line item and you can’t see the other cleared line items.
(it clears original invoice with incoming amount and create new line item for remaining outstanding amount. )
Use of residual clearing as it affects on aging reports.
Example :
$100 :Invoice (Open Item)
$ 80 :Paid(Open Item)
$ 20 :Balance
In Partial Clearing you can see $100 and $80 are cleared line items and $20 as balance
(it leaves the original invoice amount and creates new
line item for incoming amount)
In Residual Clearing you can only $30 as balance as it creates new line item and you can’t see the other cleared line items.
(it clears original invoice with incoming amount and create new line item for remaining outstanding amount. )
Use of residual clearing as it affects on aging reports.
Monday, March 10, 2008
SD Integration with other modules
In SAP you will always get integration with other modules.
Looking at MM and SD interaction first, take the scenario of a third party order process.
The link between SD and MM :-
1. When you create sales order in SD, all the details of the items are copied from Material master of MM.
2. MRP and availibility check related data is also taken from MM although you control this data in SD also.
3. While you create inbound/outbound delivery with reference to a sales order,the shipping point determination takes place with the help of the loading group, plant data, shipping conditions etc. This also refers to Material Master.
4. The material which you are entering in a sales order must be extended to the sales area of your sales order/customer otherwise you cannot transact with this material.
The link between SD and FI :-
1. Whenever you create a delivery with reference to a sales order, goods movement takes place in the background. eg. In case of standard sales order, you create an outbound goods delivery to the customer.
Here movement 601 takes place. This movement is configured in MM. Also, this movement hits some G/L account in FI. Every such movement of good s hits some G/L account.
2. The accounts posting in FI is done with reference to the billing documents (invoice, debit note, credit note etc) created in SD. Thus this is a link between SD and FI
3. Tax determination: In case of a tax determination also, there is a direct link between SD and MM
Sales Order – Integration Points Module
•Availability Check – MM
•Credit Check – FI
•Costing – CO/ MM
•Tax Determination – FI
•Transfer of Requirements – PP/ MM
Delivery & Goods Issue –Integration Points Module
•Availability Check – MM
•Credit Check – FI
•Reduces stock – MM
•Reduces Inventory $– FI/ CO
•Requirement Eliminated – PP/ MM
Billing – Integration Points Module
•Debit A/R – FI/ CO
•Credit Revenue – FI/ CO
•Updates G/ L - FI/ CO
(Tax, discounts, surcharges, etc.)
•Milestone Billing – PS
Return Delivery & Credit Memo – Integration Points Module
•Increases Inventory – MM
•Updates G/ L - FI
•Credit Memo – FI
•Adjustment to A/R – FI
•Reduces Revenue – FI
Looking at MM and SD interaction first, take the scenario of a third party order process.
The link between SD and MM :-
1. When you create sales order in SD, all the details of the items are copied from Material master of MM.
2. MRP and availibility check related data is also taken from MM although you control this data in SD also.
3. While you create inbound/outbound delivery with reference to a sales order,the shipping point determination takes place with the help of the loading group, plant data, shipping conditions etc. This also refers to Material Master.
4. The material which you are entering in a sales order must be extended to the sales area of your sales order/customer otherwise you cannot transact with this material.
The link between SD and FI :-
1. Whenever you create a delivery with reference to a sales order, goods movement takes place in the background. eg. In case of standard sales order, you create an outbound goods delivery to the customer.
Here movement 601 takes place. This movement is configured in MM. Also, this movement hits some G/L account in FI. Every such movement of good s hits some G/L account.
2. The accounts posting in FI is done with reference to the billing documents (invoice, debit note, credit note etc) created in SD. Thus this is a link between SD and FI
3. Tax determination: In case of a tax determination also, there is a direct link between SD and MM
Sales Order – Integration Points Module
•Availability Check – MM
•Credit Check – FI
•Costing – CO/ MM
•Tax Determination – FI
•Transfer of Requirements – PP/ MM
Delivery & Goods Issue –Integration Points Module
•Availability Check – MM
•Credit Check – FI
•Reduces stock – MM
•Reduces Inventory $– FI/ CO
•Requirement Eliminated – PP/ MM
Billing – Integration Points Module
•Debit A/R – FI/ CO
•Credit Revenue – FI/ CO
•Updates G/ L - FI/ CO
(Tax, discounts, surcharges, etc.)
•Milestone Billing – PS
Return Delivery & Credit Memo – Integration Points Module
•Increases Inventory – MM
•Updates G/ L - FI
•Credit Memo – FI
•Adjustment to A/R – FI
•Reduces Revenue – FI
Friday, March 7, 2008
GR/IR tolerance for automatic clearing
All you have to do is define a tolerance limit (Group) and assign it to the user.
The group must be assigned to the particular GL Account through its master data. In this case, you need to have accounts where clearing differences (loss or gain) will go.
Check the following t-codes: OBA0, OB57 and OBXZ
IMG > FA > GLA > Business Trn > Opn Itm clrg > Clrg differences
1. Define tolerance for GL Account (This tolerance to be assigned to that GL account)
2. Assign Users to Tolerance Groups
3. Create Accounts for Clearing Differences
The group must be assigned to the particular GL Account through its master data. In this case, you need to have accounts where clearing differences (loss or gain) will go.
Check the following t-codes: OBA0, OB57 and OBXZ
IMG > FA > GLA > Business Trn > Opn Itm clrg > Clrg differences
1. Define tolerance for GL Account (This tolerance to be assigned to that GL account)
2. Assign Users to Tolerance Groups
3. Create Accounts for Clearing Differences
Thursday, March 6, 2008
Will Source List automatically appear in Material Master as default at plant level?
If you have maintained source list requirement in OME5 and have not maintained the source listfor the material. PO cannot be released. You are required to maintain source list for all materialsin the plant where the indicator is set if you maintain source list at plant level.
Else you can make use of info record to do so automatically.
Else you can make use of info record to do so automatically.
How can we delete materials permanently from Material master?
Use transaction MM70 - Material Master->Other->Reorganization->Material->Choose.
Build variant with selection range of material master records to be selected for deletion and maintainrun parameters.Execute.
Use transaction MM71 - Material Master-> other-> Reorganizationn-->Material->Reorganization
Build a second variant, Maintain run parameters and execute.
It is also important to remove the records manually from info record, POs, PRs, reservation etcfor successful deletion of the material.
Build variant with selection range of material master records to be selected for deletion and maintainrun parameters.Execute.
Use transaction MM71 - Material Master-> other-> Reorganizationn-->Material->Reorganization
Build a second variant, Maintain run parameters and execute.
It is also important to remove the records manually from info record, POs, PRs, reservation etcfor successful deletion of the material.
Pricing in MM
Standard price are used for products that do not fluctuated frequently. It is usually used for finished or semi finished products.
Moving average price are used mainly for raw materials that are purchased externally.
The advantage of using moving average price for your raw materials is that your inventory costs will always reflect the current market cost.
SAP strongly recommends that you do not select price control V for semi-finished products and finished products, because doing so will very easily cause the calculation of unrealistic valuation prices.
SAP recommends: Price control V for raw materials and trading goods; price control S for semi-finished products and products.
If we select std price for any type of material or mav and then make po, it will pick from material master or what?
The Purchase Info Record have the FIRST priority. When no po info record is found, the Purchase Order will pick the user LAST enter price. The PO module do not pick up any price from material master.
Moving average price are used mainly for raw materials that are purchased externally.
The advantage of using moving average price for your raw materials is that your inventory costs will always reflect the current market cost.
SAP strongly recommends that you do not select price control V for semi-finished products and finished products, because doing so will very easily cause the calculation of unrealistic valuation prices.
SAP recommends: Price control V for raw materials and trading goods; price control S for semi-finished products and products.
If we select std price for any type of material or mav and then make po, it will pick from material master or what?
The Purchase Info Record have the FIRST priority. When no po info record is found, the Purchase Order will pick the user LAST enter price. The PO module do not pick up any price from material master.
ERP SAP General Question - Part 1
Q1 .Why do you usually choose to implement SAP?
There are number of technical reasons numbers of companies are planning to implement SAP. It’s highly configurable, highly secure data handling, min data redundancy, max data consistency, you can capitalize on economics of sales like purchasing, tight integration-cross function.
Q2. What is IDES?
International Demonstration and Education System. A sample application provided for faster learning and implementation.
Q3. What is SAP R/3?
A third generation set of highly integrated software modules that performs common business function based on multinational leading practice. Takes care of any enterprise however diverse in operation, spread over the world. In R/3 system all the three servers like presentation, application server and database server are located at different system.
Q4. What are internal tables check table, value table, and transparent table?
Internal table: It is a standard data type object, which exists only during the runtime of the program.
Check table: Check table will be at field level checking.
Value table: Value table will be at domain level checking.
Q5. How can an ERP such as SAP help a business owner learn more about how business operates?
In order to use an ERP system, a business person must understand the business processes and how they work together from one functional area to the other. This knowledge gives the student a much deeper understanding of how a business operates.
Using SAP as a tool to learn about ERP systems will require that the people understand the business processes and how they integrate.
Q6. Define Meta data, Master data and Transaction data
Meta Data: Data that describes the structure of data or MetaObjects is called Metadata. In other words data about data is known as Meta Data.
Master Data: Master data is data that remains unchanged over a long period of time. It contains information that is always needed in the same way. Characteristics can bear master data in BW. With master data you are dealing with attributes, texts or hierarchies.
Transaction data: Data relating to the day-to-day transactions is the Transaction data.
Q7. Name some drawbacks of SAP
Interfaces are huge problem, Determine where master data resides, Expensive, very complex, demands highly trained staff, lengthy implementation time.
There are number of technical reasons numbers of companies are planning to implement SAP. It’s highly configurable, highly secure data handling, min data redundancy, max data consistency, you can capitalize on economics of sales like purchasing, tight integration-cross function.
Q2. What is IDES?
International Demonstration and Education System. A sample application provided for faster learning and implementation.
Q3. What is SAP R/3?
A third generation set of highly integrated software modules that performs common business function based on multinational leading practice. Takes care of any enterprise however diverse in operation, spread over the world. In R/3 system all the three servers like presentation, application server and database server are located at different system.
Q4. What are internal tables check table, value table, and transparent table?
Internal table: It is a standard data type object, which exists only during the runtime of the program.
Check table: Check table will be at field level checking.
Value table: Value table will be at domain level checking.
Q5. How can an ERP such as SAP help a business owner learn more about how business operates?
In order to use an ERP system, a business person must understand the business processes and how they work together from one functional area to the other. This knowledge gives the student a much deeper understanding of how a business operates.
Using SAP as a tool to learn about ERP systems will require that the people understand the business processes and how they integrate.
Q6. Define Meta data, Master data and Transaction data
Meta Data: Data that describes the structure of data or MetaObjects is called Metadata. In other words data about data is known as Meta Data.
Master Data: Master data is data that remains unchanged over a long period of time. It contains information that is always needed in the same way. Characteristics can bear master data in BW. With master data you are dealing with attributes, texts or hierarchies.
Transaction data: Data relating to the day-to-day transactions is the Transaction data.
Q7. Name some drawbacks of SAP
Interfaces are huge problem, Determine where master data resides, Expensive, very complex, demands highly trained staff, lengthy implementation time.
Wednesday, March 5, 2008
The determination on SD?
(a) Text Determination:
Any Texts in Material Master/Material Determination/Order/Delivery , etc is meant to convey messages to the subsequent documents for compliance.
e.g. “Give Top Priority” message mentioned in Order is meant for Production Dept.
(b) Account Determination:
The integration between Finance and SD. The A/P along with Account Keys need to be allocated accordingly with combination of Account Determination Group for Customer and Material if required.
(c) Partner Determination:
To identify which type of Partner it is so that if required for same Customer different Partner Functions may be required (Ex. Only One Sold To Party per Customer. More than One Ship to Party / Bill to Party / Payer possible. Accordingly different Masters will have to be created. Useful for Despatch of Material in case of Ship to Party, sending Bill in case of Bill to Party and payment follow-up / Dunning in case of Payer.
(d) Output Determination:
What type of Output (Fax/Mail, etc) is required, where and in what Format (ABAP Customization may be required in some cases especially Invoices).
(e) Storage Location Determination:
depends on Plant, Shipping Point and Storage Conditions
Any Texts in Material Master/Material Determination/Order/Delivery , etc is meant to convey messages to the subsequent documents for compliance.
e.g. “Give Top Priority” message mentioned in Order is meant for Production Dept.
(b) Account Determination:
The integration between Finance and SD. The A/P along with Account Keys need to be allocated accordingly with combination of Account Determination Group for Customer and Material if required.
(c) Partner Determination:
To identify which type of Partner it is so that if required for same Customer different Partner Functions may be required (Ex. Only One Sold To Party per Customer. More than One Ship to Party / Bill to Party / Payer possible. Accordingly different Masters will have to be created. Useful for Despatch of Material in case of Ship to Party, sending Bill in case of Bill to Party and payment follow-up / Dunning in case of Payer.
(d) Output Determination:
What type of Output (Fax/Mail, etc) is required, where and in what Format (ABAP Customization may be required in some cases especially Invoices).
(e) Storage Location Determination:
depends on Plant, Shipping Point and Storage Conditions
Setup discount based on vendor
The procedure for applying discount based on vendor is as follow:
1) Use MEK31 and choose condition type RL01
2) Select Key Combination à Vendor
To type in the related pricing condition data: vendor, discounted percentage, valid period
1) Use MEK31 and choose condition type RL01
2) Select Key Combination à Vendor
To type in the related pricing condition data: vendor, discounted percentage, valid period
Enhance MB51: Material Document List
Fields selection for MB51 - RM07DOCS
You can enhance MB51 by reconfiguring the fields contained in the field catalog.
IMG -> Material Management -> Inventory Management and Physical Inventory -> Reporting -> Define field Selection for Material Document List
You can enhance MB51 by reconfiguring the fields contained in the field catalog.
IMG -> Material Management -> Inventory Management and Physical Inventory -> Reporting -> Define field Selection for Material Document List
ABAP technique to get the code of button
Here is a little ABAP skill to find out the code of the button that clicked by users, take the “Update” button of VA22 as an example:
Step 1) Type /h in the command box
Step 2) click the “Update” button
Step 3) In the debug mode, type “SY-UCOMM” in the field names
Then it will show the code of this “Update” button - “V69A_KONY” in the field content.
Step 4) Finally, in your userexit, you can have checking condition like:
IF SY-UCOMM = ‘V69A_KONY’.
Message ‘You have clicked the Update button’ Type ‘I’.
ENDIF.
Step 1) Type /h in the command box
Step 2) click the “Update” button
Step 3) In the debug mode, type “SY-UCOMM” in the field names
Then it will show the code of this “Update” button - “V69A_KONY” in the field content.
Step 4) Finally, in your userexit, you can have checking condition like:
IF SY-UCOMM = ‘V69A_KONY’.
Message ‘You have clicked the Update button’ Type ‘I’.
ENDIF.
Suppressing Fields in Sales Order
The fields in a sales order can be made optional / mandatoryIt can be achieved by going to this menu path -
IMG - S&D-> Basic > Functions-> Log of incomplete Procedures
Then select the fields > from the tables and the system will check for them (OVA2/VUA2)
IMG - S&D-> Basic > Functions-> Log of incomplete Procedures
Then select the fields > from the tables and the system will check for them (OVA2/VUA2)
Welcome
Hello friends,
Welcome to my SAP Study-Blogs! This is a place where we can all get together and hammer down any SAP related issues. I am trying to put together all the information from sap books and its website. I have tried to keep this blog very easy to navigate.
Hope you will find this blog useful and benefit from it. I encourage you all to give me your inputs on how to make this blogs more informative. Please let me know if you were looking for something and you could not find it here.
Also, if you have experienced some interesting scenarios which you would like to share with this forum, please write to me. I will be glad to publish them.Your comments/ feedback are always welcome. I can be reached at – alancheng328@gmail.com
Welcome to my SAP Study-Blogs! This is a place where we can all get together and hammer down any SAP related issues. I am trying to put together all the information from sap books and its website. I have tried to keep this blog very easy to navigate.
Hope you will find this blog useful and benefit from it. I encourage you all to give me your inputs on how to make this blogs more informative. Please let me know if you were looking for something and you could not find it here.
Also, if you have experienced some interesting scenarios which you would like to share with this forum, please write to me. I will be glad to publish them.Your comments/ feedback are always welcome. I can be reached at – alancheng328@gmail.com
Subscribe to:
Posts (Atom)