sap r3 all table-所有的数据库表结构

1、ECCSSAP COMMON USED TABLES1-14TableTableTypeApplicationClassDataClassDescriptionLogicalDatabase/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)602f

9、726cf48ad77c731e240de351936a.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 texts602f726cf48ad77c731e240d

16、e351936a.xlsCO Tables, Page 3CSSKTRANSPKSSMasterCost center /cost elementCSSLTRANSPKSSMasterCost center / activity602f726cf48ad77c731e240de351936a.xlsFI Tables, Page 4TableTableTypeApplicationClassDataClassDescriptionLogicalDatabase/sNotesBKPFTRANSPFBTransactionAccounting document headerBNKATRANSPFB

17、MasterBank master recordBSADTRANSPFBTransactionAccounting: Secondary index for customers (cleared items)BSAKTRANSPFBTransactionAccounting: Secondary index for vendors (cleared items)BSASTRANSPFBTransactionAccounting: Secondary index for G/L accounts (cleared items)BSECCLUSTER FBTransactionOne-time a

18、ccount 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 segmentBSIDTRANSPFBTransactionAccounting: Secondary index for customersBSIKTRAN

19、SPFBTransactionAccounting: Secondary index for vendorsBSISTRANSPFBTransactionAccounting: Secondary index for G/L accountsGLT0TRANSPFGTransactionG/L Account Master Record Monthly Debits and CreditsKNA1TRANSPFBMasterGeneral Data in Customer MasterDDFKNASTRANSPFBMasterCustomer master (VAT registration

20、numbers general section)DDFKNB1TRANSPFBMasterCustomer master (company code)DDFKNB4TRANSPFBMasterCustomer payment historyDDFKNB5TRANSPFBMasterCustomer master (dunning data)DDFKNBKTRANSPFBMasterCustomer master (bank details)DDFKNC1TRANSPFBMasterCustomer master (transaction figures)DDFKNC3TRANSPFBMaste

21、rCustomer master (special G/L transaction figures)DDFKNKATRANSPFBMasterCustomer master credit management: Central dataDDFKNKKTRANSPFBMasterCustomer master credit management: Control area dataDDFLFA1TRANSPFBMasterVendor master (general section)KOFLFASTRANSPFBMasterVendor master (VAT registration numb

22、ers general section)KOFLFB1TRANSPFBMasterVendor master (company code)KOFLFB5TRANSPFBMasterVendor master (dunning data)KOFLFBKTRANSPFBMasterVendor master (bank details)KOFLFC1TRANSPFBMasterVendor master (transaction figures)KOFLFC3TRANSPFBMasterVendor master (special G/L transaction figures)KOFNBNKTR

23、ANSPFBOrganizational Number range for banksNKUKTRANSPFBOrganizational Number range for change documentsPAYRTRANSPFBZTransactionPayment transfer medium filePCECTRANSPFBZOrganizational Prenumbered ChecksREGUATRANSPFBZTransactionChange of payment proposals: user and timeREGUHTRANSPFBZTransactionSettlem

24、ent data from payment programPYFREGUPCLUSTER FBZTransactionProcessed items from payment programPYFREGUSTRANSPFBZTransactionAcounts blocked by payment proposalREGUVTRANSPFBZTransactionControl records for the payment programSKA1TRANSPFBMasterG/L accounts master (chart of accounts)SKATTRANSPFBMasterG/L

25、 account master record (chart of accounts: description)SKB1TRANSPFBMasterG/L account master (company code)T001TRANSPFBOrganizational Company CodesT001BTRANSPFBOrganizational Posting periods allowedT005TRANSPFBOrganizational CountriesT005TTRANSPFBOrganizational Country namesT012POOLFBOrganizational H

26、ouse banks602f726cf48ad77c731e240de351936a.xlsFI Tables, Page 5T012TPOOLFBOrganizational House bank account namesTBSLPOOLFBOrganizational Posting keysTBSLTPOOLFBOrganizational Posting key namesTCURCTRANSPFBOrganizational Currency codesTCURFTRANSPFBOrganizational Conversion FactorsTCURRTRANSPFBOrgani

27、zational Currency exchange ratesTCURTTRANSPFBOrganizational Currency code namesTCURVTRANSPFBOrganizational Exchange rate types for currency translationTCURWTRANSPFBOrganizational Exchange rate type usageTGSBTRANSPFBOrganizational Business AreasTGSBTTRANSPFBOrganizational Business area names602f726cf

28、48ad77c731e240de351936a.xlsMM Tables, Page 6TableTableClassApplicationClassDataClassDescriptionLogicalDatabase/s NotesEBANTRANSPMETransactionPurchase RequisitionEBMEBKNTRANSPMETransactionPurchase Requisition Account AssignmentEBMEBUBTRANSPMETransactionIndex for Stock Transport Requisitions for Mater

29、ialEINATRANSPMETransactionPurchasing Info Record - General DataIFMEINETRANSPMETransactionPurchasing Info Record - Purchasing Organization DataIFMEIPATRANSPMETransactionOrder Price History, Info RecordIFMEKABTRANSPMETransactionRelease DocumentationEKANTRANSPMETransactionVendor Address: Purchasing Doc

30、umentEKBETRANSPMETransactionHistory of Purchasing DocumentEBMEKBZTRANSPMETransactionHistory of Purchasing Document - Delivery CostsEKETTRANSPMETransactionDelivery SchedulesEBMEKKNTRANSPMETransactionAccount Assignment in Purchasing DocumentEBMEKKOTRANSPMETransactionPurchasing Document HeaderEBMEKPBTR

31、ANSPMETransactionMaterial Provided Item in Purchasing DocumentEKPOTRANSPMETransactionPurchasing Document ItemEBMEKUBTRANSPMETransactionIndex for Stock Transport Orders for MaterialESKNTRANSPMETransactionAccount Assignment in Service PackageLFM1TRANSPMETransactionVendor master record purchasing organ

32、ization dataMAKTTRANSPMGMasterMaterial DescriptionsMAPRTRANSPMGMasterMaterial Index for ForecastPointer for forecast dataMARATRANSPMGMasterMaterial Master: General DataMSMMARCTRANSPMGMasterMaterial Master: C SegmentMSMMARDTRANSPMGMasterMaterial Master: Storage Location/Batch SegmentMSMMARMTRANSPMGMa

33、sterUnits of MeasureMSMMARVTRANSPMGMasterMaterial Control RecordMBEWTRANSPMGMasterMaterial ValuationMSMMBPRTRANSPMGMasterStock at Production Storage BinMCHATRANSPMGMasterBatchesMCHBTRANSPMGMasterBatch StocksMSMMLANTRANSPMGMasterTax Classification: MaterialSales Data (for each country)MLGNTRANSPMGMas

34、terMaterial Data per Warehouse NumberMSMWarehouse management inventory dataMLGTTRANSPMGMasterMaterial Data per Storage TypeMSMWarehouse management inventory typedataMSTATRANSPMGMasterMaterial Master StatusMVERTRANSPMGMasterMaterial consumptionMVKETRANSPMGMasterMaterial Master: Sales DataMSMSales Dat

35、a (for each Sales Org andDistribution Channel)T001LTRANSPMGOrganizational Storage LocationsT001WTRANSPMGOrganizational Plants/BranchesMKPFTRANSPMBTransactionHeader: Material DocumentLMMMSEGTRANSPMBTransactionDocument Segment: MaterialLMMIKPFTRANSPMBTransactionHeader: Physical Inventory DocumentINMIS

36、EGTRANSPMBTransactionPhysical Inventory Document ItemsINM602f726cf48ad77c731e240de351936a.xlsMM Tables, Page 7S068廠商統計602f726cf48ad77c731e240de351936a.xlsPP Tables, Page 8TableTableTypeApplicationClassDataClassShort textLogicalDatabase/s NotesAFFLTRANSPCOTransactionWork order sequenceAFFTTRANSPCPTra

37、nsactionOrder process instructionsAFFVTRANSPCPTransactionOrder process instruction valuesAFKOTRANSPCOTransactionOrder header data PP ordersAFPOTRANSPCOTransactionOrder itemAFRUTRANSPCOTransactionOrder completion confirmationsCKHSTRANSPCKTransactionHeader - Unit costing (control + totals)CKHTTRANSPCK

38、TransactionTexts for CKHSCKIPTRANSPCKTransactionUnit Costing: Period Costs Line ItemCKISTRANSPCKTransactionUnit Costing: Items / Product Costing: ItemizationCKITTRANSPCKTransactionTexts for CKISCOERTRANSPCNTransactionSales Order Value RevenueCRCATRANSPCPMasterWork Center Capacity AllocationCRCOTRANS

39、PCPMasterAssignment of Work Center to Cost CenterCRHDTRANSPCPMasterWork Center HeaderCRTXTRANSPCPMasterText for the Work Center or Production Resource/ToolDOSTTRANSPCSMasterDocument to BOM LinkEQSTTRANSPCSMasterEquipment to BOM LinkKAKOTRANSPCPMasterCapacity Header SegmentKAKTTRANSPCPMasterCapacity

40、DescriptionKBEDTRANSPCYTransactionCapacity requirements recordsKEKOTRANSPCKTransactionProduct Costing - HeaderKEPHTRANSPCKTransactionProduct Costing: Cost Components for Cost of Goods Manuf.MASTTRANSPCSMasterMaterial to BOM LinkSTASTRANSPCSMasterBOMs - Item SelectionSTKOTRANSPCSMasterBOM HeaderSTPOT

41、RANSPCSMasterBOM ItemSTPUTRANSPCSMasterBOM Sub-ItemSTZUTRANSPCSMasterPermanent BOM dataKDSTTRANSPMasterSales Order to BOM LinkSTSTTRANSPMasterStandard BOM linkTPSTTRANSPMasterFunctional Location - BOM Link602f726cf48ad77c731e240de351936a.xlsSD Tables, Page 9TableTableTypeApplicationClassDataClassDes

42、criptionLogicalDatabase/sNotesAxxxCondition key TablesKNMTTRANSPVAMasterCustomer-Material Info Record Data TableKNMTKTRANSPVAMasterCustomer-Material Info Record Header TableKNVATRANSPVVMasterCustomer Master Loading PointsKNVDTRANSPVDMasterCustomer master record sales request formKNVITRANSPVFMasterCu

43、stomer Master Tax IndicatorKNVKTRANSPVPMasterCustomer Master Contact PartnerKNVLTRANSPVFMasterCustomer Master LicensesKNVPTRANSPVPMasterCustomer Master Partner FunctionsKNVSTRANSPVVMasterCustomer Master Shipping DataKNVTTRANSPVTMasterCustomer Master Record Texts for SalesKNVVTRANSPVMasterCustomer Ma

44、ster Sales DataKONATRANSPVFMasterRebate AgreementsKONDTRANSPVFMasterConditions (Data)KONHTRANSPVFMasterConditions (Header)KONMTRANSPVFMasterConditions (1 Dimensional Quantity Scales)KONPTRANSPVFMasterConditions (Item)KONVCLUSTER VFMasterConditions (Procedure Data)KONWTRANSPVFMasterConditions (1 Dime

45、nsional Value Scales)LIKPTRANSPVLTransactionSD Document: Delivery Header DataVLVfield LIKP-WADAT_IST -Actual Goods Issue Date - ispopulated only after PostGoods IssueLIPSTRANSPVLTransactionSD document: Delivery: Item dataVLVNACHTRANSPVNTransactionDetailed output dataNASTTRANSPVNTransactionMessage st

46、atusVAKGUTRANSPVINDSales Index: Quotation Validityindex tableVAKPATRANSPVINDSales Index: Orders by Partner Functionindex tableVAPMATRANSPVINDSales Index: Order Items by Materialindex tableVBAGTRANSPVATransactionSales Document: Release Data by Schedule Line in Sch.Agrmt.VBAKTRANSPVATransactionSales D

47、ocument: Header DataVBAPTRANSPVATransactionSales Document: Item DataVBBETRANSPVTransactionSales Requirements: Individual Records602f726cf48ad77c731e240de351936a.xlsSD Tables, Page 10VBBSTRANSPVTransactionSales Requirement Totals RecordVBEPTRANSPVATransactionSales Document: Schedule Line DataVBFACLUS

48、TER VATransactionSales Document FlowAKVVLVVBFSTRANSPVTransactionError Log for Collective ProcessingVBKATRANSPVCKTransactionSales activitiesAKVVBKDTRANSPVATransactionSales Document: Business DataVBKOFTRANSPVINDSD index: Open sales activities by partner functionindex tableVBKPATRANSPVINDSD index: Sale

49、s activities by partner functionindex tableVBLKTRANSPVLTransactionSD Document: Delivery Note HeaderVBLSTRANSPVLTransactionDelivery Notes for Collective ProcessingVBPATRANSPVPTransactionSales Document: PartnerVLVVBRKTRANSPVFTransactionBilling: Header DataVBRPTRANSPVFTransactionBilling: Item DataVBSKT

50、RANSPVTransactionCollective Processing for a Sales Document HeaderVBSSTRANSPVTransactionCollective Processing: Sales DocumentsVBUKTRANSPVTransactionSales Document: Header Status and Administrative DataAKVVLVVBUPTRANSPVTransactionSales Document: Item StatusVLVVBUVCLUSTER VTransactionSales Document: I

51、ncompletion LogAKVVEPVGTRANSPVINDDelivery Due Indexindex tableVETVGTRANSPVINDDelivery Due Index for Stock Transferindex tableVKAOFTRANSPVINDSales Index: Open Sales Activitiesindex tableVKDFSTRANSPVINDSD Index: Billing Initiatorindex tableVLKPATRANSPVINDSD Index: Deliveries by Partner Functionsindex

52、tableVLPMATRANSPVINDSD Index: Delivery Items by Materialindex tableVRKPATRANSPVINDSales Index: Bills by Partner Functionsindex tableVRPMATRANSPVINDSD Index: Billing Items per Materialindex tableVTFATRANSPVATransactionShipment Document FlowVTRDITRANSPVINDShipment Planning Indexindex tableT179TRANSPVS

53、 OrganizationalMaterials: Product HeirarchiesT179TTRANSPVTOrganizationalMaterials: Product Heirarchies: TextsChina Calendar02TableTableTypeApp.ClassDataClassDescriptionLogicalDatabase/sTCALSTFACDTFACSTFACTTFAINTFAITTHOCTHOCDTHOCITHOCSTHOCTTHOLTHOLTTHOLUNotes602f726cf48ad77c731e240de351936a.xlsOthers, Page 13TableTableTypeApp.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 Inter