Scrol

SAP Trainings contact sap.sreeram@gmail.com or 091-9916083157, 001-210-399-8414

Showing posts with label SAP ABAP Free Demo. Show all posts
Showing posts with label SAP ABAP Free Demo. Show all posts

SAP Tables-3

3      MASTER DATA:

3.1      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

3.1.1        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

3.1.2        Batches 

                MCHA                                   Batches
            MCH1                           Batches
            MCHB                           Stock: batches

3.2      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

3.3      Vendor

            LFA1                            Vendor master
            LFB1                            Vendor per company code
            LFB5                            Vendor dunning data
            LFM1                            Purchasing organization data
            LFM2                            Purchasing data
            LFBK                            Bank details

3.4      Customer – material info record

KNMT                           Customer material info record

3.5      Bank data

                BNKA                                    Master bank data



SAP Tables-2


2      Basic data / administration

2.1      Workbench related tables

2.1.1        Data dictionary tables

            DD02L                                   Tables in SAP
            DD02T                          Tables description
            DD03L                          Field names in SAP
            DD03T                          Field description in SAP

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

2.2      Administration

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

2.2.2        Batch input queue

APQD                           DATA DEFINITION Queue
                APQI                                      Queue info definition

2.2.3        Job processing

TBTCO                          Job status overview table
TBTCP                          Batch job step overview

2.2.4        Spool

TSP02                          Spool: Print requests

2.2.5        Runtime errors

SNAP                           Runtime errors

2.2.6        Message control

                TNAPR                                  Processing programs for output
            NAST                            Message status
            NACH                           Printer determination

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

2.2.8        Change documents

                CDHDR                                 Change document header
            CDPOS                                    Change document positioned
            JCDS                           Change Documents for System/User Statuses (Table JEST)

2.2.9        Reporting tree table

SERPTREE                   Reporting: tree structure

2.2.10    LIS structure/control tables

TMC4                            Global Control Elements: LIS Info Structure