SAP各模块常用表

1、ECCSSAP COMMON USED TABLES1-13TableTableTypeApplicationClassDataClassDescriptionLogicalDatabase/s NotesTF100Financial Statement ItemsTF101FS items: short and medium textsTF102FS items: long textsTF103Breakdown CategoriesTF104Breakdown categories: NameTF105FS Item CategoriesTF106FS Item Categories: D

2、escriptionTF110TRANSPKEMasterSubitem CategoriesTF111Subitem Categories: DescriptionTF115SubitemsTF116Subitems: short and medium textsTF117Subitems: long textsTF120TRANSPKEMasterConsolidation Charts of AccountsTF121Consolidation Charts of Accounts: DescriptioTF123Additional rules for running program

3、SAPF124TF130FS item hierarchiesTF131Item hierarchies: NameTF140Selected FS ItemsTF150TRANSPKEMasterDimensionsTF151Dimensions: Texts and user-specific namesTF152Dimensions, screen list, consolidation unitsTF153Dimensions, screen list, consolidation groupTF154Dimensions year- and period-dependentTF155

4、Dimensions: Assign Task GroupsTF160Consolidation UnitsTF161Consolidation units: textsTF162Consolidation unit correspondenceTF164Consolidation unit year-dependentTF165Consolidation units version-dependentTF166Consolidation units version- and period cateTF167Consolidation units version- and period-dep

5、eTF168Consolidation units ledger-dependentTF169Version/period-dependent Cons Units: Tax RaTF170Position of contact personTF171Position of Contact Person: DescriptionTF172Contact person assignmentsTF173Reasons for InclusionTF174Reasons for inclusion: short and medium textTF175Reasons for inclusion: l

6、ong textsTF180Consolidation GroupsTF181Consolidation groups: TextsTF182Consolidation groups, version-dependentTF183Consolidation groups, version- and period caTF184Consolidation groups, version- and year-depeTF187Consolidation Group Set AssignmentsTF188Consolidation group assignment of task groupTF1

7、89Assignment of CG/CU, version- and period-depTF190HierarchiesTF191Hierarchies: textsTF192Hierarchies, period-dependentTF193Hierarchies, version-dependentTF194Hierarchies, version- and period category-deTF195Hierarchy levelsTF196Hierarchy levels: textsTF197Hierarchy levels usedTF198Hierarchy level r

8、elationshipsTF199AOrganizational elementsTF199BOrganizational elements: TextsTF199CCharacteristic Values of Organizational ElemTF199DChar. Values of Organizational Elements: TexTF199EOrganizational Element RelationshipsTFIN010 Consolidation Unit IntegrationECMCAEC-CS: Journal Entry table(Actual)451c

9、c44acb9c11f90906678cb4db3141.xlsCO Tables, Page 2TableTableTypeApplicationClassDataClassDescriptionLogicalDatabase/s NotesCEPCTRANSPKEMasterProfit center master data tableCOBKTRANSPKATransactionCO Object: Document headerCOEJTRANSPKATransactionCO object: year-related line itemsCOEJLTRANSPKATransactio

10、nCO Object: Line Items for Activity Types (by Year)COEJRTRANSPKATransactionCO Object: Statistical Key Figure Line Items (by Year)COEJTTRANSPKATransactionCO Object: Activity Price Line Items (by Year)COEPTRANSPKATransactionCO object: period-related line itemsCOEPBTRANSPKATransactionCO Object: Line It

11、ems Variance/Period-based Results AnalysisCOEPLTRANSPKATransactionCO Object: Line Items for Activity Types (by Period)COEPRTRANSPKATransactionCO Object: Statistical Key Figure Line Items (by Period)COEPTTRANSPKATransactionCO Object: Activity Price Line Items (by Period)COKATRANSPKATransactionCO Obje

12、ct: Cost Element Control DataCOKLTRANSPKATransactionCO Object: Activity type control dataCOKPTRANSPKATransactionCO Object: Primary Planning Control DataCOKRTRANSPKATransactionCO Object: Statistical Key Figure Control DataCOKSTRANSPKATransactionCO Object: Control Data for Secondary PlanningCOSBTRANSP

13、KATransactionCO Object: Total Variances/Results AnalysesCOSBDTRANSPKATransactionCO Object: Total of variances/accruals, of which settledCOSLTRANSPKATransactionCO Object: Activity Type TotalsCOSPTRANSPKATransactionCO Object: Cost Totals - External PostingsCOSPDTRANSPKATransactionCO Object: Settled Pr

14、imary Cost TotalsCOSRTRANSPKATransactionCO Object: Statistical Ratio TotalsCOSSTRANSPKATransactionCO Object: Cost Totals - Internal PostingsCOSSDTRANSPKATransactionCO Object: Settled Secondary Cost TotalsCOSTTRANSPKATransactionCO object: standard rate totalsCSKATRANSPKSMasterCost elements (data depe

15、ndent on chart of accounts)CSKBTRANSPKSMasterCost elements (data dependent on controlling area)CSKSTRANSPKSSMasterCost center masterCSKTTRANSPKSSMasterCost center textsCSKUTRANSPKSMasterCost element textsCSLATRANSPKSSMasterActivity masterCSLTTRANSPKSSMasterActivity type textsCSSKTRANSPKSSMasterCost

16、center /cost element451cc44acb9c11f90906678cb4db3141.xlsCO Tables, Page 3CSSLTRANSPKSSMasterCost center / activity451cc44acb9c11f90906678cb4db3141.xlsMM Tables, Page 4TableTableClassApplicationClassDataClassDescriptionLogicalDatabase/s NotesEBANTRANSPMETransactionPurchase RequisitionEBMEBKNTRANSPMET

17、ransactionPurchase Requisition Account AssignmentEBMEBUBTRANSPMETransactionIndex for Stock Transport Requisitions for MaterialEINATRANSPMETransactionPurchasing Info Record - General DataIFMEINETRANSPMETransactionPurchasing Info Record - Purchasing Organization DataIFMEIPATRANSPMETransactionOrder Pri

18、ce History, Info RecordIFMEKABTRANSPMETransactionRelease DocumentationEKANTRANSPMETransactionVendor Address: Purchasing DocumentEKBETRANSPMETransactionHistory of Purchasing DocumentEBMEKBZTRANSPMETransactionHistory of Purchasing Document - Delivery CostsEKETTRANSPMETransactionDelivery SchedulesEBMEK

19、KNTRANSPMETransactionAccount Assignment in Purchasing DocumentEBMEKKOTRANSPMETransactionPurchasing Document HeaderEBMEKPBTRANSPMETransactionMaterial Provided Item in Purchasing DocumentEKPOTRANSPMETransactionPurchasing Document ItemEBMEKUBTRANSPMETransactionIndex for Stock Transport Orders for Mater

20、ialESKNTRANSPMETransactionAccount Assignment in Service PackageLFM1TRANSPMETransactionVendor master record purchasing organization dataMAKTTRANSPMGMasterMaterial DescriptionsMAPRTRANSPMGMasterMaterial Index for ForecastPointer for forecast dataMARATRANSPMGMasterMaterial Master: General DataMSMMARCTR

21、ANSPMGMasterMaterial Master: C SegmentMSMMARDTRANSPMGMasterMaterial Master: Storage Location/Batch SegmentMSMMARMTRANSPMGMasterUnits of MeasureMSMMARVTRANSPMGMasterMaterial Control RecordMBEWTRANSPMGMasterMaterial ValuationMSMMBPRTRANSPMGMasterStock at Production Storage BinMCHATRANSPMGMasterBatches

22、MCHBTRANSPMGMasterBatch StocksMSMMLANTRANSPMGMasterTax Classification: MaterialSales Data (for each country)MLGNTRANSPMGMasterMaterial Data per Warehouse NumberMSMWarehouse management inventory dataMLGTTRANSPMGMasterMaterial Data per Storage TypeMSMWarehouse management inventory typedataMSTATRANSPMG

23、MasterMaterial Master StatusMVERTRANSPMGMasterMaterial consumptionMVKETRANSPMGMasterMaterial Master: Sales DataMSMSales Data (for each Sales Org andDistribution Channel)T001LTRANSPMGOrganizational Storage LocationsT001WTRANSPMGOrganizational Plants/BranchesMKPFTRANSPMBTransactionHeader: Material Doc

24、umentLMMMSEGTRANSPMBTransactionDocument Segment: MaterialLMMIKPFTRANSPMBTransactionHeader: Physical Inventory DocumentINMISEGTRANSPMBTransactionPhysical Inventory Document ItemsINMS068廠商統計451cc44acb9c11f90906678cb4db3141.xlsFI Tables, Page 5TableTableTypeApplicationClassDataClassDescriptionLogicalDa

25、tabase/sNotesBKPFTRANSPFBTransactionAccounting document headerBNKATRANSPFBMasterBank master recordBSADTRANSPFBTransactionAccounting: Secondary index for customers (cleared items)BSAKTRANSPFBTransactionAccounting: Secondary index for vendors (cleared items)BSASTRANSPFBTransactionAccounting: Secondary

26、 index for G/L accounts (cleared items)BSECCLUSTER FBTransactionOne-time account data document segmentBSEGCLUSTER FBTransactionAccounting document segmentAVOID USING!Use BSID, BSIK, and/or BSIS for open itemsand BSAD, BSAK, and/or BSAS for cleareditemsBSETCLUSTER FBTransactionTax data document segme

27、ntBSIDTRANSPFBTransactionAccounting: Secondary index for customersBSIKTRANSPFBTransactionAccounting: Secondary index for vendorsBSISTRANSPFBTransactionAccounting: Secondary index for G/L accountsGLT0TRANSPFGTransactionG/L Account Master Record Monthly Debits and CreditsKNA1TRANSPFBMasterGeneral Data

28、 in Customer MasterDDFKNASTRANSPFBMasterCustomer master (VAT registration numbers general section)DDFKNB1TRANSPFBMasterCustomer master (company code)DDFKNB4TRANSPFBMasterCustomer payment historyDDFKNB5TRANSPFBMasterCustomer master (dunning data)DDFKNBKTRANSPFBMasterCustomer master (bank details)DDFK

29、NC1TRANSPFBMasterCustomer master (transaction figures)DDFKNC3TRANSPFBMasterCustomer master (special G/L transaction figures)DDFKNKATRANSPFBMasterCustomer master credit management: Central dataDDFKNKKTRANSPFBMasterCustomer master credit management: Control area dataDDFLFA1TRANSPFBMasterVendor master

30、(general section)KOFLFASTRANSPFBMasterVendor master (VAT registration numbers general section)KOFLFB1TRANSPFBMasterVendor master (company code)KOFLFB5TRANSPFBMasterVendor master (dunning data)KOFLFBKTRANSPFBMasterVendor master (bank details)KOFLFC1TRANSPFBMasterVendor master (transaction figures)KOF

31、LFC3TRANSPFBMasterVendor master (special G/L transaction figures)KOFNBNKTRANSPFBOrganizational Number range for banksNKUKTRANSPFBOrganizational Number range for change documentsPAYRTRANSPFBZTransactionPayment transfer medium filePCECTRANSPFBZOrganizational Prenumbered ChecksREGUATRANSPFBZTransaction

32、Change of payment proposals: user and timeREGUHTRANSPFBZTransactionSettlement data from payment programPYFREGUPCLUSTER FBZTransactionProcessed items from payment programPYFREGUSTRANSPFBZTransactionAcounts blocked by payment proposalREGUVTRANSPFBZTransactionControl records for the payment programSKA1

33、TRANSPFBMasterG/L accounts master (chart of accounts)SKATTRANSPFBMasterG/L account master record (chart of accounts: description)SKB1TRANSPFBMasterG/L account master (company code)T001TRANSPFBOrganizational Company CodesT001BTRANSPFBOrganizational Posting periods allowedT005TRANSPFBOrganizational Co

34、untriesT005TTRANSPFBOrganizational Country namesT012POOLFBOrganizational House banksT012TPOOLFBOrganizational House bank account namesTBSLPOOLFBOrganizational Posting keys451cc44acb9c11f90906678cb4db3141.xlsFI Tables, Page 6TBSLTPOOLFBOrganizational Posting key namesTCURCTRANSPFBOrganizational Curre

35、ncy codesTCURFTRANSPFBOrganizational Conversion FactorsTCURRTRANSPFBOrganizational Currency exchange ratesTCURTTRANSPFBOrganizational Currency code namesTCURVTRANSPFBOrganizational Exchange rate types for currency translationTCURWTRANSPFBOrganizational Exchange rate type usageTGSBTRANSPFBOrganizatio

36、nal Business AreasTGSBTTRANSPFBOrganizational Business area names451cc44acb9c11f90906678cb4db3141.xlsPP Tables, Page 7TableTableTypeApplicationClassDataClassShort textLogicalDatabase/s NotesAFFLTRANSPCOTransactionWork order sequenceAFFTTRANSPCPTransactionOrder process instructionsAFFVTRANSPCPTransac

37、tionOrder process instruction valuesAFKOTRANSPCOTransactionOrder header data PP ordersAFPOTRANSPCOTransactionOrder itemAFRUTRANSPCOTransactionOrder completion confirmationsCKHSTRANSPCKTransactionHeader - Unit costing (control + totals)CKHTTRANSPCKTransactionTexts for CKHSCKIPTRANSPCKTransactionUnit

38、Costing: Period Costs Line ItemCKISTRANSPCKTransactionUnit Costing: Items / Product Costing: ItemizationCKITTRANSPCKTransactionTexts for CKISCOERTRANSPCNTransactionSales Order Value RevenueCRCATRANSPCPMasterWork Center Capacity AllocationCRCOTRANSPCPMasterAssignment of Work Center to Cost CenterCRHD

39、TRANSPCPMasterWork Center HeaderCRTXTRANSPCPMasterText for the Work Center or Production Resource/ToolDOSTTRANSPCSMasterDocument to BOM LinkEQSTTRANSPCSMasterEquipment to BOM LinkKAKOTRANSPCPMasterCapacity Header SegmentKAKTTRANSPCPMasterCapacity DescriptionKBEDTRANSPCYTransactionCapacity requiremen

40、ts recordsKEKOTRANSPCKTransactionProduct Costing - HeaderKEPHTRANSPCKTransactionProduct Costing: Cost Components for Cost of Goods Manuf.MASTTRANSPCSMasterMaterial to BOM LinkSTASTRANSPCSMasterBOMs - Item SelectionSTKOTRANSPCSMasterBOM HeaderSTPOTRANSPCSMasterBOM ItemSTPUTRANSPCSMasterBOM Sub-ItemST

41、ZUTRANSPCSMasterPermanent BOM dataKDSTTRANSPMasterSales Order to BOM LinkSTSTTRANSPMasterStandard BOM linkTPSTTRANSPMasterFunctional Location - BOM Link451cc44acb9c11f90906678cb4db3141.xlsSD Tables, Page 8TableTableTypeApplicationClassDataClassDescriptionLogicalDatabase/sNotesAxxxCondition key Table

42、sKNMTTRANSPVAMasterCustomer-Material Info Record Data TableKNMTKTRANSPVAMasterCustomer-Material Info Record Header TableKNVATRANSPVVMasterCustomer Master Loading PointsKNVDTRANSPVDMasterCustomer master record sales request formKNVITRANSPVFMasterCustomer Master Tax IndicatorKNVKTRANSPVPMasterCustomer

43、 Master Contact PartnerKNVLTRANSPVFMasterCustomer Master LicensesKNVPTRANSPVPMasterCustomer Master Partner FunctionsKNVSTRANSPVVMasterCustomer Master Shipping DataKNVTTRANSPVTMasterCustomer Master Record Texts for SalesKNVVTRANSPVMasterCustomer Master Sales DataKONATRANSPVFMasterRebate AgreementsKON

44、DTRANSPVFMasterConditions (Data)KONHTRANSPVFMasterConditions (Header)KONMTRANSPVFMasterConditions (1 Dimensional Quantity Scales)KONPTRANSPVFMasterConditions (Item)KONVCLUSTER VFMasterConditions (Procedure Data)KONWTRANSPVFMasterConditions (1 Dimensional Value Scales)LIKPTRANSPVLTransactionSD Docume

45、nt: Delivery Header DataVLVfield LIKP-WADAT_IST -Actual Goods Issue Date - ispopulated only after PostGoods IssueLIPSTRANSPVLTransactionSD document: Delivery: Item dataVLVNACHTRANSPVNTransactionDetailed output dataNASTTRANSPVNTransactionMessage statusVAKGUTRANSPVINDSales Index: Quotation Validityind

46、ex tableVAKPATRANSPVINDSales Index: Orders by Partner Functionindex tableVAPMATRANSPVINDSales Index: Order Items by Materialindex tableVBAGTRANSPVATransactionSales Document: Release Data by Schedule Line in Sch.Agrmt.VBAKTRANSPVATransactionSales Document: Header DataVBAPTRANSPVATransactionSales Docu

47、ment: Item DataVBBETRANSPVTransactionSales Requirements: Individual RecordsVBBSTRANSPVTransactionSales Requirement Totals Record451cc44acb9c11f90906678cb4db3141.xlsSD Tables, Page 9VBEPTRANSPVATransactionSales Document: Schedule Line DataVBFACLUSTER VATransactionSales Document FlowAKVVLVVBFSTRANSPVT

48、ransactionError Log for Collective ProcessingVBKATRANSPVCKTransactionSales activitiesAKVVBKDTRANSPVATransactionSales Document: Business DataVBKOFTRANSPVINDSD index: Open sales activities by partner functionindex tableVBKPATRANSPVINDSD index: Sales activities by partner functionindex tableVBLKTRANSPV

49、LTransactionSD Document: Delivery Note HeaderVBLSTRANSPVLTransactionDelivery Notes for Collective ProcessingVBPATRANSPVPTransactionSales Document: PartnerVLVVBRKTRANSPVFTransactionBilling: Header DataVBRPTRANSPVFTransactionBilling: Item DataVBSKTRANSPVTransactionCollective Processing for a Sales Doc

50、ument HeaderVBSSTRANSPVTransactionCollective Processing: Sales DocumentsVBUKTRANSPVTransactionSales Document: Header Status and Administrative DataAKVVLVVBUPTRANSPVTransactionSales Document: Item StatusVLVVBUVCLUSTER VTransactionSales Document: Incompletion LogAKVVEPVGTRANSPVINDDelivery Due Indexind

51、ex tableVETVGTRANSPVINDDelivery Due Index for Stock Transferindex tableVKAOFTRANSPVINDSales Index: Open Sales Activitiesindex tableVKDFSTRANSPVINDSD Index: Billing Initiatorindex tableVLKPATRANSPVINDSD Index: Deliveries by Partner Functionsindex tableVLPMATRANSPVINDSD Index: Delivery Items by Materi

52、alindex tableVRKPATRANSPVINDSales Index: Bills by Partner Functionsindex tableVRPMATRANSPVINDSD Index: Billing Items per Materialindex tableVTFATRANSPVATransactionShipment Document FlowVTRDITRANSPVINDShipment Planning Indexindex tableT179TRANSPVS OrganizationalMaterials: Product HeirarchiesT179TTRAN

53、SPVTOrganizationalMaterials: Product Heirarchies: TextsChina Calendar02TableTableTypeApp.ClassDataClassDescriptionLogicalDatabase/sTCALSTFACDTFACSTFACTTFAINTFAITTHOCTHOCDTHOCITHOCSTHOCTTHOLTHOLTTHOLUNotes451cc44acb9c11f90906678cb4db3141.xlsOthers, Page 12TableTableTypeApp.ClassDataClassDescriptionLogicalDatabase/s NotesEDID2CLUSTER Transaction Data Segment (IDOC) from 3.0CEDI tableTo get segment data, EDI-SDATA should bestored to the proper segment structureEDIDCTRANSPTransaction Control Record (EDI Intermediat