Modulos SAP - Plant maintenance (PM)

• PM:
  IHPA Plant Maintenance: Partners
  OBJK Plant Maintenance Object List
  ILOA PM Object Location and Account Assignment
  AFIH Maintenance order header

Human resources

• Settings
  T582A Infotypes: Customer-Specific Settings
  
• 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
  
• 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

Modulos SAP - Project system (PS)

• 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
  
• Equipment
  EQUI Equipment master data
  EQKT Equipment short text
  EQUZ Equipment time segment

Modulos SAP - Production Planning (PP)

• 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
  
• 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
  
• 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
  
• 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
  
• Planned orders
  PLAF Planned orders
  
• KANBAN
  PKPS Kanban identification, control cycle
  PKHD Kanban control cycle (header data)
  PKER Error log for Kanban containers
  
• Reservations
  RESB Material reservations
  RKPF header
  
• Capacity planning
  KBKO Header record for capacity requirements
  KBED Capacity requirements records
  
• 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.
  KBEZ Add. data for table KBED (for indiv. capacities/splits)

Modulos SAP - Quality Management (QM)

• 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
  
• 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
  
• Certificate profile
  QCVMT Certificate profile characteristic level: texts
  QCVM Certificate profile characteristic level
  QCVK Certificate profile header

Modulos SAP - Warehouse Management (WM)

• Transfer requirement
  LTBK Transfer requirement - header
  LTBP Transfer requirement - item
  
• Transfer order
  LTAK Transfer order - header
  LTAP Transfer order - item
  
• Master data - stock positions
  LQUA Quants
  
• Inventory documents in WM
  LINK Inventory document header
  LINP Inventory document item
  LINV Inventory data per quant

Modulos SAP - Material Management (MM)

• Material document
  MKPF material document
  MSEG
  material document (item level)
  
• Purchasing
  EKKO Purchase document
  EKPO Purchase document (item level)
  EKPV Shipping-Specific Data on Stock Tfr. for Purch. Doc. Item
  EKET Delivery schedule
  VETVG Delivery Due Index for Stock Transfer
  EKES Order Acceptance/Fulfillment Confirmations
  EKKN Account assignment in purchasing
  EKAN Vendor address purchasing
  EKPA Partner functions
  EIPO Item export / import data
  EINA Purchase info record (main data)
  EINE Purchase info record (organisational data)
  EORD Source list
  EBAN Purchase requisition
  EBKN Purchase Requisition Account Assignment

Modulos SAP - Sales and Distribution (SD)

• SD:
  VBFA Document flow (alg.)
  VTFA Flow shipping documents
  
• 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
  
• Billing document :
  VBRK header data
  VBRP Item data
  
• 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)
  
• Delivery :
  LIKP Delivery header
  LIPS Delivery item
  
• Pricing :
  KONH Conditions header
  KONP Conditions items
  KONV Procedure ( billing doc or sales order)
  
• contracts :
  VEDA Contract data

Modulos SAP - FI/CO

• Master data
  SKA1 Accounts
  BNKA Bank master record
  
• 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)
  
• Payment run
  REGUH Settlement data from payment program
  REGUP Processed items from payment program

• CO :
  TKA01 Controlling areas
  TKA02 Controlling area assignment
  KEKO Product-costing header
  KEPH Cost components for cost of goods manuf.
  KALO Costing objects
  KANZ Sales order items - costing objects
  
• Cost center master data
  CSKS Cost Center Master Data
  CSKT Cost center texts
  CRCO Assignment of Work Center to Cost Center
  
• Cost center accounting
  COSP CO Object: Cost Totals for External Postings
  COEP CO Object: Line Items (by Period)
  . COBK CO Object: Document header
  COST CO Object: Price Totals

Characteristics

• Characteristics :
  CABN Characteristics ( o.a. batch/vendor)
  CABNT Characteristics description
  CAWN Characteristics ( o.a. material)
  CAWNT Characteristics description
  AUSP Characteristic Values
  
• Class types and objects :
  TCLAO Several class types for object
  TCLA Class types ( vb. lfa1 => v10 en 010)
  TCLAT Class type text
  TCLT Classifiable objects
  TCLC Classification status
  
• Links :
  INOB Link between Internal Number and Object
  KLAH Class header data
  KSSK Allocation Table: Object (vb.matnr) to Class
  KSML Characteristics for a class (internal number)

Master Data - ABAP - SAP

• 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
  
• Basic data text (sap script)
  STXB SAPscript: Texts in non-SAPscript format
  STXH STXD SAPscript text file header
  STXL STXD SAPscript text file lines
  
• Batches
  MCHA Batches
  MCH1 Batches
  MCHB Stock : batches
  
• 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
  
• Vendor
  LFA1 Vendor master
  LFB1 Vendor per company code
  LFB5 Vendor dunning data
  LFM1 Purchasing organisation data
  LFM2 Purchasing data
  LFBK Bank details
  
• Customer – material info record
  KNMT Customer material info record
  
• Bank data
  BNKA Master bank data

Tables in SAP - Administration

• 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 use
  
• Batch input queue
  APQD DATA DEFINITION Queue
  APQI Queue info definition
  
• Job processing
  TBTCO Job status overview table
  TBTCP Batch job step overview
  
• Spool
  TSP02 Spool: Print requests
  
• Runtime errors
  SNAP Runtime errors
  
• Message control
  TNAPR Processing programs for output
  NAST Message status
  NACH Printer determination
  
• 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
  
• Change documents
  CDHDR Change document header
  CDPOS Change document positionen
  JCDS Change Documents for System/User Statuses (Table JEST)
  
• Reporting tree table
  SERPTREE Reporting: tree structure
  
• LIS structure/control tables
  TMC4 Global Control Elements: LIS Info Structure

Tables in SAP - Enterprise structure

Enterprise structure

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


Financial accounting

• Company code
  
  T004 Chart of accounts
  T077S Account group (g/l accounts)
  T009 Fiscal year variants
  T880 Global company data
  T014 Credit control area
  
• Fi document
  T010O Posting period variant
  T010P Posting Period Variant Names
  T001B Permitted Posting Periods
  T003 Document types
  T012 House banks
  
• 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

Basic data / administration

Workbench related tables

• Data dictionary tables
  DD02L Tables in SAP
  DD02T Tables description
  DD03L Field names in SAP
  DD03T Field description in SAP
  
• 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
  

Tables Standares SAP - ABAP

La tablas de SAP se dividen en Customising:

General settings

• Countries
  T005 Countries
  
• Currency
  TCURC Currency codes
  TCURR Wisselkoersen
  TCURT Currency name
  TCURX Decimal places for currencies.
  

Unit of measure
T006 Units of measure

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

• Enterprise structure

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