SAP各模块表关系

2007. 09. 28

Netweaver Team

Contents

Material Master Tables SD-MM Tables .……….…………………….

................……………………………..2 3

PS Tables (6)

PP Tables QM Tables CO T bl ........................…………………………….. ......................……………………………..

7

10

CO Tables FI Tables

…………..…………………………………. ..........................………………………..……

11

15

Dictionary Tables (16)

Material Master Tables

Material Ledger Material

Material Material Material

Material Master View

Material Ledger

Header CKMLHD Material Ledger Total Values Forecast Parameter

MPOP

Planning Data

MPGD Material Data

by Warehouse Number

MPGD Unit of Measure

MARM

Tax Classification

MLAN

Material Description

General Material Master

MARA CKMLCR

Material Ledger Total Quantity CKMLPP Material Ledger

Material Valuation Data

MBEW

Material Data by Plant MAKT

Prices CKMLPR

MARC Material Data by Storage Location

MARD Material Data by Storage Type M i l A ib 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)Routing Material Sales Data MVKE

by Storage Type

MLGT Material Type

T134Material Group Material Attribute Routing Header PLKO Routing Item

PLPO

BOM Header STKO BOM Item STPO

Material

Production Hierarchy

T179

p

T023Material Control Record

MARV 물류자재이동통제

MM

SD Sales Header Status

VBUK Sales Item Status

Sales Doc. Flow

VBFA

Purchase Doc. History

EKBE

Sales Order Header

VBAK Sales Order Item

VBAP

S/O Business Data

VBKD VBUP S/O Schedule Line ÆPurchase Requisition

Purchase Requisition ÆPurchase Order

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

Delivery Item

LIPS

Shipping Item

VEPO

Material Doc. Header

MKPF

G d I (G/I)EKET

Material Doc. Header

MKPF Material Doc. Item

MSEG

Billing Header

Goods Issue (G/I)Material Doc. Item

MSEG

Goods Receipt (G/R)

Invoice Header

출하실적

VBRK

Billing Item VBRP

Accounting Header

BKPF Accounting Segment

S G

RBKP Invoice Item

RSEG

매출실적

매입실적

BSEG

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

T024Purchasing Group

TSPA Division TSPAT TVBUR Sales Office TVKBT TVKGR Sales Group TVGRT

T026Purchasing Area T026T WYT1Vendor Subrange

(Vendor + Vendor Subrange)

T001W Plant

T171Sales Districts T171T Link TVKOS Sales Organization + Division

TVKOV Sales Organization + Channel

S l O i i Ch l Di i i

T001L Storage Location

(Plant + Storage Location) Link T024W Plant + Purchasing Organization

TVTA Sales Organization + Channel + Division TVBVK Sales Office + Sales Group

TVKBZ Sales Organization + Channel + Division + Sales Office

T026Z Purchasing Organization + Purchasing

Group + Purchasing Area

Vendor LFA1Vendor General Data

LFB1Vendor + Company

Customer KNA1Customer General Data

KNB1Customer + Company

KNVV Customer + Sales Organization +

Distribution Channel+Division LFM1Vendor + Purchasing Organization LFM2Vendor + Purchasing Organization + Vendor Subrange + Plant

Distribution Channel + Division

■MM Purchasing Info Record

SAP Script Text File

Long Text Information

Material Info Record

Condition Header

KONH Condition Item

KONP

Header STXH SAP Script Text File

Lines STXL

Material Info Record Header EINA Material Info Record

Item EINE

Material Info Record

by Plant A017

Purchasing Info Record +Material + Vendor

Purchasing Doc.

Header Purchasing Order

Sales Order 재고Table(판매,고객,공급처,창고재고)

EKKO Purchasing Doc.

Item EKPO

S/O Schedule Line ÆPurchase Order

EKKN

Sales Order

Stock MSKA(MSKAH)Special Stocks with Customer MSKU(MSKUH)P/O Schedule Line

EKET

Logistics Summary Tables

S?

Special Stocks with Vendor MSLB(MSLBH)

Storage Location Data

for Material MARD(MARDH)

Project Definition

Work Center Header

CRHD Work Center CO Obj. Cost Total Summary of

Actual & Plan Data Object Number (OBJNR)Project Definition PROJ

Work Center Text

CRTX Assignment Work Center

to Cost Center

External Posting

COSP CO Obj. Cost Total Internal Posting

COSS

(O )

WBS Element Master

PRPS

Scheduling Data to Cost Center CRCO

Project Hierarchy Scheduling Data for Project Item

PRTE

PS Texts (WBS)

PRTX

PS Texts (Header)

Production Order

Header AFKO

Network

j y for WBS Element

PRHI PSTX

PS Texts (Description)

PSTT

Project Hierarchy for WBS Element

PRHIS

Operation within Order

AFVC

Operation

Activity Value in Operation AFVV

Network –Relationships

AFAB Network 내작업순서선후관계

Routing Assignment

to Material BOM Link to Material

MAST

Production Version

of Material Production Version Bill of Material (BOM)Routing Work Center Header

CRHD Work Center MAPL MKAL

Routing Header

PLKO Routing Item

BOM Header

STKO

BOM Item Work Center Text

CRTX Assignment Work Center

to Cost Center Routing Selection of BOM

Item Selection Production Order Master Data CAUFV View

Planned Order

PLAF PLPO

STPO

to Cost Center

CRCO

Operation/Activates

PLAS

Order Operation Data for Work Center

Item Selection

STAS

AUFK Production Order

Header AFKO P d ti O d

P d ti O d 생산실적생산계획

S022

Goods Movements Errors from Confirmations

AFFW

Confirmation

Production Order Item AFPO

Production Order Confirmation

AFRU

Material Doc.Header MKPF M t i l D

Subsequently posted 생산품입고(G/R)

BOM 에의한투입원자재예약

Reservation

Item Reservation Header RKPF Material Doc.Item MSEG

Subseque t y posted Goods Movements for Confirmations

AFWI Goods Movement for Production Order

RESB

원자재투입(G/I)

AUFM

■Confirmation

Operation within Order

ÆOrder 내공정작업

:Order Routing Table of Planned Changes

f C fi ti

AFVC

Activity Value in Operation AFVV

: Order 생성시Routing 정보가복사된다.

Production Order Confirmation

AFRU

생산실적

생산품입고(G/R)

Goods Movements Errors from Confirmations

AFFW Incorrect Cost Calculation

from Confirmations Errors

PDC

AFRP0

for Confirmation Automatic Goods Receipt

Subsequently posted Goods Movements for Confirmations

AFWI

from Confirmations

AFRC

AFRP1

Backflushing AFRP2만약Confirmation 도중Error 가발생했거나Backlog 가남아있을경우다음의Program 을실행한다.

Program :CORUPROC Material Doc.Header MKPF Data Transfer to HR

AFRP4

Calc. Actual Costs

AFRP3Program : CORUPROC,

CORUAFFW(T-Code :COGI)

Material Doc.

Item MSEG

Production Versions

of Material

MKAL

Link between Internal MKAL-MATNR = 자재번호

MKAL-WERKS = 플랜트

MKAL-PLNTY

MKAL-PLNNR

MKAL-ALNAL

INOB-OBJEK=MKAL-PLNTY+MKAL-PLNNR+MKAL-ALNAL

Link between Internal Number and Object

INOB INOB OBJEK MKAL PLNTY + MKAL PLNNR + MKAL ALNAL INOB-KLART

INOB-OBTAB

Allocation Table Object to Class KSSK-OBJEK = INOB-OBTAB KSSK-KLART=INOB-KLART

Object to Class

KSSK KSSK KLART INOB KLART KSSK-CLINT

Class Header Data

KLAH Characteristics KLAH-CLINT = KSSK-CLINT KLAH-KLART = INOB-KLART KLAH-CLASS

Characteristics of a Class

KSML

Inspection Lot Record Inspection Catalog

Code Code Texts Quality Message –QALS

Inspection Processing: Usage Decision

Generated Table

For View QMFEL

Characteristic Specifications

for Inspection Processing

QPCD

Quality Notification Items

QMFE

QPCT Maintenance Data Excerpt

QMIH

Æ설비고장시간

Inspection Method

QAVE QMFEL

QAMV

Characteristic Results in Sample Specifications Insp. Specifications/

Quality Notification

QMEL

Inspection

Characteristic Master

QPMK

p

Master Record

QMTB

Inspection

Method Texts

QMTT

Inspection Processing

QAMR

p p

for Inspection Processing

QASV

p p

Valuation

QAMVRMS

Inspection Characteristic

I M th d/

Results Table

for the Sample Unit

QASE

Confirmation Data for Multiple Spec. Sample

QASRMS

p

Master Texts

QPMT

Link Inspection Lot Insp. Methods/

Insp. Characteristic

QPMZ

Logistics Summary Tables

S?

Link Inspection Lot

and Material Document

QAMB

Material Doc. Item

MSEG

Material Doc. Header

MKPF

EC-PCA: Actual Line Items CO-PCA Table

■Basic Table

Cost Center Master

CSKS Profit Center Master

CEPC

Cost Element Master

CSKA

Master Data

Object Number Index EC-PCA: Totals Table

GLPCT

Line Items GLPCA EC-PCA: Object Table

for Account

Assignment Elements

Object Number Index for Cost Center

ONRKS

GLPCO EC-PCA: Transaction

Attributes GLPCP

Object Number(OBJNR):‘KS’+

CO Object CO Obj. Cost Total Summary of Actual & Plan Data

Actual Line Item

CE1CO Object Document CO-PA Table

Object Number(OBJNR) : KS + Controlling Area(KOKRS) + Cost Center(KOSTL)

Document Line

COEP

CO Object

Document Header

External Posting

COSP CO Obj. Cost Total Internal Posting

COSS

Line (by Fiscal Year)

COEJ

Plan Line Item CE2Summary Record Profitability Segment COBK

Profitability Segment

CE3Profitability Segment

Definition CE4ll d

Æ :Controlling Area Code

■Material Ledger

Material Ledger Document 기준

Cost Estimate 기준

Header Record CKMLHD

Period Totals d l Cost Component Split

d Product Costing d Document Header

MLHD

Document C i d l

Document Posting i d d Q i i

Document Items

Material 과Cost Estimate 의Link 정보

Records Values CKMLCR Period Totals Records Quantity

CKMLPP

Header CKMLKEKO Cost Component Split

Elements CKMLKEPH

Header Data KEKO Product Costing Cost Components

KEPH

Currencies and Values MLCR Periods and Quantities MLPP

Document Items MLIT

Document 와Material, Cost Estimate,

Production Process 의Link 정보를담고있다.

Prices CKMLPR

Material Valuation Data

Cost Component Split Material Costing View Cost Component Split Cost Component Groups

Cost Components PP 의원가취합처나생산작업지시와연결된다.

MBEW Cost Component Split Header for Prices CKMLPRKEKO Cost Component Split Elements for Prices CKMLPRKEPH

Material Valuation Data

History MBEWH

Cost Component Split (Control Record)CKMLKEV TCKH7Cost Component Groups

-Texts TCKH6Cost Components

만약CKMLHD 와CKMLPRKEKO 를대사하여

CKMLPRKEKO 에존재하지않는Cost Estimate 가있거나

Price Update(T-Code:CK24)에서오류발생시별도생성작업을한다.Program : MLCCS_STARTUP

MLCCS_RESET Execute

Cost Components

-Texts TCKH1

Cost Components TCKH3

■Product Costs

ÆProduct Cost by Period(기간별제품원가)에서사용하는Product Cost Collector(제품원가취합처)에취합된Cost Data

Order Master Data

AUFK Generated View for CO

COAS

CO Object 기준

ÆWRTTP (Val e T pe)

Object Number(OBJNR) : ‘OR’ +

Order Number (AUFNR:원가취합처or 생산작업지시)

Order Header Data

AFKO

Total Variances/Results Analyses

COSB Order Item Cost Totals for External Postings

Generated View for PP

CAUFV

WRTTP (Value Type) -‘04’ : 사전원가(Preliminary Cost)-‘05’ : 실적

AFPO

COSP Cost Totals for Internal Postings

COSS Activity Type Totals

ÆAUFNR : 원가취합처번호(Order Type:RM01)

COSL ÆOBJNR : 오브젝트번호

※Product Cost by Order(오더별제품원가)에서는Production Order 단위로Cost Data 가취합된다.

※기간별제품원가에서사전원가(Preliminary Cost)는표준원가(Standard Cost)와달리원가취합처별(생산버전: BOM + Routing)로계산하여사용한다.

■Activity Types

Activity Master CSLA, CSLT

Cost Center Master

CSKS

Cost Center /

Activity Type

CSSL

Control Data for

Activity Type

COKL

Object Number(OBJNR) : ‘KL’ +

Controlling Area(KOKRS) +

Cost Center(KOSTL) +

Activity Type(LSTAR)

Activity Type Totals Line Item for Activity

Types(by Fiscal Year)Line Item for Activity Types(by Period)

COSL Types(by Fiscal Year)

COEJL Types(by Period)

COEPL

FI Tables

General Ledger Total

Vendor

G/L Account

Customer

New G/L

Client Level Vendor General Data

G/L Account Master

Customer General Data

General Ledger Total FAGLFLEXT G/L Actual Line Item

FAGLFLEXA

Client Level Master Data Vendor General Data LFA1G/L Account Master SKA1Customer General Data KNA1Company Level Master Data Vendor Master (Company Code)

LFB1G/L Account (Company Code)

SKB1Customer Master (Company Code)

KNB1Monthly Summary Data

Vendor

Transaction Data

LFC1Customer Transaction Data

KNC1Accounting for Vendor General Ledger Total

FAGLFLEXT Accounting for G/L Account

Accounting for Customer

ÅOpen Item

ÅFI Summary

Documents for Material Secondary Index

BSIK BSIS BSID Accounting for Vendor BSAK

Accounting for G/L Account

BSAS

Accounting for Customer

BSAD

ÅCleared Item

BSIM

Accounting Document

Header BKPF

Accounting Document Header for Parking

VBKPF

Parking Document

for Asset Parking Document for Customer Parking Document

for Vendor Parking Document for G/L Account Accounting Document

Posting Document

Parked Document

Clustered by RFBLG

for Asset VBSEGA

for Customer VBSEGD

for Vendor VBSEGK

for G/L Account

VBSEGS

Segment BSEG

Tax Data BSET

One-time Accounting Data

BSEC

Bill of Exchanging

BSED

Control Data

(Obsolete)

BSES

Dictionary Tables

Table Description Text DD01L Domains

DD01T DD02L

SAP Tables

DD02T

-TRANSP : Transparent table -INTTAB : Structure -CLUSTER : Cluster table DD03L Table Fields DD03T -POOL

: Pooled table

-VIEW : General view structure -APPEND

: Append structure

DD04L Data Elements DD04T DD07L Domain Fixed Value

DD07T DD08L Dictionary Relationship Definition (Check Table, Foreign Key)DD08T Table Secondary Indexes DD12L Table Secondary Indexes DD12T

DD17S Secondary Index Fields DD20L Match Code Objects DD20T DD30L Search Help

DD30T

DD33S Assigned Fields to Search Help ARCH_OCLAS Assign classes to Archive Object ARCH_CLASS Classes of Integrated Objects ARCH DEF Definition of Archive Object ARCH_DEF Definition of Archive Object TFDIR Function Modules TFTIT FUPARAREF Function Parameters TRMAC ABAP Program Macro TFACS

Factory Calendar