General presentation

Objective of the application

New object at Sales Order line level.

Tool Leader + IT leader of the application: Craig Wanamaker + Diogo Paiva

Dataflow overview

Aero Specific fields for the Sales Order Item location:

TECHNO - BI TEAM > BW - New object at Sales Order line level > image2019-12-20_15-22-12.png

New extractor “DTS_BW_AERO_VBAP - Aero Additional B” created to extract the Aero Specific data from the Sales Order Item in the Additional Data B tab:

TECHNO - BI TEAM > BW - New object at Sales Order line level > image2019-12-20_15-22-28.png

Fields regarding this development:

TECHNO - BI TEAM > BW - New object at Sales Order line level > image2019-12-20_15-22-42.png

The data extracted will be stored in the DSO “DPSDSO56 - Sales Document Header/Item Data Active docs (Rhodia)” and them loaded to the attributes from the characteristic “C_ITM_SD - Sales document item”:

TECHNO - BI TEAM > BW - New object at Sales Order line level > image2019-12-20_15-22-56.png

The data is also loaded from “C_ITM_SD - Sales document item” to “C_ITM_GS - Order Line (SO+PO)”:

TECHNO - BI TEAM > BW - New object at Sales Order line level > image2019-12-20_15-23-9.png

Once data is available in those InfoObjects, they could be retrieved in all the OTC reports through attributes exibition:

TECHNO - BI TEAM > BW - New object at Sales Order line level > image2019-12-20_15-23-25.png

TECHNO - BI TEAM > BW - New object at Sales Order line level > image2019-12-20_15-23-42.png

Extractor “DTS_BW_AERO_VBAP - Aero Additional B” is based on a custom function module:

TECHNO - BI TEAM > BW - New object at Sales Order line level > image2019-12-20_15-24-1.png

The source table is VBAP, which was enhanced with the Aero specific fields:

TECHNO - BI TEAM > BW - New object at Sales Order line level > image2019-12-20_15-24-19.png

Reporting documentation drive folder:

https://drive.google.com/drive/u/0/folders/1-7jbV-hDDyd8BqUFk6MJgHXvzfiLyCo0