J_1BNFE_HISTORY SAP (Electronic Nota Fiscal - History) Table details

Dictionary Type: Table
Description: Electronic Nota Fiscal - History




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




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

J_1BNFE_HISTORY is a standard SAP Table which is used to store Electronic Nota Fiscal - History data and is available within R/3 SAP systems depending on the version and release level.

The J_1BNFE_HISTORY table consists of various fields, each holding specific information or linking keys about Electronic Nota Fiscal - History data available in SAP. These include DOCNUM (Document Number), DOCSTA (Document Status), SCSSTA (System Communication Status), COUNTER (Counter (Key Field for History Table)).. 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: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP J_1BNFE_HISTORY 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 MANDTCLNT3Assigned to domainMANDT
DOCNUMDocument Number J_1BDOCNUMNUMC10Assigned to domainJ_1BDOCNUMJEF
DOCSTADocument Status J_1BNFEDOCSTATUSCHAR1J_1BNFEDOCSTATUS
SCSSTASystem Communication Status J_1BNFESCSSTATUSCHAR1J_1BNFESCSSTATUS
COUNTERCounter (Key Field for History Table) J_1BNFE_HISTORY_COUNTERNUMC3
CONTINGDocument Posted under Contingency J_1BCONTINGENCYCHAR1XFELD
CANCELCanceled J_1BCANCELCHAR1XFELD
CODEOfficial Status Code J_1BSTATUSCODECHAR3Assigned to domainALPHAJ_1BSTATUSCODE
ACTION_DATEDate of Change to Document J_1BNFE_ACTION_DATEDATS8DATUM
ACTION_TIMETime of Change to Document J_1BNFE_ACTION_TIMETIMS6UZEIT
ACTION_USERUser Who Made Change to Document J_1BNFE_ACTION_USERCHAR12USNAM
AUTHCODProtocol Number J_1BNFEAUTHCODECHAR15J_1BNFEAUTHCODE
PRINTDPrinted J_1BPRINTDCHAR1XFELD
CONTING_SSwitched to Contingency J_1BCONTINGENCY_NFE_SWITCHEDCHAR1XFELD
MSSTATStatus from Messaging System J_1BNFE_MS_STATUSCHAR1J_1BNFE_MS_STATUS
REASONReason for Cancellation/Skipping J_1BNFE_CANCEL_REASONCHAR2Assigned to domainJ_1BNFE_CANCEL_REASON
REASON1Text for Cancellation/Skipping Reason J_1BNFE_CANCEL_TEXTCHAR64J_1BNFE_CANCEL_TEXT
REASON2Text for Cancellation/Skipping Reason J_1BNFE_CANCEL_TEXTCHAR64J_1BNFE_CANCEL_TEXT
REASON3Text for Cancellation/Skipping Reason J_1BNFE_CANCEL_TEXTCHAR64J_1BNFE_CANCEL_TEXT
REASON4Text for Cancellation/Skipping Reason J_1BNFE_CANCEL_TEXTCHAR64J_1BNFE_CANCEL_TEXT
CALLRFCControl Doc. No. and RFC Execution to Messaging System J_1BNFERFCCALLCHAR1J_1BNFERFCCALL
NFNUM9Nine-Digit Document Number J_1BNFNUM9CHAR9J_1BNFNUM9
REGIORegion of Document Issuer J_1BREGIOCHAR2J_1BREGIO
TPAMBType of Environment (Test or Production) J_1BNFETPAMBCHAR1J_1BNFETPAMB
SEFAZ_ACTIVESEFAZ Server is Active J_1BNFE_SEFAZ_ACTIVECHAR1XFELD
SCAN_ACTIVESCAN Server is Active J_1BNFE_SCAN_ACTIVECHAR1XFELD
CHECKTMPLUTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) TIMESTAMPLDEC21(7) TZNTSTMPL
AUTHDATEProcessing Timestamp - Date J_1BAUTHDATEDATS8DATUM
AUTHTIMEProcessing Timestamp - Time J_1BAUTHTIMETIMS6UZEIT
TPEMISIssuing Type J_1BNFE_TPEMISCHAR1J_1BNFE_TPEMIS
REASON_CONTINGReason for Contingency J_1BNFE_CONTINGENCY_REASONCHAR2Assigned to domainJ_1BNFE_CONTINGENCY_REASON
REASON_CONTING1Text for Contingency Reason J_1BNFE_CONTINGENCY_TEXTCHAR64J_1BNFE_CONTINGENCY_TEXT
REASON_CONTING2Text for Contingency Reason J_1BNFE_CONTINGENCY_TEXTCHAR64J_1BNFE_CONTINGENCY_TEXT
REASON_CONTING3Text for Contingency Reason J_1BNFE_CONTINGENCY_TEXTCHAR64J_1BNFE_CONTINGENCY_TEXT
REASON_CONTING4Text for Contingency Reason J_1BNFE_CONTINGENCY_TEXTCHAR64J_1BNFE_CONTINGENCY_TEXT
CONTING_DATEContingency Date J_1BNFE_CONTINGENCY_DATEDATS8DATUM
CONTING_TIMEContingency Time J_1BNFE_CONTINGENCY_TIMETIMS6UZEIT
CONTIN_TIME_ZONETime Zone TZNZONECHAR6Assigned to domainTZNZONE
CANCEL_ALLOWEDCancellation Allowed by Authorities J_1BNFE_CANCEL_ALLOWEDCHAR1XFELD
CANCEL_PACancel Prior to Authorization J_1BNFE_CANCEL_PACHAR1XFELD
ACTIVE_SERVICEActive Service of Tax Authorities J_1BNFE_ACTIVE_SERVICECHAR2J_1BNFE_ACTIVE_SERVICE
ACTION_REQURequired Process Step J_1BNFE_ACTION_REQUIREDCHAR1J_1BNFE_ACTION_REQUIRED

Key field Non-key field



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

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

SELECT SINGLE *
FROM J_1BNFE_HISTORY
INTO CORRESPONDING FIELDS OF WA_J_1BNFE_HISTORY
WHERE...

How to access SAP table J_1BNFE_HISTORY

Within an ECC or HANA version of SAP you can also view further information about J_1BNFE_HISTORY 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!