SAP常用后台透明表

1、TABLES IN SAP1CUSTOMISING31.1General settings3Countries3Currency3Unit of measure3Calendar functions31.2Enterprise structure3Definition3Assignment31.3Financial accounting4Company code4Fi document41.4Not categorized42BASIC DATA / ADMINISTRATION52.1Workbench related tables5Data dictionary tables5Workbe

2、nch52.2Administration5User administration5Batch input queue5Job processing5Spool5Runtime errors6Message control6EDI6Change documents6Reporting tree table6LIS structure/control tables63MASTER DATA :73.1Material master :7Basic data text (sap script)7Batches73.2Customer master data73.3Vendor73.4Custome

3、r material info record83.5Bank data84CHARACTERISTICS :94.1Characteristics :94.2Class types and objects :94.3Links :95FI/CO :105.1FI :10Master data10Accounting documents / indices10Payment run105.2CO :10Cost center master data10Cost center accounting106SALES AND DISTRIBUTION (SD) :116.1Sales order :1

4、16.2Billing document :116.3Shipping :116.4Delivery :116.5Pricing :116.6contracts :117MATERIAL MANAGEMENT (MM) :127.1Material document127.2Purchasing128WAREHOUSE MANAGEMENT (WM) :138.1Transfer requirement138.2Transfer order138.3Master data - stock positions138.4Inventory documents in WM139QUALITY MAN

5、AGEMENT (QM) :149.1Inspection lot / info record149.2Quality notification149.3Certificate profile1410PRODUCTION PLANNING (PP)1510.1Work center1510.2Routings/operations1510.3Bill of material1510.4Production orders1510.5Planned orders1610.6KANBAN1610.7Reservations1610.8Capacity planning1610.9Planned in

6、dependent requirements1611PROJECT SYSTEM (PS)1711.1Basic data1711.2Equipment1712PLANT MAINTENANCE (PM)1712.1Human resources1812.2Settings1812.3Master data1812.4Infotypes181 Customising 1.1 General settings1.1.1 Countries T005Countries1.1.2 Currency TCURCCurrency codesTCURRWisselkoersenTCURTCurrency

7、nameTCURXDecimal places for currencies.1.1.3 Unit of measure T006Units of measure1.1.4 Calendar functionsT247Month namesTFACDFactory calendar definitionT015MMonth namesTTZZTime zonesTTZDSummer time rulesTTZDFSummer time rules (fixed annual dates)TTZDVSummer time rules (variable dates)TTZDTSummer tim

8、e rules textsTTZ5Assign Time Tones to CountriesTTZ5SAssign time zones to regions1.2 Enterprise structure 1.2.1 Definition FIT880CompanyT001Company codeCOTKA01Controlling areaLOT001WPlant / sales organisationT499SLocationsTSPADivisionSDTVKOSales organisation / company codeTVTWDistribution channelTVBU

9、RSales officeTVKBTSales office textTVKGRSales groupTVGRTSales group text T171TSales district textMMT001LStorage locationsT024EPurchasing organizationT3001Warehouse numberTVSTShipping pointTVLALoading pointTTDSTransportation1.2.2 AssignmentCOTKA02Assign company code to controlling areaLOT001KAssign p

10、lant (valuation area) to company codeSDTVKOSales organisation / company codeTVKOVDistribution channel / sales organisationTVKOSDivision to sales organizationTVTASales ariaTVKBZSales office to sales areaTVBVKSales group to sales officeTVKWZPlants to sales organizationMMT024EPurchasing organization /

11、company codeT024WPlant to Purchase organization T001KLink plant ( = valuation area) / company codeTVSWZShipping point to plantT320Assignment MM Storage Location to WM Warehouse1.3 Financial accounting1.3.1 Company codeT004Chart of accountsT077SAccount group (g/l accounts)T009Fiscal year variantsT880

12、Global company dataT014Credit control area1.3.2 Fi documentT010OPosting period variantT010PPosting Period Variant NamesT001BPermitted Posting PeriodsT003Document typesT012House banks1.4 Not categorizedT007aTax keysT134Material typesT179Materials: Product HierarchiesT179TMaterials: Product hierarchie

13、s: TextsTJ02TStatus textTINCCustomer incotermsTVFKBilling doc typesT390PM: Shop papers for print control2 Basic data / administration2.1 Workbench related tables2.1.1 Data dictionary tablesDD02LTables in SAPDD02TTables descriptionDD03LField names in SAPDD03TField description in SAP2.1.2 WorkbenchTAD

14、IRDirectory of R/3 Repository ObjectsTRDIRSystem table TRDIRTFDIRFunction ModuleTLIBGPerson responsible for function classTLIBTFunction Group Short TextsTFTITFunction Module Short TextTSTCTransaction codes in SAPTSTCTTransaction codes textsT100Message text (vb e000)VARIDVariant dataD020TScreen texts

15、TDEVCDevelopment classTDEVCTTexts for development classes2.2 Administration2.2.1 User administrationUSR01User masterUSR02Logon dataUSR03User address dataUSR04User master authorizationsUSR11User Master Texts for Profiles (USR10)UST12User master: AuthorizationsUSR12User master authorization valuesUSR1

16、3Short Texts for AuthorizationsUSR40Prohibited passwordsTOBJObjectsTOBCAuthorization Object ClassesTPRPROFProfile Name for Activity GroupDEVACCESSTable for development user2.2.2 Batch input queueAPQDDATA DEFINITION QueueAPQIQueue info definition 2.2.3 Job processingTBTCOJob status overview tableTBTC

17、PBatch job step overview2.2.4 SpoolTSP02Spool: Print requests2.2.5 Runtime errorsSNAPRuntime errors2.2.6 Message control TNAPRProcessing programs for outputNASTMessage status NACHPrinter determination2.2.7 EDIEDIDCControl recordEDIDDData recordEDID2Data record 3.0 VersionEDIDSEDI status recordEDPARC

18、onvert External < > Internal Partner NumberEDPVWEDI partner typesEDPI1EDI partner profile inboundEDPO1/2/3EDI partner profile outbound2.2.8 Change documentsCDHDRChange document headerCDPOSChange document positionenJCDSChange Documents for System/User Statuses (Table JEST)2.2.9 Reporting tree t

19、ableSERPTREEReporting: tree structure2.2.10 LIS structure/control tablesTMC4Global Control Elements: LIS Info Structure3 MASTER DATA :3.1 Material master :MARAMaterial masterMAKT Material textMARCMaterial per plant / stockMVKEMaterial master, sales dataMARDStorage location / stockMSKASales order sto

20、ckMSPRProject stockMARMUnits of measureMEANInternational article numberPGMIPlanning material PROPForecast parametersMAPRLink MARC <=> PROPMBEWMaterial valuationMVERMaterial consumptionMLGNMaterial / Warehouse numberMLGTMaterial / Storage typeMPRPForecast profilesMDTBMRP tableMDKPHeader data fo

21、r MRP documentMLANTax data material masterMTQSSMaterial master view: QM3.1.1 Basic data text (sap script)STXBSAPscript: Texts in non-SAPscript formatSTXHSTXD SAPscript text file headerSTXLSTXD SAPscript text file lines3.1.2 Batches MCHABatchesMCH1BatchesMCHBStock : batches3.2 Customer master dataKNA

22、1Customer masterKNB1Customer / companyKNVVCustomer sales dataKNBKBank detailsKNVHCustomer hierarchyKNVPCustomer partnersKNVSShipment data for customerKNVKContact personsKNVICustomer master tax indicator3.3 VendorLFA1Vendor masterLFB1Vendor per company codeLFB5Vendor dunning dataLFM1Purchasing organi

23、sation dataLFM2Purchasing dataLFBKBank details3.4 Customer material info recordKNMTCustomer material info record3.5 Bank dataBNKAMaster bank data4 Characteristics :4.1 Characteristics :CABNCharacteristics ( o.a. batch/vendor)CABNTCharacteristics descriptionCAWNCharacteristics ( o.a. material)CAWNTCh

24、aracteristics descriptionAUSPCharacteristic Values4.2 Class types and objects : TCLAO Several class types for objectTCLAClass types ( vb. lfa1 => v10 en 010)TCLATClass type textTCLTClassifiable objectsTCLCClassification status4.3 Links :INOBLink between Internal Number and ObjectKLAH Class header

25、 data KSSKAllocation Table: Object (vb.matnr) to Class KSMLCharacteristics for a class (internal number)5 FI/CO :5.1 FI :5.1.1 Master dataSKA1AccountsBNKA Bank master record5.1.2 Accounting documents / indicesBKPFAccounting documentsBSEGitem levelBSID Accounting: Secondary index for customers BSIK A

26、ccounting: Secondary index for vendors BSIM Secondary Index, Documents for Material BSIP Index for vendor validation of double documents BSIS Accounting: Secondary index for G/L accountsBSAD Accounting: Index for customers (cleared items) BSAK Accounting: Index for vendors (cleared items) BSAS Accou

27、nting: Index for G/L accounts (cleared items)5.1.3 Payment runREGUHSettlement data from payment programREGUPProcessed items from payment program5.2 CO :TKA01Controlling areasTKA02Controlling area assignmentKEKOProduct-costing headerKEPHCost components for cost of goods manuf.KALOCosting objectsKANZS

28、ales order items - costing objects5.2.1 Cost center master dataCSKSCost Center Master DataCSKTCost center textsCRCOAssignment of Work Center to Cost Center5.2.2 Cost center accountingCOSPCO Object: Cost Totals for External PostingsCOEPCO Object: Line Items (by Period).COBKCO Object: Document headerC

29、OSTCO Object: Price Totals6 Sales and Distribution (SD) :VBFADocument flow (alg.)VTFAFlow shipping documents6.1 Sales order :VBAKHeader dataVBAPItem dataVBPAPartners in sales orderVBKDSales district dataVBEPData related to line items, delivery lines6.2 Billing document :VBRKheader dataVBRPItem data6

30、.3 Shipping :VTTKShipment headerVTTPShipment itemVTTSStage in transportVTSPStage in transport per shipment itemVTPAShipment partnersVEKPHandling Unit - Header TableVEPOPacking: Handling Unit Item (Contents)6.4 Delivery :LIKPDelivery headerLIPSDelivery item6.5 Pricing :KONH Conditions headerKONPCondi

31、tions itemsKONVProcedure ( billing doc or sales order)KOND6.6 contracts :VEDAContract data7 Material Management (MM) :7.1 Material documentMKPFmaterial documentMSEGmaterial document (item level)7.2 PurchasingEKKOPurchase documentEKPOPurchase document (item level)EKPVShipping-Specific Data on Stock T

32、fr. for Purch. Doc. ItemEKETDelivery scheduleVETVGDelivery Due Index for Stock TransferEKESOrder Acceptance/Fulfillment ConfirmationsEKKNAccount assignment in purchasingEKANVendor address purchasingEKPAPartner functionsEIPOItem export / import dataEINAPurchase info record (main data)EINEPurchase inf

33、o record (organisational data)EORDSource listEBANPurchase requisitionEBKNPurchase Requisition Account Assignment8 Warehouse Management (WM) :8.1 Transfer requirementLTBKTransfer requirement - headerLTBPTransfer requirement - item8.2 Transfer orderLTAKTransfer order - headerLTAPTransfer order - item8

34、.3 Master data - stock positionsLQUAQuants8.4 Inventory documents in WMLINKInventory document headerLINPInventory document itemLINVInventory data per quant9 Quality Management (QM) : 9.1 Inspection lot / info recordQALSInspection lot recordQAMBLink inspection lot - material documentQAVEInspection us

35、age decision QDPSInspection stagesQMATInspection type - material parametersQINFInspection info record (vendor - material)QDQLQuality levelQDPSInspection stages9.2 Quality notificationTQ80Notification typesQMELQuality notificationQMFEQuality notification itemsQMURQuality notification causesQMSMQualit

36、y notification tasksQMMAQuality notification activitiesQMIHQuality message - maintenance data excerpt9.3 Certificate profileQCVMTCertificate profile characteristic level: textsQCVMCertificate profile characteristic levelQCVKCertificate profile header10 Production Planning (PP)10.1 Work centerCRHHWor

37、k center hierarchy()CRHSHierarchy structureCRHDWork center headerCRTXText for the Work Center or Production Resource/ToolCRCOAssignment of Work Center to Cost CenterKAKOCapacity Header SegmentCRCAWork Center Capacity AllocationTC24Person responsible for the workcenter10.2 Routings/operationsMAPLAllo

38、cation of task lists to materialsPLASTask list - selection of operations/activitiesPLFHTask list - production resources/toolsPLFLTask list - sequencesPLKOTask list - headerPLKZTask list: main headerPLPHPhases / suboperationsPLPOTask list operation / activityPLPRLog collector for tasklistsPLMZAllocat

39、ion of BOM - items to operations10.3 Bill of materialSTKOBOM - headerSTPOBOM - itemSTASBOMs - Item SelectionSTPNBOMs - follow-up controlSTPUBOM - sub-itemSTZUPermanent BOM dataPLMZAllocation of BOM - items to operationsMASTMaterial to BOM linkKDSTSales order to BOM link10.4 Production ordersAUFKProd

40、uction order headersAFIHMaintenance order headerAUFMGoods movement for prod. orderAFKOOrder header data PP ordersAFPOOrder itemRESBOrder componenten AFVCOrder operationsAFVVQuantities/dates/values in the operationAFVUUser fields of the operationAFFLWork order sequenceAFFHPRT assignment data for the

41、work order(routing)JSTOStatus profileJESTObject statusAFRUOrder completion confirmations PRTs voor production ordersAFFHPRT assignment data for the work orderCRVD_ALink of PRT to DocumentDRAWDocument Info RecordTDWADocument TypesTDWDData Carrier/Network NodesTDWEData Carrier Type10.5 Planned ordersPLAFPlanned orders10.6 KANBANPKPSKanban identification, control cyclePKHDKanban control cycle (header data)PKERError log for Kanban containers10.7 ReservationsRESBMaterial reservationsRKPFheader