topic Re: abt table field in Application Development and Automation Discussions

abt table field

Former Member — Fri, 17 Aug 2007 08:40:34 GMT

hi i have a field from the structure

table name is: kkbcs_out

and field name is SOLLKOST_G

but this is a structure

i want to use the sam field in my report

can somebody tell me how to find that fields or can any body provide help

plz its very urgent

its short description is total target cost

Re: abt table field

varma_narayana — Fri, 17 Aug 2007 08:43:41 GMT

Hi..

You can find the Table names based on the Field Names using Tcode SE15.

Go to SE15.

Select DDIC->Fields ->Table fields in the Navigation.

Enter Your Field Name and Execute. It will display the Table(s)

Reward if Helpful

Re: abt table field

Former Member — Fri, 17 Aug 2007 08:45:42 GMT

Hi,

You can declare a field in your program with the same datatype as the field SOLLKOST_G in table kkbcs_out.

data: lv_sollkost type (datatype of the field).

If you want an internal table of the same structure type, you can declare

data: itab type standard table of kkbcs_out.

Reward points for useful answers.

Best Regards,

Ram.

Re: abt table field

Former Member — Fri, 17 Aug 2007 08:46:01 GMT

but i dont know the table name or field name

Re: abt table field

Former Member — Fri, 17 Aug 2007 08:47:06 GMT

@ram i need the tables

plz help

this is the requirement

Re: abt table field

Former Member — Fri, 17 Aug 2007 08:48:26 GMT

u can get that field CKBOB table with field name soges

Re: abt table field

Former Member — Fri, 17 Aug 2007 08:55:26 GMT

Hi,

First of all please mention what is your purpose of using this as it can be used for a number of purposes and the solution depends on it.

Because if you just want to use the data type of that field,then you can use it anyways be it a structure or a table.

But if you want to fetch some data from the structure KKBCS_OUT,then you will have to find out where it is getting populated as the structures are populated at runtime only.

The other way of finding the reference table is to double click on the Data type of the field SOLLKOST_G which is KKB_SOLLKOST_G ,then again double click on the Domain name and then go to the Value Range tab and at the bottom, Value table has the table name in it.

Answer my question and I might be able to help you.

Regards,

Puneet Jhari.

Re: abt table field

Former Member — Fri, 17 Aug 2007 08:59:58 GMT

The Reference table is TCURC.

The steps to get there is to click on the Currency/Quantity Fields and double click on the Refernec Table KKB_KENNZ and then again double click on the WAERS field in the Component Type and then again double click on WAERS and then click on the Value Range tab and then the Value Table is TCURC.

Regards,

Puneet Jhari.

Re: abt table field

Former Member — Fri, 17 Aug 2007 09:01:55 GMT

i m not geting any thing

plz help

Re: abt table field

Former Member — Fri, 17 Aug 2007 09:06:12 GMT

@puneet

hi i hav run a transaction co03 on production

then production order is displayed

here for one pro order i in goto menu---cost analysis

here i get a grid

and it has some fields

cost elemnet cost element text total target cost total actual cost

so i need the tables and fields related to it

if u provide help

i wil be very thankful to u

plz help

Re: abt table field

Former Member — Fri, 17 Aug 2007 09:14:07 GMT

plz help its very urgent

but take ur time

Re: abt table field

Former Member — Fri, 17 Aug 2007 09:48:35 GMT

i m getting the fields

but they are present in the structures

please help