Hola dgrvedado
Puedes crear el formulario mediante SDK, si utilizas una tabla de usuario de tipo de objeto maestro o documento, podrias utilizar un UDO.
En relacion al UPDATE, es solo permitido para las tablas de usuario que son de tipo NINGÚN OBJETO. lo demás como campos de usuarios de transacciones, tablas de usuario tipo maestro y articulo(encabezado y detalle) no esta permitido. existe una nota de SAP donde se detalla este tema. (2371729)
SAP will not support any database, which is inconsistent, due to SQL-Queries, which modify datasets or the datastructure of the SAP Business One Database. This includes any update-, delete- or drop-statements executed via SQL-Server Tools or via the the query interface of SAP Business One.
This is stated in the support contract between SAP and the SAP Business Partner also.
"SAP will not provide support for any problem that arises because Partner or end customer has altered Software or SDK inappropriately " and “Nor will SAP provide any support services for problems that lie in Partner’s or end customer’s area of responsibility and result, for example, from inappropriate installation, unsatisfactory end-user training, lack of or incorrect business design, incorrect operation, or faulty hardware”
Where inconsistencies are found in a database as outlined above, SAP Business One Product Support will be unable to process the incident further. In order to continue the support for this SAP Business One installation, it is expected to revert to a database backup where inappropriate changes have not been carried out.
SAP Partner can find additional related information within the Maintenance policy & Support Scope document.
See the section ‘Limitations to Support Scope’ in the Maintenance Policy & Support Scope document.
Additionally, you may have the following questions:
Is it allowed to INSERT/UPDATE/DELETE on UDT (user-defined table) through SQL Scripts Hana Studio/SQL Management Studio/SDK Doquery() methods/any ADO methods?
Answer: Direct inserts/updates/deletes are not allowed. It is OK for UDTs of type [No Object & No Object with Auto. Increment] only.
Example:
INSERT INTO [@DS_TESTUDT]?
=>Yes for UDTs of type [No Object & No Object with Auto. Increment] only. Not allowed for all other types.
Is it allowed to UPDATE UDFs (user-defined fields) of system tables through SQL Scripts Hana Studio/SQL Management Studio/SDK Doquery() methods/any ADO methods?
Answer: This is not allowed in SAP Business One system tables.
Example:
UPDATE OPOR SET U_DSIC_ParentDoc = ‘1234’?
=>No
UPDATE OPOR SET Printed = ‘Y’?
=>No
Is it allowed to CREATE/ALTER/DROP a table that is not a UDT in an SAP Business One database?
Answer: This is not allowed; all user tables should be part of UDT registration.
Saludos,
Andres Ramirez Jaramillo 