Sap基本表关系

SAP PP - Project PlanningPROJECTSProject and WBS element numbers have a domain with a conversionfunction module which converts it from 8 numc input to 24 char on output.PROJ(Project definition)Project Number (PSPNR)Project Name (PSPID)PRTE(Scheduling Data for Project Item)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)P(PWTPRHIS(Standard WBS, Edges (Hierarchypointers))SAP - Sales and DistributionSalesFinacial AccountingShippingSales and DistributionMaterials Mgmt.Billing

Tables: KONV LIKP LIPS VBAK VBAP VBBESales/Order DocumentShipping/Delivery DocumentVBBE(SalesRequirements)VBLB(Release OrderData)VBLB-VBELN=VBAK-VBELNVBLK(SD:Delivery NoteHeader)VEPO(SD Doc:ShippingItem content)VEPO-VENUM =VEKP-VENUMVBBE-VBELN=VBAK-VBELNVBPA(Partner Table)VBPA-VBELN=VBAK-VBELNVBPA-POSNR=VBAP-POSNRVEPO-VBELN =VBLK-VBELNVEPO-VBELN =LIKP-VBELNVBAK(SalesDoc:Header)LIKP(SalesDoc:DeliveryHeader)VEKP(SD Doc:ShippingUnit Header)VTTP-VBELN =LIKP-VBELNVBAK-VBELN =VBAP-VBELNVEPVG(Delivery DueIndex)VKDFS(SD Index:Billing Initiator)VAPMA(SD Index:Order Itemsby Material)VBEP-VBELN =VBAK-VBELNVBAP(Sales Doc:ItemInfo)VTTP(Shipment Item)VBPA-VBELN =LIPS-VGBELLIPS-VBELN =LIKP-VBELNVTTK-TKNUM =VTTP-TKNUMVBEP-VBELN =VBAP-VBELNandVBAP-POSNR =VBEP-POSNRVBKD-VBELN =VBAP-VBELNandVBKD-POSNR =VBAP-POSNRLIPS-VGBEL =VBAP-VBELNandLIPS-VGPOS =VBAP-POSNRVTTK(Shipment Header)VLIPS(SalesDoc:DeliveryLIPS-VBELN =VBRP-VGBELLIPS-POSNR=VKDFS(SD Index:Billing Initiator)Billing Cat (FKTYP)Sales Org (VKORG)Billing Date (FKDAT)Customer (KUNNR)Billing Type (FKART)Country (LLAND)Sales doc (VBELN)VAPMA(SD Index:Order Items by Material)Material No (MATNR)Sales Org (VKORG)Trans Group (TRVOG)Document Date (AUDAT)Distribution Channel (VTWEG)Division (SPART)Document Type (AUART)Sold-to-Party (KUNNR)Sales Office (VKBUR)Sales Group (VKGRP)Customer PO No (BSTNK)User Name (ERNAM)Sales Ord (VBELN)Item (POSNR)SAP SD - Sales TablesSTXH(STXD SAPscript text file header)Texts (TDOBJECT)Text Name (TDNAME)Text Id (TDID)Language (TDSPRAS)VBUK(Header Status)Sales doc (VBELN)VBAK(Sales Document :Header)Sales doc (VBELN)VBUP(Item Status)Sales doc (VBELN)Item (POSNR)VAKPA(SD Index:Order by Partner Function)VBAP(Sales Document : Item Info)Sales doc (VBELN)Item (POSNR)To ShippLIPS-VGBLIPS-VGPO

Partner No (KUNDE)Partner Function (PARVW)Sales Org (VKORG)Trans Group (TRVOG)Document Date (AUDAT)Sales Office (VKBUR)