SAP ABAP Table J_1BNFE_ACTIVE (Electronic Nota Fiscal: Actual Status)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-LOC-BR (Application Component) Brazil
     ⤷ J1BA (Package) Localization Brazil

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	J_1BNFE_ACTIVE	Table Relationship Diagram
Short Description	Electronic Nota Fiscal: Actual Status

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	*
2	DOCNUM	☑	J_1BDOCNUM	J_1BDOCNUM	NUMC	10	0	Document Number	*
3	DOCSTA	☐	J_1BNFEDOCSTATUS	J_1BNFEDOCSTATUS	CHAR	1	0	Document Status
4	SCSSTA	☐	J_1BNFESCSSTATUS	J_1BNFESCSSTATUS	CHAR	1	0	System Communication Status
5	CONTING	☐	J_1BCONTINGENCY	XFELD	CHAR	1	0	Document Posted under Contingency
6	CANCEL	☐	J_1BCANCEL	XFELD	CHAR	1	0	Canceled
7	CODE	☐	J_1BSTATUSCODE	J_1BSTATUSCODE	CHAR	3	0	Official Status Code	*
8	REGIO	☐	J_1BREGIO	J_1BREGIO	CHAR	2	0	Region of Document Issuer
9	NFYEAR	☐	J_1BYEAR	J_1BYEAR	CHAR	2	0	Year of Document Date
10	NFMONTH	☐	J_1BMONTH	J_1BMONTH	CHAR	2	0	Month of Document Date
11	STCD1	☐	J_1BSTCD1	J_1BSTCD1	CHAR	14	0	CNPJ Number of Document Issuer
12	MODEL	☐	J_1BMODEL	J_1BMODEL	NUMC	2	0	Model of Nota Fiscal
13	SERIE	☐	J_1BSERIES	J_1BSERIES	CHAR	3	0	Series
14	NFNUM9	☐	J_1BNFNUM9	J_1BNFNUM9	CHAR	9	0	Nine-Digit Document Number
15	DOCNUM9	☐	J_1BDOCNUM9	J_1BDOCNUM9	CHAR	9	0	Random Number in Access Key
16	CDV	☐	J_1BCHECKDIGIT	J_1BCHECKDIGIT	CHAR	1	0	Check Digit in Access Key
17	AUTHCOD	☐	J_1BNFEAUTHCODE	J_1BNFEAUTHCODE	CHAR	15	0	Protocol Number
18	CREDAT	☐	J_1BCREDAT	DATUM	DATS	8	0	Create date
19	ACTION_DATE	☐	J_1BNFE_ACTION_DATE	DATUM	DATS	8	0	Date of Change to Document
20	ACTION_TIME	☐	J_1BNFE_ACTION_TIME	UZEIT	TIMS	6	0	Time of Change to Document
21	ACTION_USER	☐	J_1BNFE_ACTION_USER	USNAM	CHAR	12	0	User Who Made Change to Document
22	BUKRS	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
23	BRANCH	☐	J_1BBRANC_	J_1BBRANCH	CHAR	4	0	Business Place	*
24	VSTEL	☐	VSTEL	VSTEL	CHAR	4	0	Shipping Point/Receiving Point	*
25	PARID	☐	J_1BPARID	J_1BPARID	CHAR	10	0	Partner ID (Customer, Vendor, Business Place)
26	PARTYP	☐	J_1BPARTYP	J_1BPARTYP	CHAR	1	0	Nota Fiscal Partner Type
27	DIRECT	☐	J_1BDIRECT	J_1BDIRECT	CHAR	1	0	Direction of the movement
28	REFNUM	☐	J_1BNFE_REFNUM	J_1BDOCNUM	NUMC	10	0	Number of Reference Document	*
29	FORM	☐	J_1BFORM	J_1BFORM	CHAR	4	0	Form of Nota Fiscal	*
30	ACTION_REQU	☐	J_1BNFE_ACTION_REQUIRED	J_1BNFE_ACTION_REQUIRED	CHAR	1	0	Required Process Step
31	PRINTD	☐	J_1BPRINTD	XFELD	CHAR	1	0	Printed
32	CONTING_S	☐	J_1BCONTINGENCY_NFE_SWITCHED	XFELD	CHAR	1	0	Switched to Contingency
33	MSSTAT	☐	J_1BNFE_MS_STATUS	J_1BNFE_MS_STATUS	CHAR	1	0	Status from Messaging System
34	REASON	☐	J_1BNFE_CANCEL_REASON	J_1BNFE_CANCEL_REASON	CHAR	2	0	Reason for Cancellation/Skipping	J_1BNFE_CANCELR
35	REASON1	☐	J_1BNFE_CANCEL_TEXT	J_1BNFE_CANCEL_TEXT	CHAR	64	0	Text for Cancellation/Skipping Reason
36	REASON2	☐	J_1BNFE_CANCEL_TEXT	J_1BNFE_CANCEL_TEXT	CHAR	64	0	Text for Cancellation/Skipping Reason
37	REASON3	☐	J_1BNFE_CANCEL_TEXT	J_1BNFE_CANCEL_TEXT	CHAR	64	0	Text for Cancellation/Skipping Reason
38	REASON4	☐	J_1BNFE_CANCEL_TEXT	J_1BNFE_CANCEL_TEXT	CHAR	64	0	Text for Cancellation/Skipping Reason
39	CRENAM	☐	J_1BCRENAM	USNAM	CHAR	12	0	Name of the user
40	CALLRFC	☐	J_1BNFERFCCALL	J_1BNFERFCCALL	CHAR	1	0	Control Doc. No. and RFC Execution to Messaging System
41	TPAMB	☐	J_1BNFETPAMB	J_1BNFETPAMB	CHAR	1	0	Type of Environment (Test or Production)
42	SEFAZ_ACTIVE	☐	J_1BNFE_SEFAZ_ACTIVE	XFELD	CHAR	1	0	SEFAZ Server is Active
43	SCAN_ACTIVE	☐	J_1BNFE_SCAN_ACTIVE	XFELD	CHAR	1	0	SCAN Server is Active
44	CHECKTMPL	☐	TIMESTAMPL	TZNTSTMPL	DEC	21	7	UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)
45	AUTHDATE	☐	J_1BAUTHDATE	DATUM	DATS	8	0	Processing Timestamp - Date
46	AUTHTIME	☐	J_1BAUTHTIME	UZEIT	TIMS	6	0	Processing Timestamp - Time
47	TPEMIS	☐	J_1BNFE_TPEMIS	J_1BNFE_TPEMIS	CHAR	1	0	Issuing Type
48	REASON_CONTING	☐	J_1BNFE_CONTINGENCY_REASON	J_1BNFE_CONTINGENCY_REASON	CHAR	2	0	Reason for Contingency	J_1BNFE_CONTINR
49	REASON_CONTING1	☐	J_1BNFE_CONTINGENCY_TEXT	J_1BNFE_CONTINGENCY_TEXT	CHAR	64	0	Text for Contingency Reason
50	REASON_CONTING2	☐	J_1BNFE_CONTINGENCY_TEXT	J_1BNFE_CONTINGENCY_TEXT	CHAR	64	0	Text for Contingency Reason
51	REASON_CONTING3	☐	J_1BNFE_CONTINGENCY_TEXT	J_1BNFE_CONTINGENCY_TEXT	CHAR	64	0	Text for Contingency Reason
52	REASON_CONTING4	☐	J_1BNFE_CONTINGENCY_TEXT	J_1BNFE_CONTINGENCY_TEXT	CHAR	64	0	Text for Contingency Reason
53	CONTING_DATE	☐	J_1BNFE_CONTINGENCY_DATE	DATUM	DATS	8	0	Contingency Date
54	CONTING_TIME	☐	J_1BNFE_CONTINGENCY_TIME	UZEIT	TIMS	6	0	Contingency Time
55	CONTIN_TIME_ZONE	☐	TZNZONE	TZNZONE	CHAR	6	0	Time Zone	*
56	CANCEL_ALLOWED	☐	J_1BNFE_CANCEL_ALLOWED	XFELD	CHAR	1	0	Cancellation Allowed by Authorities
57	SOURCE	☐	J_1BNFE_SOURCE	J_1BNFE_SOURCE	CHAR	1	0	Source of Entry
58	CANCEL_PA	☐	J_1BNFE_CANCEL_PA	XFELD	CHAR	1	0	Cancel Prior to Authorization
59	EVENT_FLAG	☐	XFELD	XFELD	CHAR	1	0	Checkbox
60	ACTIVE_SERVICE	☐	J_1BNFE_ACTIVE_SERVICE	J_1BNFE_ACTIVE_SERVICE	CHAR	2	0	Active Service of Tax Authorities

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	J_1BNFE_ACTIVE	REASON	J_1BNFE_CANCELR	REASON	KEY	1	CN
2	J_1BNFE_ACTIVE	REASON_CONTING	J_1BNFE_CONTINR	REASON	KEY	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in	604