If you’re setting up your master data to run magnetic media report formats for Colombia, you may get yourself with a question: how to enter city codes according to the ones defined by DANE in third parties’ address?
Here’s a quick guide for you to get away with city codes in master data so that you can have them correctly reported in magnetic media report formats.
Check the following materials – they help you with the overall process on setting up your master data:
- In the SAP Help Portal, see Master Data for Magnetic Media.
- In SAP Community, see our guide on how to treat business partners names in Magnetic Media Compliance Reports: Master Data for Business Partners Names.
Specifying your City Codes:
First of all, you need to create your city codes in the Create Cities Individually customizing activity. To do so, go to SAP Customizing Implementation Guide > SAP NetWeaver > Application Server > Basis Services > Address Management > Regional Structure/City File > Cities > Create Cities Individually (SR10).
Keep in mind that DIAN requires that you report city codes according to DANE guidelines. Use these guidelines when you create your city codes. You can find the details in DIAN portal: https://www.dian.gov.co/atencionciudadano/formulariosinstructivos/Formularios/2007/Codigos_municipios_2007.pdf#search=c%C3%B3digos%20municipios
Here’s an example of city code for Bogota city:
For blindsided people to see: The picture shows a screenshot of the SAP system in the Create Cities Individually customizing activity.
Once you make sure you have created the city codes according to DANE guidelines, you can assign an address to your business partner.
Assigning an Address to a Business Partner:
- Access BP transaction.
- Choose the business partner that you want to add an address for.
- Go to the Address tab.
- Go to the Postal Code/City field.
- Select the address you want to add.
- Save your entries.
For blindsided people to see: The picture shows a screenshot of the SAP system in BP transaction.
Done that, you can run a test run to check if the city codes are correctly reported in the output XML file.
Verifying a City Code in the Output XML
The city code is reported with the last 3 digits in the element ‘mun’ of the report formats. Here’s how it appears in the output XML file:
For blindsided people to see: The picture shows a screenshot of the output XML file of the 1001 report format with the ‘mun‘ element highlighted.
We hope this blog post is helpful for you.
Didn’t find your answer? Let us know in the comments below, your doubt can be the subject of our next publication.
See you next time and stay compliant 😉,