TCNIFP SAP (Profile for BOM transfer) Table details
Dictionary Type: Table
Description: Profile for BOM transfer
Description: Profile for BOM transfer
Table field list including key, data, relationships and ABAP select examples
TCNIFP is a standard SAP Table which is used to store Profile for BOM transfer data and is available within R/3 SAP systems depending on the version and release level.
The TCNIFP table consists of various fields, each holding specific information or linking keys about Profile for BOM transfer data available in SAP. These include PROFILE (Profile for BOM transfer), BDMNG (Requirement Quantity), WERKS (Plant), MEHRS (Multilevel BOM Explosion).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: C - Customising table, maintenance only by custDisplay/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
Text table = TCNIFPT
SAP TCNIFP table fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
PROFILE | Profile for BOM transfer | PROFILE_IF | CHAR | 4 | PROFILE_IF | PSBM | |||
BDMNG | Requirement Quantity | BDMNG | QUAN | 13(3) | MENG13 | ||||
WERKS | Plant | WERKS_D | CHAR | 4 | T001W | WERKS | WRK | H_T001W_C | |
MEHRS | Multilevel BOM Explosion | CN_MEHRS | CHAR | 1 | XFELD | ||||
FLG_EXT | Copy data from external systems via user exit | EXT_SYST | CHAR | 1 | XFELD | ||||
FLG_ALL | Copy all bill of material items | CN_FLG_ALL | CHAR | 1 | XFELD | ||||
FLG_PRE | In general generate preliminary requirements | CN_FLG_PRE | CHAR | 1 | XFELD | ||||
FLG_MAT | Indicator: only take material BOMs into account | MAT_BOM | CHAR | 1 | XFELD | ||||
FLG_SALES | Indicator: Take sales order BOM into account | SALES_BOM | CHAR | 1 | XFELD | ||||
FLG_PROJECT | Indicator: Take project BOMs into account | PROJ_BOM | CHAR | 1 | XFELD | ||||
CAPID | Application | CAPID | CHAR | 4 | TC04 | CAPID | CSA | ||
STLAN | BOM Usage | STLAN | CHAR | 1 | T416 | STLAN | CSV | ||
NODLG | Indicator: Run without dialog, automatic data backup | CN_NODLG | CHAR | 1 | XFELD | ||||
AV_CHECK | Availability check during save | CN_AVCHK | CHAR | 1 | XFELD | ||||
FLG_UNIQUE | Indicator: Ambiguity check for reference points | CN_UNIQUE | CHAR | 1 | XFELD | ||||
SANKO | Indicator: item relevant to engineering | SANKO | CHAR | 1 | XFELD | ||||
POSTP | Item Category (Bill of Material) | POSTP | CHAR | 1 | T418 | POSTP | |||
SANFE | Indicator: item relevant to production | SANFE | CHAR | 1 | XFELD | ||||
SANKA | Indicator for Relevancy to Costing | CK_SELKZ | CHAR | 1 | TCK08 | CK_SELKZ | |||
SANIN | Indicator: item relevant to plant maintenance | SANIN | CHAR | 1 | XFELD | ||||
KLKSL | Selection of BOM items relevant to costing | KLKSL | CHAR | 1 | KLKSL | ||||
RVREL | Indicator: item relevant to sales | RVREL | CHAR | 1 | TVRL | RVREL | |||
SCHGT | Indicator: Bulk Material | SCHGT | CHAR | 1 | XFELD | ||||
RVRSL | Selection of BOM items relevant to sales and distribution | RVRSL | CHAR | 1 | RVRSL | ||||
STKKZ | PM assembly indicator | STKKZ | CHAR | 1 | XFELD | ||||
ERSKZ | Indicator: spare part | ERSKZ | CHAR | 1 | T413 | ERSKZ | |||
ERSSL | Spare part selection | ERSSL | CHAR | 1 | ERSSL | ||||
BEIKZ | Material Provision Indicator | BEIKZ | CHAR | 1 | T417 | BEIKZ | |||
BESSL | Selection for material provision | BESSL | CHAR | 1 | BESSL | ||||
AEFRK | Release for costing | CC_AEFRK | CHAR | 1 | CC_XFELD | ||||
AEFRP | Release for planning | CC_AEFRP | CHAR | 1 | CC_XFELD | ||||
AEFRF | Release for production | CC_AEFRF | CHAR | 1 | CC_XFELD | ||||
AEFRS | Release for simulation | CC_AEFRS | CHAR | 1 | CC_XFELD | ||||
STPST | Maximum explosion level of the BOM | CS_MAXST | DEC | 3 | DEC3 |
Key field | Non-key field |
How do I retrieve data from SAP table TCNIFP using ABAP code
The following ABAP code Example will allow you to do a basic selection on TCNIFP to SELECT all data from the tableDATA: WA_TCNIFP TYPE TCNIFP.
SELECT SINGLE *
FROM TCNIFP
INTO CORRESPONDING FIELDS OF WA_TCNIFP
WHERE...
How to access SAP table TCNIFP
Within an ECC or HANA version of SAP you can also view further information about TCNIFP and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects