J_1BNFSTX

Transparent Table Application Table
30 Fields 1 CDS Views

Nota Fiscal tax per item

J_1BNFSTX is an SAP database table in S/4HANA. Nota Fiscal tax per item. It contains 30 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_BR_NFTax view from BASIC Brazil Nota Fiscal Taxes

Fields (30)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY docnum j_1bdocnum Document Number
KEY itmnum j_1bitmnum Item Number
KEY taxtyp j_1btaxtyp Tax Type
base j_1bbase Base Amount
rate j_1btxrate Tax Rate
taxval j_1btaxval Tax Value
excbas j_1bexcbas Excluded Base
othbas j_1bothbas Other Base
stattx j_1bstattx Stat.Tax
rectype j_1btxrt Rec.Type
factor j_1btxipf Number of units
unit j_1btxipu Unit
tax_loc j_1btxjcd Jurisdict. Code
servtype_in j_1bservtype_in SrvTyp Inc
servtype_out j_1bservtype_out SrvTyp Out
withhold j_1btxwht WTax
taxinnet j_1btaxinnet Tax Included
whtcollcode j_1bwhtcoll Coll. Code
basered1 j_1btxbase Tax Base
basered2 j_1btxbase Tax Base
rate4dec j_1btxrate4dec Tax Rate 4 DP
factor4dec j_1btxpf4dec No. Units 4DP (Rep.)
unit4dec j_1btxpu4dec UoM 4DP (Rep.)
tax_difference j_1btxdiff Tax Diff.
srate j_1btxstpr Surcharge rate
pauta_base j_1btxpauta_base_4dec Pauta Base 4 Dec
taxgrp j_1btaxgrp Tax Group
taxoff j_1btaxoffset Offset Cond.
taxoutvalue j_1btaxoutvalue Net Val. Without Tax

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 tax per item
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE J_1BNFSTX (
    MANDT,           -- Client [mandt]
    DOCNUM,          -- Document Number [j_1bdocnum]
    ITMNUM,          -- Item Number [j_1bitmnum]
    TAXTYP,          -- Tax Type [j_1btaxtyp]
    BASE,            -- Base Amount [j_1bbase]
    RATE,            -- Tax Rate [j_1btxrate]
    TAXVAL,          -- Tax Value [j_1btaxval]
    EXCBAS,          -- Excluded Base [j_1bexcbas]
    OTHBAS,          -- Other Base [j_1bothbas]
    STATTX,          -- Stat.Tax [j_1bstattx]
    RECTYPE,         -- Rec.Type [j_1btxrt]
    FACTOR,          -- Number of units [j_1btxipf]
    UNIT,            -- Unit [j_1btxipu]
    TAX_LOC,         -- Jurisdict. Code [j_1btxjcd]
    SERVTYPE_IN,     -- SrvTyp Inc [j_1bservtype_in]
    SERVTYPE_OUT,    -- SrvTyp Out [j_1bservtype_out]
    WITHHOLD,        -- WTax [j_1btxwht]
    TAXINNET,        -- Tax Included [j_1btaxinnet]
    WHTCOLLCODE,     -- Coll. Code [j_1bwhtcoll]
    BASERED1,        -- Tax Base [j_1btxbase]
    BASERED2,        -- Tax Base [j_1btxbase]
    RATE4DEC,        -- Tax Rate 4 DP [j_1btxrate4dec]
    FACTOR4DEC,      -- No. Units 4DP (Rep.) [j_1btxpf4dec]
    UNIT4DEC,        -- UoM 4DP (Rep.) [j_1btxpu4dec]
    TAX_DIFFERENCE,  -- Tax Diff. [j_1btxdiff]
    SRATE,           -- Surcharge rate [j_1btxstpr]
    PAUTA_BASE,      -- Pauta Base 4 Dec [j_1btxpauta_base_4dec]
    TAXGRP,          -- Tax Group [j_1btaxgrp]
    TAXOFF,          -- Offset Cond. [j_1btaxoffset]
    TAXOUTVALUE,     -- Net Val. Without Tax [j_1btaxoutvalue]
    PRIMARY KEY (MANDT, DOCNUM, ITMNUM, TAXTYP)
);

Learn More