Value Mapping with validity period checked with add. data element

[Former Member]

Hello AIF specialist,

I need to implement a value mapping with a valid from and valid to date. By activating the checkbox “Enter Validity Period Dates Directly” these entered dates are only checked against the system date during mapping execution.

But in most cases the validity period need to be checked with an additional date source data element. The outsourcing of the value mapping maintenance into a Z-table is an option. When we enter “SM30” in “Alternative Transaction” field for a direct jump into the value mapping in case of missing mappings is also working fine. But we want to use the AIF VMAP instead of Z-Tables as much as possible.

In my solution I set up a multiple master data value mapping (here: VM_AIF_HOTEL_CODES2) with three external values. The data element for EXT2 and EXT3 are DATAB and DATBI. Here the business user can maintain their value mappings.

Then I set up a second value mapping for the execution (here: VM_AIF_TBL_HOTEL_CD) with a select on the first value mapping:

• Table Name: /AIF/T_MVMAPVAL5
• Field Name: INT_VALUE
• Where Condition for Select Statement: EXT_VALUE1 = '$1' AND EXT_VALUE2 LE '$2' AND EXT_VALUE3 GE '$2'

The second value mapping VM_AIF_HOTEL_CODES2 is executed with a select on the maintained values from first value mapping VM_AIF_HOTEL_CODES2. This works fine. But in case of missing values I’m not able to jump into the transaction /AIF/VMAP with the preselected value mapping VM_AIF_HOTEL_CODES2 as I can do at a normal value mapping.

Our business users are looking forward to the direct jump into the /AIF/VMAP with preselected value mapping. Is there any other change to do this or perhaps does someone have a better idea to solve the check of the validity period against a source data value in AIF?

I’m happy to read your feedback or ideas.

Best wishes

Christoph

[YapingGao · Accepted solution]

Hi Christoph,

There may be no chance (with limited change or enhancement to the standard codes) to support the validity period in the way as you expected.

Regarding to the functionality "Jump into /AIF/VMAP", I think you are looking for a solution of how to "jump into the 2nd value mapping" from Error Handling transaction in case any value mapping error occurs, right?

If yes, I would suggest to implement BAdI /AIF/V5_ACT (in the enhancement spot /AIF/ERROR_HANDLING).  You can take enhancement implementation "/AIF/IM_V5_ACTIONS" as your reference.

Cheers

Yaping

[Former Member · Accepted solution]

Hello Yaping,

thanks a lot for your advice. We will check the BAdI implementation.

Perhaps in one of the next releases a possible additional item in value mapping setup to enter an optional date field to validate date from and date to would be a nice enhancement.

Best regards

Christoph