There is often requirement from client to have additional data placed on Sales order either on Header level or item level. This requirement was achieved through implementing BADI BADI_SD_SALES_BASIC.
Add below code to BADI Method:
data wa_head_tab type SALES_CUST_TAB_PAGE.
if sy–tcode eq ‘VA01’ or sy–tcode eq ‘VA02’ or sy–tcode eq ‘VA03’.
wa_head_Tab–head_caption = ‘Additional Address Data’.
wa_head_Tab–head_program = ‘SAPLZSD_ADDR’.
wa_head_Tab–head_dynpro = ‘9009’.
append wa_head_tab to ct_cus_head_tab.
While ZSD_ADDR is the function group and 9009 is a sub screen created in that function group.
These three fields are added using append structure in sales order header table VBAK.
These fields are defined using custom data elements with check table of relevant data in system.
ZZPRKEY is determined from custom Ztable for provinces, while ZZDSKEY is determined from custom Z Table for Division and another z table determines values for district.
Each of these tables have primary foreign key relationship by which it is easier to determine province wise division wise districts in system.
Happy New Year and stay blessed.