Precheck before uploading the data

dataservices sap-erp-bw
1

Hello All,

Is there a way to check if the data is already created in SAP R/3 before uploading through BODS.For example before creating a material in SAP i want to check if the material is already present.This precheck should be incorporated in BODS.

Thanks,
Rakesh.

rakesh.sap (BOB member since 2013-10-28)

2

Could you please brief on what you mean by uploading through BODS ? Are you using any IDocs?

ganeshxp :us: (BOB member since 2008-07-17)

3

Yes I use IDOCs for uploading…Before triggerring the IDOC I want to check if the material is already present in SAP .

rakesh.sap (BOB member since 2013-10-28)

4

If it is external number and if you are assigning the material number then you can check that in MARA table MATNR field in sap.

If you are sending blank in MATNR field in your idoc load, you should load your legacy reference into MARA.BISMT field so that you before loading you can import the MARA data from sap into database and compare against it.

naveen3733 (BOB member since 2010-12-06)

5

Hello Naveen,

I know I need to query the MARA table to check if Material is already there.But my question is where should i write the select query?

Thanks,
Rakesh.

rakesh.sap (BOB member since 2013-10-28)