SAP常用后台透明表.doc

《SAP常用后台透明表.doc》由会员分享，可在线阅读，更多相关《SAP常用后台透明表.doc（19页珍藏版）》请在淘文阁 - 分享文档赚钱的网站上搜索。

1、-作者xxxx-日期xxxxSAP常用后台透明表【精品文档】TABLES IN SAP1CUSTOMISING3General settings3Countries3Currency3Unit of measure3Calendar functions3Enterprise structure3Definition3Assignment3Financial accounting4Company code4Fi document4Not categorized42BASIC DATA / ADMINISTRATION5Workbench related tables5Data dictionar

2、y tables5Workbench5Administration5User administration5Batch input queue5Job processing5Spool5Runtime errors6Message control6EDI6Change documents6Reporting tree table6LIS structure/control tables63MASTER DATA :7Material master :7Basic data text (sap script)7Batches7Customer master data7Vendor7Custome

3、r material info record8Bank data84CHARACTERISTICS :9Characteristics :9Class types and objects :9Links :95FI/CO :10FI :10Master data10Accounting documents / indices10Payment run10CO :10Cost center master data10Cost center accounting106SALES AND DISTRIBUTION (SD) :11Sales order :11Billing document :11

4、Shipping :11Delivery :11Pricing :11contracts :117MATERIAL MANAGEMENT (MM) :12Material document12Purchasing128WAREHOUSE MANAGEMENT (WM) :13Transfer requirement13Transfer order13Master data - stock positions13Inventory documents in WM139QUALITY MANAGEMENT (QM) :14Inspection lot / info record14Quality

5、notification14Certificate profile1410PRODUCTION PLANNING (PP)15Work center15Routings/operations15Bill of material15Production orders15Planned orders16KANBAN16Reservations16Capacity planning16Planned independent requirements1611PROJECT SYSTEM (PS)17Basic data17Equipment1712PLANT MAINTENANCE (PM)17Hum

6、an resources18Settings18Master data18Infotypes181 Customising 1.1 General settings1.1.1 Countries T005Countries1.1.2 Currency TCURCCurrency codesTCURRWisselkoersenTCURTCurrency nameTCURXDecimal places for currencies.1.1.3 Unit of measure T006Units of measure1.1.4 Calendar functionsT247Month namesTFA

7、CDFactory calendar definitionT015MMonth namesTTZZTime zonesTTZDSummer time rulesTTZDFSummer time rules (fixed annual dates)TTZDVSummer time rules (variable dates)TTZDTSummer time rules textsTTZ5Assign Time Tones to CountriesTTZ5SAssign time zones to regions1.2 Enterprise structure 1.2.1 Definition F

8、IT880CompanyT001Company codeCOTKA01Controlling areaLOT001WPlant / sales organisationT499SLocationsTSPADivisionSDTVKOSales organisation / company codeTVTWDistribution channelTVBURSales officeTVKBTSales office textTVKGRSales groupTVGRTSales group text T171TSales district textMMT001LStorage locationsT0

9、24EPurchasing organizationT3001Warehouse numberTVSTShipping pointTVLALoading pointTTDSTransportation1.2.2 AssignmentCOTKA02Assign company code to controlling areaLOT001KAssign plant (valuation area) to company codeSDTVKOSales organisation / company codeTVKOVDistribution channel / sales organisationT

10、VKOSDivision to sales organizationTVTASales ariaTVKBZSales office to sales areaTVBVKSales group to sales officeTVKWZPlants to sales organizationMMT024EPurchasing organization / company codeT024WPlant to Purchase organization T001KLink plant ( = valuation area) / company codeTVSWZShipping point to pl

11、antT320Assignment MM Storage Location to WM Warehouse1.3 Financial accounting1.3.1 Company codeT004Chart of accountsT077SAccount group (g/l accounts)T009Fiscal year variantsT880Global company dataT014Credit control area1.3.2 Fi documentT010OPosting period variantT010PPosting Period Variant NamesT001

12、BPermitted Posting PeriodsT003Document typesT012House banks1.4 Not categorizedT007aTax keysT134Material typesT179Materials: Product HierarchiesT179TMaterials: Product hierarchies: TextsTJ02TStatus textTINCCustomer incotermsTVFKBilling doc typesT390PM: Shop papers for print control2 Basic data / admi

13、nistration2.1 Workbench related tables2.1.1 Data dictionary tablesDD02LTables in SAPDD02TTables descriptionDD03LField names in SAPDD03TField description in SAP2.1.2 WorkbenchTADIRDirectory of R/3 Repository ObjectsTRDIRSystem table TRDIRTFDIRFunction ModuleTLIBGPerson responsible for function classT

14、LIBTFunction Group Short TextsTFTITFunction Module Short TextTSTCTransaction codes in SAPTSTCTTransaction codes textsT100Message text (vb e000)VARIDVariant dataD020TScreen textsTDEVCDevelopment classTDEVCTTexts for development classes2.2 Administration2.2.1 User administrationUSR01User masterUSR02Lo

15、gon dataUSR03User address dataUSR04User master authorizationsUSR11User Master Texts for Profiles (USR10)UST12User master: AuthorizationsUSR12User master authorization valuesUSR13Short Texts for AuthorizationsUSR40Prohibited passwordsTOBJObjectsTOBCAuthorization Object ClassesTPRPROFProfile Name for

16、Activity GroupDEVACCESSTable for development user2.2.2 Batch input queueAPQDDATA DEFINITION QueueAPQIQueue info definition 2.2.3 Job processingTBTCOJob status overview tableTBTCPBatch job step overview2.2.4 SpoolTSP02Spool: Print requests2.2.5 Runtime errorsSNAPRuntime errors2.2.6 Message control TN

17、APRProcessing programs for outputNASTMessage status NACHPrinter determination2.2.7 EDIEDIDCControl recordEDIDDData recordEDID2Data record 3.0 VersionEDIDSEDI status recordEDPARConvert External Internal Partner NumberEDPVWEDI partner typesEDPI1EDI partner profile inboundEDPO1/2/3EDI partner profile o

18、utbound2.2.8 Change documentsCDHDRChange document headerCDPOSChange document positionenJCDSChange Documents for System/User Statuses (Table JEST)2.2.9 Reporting tree tableSERPTREEReporting: tree structure2.2.10 LIS structure/control tablesTMC4Global Control Elements: LIS Info Structure3 MASTER DATA

19、:3.1 Material master :MARAMaterial masterMAKT Material textMARCMaterial per plant / stockMVKEMaterial master, sales dataMARDStorage location / stockMSKASales order stockMSPRProject stockMARMUnits of measureMEANInternational article numberPGMIPlanning material PROPForecast parametersMAPRLink MARC PRO

20、PMBEWMaterial valuationMVERMaterial consumptionMLGNMaterial / Warehouse numberMLGTMaterial / Storage typeMPRPForecast profilesMDTBMRP tableMDKPHeader data for MRP documentMLANTax data material masterMTQSSMaterial master view: QM3.1.1 Basic data text (sap script)STXBSAPscript: Texts in non-SAPscript

21、formatSTXHSTXD SAPscript text file headerSTXLSTXD SAPscript text file lines3.1.2 Batches MCHABatchesMCH1BatchesMCHBStock : batches3.2 Customer master dataKNA1Customer masterKNB1Customer / companyKNVVCustomer sales dataKNBKBank detailsKNVHCustomer hierarchyKNVPCustomer partnersKNVSShipment data for c

22、ustomerKNVKContact personsKNVICustomer master tax indicator3.3 VendorLFA1Vendor masterLFB1Vendor per company codeLFB5Vendor dunning dataLFM1Purchasing organisation dataLFM2Purchasing dataLFBKBank details3.4 Customer material info recordKNMTCustomer material info record3.5 Bank dataBNKAMaster bank da

23、ta4 Characteristics :4.1 Characteristics :CABNCharacteristics ( o.a. batch/vendor)CABNTCharacteristics descriptionCAWNCharacteristics ( o.a. material)CAWNTCharacteristics descriptionAUSPCharacteristic Values4.2 Class types and objects : TCLAO Several class types for objectTCLAClass types ( vb. lfa1

24、= v10 en 010)TCLATClass type textTCLTClassifiable objectsTCLCClassification status4.3 Links :INOBLink between Internal Number and ObjectKLAH Class header data KSSKAllocation Table: Object (vb.matnr) to Class KSMLCharacteristics for a class (internal number)5 FI/CO :5.1 FI :5.1.1 Master dataSKA1Accou

25、ntsBNKA Bank master record5.1.2 Accounting documents / indicesBKPFAccounting documentsBSEGitem levelBSID Accounting: Secondary index for customers BSIK Accounting: Secondary index for vendors BSIM Secondary Index, Documents for Material BSIP Index for vendor validation of double documents BSIS Accou

26、nting: Secondary index for G/L accountsBSAD Accounting: Index for customers (cleared items) BSAK Accounting: Index for vendors (cleared items) BSAS Accounting: Index for G/L accounts (cleared items)5.1.3 Payment runREGUHSettlement data from payment programREGUPProcessed items from payment program5.2

27、 CO :TKA01Controlling areasTKA02Controlling area assignmentKEKOProduct-costing headerKEPHCost components for cost of goods manuf.KALOCosting objectsKANZSales order items - costing objects5.2.1 Cost center master dataCSKSCost Center Master DataCSKTCost center textsCRCOAssignment of Work Center to Cos

28、t Center5.2.2 Cost center accountingCOSPCO Object: Cost Totals for External PostingsCOEPCO Object: Line Items (by Period).COBKCO Object: Document headerCOSTCO Object: Price Totals6 Sales and Distribution (SD) :VBFADocument flow (alg.)VTFAFlow shipping documents6.1 Sales order :VBAKHeader dataVBAPIte

29、m dataVBPAPartners in sales orderVBKDSales district dataVBEPData related to line items, delivery lines6.2 Billing document :VBRKheader dataVBRPItem data6.3 Shipping :VTTKShipment headerVTTPShipment itemVTTSStage in transportVTSPStage in transport per shipment itemVTPAShipment partnersVEKPHandling Un

30、it - Header TableVEPOPacking: Handling Unit Item (Contents)6.4 Delivery :LIKPDelivery headerLIPSDelivery item6.5 Pricing :KONH Conditions headerKONPConditions itemsKONVProcedure ( billing doc or sales order)KOND6.6 contracts :VEDAContract data7 Material Management (MM) :7.1 Material documentMKPFmate

31、rial documentMSEGmaterial document (item level)7.2 PurchasingEKKOPurchase documentEKPOPurchase document (item level)EKPVShipping-Specific Data on Stock Tfr. for Purch. Doc. ItemEKETDelivery scheduleVETVGDelivery Due Index for Stock TransferEKESOrder Acceptance/Fulfillment ConfirmationsEKKNAccount as

32、signment in purchasingEKANVendor address purchasingEKPAPartner functionsEIPOItem export / import dataEINAPurchase info record (main data)EINEPurchase info record (organisational data)EORDSource listEBANPurchase requisitionEBKNPurchase Requisition Account Assignment8 Warehouse Management (WM) :8.1 Tr

33、ansfer requirementLTBKTransfer requirement - headerLTBPTransfer requirement - item8.2 Transfer orderLTAKTransfer order - headerLTAPTransfer order - item8.3 Master data - stock positionsLQUAQuants8.4 Inventory documents in WMLINKInventory document headerLINPInventory document itemLINVInventory data p

34、er quant9 Quality Management (QM) : 9.1 Inspection lot / info recordQALSInspection lot recordQAMBLink inspection lot - material documentQAVEInspection usage decision QDPSInspection stagesQMATInspection type - material parametersQINFInspection info record (vendor - material)QDQLQuality levelQDPSInspe

35、ction stages9.2 Quality notificationTQ80Notification typesQMELQuality notificationQMFEQuality notification itemsQMURQuality notification causesQMSMQuality notification tasksQMMAQuality notification activitiesQMIHQuality message - maintenance data excerpt9.3 Certificate profileQCVMTCertificate profil

36、e characteristic level: textsQCVMCertificate profile characteristic levelQCVKCertificate profile header10 Production Planning (PP)10.1 Work centerCRHHWork center hierarchy()CRHSHierarchy structureCRHDWork center headerCRTXText for the Work Center or Production Resource/ToolCRCOAssignment of Work Cen

37、ter to Cost CenterKAKOCapacity Header SegmentCRCAWork Center Capacity AllocationTC24Person responsible for the workcenter10.2 Routings/operationsMAPLAllocation of task lists to materialsPLASTask list - selection of operations/activitiesPLFHTask list - production resources/toolsPLFLTask list - sequen

38、cesPLKOTask list - headerPLKZTask list: main headerPLPHPhases / suboperationsPLPOTask list operation / activityPLPRLog collector for tasklistsPLMZAllocation of BOM - items to operations10.3 Bill of materialSTKOBOM - headerSTPOBOM - itemSTASBOMs - Item SelectionSTPNBOMs - follow-up controlSTPUBOM - s

39、ub-itemSTZUPermanent BOM dataPLMZAllocation of BOM - items to operationsMASTMaterial to BOM linkKDSTSales order to BOM link10.4 Production ordersAUFKProduction order headersAFIHMaintenance order headerAUFMGoods movement for prod. orderAFKOOrder header data PP ordersAFPOOrder itemRESBOrder componente

40、n AFVCOrder operationsAFVVQuantities/dates/values in the operationAFVUUser fields of the operationAFFLWork order sequenceAFFHPRT assignment data for the 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 Kanb