几个基础表的关系

几个基础表的关系

Country (ALAND)
MAKT
(Material Descriptions)
Material No (MATNR)
Language (SPRAS)
MARA
(Material Master: General Data)
Material No (MATNR)
MARM
(Units of Measure)
Material No (MATNR)
UOM (MEINH)
Material No (MATNR)
Valuation Area (BWKEY)
Valuation Type (BWTAR)
Accounting Data

MBEW
(Material Valuation)

SAP MM - Purchasing
Purchasing Info Record

KONP
(Conditions (Item))
Condition No (KNUMH)
Seq No (KOPOS)
KONH
(Conditions (Header))
Condition No (KNUMH)
EINA
(Purchasing Info Record: General
Data)
Info Record (INFNR)
EINE
(Purchasing Info Record: Purchasing
Organization Data)
Info Record (INFNR)
Purchasing Org (EKORG)
Info Record Type (ESOKZ)
Plant (WERKS)
A017
(Material Info Record (Plant-Specific))

Application (KAPPL)
Condition Type (KSCHL)
Vendor (LIFNR)
Material No (MATNR)
Purchasing Org (EKORG)
Plant (WERKS)
Info Record Category (ESOKZ)
Validity (DATBI)

SAP - Project Planning

Project Planning

PROJ
(Project Definition)
PRPS
(WBS Elements)
PRPS-PSPHI = PROJ-PSPNR
PRTE
(Schedule Data for
Proj. Item)
PRPS-PSPNR = PRTE-POSNR
and
PRPS-PSPHI= PRTE-PSPHI
PRTX
(Texts(WBS))
PRTX-PRPSPNR = PRTE-POSNR
PRHIS
(Proj. Hierarchy for
WBS Element)
PRPS-PSPNR = PRHIS-POSNR
and
PRPS-PSPHI= PRHIS-PSPHI
PSTX
(Project Texts
(Header))
PSTT
(Project Texts)
PRTX-PRTXTKY = PSTX-PRTXTKY
PSTX-PRTXTKY = PSTT-PRTXTKY
PP

Table Mapping

SAP PP - Project Planning
PROJECTS
Project and WBS element numbers have a domain with a conversion
function module which converts it from 8 numc input to 24 char on output.

PROJ
(Project definition)

Project Number (PSPNR)
Project Name (PSPID)
PRPS
(WBS (Work Breakdown Structure)
Element Master Data))
Project Number (PSPHI)
WBS Element Number (PSPNR)
WBS Name (POSID)
Project Number (PSPHI)
WBS Element Number (POSNR)
PRTE
(Scheduling Data for Project Item)

PRTX
(PS Texts (WBS))

WBS Element Number (PRPSPNR)
Text Identifier (PRTXTKY)
PSTX
(PS Texts (Header))

Text Identifier (PRTXTKY)
PS text description (PSTXTTI)
PRHIS
(Standard WBS, Edges (Hierarchy
pointers))

Project Number (PSPHI)
WBS Element Number (POSNR)
PSTT
(PS texts (description))

Text Identifier (PRTXTKY)
PS text: Description(PTKTEXT)

SAP - Sales and Distribution

Sales and Distribution
Finacial Accounting
Billing
Accounts Receivable
Sales
Material Master
Shipping
Materials Mgmt.
Tables:
KONV
LIKP
LIPS
VBAK
VBAP
VBBE
VBEH
VBEP
VBFA
VBLB
VBLK
VBPA
VBRK
VBRP
VBUK
VBUP
VEKP
VEPO
VEPVG

VBAK
(Sales
Doc:Header)
VBEP
(Sales
Doc:Schedule
Lines)
VBAP
(Sales Doc:Item
Info)
VBAK-VBELN = VBAP-VBELN
VBEP-VBELN = VBAP-VBELN
and
VBAP-POSNR = VBEP-POSNR
VBEP-VBELN = VBAK-VBELN
LIKP
(Sales
Doc:Delivery
Header)
LIPS
(Sales
Doc:Delivery
Items)
LIPS-VBELN = LIKP-VBELN
LIPS-VGBEL = VBAP-VBELN
and
LIPS-VGPOS = VBAP-POSNR
VBPA-VBELN = LIPS-VGBEL
VBPA
(Partner Table)
VBPA-VBELN= VBAK-VBELN
VBPA-POSNR= VBAP-POSNR
VBFA
(Doc. Flow)
VBUP
(Item Status))
VBUK
(Header Status)
vbelv = preceeding document
vbeln = subsequent doc
vbeln = document number
vbeln = document number
;use with VBAP and LIPs