SAP Principal Tables
SAP Principal Tables
NetweaverTeam
2007. 09. 28
Contents
Material Master Tables
SD-MM Tables
.……….…………………….
................……………………………..
2
3
PS Tables
PP Tables
........................……………………………..
........................……………………………..
6
7
PP Tables
QM Tables
CO T bl
........................……………………………..
......................……………………………..
7
10
11
CO T
a
bl
es
FI Tables
…………..………………………………….
..........................………………………..……
11
15
Dictionary Tables ..........….………………………….. 16
1
Material Master Tables
Material Ledger
MaterialMaterial Material Material
Material Master View
Material Led
g
er
Header
CKMLHD
Material Ledger
Total Values
CKMLCR
Forecast Parameter
MPOP
Plannin
g
Data
MPGD
Material Data
by Warehouse Number
MPGD
Unit of Measure
MARM
T
ax Classification
MLAN
Material Description
General Material Master
MARA
CKMLCR
Material Ledger
Total Quantity
CKMLPP
Material Ledger
Prices
Material Valuation Data
MBEW
Material Data
by Plant
MARC
MAKT
Prices
CKMLPR
MARC
Material Data
by Storage Location
MARD
Material Data
by Storage Type
MilAib
Routing Assignment
to Material
MAPL
BOM Link to Material
MAST
Production Version
of Material
MKAL
Routing Header
BOM Header
Production Version Bill of Material (BOM) Routin
g
Material
Sales Data
MVKE
by
Storage
Type
MLGT
Material Type
T134
Material Grou
p
M
ater
i
a
l
A
ttr
ib
ute
Routing
Header
PLKO
Routing Item
PLPO
BOM
Header
STKO
BOM Item
STPO
Material
Production Hierarchy
T179
p
T023
Material Control Record
MARV
2
물류자재 이동 통제
SD-MM Tables
MMSD
Sales Header Status
VBUK
Sa
l
es
I
te
m
Status
Sales Doc. Flow
VBFA
Purchase Doc. History
EKBE
Sales Order Header
VBAK
Sales Order Item
VBAP
S/O Business Data
VBKD
Sales
Item
Status
VBUP
S/O Schedule Line
Æ Purchase Requisition
EBKN
Purchase Requisition
Æ Purchase Order
EBAN
Purchase Order Header
EKKO
Purchase Order Item
EKPO
S/O Schedule Line
VBEP
Delivery Header
LIKP
Shipping Header
VEKP
S/O Schedule Line
Æ Purchase Order
EKKN
EBKN
EBAN
P/O Schedule Line
EKET
Delivery Item
LIPS
Shippin
g
Item
VEPO
Material Doc. Header
MKPF
GdI (G/I)
EKET
Material Doc. Header
MKPF
Material Doc. Item
MSEG
Billing Header
G
oo
d
s
I
ssue
(G/I)
Material Doc. Item
MSEG
Goods Receipt (G/R)
Invoice Header
출하실적
VBRK
Billing Item
VBRP
Accounting Header
BKPF
Accounting Segment
SG
RBKP
Invoice Item
RSEG
매출실적 매입실적
3
B
S
E
G
SD-MM Tables
SD MM
■ Organization Tables
Category Table Description Text
Master TVKO Sales Organization TVKOT
TVTW Distribution Channel TVTWT
Category Table Description Text
Master T024E Purchasing Organization
T024 Purchasing Group
TSPA Division TSPAT
TVBUR Sales Office TVKBT
TVKGR Sales Group TVGRT
T026 Purchasing Area T026T
WYT1 Vendor Subrange
(Vendor + Vendor Subrange)
T
001W Plant
T
171 Sales Districts
T
171
T
Link TVKOS Sales Organization + Division
TVKOV Sales Organization + Channel
TVTA
Sl O i i Ch l Diii
T001L Storage Location
(Plant + Storage Location)
Link T024W Plant + Purchasing Organization
TVTA
S
a
l
es
O
r
g
an
i
zat
i
on +
Ch
anne
l
+
Di
v
i
s
i
on
TVBVK Sales Office + Sales Group
TVKBZ Sales Organization + Channel + Division
+ Sales Office
T
026Z Purchasin
g
Or
g
anization + Purchasin
g
Group + Purchasing Area
Vendor LFA1 Vendor General Data
LFB1 Vendor + Company
Customer KNA1 Customer General Data
KNB1 Customer + Company
KNVV Customer + Sales Organization +
Distribution Channel + Division
LFM1 Vendor + Purchasing Organization
LFM2 Vendor + Purchasing Organization +
Vendor Subrange + Plant
4
Distribution
Channel
+
Division