Read KTOKD number range

[luis_rod]

Hi all,

I am trying to read the KNA1 table using the KTOKD (account group) column. As this field is not a key field for KNA1, the query can get quite slow.

I have thought that (*maybe*) a faster way to process this query would be to read KNA1 using the proper KUNNR number range, according to the account group. So, my question is: How do I read the number range for a particular KTOKD?

Thanks in advance,

Luis

[luis_rod]

Hi all,

I am trying to read the KNA1 table using the KTOKD (account group) column. As this field is not a key field for KNA1, the query can get quite slow.

I have thought that (*maybe*) a faster way to process this query would be to read KNA1 using the proper KUNNR number range, according to the account group. So, my question is: How do I read the number range for a particular KTOKD?

Thanks in advance,

Luis

[RaymondGiuseppi]

Link between account groups and range numbers :

1. Transaction OBAR or SPRO, Table T077D, KTOKD -> NUMKR range number
2. Transaction XDN1 or SNUM, Table NRIV (DEBITOR, space, NRNR = NUMKR)

Regards,
Raymond

[luis_rod]

Raymond,

Thanks!! That's exactly what I needed...

Regards,

Luis