二维码

[其他] SAP各模块常用表归纳

Twilight发表于 2015-05-08 10:13zhongguomao 最后回复于 2017-08-03 10:22 [复制链接] 6980 2

  • fi
    1.1.1 Master data
    SKA1 Accounts
    BNKA Bank master record
    1.1.2 Accounting documents // indices
    BKPF Accounting documents
    BSEG item level
    BSID 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 Accounting: Secondary index for G/L accounts
    BSAD Accounting: Index for customers (cleared items)
    BSAK Accounting: Index for vendors (cleared items)
    BSAS Accounting: Index for G/L accounts (cleared items)
    1.1.3 Payment run
    REGUH Settlement data from payment program
    REGUP Processed items from payment program
    固定资产
    ANLA 资产主记录段
    ANLB 折旧条件(折旧范围,折旧码,使用年月等)
    ANLC 资产值字段
    ANLZ 时间相关资产分配
    ANLH 主资产号
    ANEK 凭证抬头资产过帐
    ANEP 资产行项目
    ANEA 用于比例值的资产行项目
    ANKT 资产类型描述
  • hr
    2.1 Settings
    T582A Infotypes: Customer-Specific Settings
    2.2 Master data
    T527X Organizational Units
    T528T Position Texts
    T554T Attendance and Absence Texts
    T501 Employee group
    T503 Employee group, subgroup
    T503K Employee subgroup
    T510N Pay Scales for Annual Salaries (NA)
    T549A Payroll Accounting Areas
    T750X Vacancy
    2.3 Infotypes
    PA0001 Org. Assignment
    PA0002 Personal Data
    PA0006 Addresses
    PA0007 Planned Working Time
    PA0016 Contract elements
    PA0008 Basic pay
    PA0105 Communications
    PA1007 Vacancies
    PA1035 Training
    PA2001 Absences
  • pp
    3.1 Work center
    CRHH Work center hierarchy
    CRHS Hierarchy structure
    CRHD Work center header
    CRTX Text for the Work Center or Production Resource/Tool
    CRCO Assignment of Work Center to Cost Center
    KAKO Capacity Header Segment
    CRCA Work Center Capacity Allocation
    TC24 Person responsible for the workcenter
    3.2 Routings/operations
    MAPL Allocation of task lists to materials
    PLAS Task list - selection of operations/activities
    PLFH Task list - production resources/tools
    PLFL Task list - sequences
    PLKO Task list - header
    PLKZ Task list: main header
    PLPH Phases / suboperations
    PLPO Task list operation / activity
    PLPR Log collector for tasklists
    PLMZ Allocation of BOM - items to operations
    3.3 Bill of material
    STKO BOM - header
    STPO BOM - item
    STAS BOMs - Item Selection
    STPN BOMs - follow-up control
    STPU BOM - sub-item
    STZU Permanent BOM data
    PLMZ Allocation of BOM - items to operations
    MAST Material to BOM link
    KDST Sales order to BOM link
    3.4 Production orders
    AUFK Production order headers
    AFIH Maintenance order header
    AUFM Goods movement for prod. order
    AFKO Order header data PP orders
    AFPO Order item
    RESB Order componenten
    AFVC Order operations
    AFVV Quantities/dates/values in the operation
    AFVU User fields of the operation
    AFFL Work order sequence
    AFFH PRT assignment data for the work order(routing)
    JSTO Status profile
    JEST Object status
    AFRU Order completion confirmations
    PRT’s voor production orders
    AFFH PRT assignment data for the work order
    CRVD_A Link of PRT to Document
    DRAW Document Info Record
    TDWA Document Types
    TDWD Data Carrier/Network Nodes
    TDWE Data Carrier Type
    3.5 Planned orders
    PLAF Planned orders
    3.6 KANBAN
    PKPS Kanban identification, control cycle
    PKHD Kanban control cycle (header data)
    PKER Error log for Kanban containers
    3.7 Reservations
    RESB Material reservations
    RKPF header
    3.8 Capacity planning
    KBKO Header record for capacity requirements
    KBED Capacity requirements records
    KBEZ Add. data for table KBED (for indiv. capacities/splits)
    3.9 Planned independent requirements
    PBIM Independent requirements for material
    PBED Independent requirement data
    PBHI Independent requirement history
    PBIV Independent requirement index
    PBIC Independent requirement index for customer req.
  • ps
    4.1 Basic data
    PRHI Work Breakdown Structure, Edges (Hierarchy Pointer)
    PROJ Project definition
    PRPS WBS (Work Breakdown Structure) Element Master Data
    RPSCO Project info database: Costs, revenues, finances
    MSPR Project stock
    4.2 Equipment
    EQUI Equipment master data
    EQKT Equipment short text
    EQUZ Equipment time segment
    4.3 Plant maintenance (PM)
    IHPA Plant Maintenance: Partners
    OBJK Plant Maintenance Object List
    ILOA PM Object Location and Account Assignment
    AFIH Maintenance order header
  • qm
    5.1 Inspection lot / info record
    QALS Inspection lot record
    QAMB Link inspection lot - material document
    QAVE Inspection usage decision
    QDPS Inspection stages
    QMAT Inspection type - material parameters
    QINF Inspection info record (vendor - material)
    QDQL Quality level
    QDPS Inspection stages
    5.2 Quality notification
    TQ80 Notification types
    QMEL Quality notification
    QMFE Quality notification – items
    QMUR Quality notification – causes
    QMSM Quality notification – tasks
    QMMA Quality notification – activities
    QMIH Quality message - maintenance data excerpt
    5.3 Certificate profile
    QCVMT Certificate profile characteristic level: texts
    QCVM Certificate profile characteristic level
    QCVK Certificate profile header
  • sd
    VBFA Document flow (alg.)
    VTFA Flow shipping documents
    6.1 Sales order :
    VBAK Header data
    VBAP Item data
    VBPA Partners in sales order
    VBKD Sales district data
    VBEP Data related to line items, delivery lines
    6.2 Billing document :
    VBRK header data
    VBRP Item data
    6.3 Shipping :
    VTTK Shipment header
    VTTP Shipment item
    VTTS Stage in transport
    VTSP Stage in transport per shipment item
    VTPA Shipment partners
    VEKP Handling Unit - Header Table
    VEPO Packing: Handling Unit Item (Contents)
    6.4 Delivery :
    LIKP Delivery header
    LIPS Delivery item
    6.5 Pricing :
    KONH Conditions header
    KONP Conditions items
    KONV Procedure ( billing doc or sales order)
    KOND
    6.6 contracts :
    VEDA Contract data
  • vendor
    LFA1 Vendor master
    LFB1 Vendor per company code
    LFB5 Vendor dunning data
    LFM1 Purchasing organisation data
    LFM2 Purchasing data
    LFBK Bank details
    3.4 Customer – material info record
    KNMT Customer material info record
    Bank data
    BNKA Master bank data
  • wm
    8.1 Transfer requirement
    LTBK Transfer requirement - header
    LTBP Transfer requirement - item
    8.2 Transfer order
    LTAK Transfer order - header
    LTAP Transfer order - item
    8.3 Master data - stock positions
    LQUA Quants
    8.4 Inventory documents in WM
    LINK Inventory document header
    LINP Inventory document item
    LINV Inventory data per quant
  • customer master data
    KNA1 Customer master
    KNB1 Customer / company
    KNVV Customer sales data
    KNBK Bank details
    KNVH Customer hierarchy
    KNVP Customer partners
    KNVS Shipment data for customer
    KNVK Contact persons
    KNVI Customer master tax indicator
  • material master
    MARA Material master
    MAKT Material text
    MARC Material per plant / stock
    MVKE Material master, sales data
    MARD Storage location / stock
    MSKA Sales order stock
    MSPR Project stock
    MARM Units of measure
    MEAN International article number
    PGMI Planning material
    PROP Forecast parameters
    MAPR Link MARC <=> PROP
    MBEW Material valuation
    MVER Material consumption
    MLGN Material / Warehouse number
    MLGT Material / Storage type
    MPRP Forecast profiles
    MDTB MRP table
    MDKP Header data for MRP document
    MLAN Tax data material master
    MTQSS Material master view: QM
    10.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
    10.1.2 Batches
    MCHA Batches
    MCH1 Batches
    MCHB Stock : batches
  • financial accounting
    11.3.1 Company code
    T004 Chart of accounts
    T077S Account group (g/l accounts)
    T009 Fiscal year variants
    T880 Global company data
    T014 Credit control area
    11.3.2 Fi document
    T010O Posting period variant
    T010P Posting Period Variant Names
    T001B Permitted Posting Periods
    T003 Document types
    T012 House banks
  • Administration
    12.2.1 User administration
    USR01 User master
    USR02 Logon data
    USR03 User address data
    USR04 User master authorizations
    USR11 User Master Texts for Profiles (USR10)
    UST12 User master: Authorizations
    USR12 User master authorization values
    USR13 Short Texts for Authorizations
    USR40 Prohibited passwords
    TOBJ Objects
    TOBC Authorization Object Classes
    TPRPROF Profile Name for Activity Group
    DEVACCESS Table for development user
    12.2.2 Batch input queue
    APQD DATA DEFINITION Queue
    APQI Queue info definition
    12.2.3 Job processing
    TBTCO Job status overview table
    TBTCP Batch job step overview
    12.2.4 Spool
    TSP02 Spool: Print requests
    12.2.5 Runtime errors
    SNAP Runtime errors
    12.2.6 Message control
    TNAPR Processing programs for output
    NAST Message status
    NACH Printer determination
    12.2.7 EDI
    EDIDC Control record
    EDIDD Data record
    EDID2 Data record 3.0 Version
    EDIDS EDI status record
    EDPAR Convert External < > Internal Partner Number
    EDPVW EDI partner types
    EDPI1 EDI partner profile inbound
    EDPO1/2/3 EDI partner profile outbound
    12.2.8 Change documents
    CDHDR Change document header
    CDPOS Change document positionen
    JCDS Change Documents for System/User Statuses (Table JEST)
    12.2.9 Reporting tree table
    SERPTREE Reporting: tree structure
    12.2.10 LIS structure/control tables
    TMC4 Global Control Elements: LIS Info Structure
  • general setting
    13.1 General settings
    13.1.1 Countries
    T005 Countries
    13.1.2 Currency
    TCURC Currency codes
    TCURR Wisselkoersen
    TCURT Currency name
    TCURX Decimal places for currencies.
    13.1.3 Unit of measure
    T006 Units of measure
    13.1.4 Calendar functions
    T247 Month names
    TFACD Factory calendar definition
    T015M Month names
    TTZZ Time zones
    TTZD Summer time rules
    TTZDF Summer time rules (fixed annual dates)
    TTZDV Summer time rules (variable dates)
    TTZDT Summer time rules texts
    TTZ5 Assign Time Tones to Countries
    TTZ5S Assign time zones to regions
  • Workbench related tables
    14.1 Data dictionary tables
    DD02L Tables in SAP
    DD02T Tables description
    DD03L Field names in SAP
    DD03T Field description in SAP
    14.2 Workbench
    TADIR Directory of R/3 Repository Objects
    TRDIR System table TRDIR
    TFDIR Function Module
    TLIBG Person responsible for function class
    TLIBT Function Group Short Texts
    TFTIT Function Module Short Text
    TSTC Transaction codes in SAP
    TSTCT Transaction codes texts
    T100 Message text (vb e000)
    VARID Variant data
    D020T Screen texts
    TDEVC Development class
    TDEVCT Texts for development classes
  • Enterprise structure
    15.1 Definition
    FI T880 Company
    T001 Company code
    CO TKA01 Controlling area
    LO T001W Plant / sales organisation
    T499S Locations
    TSPA Division
    SD TVKO Sales organisation / company code
    TVTW Distribution channel
    TVBUR Sales office
    TVKBT Sales office text
    TVKGR Sales group
    TVGRT Sales group text
    T171T Sales district text
    MM T001L Storage locations
    T024E Purchasing organization
    T3001 Warehouse number
    TVST Shipping point
    TVLA Loading point
    TTDS Transportation
    15.2 Assignment
    CO TKA02 Assign company code to controlling area
    LO T001K Assign plant (valuation area) to company code

    SD TVKO Sales organisation / company code
    TVKOV Distribution channel / sales organisation
    TVKOS Division to sales organization
    TVTA Sales aria
    TVKBZ Sales office to sales area
    TVBVK Sales group to sales office
    TVKWZ Plants to sales organization
    MM T024E Purchasing organization / company code
    T024W Plant to Purchase organization
    T001K Link plant ( = valuation area) / company code
    TVSWZ Shipping point to plant
    T320 Assignment MM Storage Location to WM Warehouse
  • Not categorized
    T007a Tax keys
    T134 Material types
    T179 Materials: Product Hierarchies
    T179T Materials: Product hierarchies: Texts
    TJ02T Status text
    TINC Customer incoterms
    TVFK Billing doc types
    T390 PM: Shop papers for print control

回复

使用道具 举报

缘聚风中
我只是路过打酱油的。
回复

使用道具 举报

zhongguomao
我只是路过打酱油的。
回复

使用道具 举报

快速回帖

本版积分规则
您需要登录后才可以回帖 登录 | 注册有礼

快速回复 返回顶部 返回列表