Follow us on LinkedIn for your next SAP project

← Back to Search

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.

J_1BNFE_ACTIVE table fields

Field

Data element

Checktable

Datatype

Length

Decimals

Possible values

MANDT

Client

MANDT

CLNT

DOCNUM

Document Number

J_1BDOCNUM

NUMC

DOCSTA

Document Status

J_1BNFEDOCSTATUS

CHAR

Value	Description
NULL	Initial
1	Authorized
2	Rejected
3	Denied

SCSSTA

System Communication Status

J_1BNFESCSSTATUS

CHAR

Value	Description
NULL	Not sent
NULL	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

Value	Description
X	Yes
NULL	No

CANCEL

Canceled

J_1BCANCEL

CHAR

Value	Description
X	Yes
NULL	No

CODE

Official Status Code

J_1BSTATUSCODE

CHAR

REGIO

Region of Document Issuer

J_1BREGIO

CHAR

NFYEAR

Year of Document Date

J_1BYEAR

CHAR

NFMONTH

Month of Document Date

J_1BMONTH

CHAR

STCD1

CNPJ Number of Document Issuer

J_1BSTCD1

CHAR

MODEL

Model of Nota Fiscal

J_1BMODEL

NUMC

Value	Description
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

NFNUM9

Nine-Digit Document Number

J_1BNFNUM9

CHAR

DOCNUM9

Random Number in Access Key

J_1BDOCNUM9

CHAR

CDV

Check Digit in Access Key

J_1BCHECKDIGIT

CHAR

AUTHCOD

Protocol Number

J_1BNFEAUTHCODE

CHAR

CREDAT

Create date

J_1BCREDAT

DATS

ACTION_DATE

Date of Change to Document

J_1BNFE_ACTION_DATE

DATS

ACTION_TIME

Time of Change to Document

J_1BNFE_ACTION_TIME

TIMS

ACTION_USER

User Who Made Change to Document

J_1BNFE_ACTION_USER

CHAR

BUKRS

Company Code

BUKRS

CHAR

BRANCH

Business Place

J_1BBRANC_

CHAR

VSTEL

Shipping Point/Receiving Point

VSTEL

CHAR

PARID

Partner ID (Customer, Vendor, Business Place)

J_1BPARID

CHAR

PARTYP

Nota Fiscal Partner Type

J_1BPARTYP

CHAR

Value	Description
B	Business Place
C	Customer
V	Vendor

DIRECT

Direction of the movement

J_1BDIRECT

CHAR

Value	Description
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

FORM

Form of Nota Fiscal

J_1BFORM

CHAR

ACTION_REQU

Required Process Step

J_1BNFE_ACTION_REQUIRED

CHAR

Value	Description
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
NULL	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

Value	Description
X	Yes
NULL	No

CONTING_S

Switched to Contingency

J_1BCONTINGENCY_NFE_SWITCHED

CHAR

Value	Description
X	Yes
NULL	No

MSSTAT

Status from Messaging System

J_1BNFE_MS_STATUS

CHAR

Value	Description
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

REASON1

Text for Cancellation/Skipping Reason

J_1BNFE_CANCEL_TEXT

CHAR

REASON2

Text for Cancellation/Skipping Reason

J_1BNFE_CANCEL_TEXT

CHAR

REASON3

Text for Cancellation/Skipping Reason

J_1BNFE_CANCEL_TEXT

CHAR

REASON4

Text for Cancellation/Skipping Reason

J_1BNFE_CANCEL_TEXT

CHAR

CRENAM

Name of the user

J_1BCRENAM

CHAR

CALLRFC

Control Doc. No. and RFC Execution to Messaging System

J_1BNFERFCCALL

CHAR

Value	Description
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

Value	Description
1	Production
2	Homologation (Test)
NULL	Derived from Client Role (T000-CCCATEGORY)

SEFAZ_ACTIVE

SEFAZ Server is Active

J_1BNFE_SEFAZ_ACTIVE

CHAR

Value	Description
X	Yes
NULL	No

SCAN_ACTIVE

SCAN Server is Active

J_1BNFE_SCAN_ACTIVE

CHAR

Value	Description
X	Yes
NULL	No

CHECKTMPL

UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)

TIMESTAMPL

DEC

AUTHDATE

Processing Timestamp - Date

J_1BAUTHDATE

DATS

AUTHTIME

Processing Timestamp - Time

J_1BAUTHTIME

TIMS

TPEMIS

Issuing Type

J_1BNFE_TPEMIS

CHAR

Value	Description
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

REASON_CONTING

Reason for Contingency

J_1BNFE_CONTINGENCY_REASON

J_1BNFE_CONTINR

CHAR

REASON_CONTING1

Text for Contingency Reason

J_1BNFE_CONTINGENCY_TEXT

CHAR

REASON_CONTING2

Text for Contingency Reason

J_1BNFE_CONTINGENCY_TEXT

CHAR

REASON_CONTING3

Text for Contingency Reason

J_1BNFE_CONTINGENCY_TEXT

CHAR

REASON_CONTING4

Text for Contingency Reason

J_1BNFE_CONTINGENCY_TEXT

CHAR

CONTING_DATE

Contingency Date

J_1BNFE_CONTINGENCY_DATE

DATS

CONTING_TIME

Contingency Time

J_1BNFE_CONTINGENCY_TIME

TIMS

CONTIN_TIME_ZONE

Time Zone

TZNZONE

CHAR

CANCEL_ALLOWED

Cancellation Allowed by Authorities

J_1BNFE_CANCEL_ALLOWED

CHAR

Value	Description
X	Yes
NULL	No

SOURCE

Source of Entry

J_1BNFE_SOURCE

CHAR

Value	Description
NULL	Standard
1	Incoming Automation Interface

CANCEL_PA

Cancel Prior to Authorization

J_1BNFE_CANCEL_PA

CHAR

Value	Description
X	Yes
NULL	No

EVENT_FLAG

Checkbox

XFELD

CHAR

Value	Description
X	Yes
NULL	No

ACTIVE_SERVICE

Active Service of Tax Authorities

J_1BNFE_ACTIVE_SERVICE

CHAR

Value	Description
NULL	No active service
01	SEFAZ is active
02	SCAN is active
03
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