supot197.doc

SAP MM Tables Link and Flow MM fow fow is processing between business organisation organisation and Vendor: 1...Purchase Requisition --- T.code ---ME51 2...Source List -----T.code-----ME41 3...Request for Quation (RQ!---T.code-(RQ!---T.code--ME21" ME21" (To (To #endor! #endor! 4...Purchase 4...Purchas e $rder ---- T.code T.code ----ME21" ----ME 21" (To (To #endor! #endor! 5...%oods Recei&t-------T.code....M'%$ (Ta)es* (Ta)es* M+P, MSE%! ...'noice #eri/cation----T.code...M'R$ (Ta)es* 0+P , 0SE%! ...#endor Paent----T.code...0 (' - ccount Paa)e! MM Table Table Link:

all tables in MM-PUR Purc!asing" :

E0" - Purchase Purchase Requisition E0+" - Purchase Purchase Requisition Requisition ccount ccount ssi6nent E070 - 'nde8 'nde8 for for Stoc9 Trans&ort Requisitions Requisitions for Materi E'" - Purchasin6 Purchasin6 'nfo Record* Record* %enera) :ata E'"E - Purchasin6 Purchasin6 'nfo Record* Record* Purchasin6 $r6ani;ation : E'P - $rder Price osts E+0=< - osts E+E< - Schedu)in6 6reeent Re)ease :ocuentation E+E+ - on/rations E+ET - Schedu)in6 6reeent Schedu)e Lines E+ET< - Schedu)in6 6reeent Schedu)es* ondition 'nde8 E++" - ccount ssi6nent in Purchasin6 :ocuent E++$ - Purchasin6 Purchasin6 :ocuent - >odes for >o&)iance Aith Shi&&in6 Shi&&in6 'nstructions  T2: - >o&)iance Aith Shi&&in6 'nstructions* 'nstructions* Te8ts Te8ts  TB - >erti/cate >ate6ories  TBQ - >ontro) :ata for Source Source :eterination and and >hec9in  TBT - >erti/cate >ate6ories* Te8t :escri&tion  T1 - SP Transaction Transaction >ontro), >ontro), Purchasin6  T10 - SP Transaction Transaction >ontro), List :is&)as, Purchasin Purchasin  T1> - SP Transaction Transaction >ontro) >ontro) for List :is&)as in >LL  T1: - unction unction uthori;ations* Purchase Purchase $rder  T1E - unction unction uthori;ations* Purchasin6* Purchasin6* :escri&tions  T1' - >ontro) of 'ntrastat Re&orts  T1C - Te8t Ta)e Ta)e for 'ntrastat Re&orts Re&orts  T1L - Sco&e of Purchasin6 Purchasin6 Lists  T1M - Messa6e >ontro)* Purchasin6 Purchasin6 (Sste Messa6es!

 T1$ - :escri&tion of Sco&e of List  T1P - Entities Ta)e Ta)e Routines Routines  T1Q - Sco&e of List* 0uerDs "e6otiation Sheet* Routine Routine  T1R - Routines Routines for 0uerDs "e6otiation Sheet  T1S - Se)ection Paraeters Paraeters for Purchasin6 Purchasin6 Lists  T1T - :escri&tion of Se)ection Paraeters Paraeters  T1# - :efau)t #a)ues #a)ues for Purchasin6  T1@ - :escri&tion for :efau)t #a)ues #a)ues for Purchasin6 Purchasin6 $&e  T1 - Sco&e of List* 0uerDs "e6otiation Sheet  T1F - Sco&e of List* 0uerDs "e6otiation Sheet* :escri&  T11 - Purchasin6 :ocuent :ocuent T&es T&es  T11 - Lin9a6e of Requisition Requisition :oc. T&e T&e to Purchasin6 Purchasin6 :o  T110 - :efau)t 0usiness Transaction Transaction T&e T&e for '&ort  T11E - Re)ease >odes >odes  T11 - Re)ease Point Point ssi6nent for Purchase Purchase Requisition  T11% - Re)ease Prerequisite, Prerequisite, Purchase Purchase Requisition Requisition  T11< - ie)ds for Re)ease Procedure, Procedure, Purchase Purchase Requisitio Requisitio  T11' - :eterination of Re)ease Re)ease Strate6  T11M - ine-T ine-Tuned >ontro)* Messa6e T&es T&es  T11" - Messa6e :eterination Scheas* Scheas* ssi6nent  T11P - >hec9 of :ocuent T&e, T&e, :ocuent >ate6or, 'te >  T11R - RE$R% >ontro), Purchasin6 Purchasin6  T11S - Re)ease 'ndicator, 'ndicator, Purchase Requisition Requisition  T11T - Te8ts for Purchasin6 Purchasin6 :ocuent T&es T&es  T117 - Te8ts for Re)ease Re)ease 'ndicator  T11# - Shi&&in6-S&eci/c :ata for Stoc9 Tfr. Tfr. for Purch.  T11@ - $rder T&es T&es for Stoc9 Transfer Transfer  T11= - dditiona) >hec9s for $ut)ine 6reeents 6reeents on Reor6 Reor6  T12 - ie)d Se)ection, Purchasin6 Purchasin6 :ocuent  T12+ - ie)d Se)ection, ccount ssi6nent ie)ds, ie)ds, Purch  T12T - :escri&tion of ie)d ie)d Se)ection Reference Reference +e  T12 - :escri&tion of ie)d ie)d %rou&s fro T12GT12+ T12GT12+  T12F - %rou&s* ie)d ie)d Se)ection  T13 - 'te >ate6ories in Purchasin6 Purchasin6 :ocuent  T13 - >hec9 'te >ate6orGccount >ate6orGccount ssi6nent >ate6or  T130 - Purchase $rder $rder ate6ories  T13> - Te8ts for Purchase Purchase $rder ate6ories  T13: - ssi6nent 'nterna)GE8terna) 'nterna)GE8terna) >on/ration >on/ration >ate6or  T13E - >on/ration >ate6ories >ate6ories  T13 - >on/ration >ate6ories* >ate6ories* :escri&tions  T13% - >on/ration >ontro) >ontro)  T13' - Te8ts for ccount ccount ssi6nent >ate6ories  T13+ - ccount ssi6nent >ate6ories >ate6ories in Purchasin6 :ocu  T13+S - ssi6nent of Ta8 Ta8 'ndicator to ccount ssi6nent  T13L - >on/ration >ontro) >ontro) +es +es  T13M - >on/ration >ontro) >ontro) +es* +es* :escri&tion  T13P - Re)ease >reation >reation Pro/)e  T13S - :escri&tion for Re)ease >reation >reation Pro/)e Pro/)e  T13 - ?=oie? T13

 T13F - Te8ts for 'te >ate6ories  T15+ - >o&in6 $&tions* o&in6 $&tions* 'te te8ts  T1 - Su&&)eent Te8t in Purchasin6 :ocuent Printouts  T1> - Print-Re)eant Purchasin6 :ocuent >han6es  T1+ - han6e Te8ts in Purchasin6 :ocuent Printouts  T17 - ontro), Purchasin6  T1H - unction >odes, Purchasin6  T1HT - Screen Tit)es  T10 - Re)ease 'ndicators* Purchasin6 :ocuent  T1> - Re)ease >odes  T1: - :escri&tion of Re)ease >odes  T1E - :escri&tions of Re)ease 'ndicators* Purchasin6 :o  T1% - Re)ease %rou&s  T1< - :escri&tions of Re)ease %rou&s  T1+ - Re)ease Statuses  T1S - Re)ease Strate6ies

#o$$on Tables used b% SAP MM 0e)oA are feA i&ortant >oon Ta)es used in Materia)s Mana6eent Modu)es* E'" Purchasin6 'nfo Record- %enera) :ata E'"E Purchasin6 'nfo Record- Purchasin6 $r6ani;ation :ata M+T Materia) :escri&tions MR %enera) Materia) :ata MR> P)ant :ata for Materia) MR: Stora6e Location :ata for Materia) MST Materia) to 0$M Lin9 M0E@ Materia) #a)uation M+P onsu&tion M#+E Sa)es :ata for ateria)s R+P :ocuent
E++$ Purchasin6 :ocuent o&an >ode! "R'# "uer ran6e intera)s RES0 ReserationGde&endent requireents  T11T Te8ts for Purchasin6 :ocuent T&es

SAP MM Tips b% : &a!adur o))oAin6 are the )ist of '&ortant MM ta)es. P)ease chec9 if its usefu). 'nentor Mana6eent* I-------------------------J--------J-----------------------------------------I I I Ta)e I :escri&tion I I-------------------------J--------J-----------------------------------------I I Materia) I MSE% I Materia) docuent G transaction detai)s I I :ocuentGMoeents I M+P I Materia) docuent header inforation I-------------------------J--------J-----------------------------------------I I Materia) Stoc9 0a)ances I MR: I Materia) stoc9 I I I M0E@ I Materia) stoc9 Aith a)uation I I-------------------------J--------J-----------------------------------------I I Sa)es $rder Stoc9 I MS+ I Stoc9 a)ance Aith associated sa)es I I I I order data I I-------------------------J--------J-----------------------------------------I I Stoc9 Trans&ort I E+70 I 'nde8 for Stoc9 Trans&ort $rders for I I I M:70 I Materia) I I I I Readin6 #ieA of Stoc9 Trans&ort $rd. forI I I I Re)ease $rd. I I-------------------------J--------J-----------------------------------------I I S&ecia) Stoc9s I M+$L I >onsi6nent, ateria) &roided to I I I I endor, etc. I I-------------------------J--------J-----------------------------------------I Materia) Master :ata* I-------------------------J---------J--------------------------------------I I ITa)e I :escri&tion I I-------------------------J---------J--------------------------------------I I Materia)s I MR I %enera) :ata, ateria) t&e, 6rou&, I I I I con/6ura)e K atch ind. I I I M+T I Short Te8ts, descri&tions I I I MRM I >onersion actors I I I M#+E I Sa)es $r6, distriution channe) I I I ML" I Sa)es data, ta8 indicator, ta8 I I I MR> I c)assi/cation I I I M0E@ I P)ant P)annin6 :ata I I I ML%" I #a)uation :ata I I I ML%T I @arehouse Mana6eent 'nentor :ata I I I M#ER I @arehouse Mana6eent Stora6e T&e I I I MPR I :ata I I I MR: I >onsu&tion :ata I I I M>< I Pointer for orecast :ata I I I M><0 I Stora6e )ocation data Aith stoc9 I I I I a)ances I I I I 0atches I I I I 0atch Stoc9s I I-------------------------J---------J--------------------------------------I

SAP MM Tips b% : '()Ma!eswar

I

Sales and Distribution Tables

KONV Conditions for Transaction Data KONP Conditions for Items LIKP

Delivery Header Data

LIPS

Delivery: Item data

VBAK

Sales Document: Header Data

VBAP

Sales Document: Item Data

VBBE

Sales Requirements: Individual Records

VBEH

Schedule line history

VBEP

Sales Document: Schedule Line Data

VBFA

Sales Document Flow

VBLB

Sales document: Release order data

VBLK

SD Document: Delivery Note Header

VBPA

Sales Document: artner

VBRK

!illin": Header Data

VBRP

!illin": Item Data

VBUK

Sales Document: Header Status and #dministrative Data

VBUP

Sales Document: Item Status

VEKP

Handlin" $nit % Header Ta&le

VEPO

ac'in": Handlin" $nit Item (Contents)

VEPVG Delivery Due Inde*

Materials Management Tables

EINA

urchasin" Info Record% +eneral Data

EINE

urchasin" Info Record% urchasin" ,r"ani-ation Data

MAKT .aterial Descri/tions MARA +eneral .aterial Data MARC lant Data for .aterial MARD Stora"e Location Data for .aterial MAST .aterial to !,. Lin' MBEW .aterial 0aluation MKPF Header% .aterial Document MSEG Document Se"ment% .aterial MVER  .aterial Consum/tion MVKE Sales Data for materials RKPF

Document Header% Reservation

T023

.at1 "rou/s

T024

urchasin" +rou/s

T156

.ovement Ty/e

T157H Hel/ Te*ts for .ovement Ty/es MOFF Lists what views have not &een created Purchasing Tables

A501

lant2.aterial

EBAN urchase Requisition EBKN urchase Requisition #ccount #ssi"nment EKAB Release Documentation EKBE

History /er urchasin" Document

EKET

Schedulin" #"reement Schedule Lines

EKKN #ccount #ssi"nment in urchasin" Document EKKO urchasin" Document Header EKPO urchasin" Document Item IKPF

Header% hysical Inventory Document

ISEG

hysical Inventory Document Items

LFA1

0endor .aster (+eneral section)

LFB1

0endor .aster (Com/any Code)

NRIV Num&er ran"e intervals RESB Reservation2de/endent requirements T161T Te*ts for urchasin" Document Ty/es

Materials Management Tables

EINA

urchasin" Info Record% +eneral Data

EINE

urchasin" Info Record% urchasin" ,r"ani-ation Data

MAKT .aterial Descri/tions MARA +eneral .aterial Data MARC lant Data for .aterial MARD Stora"e Location Data for .aterial MAST .aterial to !,. Lin' MBEW .aterial 0aluation MKPF Header% .aterial Document MSEG Document Se"ment% .aterial MVER  .aterial Consum/tion MVKE Sales Data for materials RKPF

Document Header% Reservation

T023

.at1 "rou/s

T024

urchasin" +rou/s

T156

.ovement Ty/e

T157H Hel/ Te*ts for .ovement Ty/es MOFF Lists what views have not &een created Purchasing Tables

A501

lant2.aterial

EBAN urchase Requisition EBKN urchase Requisition #ccount #ssi"nment EKAB Release Documentation EKBE

History /er urchasin" Document

EKET

Schedulin" #"reement Schedule Lines

EKKN #ccount #ssi"nment in urchasin" Document EKKO urchasin" Document Header EKPO urchasin" Document Item IKPF

Header% hysical Inventory Document

ISEG

hysical Inventory Document Items

LFA1

0endor .aster (+eneral section)

LFB1

0endor .aster (Com/any Code)

NRIV Num&er ran"e intervals RESB Reservation2de/endent requirements T161T Te*ts for urchasin" Document Ty/es

Project Systems Tables

IMAK #//ro/riation requests % "eneral data IMAV #//ro/riation request variant IMPR  Investment ro"ram ositions IMPU Te*ts for ca/1 inv1 /ro"ram /ositions IMTP

Investment /ro"rams

IMZO #ssi"nment Ta&le% C, ,&3ect % Ca/ital Investment ro"1os1 PMCO Cost structure of maintenance order PRHI

4or' !rea'down Structure5 6d"es (Hierarchy ointer)

PROJ

ro3ect definition

PRPS 4!S (4or' !rea'down Structure) 6lement .aster Data

Production Planning

 Than9s to Ton +erste for the PP ta)e info. Than9s to Ton +erste for the PP ta)e info.

MAST .aterial !,. STKO !,. Header STPO !,. ositions (detail) MAPL #ssi"nment fo Tas' Lists to .aterials PLKO Routin" +rou/ Header PLSO Routin" +rou/ Sequence PLPO Routin" +rou/ ,/erations AFKO roduction ,rder Header AFPO roduction ,rder osition (details)

AFA&

"etAor9 - Re)ationshi&s

AFF*

PRT assi6nent data for the Aor9 order

AFFL

@or9 order sequence

AFFT

$rder - Process 'nstructions

AFFV

$rder - Process 'nstruction #a)ues

AFF+

%oods oeents Aith errors fro con/rations

AF,*

Maintenance order header

AF'

$rder header data PP orders

AFP

$rder ite

AFR#

'ncorrect cost ca)cu)ations fro con/rations

AFR.

:efau)t a)ues for co))ectie con/ration

AFR*


AFRU

$rder co&)etion con/rations

AFRV

>on/rations &oo)

AFV#

$&eration Aithin an order

AFVU

:0 structure of the user /e)ds of the o&eration

AFVV

:0 structure of the quantitiesGdatesGa)ues in the o&eration

AF+,

Susequent) &osted 6oods oeents for con/rations

AUF' 

$rder aster data

AUFM

%oods oeents for order

&(M' 

Master @arrant
&(MP

Master @arrant 'te

&(MS

Master @arrant Te8t 'te

&(MT

Master @arrant Te8t

&(M/

@arrant >ounter

#R*.

@or9 >enter
#RT0

 Te8t for the @or9 >enter or Production ResourceGToo)

12'T

Equi&ent Short Te8ts

12ST

Equi&ent to 0$M Lin9

12U,

Equi&ent aster data

12U/

Equi&ent tie se6ent

*,'

$rder aster data histor

,FL

 Ta)e 6enerated for #ieA 'L$

,FLT

unctiona) Location (Ta)e!

,FLT0

unctiona) Location- Short Te8ts

,*(3S

Perit Se6ent for P)ant Maintenance

,*PA

P)ant Maintenance- Partners

,*S(

$ect-Re)ated Perits in P)ant Maintenance

,LA

PM $ect Location and ccount ssi6nent

,MPTT

Measurin6 Point (Ta)e!

,MR(

Measureent :ocuent

'A'

>a&acit
'3P

>onditions ('te!

'3V

>onditions (Transaction :ata!

&4' 

P)ant Maintenance $ect List

2M1L

Qua)it "oti/cation

2MF1

Qua)it noti/cation - ites

2M,*

Qua)it essa6e - aintenance data e8cer&t

2MMA

Qua)it noti/cation - actiities

2MSM

Qua)it noti/cation - tas9s

2MUR

Qua)it noti/cation - causes

T556

>o&an >odes

T556L

Stora6e Locations

T556+

P)antsG0ranches

T577.

>ustoer account 6rou&s

T558

$rder T&es

T89R

Maintenance reisions

T898,;T

Maintenance actiit t&e descri&tion

T89<

Priorities

T897(

Perits

T897(;T  Te8t for Ta)e 35%T T875A

ctiit >ate6or for PM Lists

T,3#T

>ustoers- 'ncoters- Te8ts

TV'

$r6ani;ationa) 7nit- Sa)es $r6ani;ations

TV'S

$r6ani;ationa) 7nit- :iisions &er Sa)es $r6ani;ation

TV'V

$r6. 7nit- :istriution >hanne)s &er Sa)es $r6ani;ation

TVTA

$r6ani;ationa) 7nit- Sa)es rea(s!

V,AUF'S %enerated Ta)e for #ieA #'7+ST T System Tables

ADCP

erson2#ddress assi"nment (central address administration)

ADIRACCESS Ta&le to store 'eys for T#DIR o&3ects ADR2

Tele/hone num&ers (central address admin1)

ADRP

ersons (central address administration)

APD

D#T# D6FINITI,N 7ueue

API

7ueue info definition

D010SINF

#!#% Information a&out #!# /ro"ram source code

E071

Chan"e and Trans/ort System% ,&3ect 6ntries of Requests2Tas's

E07T

Chan"e and Trans/ort System% Short Te*ts for Requests2Tas's

ENLFDIR 

#dditional #ttri&utes for Function .odules

IND!

System ta&le IND8

NAST

.essa"e Status

ST!H

ST8D S#scri/t te*t file header

T005

Countries

T005S

Ta*es% Re"ion (rovince) 9ey

T005U

Ta*es% Re"ion 9ey% Te*ts

T006

$nits of .easurement

T015M

Names of the months

T247

.onth name and short te*t

T777A

!uildin" #ddresses

TADIR 

Directory of Re/ository ,&3ects

TBTCO

o& status overview ta&le

TBTCP

!atch 3o& ste/ overview

TFDIR 

Function .odule

TFTIT

Function .odule Short Te*t

TSP03L

S/ool% Lon" device names

TSTC

S# Transaction Codes

TSTCT

Transaction Code Te*ts

TUT"P

$ser Ty/es in Current rice List in S# System

TUZUS

S/ecial versions

TVARV

Ta&le of varia&les in selection criteria

TVDIR 

0iew Directory

US#30

Data Relevant to .easurement for $ser .aster Record

USR01

$ser master record (runtime data)

USR02

Lo"on data

USR04

$ser master authori-ations

USR06

#dditional Data /er $ser

USR14

Surchar"ea&le Lan"ua"e 0ersions /er $ser

USR21

#ssi"n user name address 'ey

ARCH$OBJ

,&3ects for archivin" and reor"ani-ation

BTCUED

Descri/tion of user event IDs for &ac'"round /rocessin"

BT!SUPB

!SI% $/"rade%Information

CCCFLOW

Client Co/y Control Flow

DBSTATC

D! ,/timi-er Control (Statistics Creation)

DEVACCESS

Ta&le for develo/ment users

DEVL

,!S,L6T6% Do not use (See TC6TR#L)

E070

Chan"e and Trans/ort System% Header of Requests2Tas's

E070L

CTS% Inde* for #ssi"nin" Num&ers to Requests2Tas's

INSTVERS

Documentation for installation Status and History

PAT03

atch Directory

SDBAC

D!# #ction Ta&le

T100

.essa"es

TAPLT

ro"ram #//lication Lon" Te*ts

TAS"S

,!S,L6T6% Do not use5 see TC6D6LI

TDEVC

Develo/ment Classes

TEMSE

Tem/ Sequential ta&le1

TLOCK

Chan"e and Trans/ort System% Loc' Ta&le

TNAPR 

rocessin" /ro"rams for out/ut1 Can &e very handy to find the /rint /ro"ram for a S#Scri/t1

TNAST

rinted out/ut control ta&le

TPFET

Ta&le of /rofile /arameters

TPFHT

rofile header5 administration data for /rofiles in D!

TPROT

Ta&le contains all DD ta&les to &e lo""ed

TRBAT

Communication Ta&le for Trans/ort Control

TRDIRT

Title te*ts for /ro"rams in TRDIR

TRESN

Ta&le of Namin" Conventions in #!# 4or'&ench

TRJOB

o& ID for Coordinatin" !atch%#!#2$NI8 for Trans/orts

TSP03C

S/ool% Device Descri/tion 6*tension

TST03

TemSe data

TS"ST

,!S,L6T6% Do not use (see TC6S;ST)

TWS"S

,!S,L6T6% Do not use (See TC6TR#L)

USOBT

Relation transaction % authori-ation o&3ect

USR03

$ser address data

USR05

$ser .aster arameter ID

USR12

$ser master authori-ation values

USR40

Ta&le for ille"al /asswords

USR41

$ser master% #dditional data

UST04

$ser masters

VARIT

0ariant te*ts

VARID

0ariant directory

D010TAB

Ta&le for $se Re/ort%%%Ta&les

DD02L

S# ta&les

DD02T

R2< DD% S# ta&le te*ts

DD03L

Ta&le Fields

DD03T

DD% Te*ts for fields (lan"ua"e de/endent)

EDIDC

ID,C Control Records

EDIDOT

Short descri/tion of IDoc ty/es

EDID2

ID,C se"ments (version <1=)

EDID4

ID,C se"ments (version >1?)

EDSEA

6DI% Ta&le of all se"ments of current release

VRS!2

Central Ta&le for 0ersion .ana"ement (Re/ort Source)

TSE05

Can add /arameters to the INS6RT C,..#ND (IC)1 Then5 when you insert command5 your info a//ears in the editor1 $seful for comment &loc's5 common section of code5 etc1

CDPOS

Chan"e document items

CDHDR 

Chan"e document header

T52#A

"overns the fore"round sequence of infoty/es the system will use to /rom/t the user durin" online and &atch /rocessin"1 ;ou will have to code your !DC to follow that sequence of creatin" infoty/es1

T5%%Z

"overns the dynamic event /rocessin" that will only ta'e /lace durin" online user in/uts1 For !DC@s you will have to create se/arate !DC@s to handle any infoty/es that are inserted dynamically &y this ta&le1

T5%%M

Infoty/e Screen Control