Skip to Content
0

Read KTOKD number range

Feb 22, 2017 at 01:42 PM

53

avatar image
Luis Rodriguez

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
Answers Answers and Comments
10 |10000 characters needed characters left characters exceeded
▼ Viewable by all users
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Sort by:
Best Answer
avatar image
Raymond Giuseppi Answered
Feb 22, 2017 at 01:58 PM
0

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

Show 1 Share
10 |10000 characters needed characters left characters exceeded
▼ Viewable by all users
Luis Rodriguez
Feb 22, 2017 at 02:27 PM

Raymond,

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

Regards,

Luis

0
Comment