J_1BCTE_D_DOCREF

Transparent Table Application Table
27 Fields 1 CDS Views

Reference to the NF-e being transported

J_1BCTE_D_DOCREF is an SAP database table in S/4HANA. Reference to the NF-e being transported. It contains 27 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_BR_CteNotaFiscalReference view from BASIC Brazil CT-e Document Reference

Fields (27)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY docnum J_1BDOCNUM Document Number
KEY counter J_1BCTE_REF_COUNTER Ref. No.
rfdocnum J_1BDOCNUM Document Number
logsys LOGSYSTEM Logical System
docval J_1BCTE_REF_VAL Doc. Amount
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
nfmodel J_1BMODEL NF model
nfseries J_1BSERIES Series
nfnum J_1BNFNUMB NF Number
nfdate J_1BDOCDAT Document date
nficms_bv J_1BCTE_ICMS_BV ICMS Base Value
nficms_val J_1BCTE_ICMS_VAL ICMS Tax Value
nfstic_bv J_1BCTE_STIC_BV SubTrib Base
nfstic_val J_1BCTE_STIC_VAL SubTrib Tax
nfnet_val J_1BNETVAL Value
nftot_val J_1BNFTOT Total value
nfcfop J_1BCFOP CFOP
nfbrgew BRGEW_15 Gross Weight

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.

-- Reference to the NF-e being transported
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE J_1BCTE_D_DOCREF (
    MANDT,       -- Client [MANDT]
    DOCNUM,      -- Document Number [J_1BDOCNUM]
    COUNTER,     -- Ref. No. [J_1BCTE_REF_COUNTER]
    RFDOCNUM,    -- Document Number [J_1BDOCNUM]
    LOGSYS,      -- Logical System [LOGSYSTEM]
    DOCVAL,      -- Doc. Amount [J_1BCTE_REF_VAL]
    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]
    NFMODEL,     -- NF model [J_1BMODEL]
    NFSERIES,    -- Series [J_1BSERIES]
    NFNUM,       -- NF Number [J_1BNFNUMB]
    NFDATE,      -- Document date [J_1BDOCDAT]
    NFICMS_BV,   -- ICMS Base Value [J_1BCTE_ICMS_BV]
    NFICMS_VAL,  -- ICMS Tax Value [J_1BCTE_ICMS_VAL]
    NFSTIC_BV,   -- SubTrib Base [J_1BCTE_STIC_BV]
    NFSTIC_VAL,  -- SubTrib Tax [J_1BCTE_STIC_VAL]
    NFNET_VAL,   -- Value [J_1BNETVAL]
    NFTOT_VAL,   -- Total value [J_1BNFTOT]
    NFCFOP,      -- CFOP [J_1BCFOP]
    NFBRGEW,     -- Gross Weight [BRGEW_15]
    PRIMARY KEY (MANDT, DOCNUM, COUNTER)
);

Learn More