The SAP – ISU master data creation program is used to create the automatic master data with proper linking without going through the SAP standard transaction.
The typical flow of an ISU master data is outlined in the flow chart below.
As a standard, SAP has no option to create all the master data in single click.
For creating the ISU master data we have to go through different SAP standards screen to create master data and link them separately but through this program we can do all that in single click.
Also Read: SAP CRM Certification Preparation Guide
As creating the ISU master data needs the technical knowledge but through this code that complexity is reduced. Now we have to provide little information at the screen and we ready to create the master data in the ISU system.
Master Data Template (MDT) and Master Data Generator (MDG) are the common tools in IS-U to accelerate the data creation process. MDT allows you to allocate fixed values to fields in any given object. This enables you to create data with minimum data entry.
Creation of MDT
Go to transaction code:- ‘EPRODCUST’
Now provide the MD template name and MD template category and create.
All objects are deactivated during the initial creation.as below example
Activate the necessary Object Nodes that you want. The red dot indicates the services that needs to be defined for the specific activated node.
Maintain mandatory field as we have few options to define the node, mostly commonly used are Parameter & Constant are shown below. For key field (e.g. HAUS), always declare it as a Parameter in order to retrieve the object key after the execution.
Now after activating all the necessary node and maintaining the mandatory field and additional field of the activated node save the MDT and we are ready for the execution.
Now go back to the transaction code and provide the MD Template name and execute it.
Now pass the required value to the field.
After Passing the value click on ADOPT in application tool bar all the required data will get created.
Creating the ISU Device Data Through ABAP Program Using the MDT
Creation of Business Partner:
A business partner could be a person, an organization, a future customer, a contact person or even an installer who is licensed to provide the utilities services on behalf of the utility company.
For creating Business Partner we are using SAP Standard Function Module ‘BAPI_BUPA_CREATE_FROM_DATA’ and passing different values like partner category, partner group, partner personal data and partner address as mention below.
gs_centraldata-title_key = p_t_key. gs_centraldataperson-firstname = p_fname. gs_centraldataperson-lastname = p_lname. gs_address-city = p_city1. gs_address-country = p_cntry. gs_address-street = p_strt. gs_address-house_no = p_hs_no. gs_address-postl_cod1 = p_p_cod1. gv_partnergroup = p_pgroup. CALL FUNCTION ‘BAPI_BUPA_CREATE_FROM_DATA’ EXPORTING partnercategory = gc_person partnergroup = gv_partnergroup centraldata = gs_centraldata centraldataperson = gs_centraldataperson addressdata = gs_address IMPORTING businesspartner = gv_businesspartner TABLES return = gt_return.
After passing all the values we are going to pass the Business Partner role using the function module ‘BAPI_BUPA_ROLE_ADD_2’ with the other information like Business Partner number created earlier and business partner category as below.
CALL FUNCTION ‘BAPI_BUPA_ROLE_ADD_2’ EXPORTING businesspartner = gv_businesspartner businesspartnerrolecategory = gc_partnerrolecat businesspartnerrole = gc_partnerrole.
Now we are using the function module ‘BAPI_BUPA_CARDDETAIL_ADD’ to add the card details of the business partner by passing the card detail along with the business partner number.
CALL FUNCTION ‘BAPI_BUPA_BANKDETAIL_ADD’ EXPORTING businesspartner = gv_businesspartner * BANKDETAILID = bankdetaildata = gs_bankdetaildata IMPORTING bankdetailidout = gv_bankdetailid TABLES return = gt_return.
Now after successful completion of all the function module we have to commit the generated details at the database level by using the FM ‘BAPI_TRANSCATION_COMMIT’.
Using the MDT
We have to create one class which create the following methods like
Inside the method get_container we are passing the Field name and field value to the container and calling the method append_container to append those values to the container.
Now inside the mdt_call we are using the SAP standard function module ‘ISU_PRODUCT_IMPLEMENT’ and pass the MDT name ‘ZCO_MDT1’ and the Container value and also pass the table ‘lt_new_keys_tab’ to retrieve the generated technical master data at MDT level.
call function ‘ISU_PRODUCT_IMPLEMENT’ exporting x_prodid = lv_product_id x_container = lt_container changing xy_new_keys_tab = lt_new_keys_tab exceptions general_fault = 1 input_error = 2 ambiguous_environment = 3 others = 4.
Creating Move-In Document
Move-in document is the one when the customer moves into a location where the company has its services and he is ready to avail them, then a move-in document is created for him and billing is done based on that.
For creating the Move-In Document we are using the Function Module ‘BAPI_ISUMOVEIN_CREATEFROMDATA’ and passing all the required field necessary to create the move-in document like company code, division, account determination id and joint invoice.
CALL FUNCTION ‘BAPI_ISUMOVEIN_CREATEFROMDATA’ EXPORTING moveincreatecontroldata = gs_moveincreatecontroldata moveincreateinputdata = gs_moveincreateinputdata IMPORTING moveindocnumber = gv_moveindocnumber TABLES treturn = gt_return1 tcontractdata = gt_tcontractdata tcontractdatax = gt_tcontractdatax.
Now after doing all these coding, we are ready to execute our program. Here we have the screenshot of the above code ‘ZCO_ISU_DATA_CREATE’ .
Initial Screen of the Program.
Pass all the details in the field at the screen and execute.
As soon as all the fields are provided at the selection screen and the program is executed the end to end master data is created in the system and the result will be displayed at the screen in ALV mode.
ISU master data creation can be used by any client to obtain as many number of master data in the ISU system.