Master data mapping in KSA eInvoicing solution

[zaheer4sana]

Preface

The master data is one of the key data sets of eInvoicing. As a taxpayer all the required master data needs to be maintained in the appropriate place as per the format required by the tax authority, ZATCA.

Well, there is a big list of master data information required of which some are optional, some are mandatory and other few are conditional. Please refer to the XML implementation standard document for the detailed list of required master data and their validation business rules.

With the introduction of eInvoicing integration with the Tax authority we all know how important it is to maintain clean master data in our ERP’s. This blog is to provide the technical mapping and its specific details to be noted regarding the master data maintenance objects for KSA eInvoicing.

Context

In a broad context, there are two main master data elements in customer centric eInvoicing regulatory requirement in KSA.

Supplier master data

This generally is the company code master data for all the business scenarios in customer invoicing scenarios. Only In the case of self-billing, the company code master is represented as customer data in the XML as company code is the buyer self-generating the invoices on behalf of the vendor.

The other master data element of self-billing is the vendor master. In the XML, the accounting supplier party is mapped to the vendor master created in BP.

Customer master data

This is the buyers master data created in the BP transaction in S4HANA and XD01 transaction in ECC.

Master data mapping in general

Please refer to the below master data mapping table that clarifies at which place i.e., the relevant master data field the information needs to be maintained.

Table 1: General Master data mapping

Master data specific for onboarding

Apart from the various other master data required for onboarding, which is explained in the onboarding blog, there are two specific master data objects that are required only for onboarding.

1. TIN number of the supplier 

This is the tax identification of the individual entity which is belonging to a group company having group VAT registration number.

This needs to be maintained in the company code additional parameter called SATAXN.

This is mapped to the Org unit field of the Certificate Signing Request.

1. Industry of the supplier 

This is the main Industry in which the supplier’s business is in. Company code additional parameter SAINDU is the place this needs to be maintained.

This is mapped to the industry field of the Cryptographic stamp request.

---

Scheme Id specific master data

In addition to the Tax scheme Id which is always VAT number, ZATCA identifies the supplier and the customer in the XML with the help of the XML tag schemeID as shown below in the sample XML snippet.

schemeID (BT-46-1) denotes the various identification types of a taxpayer. This XML tag under the AccountingSupplierParty XML group, denotes the supplier’s identification type and the same under the XML group AccountingCustomerParty denotes the customers identification type.

ZATCA has defined multiple scheme ID’s that can be referred to in the XML as listed below.

Table 2: List of schemeID

The buyer identification (BT-46) and the seller identification (BT-29) in the XML must exist only once with one of the above listed scheme ID (BT-46-1) and must contain only alphanumeric characters.

In case multiple IDs exist for a taxpayer or a consumer then one of the above must be reported in the XML following the sequence specified above.

Note: Tax Identification number (TIN) for a buyer needs to be maintained in the ta category SA1 and this will be read and populated in the XML only if the customer's country is not SA.

Scheme Id specific master data mapping

Please refer to the below master data mapping table that clarifies at which place the relevant scheme ID needs to be maintained.

Table 3: schemeID Mapping matrix

Scheme Id at transaction level for simplified (B2C) eDocuments

Not all customers are consumers. In case of B2C customers who are referred to as consumers for whom generally no unique customer master is created but transaction is completed with a generic onetime customer, the schemeID can still be maintained at the individual billing document and accounting document level.

For SD billing documents it should be maintained at the header level in the new text field SAID and for FI invoices this should be maintained at the Reference Key 3 (XREF3) field at the customer item level of the accounting document.

Data format

Irrespective of the place where the schemeID other than CRN is being maintained, the data needs to be maintained in the below format.

Where schemeID should consists of one of the scheme ID’s listed in table 2 and IDNUM is the number of the identification document.

For example: IQA:6534565243524

Buyer ID for export scenarios:

Are these other buyer ID's required only for domestic scenarios? The answer is No. Even if your customers country is outside KSA, some identification number should be entered that is verifiable. you may not find the exact scheme ID type in the above list of schemeID's but you can use OTH for this purpose.

Note

• In business partner for customer and Vendor you may enter multiple documents with the identification type SABYID with different or same validity dates but only one currently valid document according to the priority in the sequence listed in table 2 is reported in XML.


• In additional parameters SASEID and CREGNO at company code level you can maintain only one currently valid Identification document.

 

Important SAP Notes:

3242982 - BP ID type “SABYID” for KSA e-invoice regulation

3257432 - Saudi Arabia: Configure and Maintain Other Buyer ID for Outgoing Invoices

3212218 - Company code additional parameters for KSA E-invoicing - SAP ONE Support Launchpad

3256545 - SAP Document Compliance Saudi Arabia: Mapping Enablement and Code Correction X

 

Other blogs on KSA eInvoicing

Solution onboarding guide

Handling Intercompany transactions in KSA eInvoicing | SAP Blogs

 

Some useful links

• SAP Document Compliance topic page


• Document Compliance Help Page


• Announcement Legal Notification


• KSA eInvoicing Webinar (Login required)


• Saudi Arabia E-Invoice Webinar 28Sep2022.pdf (sapjam.com) (Login required)


• [Release announcement] Phase 2 Solution for Saudi Arabia Electronic Invoicing (sapjam.com) (Login re...

 Note: For accessing the last three links listed above you need to login to MENA Localization SIG – Overview (sapjam.com)

 

Thank you for reading this blog. I hope the information is useful to you. Please share your feedback in the comments section below.

I encourage you to follow my profile for similar content.

[former_member829593]

Hi Zaheer,

Nice Document !!

I am getting error "Field ID is empty in TaxCategory of TaxSubtotal" while generating e-invoice i.e in XML format  for billing document in EDOC_COCKPIT.

It's working fine for Direct FI invoice through FB70 but not for SD Billing Document VF01.

I have maintain the Tax Category Mapping for A1 tax code as below.

[zaheer4sana]

Hi Shakir,

Please check if you have implemented all the notes mentioned in the overview note: 3095262 - SAP Document Compliance Saudi Arabia: eInvoicing

The tax category should be maintained in the value mapping before the eDocument is generated. i.e., before the source document is saved. Please check this if the tax category is determined for the subsequent SD invoices after maintaining the entry in the value mapping?

Please also check if the tax category is maintained for the tax code determined in the source document.

 

[koenvanlangeraert]

Hi Zaheer

I am still a bit puzzled. for phase 1, we had maintained the TIN number for Saudi customers in SA1. Now I read that this is only for foreign customers.

If I understand your blog we need to store this now in SASEID but I don't understand how the system will then make the distinction for the different type of other ID, like GCC, PAS, MOM,... if we all put that under SASEID

ex if we would have the passport ID of a customer, we store it in SASEID, so how the code will now this should PAS in the xml?

Kr

Koen

 

[zaheer4sana]

Hi Koen,

The data needs to be maintained in the below format.

 

XML will identify first three chars as scheme ID and the remaining after colon as the document number itself.



 

 

Where schemeID should consists of one of the scheme ID’s listed in table 2 for example PAS for passport and IDNUM is the number of the identification document.

 

Regards,

Zaheer

[brennen_fischer12]

Hi zaheer4sana ,

We're VAT registered and therefore have a valid 15 digit VAT # that's maintained for the company code. Our company also has a valid 10 digit CRN number (1XXXXXXXX3), as well as a 10 digit TIN (3XXXXXXXX9).

My question is in regards to maintaining additional parameters and the specific formatting that's required. What's shown below is what we currently have maintained.... That said, do I need to maintain a Scheme ID when inputting these values or should they be maintained as numbers only?

I'm ultimately trying to validate CSR information being sent to ZATCA to ensure it aligns with our current setup as we're having issues authenticating the OTP generated in ZATCA for the onboarding process.

• CREGNO - 10 digit CRN
• SAINDU - Free text
• SASEID - blank
• SATAXN - 10 digit TIN

Thank you in advance,

Brennen