Adding custom data fields from Auto-ID Observation Transactions to BW BADI

[Former Member]

We have been trying to extend the existing AUto-ID 4.0 SP5 BW reporting to include additional data elements we are capturing with the observational transactions. SAP provides some method and BADI (MODIFY_BW_EXTRACT_STRUCTURE) but limited documentation on how to code it. We have already added the necessary data elements and they are working correctly (we see them in the UI, and we have created the necessary BW append strucute). What my developers tell me they need is the underlying tables to which the elements are added. Also, any example of this being done to extend appended data fields to AII transaction data would likely show us what we need. We need help finding the AII transaction data and where the tables are so that the proper code can be added. SAP has implemented an untypical approach here, and its likely due to the need to improve performance of extracting the large amounts of RFID data.

If anyone can assist, we are at critical milestone in our project and would welcome the input. If you need to forward this request to anyone, please do.

[Former Member]

Hi Randy,

The way i understand your requirement is like this

You are capturing additional information as observational data which might through mobile readers or Fixed readers.

If this is additional fields then i believe your team should be aware of the tables

But still the standard SAP AII tables which store transaction data are

/AIN/DM_DOC

/AIN/DM_OBJECT

/AIN/DM_DOC_OBJ

/AIN/DM_DOC_ITM

There are other transaction tables which store information Go to --> se11

select table node and put /AIN/* and do F4. you will get the list of the tables in AII with their description.

If this is not the answer you are expecting, let us know the requirement bit more in detail.

Thanks and regards,

Amit Deshpande