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 SDMMCategoryTableDescriptionTextMasterTVKO Sales OrganizationTVKOTTVTW D
7、istribution ChannelTVTWTTSPA DivisionTSPATTVBUR Sales OfficeTVKBTTVKGR Sales GroupTVGRTT171 Sales DistrictsT171TLinkTVKOS Sales Organization+DivisionTVKOV Sales Organization+ChannelTVTA Sales Organization+Channel+DivisionTVBVK Sales Office+Sales GroupTVKBZ Sales Organization+Channel+Division+Sales O
8、fficeCustomerKNA1 Customer General DataKNB1 Customer+CompanyKNVV Customer+Sales Organization+Distribution Channel+Division4CategoryTableDescriptionTextMasterT024EPurchasing OrganizationT024Purchasing GroupT026Purchasing AreaT026TWYT1Vendor Subrange(Vendor+Vendor Subrange)T001WPlantT001LStorage Locat
9、ion(Plant+Storage Location)LinkT024WPlant+Purchasing OrganizationT026ZPurchasing Organization+Purchasing Group+Purchasing AreaVendorLFA1Vendor General DataLFB1Vendor+CompanyLFM1Vendor+Purchasing OrganizationLFM2Vendor+Purchasing Organization+Vendor Subrange+PlantSD-MM TablesMM Purchasing Info Record
10、Long Text InformationMaterial 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.HeaderEKK
11、OPurchasing Doc.ItemEKPOS/O Schedule Line Purchase OrderEKKNP/O Schedule LineEKETLogistics Summary Tables S?Sales Orde StockMSKA(MSKAH)Special Stocks with C u s t o m e r MSKU(MSKUH)Special Stocks with Vendor MSLB(MSLBH)Storage Location Data for Material MARD(MARDH)5PS TablesProject DefinitionWork C
12、enter HeaderCRHDWork 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 Text
13、s(Header)PSTXProduction 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 Li
14、nk to MaterialMASTProduction 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 SelectionPro
15、duction Order Master 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 Do
16、c.HeaderMKPFMaterial 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
17、/R)Goods Movements Errors from Confirmations AFFWIncorrect Cost Calculation from ConfirmationsErrorsPDCAFRP0Table of Planned Changes for ConfirmationAutomatic Goods ReceiptSubsequently posted Goods Movements for Confirmations AFWIAFRCAFRP1BackflushingAFRP2Material Doc.HeaderMKPFData Transfer to HRAF
18、RP4Calc.Actual CostsAFRP3 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 I
19、nternalNumber and ObjectINOBINOB-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 Insp
20、ection Catalog CodeQPCDQuality Notification ItemsQMFEQuality Message Maintenance Data ExcerptQMIHInspection Processing:Usage DecisionQAVEGenerated Table For View QMFEL QMFELCharacteristic Specifications for Inspection Processing QAMVQuality NotificationQMELInspection Method Master Record QMTBInspect
21、ion Method Texts QMTTCharacteristic 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 Chara
22、cteristic Master TextsQPMTInsp.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 N
23、umber IndexEC-PCA:Totals 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
24、LineCOEPCO Obj.Cost Total 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 Code11C
25、O TablesMaterial LedgerMaterial 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 Elemen
26、ts CKMLKEPHProduct Costing 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 Com
27、ponent Split Elements 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_STARTUP
28、MLCCS_RESET ExecuteCost 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 Analys
29、es COSBOrder ItemAFPOCost 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
30、Cost)(:BOM+Routing).13CO 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 Fisca
31、l Year)Line Item for 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 (Compan
32、y Code)LFB1G/L Account (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 BS
33、IDAccounting for Vendor 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 f
34、or Customer VBSEGDParking 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:Transpare
35、nt table-POOL:Pooled 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 IndexesDD12TDD1
36、7SSecondary Index FieldsDD20LMatch 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
