TNLS SAP table for – Nielsen ID

Here we would like to draw your attention to TNLS table in SAP. As we know it is being mainly used with the SAP SD-BF (Basic Functions in SD) component which is coming under SD module (Sales & Distribution). TNLS is a SAP standard transparent table used for storing Nielsen ID related data in SAP. It comes under the package VZ.

SAP TNLS table

Table TNLS technical data

TableTNLS
Data storingNielsen ID
ModuleSD
ComponentSD-BF
SAP PackageVZ
Delivery ClassC – Customer table, data is only maintained by the customer
Table CategoryTRANSPARENT

SAP TNLS Table Fields

Here is the details of each fields in this table.You can find the discription, data type and assigned lenth of each of the fields in TNLS table.

  • MANDT : Client
    Its a key field. Its data type is C (Character String) with field length 3
  • NIELS
    Its a key field. Its data type is C (Character String) with field length 2