SAP Table TCNIFP

Profile for BOM transfer

TCNIFP (Profile for BOM transfer) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link TCNIFP to other SAP tables.

TCNIFP table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
PROFILE Profile for BOM transfer PROFILE_IF CHAR 4 0
BDMNG Requirement Quantity BDMNG QUAN 13 3
WERKS Plant WERKS_D T001W CHAR 4 0
MEHRS Multilevel BOM Explosion CN_MEHRS CHAR 1 0
X Yes
NULL No
FLG_EXT Copy data from external systems via user exit EXT_SYST CHAR 1 0
X Yes
NULL No
FLG_ALL Copy all bill of material items CN_FLG_ALL CHAR 1 0
X Yes
NULL No
FLG_PRE In general generate preliminary requirements CN_FLG_PRE CHAR 1 0
X Yes
NULL No
FLG_MAT Indicator: only take material BOMs into account MAT_BOM CHAR 1 0
X Yes
NULL No
FLG_SALES Indicator: Take sales order BOM into account SALES_BOM CHAR 1 0
X Yes
NULL No
FLG_PROJECT Indicator: Take project BOMs into account PROJ_BOM CHAR 1 0
X Yes
NULL No
CAPID Application CAPID TC04 CHAR 4 0
STLAN BOM Usage STLAN T416 CHAR 1 0
NODLG Indicator: Run without dialog, automatic data backup CN_NODLG CHAR 1 0
X Yes
NULL No
AV_CHECK Availability check during save CN_AVCHK CHAR 1 0
X Yes
NULL No
FLG_UNIQUE Indicator: Ambiguity check for reference points CN_UNIQUE CHAR 1 0
X Yes
NULL No
SANKO Indicator: item relevant to engineering SANKO CHAR 1 0
X Yes
NULL No
POSTP Item Category (Bill of Material) POSTP T418 CHAR 1 0
SANFE Indicator: item relevant to production SANFE CHAR 1 0
X Yes
NULL No
SANKA Indicator for Relevancy to Costing CK_SELKZ TCK08 CHAR 1 0
SANIN Indicator: item relevant to plant maintenance SANIN CHAR 1 0
X Yes
NULL No
KLKSL Selection of BOM items relevant to costing KLKSL CHAR 1 0
X All relevant to costing
3 All not relevant to costing
RVREL Indicator: item relevant to sales RVREL TVRL CHAR 1 0
SCHGT Indicator: Bulk Material SCHGT CHAR 1 0
X Yes
NULL No
RVRSL Selection of BOM items relevant to sales and distribution RVRSL CHAR 1 0
X All relevant to sales
3 All not relevant to sales
STKKZ PM assembly indicator STKKZ CHAR 1 0
X Yes
NULL No
ERSKZ Indicator: spare part ERSKZ T413 CHAR 1 0
ERSSL Spare part selection ERSSL CHAR 1 0
X All spare parts
1 Spare parts relevant to production
2 Spare parts not relevant to production
BEIKZ Material Provision Indicator BEIKZ T417 CHAR 1 0
BESSL Selection for material provision BESSL CHAR 1 0
X All materials to be provided
1 Materials to be provided by customer
2 Materials to be provided to vendor
AEFRK Release for costing CC_AEFRK CHAR 1 0
X Yes
NULL No
AEFRP Release for planning CC_AEFRP CHAR 1 0
X Yes
NULL No
AEFRF Release for production CC_AEFRF CHAR 1 0
X Yes
NULL No
AEFRS Release for simulation CC_AEFRS CHAR 1 0
X Yes
NULL No
STPST Maximum explosion level of the BOM CS_MAXST DEC 3 0

TCNIFP foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
TCNIFP BEIKZ TCNIFP BEIKZ T417 Material Provision Indicators BEIKZ
TCNIFP BEIKZ TCNIFP MANDT T417 Material Provision Indicators MANDT
TCNIFP CAPID TCNIFP MANDT TC04 Applic-Specific Criteria for Alternative Determination MANDT
TCNIFP CAPID TCNIFP CAPID TC04 Applic-Specific Criteria for Alternative Determination CAPID
TCNIFP ERSKZ TCNIFP MANDT T413 Spare Part Indicators MANDT
TCNIFP ERSKZ TCNIFP ERSKZ T413 Spare Part Indicators ERSKZ
TCNIFP MANDT TCNIFP MANDT T000 Clients MANDT
TCNIFP POSTP TCNIFP MANDT T418 Item Categories MANDT
TCNIFP POSTP TCNIFP POSTP T418 Item Categories POSTP
TCNIFP RVREL TCNIFP MANDT TVRL Relevance of Bill of Material Items for SD MANDT
TCNIFP RVREL TCNIFP RVREL TVRL Relevance of Bill of Material Items for SD RVREL
TCNIFP SANKA TCNIFP SANKA TCK08 Indicator for Relevancy to Costing SELKZ
TCNIFP SANKA TCNIFP MANDT TCK08 Indicator for Relevancy to Costing MANDT
TCNIFP STLAN TCNIFP MANDT T416 BOM Usage - Item Statuses MANDT
TCNIFP STLAN TCNIFP STLAN T416 BOM Usage - Item Statuses STLAN
TCNIFP WERKS TCNIFP MANDT T001W Plants/Branches MANDT
TCNIFP WERKS TCNIFP WERKS T001W Plants/Branches WERKS