How to link between KONV table(condition types) and GL account ?

[former_member183835]

Hi Experts,

My issue is in my report (Sales Register), It is displaying the billing items with amount. Now my requirement is i want to dispaly its GL account num ( Accounting doc) next to the amount.

GL number is present in BSEG, but my problem is i am unable to link KONV values with BSEG records.

Please help me, how can I link these two tables?

Thanks,

Anoop...

[former_member349098]

hi ,

BSEG is a cluster table u cant user join ....

so try to use FOR ALL ENTRIES

[former_member946717]

Hi Anoop,

Have you displayed Item Conditions on the report?

Please explain your requirement clearly as the Amount in the Billing Item is different from Item Conditions.

KONV refers to the Conditions table

BSEG refers to the Accounting Document Segment.

Please specify the SAP fields you are displaying for Billing Items with Amount, maybe we can help you then.

[former_member183835]

Hi AN,

In my report it is displaying the values from KONV table. the select quesry will fetch from the KONV with where condition (Number of the document condition KNUMV) and (Condition type

  kschl). See the query below.

   SELECT kposn knumv kwert kschl kbetr
    FROM  konv
    INTO  TABLE itab_konv
    FOR   ALL ENTRIES IN itab_vbrk
    WHERE knumv = itab_vbrk-knumv
    AND   kschl IN

So after this query i will get multiple line items from that table, but its GL number is not there in that KONV table. I want to display GL num of all line items which is updated in the accounting doc.

in bseg table, i will get the GL number but i am unable link that with KONV line items...

please help me...

Regards,

Anoop

[Sijin_Chandran]

Hi Anoop ,

I guess you want the GLs associated with the accounting documents in Billing Document of sales.

For that you need to link BKPF( accounting header ) and VBRK ( sale billing header ).

BKPF-AWKEY = VBRK-VBELN.

And thereafter from BSEG you can fetch individual GLs.

There is no direct linking between KONV ( i.e condition type documents ) and GLs.

[former_member183835]

Hi Sijin,

In if you double click on that line items and select the condition type tab, you can see all the line items withs its own condition type.

Currently in my report they are displaying all that items (which is from KONV table). In those line items, some of them have Account key , only that will be updated in Accounts.

Suppose there is 4 items in KONV, in that 3 items have the Account key field filled then that 3 items will be in Accounting doc with its GL.

but how can I link these line items ? So that I can display the GL next to the corresponding column in the report.

hope you understand the issue..

Thanks,

Anoop

[Sijin_Chandran]

Fine ,

Now I understood.

I need to provide you the Pricing Procedure related detail associated.

See , Pricing Procedures are maintained in SAP SD for carrying out pricing.

Pricing means applying different condition types according to different conditions and scenarios.

Now consider this below example :

In this Pricing Procedure ZSFS01

You can see that for some Condition Types Accounting Key are maintained.

And only that will hit GL.

TCode for above V/08.

Now this is not the whole thing.

For determining which GL to hit we need to provide access sequence based on different combinations.

Now here you can see 5 combinations based on this you need to create combinations for which the GL should hit.

Eg.

As an example consider the below example combination

So you can see that whenever this pricing is applied

for the combination of Condition type KOFI with Cust Group 1000 with Mat Grp 00 with AccKey ERL

GL 40000000 will be captured.

c001 table is Cust.Grp/MaterialGrp/AcctKey combination

c002 for Cust.Grp/Account Key

c003 for Material Grp/Acct Key

C005 for Acct Key only.

So you can see that this is not that easy.

[former_member534459]

This message was moderated.