cancel
Showing results for 
Search instead for 
Did you mean: 

Mapping FlatStructure from FileAdapter to Hierarchical IDOC

Former Member
0 Kudos

We want to map the following FLAT-Structure to an Hierarchical IDOC-Structure


ZUECH_0210
recordset
    H1
    H2
    …
    H6
    D1  (1 to unbounded)
    D2  (1 to unbounded)
        Meterno1
    D3  (1 to unbounded)
         Q1
    D3
         Q2
    D2
       Meterno2
    D3
        Q1
    D3
        Q2
    D3
        Q3
/recordset

IDOC_ZUECH_210
  IDOC
       HEADER
             H1
             H2
             ….
             H6
        /HEADER
        D1  (1:1)
             D2 (1:99)
                 D3 (1:99)
    /IDOC

We tried D3 splitbyvalue to D3 => below D2 there is only one D3 mapped?

Any ideas how to keep the values from D3 below the according D2?

We went through

http://help.sap.com/saphelp_nw70/helpdata/en/ab/bdb13b00ae793be10000000a11402f/frameset.htm.

It didn't help us very much

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

To Implement this type of mapping you need to write user define function.

Also explain what is a relationship between D1, D2 and D3.

Your UDF should take primary fields as input from current and upper level structure. compare fields and should decide the level.

Gaurav Jain

Former Member
0 Kudos

The message contains metering data

D1=PoD (Point of Delivery which can have multiple meterno )

D2=MeterNo

D3=QuantityData per MeterNo

Is there no change without a UDF?

Answers (2)

Answers (2)

Former Member
0 Kudos

Thanks Sarvesh, but as I already told you the input xml ist produced by the filedadapter and I can not delete the second d2. This content is correct and important. The D1 has multiple meters in this case two.

The flat file (input for the fileadapter) is as follows:

#H1 210

#H2 ECH210_20070710_126757625.dat

#H3 20070710_0800

#H4 9.0

#H5 8712423010208

#H6 8717154940022

#MEDTD1 MN00001 TEST 873456789012345678E03200708062007080620070806035423 871687900000410000000000000000000

#MEDTD2 1234 2

#MEDTD3 2000 22020070806368KWHE1190 6

#MEDTD3 1500 22020070806368KWHE1090 6

#MEDTD2 4567 2

#MEDTD3 2927 22020070321367KWHE1090 6

#MEDTD3 2230 22020070321367KWHE1190 6

#MEDTD1 MN00002 TEST 873456789012345678E03200708062007080620070806035423 871687900000410000000000000000000

#MEDTD2 8912 2

#MEDTD3 2000 22020070806368KWHE1190 6

#MEDTD3 1500 22020070806368KWHE1090 6

#F1 15

Former Member
0 Kudos

Marlies,

Your flat structure is wrong, you can not have/create in multiple fields with same name e.g. D2 & D3.

Send the exact source structue, target structure and desired result.

One more thing if H1,H2,H3....H6 are your headers then this is also wrong, as per my understanding there should be only one Header per IDOC.

Former Member
0 Kudos

Sorry Sarvesh, but the input structure is produced by the fileadapter.

should I send you the source structure and target structure via Email, then I need your email adress

Former Member
0 Kudos

If possible send it here.

Regards,

Former Member
0 Kudos

Here the <b>source structure</b>


<?xml version="1.0" encoding="UTF-8"?>
<!-- edited with XMLSpy v2007 (http://www.altova.com) by d2k (-) -->
<!--W3C Schema generated by XMLSpy v2007 (http://www.altova.com)-->
<xs:schema xmlns:xs="http://www.w3.org/2001/XMLSchema" targetNamespace="urn:rwe-nl:xi:interfaces_ext:global">
	<xs:element name="ZUECH_0210">
		<xs:complexType>
			<xs:sequence>
				<xs:element name="recordset" maxOccurs="unbounded">
					<xs:complexType>
						<xs:sequence>
							<xs:element name="H1">
								<xs:complexType>
									<xs:sequence>
										<xs:element name="KH1" type="xs:string"/>
										<xs:element name="H1" type="xs:string"/>
									</xs:sequence>
								</xs:complexType>
							</xs:element>
							<xs:element name="H2">
								<xs:complexType>
									<xs:sequence>
										<xs:element name="KH2" type="xs:string"/>
										<xs:element name="H2" type="xs:string"/>
									</xs:sequence>
								</xs:complexType>
							</xs:element>
							<xs:element name="H3">
								<xs:complexType>
									<xs:sequence>
										<xs:element name="KH3" type="xs:string"/>
										<xs:element name="H3" type="xs:string"/>
									</xs:sequence>
								</xs:complexType>
							</xs:element>
							<xs:element name="H4">
								<xs:complexType>
									<xs:sequence>
										<xs:element name="KH4" type="xs:string"/>
										<xs:element name="H4" type="xs:string"/>
									</xs:sequence>
								</xs:complexType>
							</xs:element>
							<xs:element name="H5">
								<xs:complexType>
									<xs:sequence>
										<xs:element name="KH5" type="xs:string"/>
										<xs:element name="H5" type="xs:string"/>
									</xs:sequence>
								</xs:complexType>
							</xs:element>
							<xs:element name="H6">
								<xs:complexType>
									<xs:sequence>
										<xs:element name="KH6" type="xs:string"/>
										<xs:element name="H6" type="xs:string"/>
									</xs:sequence>
								</xs:complexType>
							</xs:element>
							<xs:element name="MEDTD1" maxOccurs="unbounded">
								<xs:complexType>
									<xs:sequence>
										<xs:element name="KMEDTD1" type="xs:string"/>
										<xs:element name="REQUEST_ID" type="xs:string"/>
										<xs:element name="TRANSACTION_ID" type="xs:string"/>
										<xs:element name="CONNECT_EAN" type="xs:string"/>
										<xs:element name="REASON_ID" type="xs:string"/>
										<xs:element name="PERIOD_STARTDATE" type="xs:string"/>
										<xs:element name="PERIOD_ENDDATE" type="xs:string"/>
										<xs:element name="SUBMITTED_DATE" type="xs:string"/>
										<xs:element name="MARKET_SEGMENT" type="xs:string"/>
										<xs:element name="NETOP_EAN" type="xs:string"/>
										<xs:element name="REQUEST_REFERENCE" type="xs:string"/>
									</xs:sequence>
								</xs:complexType>
							</xs:element>
							<xs:element name="MEDTD2" maxOccurs="unbounded">
								<xs:complexType>
									<xs:sequence>
										<xs:element name="KMEDTD2" type="xs:string"/>
										<xs:element name="METERNO" type="xs:string"/>
										<xs:element name="NO_DIALS" type="xs:string"/>
									</xs:sequence>
								</xs:complexType>
							</xs:element>
							<xs:element name="MEDTD3" maxOccurs="unbounded">
								<xs:complexType>
									<xs:sequence>
										<xs:element name="KMEDTD3" type="xs:string"/>
										<xs:element name="QUANTITY" type="xs:string"/>
										<xs:element name="QUANTITY_TYPE_ID" type="xs:string"/>
										<xs:element name="QUANTITY_DATE" type="xs:string"/>
										<xs:element name="QUANTITY_DATE_TYPE" type="xs:string"/>
										<xs:element name="MEASURE_UNIT_ID" type="xs:string"/>
										<xs:element name="TIMEFRAME_ID" type="xs:string"/>
										<xs:element name="QUALIFICATION" type="xs:string"/>
										<xs:element name="NO_DIGITS" type="xs:string"/>
									</xs:sequence>
								</xs:complexType>
							</xs:element>
							<xs:element name="F1">
								<xs:complexType>
									<xs:sequence>
										<xs:element name="KF1" type="xs:string"/>
										<xs:element name="F1" type="xs:string"/>
									</xs:sequence>
								</xs:complexType>
							</xs:element>
						</xs:sequence>
					</xs:complexType>
				</xs:element>
			</xs:sequence>
		</xs:complexType>
	</xs:element>
</xs:schema>

And here the <b>Target Structure</b> of the IDOC


<?xml version="1.0" encoding="UTF-8"?>
<xsd:schema xmlns:xsd="http://www.w3.org/2001/XMLSchema">
	<xsd:element name="ZUECH_0210">
		<xsd:complexType>
			<xsd:sequence>
				<xsd:element name="IDOC" type="ZUECH_0210.ZUECH_0210" maxOccurs="unbounded"/>
			</xsd:sequence>
		</xsd:complexType>
	</xsd:element>
	<xsd:complexType name="EDI_DC40.ZUECH_0210.ZUECH_0210">
		<xsd:sequence>
			<xsd:element name="TABNAM" type="xsd:string" fixed="EDI_DC40">
				<xsd:annotation>
					<xsd:documentation>Table Structure Name</xsd:documentation>
				</xsd:annotation>
			</xsd:element>
			<xsd:element name="MANDT" minOccurs="0">
				<xsd:annotation>
					<xsd:documentation>Client</xsd:documentation>
				</xsd:annotation>
				<xsd:simpleType>
					<xsd:restriction base="xsd:string">
						<xsd:maxLength value="3"/>
					</xsd:restriction>
				</xsd:simpleType>
			</xsd:element>
			<xsd:element name="DOCNUM" minOccurs="0">
				<xsd:annotation>
					<xsd:documentation>IDoc Number</xsd:documentation>
				</xsd:annotation>
				<xsd:simpleType>
					<xsd:restriction base="xsd:string">
						<xsd:maxLength value="16"/>
					</xsd:restriction>
				</xsd:simpleType>
			</xsd:element>
			<xsd:element name="DOCREL" minOccurs="0">
				<xsd:annotation>
					<xsd:documentation>SAP IDoc Release</xsd:documentation>
				</xsd:annotation>
				<xsd:simpleType>
					<xsd:restriction base="xsd:string">
						<xsd:maxLength value="4"/>
					</xsd:restriction>
				</xsd:simpleType>
			</xsd:element>
			<xsd:element name="STATUS" minOccurs="0">
				<xsd:annotation>
					<xsd:documentation>IDoc Status</xsd:documentation>
				</xsd:annotation>
				<xsd:simpleType>
					<xsd:restriction base="xsd:string">
						<xsd:maxLength value="2"/>
					</xsd:restriction>
				</xsd:simpleType>
			</xsd:element>
			<xsd:element name="DIRECT">
				<xsd:annotation>
					<xsd:documentation>Direction</xsd:documentation>
				</xsd:annotation>
				<xsd:simpleType>
					<xsd:restriction base="xsd:string">
						<xsd:enumeration value="1">
							<xsd:annotation>
								<xsd:documentation>Outbound</xsd:documentation>
							</xsd:annotation>
						</xsd:enumeration>
						<xsd:enumeration value="2">
							<xsd:annotation>
								<xsd:documentation>Inbound</xsd:documentation>
							</xsd:annotation>
						</xsd:enumeration>
					</xsd:restriction>
				</xsd:simpleType>
			</xsd:element>
			<xsd:element name="OUTMOD" minOccurs="0">
				<xsd:annotation>
					<xsd:documentation>Output Mode</xsd:documentation>
				</xsd:annotation>
				<xsd:simpleType>
					<xsd:restriction base="xsd:string">
						<xsd:maxLength value="1"/>
					</xsd:restriction>
				</xsd:simpleType>
			</xsd:element>
			<xsd:element name="EXPRSS" minOccurs="0">
				<xsd:annotation>
					<xsd:documentation>Overriding in Inbound Processing</xsd:documentation>
				</xsd:annotation>
				<xsd:simpleType>
					<xsd:restriction base="xsd:string">
						<xsd:maxLength value="1"/>
					</xsd:restriction>
				</xsd:simpleType>
			</xsd:element>
			<xsd:element name="TEST" minOccurs="0">
				<xsd:annotation>
					<xsd:documentation>Test Flag</xsd:documentation>
				</xsd:annotation>
				<xsd:simpleType>
					<xsd:restriction base="xsd:string">
						<xsd:maxLength value="1"/>
					</xsd:restriction>
				</xsd:simpleType>
			</xsd:element>
			<xsd:element name="IDOCTYP" type="xsd:string" fixed="ZUECH_0210">
				<xsd:annotation>
					<xsd:documentation>Basic Type Name</xsd:documentation>
				</xsd:annotation>
			</xsd:element>
			<xsd:element name="CIMTYP" minOccurs="0">
				<xsd:annotation>
					<xsd:documentation>Enhancement (Customer-Defined)</xsd:documentation>
				</xsd:annotation>
				<xsd:simpleType>
					<xsd:restriction base="xsd:string">
						<xsd:maxLength value="30"/>
					</xsd:restriction>
				</xsd:simpleType>
			</xsd:element>
			<xsd:element name="MESTYP" type="xsd:string" fixed="ZUECH_0210">
				<xsd:annotation>
					<xsd:documentation>Message Type</xsd:documentation>
				</xsd:annotation>
			</xsd:element>
			<xsd:element name="MESCOD" minOccurs="0">
				<xsd:annotation>
					<xsd:documentation>Message Variant</xsd:documentation>
				</xsd:annotation>
				<xsd:simpleType>
					<xsd:restriction base="xsd:string">
						<xsd:maxLength value="3"/>
					</xsd:restriction>
				</xsd:simpleType>
			</xsd:element>
			<xsd:element name="MESFCT" minOccurs="0">
				<xsd:annotation>
					<xsd:documentation>Message Function</xsd:documentation>
				</xsd:annotation>
				<xsd:simpleType>
					<xsd:restriction base="xsd:string">
						<xsd:maxLength value="3"/>
					</xsd:restriction>
				</xsd:simpleType>
			</xsd:element>
			<xsd:element name="STD" minOccurs="0">
				<xsd:annotation>
					<xsd:documentation>EDI Standard, Flag</xsd:documentation>
				</xsd:annotation>
				<xsd:simpleType>
					<xsd:restriction base="xsd:string">
						<xsd:maxLength value="1"/>
					</xsd:restriction>
				</xsd:simpleType>
			</xsd:element>
			<xsd:element name="STDVRS" minOccurs="0">
				<xsd:annotation>
					<xsd:documentation>EDI Standard, Version, and Release</xsd:documentation>
				</xsd:annotation>
				<xsd:simpleType>
					<xsd:restriction base="xsd:string">
						<xsd:maxLength value="6"/>
					</xsd:restriction>
				</xsd:simpleType>
			</xsd:element>
			<xsd:element name="STDMES" minOccurs="0">
				<xsd:annotation>
					<xsd:documentation>EDI Message Type</xsd:documentation>
				</xsd:annotation>
				<xsd:simpleType>
					<xsd:restriction base="xsd:string">
						<xsd:maxLength value="6"/>
					</xsd:restriction>
				</xsd:simpleType>
			</xsd:element>
			<xsd:element name="SNDPOR">
				<xsd:annotation>
					<xsd:documentation>Sender Port (SAP System, External Subsystem)</xsd:documentation>
				</xsd:annotation>
				<xsd:simpleType>
					<xsd:restriction base="xsd:string">
						<xsd:maxLength value="10"/>
					</xsd:restriction>
				</xsd:simpleType>
			</xsd:element>
			<xsd:element name="SNDPRT">
				<xsd:annotation>
					<xsd:documentation>Sender Partner Type</xsd:documentation>
				</xsd:annotation>
				<xsd:simpleType>
					<xsd:restriction base="xsd:string">
						<xsd:maxLength value="2"/>
					</xsd:restriction>
				</xsd:simpleType>
			</xsd:element>
			<xsd:element name="SNDPFC" minOccurs="0">
				<xsd:annotation>
					<xsd:documentation>Sender Partner Function</xsd:documentation>
				</xsd:annotation>
				<xsd:simpleType>
					<xsd:restriction base="xsd:string">
						<xsd:maxLength value="2"/>
					</xsd:restriction>
				</xsd:simpleType>
			</xsd:element>
			<xsd:element name="SNDPRN">
				<xsd:annotation>
					<xsd:documentation>Sender Partner Number</xsd:documentation>
				</xsd:annotation>
				<xsd:simpleType>
					<xsd:restriction base="xsd:string">
						<xsd:maxLength value="10"/>
					</xsd:restriction>
				</xsd:simpleType>
			</xsd:element>
			<xsd:element name="SNDSAD" minOccurs="0">
				<xsd:annotation>
					<xsd:documentation>Sender Address (SADR)</xsd:documentation>
				</xsd:annotation>
				<xsd:simpleType>
					<xsd:restriction base="xsd:string">
						<xsd:maxLength value="21"/>
					</xsd:restriction>
				</xsd:simpleType>
			</xsd:element>
			<xsd:element name="SNDLAD" minOccurs="0">
				<xsd:annotation>
					<xsd:documentation>Logical Sender Address</xsd:documentation>
				</xsd:annotation>
				<xsd:simpleType>
					<xsd:restriction base="xsd:string">
						<xsd:maxLength value="70"/>
					</xsd:restriction>
				</xsd:simpleType>
			</xsd:element>
			<xsd:element name="RCVPOR">
				<xsd:annotation>
					<xsd:documentation>Receiver Port</xsd:documentation>
				</xsd:annotation>
				<xsd:simpleType>
					<xsd:restriction base="xsd:string">
						<xsd:maxLength value="10"/>
					</xsd:restriction>
				</xsd:simpleType>
			</xsd:element>
			<xsd:element name="RCVPRT" minOccurs="0">
				<xsd:annotation>
					<xsd:documentation>Receiver Partner Type</xsd:documentation>
				</xsd:annotation>
				<xsd:simpleType>
					<xsd:restriction base="xsd:string">
						<xsd:maxLength value="2"/>
					</xsd:restriction>
				</xsd:simpleType>
			</xsd:element>
			<xsd:element name="RCVPFC" minOccurs="0">
				<xsd:annotation>
					<xsd:documentation>Receiver Partner Function</xsd:documentation>
				</xsd:annotation>
				<xsd:simpleType>
					<xsd:restriction base="xsd:string">
						<xsd:maxLength value="2"/>
					</xsd:restriction>
				</xsd:simpleType>
			</xsd:element>
			<xsd:element name="RCVPRN">
				<xsd:annotation>
					<xsd:documentation>Receiver Partner Number</xsd:documentation>
				</xsd:annotation>
				<xsd:simpleType>
					<xsd:restriction base="xsd:string">
						<xsd:maxLength value="10"/>
					</xsd:restriction>
				</xsd:simpleType>
			</xsd:element>
			<xsd:element name="RCVSAD" minOccurs="0">
				<xsd:annotation>
					<xsd:documentation>Receiver Address (SADR)</xsd:documentation>
				</xsd:annotation>
				<xsd:simpleType>
					<xsd:restriction base="xsd:string">
						<xsd:maxLength value="21"/>
					</xsd:restriction>
				</xsd:simpleType>
			</xsd:element>
			<xsd:element name="RCVLAD" minOccurs="0">
				<xsd:annotation>
					<xsd:documentation>Logical Receiver Address</xsd:documentation>
				</xsd:annotation>
				<xsd:simpleType>
					<xsd:restriction base="xsd:string">
						<xsd:maxLength value="70"/>
					</xsd:restriction>
				</xsd:simpleType>
			</xsd:element>
			<xsd:element name="CREDAT" minOccurs="0">
				<xsd:annotation>
					<xsd:documentation>Creation Date</xsd:documentation>
				</xsd:annotation>
				<xsd:simpleType>
					<xsd:restriction base="xsd:string">
						<xsd:maxLength value="8"/>
					</xsd:restriction>
				</xsd:simpleType>
			</xsd:element>
			<xsd:element name="CRETIM" minOccurs="0">
				<xsd:annotation>
					<xsd:documentation>Creation Time</xsd:documentation>
				</xsd:annotation>
				<xsd:simpleType>
					<xsd:restriction base="xsd:string">
						<xsd:maxLength value="6"/>
					</xsd:restriction>
				</xsd:simpleType>
			</xsd:element>
			<xsd:element name="REFINT" minOccurs="0">
				<xsd:annotation>
					<xsd:documentation>Interchange File (EDI Interchange)</xsd:documentation>
				</xsd:annotation>
				<xsd:simpleType>
					<xsd:restriction base="xsd:string">
						<xsd:maxLength value="14"/>
					</xsd:restriction>
				</xsd:simpleType>
			</xsd:element>
			<xsd:element name="REFGRP" minOccurs="0">
				<xsd:annotation>
					<xsd:documentation>Message Group (EDI Message Group)</xsd:documentation>
				</xsd:annotation>
				<xsd:simpleType>
					<xsd:restriction base="xsd:string">
						<xsd:maxLength value="14"/>
					</xsd:restriction>
				</xsd:simpleType>
			</xsd:element>
			<xsd:element name="REFMES" minOccurs="0">
				<xsd:annotation>
					<xsd:documentation>Message (EDI Message)</xsd:documentation>
				</xsd:annotation>
				<xsd:simpleType>
					<xsd:restriction base="xsd:string">
						<xsd:maxLength value="14"/>
					</xsd:restriction>
				</xsd:simpleType>
			</xsd:element>
			<xsd:element name="ARCKEY" minOccurs="0">
				<xsd:annotation>
					<xsd:documentation>External Message Archive Key</xsd:documentation>
				</xsd:annotation>
				<xsd:simpleType>
					<xsd:restriction base="xsd:string">
						<xsd:maxLength value="70"/>
					</xsd:restriction>
				</xsd:simpleType>
			</xsd:element>
			<xsd:element name="SERIAL" minOccurs="0">
				<xsd:annotation>
					<xsd:documentation>Serialization</xsd:documentation>
				</xsd:annotation>
				<xsd:simpleType>
					<xsd:restriction base="xsd:string">
						<xsd:maxLength value="20"/>
					</xsd:restriction>
				</xsd:simpleType>
			</xsd:element>
		</xsd:sequence>
		<xsd:attribute name="SEGMENT" type="xsd:string" use="required" fixed="1"/>
	</xsd:complexType>
	<xsd:complexType name="ZUECH_0210._-RWENL_-U_MEDTD2">
		<xsd:annotation>
			<xsd:documentation>MEDTD2</xsd:documentation>
		</xsd:annotation>
		<xsd:sequence>
			<xsd:element name="METERNO" minOccurs="0">
				<xsd:annotation>
					<xsd:documentation>MeterNo</xsd:documentation>
				</xsd:annotation>
				<xsd:simpleType>
					<xsd:restriction base="xsd:string">
						<xsd:maxLength value="18"/>
					</xsd:restriction>
				</xsd:simpleType>
			</xsd:element>
			<xsd:element name="NO_DIALS" minOccurs="0">
				<xsd:annotation>
					<xsd:documentation>No_Dials</xsd:documentation>
				</xsd:annotation>
				<xsd:simpleType>
					<xsd:restriction base="xsd:string">
						<xsd:maxLength value="2"/>
					</xsd:restriction>
				</xsd:simpleType>
			</xsd:element>
			<xsd:element name="_-RWENL_-U_MEDTD3" type="ZUECH_0210._-RWENL_-U_MEDTD3" maxOccurs="99"/>
		</xsd:sequence>
		<xsd:attribute name="SEGMENT" type="xsd:string" use="required" fixed="1"/>
	</xsd:complexType>
	<xsd:complexType name="ZUECH_0210._-RWENL_-U_EDSN_HEADER">
		<xsd:annotation>
			<xsd:documentation>EDSN Header information</xsd:documentation>
		</xsd:annotation>
		<xsd:sequence>
			<xsd:element name="H1" minOccurs="0">
				<xsd:annotation>
					<xsd:documentation>Not More Closely Defined Area, Possibly Used for Patchlevels</xsd:documentation>
				</xsd:annotation>
				<xsd:simpleType>
					<xsd:restriction base="xsd:string">
						<xsd:maxLength value="4"/>
					</xsd:restriction>
				</xsd:simpleType>
			</xsd:element>
			<xsd:element name="H2" minOccurs="0">
				<xsd:annotation>
					<xsd:documentation>Character 100</xsd:documentation>
				</xsd:annotation>
				<xsd:simpleType>
					<xsd:restriction base="xsd:string">
						<xsd:maxLength value="100"/>
					</xsd:restriction>
				</xsd:simpleType>
			</xsd:element>
			<xsd:element name="H3" minOccurs="0">
				<xsd:annotation>
					<xsd:documentation>Character field 13 digits</xsd:documentation>
				</xsd:annotation>
				<xsd:simpleType>
					<xsd:restriction base="xsd:string">
						<xsd:maxLength value="13"/>
					</xsd:restriction>
				</xsd:simpleType>
			</xsd:element>
			<xsd:element name="H4" minOccurs="0">
				<xsd:annotation>
					<xsd:documentation>Character Field Length = 10</xsd:documentation>
				</xsd:annotation>
				<xsd:simpleType>
					<xsd:restriction base="xsd:string">
						<xsd:maxLength value="10"/>
					</xsd:restriction>
				</xsd:simpleType>
			</xsd:element>
			<xsd:element name="H5" minOccurs="0">
				<xsd:annotation>
					<xsd:documentation>Supplier_EAN</xsd:documentation>
				</xsd:annotation>
				<xsd:simpleType>
					<xsd:restriction base="xsd:string">
						<xsd:maxLength value="13"/>
					</xsd:restriction>
				</xsd:simpleType>
			</xsd:element>
			<xsd:element name="H6" minOccurs="0">
				<xsd:annotation>
					<xsd:documentation>Supplier_EAN</xsd:documentation>
				</xsd:annotation>
				<xsd:simpleType>
					<xsd:restriction base="xsd:string">
						<xsd:maxLength value="13"/>
					</xsd:restriction>
				</xsd:simpleType>
			</xsd:element>
		</xsd:sequence>
		<xsd:attribute name="SEGMENT" type="xsd:string" use="required" fixed="1"/>
	</xsd:complexType>
	<xsd:complexType name="ZUECH_0210.ZUECH_0210">
		<xsd:annotation>
			<xsd:documentation>Received Metered data E</xsd:documentation>
		</xsd:annotation>
		<xsd:sequence>
			<xsd:element name="EDI_DC40" type="EDI_DC40.ZUECH_0210.ZUECH_0210"/>
			<xsd:element name="_-RWENL_-U_EDSN_HEADER" type="ZUECH_0210._-RWENL_-U_EDSN_HEADER"/>
			<xsd:element name="_-RWENL_-U_MEDTD1" type="ZUECH_0210._-RWENL_-U_MEDTD1"/>
		</xsd:sequence>
		<xsd:attribute name="BEGIN" type="xsd:string" use="required" fixed="1"/>
	</xsd:complexType>
	<xsd:complexType name="ZUECH_0210._-RWENL_-U_MEDTD3">
		<xsd:annotation>
			<xsd:documentation>MEDTD3</xsd:documentation>
		</xsd:annotation>
		<xsd:sequence>
			<xsd:element name="QUANTITY" minOccurs="0">
				<xsd:annotation>
					<xsd:documentation>Quantity</xsd:documentation>
				</xsd:annotation>
				<xsd:simpleType>
					<xsd:restriction base="xsd:string">
						<xsd:maxLength value="15"/>
					</xsd:restriction>
				</xsd:simpleType>
			</xsd:element>
			<xsd:element name="QUANTITY_TYPE_ID" minOccurs="0">
				<xsd:annotation>
					<xsd:documentation>Quantity_Type_ID</xsd:documentation>
				</xsd:annotation>
				<xsd:simpleType>
					<xsd:restriction base="xsd:string">
						<xsd:maxLength value="3"/>
					</xsd:restriction>
				</xsd:simpleType>
			</xsd:element>
			<xsd:element name="QUANTITY_DATE" minOccurs="0">
				<xsd:annotation>
					<xsd:documentation>Quantity_Date</xsd:documentation>
				</xsd:annotation>
				<xsd:simpleType>
					<xsd:restriction base="xsd:string">
						<xsd:maxLength value="8"/>
					</xsd:restriction>
				</xsd:simpleType>
			</xsd:element>
			<xsd:element name="QUANTITY_DATE_TYPE" minOccurs="0">
				<xsd:annotation>
					<xsd:documentation>Quantity_Date_Type</xsd:documentation>
				</xsd:annotation>
				<xsd:simpleType>
					<xsd:restriction base="xsd:string">
						<xsd:maxLength value="3"/>
					</xsd:restriction>
				</xsd:simpleType>
			</xsd:element>
			<xsd:element name="MEASURE_UNIT_ID" minOccurs="0">
				<xsd:annotation>
					<xsd:documentation>Measure_Unit_ID</xsd:documentation>
				</xsd:annotation>
				<xsd:simpleType>
					<xsd:restriction base="xsd:string">
						<xsd:maxLength value="3"/>
					</xsd:restriction>
				</xsd:simpleType>
			</xsd:element>
			<xsd:element name="TIMEFRAME_ID" minOccurs="0">
				<xsd:annotation>
					<xsd:documentation>TimeFrame_ID</xsd:documentation>
				</xsd:annotation>
				<xsd:simpleType>
					<xsd:restriction base="xsd:string">
						<xsd:maxLength value="3"/>
					</xsd:restriction>
				</xsd:simpleType>
			</xsd:element>
			<xsd:element name="QUALIFICATION" minOccurs="0">
				<xsd:annotation>
					<xsd:documentation>Qualification</xsd:documentation>
				</xsd:annotation>
				<xsd:simpleType>
					<xsd:restriction base="xsd:string">
						<xsd:maxLength value="3"/>
					</xsd:restriction>
				</xsd:simpleType>
			</xsd:element>
			<xsd:element name="NO_DIGITS" minOccurs="0">
				<xsd:annotation>
					<xsd:documentation>No_Digits</xsd:documentation>
				</xsd:annotation>
				<xsd:simpleType>
					<xsd:restriction base="xsd:string">
						<xsd:maxLength value="2"/>
					</xsd:restriction>
				</xsd:simpleType>
			</xsd:element>
		</xsd:sequence>
		<xsd:attribute name="SEGMENT" type="xsd:string" use="required" fixed="1"/>
	</xsd:complexType>
	<xsd:complexType name="ZUECH_0210._-RWENL_-U_MEDTD1">
		<xsd:annotation>
			<xsd:documentation>MEDTD1</xsd:documentation>
		</xsd:annotation>
		<xsd:sequence>
			<xsd:element name="REQUEST_ID" minOccurs="0">
				<xsd:annotation>
					<xsd:documentation>Request_ID</xsd:documentation>
				</xsd:annotation>
				<xsd:simpleType>
					<xsd:restriction base="xsd:string">
						<xsd:maxLength value="10"/>
					</xsd:restriction>
				</xsd:simpleType>
			</xsd:element>
			<xsd:element name="TRANSACTION_ID" minOccurs="0">
				<xsd:annotation>
					<xsd:documentation>Transaction_ID</xsd:documentation>
				</xsd:annotation>
				<xsd:simpleType>
					<xsd:restriction base="xsd:string">
						<xsd:maxLength value="10"/>
					</xsd:restriction>
				</xsd:simpleType>
			</xsd:element>
			<xsd:element name="CONNECT_EAN" minOccurs="0">
				<xsd:annotation>
					<xsd:documentation>Connect_EAN</xsd:documentation>
				</xsd:annotation>
				<xsd:simpleType>
					<xsd:restriction base="xsd:string">
						<xsd:maxLength value="18"/>
					</xsd:restriction>
				</xsd:simpleType>
			</xsd:element>
			<xsd:element name="REASON_ID" minOccurs="0">
				<xsd:annotation>
					<xsd:documentation>Reason_ID</xsd:documentation>
				</xsd:annotation>
				<xsd:simpleType>
					<xsd:restriction base="xsd:string">
						<xsd:maxLength value="3"/>
					</xsd:restriction>
				</xsd:simpleType>
			</xsd:element>
			<xsd:element name="PERIOD_STARTDATE" minOccurs="0">
				<xsd:annotation>
					<xsd:documentation>Period Startdate</xsd:documentation>
				</xsd:annotation>
				<xsd:simpleType>
					<xsd:restriction base="xsd:string">
						<xsd:maxLength value="8"/>
					</xsd:restriction>
				</xsd:simpleType>
			</xsd:element>
			<xsd:element name="PERIOD_ENDDATE" minOccurs="0">
				<xsd:annotation>
					<xsd:documentation>Requested_MR_End_Date</xsd:documentation>
				</xsd:annotation>
				<xsd:simpleType>
					<xsd:restriction base="xsd:string">
						<xsd:maxLength value="8"/>
					</xsd:restriction>
				</xsd:simpleType>
			</xsd:element>
			<xsd:element name="SUBMITTED_DATE" minOccurs="0">
				<xsd:annotation>
					<xsd:documentation>Submitted_date</xsd:documentation>
				</xsd:annotation>
				<xsd:simpleType>
					<xsd:restriction base="xsd:string">
						<xsd:maxLength value="12"/>
					</xsd:restriction>
				</xsd:simpleType>
			</xsd:element>
			<xsd:element name="MARKET_SEGMENT" minOccurs="0">
				<xsd:annotation>
					<xsd:documentation>Market_Segment</xsd:documentation>
				</xsd:annotation>
				<xsd:simpleType>
					<xsd:restriction base="xsd:string">
						<xsd:maxLength value="3"/>
					</xsd:restriction>
				</xsd:simpleType>
			</xsd:element>
			<xsd:element name="NETOP_EAN" minOccurs="0">
				<xsd:annotation>
					<xsd:documentation>NetOp EAN</xsd:documentation>
				</xsd:annotation>
				<xsd:simpleType>
					<xsd:restriction base="xsd:string">
						<xsd:maxLength value="13"/>
					</xsd:restriction>
				</xsd:simpleType>
			</xsd:element>
			<xsd:element name="REQUEST_REFERENCE" minOccurs="0">
				<xsd:annotation>
					<xsd:documentation>Request_Reference</xsd:documentation>
				</xsd:annotation>
				<xsd:simpleType>
					<xsd:restriction base="xsd:string">
						<xsd:maxLength value="25"/>
					</xsd:restriction>
				</xsd:simpleType>
			</xsd:element>
			<xsd:element name="_-RWENL_-U_MEDTD2" type="ZUECH_0210._-RWENL_-U_MEDTD2" maxOccurs="99"/>
		</xsd:sequence>
		<xsd:attribute name="SEGMENT" type="xsd:string" use="required" fixed="1"/>
	</xsd:complexType>
</xsd:schema>

Former Member
0 Kudos

Can you give me example of your desired output?? Or how do you want to map it?

Former Member
0 Kudos

If the

source

is like this

ZUECH_0210
recordset
    H1
    H2
    …
    H6
    D1  
    D2  
        Meterno1
    D3  
         Q11
    D3
         Q12
    D2
       Meterno2
    D3
        Q21
    D3
        Q22
    D3
        Q23
/recordset

The

Target should

be


IDOC_ZUECH_210
  IDOC
       HEADER
             H1
             H2
             ….
             H6
        /HEADER
        D1  
             D2 
                  MeterNo1
                        D3 
                            Q11
                        D3 
                            Q12
             D2 
                  MeterNo2
                        D3 
                            Q21
                        D3 
                            Q22
                        D3 
                            Q23
    /IDOC

And here an

complete example

for the source xml


<?xml version="1.0" encoding="utf-8"?>
<ns:ZUECH_0210 xmlns:ns="urn:rwe-nl:xi:interfaces_ext:global">
<recordset>
	<H1>
		<KH1>#H1</KH1>
		<H1>210</H1>
	</H1>
	<H2>
		<KH2>#H2</KH2>
		<H2>ECH210_20070710_126757625.dat</H2>
	</H2>
	<H3>
		<KH3>#H3</KH3>
		<H3>20070710_0800</H3>
	</H3>
	<H4>
		<KH4>#H4</KH4>
		<H4>9.0</H4>
	</H4>
	<H5>
		<KH5>#H5</KH5>
		<H5>8712423010208</H5>
	</H5>
	<H6>
		<KH6>#H6</KH6>
		<H6>8717154940022</H6>
	</H6>
	<MEDTD1>
		<KMEDTD1>#MEDTD1</KMEDTD1>
		<REQUEST_ID>MN00001</REQUEST_ID>
		<TRANSACTION_ID>TEST</TRANSACTION_ID>
		<CONNECT_EAN>873456789012345678</CONNECT_EAN>
		<REASON_ID>E03</REASON_ID>
		<PERIOD_STARTDATE>20070806</PERIOD_STARTDATE>
		<PERIOD_ENDDATE>20070806</PERIOD_ENDDATE>
		<SUBMITTED_DATE>200708060354</SUBMITTED_DATE>
		<MARKET_SEGMENT>23</MARKET_SEGMENT>
		<NETOP_EAN>8716879000004</NETOP_EAN>
		<REQUEST_REFERENCE>10000000000000000000</REQUEST_REFERENCE>
	</MEDTD1>
	<MEDTD2>
		<KMEDTD2>#MEDTD2</KMEDTD2>
		<METERNO>1234</METERNO>
		<NO_DIALS>2</NO_DIALS>
	</MEDTD2>
	<MEDTD3>
		<KMEDTD3>#MEDTD3</KMEDTD3>
		<QUANTITY>2000</QUANTITY>
		<QUANTITY_TYPE_ID>220</QUANTITY_TYPE_ID>
		<QUANTITY_DATE>20070806</QUANTITY_DATE>
		<QUANTITY_DATE_TYPE>368</QUANTITY_DATE_TYPE>
		<MEASURE_UNIT_ID>KWH</MEASURE_UNIT_ID>
		<TIMEFRAME_ID>E11</TIMEFRAME_ID>
		<QUALIFICATION>90</QUALIFICATION>
		<NO_DIGITS>6</NO_DIGITS>
	</MEDTD3>
	<MEDTD3>
		<KMEDTD3>#MEDTD3</KMEDTD3>
		<QUANTITY>1500</QUANTITY>
		<QUANTITY_TYPE_ID>220</QUANTITY_TYPE_ID>
		<QUANTITY_DATE>20070806</QUANTITY_DATE>
		<QUANTITY_DATE_TYPE>368</QUANTITY_DATE_TYPE>
		<MEASURE_UNIT_ID>KWH</MEASURE_UNIT_ID>
		<TIMEFRAME_ID>E10</TIMEFRAME_ID>
		<QUALIFICATION>90</QUALIFICATION>
		<NO_DIGITS>6</NO_DIGITS>
	</MEDTD3>
	<MEDTD2>
		<KMEDTD2>#MEDTD2</KMEDTD2>
		<METERNO>4567</METERNO>
		<NO_DIALS>2</NO_DIALS>
	</MEDTD2>
	<MEDTD3>
		<KMEDTD3>#MEDTD3</KMEDTD3>
		<QUANTITY>2927</QUANTITY>
		<QUANTITY_TYPE_ID>220</QUANTITY_TYPE_ID>
		<QUANTITY_DATE>20070321</QUANTITY_DATE>
		<QUANTITY_DATE_TYPE>367</QUANTITY_DATE_TYPE>
		<MEASURE_UNIT_ID>KWH</MEASURE_UNIT_ID>
		<TIMEFRAME_ID>E10</TIMEFRAME_ID>
		<QUALIFICATION>90</QUALIFICATION>
		<NO_DIGITS>6</NO_DIGITS>
	</MEDTD3>
	<MEDTD3>
		<KMEDTD3>#MEDTD3</KMEDTD3>
		<QUANTITY>2230</QUANTITY>
		<QUANTITY_TYPE_ID>220</QUANTITY_TYPE_ID>
		<QUANTITY_DATE>20070321</QUANTITY_DATE>
		<QUANTITY_DATE_TYPE>367</QUANTITY_DATE_TYPE>
		<MEASURE_UNIT_ID>KWH</MEASURE_UNIT_ID>
		<TIMEFRAME_ID>E11</TIMEFRAME_ID>
		<QUALIFICATION>90</QUALIFICATION>
		<NO_DIGITS>6</NO_DIGITS>
	</MEDTD3>
</recordset>
<recordset>
	<MEDTD1>
		<KMEDTD1>#MEDTD1</KMEDTD1>
		<REQUEST_ID>MN00002</REQUEST_ID>
		<TRANSACTION_ID>TEST</TRANSACTION_ID>
		<CONNECT_EAN>873456789012345678</CONNECT_EAN>
		<REASON_ID>E03</REASON_ID>
		<PERIOD_STARTDATE>20070806</PERIOD_STARTDATE>
		<PERIOD_ENDDATE>20070806</PERIOD_ENDDATE>
		<SUBMITTED_DATE>200708060354</SUBMITTED_DATE>
		<MARKET_SEGMENT>23</MARKET_SEGMENT>
		<NETOP_EAN>8716879000004</NETOP_EAN>
		<REQUEST_REFERENCE>10000000000000000000</REQUEST_REFERENCE>
	</MEDTD1>
	<MEDTD2>
		<KMEDTD2>#MEDTD2</KMEDTD2>
		<METERNO>8912</METERNO>
		<NO_DIALS>2</NO_DIALS>
	</MEDTD2>
	<MEDTD3>
		<KMEDTD3>#MEDTD3</KMEDTD3>
		<QUANTITY>2000</QUANTITY>
		<QUANTITY_TYPE_ID>220</QUANTITY_TYPE_ID>
		<QUANTITY_DATE>20070806</QUANTITY_DATE>
		<QUANTITY_DATE_TYPE>368</QUANTITY_DATE_TYPE>
		<MEASURE_UNIT_ID>KWH</MEASURE_UNIT_ID>
		<TIMEFRAME_ID>E11</TIMEFRAME_ID>
		<QUALIFICATION>90</QUALIFICATION>
		<NO_DIGITS>6</NO_DIGITS>
	</MEDTD3>
	<MEDTD3>
		<KMEDTD3>#MEDTD3</KMEDTD3>
		<QUANTITY>1500</QUANTITY>
		<QUANTITY_TYPE_ID>220</QUANTITY_TYPE_ID>
		<QUANTITY_DATE>20070806</QUANTITY_DATE>
		<QUANTITY_DATE_TYPE>368</QUANTITY_DATE_TYPE>
		<MEASURE_UNIT_ID>KWH</MEASURE_UNIT_ID>
		<TIMEFRAME_ID>E10</TIMEFRAME_ID>
		<QUALIFICATION>90</QUALIFICATION>
		<NO_DIGITS>6</NO_DIGITS>
	</MEDTD3>
	<F1>
		<KF1>#F1</KF1>
		<F1>15</F1>
	</F1>
</recordset>
</ns:ZUECH_0210>

Don't mind for the header mapping I solved it with copyvalue, but the D3 is my problem. They should be mapped to the correct D2

Thanks for your help.

Former Member
0 Kudos

Hi Marlies,

I have found one thing in your test source. Your test source file seems to be wrong because if you see below structure of source file

<ns:ZUECH_0210 xmlns:ns="urn:rwe-nl:xi:interfaces_ext:global">

<recordset>

<H1>

<H2>

<H3>

<H4>

<H5>

<H6>

<MEDTD1>

<MEDTD2>

<MEDTD3>

<MEDTD3>

<b><MEDTD2> -


> This is your broblem (it can never

ome after MEDTD3)</b>

<MEDTD3>

<MEDTD3>

</recordset>

<MEDTD1>

<MEDTD2>

<MEDTD3>

<MEDTD3>

<F1>

</recordset>

</ns:ZUECH_0210>

Now what to do with your mapping, See your mapping is very simple, i have mapped it my system based on your source & target xsd and then tested and getting the results as per your requirement. Map all nodes as i am going to display below:

<b>recordset----


>IDOC

map header as you want. no issue.

MEDTD1 -


> -RWENL-U_MEDTD1

MEDTD2 -


> -RWENL-U_MEDTD2

MEDTD3 -


> -RWENL-U_MEDTD3</b>

and offcourse map your desired fields of all nodes to respective node fields.

There is no need to use any other function in mapping it is simply 1:1 mapping

After doing all the canges activate mapping and test your mapping with the below given test data. This test data is same which you given only the difference is, i have delete the <b>MEDTD2</b> node which was coming in after <b>MEDTD3</b> node.

<?xml version="1.0" encoding="utf-8"?>
<ns:ZUECH_0210 xmlns:ns="urn:rwe-nl:xi:interfaces_ext:global">
<recordset>
	<H1>
		<KH1>#H1</KH1>
		<H1>210</H1>
	</H1>
	<H2>
		<KH2>#H2</KH2>
		<H2>ECH210_20070710_126757625.dat</H2>
	</H2>
	<H3>
		<KH3>#H3</KH3>
		<H3>20070710_0800</H3>
	</H3>
	<H4>
		<KH4>#H4</KH4>
		<H4>9.0</H4>
	</H4>
	<H5>
		<KH5>#H5</KH5>
		<H5>8712423010208</H5>
	</H5>
	<H6>
		<KH6>#H6</KH6>
		<H6>8717154940022</H6>
	</H6>
	<MEDTD1>
		<KMEDTD1>#MEDTD1</KMEDTD1>
		<REQUEST_ID>MN00001</REQUEST_ID>
		<TRANSACTION_ID>TEST</TRANSACTION_ID>
		<CONNECT_EAN>873456789012345678</CONNECT_EAN>
		<REASON_ID>E03</REASON_ID>
		<PERIOD_STARTDATE>20070806</PERIOD_STARTDATE>
		<PERIOD_ENDDATE>20070806</PERIOD_ENDDATE>
		<SUBMITTED_DATE>200708060354</SUBMITTED_DATE>
		<MARKET_SEGMENT>23</MARKET_SEGMENT>
		<NETOP_EAN>8716879000004</NETOP_EAN>
		<REQUEST_REFERENCE>10000000000000000000</REQUEST_REFERENCE>
	</MEDTD1>
	<MEDTD2>
		<KMEDTD2>#MEDTD2</KMEDTD2>
		<METERNO>1234</METERNO>
		<NO_DIALS>2</NO_DIALS>
	</MEDTD2>
	<MEDTD3>
		<KMEDTD3>#MEDTD3</KMEDTD3>
		<QUANTITY>2000</QUANTITY>
		<QUANTITY_TYPE_ID>220</QUANTITY_TYPE_ID>
		<QUANTITY_DATE>20070806</QUANTITY_DATE>
		<QUANTITY_DATE_TYPE>368</QUANTITY_DATE_TYPE>
		<MEASURE_UNIT_ID>KWH</MEASURE_UNIT_ID>
		<TIMEFRAME_ID>E11</TIMEFRAME_ID>
		<QUALIFICATION>90</QUALIFICATION>
		<NO_DIGITS>6</NO_DIGITS>
	</MEDTD3>
	<MEDTD3>
		<KMEDTD3>#MEDTD3</KMEDTD3>
		<QUANTITY>1500</QUANTITY>
		<QUANTITY_TYPE_ID>220</QUANTITY_TYPE_ID>
		<QUANTITY_DATE>20070806</QUANTITY_DATE>
		<QUANTITY_DATE_TYPE>368</QUANTITY_DATE_TYPE>
		<MEASURE_UNIT_ID>KWH</MEASURE_UNIT_ID>
		<TIMEFRAME_ID>E10</TIMEFRAME_ID>
		<QUALIFICATION>90</QUALIFICATION>
		<NO_DIGITS>6</NO_DIGITS>
	</MEDTD3>
	<MEDTD3>
		<KMEDTD3>#MEDTD3</KMEDTD3>
		<QUANTITY>2927</QUANTITY>
		<QUANTITY_TYPE_ID>220</QUANTITY_TYPE_ID>
		<QUANTITY_DATE>20070321</QUANTITY_DATE>
		<QUANTITY_DATE_TYPE>367</QUANTITY_DATE_TYPE>
		<MEASURE_UNIT_ID>KWH</MEASURE_UNIT_ID>
		<TIMEFRAME_ID>E10</TIMEFRAME_ID>
		<QUALIFICATION>90</QUALIFICATION>
		<NO_DIGITS>6</NO_DIGITS>
	</MEDTD3>
	<MEDTD3>
		<KMEDTD3>#MEDTD3</KMEDTD3>
		<QUANTITY>2230</QUANTITY>
		<QUANTITY_TYPE_ID>220</QUANTITY_TYPE_ID>
		<QUANTITY_DATE>20070321</QUANTITY_DATE>
		<QUANTITY_DATE_TYPE>367</QUANTITY_DATE_TYPE>
		<MEASURE_UNIT_ID>KWH</MEASURE_UNIT_ID>
		<TIMEFRAME_ID>E11</TIMEFRAME_ID>
		<QUALIFICATION>90</QUALIFICATION>
		<NO_DIGITS>6</NO_DIGITS>
	</MEDTD3>
</recordset>
<recordset>
	<MEDTD1>
		<KMEDTD1>#MEDTD1</KMEDTD1>
		<REQUEST_ID>MN00002</REQUEST_ID>
		<TRANSACTION_ID>TEST</TRANSACTION_ID>
		<CONNECT_EAN>873456789012345678</CONNECT_EAN>
		<REASON_ID>E03</REASON_ID>
		<PERIOD_STARTDATE>20070806</PERIOD_STARTDATE>
		<PERIOD_ENDDATE>20070806</PERIOD_ENDDATE>
		<SUBMITTED_DATE>200708060354</SUBMITTED_DATE>
		<MARKET_SEGMENT>23</MARKET_SEGMENT>
		<NETOP_EAN>8716879000004</NETOP_EAN>
		<REQUEST_REFERENCE>10000000000000000000</REQUEST_REFERENCE>
	</MEDTD1>
	<MEDTD2>
		<KMEDTD2>#MEDTD2</KMEDTD2>
		<METERNO>8912</METERNO>
		<NO_DIALS>2</NO_DIALS>
	</MEDTD2>
	<MEDTD3>
		<KMEDTD3>#MEDTD3</KMEDTD3>
		<QUANTITY>2000</QUANTITY>
		<QUANTITY_TYPE_ID>220</QUANTITY_TYPE_ID>
		<QUANTITY_DATE>20070806</QUANTITY_DATE>
		<QUANTITY_DATE_TYPE>368</QUANTITY_DATE_TYPE>
		<MEASURE_UNIT_ID>KWH</MEASURE_UNIT_ID>
		<TIMEFRAME_ID>E11</TIMEFRAME_ID>
		<QUALIFICATION>90</QUALIFICATION>
		<NO_DIGITS>6</NO_DIGITS>
	</MEDTD3>
	<MEDTD3>
		<KMEDTD3>#MEDTD3</KMEDTD3>
		<QUANTITY>1500</QUANTITY>
		<QUANTITY_TYPE_ID>220</QUANTITY_TYPE_ID>
		<QUANTITY_DATE>20070806</QUANTITY_DATE>
		<QUANTITY_DATE_TYPE>368</QUANTITY_DATE_TYPE>
		<MEASURE_UNIT_ID>KWH</MEASURE_UNIT_ID>
		<TIMEFRAME_ID>E10</TIMEFRAME_ID>
		<QUALIFICATION>90</QUALIFICATION>
		<NO_DIGITS>6</NO_DIGITS>
	</MEDTD3>
	<F1>
		<KF1>#F1</KF1>
		<F1>15</F1>
	</F1>
</recordset>
</ns:ZUECH_0210>

Do the testing and if you feel any dificulty, do let me know.

Regards,

Sarvesh