Re: ALV GRID EXPORT TO XML

yogesh_pathak · ‎2010 Sep 28

Dear Madam / Sir,

Firstly thank you very much for attending my question.

My question is regarding Excise Dealer Return (India) to be filed in XML format.

I have completed ALV GRID with all required fields, but the XML portion is pending just because I don't know how to make XML as per Sample Format given by Excise Dept.

Although I have tried to make XML file by putting below mentioned code but the format is not as required:

FORM create_xml .
  DATA : l_xml TYPE REF TO cl_xml_document,
         sysubrc TYPE sy-subrc .
* CREATE THE XML OBJECT
  CREATE OBJECT l_xml.

* CONVERT THE DATA TO XML
  CALL METHOD l_xml->create_with_data( dataobject = gt_finalx[] ).

* DATA IS CONVERTED TO XML; DISPLAY THE XML-DOCUMENT
  CALL METHOD l_xml->display.
ENDFORM.                    " CREATE_XML

===========================================================

Below is the sample XML content provided by Excise Dept. in which the XML file must be created.

Kindly guide me as to how to make XML as per the format required.

With Warm Regards,

SAMPLE XML CODE PROVIDED BY EXCISE DEPT.

=======================================

- <ACES xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="ACES_DLR.xsd";>

- <RETURN ReturnType="DLR" ToolVer="1.0";>
- <HEADER-DATA>
  <RETURN-YEAR>2009</RETURN-YEAR> 
  <QUARTER>Jul-Sep</QUARTER> 
  <DEALER-NAME>ABC Limited</DEALER-NAME> 
  <REGISTRATION-NUMBER>BFMPS5767QXD001</REGISTRATION-NUMBER> 
  <NIL-RETURN>No</NIL-RETURN> 
  </HEADER-DATA>
- <INVOICE-HEADER>
- <INVOICE-PARTICULARS SL-NO="1">
  <INVOICE-NUMBER>12365897777777771541</INVOICE-NUMBER> 
  <INVOICE-DATE>15/11/2009</INVOICE-DATE> 
- <INVOICE-ITEMS>
  <DESCRIPTION-OF-GOODS>details of goods</DESCRIPTION-OF-GOODS> 
  <CETSH-NUMBER>01019020</CETSH-NUMBER> 
  <QUANTITY-CODE>U</QUANTITY-CODE> 
  <QUANTITY>1235.00<;/QUANTITY> 
  <AMOUNT-OF-DUTY-INVOLVED>226584.00<;/AMOUNT-OF-DUTY-INVOLVED> 
  </INVOICE-ITEMS>
- <INVOICE-ITEMS>
  <DESCRIPTION-OF-GOODS>details of goods</DESCRIPTION-OF-GOODS> 
  <CETSH-NUMBER>84369100</CETSH-NUMBER> 
  <QUANTITY-CODE>KG</QUANTITY-CODE> 
  <QUANTITY>3368.00<;/QUANTITY> 
  <AMOUNT-OF-DUTY-INVOLVED>99653.00<;/AMOUNT-OF-DUTY-INVOLVED> 
  </INVOICE-ITEMS>
  </INVOICE-PARTICULARS>
- <INVOICE-PARTICULARS SL-NO="2">
  <INVOICE-NUMBER>12556523655542154445</INVOICE-NUMBER> 
  <INVOICE-DATE>11/10/2009</INVOICE-DATE> 
- <INVOICE-ITEMS>
  <DESCRIPTION-OF-GOODS>details</DESCRIPTION-OF-GOODS> 
  <CETSH-NUMBER>63064900</CETSH-NUMBER> 
  <QUANTITY-CODE>U</QUANTITY-CODE> 
  <QUANTITY>456.00<;/QUANTITY> 
  <AMOUNT-OF-DUTY-INVOLVED>2236.00<;/AMOUNT-OF-DUTY-INVOLVED> 
  </INVOICE-ITEMS>
  </INVOICE-PARTICULARS>
  </INVOICE-HEADER>
- <DOCUMENT-HEADER>
- <DOCUMENT-DETAIL SL-NO="1">
  <INVOICE-BILL-ENTRY-NO>55623255451145</INVOICE-BILL-ENTRY-NO> 
  <DATE>17/10/2009</DATE> 
  <ISSUED-BY>Manufacturer</ISSUED-BY> 
  <REGISTRATION-NUMBER>BFMPS5767QXD002</REGISTRATION-NUMBER> 
  <NAME>SEZ ltd</NAME> 
  <ADDRESS>udyog vihar</ADDRESS> 
- <INVOICE-ITEMS>
  <DESCRIPTION-OF-GOODS>goods desc</DESCRIPTION-OF-GOODS> 
  <CETSH-NUMBER>84079020</CETSH-NUMBER> 
  <QUANTITY-CODE>U</QUANTITY-CODE> 
  <QUANTITY>66</QUANTITY> 
  <AMOUNT-OF-DUTY-INVOLVED>9999999999999</AMOUNT-OF-DUTY-INVOLVED> 
  </INVOICE-ITEMS>
- <INVOICE-ITEMS>
  <DESCRIPTION-OF-GOODS>Description Of Goods</DESCRIPTION-OF-GOODS> 
  <CETSH-NUMBER>84079020</CETSH-NUMBER> 
  <QUANTITY-CODE>U</QUANTITY-CODE> 
  <QUANTITY>21.00<;/QUANTITY> 
  <AMOUNT-OF-DUTY-INVOLVED>23.00<;/AMOUNT-OF-DUTY-INVOLVED> 
  </INVOICE-ITEMS>
  </DOCUMENT-DETAIL>
- <DOCUMENT-DETAIL SL-NO="2">
  <INVOICE-BILL-ENTRY-NO>556232554511889</INVOICE-BILL-ENTRY-NO> 
  <DATE>17/11/2009</DATE> 
  <ISSUED-BY>Importer</ISSUED-BY> 
  <REGISTRATION-NUMBER>BFMPS5767QXD005</REGISTRATION-NUMBER> 
  <NAME>SEG sec</NAME> 
  <ADDRESS>sec 2 ggn</ADDRESS> 
- <INVOICE-ITEMS>
  <DESCRIPTION-OF-GOODS>test data</DESCRIPTION-OF-GOODS> 
  <CETSH-NUMBER>44109092</CETSH-NUMBER> 
  <QUANTITY-CODE>KG</QUANTITY-CODE> 
  <QUANTITY>88.00<;/QUANTITY> 
  <AMOUNT-OF-DUTY-INVOLVED>256.00<;/AMOUNT-OF-DUTY-INVOLVED> 
  </INVOICE-ITEMS>
  </DOCUMENT-DETAIL>
  </DOCUMENT-HEADER>
- <SELF-ASSESSMENT-MEMORANDAM>
  <DATE>08/12/2009</DATE> 
  <PLACE>gurgaon</PLACE> 
  <REMARKS>Return for jul-sep 2009</REMARKS> 
  </SELF-ASSESSMENT-MEMORANDAM>
  </RETURN>
  </ACES>

Former Member · ‎2010 Sep 28

Hello Yogesh,

There are FMs like SAP_CONVERT_TO_XML_FORMAT that you can use to achieve this.

However, you can also use SIMPLE TRANSFORMATIONS (called using the statment Call Transformation) for describing transformations between ABAP data and XML. You can find more info on this at

http://help.sap.com/abapdocu_70/en/ABENABAP_ST.htm

Hope it helps...

Regards...Jaison

Lukas_Weigelt · ‎2010 Sep 28

Hi Yogesh,

could you provide us with the source table's structure/contents which your sample xml document is supposed to be the result of?

regards, Lukas

yogesh_pathak · ‎2010 Sep 29

Dear Lukas Weigelt,

Please find hereunder the XML Structure:

S.NoXML TAG/ Attribute Description Mandatory Data Validations Format/Length Sample Values

1 ACES Root element of the Dealer Return XML Y NA NA NA

2 RETURN Contains information of Return type and Version Y NA NA NA

3 Return Type First attribute of RETURN, should have value DLR Y Accepts only DLR NA DLR

4 ToolVer Second attribute of RETURN, current value 1.0 Y Contains schema version currently 1.0 NA 1.0

5

HEADER-DATA Contains basic return information like period etc. Y

6 RETURN-YEAR QUARTERLY RETURN UNDER RULE 7 OF CENVAT CREDIT RULES 2002 FOR THE YEAR Y Must be a valid year, cannot be future year. Length-4 2009

7 QUARTER Return for the quarter ending Y Quarter for which return is being filed January-March --> Jan-Mar April-June ~~> Apr-Jun July-September~~> Jul-Sep October-December -->Oct-Dec Exact values as per enumeration in schema Jan-Mar

8 DEALER-NAME Name of the first stage/second stage dealer Y Maximum 255 characters 255 characters abc limited

9 REGISTRATION-NUMBER Excise registration number Y PAN based Valid registration number, Registration number must have 15 characters. First 10 characters from PAN, next 2 characters should be in XM, XD, EM or ED, last three digits are running serial number. Length- 15 ABCDE1234FXD001 or ABCDE1234FXM001 or AACCA8076DEM001 or AACCA8076DED001

10 INVOICE-HEADER INVOICES ISSUED BY FIRST STAGE/ SECOND STAGE DEALER Y

11 INVOICE-PARTICULARS PARTICULARS OF INVOICES ISSUED BY FIRST STAGE/SECOND STAGE DEALER maintained by attribute SL-NO Y Attribute SL-NO is for indexing of invoices , SL-NO must start with 1 and should increase by 1 for each new item NA 1

12 INVOICE-NUMBER Invoice number Y Maximum 20 characters Maxlength-20 12345698563214500000

13 INVOICE-DATE Date of invoice Y Must be valid date in DD/MM/YYYY format Length-10 11/11/2008

14 INVOICE-ITEMS MAIN ITEMS IN THE INVOICE Y

15 DESCRIPTION-OF-GOODS Detailed description of goods Y Maximum 255 characters Maxlength-255

16 CETSH-NUMBER CETSH number Y Length 8 characters, Full list provided in excel CETSH-UOM.xls; CETSH entered apart from will be rejected at the time of XML processing. Length-8 1011090

17 QUANTITY-CODE Quantity Code i.e. Unit of measure applicable to CETSH Y Please provide correct UOM applicable to CETSH else return XML will be rejected. Refer CETSH-UOM LIST for applicable code to CETSH provided in CETSH-UOM.xls file. Exact values as per enumeration in schema U

18 QUANTITY Quantity Y decimal between 0 and 999999999999.99 12354

19 AMOUNT-OF-DUTY-INVOLVED Amount of Duty Involved (Rs) Y Whole number between 0 and 9999999999999 22256235

20 DOCUMENT-HEADER DOCUMENTS BASED ON WHICH THE CREDIT IS PASSED ON Y

21 DOCUMENT-DETAIL PARTICULARS OF THE DOCUMENTS BASED ON WHICH THE CREDIT IS PASSED ON maintained by attribute SL-NO Y Attribute SL-NO is for indexing of records, SL-NO must start with 1 and should increase by 1 for each new item. NA 1

22 INVOICE-BILL-ENTRY-NO Invoice/Bill Of Entry Number Y Maximum 20 characters Maxlength-20 88898884454

23 DATE Date Y Must be valid date in DD/MM/YYYY format Length-10 11/11/2008

24 ISSUED-BY Issued By Y One of the following : Importer, Manufacturer or Dealer Enumerations provided in schema Dealer

25 REGISTRATION-NUMBER Registration Number Y PAN based Valid registration number, Registration number must have 15 characters. First 10 characters from PAN, next 2 characters should be in XM, XD, EM or ED, last three digits are running serial number. Length- 15 ABCDE1234FXD001 or ABCDE1234FXM001 or AACCA8076DEM001 or AACCA8076DED001

26 NAME Name N Maximum 100 characters Maxlength-100 xyz limited

27 ADDRESS Address N Maximum 200 characters Maxlength-200 abc street, road no 4 , Goa

28 SELF-ASSESSMENT-MEMORANDAM Declaration section of return Y

29 DATE Date of filing return Y Must be a valid date in DD/MM/YYYY format Length-10 10/12/2009

30 PLACE Place of filing return Y Maximum 50 characters Maxlength-50 Gurgaon

31 REMARKS Remarks Y Maximum 1000 characters Maxlength-1000

yogesh_pathak · ‎2010 Sep 29

Dear Lukas Weigelt,

Thanks for your reply.

Please find the XML Structure as under:

Just copy and paste in MS-EXCEL for better view.

S.No XML TAG/ Attribute Description Mandatory Data Validations Format/Length Sample Values