Sunday, November 23, 2008

ABAP-SAP System Tables

ADCP - Person/Address assignment (central address administration)

ADIRACCESS - Table to store keys for TADIR objects

ADR2 - Telephone numbers (central address admin.)

ADRP - Persons (central address administration)

APQD - DATA DEFINITION Queue

APQI - Queue info definition

D010SINF - ABAP- Information about ABAP program source code

E071 - Change and Transport System- Object Entries of Requests/Tasks

E07T - Change and Transport System- Short Texts for Requests/Tasks

ENLFDIR - Additional Attributes for Function Modules

INDX - System table

INDX NAST - Message Status

STXH STXD - SAPscript text file header

T005 - Countries

T005S - Taxes- Region (Province) Key

T005U - Taxes- Region Key- Texts T006 Units of Measurement

T015M - Names of the months

T247 - Month name and short text

T777A - Building Addresses

TADIR - Directory of Repository Objects

TBTCO - Job status overview table

TBTCP - Batch job step overview

TFDIR - Function Module

TFTIT - Function Module Short Text

TSP03L - Spool- Long device names

TSTC - SAP Transaction Codes

TSTCT - Transaction Code Texts

TUTYP - User Types in Current Price List in SAP System

TUZUS - Special versions

TVARV - Table of variables in selection criteria

TVDIR - View Directory

US930 - Data Relevant to Measurement for User Master Record

USR01 - User master record (runtime data)

USR02 - Logon data

USR04 - User master authorizations

USR06 - Additional Data per User

USR14 - Surchargeable Language Versions per User

USR21 - Assign user name address key

ARCH_OBJ - Objects for archiving and reorganization

BTCUED - Description of user event IDs for background processing

BTXSUPB - BSI- Upgrade-Information

CCCFLOW - Client Copy Control Flow

DBSTATC DB - Optimizer Control (Statistics Creation)

DEVACCESS - Table for development users

DEVL OBSOLETE - Do not use (See TCETRAL)

E070 - Change and Transport System- Header of Requests/Tasks

E070L - CTS- Index for Assigning Numbers to Requests/Tasks

INSTVERS - Documentation for installation Status and History

PAT03 - Patch Directory

SDBAC - DBA Action Table

T100 - Messages

TAPLT - Program Application Long Texts

TASYS OBSOLETE - Do not use, see TCEDELI

TDEVC - Development Classes

TEMSE - Temp Sequential table.

TLOCK - Change and Transport System- Lock Table

TNAPR - Processing programs for output. Can be very handy to find the print program for a SAPScript.

TNAST - Printed output control table

TPFET - Table of profile parameters

TPFHT - Profile header, administration data for profiles in DB

TPROT - Table contains all DD tables to be logged

TRBAT - Communication Table for Transport Control

TRDIRT - Title texts for programs in TRDIR

TRESN - Table of Naming Conventions in ABAP Workbench

TRJOB - Job ID for Coordinating Batch-ABAP/UNIX for Transports

TSP03C - Spool- Device Description Extension

TST03 - TemSe data

TSYST OBSOLETE - Do not use (see TCESYST)

TWSYS OBSOLETE - Do not use (See TCETRAL)

USOBT - Relation transaction - authorization object

USR03 - User address data

USR05 - User Master Parameter ID

USR12 - User master authorization values

USR40 - Table for illegal passwords

USR41 - User master- Additional data

UST04 - User masters

VARIT - Variant texts

VARID - Variant directory

D010TAB - Table for Use Report—Tables

DD02L - SAP tables

DD02T - R/3 DD- SAP table texts

DD03L - Table Fields

DD03T - DD- Texts for fields (language dependent)

EDIDC - IDOC Control Records

EDIDOT - Short description of IDoc types

EDID2 - IDOC segments (version 3.1)

EDID4 - IDOC segments (version 4.6)

EDSEA - EDI- Table of all segments of current release

VRSX2 - Central Table for Version Management (Report Source)

TSE05 - Can add parameters to the INSERT COMMAND (IC).

CDPOS - Change document items

CDHDR - Change document header

T529A - governs the foreground sequence of infotypes.

T588Z - governs the dynamic event processing that will only take place during online user inputs.

T588M - Infotype Screen Control

ABAP-Material Management Tables

EINA - Purchasing Info Record- General Data

EINE - Purchasing Info Record- Purchasing Organization Data

MAKT - Material Descriptions

MARA - General Material Data

MARC - Plant Data for Material

MARD - Storage Location Data for Material

MAST - Material to BOM Link

MBEW - Material Valuation

MKPF - Header- Material Document

MSEG - Document Segment- Material

MVER - Material Consumption

MVKE - Sales Data for materials

RKPF - Document Header- Reservation

T023 - Mat. groups

T024 - Purchasing Groups

T156 - Movement Type

T157H - Help Texts for Movement Types

MOFF - Lists what views have not been created

ABAP-Sales and Distribution Tables

KONV - Conditions for Transaction Data

KONP - Conditions for Items

LIKP - Delivery Header Data

LIPS - Delivery: Item data

VBAK - Sales Document: Header Data

VBAP - Sales Document: Item Data

VBBE - Sales Requirements: Individual Records

VBEH - Schedule line history

VBEP - Sales Document: Schedule Line Data

VBFA - Sales Document Flow

VBLB - Sales document: Release order data

VBLK - SD Document: Delivery Note Header

VBPA - Sales Document: Partner

VBRK - Billing: Header Data

VBRP - Billing: Item Data

VBUK - Sales Document: Header Status and Administrative Data

VBUP - Sales Document: Item Status

VEKP - Handling Unit - Header Table

VEPO - Packing: Handling Unit Item (Contents)

VEPVG - Delivery Due Index

ABAP-Production Planning Tables

MAST - Material BOM

STKO - BOM Header

STPO - BOM Positions (detail)

MAPL - Assignment fo Task Lists to Materials

PLKO - Routing Group Header

PLSO - Routing Group Sequence

PLPO - Routing Group Operations

AFKO - Production Order Header

AFPO - Production Order Position (details)

ABAP-PM / SD Tables

AFAB - Network - Relationships

AFFH - PRT assignment data for the work order

AFFL - Work order sequence

AFFT - Order - Process Instructions

AFFV - Order - Process Instruction Values

AFFW - Goods movements with errors from confirmations

AFIH - Maintenance order header

AFKO - Order header data PP orders

AFPO - Order item

AFRC - Incorrect cost calculations from confirmations

AFRD - Default values for collective confirmation

AFRH - Header information for confirmation pool

AFRU - Order completion confirmations

AFRV - Confirmations pool

AFVC - Operation within an order

AFVU - DB structure of the user fields of the operation

AFVV - DB structure of the quantities/dates/values in the operation

AFWI - Subsequently posted goods movements for confirmations

AUFK - Order master data

AUFM - Goods movements for order

BGMK - Master Warranty Header

BGMP - Master Warranty Item

BGMS - Master Warranty Text Item

BGMT - Master Warranty Text

BGMZ - Warranty Counter

CRHD - Work Center Header

CRTX - Text for the Work Center or Production Resource/Tool

EQKT - Equipment Short Texts

EQST - Equipment to BOM Link

EQUI - Equipment master data

EQUZ - Equipment time segment

HIKO - Order master data history

IFLO - Table generated for View IFLO

IFLOT - Functional Location (Table)

IFLOTX - Functional Location- Short Texts

IHGNS - Permit Segment for Plant Maintenance

IHPA - Plant Maintenance- Partners

IHSG - Object-Related Permits in Plant Maintenance

ILOA - PM Object Location and Account Assignment

IMPTT - Measuring Point (Table)

IMRG - Measurement Document

KAKO - Capacity Header Segment

KONP - Conditions (Item)

KONV - Conditions (Transaction Data)

OBJK - Plant Maintenance Object List

QMEL - Quality Notification

QMFE - Quality notification - items

QMIH - Quality message - maintenance data excerpt

QMMA - Quality notification - activities

QMSM - Quality notification - tasks

QMUR - Quality notification - causes

T001 - Company Codes

T001L - Storage Locations

T001W - Plants/Branches

T077D - Customer account groups

T003O - Order Types

T352R - Maintenance revisions

T353I_T - Maintenance activity type description

T356 - Priorities

T357G - Permits

T357G_T - Text for Table 357GT

T370A - Activity Category for PM Lists

TINCT - Customers- Incoterms- Texts

TVKO - Organizational Unit- Sales Organizations

TVKOS - Organizational Unit- Divisions per Sales Organization

TVKOV - Org. Unit- Distribution Channels per Sales Organization

TVTA - Organizational Unit- Sales Area(s)

VIAUFKST - Generated Table for View VIAUFKST

ABAP-FI /CO Tables

AGKO - Cleared Accounts

ANAR - Asset Types

ANAT - Asset type text

ANEK - Document Header Asset Posting

ANEP - Asset Line Items

ANEV - Asset downpayment settlement

ANKT - Asset classes- Description

ANLA - Asset Master Record Segment

ANLB - Depreciation terms

ANLC - Asset Value Fields

ANLH - Main asset number

AT02T - Transaction Activity Category- Description

AT02A - Transaction Code for Menu TIMN

AT10 - Transaction type

AT10T - Name of Transaction Type

BKDF - Document Header Supplement for Recurring Entry

BKORM - Accounting Correspondence Requests

BKPF - Accounting Document Header

BLPK - Document log header

BLPP - Document log item

BLPR - Document Log Index and Planned Order (Backflush)

BNKA - Bank master record

BP000 - Business Partner Master (General Data)

BPBK - Doc.Header Controlling Obj.

BPEG - Line Item Total Values Controlling Obj.

BPEJ - Line Item Annual Values Controlling Obj.

BPEP - Line Item Period Values Controlling Obj.

BPGE - Totals Record for Total Value Controlling obj.

BPJA - Totals Record for Annual Total Controlling Obj.

BSAD - Accounting- Secondary Index for Customers (Cleared Items)

BSAK - Accounting- Secondary Index for Vendors (Cleared Items)

BSAS - Accounting- Secondary Index for G/L Accounts (Cleared Items)

BSEC - One-Time Account Data Document Segment

BSEG - Accounting Document Segment

BSID - Accounting- Secondary Index for Customers

BSIK - Accounting- Secondary Index for Vendors

BSIM - Secondary Index, Documents for Material

BSIS - Accounting- Secondary Index for G/L Accounts

CEPC - Profit Center Master Data Table

CEPCT - Texts for Profit Center Master Data

COBRA - Settlement Rule for Order Settlement

COBRB - Distribution Rules Settlement Rule Order Settlement

COKA - CO Object- Control Data for Cost Elements

COSP - CO Object- Cost Totals for External Postings

COSS - CO Object- Cost Totals for Internal Postings

CRCO - Assignment of Work Center to Cost Center

CSKA - Cost Elements (Data Dependent on Chart of Accounts)

CSKB - Cost Elements (Data Dependent on Controlling Area)

CSLA - Activity master

FEBEP - Electronic Bank Statement Line Items

FPLA - Billing Plan

FPLT - Billing Plan- Dates

GLPCT - EC-PCA- Totals Table

KNA1 - General Data in Customer Master

KOMK - Pricing Communication Header

MAHNV - Management Records for the Dunning Program

REGUT - TemSe - Administration Data

SKA1 - G/L Account Master (Chart of Accounts)

SKAT - G/L Account Master Record (Chart of Accounts- Description)

SKB1 - G/L account master (company code)

T003T - Document Type Texts

T007S - Tax Code Names

T087J - Text

TAPRFT - Text tab. for investment profile

TKA01 - Controlling Areas

TKA09 - Basic Settings for Versions

TKVS - CO Versions

TZB0T - Flow types text table

TZPAT - Financial Assets Management product type texts

VBSEGS - Document Segment for G/L Accounts Document Parking

VTBFHA - Transaction

VTBFHAPO - Transaction Flow

VTBFHAZU - Transaction Activity

VTBFINKO - Transaction Condition

VTIDERI - Master Data Listed Options and Futures

VTIFHA - Underlying transaction

VTIFHAPO - Underlying transaction flows

VTIFHAZU - Underlying transaction status table

VTIOF - Options Additional Data

VWPANLA - Asset master for securities

ABAP-Control statements

LOOP … END LOOP

BEGIN OF … END OF

SELECT … END SELECT

The program loops over a table pulling the data into a work area in the program.

CASE … END CASE

IF … END IF

ELSE … ELSE IF

Defines program behaviour dependent field entries that require a different reaction per unique entry

MOVE

Moves data from one field to another

MOVE CORRESPONDING

Moves data from one table field to another that is similar to the other table. Used when the attributes of tables differ.