J_1BNFADD_INFO

Transparent Table Application Table

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)
);