Ms Access (like in ECCS) in BCS 4.0?
As far as I understand there are 3 data entry method only in BCS 4.0 which are the data entry layout, flexible upload, and load from datastream.
Many of our subsidiaries do not use SAP, and do not have the connection to SAP, meanings that in this case the flexible upload is the only method available.
The problem is, this flexible upload do not contain the validation rule inside (not like the ms access in ECCS version where the we can embedded the validation into), meanings that the subsidiaries user can send any data, even unbalance data to the consolidation user. In this case, the consolidation user will be very busy just to load the flexible upload and run validation in SAP (then return the file to every user for correction).
In Ms Access ECCS, since the tool has the validation inside, then the checking role is done in subsidiary level before the data is sent to consolidation users. I have sent a message to request the ms access to SAP, but they say that there is no plan to build ms access for BCS.
My question is, is there anyone have this situation? Is there anyone can advise how to overcome the issue?