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

Dictionary Type: Table
Description: Electronic Nota Fiscal: Actual Status




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




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

J_1BNFE_ACTIVE is a standard SAP Table which is used to store Electronic Nota Fiscal: Actual Status data and is available within R/3 SAP systems depending on the version and release level.

The J_1BNFE_ACTIVE table consists of various fields, each holding specific information or linking keys about Electronic Nota Fiscal: Actual Status data available in SAP. These include DOCNUM (Document Number), DOCSTA (Document Status), SCSSTA (System Communication Status), CONTING (Document Posted under Contingency).. 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_ACTIVE 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
CONTINGDocument Posted under Contingency J_1BCONTINGENCYCHAR1XFELD
CANCELCanceled J_1BCANCELCHAR1XFELD
CODEOfficial Status Code J_1BSTATUSCODECHAR3Assigned to domainALPHAJ_1BSTATUSCODE
REGIORegion of Document Issuer J_1BREGIOCHAR2J_1BREGIO
NFYEARYear of Document Date J_1BYEARCHAR2J_1BYEAR
NFMONTHMonth of Document Date J_1BMONTHCHAR2J_1BMONTH
STCD1CNPJ Number of Document Issuer J_1BSTCD1CHAR14J_1BSTCD1
MODELModel of Nota Fiscal J_1BMODELNUMC2J_1BMODEL
SERIESeries J_1BSERIESCHAR3J_1BSERIES
NFNUM9Nine-Digit Document Number J_1BNFNUM9CHAR9J_1BNFNUM9
DOCNUM9Random Number in Access Key J_1BDOCNUM9CHAR9J_1BDOCNUM9
CDVCheck Digit in Access Key J_1BCHECKDIGITCHAR1J_1BCHECKDIGIT
AUTHCODProtocol Number J_1BNFEAUTHCODECHAR15J_1BNFEAUTHCODE
CREDATCreate date J_1BCREDATDATS8DATUM
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
BUKRSCompany Code BUKRSCHAR4Assigned to domainBUKRSBUKC_T001
BRANCHBusiness Place J_1BBRANC_CHAR4Assigned to domainJ_1BBRANCH
VSTELShipping Point/Receiving Point VSTELCHAR4Assigned to domainVSTELVST
PARIDPartner ID (Customer, Vendor, Business Place) J_1BPARIDCHAR10ALPHAJ_1BPARIDDEBI_KRED
PARTYPNota Fiscal Partner Type J_1BPARTYPCHAR1J_1BPARTYP
DIRECTDirection of the movement J_1BDIRECTCHAR1J_1BDIRECT
REFNUMNumber of Reference Document J_1BNFE_REFNUMNUMC10Assigned to domainJ_1BDOCNUM
FORMForm of Nota Fiscal J_1BFORMCHAR4Assigned to domainJ_1BFORM
ACTION_REQURequired Process Step J_1BNFE_ACTION_REQUIREDCHAR1J_1BNFE_ACTION_REQUIRED
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_REASONCHAR2J_1BNFE_CANCELRJ_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
CRENAMName of the user J_1BCRENAMCHAR12USNAM
CALLRFCControl Doc. No. and RFC Execution to Messaging System J_1BNFERFCCALLCHAR1J_1BNFERFCCALL
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_REASONCHAR2J_1BNFE_CONTINRJ_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
SOURCESource of Entry J_1BNFE_SOURCECHAR1J_1BNFE_SOURCE
CANCEL_PACancel Prior to Authorization J_1BNFE_CANCEL_PACHAR1XFELD
EVENT_FLAGCheckbox XFELDCHAR1XFELD
ACTIVE_SERVICEActive Service of Tax Authorities J_1BNFE_ACTIVE_SERVICECHAR2J_1BNFE_ACTIVE_SERVICE

Key field Non-key field



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

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

SELECT SINGLE *
FROM J_1BNFE_ACTIVE
INTO CORRESPONDING FIELDS OF WA_J_1BNFE_ACTIVE
WHERE...

How to access SAP table J_1BNFE_ACTIVE

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