SAP最全的系统表.doc

发布时间：2022-06-09 发布人：admin 分类：说明书资料大小：0.14M 资料格式：doc 举报版权申诉

ckppp-3862633-16359647371216940465.doc.pdf-第1页.png

第1页 / 共18页

ckppp-3862633-16359647371216940465.doc.pdf-第2页.png

第2页 / 共18页

ckppp-3862633-16359647371216940465.doc.pdf-第3页.png

第3页 / 共18页

ckppp-3862633-16359647371216940465.doc.pdf-第4页.png

第4页 / 共18页

ckppp-3862633-16359647371216940465.doc.pdf-第5页.png

第5页 / 共18页

ckppp-3862633-16359647371216940465.doc.pdf-第6页.png

第6页 / 共18页

ckppp-3862633-16359647371216940465.doc.pdf-第7页.png

第7页 / 共18页

ckppp-3862633-16359647371216940465.doc.pdf-第8页.png

第8页 / 共18页

1Customising

1.1General settings

1.1.1Countries

1.1.2Currency

1.1.3Unit of measure

1.1.4Calendar functions

1.2Enterprise structure

1.2.1Definition

1.2.2Assignment

1.3Financial accounting

1.3.1Company code

1.3.2Fi document

1.4Not categorized

2Basic data / administration

2.1Workbench related tables

2.1.1Data dictionary tables

2.1.2Workbench

2.2Administration

2.2.1User administration

2.2.2Batch input queue

2.2.3Job processing

2.2.4Spool

2.2.5Runtime errors

2.2.6Message control

2.2.7EDI

2.2.8Change documents

2.2.9Reporting tree table

2.2.10LIS structure/control tables

3MASTER DATA :

3.1Material master :

3.1.1Basic data text (sap script)

3.1.2Batches

3.2Customer master data

3.3Vendor

3.4Customer – material info record

3.5Bank data

4Characteristics :

4.1Characteristics :

4.2Class types and objects :

4.3Links :

5FI/CO :

5.1FI :

5.1.1Master data

5.1.2Accounting documents // indices

5.1.3Payment run

5.2CO :

5.2.1Cost center master data

5.2.2Cost center accounting

6Sales and Distribution (SD) :

6.1Sales order :

6.2Billing document :

6.3Shipping :

6.4Delivery :

6.5Pricing :

6.6contracts :

7Material Management (MM) :

7.1Material document

7.2Purchasing

8Warehouse Management (WM) :

8.1Transfer requirement

8.2Transfer order

8.3Master data - stock positions

8.4Inventory documents in WM

9Quality Management (QM) :

9.1Inspection lot / info record

9.2Quality notification

9.3Certificate profile

10Production Planning (PP)

10.1Work center

10.2Routings/operations

10.3Bill of material

10.4Production orders

10.5Planned orders

10.6KANBAN

10.7Reservations

10.8Capacity planning

10.9Planned independent requirements

11Project system (PS)

11.1Basic data

11.2Equipment

12Plant maintenance (PM)

12.1Human resources

12.2Settings

12.3Master data

12.4Infotypes

BC – Tables in SAP TABLES IN SAP 1 1.1 1.2 1.3 1.4 2 2.1 2.2 2.1.1 2.1.2 1.1.1 1.1.2 1.1.3 1.1.4 1.2.1 1.2.2 1.3.1 1.3.2 2.2.1 2.2.2 2.2.3 2.2.4 2.2.5 2.2.6 2.2.7 2.2.8 2.2.9 2.2.10 CUSTOMISING .............................................................................................................................. 3 GENERAL SETTINGS....................................................................................................................3 Countries........................................................................................................................... 3 Currency............................................................................................................................3 Unit of measure................................................................................................................. 3 Calendar functions............................................................................................................ 3 ENTERPRISE STRUCTURE............................................................................................................3 Definition...........................................................................................................................3 Assignment .........................................................................................................................3 FINANCIAL ACCOUNTING ........................................................................................................... 4 Company code................................................................................................................... 4 Fi document.......................................................................................................................4 NOT CATEGORIZED.....................................................................................................................4 BASIC DATA / ADMINISTRATION...........................................................................................5 WORKBENCH RELATED TABLES................................................................................................. 5 Data dictionary tables....................................................................................................... 5 Workbench.........................................................................................................................5 ADMINISTRATION.......................................................................................................................5 User administration ...........................................................................................................5 Batch input queue ..............................................................................................................5 Job processing................................................................................................................... 5 Spool..................................................................................................................................5 Runtime errors ...................................................................................................................6 Message control.................................................................................................................6 EDI.................................................................................................................................... 6 Change documents.............................................................................................................6 Reporting tree table...........................................................................................................6 LIS structure/control tables...............................................................................................6 3 MASTER DATA :........................................................................................................................... 7 3.1 MATERIAL MASTER :..................................................................................................................7 Basic data text (sap script) ..............................................................错误！未定义书签。 Batches.............................................................................................................................. 7 CUSTOMER MASTER DATA......................................................................................................... 7 VENDOR..................................................................................................................................... 7 CUSTOMER – MATERIAL INFO RECORD...................................................................................... 8 BANK DATA................................................................................................................................8 CHARACTERISTICS :.................................................................................................................9 CHARACTERISTICS :................................................................................................................... 9 CLASS TYPES AND OBJECTS :..................................................................................................... 9 LINKS :....................................................................................................................................... 9 FI/CO :...........................................................................................................................................10 FI :........................................................................................................................................... 10 Master data......................................................................................................................10 Accounting documents // indices..................................................................................... 10 Payment run.....................................................................................................................10 CO :......................................................................................................................................... 10 Cost center master data...................................................................................................10 Cost center accounting....................................................................................................10 SALES AND DISTRIBUTION (SD) :......................................................................................... 11 SALES ORDER :.........................................................................................................................11 BILLING DOCUMENT :...............................................................................................................11 3.2 3.3 3.4 3.5 4 4.1 4.2 4.3 5 5.1 5.1.1 5.1.2 5.1.3 5.2.1 5.2.2 6 6.1 6.2 3.1.1 3.1.2 5.2 sap_tab_1.doc Page 1 6/9/221

BC – Tables in SAP SHIPPING :................................................................................................................................ 11 6.3 DELIVERY :.............................................................................................................................. 11 6.4 6.5 PRICING :..................................................................................................................................11 7 MATERIAL MANAGEMENT (MM) :...................................................................................... 12 7.1 MATERIAL DOCUMENT.............................................................................................................12 7.2 PURCHASING............................................................................................................................ 12 8 WAREHOUSE MANAGEMENT (WM) :..................................................................................13 8.1 TRANSFER REQUIREMENT........................................................................................................ 13 TRANSFER ORDER.................................................................................................................... 13 8.2 MASTER DATA - STOCK POSITIONS.......................................................................................... 13 8.3 8.4 INVENTORY DOCUMENTS IN WM.............................................................................................13 9 QUALITY MANAGEMENT (QM) :.......................................................................................... 14 INSPECTION LOT / INFO RECORD.............................................................................................. 14 9.1 QUALITY NOTIFICATION...........................................................................................................14 9.2 CERTIFICATE PROFILE .............................................................................................................. 14 9.3 10 PRODUCTION PLANNING (PP)...........................................................................................15 WORK CENTER......................................................................................................................... 15 10.1 ROUTINGS/OPERATIONS........................................................................................................... 15 10.2 10.3 BILL OF MATERIAL...................................................................................................................15 PRODUCTION ORDERS.............................................................................................................. 15 10.4 PLANNED ORDERS.................................................................................................................... 16 10.5 KANBAN................................................................................................................................16 10.6 RESERVATIONS.........................................................................................................................16 10.7 10.8 CAPACITY PLANNING ............................................................................................................... 16 PLANNED INDEPENDENT REQUIREMENTS.................................................................................16 10.9 EQUIPMENT.......................................................................................... 错误！未定义书签。 10.10 11 PROJECT SYSTEM (PS).........................................................................................................17 BASIC DATA............................................................................................................................. 17 11.1 12 PLANT MAINTENANCE (PM)..............................................................................................17 13 13.1 13.2 13.3 HUMAN RESOURCES ............................................................................................................ 18 SETTINGS..................................................................................................................................18 MASTER DATA..........................................................................................................................18 INFOTYPES................................................................................................................................18 sap_tab_1.doc Page 2 6/9/222

BC – Tables in SAP 1 Customising 1.1 General settings 1.1.1 Countries T005 1.1.2 Currency TCURC TCURR TCURT TCURX Countries Currency codes Wisselkoersen Currency name Decimal places for currencies. 1.1.3 Unit of measure T006 Units of measure 1.1.4 Calendar functions T247 TFACD T015M TTZZ TTZD TTZDF TTZDV TTZDT TTZ5 TTZ5S Month names Factory calendar definition Month names Time zones Summer time rules Summer time rules (fixed annual dates) Summer time rules (variable dates) Summer time rules texts Assign Time Tones to Countries Assign time zones to regions 1.2 Enterprise structure 1.2.1 Definition FI T880 T001 CO TKA01 LO T001W T499S TSPA SD TVKO TVTW TVBUR TVKBT TVKGR TVGRT T171T MM T001L T024E T3001 TVST TVLA TTDS Company Company code Controlling area Plant / sales organisation Locations Division Sales organisation / company code Distribution channel Sales office Sales office text Sales group Sales group text Sales district text Storage locations Purchasing organization Warehouse number Shipping point Loading point Transportation 1.2.2 Assignment CO TKA02 LO T001K Assign company code to controlling area Assign plant (valuation area) to company code sap_tab_1.doc Page 3 6/9/223

BC – Tables in SAP SD TVKO TVKOV TVKOS TVTA TVKBZ TVBVK TVKWZ MM T024E T024W T001K TVSWZ T320 Sales organisation / company code Distribution channel / sales organisation Division to sales organization Sales aria Sales office to sales area Sales group to sales office Plants to sales organization Purchasing organization / company code Plant to Purchase organization Link plant ( = valuation area) / company code Shipping point to plant Assignment MM Storage Location to WM Warehouse 1.3 Financial accounting 1.3.1 Company code T004 T077S T009 T880 T014 1.3.2 Fi document T010O T010P T001B T003 T012 1.4 Not categorized Chart of accounts Account group (g/l accounts) Fiscal year variants Global company data Credit control area Posting period variant Posting Period Variant Names Permitted Posting Periods Document types House banks T007a T134 T179 T179T TJ02T TINC TVFK T390 Tax keys Material types Materials: Product Hierarchies Materials: Product hierarchies: Texts Status text Customer incoterms Billing doc types PM: Shop papers for print control sap_tab_1.doc Page 4 6/9/224

BC – Tables in SAP 2 Basic data / administration 2.1 Workbench related tables 2.1.1 Data dictionary tables DD02L DD02T DD03L DD03T Tables in SAP Tables description Field names in SAP Field description in SAP 2.1.2 Workbench TADIR TRDIR TFDIR TLIBG TLIBT TFTIT TSTC TSTCT T100 VARID D020T TDEVC TDEVCT Directory of R/3 Repository Objects System table TRDIR Function Module Person responsible for function class Function Group Short Texts Function Module Short Text Transaction codes in SAP Transaction codes texts Message text (vb e000) Variant data Screen texts Development class Texts for development classes 2.2 Administration 2.2.1 User administration USR01 USR02 USR03 USR04 USR11 UST12 USR12 USR13 USR40 TOBJ TOBC TPRPROF DEVACCESS User master Logon data User address data User master authorizations User Master Texts for Profiles (USR10) User master: Authorizations User master authorization values Short Texts for Authorizations Prohibited passwords Objects Authorization Object Classes Profile Name for Activity Group Table for development user 2.2.2 Batch input queue APQD APQI DATA DEFINITION Queue Queue info definition 2.2.3 Job processing TBTCO TBTCP 2.2.4 Spool TSP02 Job status overview table Batch job step overview Spool: Print requests sap_tab_1.doc Page 5 6/9/225

BC – Tables in SAP 2.2.5 Runtime errors SNAP Runtime errors 2.2.6 Message control TNAPR NAST NACH 2.2.7 EDI Processing programs for output Message status Printer determination EDIDC EDIDD EDID2 EDIDS EDPAR EDPVW EDPI1 EDPO1/2/3 Control record Data record Data record 3.0 Version EDI status record Convert External < > Internal Partner Number EDI partner types EDI partner profile inbound EDI partner profile outbound 2.2.8 Change documents CDHDR CDPOS JCDS Change document header Change document positionen Change Documents for System/User Statuses (Table JEST) 2.2.9 Reporting tree table SERPTREE Reporting: tree structure 2.2.10 LIS structure/control tables TMC4 Global Control Elements: LIS Info Structure sap_tab_1.doc Page 6 6/9/226

BC – Tables in SAP 按照工厂来划分物料有销售数据的 3 MASTER DATA : 3.1 Material master : MARA MAKT MARC MVKE MARD MSKA MSPR MARM MEAN PGMI PROP MAPR MBEW MVER MLGN MLGT MPRP MDTB MDKP MLAN MTQSS Material master 物料主数据 Material text 存放物料名字的 Material per plant / stock Material master, sales data Storage location / stock Sales order stock Project stock Units of measure International article number Planning material Forecast parameters Link MARC <=> PROP Material valuation Material consumption Material / Warehouse number Material / Storage type Forecast profiles MRP table Header data for MRP document Tax data material master Material master view: QM 3.1.1 Basic data text (sap script) STXB STXH STXL 3.1.2 Batches MCHA MCH1 MCHB SAPscript: Texts in non-SAPscript format STXD SAPscript text file header STXD SAPscript text file lines Batches Batches Stock : batches 3.2 Customer master data KNA1 KNB1 KNVV KNBK KNVH KNVP KNVS KNVK KNVI 3.3 Vendor LFA1 LFB1 LFB5 LFM1 LFM2 LFBK 客户主数据 Customer master Customer / company Customer sales data Bank details Customer hierarchy Customer partners Shipment data for customer Contact persons Customer master tax indicator Vendor master 供应商主数据 Vendor per company code Vendor dunning data Purchasing organisation data Purchasing data Bank details sap_tab_1.doc Page 7 6/9/227

BC – Tables in SAP 3.4 Customer – material info record KNMT Customer material info record 3.5 Bank data BNKA Master bank data sap_tab_1.doc Page 8 6/9/228

分享到：

赞收藏

资料库

SAP最全的系统表.doc

相关推荐

课程资源

热门标签

最新资料