1. Home
  2. Resources
  3. SAP Tables
  4. J_1BNFE_ACTIVE - Electronic Nota Fiscal: Actual Status

SAP Table J_1BNFE_ACTIVE

Electronic Nota Fiscal: Actual Status

J_1BNFE_ACTIVE (Electronic Nota Fiscal: Actual Status) 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 J_1BNFE_ACTIVE to other SAP tables.

Source: J_1BNFE_ACTIVE (Electronic Nota Fiscal: Actual Status)

J_1BNFE_ACTIVE table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT CLNT 3 0
DOCNUM Document Number J_1BDOCNUM NUMC 10 0
DOCSTA Document Status J_1BNFEDOCSTATUS CHAR 1 0
NULL Initial
1 Authorized
2 Rejected
3 Denied
SCSSTA System Communication Status J_1BNFESCSSTATUS CHAR 1 0
NULL Not sent
0 Sent to Messaging System (XI,...)
1 Authorized & Author. for Cancellation Requested
2 Authorized & Cancellation Authorized
3 Rejected & Author. for Skipping Requested
4 Rejected & Skipping (Cancel) Authorized
5 Switched to Contingency/Canceled Prior to Author.
6 Request to Cancel Rejected
7 Request to Skip Rejected
8 Rejection to Cancel/Skip Accepted by User
9 Validation Error & Skipping Requested
A Validation Error & Skipping Authorized
B Validation Error & Skipping Rejected
C Switched to Contingency / CPA with new document creation
CONTING Document Posted under Contingency J_1BCONTINGENCY CHAR 1 0
X Yes
NULL No
CANCEL Canceled J_1BCANCEL CHAR 1 0
X Yes
NULL No
CODE Official Status Code J_1BSTATUSCODE CHAR 3 0
REGIO Region of Document Issuer J_1BREGIO CHAR 2 0
NFYEAR Year of Document Date J_1BYEAR CHAR 2 0
NFMONTH Month of Document Date J_1BMONTH CHAR 2 0
STCD1 CNPJ Number of Document Issuer J_1BSTCD1 CHAR 14 0
MODEL Model of Nota Fiscal J_1BMODEL NUMC 2 0
10 Conhecimento - Air
11 Conhecimento - Train
09 Conhecimento - Inland Waterways
08 Conhecimento - Road
01 Nota Fiscal - Model 1/1A
06 Nota Fiscal - Eletrical Energy
03 Nota Fiscal - Entrada
21 Nota Fiscal - Comunication Service
22 Nota Fiscal - Telecomunication Service
07 Nota Fiscal - Transportation Service
02 Nota Fiscal - Consumption
04 Nota Fiscal - Production
55 Nota Fiscal - Model 55
57 Conhecimento de Transporte electronico (CT-e) Model 57
SERIE Series J_1BSERIES CHAR 3 0
NFNUM9 Nine-Digit Document Number J_1BNFNUM9 CHAR 9 0
DOCNUM9 Random Number in Access Key J_1BDOCNUM9 CHAR 9 0
CDV Check Digit in Access Key J_1BCHECKDIGIT CHAR 1 0
AUTHCOD Protocol Number J_1BNFEAUTHCODE CHAR 15 0
CREDAT Create date J_1BCREDAT DATS 8 0
ACTION_DATE Date of Change to Document J_1BNFE_ACTION_DATE DATS 8 0
ACTION_TIME Time of Change to Document J_1BNFE_ACTION_TIME TIMS 6 0
ACTION_USER User Who Made Change to Document J_1BNFE_ACTION_USER CHAR 12 0
BUKRS Company Code BUKRS CHAR 4 0
BRANCH Business Place J_1BBRANC_ CHAR 4 0
VSTEL Shipping Point/Receiving Point VSTEL CHAR 4 0
PARID Partner ID (Customer, Vendor, Business Place) J_1BPARID CHAR 10 0
PARTYP Nota Fiscal Partner Type J_1BPARTYP CHAR 1 0
B Business Place
C Customer
V Vendor
DIRECT Direction of the movement J_1BDIRECT CHAR 1 0
1 Incoming
2 Outgoing
3 Outgoing Returns of Stock Transfers
4 Incoming Returns of Stock Transfers
REFNUM Number of Reference Document J_1BNFE_REFNUM NUMC 10 0
FORM Form of Nota Fiscal J_1BFORM CHAR 4 0
ACTION_REQU Required Process Step J_1BNFE_ACTION_REQUIRED CHAR 1 0
NULL In process; no manual action required
C Completed
1 Cancel doc. & and post new one/Reset doc. & and send again
2 Cancel source document
3 Send document to tax authorities
4 Request to cancel rejected; check the reason
5 Request to skip rejected; check the reason
6 Enter protocol number
7 Req. authorization from tax authorities to cancel/skip doc.
8 Internal validation error in messaging system; send again!
9 Set document no. and send to tax authorities
0 Set documen no. and send to tax authorities via batch report
A Numbering will be done via batch report; no action required
B Sending will be done via batch report; no action required
D Validation error from messaging system; request canc. again
PRINTD Printed J_1BPRINTD CHAR 1 0
X Yes
NULL No
CONTING_S Switched to Contingency J_1BCONTINGENCY_NFE_SWITCHED CHAR 1 0
X Yes
NULL No
MSSTAT Status from Messaging System J_1BNFE_MS_STATUS CHAR 1 0
A Request for authorization received by MS
B Cancellation request received by MS
C Skipping request received by MS
G Error from MS: Request cannot be sent to authorities
V Internal validation error returned from MS
D Error from MS: Data inconsistency between ERP and MS
REASON Reason for Cancellation/Skipping J_1BNFE_CANCEL_REASON J_1BNFE_CANCELR CHAR 2 0
REASON1 Text for Cancellation/Skipping Reason J_1BNFE_CANCEL_TEXT CHAR 64 0
REASON2 Text for Cancellation/Skipping Reason J_1BNFE_CANCEL_TEXT CHAR 64 0
REASON3 Text for Cancellation/Skipping Reason J_1BNFE_CANCEL_TEXT CHAR 64 0
REASON4 Text for Cancellation/Skipping Reason J_1BNFE_CANCEL_TEXT CHAR 64 0
CRENAM Name of the user J_1BCRENAM CHAR 12 0
CALLRFC Control Doc. No. and RFC Execution to Messaging System J_1BNFERFCCALL CHAR 1 0
NULL RFC execution and database update in the same LUW (default)
1 Numbering & RFC triggered via the Monitor Report (J1BNFE)
2 Numbering in Monitor Report - RFC via batch report
3 Numbering & RFC triggered via Batch report (J_BNFECALLRFC)
TPAMB Type of Environment (Test or Production) J_1BNFETPAMB CHAR 1 0
1 Production
2 Homologation (Test)
NULL Derived from Client Role (T000-CCCATEGORY)
SEFAZ_ACTIVE SEFAZ Server is Active J_1BNFE_SEFAZ_ACTIVE CHAR 1 0
X Yes
NULL No
SCAN_ACTIVE SCAN Server is Active J_1BNFE_SCAN_ACTIVE CHAR 1 0
X Yes
NULL No
CHECKTMPL UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) TIMESTAMPL DEC 21 7
AUTHDATE Processing Timestamp - Date J_1BAUTHDATE DATS 8 0
AUTHTIME Processing Timestamp - Time J_1BAUTHTIME TIMS 6 0
TPEMIS Issuing Type J_1BNFE_TPEMIS CHAR 1 0
1 Normal
2 Contingency FS (Security Form for DANFE)
3 Contingency SCAN
4 Contingency DPEC
5 Contingency FS-DA (Security Form for DANFE & DACTE)
7 Contingency SVCRS Rio Grande do Sul
8 Contingency SVCSP São Paulo
REASON_CONTING Reason for Contingency J_1BNFE_CONTINGENCY_REASON J_1BNFE_CONTINR CHAR 2 0
REASON_CONTING1 Text for Contingency Reason J_1BNFE_CONTINGENCY_TEXT CHAR 64 0
REASON_CONTING2 Text for Contingency Reason J_1BNFE_CONTINGENCY_TEXT CHAR 64 0
REASON_CONTING3 Text for Contingency Reason J_1BNFE_CONTINGENCY_TEXT CHAR 64 0
REASON_CONTING4 Text for Contingency Reason J_1BNFE_CONTINGENCY_TEXT CHAR 64 0
CONTING_DATE Contingency Date J_1BNFE_CONTINGENCY_DATE DATS 8 0
CONTING_TIME Contingency Time J_1BNFE_CONTINGENCY_TIME TIMS 6 0
CONTIN_TIME_ZONE Time Zone TZNZONE CHAR 6 0
CANCEL_ALLOWED Cancellation Allowed by Authorities J_1BNFE_CANCEL_ALLOWED CHAR 1 0
X Yes
NULL No
SOURCE Source of Entry J_1BNFE_SOURCE CHAR 1 0
NULL Standard
1 Incoming Automation Interface
CANCEL_PA Cancel Prior to Authorization J_1BNFE_CANCEL_PA CHAR 1 0
X Yes
NULL No
EVENT_FLAG Checkbox XFELD CHAR 1 0
X Yes
NULL No
ACTIVE_SERVICE Active Service of Tax Authorities J_1BNFE_ACTIVE_SERVICE CHAR 2 0
NULL No active service
01 SEFAZ is active
02 SCAN is active
03 SVCSP São Paulo is active
04 SVCRS Rio Grande do Sul is active
99 Error during determination of active service

J_1BNFE_ACTIVE foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
J_1BNFE_ACTIVE REASON J_1BNFE_ACTIVE MANDT J_1BNFE_CANCELR NF-e: Reason for Cancel / Skip MANDT
J_1BNFE_ACTIVE REASON J_1BNFE_ACTIVE REASON J_1BNFE_CANCELR NF-e: Reason for Cancel / Skip REASON
J_1BNFE_ACTIVE REASON_CONTING J_1BNFE_ACTIVE MANDT J_1BNFE_CONTINR NFe: Reason for Contingency MANDT
J_1BNFE_ACTIVE REASON_CONTING J_1BNFE_ACTIVE REASON_CONTING J_1BNFE_CONTINR NFe: Reason for Contingency REASON