Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Populating extension fields: BAdI vs Direct SQL Update

Hi Experts,

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!

Best Regards,

Vitaliy

Tags:
Former Member
replied

Hi!

Never do direct SQL updates on standard tables. This may cause inconsistencies and SAP will not support them!

You can either use old FM WS_DELIVERY_UPDATE2 or Enhancements (like EXIT_SAPLV50I_010) on BAPI_OUTB_DELIVERY_CHANGE.

Bst Regards!

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question