J_1BNFE_ACTIVE

Transparent Table Application Table
75 Fields 2 CDS Views

Electronic Nota Fiscal: Actual Status

J_1BNFE_ACTIVE is an SAP database table in S/4HANA. Electronic Nota Fiscal: Actual Status. It contains 75 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_BR_NFeActive view from BASIC Brazil Electronic Nota Fiscal Active
V_NFE_OM_PARAM view from Output Manag. Parameters for Nota Fiscal

Fields (75)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY docnum J_1BDOCNUM Document Number
docsta J_1BNFEDOCSTATUS Doc. Status
scssta J_1BNFESCSSTATUS Sys. Comm. Status
conting J_1BCONTINGENCY Posted Cont.
cancel J_1BCANCEL Canceled
code J_1BSTATUSCODE Status Code
regio J_1BREGIO Region
nfyear J_1BYEAR Document Year
nfmonth J_1BMONTH Document Month
stcd1 J_1BSTCD1 CNPJ/CPF Number
model J_1BMODEL NF model
serie J_1BSERIES Series
nfnum9 J_1BNFNUM9 NF-e Number
docnum9 J_1BDOCNUM9 Random No.
cdv J_1BCHECKDIGIT Check Digit
authcod J_1BNFEAUTHCODE Protocol No.
credat J_1BCREDAT Created on
action_date J_1BNFE_ACTION_DATE Changed On
action_time J_1BNFE_ACTION_TIME Changed At
action_user J_1BNFE_ACTION_USER Changed By
bukrs BUKRS Company Code
branch J_1BBRANC_ Business Place
vstel VSTEL Shipping Point
parid J_1BPARID Partner ID
partyp J_1BPARTYP NF partner type
direct J_1BDIRECT Direc.movement
refnum J_1BNFE_REFNUM No. of Ref. Doc.
form J_1BFORM Document Form
action_requ J_1BNFE_ACTION_REQUIRED Process Step
printd J_1BPRINTD Printed
conting_s J_1BCONTINGENCY_NFE_SWITCHED Switch to Cont.
msstat J_1BNFE_MS_STATUS Mes. Syt. Status
reason J_1BNFE_CANCEL_REASON Cancel Reason
reason1 J_1BNFE_CANCEL_TEXT Cancel Reason
reason2 J_1BNFE_CANCEL_TEXT Cancel Reason
reason3 J_1BNFE_CANCEL_TEXT Cancel Reason
reason4 J_1BNFE_CANCEL_TEXT Cancel Reason
crenam J_1BCRENAM Created by
callrfc J_1BNFERFCCALL RFC Execution
tpamb J_1BNFETPAMB Type Environment
sefaz_active J_1BNFE_SEFAZ_ACTIVE SEFAZ Active
scan_active J_1BNFE_SCAN_ACTIVE SCAN Active
checktmpl TIMESTAMPL Time Stamp
authdate J_1BAUTHDATE Proc. Date
authtime J_1BAUTHTIME Proc. Time
tpemis J_1BNFE_TPEMIS Issuing Type
reason_conting J_1BNFE_CONTINGENCY_REASON Conting. Reason
reason_conting1 J_1BNFE_CONTINGENCY_TEXT Conting. Reason
reason_conting2 J_1BNFE_CONTINGENCY_TEXT Conting. Reason
reason_conting3 J_1BNFE_CONTINGENCY_TEXT Conting. Reason
reason_conting4 J_1BNFE_CONTINGENCY_TEXT Conting. Reason
conting_date J_1BNFE_CONTINGENCY_DATE Conting. Date
conting_time J_1BNFE_CONTINGENCY_TIME Conting. Time
contin_time_zone TZNZONE Time Zone
cancel_allowed J_1BNFE_CANCEL_ALLOWED Cancel. Sync.
source J_1BNFE_SOURCE Source
cancel_pa J_1BNFE_CANCEL_PA Cncl Prior Auth.
event_flag XFELD Checkbox
active_service J_1BNFE_ACTIVE_SERVICE Active Service
svc_sp_active J_1BNFE_SVCSP_ACTIVE SVC SP Act.
svc_rs_active J_1BNFE_SVCRS_ACTIVE SVC RS Act.
svc_active J_1BNFE_SVC_ACTIVE SVC Act.
rps J_1B_PROVISORY_SERVICE_RECEIPT Provisory Receipt
nfse_number J_1BPREFNO NFS-e Number
nfse_check_code J_1BCHECOD Verification Code
code_description J_1BNFE_CODE_DESCRIPTION Status Code Descr
cmsg J_1BNFE_CMSG SEFAZ Message Code
xmsg J_1BNFE_XMSG SEFAZ Message Desc.
cloud_guid NFE_DOCUMENT_UUID Unique Identifier
cloud_extens_flag NFE_EXTENS_FLAG Extension values
replacement_status NFE_REPLACEMENT_STATUS Replacement Status
cloud_log_status NFE_CLOUD_LOG_STATUS Cloud Log Status
mail_log_status NFE_MAIL_LOG_STATUS Mail Log Status
authcod16 J_1BNFEAUTHCODE16 Protocol No.

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Electronic Nota Fiscal: Actual Status
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE J_1BNFE_ACTIVE (
    MANDT,               -- Client [MANDT]
    DOCNUM,              -- Document Number [J_1BDOCNUM]
    DOCSTA,              -- Doc. Status [J_1BNFEDOCSTATUS]
    SCSSTA,              -- Sys. Comm. Status [J_1BNFESCSSTATUS]
    CONTING,             -- Posted Cont. [J_1BCONTINGENCY]
    CANCEL,              -- Canceled [J_1BCANCEL]
    CODE,                -- Status Code [J_1BSTATUSCODE]
    REGIO,               -- Region [J_1BREGIO]
    NFYEAR,              -- Document Year [J_1BYEAR]
    NFMONTH,             -- Document Month [J_1BMONTH]
    STCD1,               -- CNPJ/CPF Number [J_1BSTCD1]
    MODEL,               -- NF model [J_1BMODEL]
    SERIE,               -- Series [J_1BSERIES]
    NFNUM9,              -- NF-e Number [J_1BNFNUM9]
    DOCNUM9,             -- Random No. [J_1BDOCNUM9]
    CDV,                 -- Check Digit [J_1BCHECKDIGIT]
    AUTHCOD,             -- Protocol No. [J_1BNFEAUTHCODE]
    CREDAT,              -- Created on [J_1BCREDAT]
    ACTION_DATE,         -- Changed On [J_1BNFE_ACTION_DATE]
    ACTION_TIME,         -- Changed At [J_1BNFE_ACTION_TIME]
    ACTION_USER,         -- Changed By [J_1BNFE_ACTION_USER]
    BUKRS,               -- Company Code [BUKRS]
    BRANCH,              -- Business Place [J_1BBRANC_]
    VSTEL,               -- Shipping Point [VSTEL]
    PARID,               -- Partner ID [J_1BPARID]
    PARTYP,              -- NF partner type [J_1BPARTYP]
    DIRECT,              -- Direc.movement [J_1BDIRECT]
    REFNUM,              -- No. of Ref. Doc. [J_1BNFE_REFNUM]
    FORM,                -- Document Form [J_1BFORM]
    ACTION_REQU,         -- Process Step [J_1BNFE_ACTION_REQUIRED]
    PRINTD,              -- Printed [J_1BPRINTD]
    CONTING_S,           -- Switch to Cont. [J_1BCONTINGENCY_NFE_SWITCHED]
    MSSTAT,              -- Mes. Syt. Status [J_1BNFE_MS_STATUS]
    REASON,              -- Cancel Reason [J_1BNFE_CANCEL_REASON]
    REASON1,             -- Cancel Reason [J_1BNFE_CANCEL_TEXT]
    REASON2,             -- Cancel Reason [J_1BNFE_CANCEL_TEXT]
    REASON3,             -- Cancel Reason [J_1BNFE_CANCEL_TEXT]
    REASON4,             -- Cancel Reason [J_1BNFE_CANCEL_TEXT]
    CRENAM,              -- Created by [J_1BCRENAM]
    CALLRFC,             -- RFC Execution [J_1BNFERFCCALL]
    TPAMB,               -- Type Environment [J_1BNFETPAMB]
    SEFAZ_ACTIVE,        -- SEFAZ Active [J_1BNFE_SEFAZ_ACTIVE]
    SCAN_ACTIVE,         -- SCAN Active [J_1BNFE_SCAN_ACTIVE]
    CHECKTMPL,           -- Time Stamp [TIMESTAMPL]
    AUTHDATE,            -- Proc. Date [J_1BAUTHDATE]
    AUTHTIME,            -- Proc. Time [J_1BAUTHTIME]
    TPEMIS,              -- Issuing Type [J_1BNFE_TPEMIS]
    REASON_CONTING,      -- Conting. Reason [J_1BNFE_CONTINGENCY_REASON]
    REASON_CONTING1,     -- Conting. Reason [J_1BNFE_CONTINGENCY_TEXT]
    REASON_CONTING2,     -- Conting. Reason [J_1BNFE_CONTINGENCY_TEXT]
    REASON_CONTING3,     -- Conting. Reason [J_1BNFE_CONTINGENCY_TEXT]
    REASON_CONTING4,     -- Conting. Reason [J_1BNFE_CONTINGENCY_TEXT]
    CONTING_DATE,        -- Conting. Date [J_1BNFE_CONTINGENCY_DATE]
    CONTING_TIME,        -- Conting. Time [J_1BNFE_CONTINGENCY_TIME]
    CONTIN_TIME_ZONE,    -- Time Zone [TZNZONE]
    CANCEL_ALLOWED,      -- Cancel. Sync. [J_1BNFE_CANCEL_ALLOWED]
    SOURCE,              -- Source [J_1BNFE_SOURCE]
    CANCEL_PA,           -- Cncl Prior Auth. [J_1BNFE_CANCEL_PA]
    EVENT_FLAG,          -- Checkbox [XFELD]
    ACTIVE_SERVICE,      -- Active Service [J_1BNFE_ACTIVE_SERVICE]
    SVC_SP_ACTIVE,       -- SVC SP Act. [J_1BNFE_SVCSP_ACTIVE]
    SVC_RS_ACTIVE,       -- SVC RS Act. [J_1BNFE_SVCRS_ACTIVE]
    SVC_ACTIVE,          -- SVC Act. [J_1BNFE_SVC_ACTIVE]
    RPS,                 -- Provisory Receipt [J_1B_PROVISORY_SERVICE_RECEIPT]
    NFSE_NUMBER,         -- NFS-e Number [J_1BPREFNO]
    NFSE_CHECK_CODE,     -- Verification Code [J_1BCHECOD]
    CODE_DESCRIPTION,    -- Status Code Descr [J_1BNFE_CODE_DESCRIPTION]
    CMSG,                -- SEFAZ Message Code [J_1BNFE_CMSG]
    XMSG,                -- SEFAZ Message Desc. [J_1BNFE_XMSG]
    CLOUD_GUID,          -- Unique Identifier [NFE_DOCUMENT_UUID]
    CLOUD_EXTENS_FLAG,   -- Extension values [NFE_EXTENS_FLAG]
    REPLACEMENT_STATUS,  -- Replacement Status [NFE_REPLACEMENT_STATUS]
    CLOUD_LOG_STATUS,    -- Cloud Log Status [NFE_CLOUD_LOG_STATUS]
    MAIL_LOG_STATUS,     -- Mail Log Status [NFE_MAIL_LOG_STATUS]
    AUTHCOD16,           -- Protocol No. [J_1BNFEAUTHCODE16]
    PRIMARY KEY (MANDT, DOCNUM)
);

Learn More