Populating extension fields: BAdI vs Direct SQL Update
I would like to ask for opinions and best practises about approaches in populating SAP tables extension fields.
Sometimes it is necessary to extend tables with some custom fields (ZZ-fields). The necessity comes from costumers requirements when standart tables fields do not cover all the data that should be stored.
Then, those extension fields should be populated with data. As added fields are not standart (Captain Obvious ), it is not possible to populate those fields by standart FM's
As far as I know, it is recomended to use Business Add-Ins (BAdI's) and then extentions in BAPI. But is also possible to use direct SQL updates to extended tables via special FM's.
Another point is standart fields, which unfortunatelly are not supported in BAPI's. In example, it is not possible to update LIKP-BOLNR via BAPI_OUTB_DELIVERY_CHANGE as field BOLNR is not provided in BAPI's structures.
As for me (I am SAP MII Developer) it is more comfortable to use direct SQL updates, but I am no sure is it good approach.
So can you please provide your thoughts about approaches and best practises according to my question?
Thanks in advance!