How can I find the source field of a target field in S4Hana cloud?

[KatjaS]

In the billing document Header Detail, under Taxes, I have a field called "VAT Registration No.". I need to know what the source field of this field is and which business partner role it comes from (Payer, BillTo, ShipTo). 

The general question of how to find the source field of a target field frequently comes up in other situations, too.

[Rosita928Ruiz]

To find the source of the "VAT Registration No." in the billing document header (Taxes) in SAP, first use F1 help on the field to identify the underlying table and field name. Then, check the Business Partner master data (transaction BP) for the Payer and Bill-to Party roles, specifically under the "Tax Numbers" tab, as the VAT number likely tollbyplate originates from one of these. If not found, explore the tax configuration in SPRO. The field is usually linked to the VAT registration number maintained in the relevant business partner's master data.

[KatjaS]

Thanks Rosita! I was now able to identify the table and field name. In Data Browser, I can look up the field but not view the content. In the BP master, I can find the VAT field, but in this case, my Payer and ShipTo are the same, so I'll need to find an example where they are different. In SPRO, I checked 103110, but no values are assigned to the companies, so I guess it isn't here where it's defined. Not sure where it is.

[DequanXu]

Hi,

The ‘VAT Registration No.’ field in the billing document header is sourced from the business partner master data. Specifically, it is derived from the VAT registration number maintained for the business partner Poland - Maintaining VAT Registration Number for Business Partners in the ‘Manage Business Partner Master Data’ app.

Source Field

• Source Field: The VAT registration number is stored in the business partner master data under the ‘Tax Numbers’ section.

Business Partner Role

• Business Partner Role: The VAT registration number can be associated with different roles such as Payer, BillTo, or ShipTo. The determination of which role’s VAT registration number is used can depend on the configuration settings for the sales organization and the specific sales document.

Best regards, Dequan Xu