topic Read KTOKD number range in Application Development and Automation Discussions

Read KTOKD number range

luis_rod — Wed, 22 Feb 2017 13:42:34 GMT

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

Re: Read KTOKD number range

RaymondGiuseppi — Wed, 22 Feb 2017 13:58:15 GMT

Link between account groups and range numbers :

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

Regards,
Raymond

Re: Read KTOKD number range

luis_rod — Wed, 22 Feb 2017 14:27:27 GMT

Raymond,

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

Regards,

Luis