I need the name of the table where Organisational data get saved while creating a Functional location using transaction 'IL01'.
Helpful answer will be rewarded.
Please check tables CAWNT for field ATWTB.
You can create a database view joining CABN, CAWN, CAWNT.
Join condition should look like this.
CABN-MANDT = CAWN-MANDT
CABN-ATINN = CAWN-ATINN
CAWN-MANDT = CAWNT-MANDT
CAWN-ATINN = CAWNT-ATINN
CAWN-ATZHL = CAWNT-ATZHL
The view fields are like this ...
ATIN NUMC 10 Internal characteristic
ATZHL NUMC 4 Int counter
ATWRT CHAR 30 Characteristic value
ATWTB CHAR 30 Characteristic value description