Table- fields

[Former Member]

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?

[Former Member]

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

[rupesh_brahmankar3]

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