J_1BNFADD_INFO

Transparent Table Application Table
14 Fields 1 CDS Views

Free Usage Fields for Additional Information

J_1BNFADD_INFO is an SAP database table in S/4HANA. Free Usage Fields for Additional Information. It contains 14 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_BR_NFAdditionalInformation view from BASIC Brazil Nota Fiscal Additional Info

Fields (14)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY docnum j_1bdocnum Document Number
KEY inf_usage j_1b_add_inf_usage Usage
KEY xcampo j_1b_fieldname Field Id.
xtexto j_1b_fieldvalue Field Cont.
xtexto2 j_1b_fieldvalue Field Cont.
xtexto3 j_1b_fieldvalue Field Cont.
xtexto4 j_1b_fieldvalue Field Cont.
xtexto5 j_1b_fieldvalue Field Cont.
xtexto6 j_1b_fieldvalue Field Cont.
xtexto7 j_1b_fieldvalue Field Cont.
xtexto8 j_1b_fieldvalue Field Cont.
xtexto9 j_1b_fieldvalue Field Cont.
xtexto10 j_1b_fieldvalue Field Cont.

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.

-- Free Usage Fields for Additional Information
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE J_1BNFADD_INFO (
    MANDT,      -- Client [mandt]
    DOCNUM,     -- Document Number [j_1bdocnum]
    INF_USAGE,  -- Usage [j_1b_add_inf_usage]
    XCAMPO,     -- Field Id. [j_1b_fieldname]
    XTEXTO,     -- Field Cont. [j_1b_fieldvalue]
    XTEXTO2,    -- Field Cont. [j_1b_fieldvalue]
    XTEXTO3,    -- Field Cont. [j_1b_fieldvalue]
    XTEXTO4,    -- Field Cont. [j_1b_fieldvalue]
    XTEXTO5,    -- Field Cont. [j_1b_fieldvalue]
    XTEXTO6,    -- Field Cont. [j_1b_fieldvalue]
    XTEXTO7,    -- Field Cont. [j_1b_fieldvalue]
    XTEXTO8,    -- Field Cont. [j_1b_fieldvalue]
    XTEXTO9,    -- Field Cont. [j_1b_fieldvalue]
    XTEXTO10,   -- Field Cont. [j_1b_fieldvalue]
    PRIMARY KEY (MANDT, DOCNUM, INF_USAGE, XCAMPO)
);

Learn More