tables

[Former Member]

hi guru's,

i need the tables and fields in the each table.(min of 5).related to sd and mm tables. i've the table list.don't give me tht. field name and field description and table name. urgent. help full full points.

thanx,

yogi.

[Former Member]

Hi Yogi,

<b>SD tables:</b>

Check this link which has relation ship among the tables with fields.

http://www.erpgenie.com/abap/tables_sd.htm

<b>MM tables:</b>

Check this link which has relation ship among the tables with fields.

http://www.erpgenie.com/abap/tables_mm.htm

Thanks,

Vinay

[Former Member]

hi,

when you have the table list u can find out the fields and there descriptions-

VBAK

VBELN Sales Document

ERDAT Date on which the record was created

ERZET Entry time

ERNAM Name of Person who Created the Object

ANGDT Quotation/Inquiry is valid from

VBAP - Sales Document: Item Data

VBELN Sales Document

POSNR Sales Document Item

MATNR Material Number

MATWA Material entered

PMATN Pricing reference material

VBRK - Billing Document: Header Dat

VBELN Billing Document

FKART Billing Type

FKTYP Billing category

VBTYP SD document category

WAERK SD document currency

VBRP- Billing Document: Item Data

VBELN Billing Document

POSNR Billing item

UEPOS Higher-level item in bill of material structures

FKIMG Actual Invoiced Quantity

VRKME Sales unit

VBFA - Sales Document Flow

VBELV Preceding sales and distribution document

POSNV Preceding item of an SD document

VBELN Subsequent sales and distribution document

POSNN Subsequent item of an SD document

VBTYP_N Document category of subsequent document

VBPA - Sales Document: Partner

VBELN Sales and Distribution Document Number

POSNR Item number of the SD document

PARVW Partner function

KUNNR Customer Number 1

LIFNR Account Number of Vendor or Creditor

VBKD - Sales Document: Business Data

VBELN Sales and Distribution Document Number

POSNR Item number of the SD document

KONDA Price group (customer)

KDGRP Customer group

BZIRK Sales district

VBEH - Schedule line hist

VBELN Sales Document

POSNR Sales Document Item

ETENR Schedule line

ABRLI Internal delivery schedule number

ABART Release type

MM tables

MARA - General Material Data

MATNR Material Number

ERSDA Creation date

ERNAM Name of Person who Created the Object

LAEDA Date of Last Change

AENAM Name of person who changed object

VPSTA Maintenance status of complete material

MARC - Plant Data for Material

MATNR Material Number

WERKS Plant

PSTAT Maintenance status

LVORM Flag Material for Deletion at Plant Level

BWTTY Valuation Category

XCHAR Batch management indicator (internal)

MARD - Storage Location Data for Material

MATNR Material Number

WERKS Plant

LGORT Storage Location

PSTAT Maintenance status

LVORM Flag Material for Deletion at Storage Location Level

makt - Material Descriptions

MATNR Material Number

SPRAS Language Key

MAKTX Material Description

MAKTG Material description in upper case for matchcodes

these are some of the important tables in sd and mm

raju

[Former Member]

HI Yogi,

When you have the table list, why don't you see in SE11 transaction?

REgards,

Ravi