Sap几个基础表的关系

hgtvf

几个基础表的关系

　　VBAK 销售订单抬头
VBAP 销售订单行项目
KNA1 客户主文件一般数据
　　vbak和vbap通过vbeln关联
vbak和kna1通过kunnr关联
　　LIPS 交货单明细
VBRP 发票行项目
VBFA 销售凭证流
　　
vbap和vbfa通过 vbfa~vbelv = vbap~vbeln
               vbfa~posnv = vbap~posnr
　　lips和vbfa通过 lips~vbeln = vbfa~vbeln
       lips~posnv = vbfa~posnv
　　vbrp和vbfa通过 vbrp~vbeln = vbfa~vbeln
       vbrp~posnr = vbfa~posnn
　　lips和vbap通过 lips~vgbel = vbap~vbeln
       lips~vgpos = vbap-posnr
　　
　　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