J_1BNFDOC

Transparent Table Application Table
72 Fields 3 CDS Views

Nota Fiscal Header

J_1BNFDOC is an SAP database table in S/4HANA. Nota Fiscal Header. It contains 72 fields. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
E_BR_NotaFiscal view_entity from EXTENSION Header NF - Extn
I_BR_NFDocument view from BASIC Brazil Nota Fiscal Document Data
I_BR_NFDocumentCurrency view from BASIC Currency of Brazil Nota Fiscal Document

Fields (72)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY docnum j_1bdocnum Document Number
nftype j_1bnftype NF type
doctyp j_1bdoctyp Document type
direct j_1bdirect Direc.movement
docdat j_1bdocdat Document date
pstdat j_1bpstdat Posting date
credat j_1bcredat Created on
cretim j_1bcretim Created at
crenam j_1bcrenam Created by
chadat j_1bchadat Changed on
chatim j_1bchatim Changed at
chanam j_1bchanam Changed by
form j_1bform Document Form
model j_1bmodel NF model
series j_1bseries Series
subser j_1bsubser Sub series
nfnum j_1bnfnumb NF Number
entrad j_1bentrad NF Entrada
fatura j_1bfatura NF fatura
zterm dzterm Pyt Terms
printd j_1bprintd Printed
manual j_1bmanual Created man.
follow j_1bfollow Follow up
waerk waerk Doc. Currency
belnr belnr_d Document Number
gjahr gjahr Fiscal Year
bukrs bukrs Company Code
branch j_1bbranc_ Business Place
parvw j_1bparvw NF partn.funct.
parid j_1bparid Partner ID
parxcpdk xcpdk One-time acct
partyp j_1bpartyp NF partner type
cancel j_1bcancel Canceled
candat j_1bcandat Cancel. Date
subseq j_1bsubseq Follow-On Doc.
docref j_1bdocref Orig.docum.num.
traty traty MnsOfTrns Type
traid traid Mns of Trans.ID
inco1 inco1 Incoterms
inco2 inco2 Incoterms 2
shpunt j_1bshpunt Shipping unit
anzpk anzpk No. of Packages
shpmrk j_1bshpmrk Mark ship.unit
shpnum j_1bshpnum Numb.ship.unit
brgew brgew_15 Gross Weight
ntgew ntgew_15 Net Weight
gewei gewei Unit of Weight
zfbdt dzfbdt Baseline Date
witha j_1bwitham Withhld. amnt.
observat j_1blbobs Observations
vstel vstel Shipping Point
nfdec j_1bnfdec NF Price DecPl.
nftot j_1bnftot Total value
awsys logsystem Logical System
authdate j_1bauthdate Proc. Date
authtime j_1bauthtime Proc. Time
bapi_flag j_1bbapi NF via BAPI
cre_timestamp j_1bcre_timestamp Creat. Time Stamp
cte_partner j_1bcte_tomali CT-e Partner Doc.
cte_serv_taker j_1bcte_service_taker CT-e Serv.Taker
cte_type j_1bcttype CT-e Type
autom_incoming j_1b_posted_with_xml_values Price Elem. from XML
docnum_next j_1bdocnum_next Next Document
docnum_prev j_1bdocnum_prev Prev. Document
municipal j_1bmunicipal Municipal Doc.
partr j_1bpartrate ICMS Partilha Tax Rt
nfnum_utilities j_1bnfnum_utilities Nota Fiscal Number
partner_role j_1bnfe_part_role Partner Place Type
cod_cta_header j_1bnfe_cod_cta_header G/L Account Nr.
api logbr_nfapi Created by API
tax_services_calc logbr_tax_services_calc External Tax Calc.

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.

-- Nota Fiscal Header
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE J_1BNFDOC (
    MANDT,              -- Client [mandt]
    DOCNUM,             -- Document Number [j_1bdocnum]
    NFTYPE,             -- NF type [j_1bnftype]
    DOCTYP,             -- Document type [j_1bdoctyp]
    DIRECT,             -- Direc.movement [j_1bdirect]
    DOCDAT,             -- Document date [j_1bdocdat]
    PSTDAT,             -- Posting date [j_1bpstdat]
    CREDAT,             -- Created on [j_1bcredat]
    CRETIM,             -- Created at [j_1bcretim]
    CRENAM,             -- Created by [j_1bcrenam]
    CHADAT,             -- Changed on [j_1bchadat]
    CHATIM,             -- Changed at [j_1bchatim]
    CHANAM,             -- Changed by [j_1bchanam]
    FORM,               -- Document Form [j_1bform]
    MODEL,              -- NF model [j_1bmodel]
    SERIES,             -- Series [j_1bseries]
    SUBSER,             -- Sub series [j_1bsubser]
    NFNUM,              -- NF Number [j_1bnfnumb]
    ENTRAD,             -- NF Entrada [j_1bentrad]
    FATURA,             -- NF fatura [j_1bfatura]
    ZTERM,              -- Pyt Terms [dzterm]
    PRINTD,             -- Printed [j_1bprintd]
    MANUAL,             -- Created man. [j_1bmanual]
    FOLLOW,             -- Follow up [j_1bfollow]
    WAERK,              -- Doc. Currency [waerk]
    BELNR,              -- Document Number [belnr_d]
    GJAHR,              -- Fiscal Year [gjahr]
    BUKRS,              -- Company Code [bukrs]
    BRANCH,             -- Business Place [j_1bbranc_]
    PARVW,              -- NF partn.funct. [j_1bparvw]
    PARID,              -- Partner ID [j_1bparid]
    PARXCPDK,           -- One-time acct [xcpdk]
    PARTYP,             -- NF partner type [j_1bpartyp]
    CANCEL,             -- Canceled [j_1bcancel]
    CANDAT,             -- Cancel. Date [j_1bcandat]
    SUBSEQ,             -- Follow-On Doc. [j_1bsubseq]
    DOCREF,             -- Orig.docum.num. [j_1bdocref]
    TRATY,              -- MnsOfTrns Type [traty]
    TRAID,              -- Mns of Trans.ID [traid]
    INCO1,              -- Incoterms [inco1]
    INCO2,              -- Incoterms 2 [inco2]
    SHPUNT,             -- Shipping unit [j_1bshpunt]
    ANZPK,              -- No. of Packages [anzpk]
    SHPMRK,             -- Mark ship.unit [j_1bshpmrk]
    SHPNUM,             -- Numb.ship.unit [j_1bshpnum]
    BRGEW,              -- Gross Weight [brgew_15]
    NTGEW,              -- Net Weight [ntgew_15]
    GEWEI,              -- Unit of Weight [gewei]
    ZFBDT,              -- Baseline Date [dzfbdt]
    WITHA,              -- Withhld. amnt. [j_1bwitham]
    OBSERVAT,           -- Observations [j_1blbobs]
    VSTEL,              -- Shipping Point [vstel]
    NFDEC,              -- NF Price DecPl. [j_1bnfdec]
    NFTOT,              -- Total value [j_1bnftot]
    AWSYS,              -- Logical System [logsystem]
    AUTHDATE,           -- Proc. Date [j_1bauthdate]
    AUTHTIME,           -- Proc. Time [j_1bauthtime]
    BAPI_FLAG,          -- NF via BAPI [j_1bbapi]
    CRE_TIMESTAMP,      -- Creat. Time Stamp [j_1bcre_timestamp]
    CTE_PARTNER,        -- CT-e Partner Doc. [j_1bcte_tomali]
    CTE_SERV_TAKER,     -- CT-e Serv.Taker [j_1bcte_service_taker]
    CTE_TYPE,           -- CT-e Type [j_1bcttype]
    AUTOM_INCOMING,     -- Price Elem. from XML [j_1b_posted_with_xml_values]
    DOCNUM_NEXT,        -- Next Document [j_1bdocnum_next]
    DOCNUM_PREV,        -- Prev. Document [j_1bdocnum_prev]
    MUNICIPAL,          -- Municipal Doc. [j_1bmunicipal]
    PARTR,              -- ICMS Partilha Tax Rt [j_1bpartrate]
    NFNUM_UTILITIES,    -- Nota Fiscal Number [j_1bnfnum_utilities]
    PARTNER_ROLE,       -- Partner Place Type [j_1bnfe_part_role]
    COD_CTA_HEADER,     -- G/L Account Nr. [j_1bnfe_cod_cta_header]
    API,                -- Created by API [logbr_nfapi]
    TAX_SERVICES_CALC,  -- External Tax Calc. [logbr_tax_services_calc]
    PRIMARY KEY (MANDT, DOCNUM)
);

Learn More