How to get business partner from premise?

[alejiandro_sensejl]

Hello gurus,

I'm looking for a way to get the business partner (but000-partner) from a premise number (evbs-vstelle). I tried FM ISU_FINDER but he cannot find a business partner for the object.

Can someone tell me another function module, table connections or at least sap transactions with which I can do it?

Thanks in advance,

Alej

PS: Points will be rewarded!

[Former Member · Accepted solution]

Hi,

You can use ISU_FINDER, to get the BP.

On the FM interface, set:

X_OBJTYPE = ISUPARTNER

structure X_FINDPAR-S_VSTELLE = .

Hope it helps,

André

[Former Member]

Hi ,

use this function module ISU_S_OWNER_FOR_PREMISE .

or you can try this path:

you have EVBS-VSTELLE (Premise)

get the EANL-ANLAGE(Installtion) from VSTELLE

each Installtion have one Contract so

get EVER-VERTRAG(Contract) from ANLAGE

Now you can get the Contarct Account from Contract.

get FKKVK-VKONT(Contract Account Number) from VKONTO of EVER.

Now you can get BP Number from Table (FKKVKP-GPART ) .

use this if you not able to find any FM or BAPI , because its not a efficient way .

revert back if any query.

regards

Deepak

[former_member229976]

Hi,

the owner's usage I would not recommend as it reads too much data. You should select the premise either by ISU_DB_EVBS_SINGLE or ISU_DB_EVBS_FORALL. If you already have the premise data, use function module ISU_DB_EANLS_SELECT_VST_SP or ISU_DB_EANL_FORALL_VSTELLE to get the installation. With this you could read table EVER - but please pay attention to the data as an installation can have several contracts within a certain time period - by using ISU_DB_EVER_SELECT_ANLAGE resp. ISU_DB_VERTRAG_SELECT_GP_VS. The table EVER already contains the business partner !!!

But the faster way would probably be to use the MOVE-IN table. Start again with the premise and use function module ISU_DB_EEINV_SELECT_VSTELLE to select the according contracts. Select the BP again via table ever as described above.

BUT, better way would be to use the ISU_FINDER. Call the dialog function module and see how it fills the data to search for the BP.

KR

Uwe