Determination of country based on Sales Org

[Former Member]

Hi Friends,

I have sales Organization , I need to determine the country (Land1 field )

, which table I need to check to that,

Is there any direct relationship to get this or please provide the path forward to get this.

Cheers

Prashant

[Former Member]

check the table TVKO

[Former Member]

just select the fields vkrog and BUKRS from TVKO

and now select the Land1 from T001 giving BUkrs as the input .

u need to make use of both the tables TVKO and T001 to get land1 .

regards,

vijay

[Former Member]

parameters : p_vkorg like tvko-vkorg.


data : v_vkorg like vbak-vkorg.
data:  v_bukrs like ekpo-bukrs.
data:  v_land1 like kna1-land1.

       select single vkorg bukrs into (v_vkorg , v_bukrs)
               from tvko where
                    vkorg = p_vkorg.

                    if sy-subrc eq 0.
                    write:/ v_vkorg, v_bukrs.
                    else.
                    write:/ 'Invalid sales org'.
                    endif.

       select single land1 into v_land1 from t001 where bukrs = v_bukrs.

       write:/ 'Country', v_land1.

check this ..

regards,

vijay.