Skip to Content
0
Dec 09, 2013 at 11:46 AM

How to read below XML file into ABAP Internal Table?

938 Views

<DatabaseExportRequestType xmlns="http://cmsg2.vf.com/CMSG2Schema/V9">

- <Customer Id="1486">

<CustomerName>Atlanta</CustomerName>

</Customer>

- <DatabaseExports>

- <Export>

- <CurriculumSetup>

<CurriculumName />

<CurriculumPurposeCode />

<CurriculumStatusCode />

<CurriculumStartDate>2013-11-21</CurriculumStartDate>

<CurriculumEndDate>2013-11-21</CurriculumEndDate>

<LockIndicator>N</LockIndicator>

</CurriculumSetup>

- <TransactionMetaData>

<TransactionTypeCode>EXP</TransactionTypeCode>

<SystemCode>CMSG2</SystemCode>

<StatusCode>CMPLT</StatusCode>

<CreatedDate>2013-11-21</CreatedDate>

<StatusDate>2013-11-21</StatusDate>

</TransactionMetaData>

</Export>

- <Export xmlns="http://cmsg2.vf.com/CMSG2Schema/V9">

- <TrainingSetup>

<TrainingTypeCode />

<GenerateSubsequentTrainingPeriodInd />

<TrainingStartDate>2013-11-21</TrainingStartDate>

<WindowStatusCode />

<AutoAssignIndicator />

</TrainingSetup>

- <TransactionMetaData>

<TransactionTypeCode>EXP</TransactionTypeCode>

<SystemCode>CMSG2</SystemCode>

<StatusCode>CMPLT</StatusCode>

<CreatedDate>2013-11-21</CreatedDate>

<StatusDate>2013-11-21</StatusDate>

</TransactionMetaData>

</Export>

- <Export xmlns="http://cmsg2.vf.com/CMSG2Schema/V9">

- <Producer>

- <Individual Id="41228109">

<LastName>Lname03613</LastName>

<FirstName>Fname03613</FirstName>

<SSN>999003613</SSN>

<BirthDate>1953-09-14</BirthDate>

<NationalProducerNumber>0013423408</NationalProducerNumber>

<CrdNumber>0502296</CrdNumber>

<MiddleName>V</MiddleName>

<GenderCode>2</GenderCode>

<PrimaryCitizenshipCountryCode>224</PrimaryCitizenshipCountryCode>

<StatusCode>1</StatusCode>

<StatusDate>2013-11-20</StatusDate>

<BillCode>6311390</BillCode>

<FirstResidentStateCode>NY</FirstResidentStateCode>

<FINRADisclosureIndicator>N</FINRADisclosureIndicator>

<FINRAMaterialDifferenceIndicator>N</FINRAMaterialDifferenceIndicator>

<FINRADualRegisteredIndicator>N</FINRADualRegisteredIndicator>

<EmailAddress>test@AB.COM</EmailAddress>

- <Addresses>

- <IndividualAddress Id="76735709">

<AddressTypeCode>101</AddressTypeCode>

<AddressPurposeCode>1</AddressPurposeCode>

<LineOneAddress>SVP/Director</LineOneAddress>

<CityName>Not Applicable</CityName>

<CountryCode>230</CountryCode>

<FromDate>2007-09-21</FromDate>

<PrivateResidenceIndicator>N</PrivateResidenceIndicator>

</IndividualAddress>

- <IndividualAddress Id="76735809">

<AddressTypeCode>102</AddressTypeCode>

<AddressPurposeCode>1</AddressPurposeCode>

<LineOneAddress>John Edward English</LineOneAddress>

<LineTwoAddress>JOHN@AB.XOM</LineTwoAddress>

<CityName>Not Applicable</CityName>

<CountryCode>230</CountryCode>

<FromDate>2010-06-14</FromDate>

<PrivateResidenceIndicator>N</PrivateResidenceIndicator>

</IndividualAddress>