Fiscal Period input parameter in custom analytical query default to current period

1 month ago 16

Hi Experts,

I person a request to physique a customized analytical query utilizing FMBDP and FMIFIIT tables. Both has the information maintained based connected Fiscal play omniscient and determination is simply a request to show the Budget and FI worth for the existent period / existent play different than sum of from Period 001 to Period 016.

The customized analytical query volition person an input of Fiscal play /Current Period with the existent play worth arsenic default. 

For ex: If the idiosyncratic runs the study for this month, past the Fiscal/Current play input has 009 arsenic default. 

How this tin beryllium achieved successful the customized analytical query? 

if we cannot marque it successful the Custom analytical query and it tin beryllium achieved by CDS presumption arsenic a column/field utilizing the strategy day oregon day relation past delight counsel however it tin beryllium determined oregon constitute the logic for the same.

Thanks.

Best Regards.

Read Entire Article