Skip to Content
Technical Articles
Author's profile photo Gaurav Kumar Dhankhar

IS-U Master Data Template : Configurations

Introduction: –

Master Data Template is a tool used in IS-U industry to automate the data creation process. As a practical implementation of this tool, it is basically integrated with CRM system or any incoming document which would initiate the data creation process. However, this is also used by testers in order to create a new set of test data in the system.

Objective of this blog post is to provide end to end customization required in to initiate Master Data template processing. Before moving forward with the configurations, would request you to kindly go through the prerequisites required and assumptions in order to get the best out of this blog post.

Prerequisite: –

  • Basic understanding of IS-U Data Model: Business Master Data & Technical Master Data

IS-U Data Model Overview

  • Overview of Master Data Template

MDT Overview

Assumptions: –

  • For this configuration, internal test system is used and only mandatory fields in each node are configured. Therefore, it is possible that in your system, additional customization is done which may be mandatory to be supplied for successful operation.
  • IS-U Device containing single register is used.
  • MD Template used is NEWCUSTPOD

Configurations: –

In this blog post, 4 different Attribute categories are used: –

  1. Parameter – This service is used when either we want to create a new artifact in the system or we want use to already existing artifact in the system. When it is not filled while MDT execution, system will create a new artifact.
  2. Constant – This acts as a constant value supplied while executing the MDT. This is done when we want the system to use a value while creating the artifact.
  3. Key Reference – This is a non-editable service which links sub nodes with parent nodes. For example, Business Partner created in node Business partner will be used in the sub node Contract Account.
  4. Virtual – This is used when we want to generate a value at run-time.

The colors preceding the nodes denote the status of the node. They are as follows:

  • Green: Parameter assigned
  • Yellow: Parameter assigned several times
  • Grey: Parameter not yet assigned.

To begin with, let’s create a new master data template using the transaction EPRODCUST and MD Template Category as NEWCUSTPOD.

  • Business Partner configuration –

Click on Business Partner node and Activate the same.

Field Name Comments
PARTNER Parameter service is used so that in create mode, system generates a new BP number, in update mode, system uses the same BP number supplied
BU_GROUP This is used to define which number rage will be used to create new BP. You can get this value using existing IS-U BP number in the table BUT000
TYPE Type defines if the BP is a person, organization or a group
TITLE This defines Title for BP i.e. Mr., Ms., Company. Values are defined in master table TSAD3
NAME_FIRST Input Variable
NAME_LAST Input Variable
XSEXF Provide value ‘X’ to any one of the 3 variables.
XSEXM
XSEXU
  • Business Partner Address Data: –

Click on Business Partner Address Data node and activate the same.

For this node, apart from Country & Time Zone all the fields are Parameter as to take details in input.

  • Contract Account: –

Click on Contract Account node and activate the same.

For the below details, you can use an existing contract account using the transaction CAA3 or using the table FKKVKP

Field Name Comments
VKONT Parameter service is used so that in create mode, system generates a new Contract account number, in update mode, system uses the same CA number supplied
VKTYP Possible values are defined in master table TFK002A
GPART This field is non-editable and is associated to Business Partner node
VKBEZ Any text (Not mandatory)
TOGRU A tolerance group is assigned to a business partner in the master record of the contract account. Master Table: TFK043
VERTYP Used to determine clearing rules in Contract Accounts Receivable and Payable.Master Table TFK111
ZAHLKOND Defines rules for determining due dates. Tcode: OBB8
KTOKL Classification of contract accounts within a supply area. Master Table: KONTOKLASSE
KOFIZ_SD Characteristic used with company code, division, main transaction and (if required) sub-transaction to determine a G/L account. Master Table: TE097A
FORMKEY This represents the print program for Invoicing.
OPBUK This represents the company code defined in the system
STDBK This represents the company code defined in the system
MAHNV This defines the dunning procedure for outstanding items. Master Table: TFK047A
  • Device Info Record: –

Click on Device Info Record node and activate the same.

Field Name Comments
SERNR Parameter service is used so that in create mode, system generates a new serial number, in update mode, system uses the same serial number supplied
MATNR This is the corresponding device category to be used. Tcode – EG01
EQUNR Parameter service is used so that in create mode, system generates a equipment number, in update mode, system uses the same equipment number supplied
DIVISION Division to be used in Master Data creation
KEYDATE Date from which the device will be available for use.
HERST Manufacturer of Device (Not Mandatory)
TYPBZ Model Number (Not Mandatory)
ZWGRUPPE Register Group which defines no of registers in the device. Tcode – EG04
  • Create Register for Device Info Record: –

Click on the sub node under Device Info Record node and activate the same.

This node represents the corresponding register info in a device. Here, ZWNUMMER determines the register number in the register group. If a IS-U meter contains more than one register, this node will be repeated using “Duplicate Node” function and ZWNUMMER will be updated accordingly.

Here I have provided all the information as constant as I am aware of the existing register’s characteristics provided in the register group and do not require anything as an input.

  • Connection Object: –

Click on Connection Object node and activate the same.

  • Address for Connection Object 

Click on the sub node under Connection Object node and activate the same.

Here, as we want to have separate address for Connection Object and Business Partner therefore we have taken different parameters in comparison to  parameter variables mentioned in node Business Partner Address Data.

  • Premise

Click on the sub node under Connection Object node and activate the same.

  • Point of delivery

Click on the sub node under Premise node and activate the same.

Field Name Comments
DATEFROM This will define the date from which POD is valid
EXT_UI Our objective is to derive a unique name for POD, therefore we have used a custom FM ZPODNAME which is a copy of FM ISU_VIRT_ATTR_REGIO_DEMO
VSTELLE This will be derived from Premise node
GRID_ID Value for this parameter will be found in Master Table EGRID
GRID_LEVEL This defines the corresponding Grid level w.r.t. Grid ID
INT_UI This will be derived internally if no value is provided at the time of execution
UITYPE This will define the service provider for POD
UITEXT This is POD text (Not Mandatory)
  • Utility Installation 

Click on the sub node under Point of delivery node and activate the same.

  • Installation History 

Click on the sub node under Utility Installation node and activate the same.

Field Name Comments
AB Start date for Installation
AKLASSE Billing class to be used. Master Table EAKLASSE
TARIFTYP Rate category should have the same billing class given above. Tcode: EA53
ABLEINH MRU defines the scheduled meter reading date. Tcode E41H
  • Point of Delivery Within Utility Installation : 

This will have all the same information provided in the node Point of Delivery.

  • Install Device in Installation (Billing-Relevant) 

Activate the sub node under Utility Installation

It will use the same parameters as given in Device Register Info.

  • Install Register in Installation (Billing-Rel.) 

Activate this node according to the no. of registers.

Here, ZWNUMMMERE should be updated as per the corresponding register number in the device.

Rate type should have register permissibility.

  • Create Contract for Move-In 

Next node to activate is Create Contract for Move-in which is a sub node under Utility Installation .

Here GEMFAKT defines if this is a Joint invoicing Contract or not.
KOFIZ should have the same value as defined in Contract Account.

 

Execution: –

This tool will serve the purpose of both create and update.

For create mode, we will not fill any standard artifacts of IS-U system i.e. BP number, Installation number and system will automatically derive them.

upon execution we can see that below artifacts are created in the system

Also as we have activated the Move-In node, therefore contract is also created by the tool

The above configurations will help in successfully implementing the BMD and TMD artifacts in the system along with Contract creation.

Happy to have your feedback and suggestions.

Assigned Tags

      5 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Juan Sepulveda Diaz
      Juan Sepulveda Diaz

      Hi Gaurav.

      Thanks for very Nice Blog!!! In my current project i have a some business scenarios:

      1. In BPARTNER node, subnode BP_ADDRESS, be able to enable address class (BUT021_FS table ADR_KIND field).
      2. In BPARTNER node, be able to enable Fuction partner (BUT100 table RLTYP field

      In my current project we dont´n have integration with SAP CRM, we have integration with salesforce system and use th FM ISU_PRODUCT_IMPLEMENT to call MDT.

      I can do something with this tool or should i develop other FM?

      Thanks
      
      
      Author's profile photo Gaurav Kumar Dhankhar
      Gaurav Kumar Dhankhar
      Blog Post Author

      Hi Juan,

      This tool can only be implemented with the above FM that you have mentioned, therefore your implementation of this tool via a program is correct.

      For the business scenarios, as per my knowledge please find the below comments

      1. While creating a new Business Partner via MDT, “Address” tab is only taken into consideration, therefore we don’t have any node indicating the “Address Overview” tab in which Address usage field is defined. For this requirement I would suggest to use the FM BAPI_BUPA_ADDRESS_CHANGE post MDT execution by supplying the BP number generated in ISU_PRODUCT_IMPLEMENT FM’s execution.
      2. For all the Business Partners created via MDT will have the same role which is configured in SPRO for IS-U environment. This role indicates that the BP number is create in the IS-U environment. It is similar to create a BP using transaction FPP1, where there is no provision of changing the role.Therefore I believe you will not be able to change this field via MDT.

      Hope this answers your question.

      Regards,

      Gaurav

      Author's profile photo Juan Sepulveda Diaz
      Juan Sepulveda Diaz

      Hi Gaurav.

      Thanks for your response, I will try to do this functionality with FM.
      
      B.R

       

      Author's profile photo Dervis Celik
      Dervis Celik

      Hi Gaurav,

      Is it possible to assign external number for installation ?

      Author's profile photo Gaurav Kumar Dhankhar
      Gaurav Kumar Dhankhar
      Blog Post Author

      Hi Dervis Celik

      Yes we can, in the execution screen in front of ANLAGE you need to provide the external number.

      Regards,
      Gaurav