2008 Feb 14 7:55 AM
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!
2008 Feb 14 3:03 PM
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é
2008 Feb 14 3:03 PM
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é
2008 Feb 15 11:17 AM
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
2008 Feb 18 3:22 PM
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