Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Tax Jurisdiction(TXJCD) of FI document

Former Member
0 Kudos
1,396

Hi Experts,

I need the Tax Jurisdiction(TXJCD) field for each line item of FI document.

I wont be able to select from BSEG table since it is a cluster and it creates lot of performance issue.

I couldn't find this field in any of the secondary index tables.

Can anyone help me?

Thanks,

Saumia

6 REPLIES 6

Former Member
0 Kudos
249

Any answers??

Former Member
0 Kudos
249

Hi Saumia,

TXJCD and TAXJURCODE both are same.

So TAXJURCODE is available in ADRC table and many table.

Check from where used list.

Regards,

Tutun

0 Kudos
249

Hi,

I want the Tax jurisdiction corresponding to each line item of an FI document.

The values which we can find in BSEG.

I could find all the other fields in other secondary index tables except this field(TXJCD).

Thanks,

saumia

SuhaSaha
Advisor
Advisor
0 Kudos
249

>

> I need the Tax Jurisdiction(TXJCD) field for each line item of FI document.

> I wont be able to select from BSEG table since it is a cluster and it creates lot of performance issue.

> I couldn't find this field in any of the secondary index tables.

What is stopping you from selecting the data from BSEG ? What are the fields available with you prior to selecting from BSEG ?

BR,

Suhas

Former Member
0 Kudos
249

Hi,

I have all the primary keys available with me but selecting from BSEG table is taking few minutes to execute even in development s/m.

Thanks,

saumia

0 Kudos
249

>

> I have all the primary keys available with me but selecting from BSEG table is taking few minutes to execute even in development s/m.

If you have all the primary keys why is it taking time ? 😮 Can you post the SELECT stmt you are using ?

BR,

Suhas