Skip to Content
author's profile photo Former Member
Former Member

0SCM_TM_SFIR, 0 (zero) selected data records in RSA3

Hello experts.

I have a problem concerning the process to fill the tables in SAP TM 9.0 for BW extraction

I performed the procedures described in http://scn.sap.com/docs/DOC-45442

- Set BW Relevance to SPRO to document types.

- I ran the initialization tables Tx. / SCMTMS / BWIs

- I ran filling tables

/ SCMTMS / BWIU_TOR, Transportation Order

/ SCMTMS / BWIU_TRQ, Transportation Request

/ SCMTMS / BWIU_SFIR, Freight Settlement

/ SCMTMS / BWIU_CFI, Forwarding Settlement

The TM datasources are active Tx. RSA5 and are checked in the Tx.RSA6

when I run the Tx. RSA3 datasources described below, drawn 0 (zero) selected data records , although there are many SAP TM generated documents.

0SCM_TM_SFIR

0SCM_TM_SFIR_ITM

0SCM_TM_SFIR_IV

0SCM_TM_SFIR_PTC

0SCM_TM_SFIR_TCD

0SCM_TM_TRQ

0SCM_TM_TRQ_ITM

0SCM_TM_TRQ_STG

Can anyone tell me how to fix this?

Thank You.

Add comment
10|10000 characters needed characters exceeded

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Sep 25, 2015 at 11:33 AM

    Hi Javier,

    Try to do the following (not included in the guide you mentioned):

    In SPRO, navigate to SAP Transportation Management --> Transportation Management --> Integration --> Integration to SAP NetWeaver Business Warehouse --> Specify Status for BW Relevance.

    Make sure all the status you want to be extracted are listed here. By default only "Completed" is included.

    Does that help?

    Regards,

    Michel

    Add comment
    10|10000 characters needed characters exceeded