2006 Nov 30 6:05 AM
Hi,
i want to know the fields and thier description for the following tables
EKPO
EKKO
EKET
EKBE
EKPV
EKKN
T163
LFA1
LFM1
ESSR
EINA
EINE
EKBZ
VBAK
VBAP
VBFA
VBRK
VBRP
VBPA
KNA1
PLZ SEND THE FIELDS AND THERE USES
2006 Nov 30 6:09 AM
Hi Sudhir,
Execute FM 'DDIF_FIELDINFO_GET' by giving table name as input you will get all fields,descriptions and technical properties
Please see all the descriptions of tables in text table DD02T.
Please find your tables and their descriptions:
EINA - Purchasing Info Record: General Data
EINE - Purchasing Info Record: Purchasing Organization Data
EKBE - History per Purchasing Document
EKBZ - History per Purchasing Document: Delivery Costs
EKET - Scheduling Agreement Schedule Lines
EKKN - Account Assignment in Purchasing Document
EKKO - Purchasing Document Header
EKPO - Purchasing Document Item
EKPV - Shipping Data For Stock Transfer of Purchasing Document Item
ESSR - Service Entry Sheet Header Data
KNA1 - General Data in Customer Master
LFA1 - Vendor Master (General Section)
LFM1 - Vendor master record purchasing organization data
T163 - Item Categories in Purchasing Document
VBAK - Sales Document: Header Data
VBAP - Sales Document: Item Data
VBFA - Sales Document Flow
VBPA - Sales Document: Partner
VBRK - Billing Document: Header Data
VBRP - Billing Document: Item Data
Procedure to search description of table
-
Go to SE11 -> enter dd02l table -> display table
See the contents of DD02L -> give table names in 'include 'area (pussbutton right side of field
Give DDLANGUAGE as 'EN' -> execute(f8)
Procedure to see fields in the table
-
Go to SE11 -> enter DD03Ltable -> display table
See the contents of DD03L-> give table names in 'include 'area (pussbutton right side of field
Give DDLANGUAGE as 'EN' -> execute(f8)
For descriptions of fields use table DDO3T (Text table of DD0L)
Regards
Bhupal Reddy
Message was edited by:
Bhupal Reddy Vendidandi
2006 Nov 30 6:07 AM
hi,
You can find any type of field in SAP using this table in SE12.
Table-DD03L.
please refer these links.
Refer these link:
http://www.erpgenie.com/abap/tables_mm.htm
Rgds
Anver
2006 Nov 30 6:09 AM
Hi Sudhir,
Execute FM 'DDIF_FIELDINFO_GET' by giving table name as input you will get all fields,descriptions and technical properties
Please see all the descriptions of tables in text table DD02T.
Please find your tables and their descriptions:
EINA - Purchasing Info Record: General Data
EINE - Purchasing Info Record: Purchasing Organization Data
EKBE - History per Purchasing Document
EKBZ - History per Purchasing Document: Delivery Costs
EKET - Scheduling Agreement Schedule Lines
EKKN - Account Assignment in Purchasing Document
EKKO - Purchasing Document Header
EKPO - Purchasing Document Item
EKPV - Shipping Data For Stock Transfer of Purchasing Document Item
ESSR - Service Entry Sheet Header Data
KNA1 - General Data in Customer Master
LFA1 - Vendor Master (General Section)
LFM1 - Vendor master record purchasing organization data
T163 - Item Categories in Purchasing Document
VBAK - Sales Document: Header Data
VBAP - Sales Document: Item Data
VBFA - Sales Document Flow
VBPA - Sales Document: Partner
VBRK - Billing Document: Header Data
VBRP - Billing Document: Item Data
Procedure to search description of table
-
Go to SE11 -> enter dd02l table -> display table
See the contents of DD02L -> give table names in 'include 'area (pussbutton right side of field
Give DDLANGUAGE as 'EN' -> execute(f8)
Procedure to see fields in the table
-
Go to SE11 -> enter DD03Ltable -> display table
See the contents of DD03L-> give table names in 'include 'area (pussbutton right side of field
Give DDLANGUAGE as 'EN' -> execute(f8)
For descriptions of fields use table DDO3T (Text table of DD0L)
Regards
Bhupal Reddy
Message was edited by:
Bhupal Reddy Vendidandi
2006 Nov 30 6:10 AM
2006 Nov 30 6:10 AM
Hi,
TO know the functionalities of tables and relationships,cehck this link.
2006 Nov 30 6:27 AM
If u want to see the table fields and their description
goto SE11 enter ur table name , click display button
U can see fields and their description.