total tables in sap 17apr2008(2)
TRANSCRIPT
-
8/2/2019 Total Tables in SAP 17Apr2008(2)
1/25
-
8/2/2019 Total Tables in SAP 17Apr2008(2)
2/25
2.2.8 Change documents.......................................................................................................................52.2.9 Reporting tree table......................................................................................................................62.2.10 LIS structure/control tables........................................................................................................63 MASTER DATA :.................................................................................................................................6
3.1 MATERIAL MASTER :................................................................................................................................63.1.1 Basic data text (sap script)...........................................................................................................63.1.2 Batches .......................................................................................................................................63.2 CUSTOMER MASTER DATA...........................................................................................................................63.3 VENDOR.................................................................................................................................................73.4 CUSTOMER MATERIAL INFO RECORD..........................................................................................................73.5 BANK DATA............................................................................................................................................7
4 CHARACTERISTICS :......................................................................................................................7
4.1 CHARACTERISTICS :..................................................................................................................................74.2 CLASS TYPES AND OBJECTS :......................................................................................................................74.3 LINKS :..................................................................................................................................................75 FI/CO :.................................................................................................................................................7
5.1 FI :.......................................................................................................................................................7
5.1.1 Master data..................................................................................................................................75.1.2 Accounting documents // indices..................................................................................................75.1.3 Payment run.................................................................................................................................85.2 CO :.....................................................................................................................................................85.2.1 Cost center master data...................................................
.............................................................85.2.2 Cost center accounting....................................................
.............................................................86 SALES AND DISTRIBUTION (SD) :.................................................................................................8
6.1 SALES ORDER :........................................................................................................................................86.2 BILLING DOCUMENT :..........................................................
-
8/2/2019 Total Tables in SAP 17Apr2008(2)
3/25
.....................................................................8456873.doc Page 1 09/02/2008 1
-
8/2/2019 Total Tables in SAP 17Apr2008(2)
4/25
BC Tables in SAP
6.3 SHIPPING :..............................................................................................................................................86.4 DELIVERY :............................................................................................................................................86.5 PRICING :...............................................................................................................................................96.6 CONTRACTS :...........................................................................................................................................97 MATERIAL MANAGEMENT (MM) :..............................................................................................9
7.1 MATERIAL DOCUMENT..............................................................................................................................97.2 PURCHASING...........................................................................................................................................98 WAREHOUSE MANAGEMENT (WM) :..........................................................................................9
8.1 TRANSFER REQUIREMENT........................................................
..................................................................98.2 TRANSFER ORDER..............................................................
......................................................................98.3 MASTER DATA -STOCKPOSITIONS...............................................................................................................98.4 INVENTORY DOCUMENTS IN WM................................................................................................................99 QUALITY MANAGEMENT (QM) : ...............................................................................................10
9.1 INSPECTION LOT / INFO RECORD.................................................................................................................10
9.2 QUALITY NOTIFICATION...........................................................................................................................109.3 CERTIFICATE PROFILE..............................................................................................................................1010 PRODUCTION PLANNING (PP)..................................................................................................10
10.1 WORK CENTER....................................................................................................................................1010.2 ROUTINGS/OPERATIONS.........................................................................................................................1010.3 BILL OF MATERIAL...........................................................
....................................................................1010.4 PRODUCTION ORDERS..........................................................
..................................................................1110.5 PLANNED ORDERS................................................................................................................................1110.6 KANBAN........................................................................................................................................1110.7 RESERVATIONS.....................................................................................................................................1110.8 CAPACITY PLANNING..........................................................
-
8/2/2019 Total Tables in SAP 17Apr2008(2)
5/25
-
8/2/2019 Total Tables in SAP 17Apr2008(2)
6/25
BC Tables in SAP
1Customising
1.1 General settings1.1.1 CountriesT005Countries
1.1.2 CurrencyTCURC Currency codesTCURR Wisselkoersen
TCURTCurrency name
TCURXDecimal places for currencies.
1.1.3 Unit of measureT006
Units of measure1.1.4 Calendar functionsT247 Month namesTFACD Factory calendar definitionT015M Month namesTTZZ Time zonesTTZD Summer time rulesTTZDF Summer time rules (fixed annual dates)TTZDV Summer time rules (variable dates)TTZDT Summer time rules textsTTZ5 Assign Time Tones to CountriesTTZ5S Assign time zones to regions
1.2 Enterprise structure1.2.1 DefinitionFIT880 Company
T001 Company codeCO TKA01 Controlling areaLO T001W Plant / sales organisation
T499S Locations
TSPA Division
SDTVKO Sales organisation / company codeTVTW Distribution channelTVBUR Sales office
TVKBT
-
8/2/2019 Total Tables in SAP 17Apr2008(2)
7/25
Sales office text
TVKGR Sales groupTVGRT Sales group textT171T Sales district text
MMT001L Storage locationsT024E Purchasing organizationT3001 Warehouse numberTVST Shipping pointTVLA Loading pointTTDS Transportation
1.2.2 AssignmentCO TKA02 Assign company code to controlling areaLO T001K Assign plant (valuation area) to company code
456873.docPage 3 09/02/2008 3
-
8/2/2019 Total Tables in SAP 17Apr2008(2)
8/25
BC Tables in SAP
SDTVKO Sales organisation / company codeTVKOV Distribution channel / sales organisationTVKOS Division to sales organizationTVTA Sales ariaTVKBZ Sales office to sales areaTVBVK Sales group to sales officeTVKWZ Plants to sales organization
MMT024E Purchasing organization / company codeT024W Plant to Purchase organizationT001K Link plant ( = valuation area) / company codeTVSWZ Shipping point to plantT320 Assignment MM Storage Location to WMWarehouse
1.3 Financial accounting1.3.1 Company code
T004 Chart of accountsT077S Account group (g/l accounts)T009 Fiscal year variantsT880 Global company dataT014 Credit control area
1.3.2 Fi documentT010O Posting period variantT010P Posting Period Variant NamesT001B Permitted Posting PeriodsT003 Document typesT012 House banks
1.4 Not categorizedT007a Tax keysT134 Material typesT179 Materials: Product HierarchiesT179T Materials: Product hierarchies: TextsTJ02T Status textTINC Customer incotermsTVFK Billing doc typesT390 PM: Shop papers for print control
2Basic data / administration
2.1 Workbench related tables2.1.1 Data dictionary tablesDD02LTables in SAP
DD02T Tables descriptionDD03L Field names in SAP
-
8/2/2019 Total Tables in SAP 17Apr2008(2)
9/25
DD03T Field description in SAP
2.1.2 WorkbenchTADIR Directory of R/3 Repository ObjectsTRDIR System table TRDIRTFDIR Function ModuleTLIBG Person responsible for function classTLIBT Function Group Short TextsTFTIT Function Module Short Text
456873.docPage 4 09/02/2008 4
-
8/2/2019 Total Tables in SAP 17Apr2008(2)
10/25
BC Tables in SAP
TSTC Transaction codes in SAP
TSTCT Transaction codes texts
T100 Message text (vb e000)VARID Variant dataD020T Screen textsTDEVC Development classTDEVCT Texts for development classes
2.2 Administration2.2.1 User administrationUSR01 User masterUSR02 Logon dataUSR03 User address dataUSR04 User master authorizationsUSR11 User Master Texts for Profiles (USR10)UST12 User master: AuthorizationsUSR12 User master authorization values
USR13 Short Texts for AuthorizationsUSR40 Prohibited passwordsTOBJ ObjectsTOBC Authorization Object ClassesTPRPROF Profile Name for Activity GroupDEVACCESS Table for development user
2.2.2 Batch input queueAPQD DATA DEFINITION Queue
APQI Queue info definition
2.2.3 Job processingTBTCO Job status overview tableTBTCP Batch job step overview
2.2.4 SpoolTSP02 Spool: Print requests
2.2.5 Runtime errorsSNAP Runtime errors
2.2.6 Message controlTNAPR Processing programs for output
NAST Message statusNACH Printer determination
2.2.7 EDIEDIDC Control record
EDIDD Data recordEDID2 Data record 3.0 Version
-
8/2/2019 Total Tables in SAP 17Apr2008(2)
11/25
EDIDS EDI status recordEDPAR Convert External < > Internal Partner NumberEDPVW EDI partner typesEDPI1 EDI partner profile inboundEDPO1/2/3 EDI partner profile outbound
2.2.8 Change documentsCDHDR Change document header
456873.doc Page 5 09/02/2008 5
-
8/2/2019 Total Tables in SAP 17Apr2008(2)
12/25
BC Tables in SAP
CDPOS Change document positionenJCDS Change Documents for System/User Statuses (Table JEST)
2.2.9 Reporting tree tableSERPTREE Reporting: tree structure
2.2.10 LIS structure/control tablesTMC4 Global Control Elements: LIS Info Structure
3 MASTER DATA :
3.1 Material master :MARA Material master
MAKT Material textMARC Material per plant / stockMVKE Material master, sales dataMARD Storage location / stockMSKA Sales order stock
MSPR Project stockMARM Units of measureMEAN International article numberPGMI Planning materialPROP Forecast parametersMAPR Link MARC PROPMBEW Material valuationMVER Material consumptionMLGN Material / Warehouse numberMLGT Material / Storage typeMPRP Forecast profilesMDTB MRP tableMDKP Header data for MRP document
MLAN Tax data material masterMTQSS Material master view: QM
3.1.1 Basic data text (sap script)STXB SAPscript: Texts in non-SAPscript format
STXH STXD SAPscript text file header
STXL STXD SAPscript text file lines
3.1.2 BatchesMCHA Batches
MCH1 BatchesMCHB Stock : batches
3.2 Customer master dataKNA1 Customer masterKNB1 Customer / companyKNVV Customer sales dataKNBK Bank details
-
8/2/2019 Total Tables in SAP 17Apr2008(2)
13/25
KNVH Customer hierarchyKNVP Customer partnersKNVS Shipment data for customerKNVK Contact personsKNVI Customer master tax indicator
456873.doc Page 6 09/02/2008 6
-
8/2/2019 Total Tables in SAP 17Apr2008(2)
14/25
BC Tables in SAP
3.3 VendorLFA1 Vendor masterLFB1 Vendor per company codeLFB5 Vendor dunning dataLFM1 Purchasing organisation dataLFM2 Purchasing dataLFBK Bank details
3.4 Customer material info recordKNMT Customer material info record
3.5 Bank dataBNKA Master bank data
4 Characteristics :
4.1 Characteristics :CABN Characteristics ( o.a. batch/vendor)
CABNT Characteristics descriptionCAWN Characteristics ( o.a. material)CAWNT Characteristics descriptionAUSP Characteristic Values
4.2 Class types and objects :TCLAO Several class types for objectTCLA Class types ( vb. lfa1 => v10 en 010)TCLAT Class type textTCLT Classifiable objectsTCLC Classification status
4.3 Links :INOB Link between Internal Number and Object
KLAH Class header data
KSSK Allocation Table: Object (vb.matnr) to ClassKSML Characteristics for a class (internal number)
5 FI/CO :
5.1 FI :5.1.1 Master dataSKA1 Accounts
BNKA Bank master record
5.1.2 Accounting documents // indicesBKPF Accounting documentsBSEG item levelBSID Accounting: Secondary index for customersBSIK Accounting: Secondary index for vendorsBSIM Secondary Index, Documents for MaterialBSIP Index for vendor validation of double documents
-
8/2/2019 Total Tables in SAP 17Apr2008(2)
15/25
-
8/2/2019 Total Tables in SAP 17Apr2008(2)
16/25
BC Tables in SAP
BSAK Accounting: Index for vendors (cleared items)BSAS Accounting: Index for G/L accounts (cleared items)
5.1.3 Payment runREGUH Settlement data from payment programREGUP Processed items from payment program
5.2 CO :TKA01 Controlling areasTKA02 Controlling area assignmentKEKO Product-costing headerKEPH Cost components for cost of goods manuf.KALO Costing objectsKANZ Sales order items - costing objects
5.2.1 Cost center master dataCSKS Cost Center Master DataCSKT Cost center texts
CRCO Assignment of Work Center to Cost Center
5.2.2 Cost center accountingCOSP CO Object: Cost Totals for External PostingsCOEP CO Object: Line Items (by Period). COBK CO Object: Document headerCOST CO Object: Price Totals
6 Sales and Distribution (SD) :
VBFA Document flow (alg.)VTFA Flow shipping documents
6.1 Sales order :VBAK Header dataVBAP Item dataVBPA Partners in sales orderVBKD Sales district dataVBEP Data related to line items, delivery lines
6.2 Billing document :VBRK header dataVBRP Item data
6.3 Shipping :VTTK Shipment headerVTTP Shipment itemVTTS Stage in transportVTSP Stage in transport per shipment itemVTPA Shipment partnersVEKP Handling Unit -Header TableVEPO Packing: Handling Unit Item (Contents)
-
8/2/2019 Total Tables in SAP 17Apr2008(2)
17/25
6.4 Delivery :LIKP Delivery headerLIPS Delivery item
456873.doc Page 8 09/02/2008 8
-
8/2/2019 Total Tables in SAP 17Apr2008(2)
18/25
BC Tables in SAP
6.5 Pricing :KONH Conditions headerKONP Conditions itemsKONV Procedure ( billing doc or sales order)KOND
6.6 contracts :VEDA Contract data
7 Material Management (MM) :
7.1 Material documentMKPF material documentMSEG material document (item level)
7.2 PurchasingEKKO Purchase documentEKPO Purchase document (item level)
EKPV Shipping-Specific Data on Stock Tfr. for Purch. Doc. ItemEKET Delivery scheduleVETVG Delivery Due Index for Stock TransferEKES Order Acceptance/Fulfillment ConfirmationsEKKN Account assignment in purchasingEKAN Vendor address purchasingEKPA Partner functionsEIPO Item export / import dataEINA Purchase info record (main data)EINE Purchase info record (organisational data)EORD Source listEBAN Purchase requisitionEBKN Purchase Requisition Account Assignment
8 Warehouse Management (WM) :
8.1 Transfer requirementLTBK Transfer requirement - headerLTBP Transfer requirement - item
8.2 Transfer orderLTAK Transfer order - headerLTAP Transfer order - item
8.3 Master data - stock positionsLQUA Quants
8.4 Inventory documents in WMLINK Inventory document headerLINP Inventory document itemLINV Inventory data per quant
456873.doc Page 9 09/02/2008 9
-
8/2/2019 Total Tables in SAP 17Apr2008(2)
19/25
-
8/2/2019 Total Tables in SAP 17Apr2008(2)
20/25
BC Tables in SAP
9 Quality Management (QM) :
9.1 Inspection lot / info recordQALS Inspection lot record
QAMB Link inspection lot - material document
QAVE Inspection usage decisionQDPS Inspection stagesQMAT Inspection type -material parametersQINF Inspection info record (vendor - material)QDQL Quality levelQDPS Inspection stages
9.2 Quality notificationTQ80 Notification typesQMEL Quality notificationQMFE Quality notification itemsQMUR Quality notification causes
QMSM Quality notification tasksQMMA Quality notification activitiesQMIH Quality message - maintenance data excerpt
9.3 Certificate profileQCVMT Certificate profile characteristic level: textsQCVM Certificate profile characteristic levelQCVK Certificate profile header
10 Production Planning (PP)
10.1 Work centerCRHH Work center hierarchyCRHS Hierarchy structureCRHD Work center headerCRTX Text for the Work Center or Production
Resource/ToolCRCO Assignment of Work Center to Cost CenterKAKO Capacity Header SegmentCRCA Work Center Capacity AllocationTC24 Person responsible for the workcenter
10.2 Routings/operations
MAPL Allocation of task lists to materialsPLAS Task list - selection of operations/activitiesPLFH Task list - production resources/toolsPLFL Task list - sequencesPLKO Task list - headerPLKZ Task list: main headerPLPH Phases / suboperationsPLPO Task list operation / activityPLPR Log collector for tasklistsPLMZ Allocation of BOM - items to operations
-
8/2/2019 Total Tables in SAP 17Apr2008(2)
21/25
10.3 Bill of materialSTKO BOM - header
456873.doc Page 10 09/02/2008 10
-
8/2/2019 Total Tables in SAP 17Apr2008(2)
22/25
BC Tables in SAP
STPO BOM - itemSTAS BOMs - Item SelectionSTPN BOMs - follow-up controlSTPU BOM - sub-itemSTZU Permanent BOM dataPLMZ Allocation of BOM - items to operationsMAST Material to BOM linkKDST Sales order to BOM link
10.4 Production ordersAUFK Production order headersAFIH Maintenance order headerAUFM Goods movement for prod. orderAFKO Order header data PP ordersAFPO Order itemRESB Order componentenAFVC Order operationsAFVV Quantities/dates/values in the operationAFVU User fields of the operationAFFL Work order sequence
AFFH PRT assignment data for the work order(routing)JSTO Status profileJEST Object statusAFRU Order completion confirmations
PRT s voor production orders
AFFH PRT assignment data for the work orderCRVD_A Link of PRT to DocumentDRAW Document Info RecordTDWA Document TypesTDWD Data Carrier/Network Nodes
TDWE Data Carrier Type10.5 Planned ordersPLAF Planned orders
10.6 KANBANPKPS Kanban identification, control cyclePKHD Kanban control cycle (header data)PKER Error log for Kanban containers
10.7 ReservationsRESB Material reservations
RKPF header
10.8 Capacity planningKBKO Header record for capacity requirementsKBED Capacity requirements recordsKBEZ Add. data for table KBED (for indiv. capacities/splits)
10.9 Planned independent requirementsPBIM Independent requirements for material
-
8/2/2019 Total Tables in SAP 17Apr2008(2)
23/25
PBED Independent requirement data
PBHI Independent requirement history
PBIV Independent requirement index
PBIC Independent requirement index for customer req.
456873.doc Page 11 09/02/2008 11
-
8/2/2019 Total Tables in SAP 17Apr2008(2)
24/25
BC Tables in SAP
11 Project system (PS)
11.1 Basic dataPRHI Work Breakdown Structure, Edges (Hierarchy Pointer)PROJ Project definitionPRPS WBS (Work Breakdown Structure) Element Master Data
RPSCO Project info database: Costs, revenues, financesMSPR Project stock
11.2 EquipmentEQUI Equipment master dataEQKT Equipment short textEQUZ Equipment time segment
12 Plant maintenance (PM)
IHPA Plant Maintenance: PartnersOBJK Plant Maintenance Object List
ILOA PM Object Location and Account AssignmentAFIH Maintenance order headerHuman resources
12.1 SettingsT582A Infotypes: Customer-Specific Settings
12.2 Master dataT527X Organizational UnitsT528T Position TextsT554T Attendance and Absence TextsT501 Employee groupT503 Employee group, subgroup
T503K Employee subgroupT510N Pay Scales for Annual Salaries (NA)T549A Payroll Accounting AreasT750X Vacancy
12.3 InfotypesPA0001 Org. AssignmentPA0002 Personal DataPA0006 AddressesPA0007 Planned Working TimePA0016 Contract elementsPA0008 Basic pay
PA0105 CommunicationsPA1007 VacanciesPA1035 TrainingPA2001 Absences
456873.doc Page 12 09/02/2008 12
-
8/2/2019 Total Tables in SAP 17Apr2008(2)
25/25