Enhance Standard CDS view I_AugmentedPhysInvtryDocItem for Fiori- Physical Inventory Analysis

[Arushi]

Hi everyone,

I have a requirement to add custom movement types to an existing fiori app - Physical Inventory Analysis that displays only 701 and 702 at the moment.

This App uses BEx query with data source I_PhysInvtryCube, this CDS view has another CDS view as data source I_AugmentedPhysInvtryDocItem.

Inside this CDS view, I found a CASE statement that restricts the movement types, now I want to change this CASE statement, can you help me how to achieve this.

I am looking at Custom Fields and Logic app to enhance this CDS view, but unable to find the business context. Is there a way to enhance the logic of this CDS view without creating a NEW CDS view.

Appreciate any help!

@ObjectModel.foreignKey.association: '_GoodsMovementType'

cast((case when Quantity > BookQtyBfrCountInMatlBaseUnit and PhysicalInventoryItemIsCounted = 'X'

then _AdjmtPostingMovementType.PhysInvtryIncreasingQtyMvtType

else case when Quantity < BookQtyBfrCountInMatlBaseUnit and PhysicalInventoryItemIsCounted = 'X'

then _AdjmtPostingMovementType.PhysInvtryDecreasingQtyMvtType

else ''

end

end) as pi_bwart preserving type) as GoodsMovementType,