SAP 各模块表逻辑关系图详解.pptx

《SAP 各模块表逻辑关系图详解.pptx》由会员分享，可在线阅读，更多相关《SAP 各模块表逻辑关系图详解.pptx（17页珍藏版）》请在淘文阁 - 分享文档赚钱的网站上搜索。

1、SAP Principal Tables2007.09.28Netweaver TeamContents.Material Master Tables.2SD-MM Tables.367PS TablesPP Tables QM Tables CO Tables.10.11FI Tables.15Dictionary Tables.161Material Master TablesMaterial LedgerMaterial Master ViewMaterial Ledger Header CKMLHDMaterial Ledger Total ValuesCKMLCRMaterial F

2、orecast ParameterMPOPMaterial Planning Data MPGDMaterial Databy Warehouse NumberMPGDMaterial Unit of MeasureMARMMaterialTax ClassificationMLANGeneral Material MasterMARAMaterial Ledger Total Quantity CKMLPPMaterial Valuation DataMBEWMaterial Data by Plant MARCMaterial DescriptionMAKTMaterial Ledger

3、PricesCKMLPRMaterial Databy Storage LocationMARDRouting Assignment to MaterialMAPLBOM Link to MaterialMASTProduction Version of MaterialMKALRouting HeaderBOM HeaderProduction VersionBill of Material(BOM)RoutingMaterial Sales Data MVKEMaterial Data by Storage TypeMLGTMaterial TypeT134PLKORouting Item

4、PLPOSTKOBOM ItemSTPOMaterial AttributeMaterial GroupT023Material Production HierarchyT179Material Control RecordMARV 2SD-MM TablesSDMMSales Header StatusVBUKSales Item StatusSales Doc.FlowVBFAPurchase Doc.HistoryEKBESales Order HeaderVBAKSales Order ItemVBAPS/O Business DataVBKDVBUPPurchase Requisit

5、ion Purchase OrderEBANPurchase Order HeaderEKKOPurchase Order ItemEKPOS/O Schedule LineVBEPDelivery HeaderLIKPShipping HeaderVEKPS/O Schedule Line Purchase RequisitionEBKNS/O Schedule Line Purchase OrderEKKNDelivery ItemLIPSShipping ItemVEPOMaterial Doc.HeaderMKPFP/O Schedule LineEKETMaterial Doc.He

6、aderMKPFMaterial Doc.ItemMSEGGoods Issue(G/I)Material Doc.ItemMSEGGoods Receipt(G/R)Billing HeaderVBRKBilling ItemVBRPAccounting HeaderBKPFInvoice HeaderRBKPInvoice ItemRSEGAccounting SegmentBSEG3SD-MM TablesOrganization Tables SDMMCategoryTableDescriptionTextMasterTVKOSales OrganizationTVKOTTVTWDis

7、tribution ChannelTVTWTTSPADivisionTSPATTVBURSales OfficeTVKBTTVKGRSales GroupTVGRTT171Sales DistrictsT171TLinkTVKOSSales Organization+DivisionTVKOVSales Organization+ChannelTVTASales Organization+Channel+DivisionTVBVKSales Office+Sales GroupTVKBZSales Organization+Channel+Division+Sales OfficeCustom

8、erKNA1Customer General DataKNB1Customer+CompanyKNVVCustomer+Sales Organization+Distribution Channel+Division4CategoryTableDescriptionTextMasterT024EPurchasing OrganizationT024Purchasing GroupT026Purchasing AreaT026TWYT1Vendor Subrange(Vendor+Vendor Subrange)T001WPlantT001LStorage Location(Plant+Stor

9、age Location)LinkT024WPlant+Purchasing OrganizationT026ZPurchasing Organization+Purchasing Group+Purchasing AreaVendorLFA1Vendor General DataLFB1Vendor+CompanyLFM1Vendor+Purchasing OrganizationLFM2Vendor+Purchasing Organization+Vendor Subrange+PlantSD-MM TablesMM Purchasing Info RecordLong Text Info

10、rmationMaterial Info RecordCondition HeaderKONHCondition ItemKONPSAP Script Text File HeaderSTXHSAP Script Text File LinesSTXLHeaderEINAMaterial Info Record ItemEINEMaterial Info Record by Plant A017Purchasing Info Record+Material+VendorPurchasing Order Table(,)Purchasing Doc.HeaderEKKOPurchasing Do

11、c.ItemEKPOS/O Schedule Line Purchase OrderEKKNP/O Schedule LineEKETLogistics Summary Tables S?Sales Orde StockMSKA(MSKAH)Special Stocks with Customer MSKU(MSKUH)Special Stocks with Vendor MSLB(MSLBH)Storage Location Data for Material MARD(MARDH)5PS TablesProject DefinitionWork Center HeaderCRHDWork

12、CenterCO Obj.Cost TotalSummary of Actual&Plan DataObject Number (OBJNR)PROJWork Center TextCRTXExternal PostingCOSPCO Obj.Cost Total Internal Posting COSSWBS Element MasterPRPS Assignment Work Center to Cost CenterCRCOScheduling Data for Project Item PRTEPS Texts(WBS)PRTXPS Texts(Header)PSTXProducti

13、on Order Header AFKONetworkPS Texts(Description)PSTTProject Hierarchy for WBS Element PRHIProject Hierarchy for WBS Element PRHISOperation within OrderAFVCOperationActivity Value in Operation AFVVNetwork RelationshipsAFABNetwork 6PP TablesRouting Assignment to MaterialMAPLBOM Link to MaterialMASTPro

14、duction Version of MaterialMKALProduction VersionBill of Material(BOM)RoutingWork Center HeaderCRHDWork CenterRouting HeaderPLKORouting ItemBOM HeaderSTKOBOM ItemWork Center TextCRTXAssignment Work Center to Cost CenterRouting Selection of Operation/ActivatesBOMItem SelectionProduction Order Master

15、DataCAUFV ViewPlanned OrderPLAFPLPOSTPOCRCOPLASSTASAUFKProduction Order Header AFKOOrder Operation Data for Work Center S022Goods Movements Errorsfrom ConfirmationsAFFWConfirmationProduction Order ItemAFPOProduction Order Confirmation AFRU (G/R)Subsequently postedBOM Material Doc.HeaderMKPFMaterial

16、Doc.ItemMSEGGoods Movements for Confirmations AFWIReservation Header RKPFReservation Item RESB(G/I)Goods Movement for Production Order AUFM7PP TablesConfirmationOperation within OrderAFVC Order :Order Routing .Activity Value in Operation AFVVProduction Order Confirmation AFRU (G/R)Goods Movements Er

17、rors from Confirmations AFFWIncorrect Cost Calculation from ConfirmationsErrorsPDCAFRP0Table of Planned Changes for ConfirmationAutomatic Goods ReceiptSubsequently posted Goods Movements for Confirmations AFWIAFRCAFRP1BackflushingAFRP2Material Doc.HeaderMKPFData Transfer to HRAFRP4Calc.Actual CostsA

18、FRP3 Confirmation Error Backlog Program .Program:CORUPROC,CORUAFFW(T-Code:COGI)Material Doc.ItemMSEG8CharacteristicsProduction VersionProduction Versions of MaterialMKALMKAL-MATNR=MKAL-WERKS=MKAL-PLNTYMKAL-PLNNR MKAL-ALNALINOB-OBJEK=MKAL-PLNTY+MKAL-PLNNR+MKAL-ALNALLink between InternalNumber and Obj

19、ectINOBINOB-KLART INOB-OBTABAllocation Table Object to Class KSSKKSSK-OBJEK=INOB-OBTAB KSSK-KLART=INOB-KLART KSSK-CLINTClass Header DataKLAHKLAH-CLINT=KSSK-CLINT KLAH-KLART=INOB-KLART KLAH-CLASSCharacteristics of a Class KSML9QM TablesInspection Lot RecordQALSCode TextsQPCT Inspection Catalog CodeQP

20、CDQuality Notification ItemsQMFEQuality Message Maintenance Data ExcerptQMIHInspection Processing:Usage DecisionQAVEGenerated Table For View QMFEL QMFELCharacteristic Specifications for Inspection Processing QAMVQuality NotificationQMELInspection Method Master Record QMTBInspection Method Texts QMTT

21、Characteristic Results in Inspection Processing QAMRSample Specifications for Inspection ProcessingQASVInsp.Specifications/Valuation QAMVRMSResults Table for the Sample UnitQASEConfirmation Data for Multiple Spec.Sample QASRMSInspection Characteristic Master QPMKInspection Characteristic Master Text

22、sQPMTInsp.Methods/Insp.Characteristic QPMZLogistics Summary Tables S?Link Inspection Lotand Material DocumentQAMBMaterial Doc.ItemMSEGMaterial Doc.HeaderMKPF10CO TablesCO-PCA TableBasic TableCost Center MasterCSKSProfit Center MasterCEPCCost Element MasterCSKAMaster DataObject Number IndexEC-PCA:Tot

23、als TableGLPCTEC-PCA:Actual Line Items GLPCAEC-PCA:Object Table for Account Assignment Elements GLPCOfor Cost CenterONRKSEC-PCA:Transaction Attributes GLPCPSummary of Actual&Plan DataCO-PA TableObject Number(OBJNR):KS+Controlling Area(KOKRS)+Cost Center(KOSTL)CO Object Document LineCOEPCO Obj.Cost T

24、otal External Posting COSPCO Obj.Cost Total Internal Posting COSSCO Object Document Line(by Fiscal Year)COEJPlan Line ItemCE2?CO Object Document Header COBKActual Line ItemCE1?Summary Record Profitability Segment CE3?Profitability Segment Definition CE4?:Controlling Area Code11CO TablesMaterial Ledg

25、erMaterial Ledger Document Cost Estimate Header RecordCKMLHDDocument HeaderMLHDDocumentDocument PostingDocument ItemsMaterial Cost Estimate Link Period Totals Records Values CKMLCRPeriod Totals Records Quantity CKMLPPCost Component Split HeaderCKMLKEKOCost Component Split Elements CKMLKEPHProduct Co

26、sting Header Data KEKOProduct Costing Cost Components KEPHCurrencies and ValuesMLCRPeriods and QuantitiesMLPPMLITDocument Material,Cost Estimate,Production Process Link .PricesCKMLPRPP .Cost ComponentsMaterial Costing ViewCost Component Split Header for Prices CKMLPRKEKOCost Component Split Elements

27、 for Prices CKMLPRKEPHMaterial Valuation Data History MBEWHCost Component Split (Control Record)CKMLKEVCost Component GroupsMaterial Valuation DataTCKH7MBEWCost Component Groups-TextsTCKH6 CKMLHD CKMLPRKEKO CKMLPRKEKO Cost Estimate Price Update(T-Code:CK24).Program:MLCCS_STARTUPMLCCS_RESET ExecuteCo

28、st Components-TextsTCKH1Cost ComponentsTCKH312CO TablesOrder Master DataAUFKGenerated View for COCOASCO Object Product Costs Product Cost by Period()Product Cost Collector()Cost DataObject Number(OBJNR):OR+Order Number(AUFNR:or)Order Header DataAFKOTotal Variances/Results Analyses COSBOrder ItemAFPO

29、Cost Totals for External Postings COSPGenerated View for PPCAUFV WRTTP(Value Type)-04:(Preliminary Cost)-05:Cost Totals for Internal Postings COSS AUFNR:(Order Type:RM01)Activity Type TotalsCOSL OBJNR:Product Cost by Order()Production Order Cost Data.(Preliminary Cost)(Standard Cost)(:BOM+Routing).1

30、3CO TablesActivity TypesActivity MasterCSLA,CSLTCost Center MasterCSKSCost Center/Activity Type CSSLControl Data for Activity Type COKLObject Number(OBJNR):KL+Controlling Area(KOKRS)+Cost Center(KOSTL)+Activity Type(LSTAR)Activity Type TotalsLine Item for Activity Types(by Fiscal Year)Line Item for

31、Activity Types(by Period)COSLCOEJLCOEPL14FI TablesGeneral Ledger TotalVendorG/L AccountCustomerNew G/LClient LevelVendor General DataG/L Account MasterCustomer General DataFAGLFLEXTG/L Actual Line ItemFAGLFLEXAMaster DataLFA1SKA1KNA1Company Level Master DataVendor Master (Company Code)LFB1G/L Accoun

32、t (Company Code)SKB1Customer Master (Company Code)KNB1Monthly Summary DataVendor Transaction Data LFC1Customer Transaction Data KNC1General Ledger TotalFAGLFLEXT Open Item FI SummarySecondary IndexAccounting for Vendor BSIKAccounting for G/L AccountBSISAccounting for Customer BSIDAccounting for Vend

33、or BSAKAccounting for G/L AccountBSASAccounting for Customer BSAD Cleared ItemDocuments for Material BSIMAccounting Document HeaderBKPFAccounting Document Header for Parking VBKPFPosting DocumentParked DocumentClustered by RFBLGParking Document for Asset VBSEGAParking Document for Customer VBSEGDPar

34、king Document for Vendor VBSEGKParking Document for G/L Account VBSEGSAccounting Document SegmentBSEGTax DataBSETOne-time Accounting Data BSEC Bill of ExchangingBSEDControl Data(Obsolete)BSES15Dictionary TablesTableDescriptionTextDD01LDomainsDD01TDD02LSAP Tables-TRANSP:Transparent table-POOL:Pooled

35、table-INTTAB:Structure-VIEW:General view structure-CLUSTER:Cluster table-APPEND:Append structureDD02TDD03LTable FieldsDD03TDD04LData ElementsDD04TDD07LDomain Fixed ValueDD07TDD08LDictionary Relationship Definition(Check Table,Foreign Key)DD08TDD12LTable Secondary IndexesDD12TDD17SSecondary Index Fie

36、ldsDD20LMatch Code ObjectsDD20TDD30LSearch HelpDD30TDD33SAssigned Fields to Search HelpARCH_OCLASAssign classes to Archive ObjectARCH_CLASSClasses of Integrated ObjectsARCH_DEFDefinition of Archive ObjectTFDIRFunction ModulesTFTITFUPARAREFFunction ParametersTRMACABAP Program MacroTFACSFactory Calendar16