SAP Tables _ ERP Database

SAP Tables | ERP Database

http://w ww .erpdb.info/ sap-tables/

Free Business and Tech Magazines and eBooks Oil & Gas Financial Journal - Provides petroleum industry managers, analysts and investors credible, useful information about the most important... Request Free!

Home Beginners FAQs Online Store Archives RSS EMAIL What is RSS? Recent Posts Understanding SAP Understanding SAP Transactions and their Structure Object Oriented ABAP (OOABAP) – FAQs Web Dynpro for ABAP – Where to Start? Understanding Unders tanding and Working with BAPI’s How to Create GL Account Master data Reversal of Documents in SAP What is Automatic Automatic Posting P osting?? What is Account Assignment Assignment Model? Connection of Account Type with Document Type What is the Document Change Rule? What do you mean by Net Postings? Hi Guest! You can contribute to ERP Database on any topic. ERP Database might be the right place for your Ideas/Opinions to reach a larger audience.

New to ERP Database? Register Now Already a member? Login

Social Bookmarks:

SAP Tables Written by admin on Feb 6th, 2008 | Filed under: General


http://www.erpdb.info/sap-tables/

Windows Storage Made Easy NetApp.com/in Simplify Windows environments by consolidating all data onto NetApp. Blog: Networking Now forums.juniper.net Brought to you by Juniper Networks. Network Security, Routing/Switching Purchasing Process www.NextLevelPurchasing.com Learn purchasing processes online. Free course on purchasing processes Positive Purchasing www.positivepurchasing.com People Development Enabling Purchasing

Accounting BSAD Accounting: Secondary index for customers (cleared items)

BSID Accounting: Secondary index for customers BSIW Index table for customer bills of exchange used BSIX Index table for customer bills of exchange used BSAK Accounting: Secondary index for vendors (cleared items) BSIK Accounting: Secondary index for vendors BSIP Index for vendor validation of double documents BSAS Accounting: Secondary index for G/L accounts (cleared items) Logical databases: -

Accounting documents

BKPF Accounting document header BSEG Accounting document segment BSET Tax data document segment BSEC One-time account data document segment Logical databases: BRM

Bill Of Material

MAST Material to BOM Link EQST Equipment to BOM Link STAS BOMs header STKO BOM header STPN BOM follow-Up control STPO BOM item STPU BOM sub-item STST Standard BOM link STVB Bills of material – Serialization of posting STZU Permanent BOM data Logical databases: -

Bill Of Material

KBED Capacity requirements record Logical databases: POH

Classification

CABS Result of the Statistical Analysis of Table AUSP CUFM Customizing: Class/Config: Screendesigner Form TCME Validity for Global Characteristics KLAH Class Header Data KLAT Classes: long texts KSML Characteristics of a Class AUSP Characteristic values SWOR Classification System: Catchwords KSSK Allocation Table: Object to Class TCLG Class groups TCLO Key Fields of Objects TCLS Classes: Organizational areas TCLST Classes: Org. Areas (Texts)



TCLU Class Status COCC PP-PI attributes for characteristics COFV Process management – process instr. charact. in ctrl. recipe COME Process management – message characteristics CORE Process mgmt.- display characteristics of the eval. version PLFV PI Characteristics/Sub-Operation Parameter Values Logical databases: Matchcodes: CLAS, MERK en KLSW

Classification

TCLA Class Types TCLAT Class Type Texts TCLT Classifiable Objects LTCLTT Classifiable Objects: Texts Logical databases: -

Classification characteristics

CABN Characteristic CAWN Characteristic values Logical databases: -

Configurator

CUCO Additional Data for Configurable Objects CUCVRNT Variants of Constraints CUEX Dependency Storage – Compilation CUFM Customizing: Class/Config: Screendesigner Form CUKB Administrative Information for Dependency Maintenance CUKBT Text Table for Dependency Maintenance Admin. Information CUKN Dependency Storage – Variants/Configuration CUOB Link between Object and Dependency CUPE Extension to BOM Item for Variants CURSADD Dependency Net Additional Data CUVT Variant Table CUXREF Object Dependency Cross References Logical databases: -

Cost elements, centers, activities

CSKA Cost elements (data dependent on chart of accounts) CSKB Cost elements (data dependent on controlling area) CSKS Cost center master CSKT Cost center texts CSKU Cost element texts CSLA Activity master CSLT Activity type texts CSSK Cost center /cost element CSSL Cost center / activity Logical databases: -

Customer

KNA1 General Data in Customer Master KNAS Customer master (VAT registration numbers general section) KNB1 Customer master (company code) KNB4 Customer payment history KNB5 Customer master (dunning data) (aanmaangegevens) KNBK Customer master (bank details) KNC1 Customer master (transaction figures) KNC3 Customer master (special G/L transaction figures) KNKA Customer master credit management: Central data KNKK Customer master credit management: Control area data KNMT Customer-Material Info Record Data Table KNMTK Customer-Material Info Record Header Table KNVA Customer Master Loading Points KNVD Customer master record sales request form KNVI Customer Master Tax Indicator KNVK Customer Master Contact Partner KNVL Customer Master Licenses



KNVP Customer Master Partner Functions KNVS Customer Master Shipping Data KNVT Customer Master Record Texts for Sales KNVV Customer Master Sales Data Logical databases: DDF

Equipment

EQUI Equipment master data EQKT Equipment short texts EQUZ Equipment time segment EAPL Allocation of Task Lists to Pieces of Equipment Logical databases: EQI

Equipment status

EQUI Equipment master data JSTO Status object information JEST Object status TJ30 User status TJ30T Texts for user status TJ02 System status TJ02T Texts for system status Logical databases: -

Function location

IFLOT Functional Location (Table) IFLOTX Functional location: short texts IRLOTX Reference functional location: short texts TAPL Allocation of task lists to functional locations Customizing tables T370R Reference functional location category Logical databases: -

General ledger accounts

SKA1 G/L accounts master (chart of accounts) SKAS G/L account master (chart of accounts: key word list) SKAT G/L account master record (chart of accounts: description) SKB1 G/L account master (company code) SKM1 Sample G/L accounts SKMT Sample account names SKPF Header Data: Inventory Sampling Logical databases: -

Goods movement

AUFM Goods movements for order AFFW Goods movements with errors from confirmations SER03 Doc.header f.serial numbers for goods movements Customizing T440C Planning file entries for goods movements Logical databases: -

Inventory document

IKPF ISEG LINK LINP LINV

Maintenance Order

AFIH Maintenance Order Header AFKO Order header data PP orders AFPO Order item (not used much) AFRU Order completion confirmations AFVC Operation within an order AFVV Order position data CRCO Assignment of work center to cost center OBJK Plant Maintenance Object List CRHD Work Center Header PLAF Planned order HIKO Order master data history HIVG PM order history: operations Logical databases: CNJ

Header: Physical Inventory Document Physical Inventory Document Items Inventory document header in WM Inventory document item in WM Inventory data per quant



Material

MARA Material Master: General Data MARC Material Master: C Segment MARD Material Master: Storage Location/Batch Segment MAKT Material Descriptions MAPL Allocation of task lists to materials MARV Material Control Record MARM Units of Measure MBEW Material Valuation MOFF Outstanding Material Master Records MSTA Material Master Status MVER Material consumption MVKE Material Master: Sales Data MAPR Material Index for Forecast PROP Forecast parameters Logical databases: MSM

Material document

MKPF Header: Material Document MSEG Document Segment: Material BSIM Secondary Index, Documents for Material Logical databases: -

Notifications

QMEL Quality notification QMIH Quality message – maintenance data excerpt Logical databases: -

Orders

AUFK Order master data AFKO Order header data PP orders AFPO Order item JSTO Status object information JEST Object status Logical databases: ODK

Personel

PCL5 HR/RP Cluster 5; HR Planning Usage PREL HR Master Data (Version 3.0: Old Version !) PTXT Texts for HR Master Data …. table PREL has been changed to PA0000 HR Master Record: Infotype 0000 (Events) PA0001 HR Master Record: Infotype 0001 (Org. Assignment) PA0002 HR Master Record: Infotype 0002 (Personal Data) PA0003 HR Master Record: Infotype 0003 (Payroll Status) PA0004 HR Master Record: Infotype 0004 (Challenge) PA0005 HR Master Record: Infotype 0005 (Leave Entitlement) PA0006 HR Master Record: Infotype 0006 (Addresses) PA0007 HR Master Record: Infotype 0007 (Work Schedule) PA0008 HR Master Record: Infotype 0008 (Basic Pay) PA0009 HR Master Record: Infotype 0009 (Bank Details) PA0010 HR Master Record: Infotype 0010 (Capital Formation) PA0011 HR Master Record: Infotype 0011 (Ext.Bank Transfers) PA0012 HR Master Record: Infotype 0012 (Fiscal Data Germany) PA0013 Infotype Social Insurance – Germany PA0014 HR Master Record: Infotype 0014 (Recurr. Bens/Deducs) PA0015 HR Master Record: Infotype 0015 (Additional Payments) PA0016 HR Master Record: Infotype 0016 (Contract Elements) … and up to PA00281 and PA0900 is available ! Logical databases: PNP

Production resource tools

AFFH PRT assignment data for the work order CRVD_A Link of PRT to Document CRVD_B Link of Document to PRT CRVE_A Assignment PRT data – equipment CRVE_B Assignment equipment – PRT data CRVM_A Link of PRT data to a material CRVS_A Relationship of PRT internal number to PRT external number CRVS_B Relationship of PRT external number to PRT internal



number Customizing tables: TCF02 PRT categories TCF03 Texts for the production resources/tools category TCF04 Status of the PRT master TCF05 Language-dependent text table for PRT status TCF06 Field groups in the PRT master for reference TCF07 Language-dependent texts for field groups in PRT master TCF08 Assignment of PRT master fields to field groups TCF10 PRT control key TCF11 Language-dependent text table for PRT control keys TCF12 PRT group key TCF13 Language-dependent text table for PRT group keys Logical databases: -

Project

PROJ Project definition PRPS WBS (Work Breakdown Structure) Element Master Data PRTE Scheduling Data for Project Item Logical databases: CNJ, PSJ, IMA

Purchase Requisition

EBAN Purchase Requisition EBKN Purchase Requisition Account Assignment EBUB Index for Stock Transport Requisitions for Material Logical databases: BAM, BKM, BBM

Purchasing document

EKAN Vendor Address: Purchasing Document EKBE History of Purchasing Document EKBZ History of Purchasing Document – Delivery Costs EKET Delivery Schedules EKKN Account Assignment in Purchasing Document EKKO Purchasing Document Header EKPO Purchasing Document Item EKPB “Material Provided” Item in Purchasing Document EKPV Shipping-Specific Data on Stock Tfr. for Purch. Doc. Item Logical databases: -

Purchasing info record

EINA Purchasing Info Record – General Data EINE Purchasing Info Record – Purchasing Organization Data EIPA Order Price History, Info Record EIKP Export/import header data EIPO Export/Import Item Data KONH Conditions (Header) KONP Conditions (Item) KONM Conditions (1 Dimensional Quantity Scales) KONW Conditions (1 Dimensional Value Scales) Logical databases: IFM, ILM

Reservation

RKPF Document Header: Reservation RESB Reservation/dependent requirements Logical databases: RKM, RNM, POH

Sales Document

VBAK VBAP VBAG VBUK VBUP VBRL VBPA VBKD VBKA VBEP VBRK VBRP VBFA

Header Data Item Data Release Data by Schedule Line in Sch.Agrmt. Header Status and Administrative Data Item Status SD Document: Invoice List partner Business Data Sales activities Schedule Line Data Billing: Header Data (invoice) Billing: Item Data (invoice) Sales Document Flow



LIKP Delivery Header Data LIPS Delivery: Item data Logical databases: AAV, AKV, ARV, VFV

Sales requirements

VBBE Sales Requirements: Individual Records VBBS Sales Requirement Totals Record Logical databases: -

Storage locations and stocks

LAGP Storage bins LEIN Storage unit header records LQUA Quants LQUAB Total quant counts for certain strategies MEIK Make-to-Order Stock for Customer Order MSCA Sales Orders on Hand with Vendor MSKA Sales Order Stock MBPR Stock at Production Storage Bin MLGN Material Data per Warehouse Number MLGT Material Data per Storage Type SLGH Elements of Stock Population Logical databases: S1L, S2L

Tasklist

PLKO Task list – header PLAS Task list – selection of operations/activities PLPO Task list – operation/activity PLKZ Task list: main header PLWP Allocation of Maintenance Packages to Task List Operations PLAB Relationships PLFH Task list – production resources/tools PLFL Task list – sequences PLFT Process instructions PLFV PI Characteristics/Sub-Operation Parameter Values PLMZ Allocation of bill of material items to operations (component list) PLPR Log collector for task lists MAPL Allocation of task lists to materials EAPL Allocation of task lists to pieces of equipments TAPL Allocation of task lists to functional locations Logical databases: -

Transfer requirement

LTBK Transfer requirement header LTBP Transfer requirement item Logical databases: R1L, RBL, RUL

User data

USR01User master record (run-time data) USR02 Logon data USR03 User address data USR04 User master authorizations USR05 User Master Parameter ID USR06 Additional data per user USR07 Object/values of last failed authorization check USR08 Table for user menu entries USR09 Entries for user menus (work areas) USR10 User master authorization profiles USR11 User Master Texts for Profiles (USR10) USR12 User master authorization values USR13 Short Texts for Authorizations USR14 Surchargeable language versions per user USR15 External User Name USR20 Date of last user master reorganization USR30 Additional Information for User Menu USR40 Table for illegal passwords USR41 User master: Additional data USRCOBJ Object Filters for Exploding Product Structures USRM0 Material Master User Settings: User Screen Reference



USRM1 Material Master User Settings: Organizational Levels USRM2 Material Master User Settings: Logical Screens USRMM User settings: material master

Vendor master

LFA1 General section LFAS VAT registration numbers general section LFB1 Company code LFB5 Dunning data LFBK Bank details LFC1 Transaction figures LFC3 Special G/L transaction figures LFM1 Record purchasing organization data Logical databases: KDF

WM transfer

LTAK WM transfer order header LTAP WM transfer order item LUBU Posting change document Logical databases: R0L, RTL

Ref : http://www.henrikfrank.dk/abaptips/appendixes/sap%20tables.htm If you like this post, you may as well like these too:

1. Source Code: Working with database tables and internal tables REPORT ZSOURCE0103. * Declaration of a work area for a Dictionary tableTABLES CUSTOMERS. * Internal table used as snapshot of the database tableDATA ALL_CUSTOMERS LIKE CUSTOMERS OCCURS 100 WITH HEADER...

2. ABAP Programs: Using internal tables as snapshots of database tables REPORT ZSOURCE1103.* Work area for a database tableTABLES CUSTOMERS.* Internal tableDATA ALL_CUSTOMERS LIKE CUSTOMERS OCCURS 100 WITH HEADER LINE.* Filling the internal table with all entries of the database tableSELECT...

SAP Certification @ NIIT NIIT.com/SAPeducation Enrol in 4 weeks SAP Program. Build yourself a better Career. SAP Courses & Colleges www.Shiksha.com/SAP-Cours Find Top SAP Institutes in India. Get Info on Courses,Admision,Fees. BusinessObjects Training lod.sdn.sap.com BO Training and Certification Start learning immediately! Frappant - Web Based ERP www.frappant.in Full-fledged ERP with 300 modules. No license/training/support costs.

Comments (1) Get FREE daily updates by RSS or e-mail

Comment (1)

Login

Sort by: Date Rating Last Activity weaaaaaaa · 33 weeks ago

0



gr8 Report

Reply

Post a new comment Enter text right here!

Comment as a Guest, or login: Name Displayed next to your comments.

Subscribe to

Comments by

Email Not displayed publicly.

Website (optional) If you have a website, link to it here.

Submit Comment


Frappant - Web Based ERP Full-fledged ERP with 300 modules. No license/training /support costs. www.frappant.in

Database Services Expert Database Support Services. Reliable Services. Contact Us Now! services.ahana.co.in

MSc SAP Business Systems Integration Using State of The Art SAP Technology, Theory & Practices www.Brunel.ac.uk/MScBSI

Ramco OnDemand ERP Full-fledged ERP for fast growing Business. Register for Free Trial www.ramcoondemand.com/E

Learn Mgmt of S/W Develop Program for Software Professionals With 2+Yrs Exp. Enrol Today! program.niitimperia.com

Subscribe to RSS

Free Ebooks



Powered by


Translate

Categories ABAP (190) ABAP Keywords (43) ABAP Programs (155) Adobe Forms (1) Application Linking and Enabling(ALE) (13) Articles (11) ASAP Methodology (2) Audit Management (1) Basis (57) Beginners (10) BSP (1)


Business One (5) Business Process Expert (3) Business Warehouse (BIW) (31) Configuration (3) Controlling (CO) (18) Customer Relationship Management (CRM) (11) Customizing (2) Data Transfer (1) Database Administration (1) Electronic Data Interchange (EDI) (3) Enterprise Portal (EP) (4) ERP Central Component (ECC) (1) FAQs (67) Finance (FI) (193) Fun Corner (4) Functional Designs (1) General (12) Human Resource (HR) (12) IDOCs (13) Industry Solutions (IS) (1) Installation (20) Integration (7) Internet Transaction Server (ITS) (1) Java for SAP (10) Knowledge Management(KM) (1) Master Data Management(MDM) (2) Material Management (MM) (86) MaxDB (1) Migration (1) Netweaver (13) Others (1) Production Planning (PP) (12) Project Systems (PS) (4) Quality Management (4) RFID (2) Sales and Distribution (SD) (57) SAP General (203) SAP News (13) SAP Scripts (3) SAP XI (5) Security (1) Sizing (3) Smartforms (4) Strategic Enterprise Management (SEM) (1) Supplier Relationship Managemen (SRM) (6) Supply Chain Management (SCM) (1) Tips & Tricks (27) TradePub (3) Transactions (6) Uncategorized (1) Upgrade (1)



Warehouse Management (WM) (4) Webdynpro (6) Workflow (8)

Blogroll Free IT Magazines SAP Community Network SAP Help SAP Websites

Recent comments The last comments for

SAP Payroll and Time Management

Abbie Poag http://forums.slipknot1.co... » 1 day ago The last comments for

Common SAP Functional Terms

orlando rental in orlando What theme are you currently running on this particular web site ? I really like it. Would you publish... » 1 day ago The last comments for

ABAP HR Programming

ram Hi All , Please send me HR ABAP material to my id [email protected] » 1 day ago The last comments for

100 SAP Basis Interview Questions and Answers

pavithran sir next week i have interview for mnc company can u send 100 basis interview question to my mail plz.... » 2 days ago The last comments for

New Place for SAP Certification Material

Padmapriya Hello Friends, Good Day , I have started to study SAP BI/BO ...Could you please send me study ... » 3 days ago

Comments by IntenseDebate

Copyright © 2007 ERP Database




Damai theme by eches SAP is a registered trademark of SAP AG. ERP Database is not affiliated to SAP AG or any of its subsidiaries. Disclaimer | DMCA Information & Copyright | Privacy Policy | Archives | Advertise

SAP Tables _ ERP Database

Recommend Documents