J_1BNFTRADENOTES

Transparent Table Application Table
6 Fields 1 CDS Views

Trade Notes

J_1BNFTRADENOTES is an SAP database table in S/4HANA. Trade Notes. It contains 6 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_BR_NFTradeNote view from BASIC Brazil Nota Fiscal Trade Note

Fields (6)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY docnum j_1bdocnum Document Number
KEY counter j_1b_nf_counter4 Counter
ndup j_1b_trade_note Number
dvenc j_1b_trade_exp_date Exp. Date
vdup j_1b_trade_note_value Value

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.

-- Trade Notes
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE J_1BNFTRADENOTES (
    MANDT,    -- Client [mandt]
    DOCNUM,   -- Document Number [j_1bdocnum]
    COUNTER,  -- Counter [j_1b_nf_counter4]
    NDUP,     -- Number [j_1b_trade_note]
    DVENC,    -- Exp. Date [j_1b_trade_exp_date]
    VDUP,     -- Value [j_1b_trade_note_value]
    PRIMARY KEY (MANDT, DOCNUM, COUNTER)
);

Learn More