J_1BNFE_ACTIVE

Transparent Table Application Table
72 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 72 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 (72)

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.
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]
    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