topic FIELDS in Application Development and Automation Discussions

FIELDS

Former Member — Wed, 18 Apr 2007 07:01:13 GMT

HI,

can anyone get the table and field names of these fields

gross sales ,credit returns, gross weight, current yr . previous yr

thank q

rushi

Re: FIELDS

Former Member — Wed, 18 Apr 2007 07:02:26 GMT

Hi,

Use the Table VBAK and

VBAP and find the related fields

reward if useful

regards,

Anji

Re: FIELDS

Former Member — Wed, 18 Apr 2007 07:04:39 GMT

Hi Rushi,

Use the tables VBAK, VBAP, MARA.

Hope this resolves your query.

Reward all the helpful answers.

Regards

Re: FIELDS

Former Member — Wed, 18 Apr 2007 07:08:56 GMT

check any COPA tables ?

like CE01PEPS ( peps = operating concern)

another wise put a login on VBAK/P for both current year and last year.

like this

r_fkdat-sign = 'I'

r_fkdat-options = 'EQ'.

r_fkdat-low = sy-datum.

append r_fkdat

clear r_fkdat

last0(4) = sy-datum0(4) - 1. "2006

last4(4) = sydatum4(4).

r_fkdat-sign = 'I'

r_fkdat-options = 'EQ'.

r_fkdat-low = last.

append r_fkdat

clear r_fkdat

if r_fkdat[] is not initial.

select data from VBAK+ VBAP where date in r_fkdat.

endif.

Regards

Prabhu

Re: FIELDS

Former Member — Wed, 18 Apr 2007 07:14:23 GMT

gross sales - VBAK-NETWR,

credit returns - VBAP-CMPRE_FLT,

gross weight - VBAP-BRGEW,

current yr . - VBKD-GJAHR ,

reward if useful

regards,

Krishna.

Re: FIELDS

Former Member — Wed, 18 Apr 2007 07:29:57 GMT

BRGEW-Gross Weight of the Item FROM VBAP

GJAHR-Fiscal Year FROM KNC1-Customer master (transaction figures)

Hope u can find similar fields from FI Tabels.

regards

Siva