FIELDS

[Former Member]

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

[Former Member]

Hi,

Use the Table VBAK and

VBAP and find the related fields

reward if useful

regards,

Anji

[Former Member]

Hi Rushi,

Use the tables VBAK, VBAP, MARA.

Hope this resolves your query.

Reward all the helpful answers.

Regards

[Former Member]

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

[Former Member]

gross sales - VBAK-NETWR,

credit returns - VBAP-CMPRE_FLT,

gross weight - VBAP-BRGEW,

current yr . - VBKD-GJAHR ,

reward if useful

regards,

Krishna.

[Former Member]

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