Master Data Flashcards
Master Data
Permanent data, used for eternity
Ex: Customer number
Transactional Data
Transient data, exists for a particular moment of time
Ex: An order
3 views of of Customer Master
General Data
Sales Area Data
Company Code Data
VD01/2/3
Create(extend), Change, Display General/Sales Area Data
Important Sales Area Data: Sales Tab fields
- Customer group
- Currency
Important Sales Area Data: Shipping Tab fields
Shipping Condition Order Combination Flag Complete delivery Flag Under deliverance tolerance Over deliverance tolerance
Important Sales Area Data: Billing Tab fields
Incoterms Terms of payment Account assignment group Invoice dates Invoice list dates Tax classification
“Extending the view”
Using an already existing customer, and creating another view for said customer
Extending the org data
Field Changes for customer master
Checking the changes in the customer master
Additional Data in customer master is used for…
Further fields to classify customers in customer master
CMOD
Customer Account Group
Determines how the customer master behaves i.e. which fields and tabs are available for the customer
You can configure the different customer account groups
Material Type
Dictates the way a material behaves, which is based on the views that the material type allows
Material Master Views for Sales Consultant
Basic Data 1 Sales Org Data 1/2 Sales General/Plant Data MRP 1 Accounting 1
Key Material Master Fields
Base Unit of Measure Material Group Minimum order quantity Minimum delivery quantity Tax classification
Valuation
How the acquired cost of a material is calculated
Material group in basic data and sales org data…
must be the same
Sales Org Material Group
Used to further classify a material in a sales group
Product Hierarchy format
18 characters limit
first 5 represent the first level
second 5 represent the second level
third 8 represent the last level
The break up of the 18 is customizable
4 options for customizing the Customer Account Group Tab field options
Suppress
Required Entry
Optional Entry
Display
VD05
Block customer
Master Data is not deleted, but it can be…
Archived
VD06
Flag customer for deletion
Common Distribution Channel
Distribution Channel used by multiple sales orgs, condition records, materials, and customers.
Reasons for Enterprise Structure
Reporting (fundamental reason) - Internal (sales reports, operational reports, only relevant for company employees) - External (government, SEC) Operational
Key Org element used for reporting…
Company Code
Material Master field: Moving Price
Determines the purchasing price of a material based on the average of the prices of the different good receipts. The price that is automatically adjusted in the material master record when price variances occur. If goods movements or invoice receipts are posted using a price that differs from the moving average price, the differences are posted to the stock account; as a result, the moving average price and the value of the stock change.
Material Master field: Standard Price
Determines the purchasing price of a material based on one material. The value of the material that is always calculated at this price. If goods movements or invoice receipts contain a price that differs from the standard price, the differences are posted to a price difference account. The variance is not taken into account in valuation.
Customer account group configuration: General Data fields
- Number range
- One-time acct flag
Customer account group configuration: Text procd fields
- CentrTextDetPrec
- TextDetProc SD
Customer account group configuration: Sales and distribution data fields
Cust pric proc PartnDetProc OutputDetProc Competitiors flag Sales partner flag Prospect flag Default SP flag Consumer flag
Partner function and procedure process
- Create a partner function i.e. SP, SH, PY etc
- Assign the partner function with an account group
- Go to the desired partner procedure, and add the desired partner function to be included
Partner function creation fields
- Partner function ID
- Name
- Partner type i.e. customer, contact person, logical system vender etc
- Unique flag
In order to have partner functions in SD documents and their sections…
You have to do the partner function/partner determination procedure for the different document sections i.e. Customer master, Sales Doc header, Sales doc item, Delivery, Billing doc header, billing doc item
The partner functions in the partner determination procedure has X exclusively for SD documents and their sections
Source field (if left blank, SAP uses the partner determination procedure of the customer master) Sequence
Fields in partner function in the partner determination procedure
- Mandatory
- Non-modifiable
Partner function conversion
Converting standard SAP partner functions ID to other another ID for language reasons
AG - SP sold-to
RG - PY payer
Partner functions exist in 3 layers..
- The customer master
- The different account groups i.e. SP, SH, PY etc
- The Document header
- The different sales documents i.e. Standard order, Rush order etc
- The Document item
- The sales order item category i.e. TANN, TAS etc
Source field in Partner function in partner determination procedure
The source to determine the partner function in X SD document
Sequence field in Partner function in partner determination procedure
This determines the priority in which the records need to be determined. This value needs to be higher than the figure of the source partner function.
I.e. if partner function is AP (contact person), source is a SH, and sequence is 1, then SAP will first look for SH, then only after SH is found, it will pick the AP from the SH
Alternative materials for BOM
Alternative materials for a BOM are added as lower level components but differentiated by group number ID
Data to be maintained in a BOM
Priority
Strategy
Usage probability
Data to be maintained in a BOM: Priority
Defines the priority of the item within an alternative item group. This determines the priority for planned withdrawal of items.
Data to be maintained in a BOM: Strategy
Strategy will determine how selection of the item for planned withdrawal is controlled within the alternative item group. Strategy should be the same for all alternative items in an alternative item group. If the value 2 (100% check) is defined for the strategy, the first material in the defined priority sequence for which sufficient quantities are available is reserved.
Data to be maintained in a BOM: Usage probability
MRP plans these alternative material components according to probability of use. Percentage is entered to show the probability of using an object in production. Material requirements for the BOM components are planned according to the usage probability. The planned withdrawal for the production order is based on reservation lists. These lists are based on the priority and strategy for the alternative item.
How to extend material master views
MM01
Access material data requires organizational levels…
Plant
Sales org
Distribution Channel
What is defined with the account group?
Texts of the customer master record
Partners tab of the customer master record
The number range