Wednesday, June 15, 2011

Master Data Tables

General settings

T005 Countries
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
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
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
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
Batch input queue
APQI Queue info definition
Job processing
TBTCO Job status overview table
TBTCP Batch job step overview
TSP02 Spool: Print requests
Runtime errors
SNAP Runtime errors
Message control
TNAPR Processing programs for output
NAST Message status
NACH Printer determination
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 positioned
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

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
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 SAP script: Texts in non-SAP script format
STXH STXD SAP script text file header
STXL STXD SAP script text file lines
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
LFA1 Vendor master
LFB1 Vendor per company code
LFB5 Vendor dunning data
LFM1 Purchasing organization data
LFM2 Purchasing data
LFBK Bank details

Customer – material info record
KNMT Customer material info record
Bank data
BNKA Master bank data
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
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)
FI :
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
Sales and Distribution (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
Material Management (MM) :
Material document
MKPF material document
MSEG material document (item level)
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

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
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

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

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

EQUI Equipment master data
EQKT Equipment short text
EQUZ Equipment time segment

Plant maintenance (PM)
IHPA Plant Maintenance: Partners
OBJK Plant Maintenance Object List
ILOA PM Object Location and Account Assignment
AFIH Maintenance order header
Human resources
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
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

Other important table

JEST System Status with object number
TJ02 System status description.

MRP Related

MDKP Header Data for MRP Document
MDVL Planning file entry for long term planning
MDVM Enry in MRP file
PBVPV Material Index for consumption of planning
REUL Material stock transfer reservation index
SAFK Run schedule master data
SQ01 Abap query
EDMSG ALE message type table
EDI Specific Transactions
• VOE1 Translation between EDI categories and SD item categories
• VOE2 Table EDSC view. Customer link to sales area detail
• VOE3 Table view EDPVW. Add partner types that will be transferred to the IDoc
• VOE4 Table view EDPAR. Link external partner number with our internal number
• WEDI EDI Administrator Menu
• BALE Idoc Administration
Scheduling agreements
• OVA9 Create entries for each sold-to customer for which you will receive EDI schedule releases. At implementation, the only field that needs to be maintained is "Check PO number," which causes SAP to make sure that the PO number sent on the release matches the PO number on the schedule agreement. This transaction updates table T663A. SAP will not post an EDI schedule release, if this record is missing.
• OVAI Create entries for each Vendor / Partner description combination. (Vendors must match sold-to Acct. at Cust., and Partner descriptions must match ship-to Partner descriptions.) This transaction updates table T661W. SAP uses this table to determine the schedule agreement sold-to partner.
• OVAJ If you would like SAP to post schedule requirements using discrete dates only, instead of weekly and/or monthly buckets, you can indicate the days of the week that you deliver to this customer. SAP will divide the customer's quantity for a week or month evenly into the days of the week specified by the distribution function code. This code must be sent in the DELINS IDoc in field E1EDP16-ETVTF.
IDoc Transactions
• WE09 / WE02 IDoc lists according to content. View IDocs via specific IDoc number or business application detail contained within the contents of a segment.
• WE05 View IDocs
• WE19 EDI test tool. Use to test inbound Function module changes.
• WE20 Partner profile configuration. Add partner detail together with inbound and outbound relationships. We also incorporate message control on the outbound IDocs. Utilize the organizational units to trap functional errors for further processing
• WE30 Create IDoc extension type
• WE31 Segment create
• WE57 Assign function module to logical message and IDoc type
• WE60 IDoc type documentation tool
• WE82 Link Release detail to Extension IDoc Type
• BD55 Conversion rule user exit. Link conversion rule user exit to the different system \ partner combinations
• BD87 Reprocess IDocs in error or waiting for action. (Both inbound and outbound in 4.6. Use BD88 in prior versions)
• BALA ALE Application Distribution
• BALM ALE Master Data Distribution
Output determination
856 - ASN
• V/36 Maintain output determination for deliveries (Output determination procedures). V10000 (Header output) has condition type LAVA (usually with requirement 1 NB: Use V/84 ? V7ALLE ? SHAD for grouped ASNs. I.e. Group deliveries into shipments
• VV21,VV22,VV23 Create output condition records for shipping. LAVA ? WE (Partner function) - We must add each new partner with VV21
• VL71 Reissue output for deliveries
810 - Invoice
• V/54 Maintain access sequence for billing documents
• VV31,VV32,VV33 Create condition records for billing documents. (RD00 ? RE Billing party)
• VF31 Reissue output for billing documents
855 ? Order Response
• V/30 Sales document output types (BA00)
• V/48, V/32, V/43 Maintain access sequence for sales documents
• VV11,VV12,VV13 Create condition records for sales documents. (BA00 ? SP Sold to party)
Requirements coding
• V/27 Create code to check requirements for output control. Used to check ZBA0 against BA00 output.
Sales & Distribution
Sales order / Quote / Sched Agreement / Contract
• VA02 Sales order change
• VA05 List of sales orders
• VA22 Quotation change
• VA32 Scheduling agreement change
• VA42 Contract change
• VF02 Change billing document
• VF11 Cancel Billing document
• VF04 Billing due list
• FBL5N Display Customer invoices by line
• FBL1N Display Vendor invoices by line
• VL02N Change delivery document
• VL04 Delivery due list
• VKM5 List of deliveries
• VL06G List of outbound deliveries for goods issue
• VL06P List of outbound deliveries for picking
• VL09 Cancel goods issue
• VT02N Change shipment
• VT70 Output for shipments
• VKM3, VKM4 List of sales documents
• VKM1 List of blocked SD documents
• VD52 Material Determination
• SWEAD Event queue administration
• SWE2 Event type linkages
• SWE3 Event linkages
• PPOME Organizational Unit Maintenance
• SWE5 Consistency Checks for Event Linkages
• SWUD Workflow Diagnostic Tool
The following section provides detail on other useful SAP areas.
Create delivery via transfer orders
Once the order is saved proceed through the following steps. The process assumes the item has values in the warehouse bin.
• VL04 Delivery due list. Run the delivery due with your order number to create the delivery
• LT03 Create Transfer Order. EG. Warehouse: 101 and enter. Picking background. Save
The Transfer order should now be saved. It now needs to be confirmed.
• In LT03 go to menu option Transfer Order -> Confirm ? Transfer Order
• Enter
• Save
The transfer order is now confirmed.
• VL02N Delivery change. EG: Edit the delivery to do the following Pack ? External customer material number = COO. External delivery number ? Waybill number. BOL ? Transport tag. Carrier ? Header partner ? SP (E.G. FXP). Tracking number = Packing Unit
Purchase Orders
• ME22N POChange
• ME57 Create POfrom purchase requisition
• CO09 Availability overview
Goods Movement
• MIGO Post goods receipt
• MB51 Material document list
• MB01 Goods Movement
• MD04 Material Requirements. Shows material requirements and releases against materials
• SE38 ABAP Editor. Used to modify ABAP programs
• SM01 Transaction list. Lock transactions in the system. Also a good tool to see what transactions are available
• SHDB Transaction recorder (BDC)
• CMOD User exit \ project tool. Coordinates your changes into projects for the purpose of activating all user exits for a particular project. A user exit needs to be modified before it will work
• SE16 Table contents display
• SOST View mails sent externally from SAP
• SU53 Check authorization object
• SQVI Table Quickviewer ? Used to created quick client dependent reports
• ST22 ABAP Dump Analysis
• ST01 System trace
• ST11 Display developer trace
• ST05 SQL Trace
• SM21 System log
• ST22 Display short dumps
• SM12 Display locked entries
• List of ABAP Reports
• RBDAPP01 Post inbound Idocs to application documents
• RBDAGAI2 Re-processing of IDocs after ALE input error
• RBDAGAIE Reprocessing of edited IDocs
• RBDMANIN Start error handling for non-posted Idocs
• RSEINB00 Idoc inbound processing by file
• RSEOUT00 Process outbound IDocs

No comments:

Post a Comment