3596851 - While generating Advance VAT Return report for DE warning "Value XXX does not match the validation pattern ([0-9]\{4\})0[0-9]\{8\}" appears

Symptom

While using the Document and Reporting Compliance (DRC) to generate the DE_VAT_ADV_RTN report, the process completes with the status "Generated with Warnings."

The warning message displayed is "Value XXX does not match the validation pattern ([0-9]\{4\})0[0-9]\{8\}"

Environment

SAP S/4HANA Cloud Public Edition

Cause

As defined by ELSTER, for this scenario the tax number should be used in the harmonized federal schema (Vereinheitlichtes Bundesschema).

Resolution

The warning come from DRC because the maintained value in the entity customizing does not match the schema type. The tax number is invalid.

As per XSD(Schema) from authority:
<xs:simpleType name="SteuernummerBaseSType">

<xs:annotation>

<xs:documentation>Steuernummer</xs:documentation>

</xs:annotation>

<xs:restriction base="xs:string">

<xs:pattern value="([0-9]\{4\})0[0-9]\{8\}"/>

</xs:restriction>

The tax number should consist of 13 digits in total. First four should be numbers from 0-9 (for example tax office ID with 4 digits), on 5th place there should be a 0 and the last 8 digits should also be filled with numbers from 0-9. Special signs, etc are not allowed.

Further info on the tax number and its structure (Aufbau einer Steuernummer), kindly check the official documentation found under ELSTER - Hilfe.

Keywords

DRC, DE_VAT_ADV_RTN, validation pattern, Tax number, harmonized federal schema, Vereinheitlichtes Bundesschema, advance vat return , KBA , FI-LOC-VAT-DE , ACR Reports Germany , Problem

Product

SAP S/4HANA Cloud Public Edition all versions