SAP table J_1BNFE_ACTIVE (Electronic Nota Fiscal: Actual Status)

SAP table J_1BNFE_ACTIVE has 2 primary key fields being MANDT,DOCNUM.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 MANDT
DOCNUM Document Number NUMC 10 0 J_1BDOCNUM
DOCSTA Document Status CHAR 1 0 J_1BNFEDOCSTATUS
Initial
1 Authorized
2 Rejected
3 Denied
SCSSTA System Communication Status CHAR 1 0 J_1BNFESCSSTATUS
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
D Administrative Process
E Request to EPEC rejected
CONTING Document Posted under Contingency CHAR 1 0 J_1BCONTINGENCY
CANCEL Canceled CHAR 1 0 J_1BCANCEL
CODE Official Status Code CHAR 3 0 J_1BSTATUSCODE
REGIO Region of Document Issuer CHAR 2 0 J_1BREGIO
NFYEAR Year of Document Date CHAR 2 0 J_1BYEAR
NFMONTH Month of Document Date CHAR 2 0 J_1BMONTH
STCD1 CNPJ/CPF Number of Document Issuer CHAR 14 0 J_1BSTCD1
MODEL Model of Nota Fiscal NUMC 2 0 J_1BMODEL
01 Nota Fiscal - Model 1/1A
02 Nota Fiscal - Consumption
03 Nota Fiscal - Entrada
04 Nota Fiscal - Production
06 Nota Fiscal - Electrical Energy
07 Nota Fiscal - Transportation Service
08 Conhecimento - Road
09 Conhecimento - Inland Waterways
10 Conhecimento - Air
11 Conhecimento - Train
21 Nota Fiscal - Communication Service
22 Nota Fiscal - Telecommunication Service
55 Nota Fiscal - Model 55
57 Conhecimento de Transporte Eletrônico (CT-e) Model 57
66 Electronic Nota Fiscal for Energy
67 Conhecimento de Transporte Eletrônico (CT-e OS) Model 67
SERIE Series CHAR 3 0 J_1BSERIES
NFNUM9 Electronic Nota Fiscal Number CHAR 9 0 J_1BNFNUM9
DOCNUM9 Random Number in Access Key CHAR 9 0 J_1BDOCNUM9
CDV Check Digit in Access Key CHAR 1 0 J_1BCHECKDIGIT
AUTHCOD Protocol Number CHAR 15 0 J_1BNFEAUTHCODE
CREDAT Create date DATS 8 0 J_1BCREDAT
ACTION_DATE Date of Change to Document DATS 8 0 J_1BNFE_ACTION_DATE
ACTION_TIME Time of Change to Document TIMS 6 0 J_1BNFE_ACTION_TIME
ACTION_USER User Who Made Change to Document CHAR 12 0 J_1BNFE_ACTION_USER
BUKRS Company Code CHAR 4 0 BUKRS
BRANCH Business Place CHAR 4 0 J_1BBRANC_
VSTEL Shipping Point / Receiving Point CHAR 4 0 VSTEL
PARID Partner ID (Customer, Vendor, Business Place) CHAR 10 0 J_1BPARID
PARTYP Nota Fiscal Partner Type CHAR 1 0 J_1BPARTYP
B Business Place
C Customer
V Vendor
DIRECT Direction of the movement CHAR 1 0 J_1BDIRECT
1 Incoming
2 Outgoing
3 Outgoing Returns of Stock Transfers
4 Incoming Returns of Stock Transfers
REFNUM Number of Reference Document NUMC 10 0 J_1BNFE_REFNUM
FORM Form of Electronic Fiscal Document CHAR 4 0 J_1BFORM
ACTION_REQU Required Process Step CHAR 1 0 J_1BNFE_ACTION_REQUIRED
In process; no manual action required
0 Set documen no. and send to tax authorities via batch report
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
A Numbering will be done via batch report; no action required
B Sending will be done via batch report; no action required
C Completed
D Validation error from messaging system; request canc. again
PRINTD Printed CHAR 1 0 J_1BPRINTD
CONTING_S Switched to Contingency CHAR 1 0 J_1BCONTINGENCY_NFE_SWITCHED
MSSTAT Status from Messaging System CHAR 1 0 J_1BNFE_MS_STATUS
A Request for authorization received by MS
B Cancellation request received by MS
C Skipping request received by MS
D Error from MS: Data inconsistency between ERP and MS
G Error from MS: Request cannot be sent to authorities
V Internal validation error returned from MS
REASON Reason for Cancellation/Skipping CHAR 2 0 J_1BNFE_CANCELR J_1BNFE_CANCEL_REASON
REASON1 Text for Cancellation/Skipping Reason CHAR 64 0 J_1BNFE_CANCEL_TEXT
REASON2 Text for Cancellation/Skipping Reason CHAR 64 0 J_1BNFE_CANCEL_TEXT
REASON3 Text for Cancellation/Skipping Reason CHAR 64 0 J_1BNFE_CANCEL_TEXT
REASON4 Text for Cancellation/Skipping Reason CHAR 64 0 J_1BNFE_CANCEL_TEXT
CRENAM Name of the user CHAR 12 0 J_1BCRENAM
CALLRFC Control Doc. No. and RFC Execution to Messaging System CHAR 1 0 J_1BNFERFCCALL
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) CHAR 1 0 J_1BNFETPAMB
Derived from Client Role (T000-CCCATEGORY)
1 Production
2 Homologation (Test)
SEFAZ_ACTIVE SEFAZ Server is Active CHAR 1 0 J_1BNFE_SEFAZ_ACTIVE
SCAN_ACTIVE SCAN Server is Active CHAR 1 0 J_1BNFE_SCAN_ACTIVE
CHECKTMPL UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) DEC 21 7 TIMESTAMPL
AUTHDATE Processing Timestamp - Date DATS 8 0 J_1BAUTHDATE
AUTHTIME Processing Timestamp - Time TIMS 6 0 J_1BAUTHTIME
TPEMIS Issuing Type CHAR 1 0 J_1BNFE_TPEMIS
1 Normal
2 Contingency FS (Security Form for DANFE)
3 NFF Special Regime / Contingency SCAN (disabled)
4 Contingency DPEC
5 Contingency FS-DA (Security Form for DANFE & DACTE)
6 Contingency SVC National
7 Contingency SVCRS Rio Grande do Sul
8 Contingency SVCSP São Paulo
REASON_CONTING Reason for Contingency CHAR 2 0 J_1BNFE_CONTINR J_1BNFE_CONTINGENCY_REASON
REASON_CONTING1 Text for Contingency Reason CHAR 64 0 J_1BNFE_CONTINGENCY_TEXT
REASON_CONTING2 Text for Contingency Reason CHAR 64 0 J_1BNFE_CONTINGENCY_TEXT
REASON_CONTING3 Text for Contingency Reason CHAR 64 0 J_1BNFE_CONTINGENCY_TEXT
REASON_CONTING4 Text for Contingency Reason CHAR 64 0 J_1BNFE_CONTINGENCY_TEXT
CONTING_DATE Contingency Date DATS 8 0 J_1BNFE_CONTINGENCY_DATE
CONTING_TIME Contingency Time TIMS 6 0 J_1BNFE_CONTINGENCY_TIME
CONTIN_TIME_ZONE Time Zone CHAR 6 0 TZNZONE
CANCEL_ALLOWED Cancellation Allowed by Authorities CHAR 1 0 J_1BNFE_CANCEL_ALLOWED
SOURCE Source of Entry CHAR 1 0 J_1BNFE_SOURCE
Standard
1 Incoming Automation Interface
CANCEL_PA Cancel Prior to Authorization CHAR 1 0 J_1BNFE_CANCEL_PA
EVENT_FLAG Checkbox CHAR 1 0 XFELD
No
X Yes
ACTIVE_SERVICE Active Service of Tax Authorities CHAR 2 0 J_1BNFE_ACTIVE_SERVICE
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
05 SVC National (91)
99 Error during determination of active service
SVC_SP_ACTIVE SVC SP Contingency Active CHAR 1 0 J_1BNFE_SVCSP_ACTIVE
SVC_RS_ACTIVE SVC RS Contingency Active CHAR 1 0 J_1BNFE_SVCRS_ACTIVE
SVC_ACTIVE Contingency SVC Active CHAR 1 0 J_1BNFE_SVC_ACTIVE
RPS Provisory Service Receipt (RPS) NUMC 6 0 J_1B_PROVISORY_SERVICE_RECEIPT
NFSE_NUMBER Service NF-e Number CHAR 20 0 J_1BPREFNO
NFSE_CHECK_CODE Verification Code of Service NF-e CHAR 20 0 J_1BCHECOD
CODE_DESCRIPTION Official Status Code Description CHAR 255 0 J_1BNFE_CODE_DESCRIPTION
CMSG SEFAZ Message Code CHAR 4 0 J_1BNFE_CMSG
XMSG SEFAZ Message Description CHAR 200 0 J_1BNFE_XMSG
CLOUD_GUID Document Universal Unique Identifier (UUID) CHAR 36 0 NFE_DOCUMENT_UUID
CLOUD_EXTENS_FLAG Extension values CHAR 1 0 NFE_EXTENS_FLAG
REPLACEMENT_STATUS NFS-e: Replacement Status CHAR 1 0 NFE_REPLACEMENT_STATUS
No status
1 To be replaced
2 Replaced
CLOUD_LOG_STATUS Cloud Log Status CHAR 1 0 NFE_CLOUD_LOG_STATUS
No logs
1 Attempt Status Logs

J_1BNFE_ACTIVE foreign key relationships

Table Field Check Table Check Field
0 J_1BNFE_ACTIVE REASON J_1BNFE_CANCELR NF-e: Reason for Cancel / Skip MANDT
1 J_1BNFE_ACTIVE REASON_CONTING J_1BNFE_CONTINR NFe: Reason for Contingency MANDT