topic Re: Module FI : General Posting in Application Development and Automation Discussions

Module FI : General Posting

Former Member — Tue, 27 Feb 2007 10:39:59 GMT

Hi,

Which tables are used to store values of General Posting against WBS element in finance.

Points will be rewarded,

Thanks

Vinayak

Re: Module FI : General Posting

Former Member — Tue, 27 Feb 2007 10:47:32 GMT

Hi,

All the costs w.r.t WBS elements will go to Controlling tables;

Costs related to PS module are found in the following Tables;

COSP, COEP, BPEJ and COST.

Regards,

Anji

Re: Module FI : General Posting

Former Member — Tue, 27 Feb 2007 13:35:51 GMT

How do I found the entry for my WBS element and in which table.

Thanks.

Re: Module FI : General Posting

Former Member — Tue, 27 Feb 2007 13:39:34 GMT

chk this table RESB

Re: Module FI : General Posting

Clemenss — Tue, 27 Feb 2007 14:06:01 GMT

Hi Vinayak,

go to domain of data element of WBS element and check what conversion exit is behind it. You have to search for internal representation which may be quite different from external.

see the following code snippet which we used to find WBS posting items

<pre>

Build COVP object key

LOOP AT lt_prps ASSIGNING <prps>.

PERFORM conversion_exit USING:

'ABPSP' 'INPUT' <prps>-posid CHANGING lv_j_objnr.

CONCATENATE

'PR' "project data

lv_j_objnr

INTO lv_j_objnr.

INSERT lv_j_objnr INTO TABLE lt_j_objnr.

ENDLOOP." at lt_posid assigning <posid>.

find CO posting data for object keys

PERFORM getfields USING lt_covp CHANGING lt_fields.

merge the DDIC key fields of the table to avaoid 4 all entry error

PERFORM merge_key USING 'COVP' CHANGING lt_fields.

SELECT (lt_fields)

INTO CORRESPONDING FIELDS OF TABLE lt_covp

FROM covp

FOR ALL ENTRIES IN lt_j_objnr

WHERE lednr = '00' "Standard ledger

AND objnr = lt_j_objnr-table_line

AND gjahr in s_gjahr ""CLI20060626 replaces faulty p_gjahr

AND versn = '000'. "Actual version

Now accordingly bseg entries

PERFORM getfields USING lt_bseg CHANGING lt_fields.

merge the DDIC key fields of the table to avaoid 4 all entry error

PERFORM merge_key USING 'BSEG' CHANGING lt_fields.

SELECT (lt_fields)

INTO CORRESPONDING FIELDS OF TABLE lt_bseg

FROM bseg

FOR ALL ENTRIES IN lt_covp

WHERE bukrs = lt_covp-refbk

AND bukrs IN s_bukrs

AND belnr = lt_covp-refbn

AND gjahr = lt_covp-refgj

AND buzei = lt_covp-refbz

AND projk <> space.

and the header data for fiscal period

PERFORM getfields USING lt_bkpf CHANGING lt_fields.

merge the DDIC key fields of the table to avaoid 4 all entry error

PERFORM merge_key USING 'BKPF' CHANGING lt_fields.

SELECT (lt_fields)

INTO CORRESPONDING FIELDS OF TABLE lt_bkpf

FROM bkpf

FOR ALL ENTRIES IN lt_covp

WHERE bukrs = lt_covp-refbk

AND belnr = lt_covp-refbn

AND gjahr = lt_covp-refgj.

LOOP AT lt_bseg ASSIGNING <bseg>.

check period

READ TABLE lt_bkpf ASSIGNING <bkpf> WITH KEY

bukrs = <bseg>-bukrs

belnr = <bseg>-belnr

gjahr = <bseg>-gjahr.

CHECK:

sy-subrc = 0,

<bkpf>-monat IN s_monat.

filter for wbs element
"Have you ever seen such?

PERFORM conversion_exit USING:

'ABPSP' 'OUTPUT' <bseg>-projk CHANGING lv_posid,

'ABPSN' 'INPUT' lv_posid CHANGING lv_posid.

READ TABLE lt_prps ASSIGNING <prps>

WITH KEY posid = lv_posid.

CHECK sy-subrc = 0.

check Profit center for new market (t_new_market)

READ TABLE t_new_market TRANSPORTING NO FIELDS

WITH KEY gjahr = <bseg>-gjahr

bukrs = <bseg>-bukrs

prctr = <bseg>-prctr.

</pre>

Regards,

Clemens

Re: Module FI : General Posting

Former Member — Tue, 27 Feb 2007 14:12:32 GMT

that table does not have any entries.

Re: Module FI : General Posting

Former Member — Wed, 14 Mar 2007 08:18:41 GMT

Hi,

I am accessing data from coep and cobk table.

but qry takes too much time.

any thing wrong

pls suggest

Regards

Vinayak

Re: Module FI : General Posting

Former Member — Wed, 14 Mar 2007 08:27:04 GMT

try to use all the keys whule selecting.

chk if this table is of any help to u:

kwbs - Assignment of WBS No. - Costing Objects

regards,

madhu

Re: Module FI : General Posting

Former Member — Mon, 09 Apr 2007 04:47:17 GMT

Thanks