J_1BNFITMRULE SAP (Rules for Nota Fiscal Item Type) Table details

Dictionary Type: Table
Description: Rules for Nota Fiscal Item Type




ABAP Code to SELECT data from J_1BNFITMRULE
Related tables to J_1BNFITMRULE
Access table J_1BNFITMRULE




Table field list including key, data, relationships and ABAP select examples

J_1BNFITMRULE is a standard SAP Table which is used to store Rules for Nota Fiscal Item Type data and is available within R/3 SAP systems depending on the version and release level.

The J_1BNFITMRULE table consists of various fields, each holding specific information or linking keys about Rules for Nota Fiscal Item Type data available in SAP. These include ITMTYP (Nota Fiscal Item Type), DEFAULTTYP (Default Item Type for Nota Fiscal), ICMSSTAT (ICMS Statistic Flag for Nota Fiscal Tax Items), IPISTAT (IPI Statistic Flag for Nota Fiscal Tax Items).. 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: E - Control table, SAP and customer have separate key areas
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP J_1BNFITMRULE 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
MANDTClient MANDTCLNT3T000MANDT
ITMTYPNota Fiscal Item Type J_1BITMTYPCHAR2J_1BITEMTYPESALPHAJ_1BITMTYP
DEFAULTTYPDefault Item Type for Nota Fiscal J_1BRTDEFAULTCHAR1XFELD
ICMSSTATICMS Statistic Flag for Nota Fiscal Tax Items J_1BRTICMSSTATCHAR1J_1BICMSSTAT
IPISTATIPI Statistic Flag for Nota Fiscal Tax Items J_1BRTIPISTATCHAR1J_1BIPISTAT
CHECKGRGICheck Goods Issue/Goods Receipt J_1BRTCHECKGRGICHAR1XFELD
UNIQUEIVUnique Item Types for All Nota Fiscal Items J_1BRTUNIQUEIVCHAR1XFELD
NOREFIVPerform Reference Check for Unique Items J_1BRTNOREFIVCHAR1XFELD
IGNOREIMIgnore Reference in Inventory Management J_1BRTIGNOREIMCHAR1XFELD
CHECKDIRCheck Reference Based on Direction J_1BRTCHECKDIRCHAR1J_1BRTCHECKDIR
UNIQUEIMUnique Item for Inventory Management J_1BRTUNIQUEIMCHAR1XFELD
REFMDReference Material Document Required J_1BRTREFMDCHAR1XFELD
OBSERVATCheck for Observations J_1BRTOBSERVATCHAR1XFELD
EXCOTHBASICMSICMS Base Stored in Excluded or Other Base J_1BRTEXCOTHBASICMSCHAR1XFELD
EXCOTHBASIPIIPI Base Stored in Excluded or Other Base J_1BRTEXCOTHBASIPICHAR1XFELD
OTHBASICMS Base Stored in Excluded or Other Base J_1BRTOTHBASCHAR1XFELD
IGNORETOTALIgnore Total J_1BRTIGNORETOTALCHAR1XFELD
SKIPSkip Item J_1BRTSKIPCHAR1XFELD
REDMWSKZRedetermination of Tax Code in SD J_1BRTREDMWSKZCHAR1XFELD
MAINITEM1Main record type for mixed case in inventory management J_1BRTMAINITEMCHAR2J_1BITEMTYPESALPHAJ_1BITMTYP
MAINITEM2Main record type for mixed case in inventory management J_1BRTMAINITEMCHAR2J_1BITEMTYPESALPHAJ_1BITMTYP
MAINITEM3Main record type for mixed case in inventory management J_1BRTMAINITEMCHAR2J_1BITEMTYPESALPHAJ_1BITMTYP
MAINITEM4Main record type for mixed case in inventory management J_1BRTMAINITEMCHAR2J_1BITEMTYPESALPHAJ_1BITMTYP
MAINITEM5Main record type for mixed case in inventory management J_1BRTMAINITEMCHAR2J_1BITEMTYPESALPHAJ_1BITMTYP
MAINITEM6Main record type for mixed case in inventory management J_1BRTMAINITEMCHAR2J_1BITEMTYPESALPHAJ_1BITMTYP
MAINITEM7Main record type for mixed case in inventory management J_1BRTMAINITEMCHAR2J_1BITEMTYPESALPHAJ_1BITMTYP
MAINITEM8Main record type for mixed case in inventory management J_1BRTMAINITEMCHAR2J_1BITEMTYPESALPHAJ_1BITMTYP
MAINITEM9Main record type for mixed case in inventory management J_1BRTMAINITEMCHAR2J_1BITEMTYPESALPHAJ_1BITMTYP
MAINITEM10Main record type for mixed case in inventory management J_1BRTMAINITEMCHAR2J_1BITEMTYPESALPHAJ_1BITMTYP
TRANSFERItem Type for Transfers J_1BRTTRANSFERCHAR1XFELD
TRDPARTYThird-Party Shipment Item from Supplier J_1BRT3RDPARTYCHAR1XFELD
TEXTMOD1Number of the Report Text J_1BTEXTNRNUMC3J_1BMODTEXTNUMC3
TEXTMOD2Number of the Report Text J_1BTEXTNRNUMC3J_1BMODTEXTNUMC3
CLEARREF1Clear Reference in Modelos 1 and 2 J_1BCLEARREFCHAR1XFELD
CLEARREF2Clear Reference in Modelos 1 and 2 J_1BCLEARREFCHAR1XFELD

Key field Non-key field



How do I retrieve data from SAP table J_1BNFITMRULE using ABAP code

The following ABAP code Example will allow you to do a basic selection on J_1BNFITMRULE to SELECT all data from the table
DATA: WA_J_1BNFITMRULE TYPE J_1BNFITMRULE.

SELECT SINGLE *
FROM J_1BNFITMRULE
INTO CORRESPONDING FIELDS OF WA_J_1BNFITMRULE
WHERE...

How to access SAP table J_1BNFITMRULE

Within an ECC or HANA version of SAP you can also view further information about J_1BNFITMRULE and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!