hgtvf 发表于 2015-9-18 08:19:22

Sap几个基础表的关系

几个基础表的关系
  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
页: [1]
查看完整版本: Sap几个基础表的关系