‎2009 Dec 18 2:44 AM
Hi All,
I want to fetch customers assigned to functional location .So I want to know the table where i can fetch this data..
‎2009 Dec 18 3:11 AM
HI Aruna,
This is available in table IFLOS IFLOT the Field name is TPLNR.
Please be clear on your requirement Just Mentioning Functional Location wont give clarity. at least mention a Tcode or Field name or Business requirement etc.
Check these following for more specific requirement
To convert the TPLNR field you can use FM CONVERSION_EXIT_TPLNR_OUTPUT
dont use this FM in a loop as this might cause Performance Issue, instead get the Corresponding Text outside the loop using For All entries using the Folloiwng table
the corresponding text is available in table IFLOS and the Field name is STRNO
IFLOALT
IFLOALT_T
IFLOCUST
IFLOCUSTA
IFLOS
IFLOS_VS
IFLOT
IFLOT_VS
IFLOTX
IFLOTX_VS
IFLOUSRHope This would serve your purpose.
Cheerz
Ram
‎2009 Dec 18 3:11 AM
HI Aruna,
This is available in table IFLOS IFLOT the Field name is TPLNR.
Please be clear on your requirement Just Mentioning Functional Location wont give clarity. at least mention a Tcode or Field name or Business requirement etc.
Check these following for more specific requirement
To convert the TPLNR field you can use FM CONVERSION_EXIT_TPLNR_OUTPUT
dont use this FM in a loop as this might cause Performance Issue, instead get the Corresponding Text outside the loop using For All entries using the Folloiwng table
the corresponding text is available in table IFLOS and the Field name is STRNO
IFLOALT
IFLOALT_T
IFLOCUST
IFLOCUSTA
IFLOS
IFLOS_VS
IFLOT
IFLOT_VS
IFLOTX
IFLOTX_VS
IFLOUSRHope This would serve your purpose.
Cheerz
Ram
‎2009 Dec 21 9:08 AM
Hi Aruna.
You must follow the following link.
1. first to go ILOA Table and fetch ADRNR field based on TPLNR field.
2. Go to but020 table to the associated business partner based on your ADDRNUNBER field.
Regards,
surya