CDS View Extension with a custom Z table

[katherine_fong]

Is it possible to create an extension for a CDS view to map a customer Z table fields to the CDS view fields? We have a pre-existing upload transaction to upload 1099 records. We would like include these records in 1099NEC processing via Advanced Compliance Reporting. So we will not need to add new fields but would like to add additional records to print out 1099NEC in the Correspondence Forms (IRS 1099NEC forms).

Thanks!

[Renan_Correa · Accepted solution]

Hi Kathy,

If you create a custom CDS view you can define it with a join from your Z table and thus map the data from the Z table to the same format of the CDS View ( same fields ).

After mapping the data you'd still need to extend the report definition to use your Z cds view instead of the standard cds view for the specific scenario.

Regards,

Renan Correa

[Jerry_Lowery]

Hi Katherine,

Have you considered a Custom Business Object?

Help: S/4HANA Cloud Help - Custom Business Object

You can Create a Custom Business Object with the new fields you need as well as add some key fields that match the Key fields in the desired CDS View. (be sure to check the can be associated field)

Once you have that Custom Business Object, a corresponding Custom CDS View will also be created by the system.

In the app Custom CDS View, you can create a new custom CDS View. Start with the original desired CDS View as the initial data source and add the cds view that represents the Custom Business Object as a secondary source. You can then associate the key fields.

The resulting Custom CDS View would represent both the original desired CDS View plus the fields from the CBO.

Thank you

Jerry

[katherine_fong]

Thank you Renan! I will try this and see if I can get this to work to append the uploaded records to the 1099 processing.

[katherine_fong]

Thank you for your answer! I can look at creating a custom Business Object. We do not need to add new fields for the 1099NEC. We just want to upload additional records to append to the 1099NEC output. We just implemented S/4 HANA and are trying to get Advanced Compliance Reporting to work for 1099 processing.

In our old on-premise solution, we used a Z transaction to upload these records and included the records from a Z table via a BADI.

If I can create a Business Object with these additional records with a corresponding Custom CDS View, then could I add these records via an extension to the 1099NEC CDS View?

Thank you!

Kathy