TNLS table in SAP ERP or S/4HANA stores Nielsen ID data. There are total 2 fields in TNLS table. The Nielsen ID table is available in all major of SAP S/4HANA versions and is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of TNLS table. It is in Application development R/3 RV central functions (VZ) ABAP package and is part of the Basic Functions (SD-BF) module.
SAP TNLS Table Fields
Following is the list of fields that are available in SAP TNLS table. The primary key fields of Nielsen ID table in SAP are MANDT (Client), NIELS (Nielsen ID).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT(3) |
| NIELS | Nielsen ID | NIELS | CHAR(2) |
