Skip to Content
avatar image
Former Member

Table- fields

HI,

For example, I have a Project to execute and I go to client which is typically an enhancement. I gather requirement from him. But now I need to prepare Functional Specifications for building the code. For preparing functional Specifications I need table- fields name. What are the ways to extract this? How I should know from which table I get data, field which is relevent to me?

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Sep 05, 2008 at 06:42 AM

    Hi,

    To find Fields and Tables to use in your reports, use the F1 Function key on those fields while in the Display Screen. You can then look at the Technical Information to get the Table and Field Names. Be aware that some Fields will be structures (which do not contain data in the ABAP Dictionary) instead of Tables. As far as creating ZReports, you should be familar with ABAP

    Please refer this thread,

    [Table- fields |https://forums.sdn.sap.com/click.jspa?searchID=15940202&messageID=6100981]

    Regards,

    R.Brahmankar

    Edited by: R Brahmankar on Sep 5, 2008 12:13 PM

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 05, 2008 at 06:55 AM

    hi

    initially you should know from wish area you need the data, like examle : if it is master datathe table is MARA MARC etc. if it related to orders then AUFM,CAUFV,AFPO etc

    when you know thw area and you cen get the technical data from SE11 t-code.

    so based on that you can write the Spec.

    some tables

    Engineering Change Management

    AENR Customer and priority

    AEOI Revision Numbers

    Work Center

    CRHD Workcenter Header Data

    CRCA Workcenter Capacity Allocation

    CRCO Workcenter Cost Center Assignment

    CRHH Hierarchy Header

    CRHS Hierarchy Structure

    CRTX Workcenter Text

    KAKO Capacity Header

    KAZY Intervals of Capacity

    Routing

    PLPO Routing Operation Details

    PLKO Routing Header Details

    MAPL Routing Link to Material

    PLAB Relationships - Standard Network

    PLAS Task List - Selection of Operations

    PLMZ Component Allocation

    PLPH CAPP Sub-operations

    PLFH PRT Allocation

    PLWP Maintenance Package Allocation

    PLMK Inspection Characteristics

    Bill of Material

    STPO BOM Item Details

    STPU BOM Sub Items (designators)

    STKO BOM Header Details

    MAST BOM Group to Material

    STZU BOM History Records

    STAS BOM Item Selection

    STPF BOM Explosion Structure

    Line Design

    LDLH Line Hierarchy Header

    LDLP Line Hierarchy Items

    LDLT Line Hierarchy Takt Times

    LDLBC Takts/No. Individual Capacities per Line

    LDLBH Line Balance Header

    LDLBP Line Balance Items

    LDLBT Line Hierarchy Entry and Exit Takts

    PRT's

    CRFH PRT Master Data

    CRVD_A Link of PRT to Document

    CRVD_B Link of Document to PRT

    CRVE_A Assignment of PRT data to Equipment

    CRVE_B Assignment of equipment to PRT data

    CRVM_A Link of PRT data to Material

    CRVM_B Link of Material to PRT data

    CRVS_A Link of PRT Internal number to PRT External number

    CRVS_B Link of PRT External number to PRT Internal number

    Repetitive Manufacturing

    SAFK RS Header Master Data

    S025 LIS -- Run Schedule Quantities

    S026 LIS -- Material Usage

    S028 LIS -- Reporting Point Statistics

    CEZP Reporting Point Document Logs

    CPZP Reporting Points - Periodic Totals

    MRP Records

    MDKP MRP Document Header Data

    MDTB MRP Table Structure (no data)

    PLSC Planning Scenario (Long-term Planning)

    MDFD MRP Firming Dates

    MDVM Planning File Entries

    S094 LIS -- Stock/Requirements Analysis

    Reservations

    RESB Reservations/Dependent Requirements

    Planned Orders

    PLAF Planned Orders

    Discrete Production

    AFKO Order Header

    AFPO Order Item Detail

    AFVC Order Operations Detail

    AFFL Order Sequence Details

    AFFH Order PRT Assignment

    AFBP Order Batch Print Requests

    AFRU Order Completion Confirmations

    AFFW Confirmations -- Goods Movements with Errors

    AFRC Confirmations -- Incorrect Cost Calculations

    AFRD Confirmations -- Defaults for Collective Confirmation

    AFRH Confirmations -- Header Info for Confirmation Pool

    AFRV Confirmation Pool

    AFWI Confirmations -- Subsequently Posted Goods Movements

    Classification

    KLAH Class Detail

    CABN Characteristic Detail

    AUSP Characteristic Values

    CAWN Characteristic Values

    CAWNT Characteristic Value Texts

    KSML Characteristic Allocation to Class

    KSSK Material Allocation to Class

    -ashok

    Add comment
    10|10000 characters needed characters exceeded