TCNIFP SAP table for – Profile for BOM transfer

Here we would like to draw your attention to TCNIFP table in SAP. As we know it is being mainly used with the SAP PS-MAT (Material in PS) component which is coming under PS module (Project Systems). TCNIFP is a SAP standard transparent table used for storing Profile for BOM transfer related data in SAP. It comes under the package CN_MAT.

SAP TCNIFP table

Table TCNIFP technical data

TableTCNIFP
Data storingProfile for BOM transfer
ModulePS
ComponentPS-MAT
SAP PackageCN_MAT
Delivery ClassC – Customer table, data is only maintained by the customer
Table CategoryTRANSPARENT

SAP TCNIFP 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 TCNIFP table.

  • MANDT : Client
    Its a key field. Its data type is C (Character String) with field length 3
  • FLG_SALES
    Its data type is C (Character String) with field length 1
  • CAPID
    Its data type is C (Character String) with field length 4
  • NODLG
    Its data type is C (Character String) with field length 1
  • AV_CHECK
    Its data type is C (Character String) with field length 1
  • FLG_UNIQUE
    Its data type is C (Character String) with field length 1
  • POSTP
    Its data type is C (Character String) with field length 1
  • SANFE
    Its data type is C (Character String) with field length 1
  • PROFILE : Upload Profile
    Its a key field. Its data type is C (Character String) with field length 4
  • SANIN
    Its data type is C (Character String) with field length 1
  • KLKSL
    Its data type is C (Character String) with field length 1
  • RVREL
    Its data type is C (Character String) with field length 1
  • SCHGT
    Its data type is C (Character String) with field length 1
  • RVRSL
    Its data type is C (Character String) with field length 1
  • ERSKZ
    Its data type is C (Character String) with field length 1
  • ERSSL
    Its data type is C (Character String) with field length 1
  • BESSL
    Its data type is C (Character String) with field length 1
  • AEFRP
    Its data type is C (Character String) with field length 1
  • AEFRF
    Its data type is C (Character String) with field length 1
  • AEFRS
    Its data type is C (Character String) with field length 1
  • STPST
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 2
  • WERKS : Plant
    Its data type is C (Character String) with field length 4
  • FLG_EXT
    Its data type is C (Character String) with field length 1
  • FLG_ALL
    Its data type is C (Character String) with field length 1
  • FLG_MAT
    Its data type is C (Character String) with field length 1