ISO Codes in SAP

What is Country ISO Codes in SAP?

In an SAP System, ISO codes are currently supported for language, country, currency, and unit of measure fields.

If you use one or more of these fields in your BAPI you have to make two fields available for each of these fields in the BAPI interface: one field containing the SAP code and another containing its corresponding ISO code. Use the naming convention, Fieldname_for_SAPCode_ISO for the field containing the ISO code.

Implement the BAPI as follows:

When you export data from the BAPI both fields must contain corresponding values.

When you import data into the BAPI the ISO code is only significant if no value was given in the SAP code.

Domains for SAP internal codes and ISO codes

Always try to use the standard domains listed below for fields. We recommend that you use your own data elements for the fields. If it does not make sense to use your own data elements, use the standard data elements that are listed below.

Field


Standard Domains

Standard Data Element

Country (SAP code)

LAND1

LAND1

Country (ISO code)

INTCA

INTCA

Currency (SAP code)

WAERS

CURCY or WAERS

Currency (ISO code)

ISOCD

ISOCD

Language (SAP code)

SPRAS

SPRAS

Language (ISO code)

LAISO

LAISO

Unit of measurement (SAP code)

MEINS

MSEHI or MEINS

Unit of measurement (ISO code)

ISOCD_UNIT

ISOCD_UNIT

Reason: If standard domains are used, the generated mapping modules automatically convert the ISO code. If you use other domains, you have to manually convert the ISO code in the module modules. See Mapping Between Internal and External Data Formats.

ISO Codes in SAP

Adding a Country Code to SAP

Minimum Required When Adding Country Code

Add Country Code & Its Corresponding Region

  1. Add Country (IMG->SAP NetWeaver->General Settings->Set Countries->Define Countries in mySAP Systems)
  2. Add Region (IMG->SAP NetWeaver->General Settings->Set Countries->Insert Regions)

 

Maintain SAP’s IRS 1042s Mapping & Witholding Tax Calculation

  1. Add IRS 1042s Mapping (IMG->Payroll->Payroll: USA->Supplements Public Sector US-> Payroll->Non-Resident Alien Master Data-> Set up Tax Treaty Information->Maintain Tax Treaty Countries)

2. Add Country Keys for Withholding Tax Calculation (IMG->Financial Accounting->Accounts Receivable and Accounts Payable->Business Transactions->Outgoing Payments->Outgoing Payments Global Settings->Carry Out and Check Settings for Withholding Tax->Maintain Countries)

When we add a Country Code to SAP, the following tables need to be updated:

  1. T005 (SAP Country Code table)
    • T005-LAND1 = ISO Country Code
  2. T005S (SAP’s Region table)
    • T005S-LAND1 = ISO Country Code
    • T005S-BLAND = (Region (State, Province, County)) Since Zip Code is used by Post Offices worldwide and not Region Code and people often don’t know what the correct foreign region should be, SAP recommends that we use same code as LAND1 for all regions outside of US & Canada
  3. T5UPBS10 (SAP’s IRS 1042s mapping table – maintained from Payroll IMG Maintain Tax Treaty Countries)
    • T5UPBS10-LAND1 = the ISO Country Code we added to T005
    • T5UPBS10-CNTRY = the corresponding IRS 1042s Country Code
  4. T005Q (Country Keys for Withholding Tax Calculation – maintained from AP IMG)
    • T005Q-LAND1 = always US
    • T005Q-QLAND = the IRS 1042s Country Code (T5UPBS10-CNTRY)
  5. Optionally T059F (Formulas for Calculating Withholding Tax – maintained from AP IMG)
    • T005F-LAND1 = always US
    • T005F-QLAND = the IRS 1042s Country Code (T5UPBS10-CNTRY)

Also See: What is the usage of User Exits in SAP SD

Online Training Tutorials

  • Role of Functional consultantRole of Functional consultant in CINRole of Functional consultant: Installation, customization and configuration related to CIN needs to be carried out for the following applications (components) in SAP R/3. This should be a […]
  • Extended Withholding TaxExtended Withholding Tax Configuration and SettingsExtended Withholding Tax: SAP system provides two procedures for processing withholding tax; the “Standard” and the “Extended” withholding tax. We’ll walk you through on the basic […]
  • System Copy in SAP Business IntelligenceHow to System Copy in SAP Business Intelligence (BI SYSTEM) System Landscapes?The below post explain how the System Copy in SAP Business Intelligence System Landscapes in detail. Take the backup f the production system (Source) Pre-Steps on the target system […]
  • ASAP Methodology ImplementationASAP Methodology Implementation StepsThe SAP ASAP Methodology (Accelerated SAP) provides the roadmap for optimizing and continuous implementation of SAP systems in the real time business processes. The ASAP roadmap brings in […]
  • Types of Master data in sap mmWhat are the different Types of Master data in SAP MM?The Master data in SAP is used to be base data that can store all the required inform about the transaction. If someone producing, transferring stock, selling, purchasing, doing physical […]
  • materials planning and controlWhat is Materials Planning and Control?Materials planning and control determines how much of which material, component, goods etc. is needed and when. This activity is the responsibility of the materials planner or […]
  • System LandscapeDefine System LandscapeThe purpose of this activity is to establish the system landscape. The system landscape consists of the SAP Systems and clients that will enable you to adapt the SAP standard software to […]
  • Invoice VerificationWhat is Invoice Verification in the SAP System?The SAP system is made up of several components linked together so that different departments within a company can cooperate with one another. The Invoice Verification component is part of […]