on 07-27-2023 9:20 AM
I have the requirement to make the standard table T024 maintainable (in an S/4-Environment). Due to company guidelines this should be implemented with Fiori.
For this reason my plan was to create a RAP App for the table with andre.fischers RAP Generator and register it in the Business Configuration App.
As a Business Configuration needs an ETag and Total ETag and the table didn´t have those, i created an append and added those two fields.
This worked fine and the Business Configuration could be generated and is being displayed in the App "Maintain Business Configurations". When clicking on it i receive the following error:
The field it is complaining about is a foreign key:
Had anyone have else the same problem? Is it even possible to create business configurations of tables with foreign key fields? Is there a better solution to this other than pre-S/4 solutions like creating a SM30 table maintenance dialog?
Hi Joshua,
first of all thank you for trying out my generator :-), however as of SAP S/4HANA 2022 you will be able to use the Business Object Maintenance Generator that is part of the SAP standard ADT delivery.
Nevertheless the error message will be the same because also here the root cause is the use of a data element that has a conversion exit.
I have reproduced the issue in a 2022 SAP S/4HANA preconfigured appliance test system.
The problem is that the field LDEST of table T024 uses the data element RSPOPNAME which in turn uses the domain RSPOPNAME.
This domain uses a conversion exit which is not allowed in RAP in general beside some exceptions such as alpha conversion for leading zeros.
What you can do is that you cast this field in the R_-CDS view to a data element that does not use a conversion exit.
I found char4 .
You will then loose text so that you might alternatively want to copy the data element to ZRSPOPNAME and the domain to ZRSPOPNAME such that the data element now uses the domain ZRSPOPNAME and you would remove the use of the conversion exit from the defintion of the new domain ZRSPOPNAME.
Kind regards,
Andre
@AccessControl.authorizationCheck: #CHECK
@Metadata.allowExtensions: true
@EndUserText.label: 'CDS View fort024'
define view entity ZR_t024TP_001
as select from t024
association to parent ZR_t024_STP_001 as _t024_S on $projection.SingletonID = _t024_S.SingletonID
{
key ekgrp as Ekgrp,
eknam as Eknam,
ektel as Ektel,
cast ( ldest as char4 preserving type) as Ldest,
// LDEST as Ldest,
telfx as Telfx,
tel_number as TelNumber,
tel_extens as TelExtens,
smtp_addr as SmtpAddr,
zz_last_changed_at as ZzLastChangedAt,
@Semantics.systemDateTime.localInstanceLastChangedAt: true
zz_local_last_changed_at as ZzLocalLastChangedAt,
_t024_S,
1 as SingletonID
}
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
82 | |
9 | |
9 | |
7 | |
7 | |
7 | |
7 | |
6 | |
5 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.