Master Data in SD

Download as docx, pdf, or txt
Download as docx, pdf, or txt
You are on page 1of 40

Page 1 of 40

MASTER DATA IN SD
Customer Master

The customer master is a data record that contains all the information
pertaining to
a client, a customer, or any other business partner who plays a role in the
business.
As noted, a master data record is shared and updated across the
organization. The
customer master data is used and updated by the sales department (which
maintains
the customer groups, preferences, classification, and so on) and the finance/
accounting department (which is more concerned with things such as bank
details,
credit classification, and account numbers). The common datasuch as the
customers
name and addressis used centrally. Based on this requirement, SAP
structures
customer master data into three parts:
1)General data, which is common to the entire organization
2)Sales data, which is specific to a sales area
3)Company code data, which is specific to the company code
This breakdown enables you to segregate authorizations and structure the
customer
master data.

Common Terms in Customer Master Data


Before proceeding with how to set up the customer master, you need to understand
what partner functions and account groups are.
Partner Functions
In each sales transaction, different groups or individuals can have different
roles
and responsibilities. For example, at the customer location, the party who
places the
order can be different from the receiving party. In addition, an invoice may
need to
go to a different address than that of the payer. Therefore, you have to map
all these
different roles in the system, which are called partner functions.
When you create customer master data, you also specify the roles that the
customer

Page 2 of 40

will play. SAP then copies this information to all the sales documents for this
customer.
Thus, you can ensure that the delivery is shipped to the door of the ship-to
party and that the correct payer is scheduled to make the payments.
The following partner functions are the most frequently used:
1)Sold-to party (AG)
2)Ship-to party (AU)
3)Bill-to party (RE)
4)Payer (RG)

Account Groups
Each partner function is assigned to an account group. Account groups are
primarily
used to control the screens and fields required to maintain data for each
customer,
based on the customers roles. As you will see in the subsequent sections,
you
can control several important settings based on the account group.

Creating Customer Master Data


The menu path to access customer master data is SAP Menu Logistics Sales
and Distribution Master Data Business Partner Customer.
Under Business Partner (see Figure 3.1), the nodes let you create or change other
business partners such as sales partners and forwarding agents.
You can use three sets of transaction codes to create and update customer master
records:
XD01 XD01 gives you the authorization to maintain all views of the customer
master data. Hence, its a master transaction code, which only a few individuals in
the organization should have permission to use.
VD01 VD01 confines the user to maintaining the sales area data and general
information, preventing access to the company code data.
FD01 FD01 is the converse of VD01. It permits the user to maintain the general
information and company code data, preventing access to sales data.
In this chapter, you will work with XD01 only.
T-Code for Create Customer master FD01 / XD01 / VD01
FD01- Company code level & data will be stored in tables KNA1 and KNB1.
XD01- Include sales area & data will be stored in tables KNA1, KNB1 and KNVV (With
company code data).
VD01 Include sales area & data will be stored in tables KNA1, KNB1 and KNVV (w/o
Company code data).

Page 3 of 40

We will use here XD01 for Customer Master Creation.

Page 4 of 40

The customer master data is divided into three areas:


1)The General Data section has common information such ff as the Address
tab,
which contains name and contact information details, control data (such as
industry, transportation zone, and tax information), payment transaction
(bank details and payment card details), marketing (Nielsen ID and other
classification), and other tabs based on relevance to the business.
2)The Sales Area Data section has tabs called Sales (containing information
on sales groups, pricing classifications, and so on), Shipping (which controls
items such as delivery priority, shipping conditions, and so on), Billing (for
tax classifications, Incoterms, and so on), and Partner Functions.
3)The Company Code Data section has tabs called Account Management
(reconciliation
account details) Payment Transactions, Correspondence, and
Insurance. From the General Data and Sales Area Data sections, you can also
branch out to Extras Additional Data to reach other fields.

Page 5 of 40

Page 6 of 40

One-Time Customers
Some customers require your service once in a lifetime. Therefore, it is not required
to set up these types of customers. In such cases, you can set up a one-time customer
master record. In this type of customer master, you do not capture any data
specific to a single customer. This makes the customer master record reusable.
Specifically, the same customer number has different names and address information
in different sales documents, and whenever you use a one-time customer number
in a sales order, the system prompts you to enter the actual name and address of
the customer placing this specific order (Figure 3.3). Since this data is stored only in
the current sales document, you can reuse the customer number. One of the common

Page 7 of 40

business processes where a one-time customer is used is in a regular cash sale.


Because the customer pays immediately for the product or service, there is no need
to track and maintain a record for future use.
This transaction is used to block a customer from
transacting business with your organization. As seen in Figure 3.4, you have options
to block sales orders, delivery, and billing documents in some or all the sales areas.
Block A Customer (VD05)

You can flag a customer master record for deletion


using this transaction. Again, you have the option to delete the data specific
to a
sales area or across the organization. The system also gives you an option to
retain
the general data of the customer and delete business-relevant data such as
Sales
Area. This way, you can retain the basic customer record for future reference.
Flag For Deletion (VD06)

Page 8 of 40

Defining Account Groups

SAP comes with a set of standard account groups that should meet most
business
requirements. However, if you want to segregate different groups of
customers
with different number ranges or screen layouts, you can create additional
account
groups. For each account group, you can control the setup of various
screens, fields,
and attributes. If you need to set up a custom account group, use the
following
path: IMG Financial Accounting Account Receivable and Account Payable

Customer Accounts Master Data Preparation For Creating Customer Master


Data Define Account Groups With Screen Layouts.

Defining Account Groups and Field Selection for


Customers (OVT0)

For each account group, you can customize the screens, mark fields as
mandatory
or optional, and even hide them. The purpose of this step is to keep only
those fields
that are relevant to your business.

Page 9 of 40

To do this, start by specifying the account group that you want to customize,
and
then click the Details icon. In Figure 3.7, we have selected the account group
0001
(Sold-To Party).
The Details screen will show you the attributes of the account group, such as
the
number range and partner determination procedure. To customize the field
selection,
first choose from General Data, Company Code Data, or Sales Data.
Doubleclick
any of these to go to the Maintain Field Status Group: Overview screen

Defining Industries
An industry is a group of customers with the same basic business activity.
You can
specify industries of your customers, such as trade, banking, service,
manufacturing,
healthcare, public service, media, and so on. The Industry appears in the
general data of the customer master record (as seen in Figure 3.12) and can
be an

Page 10 of 40

effective grouping term.

Defining Attributes
SAP provides 10 freely definable attribute fields. You can use these fields to
capture
various attributes or preferences of your customer. They are two-character
fields. To
add values applicable to your organization, click the attribute in the list, and
enter
new values.

Page 11 of 40

Customizing Fields in the Sales Area Data


We have now covered the settings in the Logistics General menu for
customer
master data. Next, the action moves to the Sales and Distribution node in
IMG
so you can configure fields in the Sales Area data. The path is IMG Sales
And
Distribution Master Data Business Partners Customers. The following
are
some of the key settings from the list of nodes appearing here

Marketing An enterprises sales and marketing team often classifies customers


into various groups. External classifications such as the Nielsen ID for the customer
can be defined here. These fields will appear in the Marketing view in the customer

Page 12 of 40

master.
Sales In this section, you can define sales districts that cater to various geographical
areas. You can also create different customer groups. This helps users track
regional sales and derive reports.
Shipping Among other functions, this tab lets you define delivery priorities.
The value you input here will define the urgency of the order. Regular or important
customers can be assigned a higher priority by default. This field gets copied into
sales orders, where it can be changed manually, if needed. Delivery priority plays a
critical role in getting stock committed to sales orders. You will study it in detail in
Chapter 6, Availability Check, Transfer of Requirements, and Backorders.
Billing Document In this section, you can define Payment terms and Incoterms,
as required. These are usually set up in consultation with the FI team.
We will use here XD01 for Customer Master Creation.
Step 1 Enter T-Code XD01 in Command field.

Step 2 Enter the detail in Address Tab screen as below1.

Enter the title and name of customer.

2.

Enter search term, for searching customer.

3.

Enter Street / House Number.

4.

Enter District / Postal code / City / Country / Region.

Page 13 of 40

Step 3 Enter Data in Control Data Tab Screen Field


1.

Enter Tax Number

Step -4 Enter Data on Payment Transactions tab.


1.

Click on the Payment Transaction tab.

2.

Enter Bank City / Bank Key / Bank Account / Account Holder Name.

Page 14 of 40
3.

To enter more detail about bank, click on Bank Data Button.

After Click on Bank data Button ,below screen appear1.

Enter bank name / region

2.

Enter City

3.

Enter Swift Code

Click on Tick Button.


Step-5 Enter sales area data1.

Click on sales area button on application tool bar.

Page 15 of 40
2.

Enter Customer pricing procedure / Shipping data / Partner functions.

Step 6 Save the record.


Click on Save Button.

Customer Will be created with Customer number.

Material Master
The material master contains all the information about the product or service being
sold. This information is shared across the organization and maintained by different
departments. Hence, it is structured in views according to the various functions
such as Purchasing view, MRP view, Accounting view, and Sales view. SD-related
data is structured in three viewsSales: Sales Org 1, Sales: Sales Org 2, and Sales:
General/Plant. These three views will be the focus of the following discussion.

Page 16 of 40

Common Terms in Material Master Data


In your organization, you manage different types of materials such as raw
materials,
semifinished goods, and finished goods. Materials with a similar set of
attributes
are grouped under the same material type. The material type, therefore, is
the key
to controlling screen sequence, data fields, and data. SAP has a set of
predefined
material types that meet most business requirements. Check whether the
following
terms match the materials and products you manage in your organization:
FERT: Finished products
HALB: Semifinished products
ROH: Raw materials
DIEN: Services
KMAT: Configurable materials
HAWA: Trading goods
From the sales and distribution angle, we will be most concerned with
products and
services sold to the customer. Hence, FERT, DIEN, and HAWA will be of
greater
interest to us than other material types.
Creating Material Master Data
You can create a material master record using transaction code MM01. The path
is SAP Menu Logistics Sales and Distribution Master Data Products
Material Other Material Create.
The Select View(s) button allows you to choose which data screens you want to create.
You can always create a material for a certain view first (such as Basic Data) and
later extend it for other views. This is the typical scenario in most organizations,
where different departments maintain their own piece of information and then
hand it over to the next group. Based on your selection, you will then have to specify
the organizational levels (plants, sales organizations, and so on) for which the data
will be created.
The following are some views that you will come across in the material master. We
will only discuss the major ones here.

Page 17 of 40

Basic Data
This view contains product data common to the entire organization. Hence, you do
not have to specify any specific organizational level to create this view. The material
description, units of measure, and attributes such as weight, volume, and status
appear in this view.
There are three sales views in the material master: Sales Org. 1, Sales Org. 2, and
General/Plant Data.

Page 18 of 40

Sales: Sales Org 1 View


This data is specific to a sales organization and distribution channel. The
following
are some of the key fields:
Units Of Measure Here you specify one or more units of measure used for
stocking,
selling, delivering, or procuring the material. You can maintain three different
units of measure for a material:
Base Unit Of Measure This represents the unit of measure in which the
stocks
of the material are maintained. This is the base unit of measure. All other
units
will be converted to the base.

Page 19 of 40

Alternative Unit Of Measure If you have more than one unit of measure,
you
maintain the alternatives and their conversion to the base unit in the
Additional
Data section of the material master. For example, some music CDs are
stored as
individual pieces (EA) but could also be sold or procured in packs of 10 (PAC).
In
this example, EA is the base unit of measure; PAC is the alternative unit of
measure.
The conversion is 10 EA = 1 PAC.
Sales Unit Of Measure The unit of measure in which the material is sold is
the
sales unit. If you need to specify a different unit for sales, enter it here.
Quantity Stipulations You can specify any stipulations regarding material
quantity in sales.
Minimum Order Quantity This refers to the lowest quantity that a
customer
must order for this material. The marketing or pricing strategy of your
organization
may set a limit on the order quantity.
Minimum Delivery Quantity This refers to the minimum quantity that
must
be delivered to the customer. This is often governed by transportation and
logistical
constraints.
Delivery Unit This is the unit in which the material is delivered. If you
specify
the Delivery Unit setting as five pieces, then you can deliver in multiples of
five
only (5, 10, 15, and so on).
Sales Status To signify the status of the material in the sales life cycle, you
use
the Sales Status setting. Certain products may be new and not yet released
in the
market. Others may have reached the end of their life cycle, become
obsolete, or be
discontinued. You can update the status in the material master in order to
control
or stop the sales of such items. In the material master, you can set the Sales
Status
setting specific to a distribution chain (using the field DChain - Spec. Status)
or
across the entire organization (using the field X-Distr. Chain Status). These
fields are

Page 20 of 40

used in conjunction with the validity date to specify when the status will take
effect.
Tax Data This allows you to specify the tax classification for the material in
each
country. (We will cover the details and impact of this in Chapter 5, Pricing
and
Tax Determination.)
Delivering Plant This is where you specify the default plant chosen to
deliver this
material.

Sales: Sales Org 2 View


This view primarily contains various grouping terms:
General Item Category Group This is a critical field that determines the

Page 21 of 40

item category. It controls the behavior and flow of the material across the
sales
documents.
Material Pricing Group This field is used in pricing a product. It is used to
group
together materials that have the same price or pricing condition.
Material Group There are five grouping terms provided to classify and
group the
material in various categories.
Product Attributes You can capture the specific attributes of the product and
control the sales transaction such that the order can be processed only if the attributes
are acceptable to the customer.

Sales: General/Plant Data View


This view contains some general data and some fields that are plant specific.
Plant Specific Information This includes fields such as availability checking
group and loading group.

Page 22 of 40

Availability Checking Group The availability group controls how stocks are
checked and committed to sales orders. Hence, it is a critical field. It plays a key
role and will be covered in detail in Chapter 6, Availability Check, Transfer of
Requirements, and Backorders.
Loading Group This field plays a role in logistics by determining the shipping
point. It will be covered in detail in Chapter 8, Shipping and Transportation.
General Information Other general data fields include packaging material information,
transportation groups, and weight.

Sales Text View


On the Sales Text tab, you can maintain a description or notes about the material
in different languages. Through controls in text determination, the text is copied to
sales documents.

Page 23 of 40

Material Requirement Planning Views


Data in these views are specific to a plant and storage location. This data contains
MRP-related information such as the MRP type, controller, and plant-specific material
status. Information relevant to material requirements planning (MRP) is spread
over four views in the material master. They are named MRP1 to MRP4. Settings
here affect material availability check and inventory control.
Purchasing View
The data in this view is provided by the purchasing department. It includes information
such as purchasing groups, handling and procurement of the material, tolerances,
and order units
Accounting and Costing View
This view contains data about valuation class, standard price, past price and costing
data, and so on.
Other views
Other views that are beyond the scope of this chapter include the following:
1)Warehouse Management
2) Storage
3)Work Scheduling
4)Quality Management
Maintaining Material Master Records
As discussed earlier, you can create the material master using transaction MM01.
The following transactions help you maintain existing material master records:
Change Material Master (MM02) To make changes to any field in the material
master, you proceed with this transaction code. You specify the material number
and select the view(s) that are to be edited. You can then navigate to the required
screen, make the changes, and save the record.
Display Material Master (MM03) This transaction provides display rights to
the user.
Flag For Deletion (MM16) If any material master is to be discontinued, you can
flag it for deletion using this transaction code.
Change Material Type (MMAM) If the material type is to be changed at a later
date, you can do so using this transaction code.

Page 24 of 40

In the Setting For Key Fields node, there is a special submenu critical to sales and
distribution. The path to it is Logistics General Material Master Setting For Key
Fields Data Relevant To Sales and Distribution. Two of the important settings
here are Define Sales Statuses and Define Material Groups.(OMSF)
Maintaining a Product Hierarchy
The Product Hierarchy field appears in the material master view Sales: Sales Org 2.
To maintain the value, use transaction code MM01 (Create Mode) or MM02
(Change Mode).
Based on the structure of your product line, you can create your own product hierarchy.
The standard SAP system offers a three-tiered product hierarchy. Level 1 and
level 2 are five digits each. Level 3 is eight digits long (and is called the 5/5/8 schema).
Thus, the total length of hierarchy adds up to 18 digits.
Customizing a Product Hierarchy
To configure the product hierarchy, the path is as follows: IMG Logistics
General Material Master Settings For Key Fields Data Relevant For
Sales and Distribution Define Product Hierarchies Maintenance: Product
Hierarchy (V/76).
If the SAP standard schema (5/5/8) meets the requirements of your organization,

Page 25 of 40

you can maintain the hierarchy levels in this transaction. You can add new entries
to set up the various levels in your product hierarchy. When you enter a hierarchy
code, the level number is determined automatically by the system based on the
number of characters you have entered. For example, if you enter a five-character
entry, the system determines the level number as 1. Similarly, a 10-character entry
would be level 2. Level 3 would have 18-character records.
Let us discuss this further with the example of Galaxy Musical Instruments, which
has adopted the standard 5/5/8 schema shown in Figure 3.27 for its musical instrument
inventory.
1) How to Create Material Stock
Their are more then one Tcode for create Material Stock .
1.

MB1C ( Other Goods Receipts) for opening balance creation of material.

2.

MIGO (used for Issue / Transfer / Receipt of material).

We use here MB1C Tcode to Create Material Stock as opening balance.

Step-1.
1.

Enter Tcode MB1C in command field.

2.

Enter Movement Type 561 , Plant & Storage location.

click Enter Button.

Page 26 of 40

Step-2
After enter on above screen ,item screen as below appear

Enter Material code for which we need to create stock.

Enter Quantity of material for stock creation.

Page 27 of 40

Step-3

click on save

button .

A message Document 5000021944 posted displayed.

You can used Bapi for create stock.

MOVE: sy-datum TO it_head-pstng_date, "F.contab. doc.


sy-datum TO it_head-doc_date, "F.doc. en documento
sy-uname TO it_head-pr_uname. "Nombre de usuario

CONCATENATE 'Procesado en el Turno #:' turno INTO


it_head-header_txt SEPARATED BY space. "Tex.cabec. documento

MOVE: '05'

TO it_code-gm_code,

"Asig.cd.trans.mov.mca

Page 28 of 40

matnr

TO it_item-material, "Material

werks

TO it_item-plant,

"Centro

lgort

TO it_item-stge_loc, "Almacen

cant

TO it_item-entry_qnt, "Cant.Uni.med.entr

'521'

TO it_item-move_type, "Cl.mov.(gest.stocks)

''

TO it_item-stck_type. "Tipo stock

APPEND it_item.
CLEAR it_item.

Bapi que realiza la salida o entrada al almacen


CALL FUNCTION 'BAPI_GOODSMVT_CREATE'
EXPORTING
goodsmvt_header = it_head
goodsmvt_code

= it_code

IMPORTING
goodsmvt_headret = it_headr
materialdocument = mat_doc
matdocumentyear = doc_year
TABLES
goodsmvt_item
return

= it_item

= it_bapir.

Movement Type
101 GR goods receipt

102 Reversal of GR

Page 29 of 40
103 GR into blocked stck
105 GR from blocked stck
121 GR subseq. adjustm.
122
124
131
141
161
201
221
231
241
251
261
281
291
301
303
305
309
311
313
315
317
319
321
323
325
331
333
335
340
342
344
350
352
402
404
406
412
414
416
442
452
454
456
458
460
502
504
506
512
522
524
526
532

RE return to vendor
GR rtrn blocked stck
Goods receipt
GR G subseq. adjustm
GR returns
162
GI for cost center 202
GI for project
GI for sales order 232
GI for asset
GI for sales
GI for order
GI for network
GI all acc. assigmts
TF tfr.plnt.to plnt.
TF rem.fm.stor.to pl
TF pl.in stor.in pl.
TF tfr.ps.mat.to mat
TF tfr. within plant
TF rem.fm.str.toSLoc
TF pl.in str.in SLoc
Create struct. mat.
Split structured mat
TF quality to unrest
TF quality in plant
TF blocked in plant
GI to sampling QI 332
GI to sampling unre.
GI to sampl. blocked
TF bch revaluation 341
TF unr. to rstricted
TR blocked to unre.
TR blocked to qual.
TR to stck in trans.
TP own to sales ord.
TP own to consgt. 405
TP own to project 411
Reversal own to own
Rev. SLoc to sls ord
Rev. SLoc to proj. 441
TP tiedEmp.to unrstr
RE returns (rev.) 453
TP own to returns 455
TR St.tfr. returns 457
TP Own QIS to ret. 459
TP Own blckt to ret.
RE receipt w/o PO 503
RE receipt to qual.
RE receipt to blockd
RE deliv. w/o charge
RE receipt w/o PrOrd
RE quality w/o PrOrd
RE blocked w/o PrOrd
RE by-product

104 Rev. GR to blocked


106 Rev.GR from blocked

GR
RE
RE

RE
TF

TP
TP
TP
TP
TF
TP
TP
GI

123 RE rtrn vendor rev.


125 GR rtn blkd stck rev
132 Goods receipt
142 GR G subseq. adjustm
rtrns reversal
for cost center
222 RE for project
for sales order
242 RE for asset
252 RE for sales
262 RE for order
282 RE for network
292 RE all acct assigmts
302 TR tfr.plnt.to plnt.
304 TR rem.fm.stor.to pl
306 TR pl.in stor.in pl.
310 TR tfr.ps.mat.to mat
312 TR transfer in plant
314 TR rem.fm.str.toSLoc
316 TR pl.in stor.inSLoc
318 RE create struc. mat
320 RE split struct.mat.
322 TR quality to unrest
324 TR quality in plant
326 TR blocked in plant
to sampling QI
334 RE to sampling unre.
336 RE to sampling blkd
unrestr.to restr.
343 TF blocked to unre.
349 TF blocked to qual.
351 TF to stck in trans.
401 TP own from sls.ord.
403 TP own from consgt.
own from project
own to own
413 TP SLoc to sls order
415 TP SLoc to project
unrstr.to tiedEmp
451 GI returns
returns to own
st.tfr. returns
Ret.to own QIS
Ret.to own blckd
501 GI receipt w/o PO
receipt to qual.
505 GI receipt to blockd
511 GI deliv. w/o charge
521 GI receipt w/o PrOrd
523 GI quality w/o PrOrd
525 GI blkd w/o prod.or.
531 GI by-product
533 GI by-product

Page 30 of 40
534
536
542
544
546
552
554
556
558
562
564
566
572
574
576
582
602
604
606
622
624
632
634
636
642
644
646
648
652
654
656
658
662
672
674
676
678
6A2
6A4
6A6
6A8
6B2
6B4
6B6
6B8
6K6
6W6
702
704
708
712
714
716
718
722
732
802

RE by-product
GR by-prod. sls.ord.
RE subctrStck toWhse
GI receipt sls.or.st
GI issue SC by-prod.
RE scrapping
RE scrapping QI
555
RE scrapping blocked
GI adjust. transit 561
RE entry of st.bals.
RE EntrStBals: QI 565
RE EntrStBals: blckd
RE receipt assembly
RE rcpt QI assembly
RE rcpt blkd assmbly
RE by-prod. network
RE goods deliv. rev.
TR rem.fm.stor.to pl
TR pl.in stor.in pl.
GI ret.pack:ret.del.
GI rcpt:cust.re.pack
GI consgmt:ret.delvy
GI rcpt:cust.consgmt
TR consgmt ret. del.
TR to stck in trans.
TR to cross company
TR cross company
647
TR to stck in trans.
GD ret.del. retn rev
GD returns unr. rev.
GD returns QI rev. 657
GD returns blk. rev.
RE ret. to vdr revrs
TF to stck in trans.
TR to cross company
TF cross company
677
TF to stck in trans.
TR GI1
6A3
TR CC GI1
6A5
TR CC GI1
6A7
TR GI1
6B1
TR GI2
6B3
TR CC GI2
6B5
TR CC GI2
6B7
TR GI2
6K5
TR GI2 consi
TR GI1 consi
GI phys.inv.: whse 703
GI phys.inv: QI
707
GI phys.inv.:blocked
GR InvDiff.:wrhouse
GR InvDiff: QI
GR InvDiff.:returns
GR InvDiff.: blocked
SlsVal.iss.n.afftMgs
SlsVal.iss. afftgMgs
RGR ad. inv. + tax 803

GI
GI
GI

TF

GD

TR
TF
TF
TF
TF
TF
TF
TF
TF
GR
GR

GR

535 GR by-prod. sls.ord.


541 GI whse to subc.stck
543 GI issue sls.ord.st.
545 GI rcpt SC by-prod.
551 GI scrapping
553 GI scrapping QI
scrapping blocked
557 GI adjust. transit
entry of st. bals
563 GI EntrStBals: QI
EntrStBals: blckd
571 GI receipt assembly
573 GI rcpt QI assembly
575 GI rcpt blkd assmbly
581 GI by-prod. network
601 GD goods issue:delvy
603 TF rem.fm.stor.to pl
605 TF pl.in stor.in pl.
621 GI ret.pack.:lending
623 GI iss:cust.ret.pack
631 GI consgmt: lending
633 GI iss: cust.consgmt
635 TF consgmt lending
641 TF to stck in trans.
643 TF to cross company
645 TF cross company
to stck in trans.
651 GD ret.del. returns
653 GD returns unrestr.
655 GD returns QI
returns blocked
661 GI returns to vendor
671 TR to stck in trans.
673 TF to cross company
675 TR cross company
to stck in trans.
6A1 TF GI1
CC GI1
CC GI1
GI1
GI2
CC GI2
CC GI2
GI2
GI2 consi
6W5 TF GI1 consi
701 GR phys.inv.: whse
phys.inv: QI
phys.inv.:blocked
711 GI InvDiff.:whouse
713 GI InvDiff: QI
715 GI InvDiff.:returns
717 GI InvDiff.: blocked
721 SlsVal.rec.n.afftMgs
731 SlsVal.rec. afftgMgs
801 GR adv. inv. + tax
AI ICMS/IPI

Page 31 of 40
804
806
812
816
822
826
834
836
842
844
862
864
922

RGR AI ICMS/IPI
805
RGR bl. AI w. tax 811
RGR TP dely w tax 815
RGR B TP dely w. tax
RGR val. VS w. tax 825
RGR B val. VS w. tax
R reval. iss. w tax
R reval. rec. w tax
RGR RTP
843
RGR RTP w. tax
861
GI TF SD/MM
863
GR TF SD/MM return 901
RE return to vendor

GR bl. AI w. tax
GR TP dely w. tax
GR B TP dely w. tax
821 GR val. VS w. tax
GR B val. VS w. tax
833 Reval. iss. w. tax
835 Reval. rec. w. tax
841 GR RTP
GR RTP w. tax
GR TF SD/MM
GI TF SD/MM return
GI internal c.center

2) How to Create Customer Material Info Record

Sometimes, customer refers to a material with a layman name(rather than technical name) in purchase
order .Hence there is a need to map customer material name with our material code, this process is
called Customer Material Info Record.
T-Code is

VD51 (Create) / VD52 (Change) / VD53 (Display)

Step-1
1.

Enter T-Code VD51 in command bar .

2.

Enter customer code / sales organization / distribution channel.

Press Enter Button,a next screen will appear.

Page 32 of 40
Step-2
1.

Enter material no. and customer material .

2.

Click on Save Button.

A Message Customer-Material info was saved.

3) How to get Overview of Material Stock:

We can get stock overview of a particular material across various organization levels by T-Code
MMBE.

Step-1
1.

Enter T-Code in Command bar MMBE.

2.

Enter Material No .

Page 33 of 40
3.

Select display level for which we want to see stock overview.

4.

Click on

Step-2

execute Button .

Page 34 of 40
Output will be displayed as below1.

Stock overview for material 9554 is displayed.

2.

Stock at Company /Plant / storage location is displayed. By double clicking each level we can see
stock overview at that level.

e.g. If we double click on company level ,then we get detail at company level as below-

Page 35 of 40
Similarly we can get get stock overview at plant / storage location after double-click on plant /
storage level.

4) Create Material Master for Sales View

Purpose: This procedure is used to manually create material master for different view. Here sales
view is used

Step 1
In T-Code MM01 Create Material
1.

Enter industry sector and material type.

2.

Click on Select View(s) Button. A pop window appears. In pop window, select view for which
material to be created and click on check button.

Page 36 of 40

Step 2.
Now a screen appear for all view(w) in Tab screen.
1.

Select Basic Data1 tab.

2.

Enter material description.

3.

Enter Base Unite of Measure.

4.

Enter material group.

5.

Enter division.

Page 37 of 40

Step-3
1.

Select Sales org 1 Tab screen.

2.

Base unit of measure will display.

3.

Enter Sales unit.

4.

A pop window appear for Conv. factors,enter Conv. factors.

5.

Material group is displayed.

Page 38 of 40

Step -4
1.

Select Sales General / Plant tab screen.

2.

Enter Transporter group.

3.

Enter Loading group.

Page 39 of 40

Step-5
click on tab list Icon.

a list of all tab appear ,select costing tab2 from list.


1. Enter valuation class for material by selection view.

Page 40 of 40

Step 6
Click on save button.
A message Material 9554 Created.

You might also like