topic Re: Data not picking from a table in Application Development and Automation Discussions

Data not picking from a table

Former Member — Wed, 26 Feb 2014 12:10:54 GMT

Hi Experts,

I have attached a customized smartform to a standard driver program. I have picked few fields from adrs table but when I try to pick telf1 from kna1, it says this field is unknown. I tried with &kna1-telf1& and &e_kna1-telf1& but it says the field in unknown.

In debugger, the values in kna1 are coming. Please suggest.

Regards

Mani

Re: Data not picking from a table

Former Member — Wed, 26 Feb 2014 12:18:06 GMT

Kindly check for global variables in debugger or can you please explain more with exact screen shots.

Re: Data not picking from a table

former_member187748 — Wed, 26 Feb 2014 12:19:04 GMT

Hi Mani,

you have written that you " I have picked few fields from adrs table but when I try to pick telf1 from kna1, it says this field is unknow"

As far as i know there is no table called as adrs

Re: Data not picking from a table

Former Member — Wed, 26 Feb 2014 12:23:52 GMT

Nice catch Sanjeev,

As ADRS is structure to save address, I think what Mani means is structure only.

He is getting values in these structures through this FM. He is able to use values from ADRS but not from KNA1. That is the issue.

Re: Data not picking from a table

Former Member — Wed, 26 Feb 2014 12:29:29 GMT

Hi Mani,

As per my understanding you can not use KNA1 as that is local to this function module.

Could please explain in details exactly where you are using this thing.

Re: Data not picking from a table

ThangaPrakash — Wed, 26 Feb 2014 12:32:49 GMT

Hello Mani,

There is a very detailed document prepared by on how to see the global internal table data in debugging.

Check it, very useful document, it might help you.

Reagrds,

Thanga

Re: Data not picking from a table

former_member187748 — Wed, 26 Feb 2014 12:35:35 GMT

Hi Mani,

have you used this function module just by copy pasting from anywhere,

please elaborate your requirements for use of this function module.

What exactly you wants, please tell us clearly.

Re: Data not picking from a table

Former Member — Wed, 26 Feb 2014 12:37:56 GMT

Hi,

Apologies for the late reply.

Adrs is a structure. What I mean is the values are coming from adrs but not from kna1. I need to pick the phone number. Please suggest. Do let me know for any screenshots.

Regards

Mani

Re: Data not picking from a table

Former Member — Wed, 26 Feb 2014 12:39:10 GMT

Hi,

The requirement is attach a customized smartform into F150. There is no driver program in nace.

Regards

Mani

Re: Data not picking from a table

former_member187748 — Wed, 26 Feb 2014 12:40:54 GMT

Hi Mani,

why not you simply pass the value of customer (kunnr) in kna1 and pick telephone no( telf1) simply.

The error you are showing is different, declare this field in output parameters, and in

global declaration properly.

i means to say that, in the program lines where you have used kna1-telf1, in that

output parameters, put this variable, please see below,

and also check that this variable has been defined in the global definition or not.

Re: Data not picking from a table

Former Member — Wed, 26 Feb 2014 12:45:27 GMT

The document has received poor ratings so far.

It is not that detailed and deals only with specific case of checking huge number of internal tables.

In addition, the document does not have anything that could help Mani Bhushan.

Re: Data not picking from a table

Former Member — Wed, 26 Feb 2014 12:51:03 GMT

Hi Sanjeev,

I appreciate your reply. Please check the following:

data: gt_kna1 type TABLE OF kna1.

select kunnr telf1 from kna1

into table gt_kna1

where kunnr = I_mhnk-kunnr.

It says I_mhnk-kunnr is unknown. How to do it?

Regards

Mani

Re: Data not picking from a table

ThangaPrakash — Wed, 26 Feb 2014 12:54:38 GMT

Oh okay Manish, Can you please update the document with detailed inputs.

Regards,

Re: Data not picking from a table

former_member187748 — Wed, 26 Feb 2014 12:56:14 GMT

Hi Mani,

please see mani, i think the variable you have used i_mhnk is a structure

that I_MHNK is an structure, and you can not pass data from a structure

please make i_mhnk as a part of any internal table then, use it.

it will surely solve your issue, please understand the difference between

a structure and a table.

Please revert if i am wrong.

Re: Data not picking from a table

former_member227140 — Wed, 26 Feb 2014 13:06:18 GMT

It says I_mhnk-kunnr is unknown. How to do it?

if issue is this i think you missed it to mention I_mhnk in INPUT PAREMETERS.(in same place where sanjeev mentioned wa and vbeln)

mention I_mhnk there in input paremeters and check if it gives same error.

Re: Data not picking from a table

former_member187748 — Wed, 26 Feb 2014 13:07:22 GMT

Hi Mani,

please go through these links , it will help you in achieving your goal.

SAP Library - Dunning

Attaching the Invoice Smartforms&nbsp; to Dunni... | SCN

Dunning with SAP Smart Forms (SAP Library - Release notes 46C)

Re: Data not picking from a table

Former Member — Wed, 26 Feb 2014 13:10:32 GMT

No i won't. The blog conveys exactly the issue faced and the approach taken to ease the situation.

Re: Data not picking from a table

Former Member — Wed, 26 Feb 2014 13:18:18 GMT

Hi All,

It has worked.

select telf1 from kna1

into gs_telf1

where kunnr = mhnk-kunnr.

ENDSELECT.

I have a doubt. I will ask tomorrow. Will close the thread later. Thank you experts.

Regards

Mani