SAP for Retail Discussions
Join conversations about personalization, omnichannel strategies, and operational excellence in retail using SAP for Retail software.
cancel
Showing results for 
Search instead for 
Did you mean: 

XML file format to Post DUMMY Sales Transactions

Former Member
0 Kudos

Hi All,

I need to post some DUMMY transactions in POS DM using program - /POSDW/XML_IN.

But I am not aware of the input file format for XML. Kindly share the XML format, so I can process some DUMMY transactions.

Many Thanks.

Regards,

Hardik

1 ACCEPTED SOLUTION

amit_tunara
Active Contributor
0 Kudos

Hi Hardik,

Please paste this into a text file and save it as XML. Then open it in Internet explorer to understand the tags.

<?xml version="1.0" encoding="UTF-8"?>

-<T_TRANSACTION_INT>

-<TRANSACTION_INT>

<RETAILSTOREID>0000008401</RETAILSTOREID>

<BUSINESSDAYDATE>2012-10-28</BUSINESSDAYDATE>

<TRANSTYPECODE>1001</TRANSTYPECODE>

<WORKSTATIONID>0000000001</WORKSTATIONID>

<TRANSNUMBER>00000000000000002698</TRANSNUMBER>

<BEGINTIMESTAMP>20121028164531</BEGINTIMESTAMP>

<ENDTIMESTAMP>20121028164531</ENDTIMESTAMP>

<DEPARTMENT/>

<OPERATORQUAL/>

<OPERATORID>000000000000000000000000000001</OPERATORID>

<TRANSCURRENCY>XXX</TRANSCURRENCY>

<PARTNERQUALIFIER/><PARTNERID/>

-<T_RETAILLINEITEM>

-<RETAILLINEITEM>

<RETAILNUMBER>0000000001</RETAILNUMBER>

<RETAILTYPECODE>2001</RETAILTYPECODE>

<RETAILREASONCODE/>

<ITEMIDQUALIFIER>2</ITEMIDQUALIFIER>

<ITEMID>SO-073636</ITEMID>

<RETAILQUANTITY>1.0</RETAILQUANTITY>

<SALESUOM>EA</SALESUOM>

<SALESAMOUNT>36.0</SALESAMOUNT>

<NORMALSALESAMT>36.0</NORMALSALESAMT>

<COST>0.0</COST>

<BATCHID/><SERIALNUMBER/>

<PROMOTIONID/>

<ENTRYMETHODCODE/>

<ACTUALUNITPRICE>0.0</ACTUALUNITPRICE>

<UNITS>0.0</UNITS>

<SCANTIME/>

</RETAILLINEITEM>

</T_RETAILLINEITEM>

-<T_TENDER>

-<TENDER>

<TENDERNUMBER>0000002689</TENDERNUMBER>

<TENDERTYPECODE>3101</TENDERTYPECODE>

<TENDERAMOUNT>181.0</TENDERAMOUNT>

<TENDERCURRENCY>XXX</TENDERCURRENCY>

<TENDERID/>

<ACCOUNTNUMBER/>

<REFERENCEID/>

-<T_CREDITCARD>

-<CREDITCARD>

<PAYMENTCARD>*000</PAYMENTCARD>

<CARDNUMBER> 0.000000000</CARDNUMBER><CARDNUMBERSUFFIX/>

<VALIDFROMDATE>0000-00-00</VALIDFROMDATE>

<EXPIRATIONDATE>0000-00-00</EXPIRATIONDATE>

<CARDHOLDERNAME/><ADJUDICATIONCODE/><AUTHTERMID/><AUTHDATETIME/>

<AUTHMETHODCODE/><MEDIAISSUERID/><REACTIONCODE/><LIMITAMOUNT/><CARDSWIPEDKEYED/>

<HOSTAUTHORIZED/><AUTHCODE/><PROVIDERID/><FORCEONLINE/><BLACKLISTVERSION/>

<BLACKLISTDATE>0000-00-00</BLACKLISTDATE>

<REQUESTEDAMOUNT>0.0</REQUESTEDAMOUNT>

<CARDTYPE/><CARDGUID/>

<ENCTYPE/><CRYPTICHASH/>

</CREDITCARD>

</T_CREDITCARD>

</TENDER>

</T_TENDER>

</TRANSACTION_INT>

</T_TRANSACTION_INT>

If you want to understand what else can be passed you need to understand the basic POS DM BAPI /POSDW/BAPI_POSTR_CREATE using SE37.

Regards,

Amit

View solution in original post

2 REPLIES 2

amit_tunara
Active Contributor
0 Kudos

Hi Hardik,

Please paste this into a text file and save it as XML. Then open it in Internet explorer to understand the tags.

<?xml version="1.0" encoding="UTF-8"?>

-<T_TRANSACTION_INT>

-<TRANSACTION_INT>

<RETAILSTOREID>0000008401</RETAILSTOREID>

<BUSINESSDAYDATE>2012-10-28</BUSINESSDAYDATE>

<TRANSTYPECODE>1001</TRANSTYPECODE>

<WORKSTATIONID>0000000001</WORKSTATIONID>

<TRANSNUMBER>00000000000000002698</TRANSNUMBER>

<BEGINTIMESTAMP>20121028164531</BEGINTIMESTAMP>

<ENDTIMESTAMP>20121028164531</ENDTIMESTAMP>

<DEPARTMENT/>

<OPERATORQUAL/>

<OPERATORID>000000000000000000000000000001</OPERATORID>

<TRANSCURRENCY>XXX</TRANSCURRENCY>

<PARTNERQUALIFIER/><PARTNERID/>

-<T_RETAILLINEITEM>

-<RETAILLINEITEM>

<RETAILNUMBER>0000000001</RETAILNUMBER>

<RETAILTYPECODE>2001</RETAILTYPECODE>

<RETAILREASONCODE/>

<ITEMIDQUALIFIER>2</ITEMIDQUALIFIER>

<ITEMID>SO-073636</ITEMID>

<RETAILQUANTITY>1.0</RETAILQUANTITY>

<SALESUOM>EA</SALESUOM>

<SALESAMOUNT>36.0</SALESAMOUNT>

<NORMALSALESAMT>36.0</NORMALSALESAMT>

<COST>0.0</COST>

<BATCHID/><SERIALNUMBER/>

<PROMOTIONID/>

<ENTRYMETHODCODE/>

<ACTUALUNITPRICE>0.0</ACTUALUNITPRICE>

<UNITS>0.0</UNITS>

<SCANTIME/>

</RETAILLINEITEM>

</T_RETAILLINEITEM>

-<T_TENDER>

-<TENDER>

<TENDERNUMBER>0000002689</TENDERNUMBER>

<TENDERTYPECODE>3101</TENDERTYPECODE>

<TENDERAMOUNT>181.0</TENDERAMOUNT>

<TENDERCURRENCY>XXX</TENDERCURRENCY>

<TENDERID/>

<ACCOUNTNUMBER/>

<REFERENCEID/>

-<T_CREDITCARD>

-<CREDITCARD>

<PAYMENTCARD>*000</PAYMENTCARD>

<CARDNUMBER> 0.000000000</CARDNUMBER><CARDNUMBERSUFFIX/>

<VALIDFROMDATE>0000-00-00</VALIDFROMDATE>

<EXPIRATIONDATE>0000-00-00</EXPIRATIONDATE>

<CARDHOLDERNAME/><ADJUDICATIONCODE/><AUTHTERMID/><AUTHDATETIME/>

<AUTHMETHODCODE/><MEDIAISSUERID/><REACTIONCODE/><LIMITAMOUNT/><CARDSWIPEDKEYED/>

<HOSTAUTHORIZED/><AUTHCODE/><PROVIDERID/><FORCEONLINE/><BLACKLISTVERSION/>

<BLACKLISTDATE>0000-00-00</BLACKLISTDATE>

<REQUESTEDAMOUNT>0.0</REQUESTEDAMOUNT>

<CARDTYPE/><CARDGUID/>

<ENCTYPE/><CRYPTICHASH/>

</CREDITCARD>

</T_CREDITCARD>

</TENDER>

</T_TENDER>

</TRANSACTION_INT>

</T_TRANSACTION_INT>

If you want to understand what else can be passed you need to understand the basic POS DM BAPI /POSDW/BAPI_POSTR_CREATE using SE37.

Regards,

Amit

0 Kudos

Thanks Amit. It helped.

Regards,

Hardik