Bookshelf Home | Contents | Index | PDF |
Siebel Customer-Centric Enterprise Warehouse Installation and Configuration Guide > Configuring Siebel Supply Chain Analytics > About the SAP R/3 Inventory Transfer Process for Siebel Supply Chain AnalyticsIn SAP R/3 you can post a stock transfer from plant to plant using a two-step procedure— post the stock removal from storage at the issuing plant and post the stock placement into storage at the receiving plant. There are certain movement types you would associate with this two-step process. By default, SAP R/3 uses:
Table 75 lists three records for the 303-305 combination in the IA_PROD_XACTS table in Siebel Customer-Centric Enterprise Warehouse. The 305 movement type in Table 75 acknowledges the receipt of 250 items in the receiving plant. If you are interested in seeing how much a plant received in a day at gross level, you should exclude the third record from the calculation. Otherwise the quantity is doubled, and your result is 500. Siebel Supply Chain Analytic is preconfigured to filter out movement types which are associated with the second step in a two-step transfer process. The filtration occurs at the reporting level and not at the ETL level. Therefore, the physical table stores these three records, but the Siebel Analytics Server applies a filter for the 305 movement type. For the 313 and 315 movement types, the filtration occurs at the 315 movement type. If you do not need these filters, remove the content filter (front end metadata) in the Fact - Inventory Transactions logical fact table in the Siebel Business Analytics repository. |
Siebel Customer-Centric Enterprise Warehouse Installation and Configuration Guide |