Skip to Content
avatar image
Luis Rodriguez

Read KTOKD number range

Feb 22, 2017 at 01:42 PM | 89 Views

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

ABAP Development | kna1 | ktokd
Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Raymond Giuseppi
    Feb 22, 2017 at 01:58 PM

    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

    Add comment
    10|10000 characters needed characters exceeded