J_1BNFNAD

Transparent Table Application Table
42 Fields 1 CDS Views

Nota Fiscal partners

J_1BNFNAD is an SAP database table in S/4HANA. Nota Fiscal partners. It contains 42 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_BR_NFPartner view from BASIC Brazil Nota Fiscal Partner

Fields (42)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY docnum J_1BDOCNUM Document Number
KEY parvw J_1BPARVW NF partn.funct.
parid J_1BPARID Partner ID
partyp J_1BPARTYP NF partner type
xcpdk XCPDK One-time acct
anred ANRED Title
name1 NAME1_GP Name
name2 NAME2_GP Name 2
name3 NAME3_GP Name 3
name4 NAME4_GP Name 4
stras STRAS_GP Street
ort01 ORT01_GP City
ort02 ORT02_GP District
regio REGIO Region
land1 LAND1_GP Country/Region Key
pstlz PSTLZ Postal Code
pfach PFACH PO Box
pstl2 PSTL2 PO Box PCode
sortl SORTL Search term
spras SPRAS Language
telf1 TLFNR Telephone no.
telfx TELFX Fax Number
teltx TELTX Teletex
telx1 TELX1 Telex
indust J_1BINDUS1 CFOP Category
stkzn STKZN Natural person
cgc J_1BCGC CNPJ Number
cpf J_1BCPF CPF number
stains J_1BSTAINS State Tax No.
munins J_1BMUNINS Munic. Tax No.
txjcd TXJCD Tax Jur.
hausn HAUSN_BAS House number
stock STOCK Floor
street AD_STREET Street
house_num1 AD_HSNM1 House Number
house_num2 AD_HSNM2 Supplement
ind_iedest J_1BNFE_IEDEST IE Indicator
foreignid J_1BNFE_FOREIGNID Foreign ID
smtp_addr AD_SMTPADR E-Mail Address
cte_partner J_1BCTE_TOMALI CT-e Partner Doc.
partner_role J_1BNFE_PART_ROLE Partner Place Type

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 partners
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE J_1BNFNAD (
    MANDT,         -- Client [MANDT]
    DOCNUM,        -- Document Number [J_1BDOCNUM]
    PARVW,         -- NF partn.funct. [J_1BPARVW]
    PARID,         -- Partner ID [J_1BPARID]
    PARTYP,        -- NF partner type [J_1BPARTYP]
    XCPDK,         -- One-time acct [XCPDK]
    ANRED,         -- Title [ANRED]
    NAME1,         -- Name [NAME1_GP]
    NAME2,         -- Name 2 [NAME2_GP]
    NAME3,         -- Name 3 [NAME3_GP]
    NAME4,         -- Name 4 [NAME4_GP]
    STRAS,         -- Street [STRAS_GP]
    ORT01,         -- City [ORT01_GP]
    ORT02,         -- District [ORT02_GP]
    REGIO,         -- Region [REGIO]
    LAND1,         -- Country/Region Key [LAND1_GP]
    PSTLZ,         -- Postal Code [PSTLZ]
    PFACH,         -- PO Box [PFACH]
    PSTL2,         -- PO Box PCode [PSTL2]
    SORTL,         -- Search term [SORTL]
    SPRAS,         -- Language [SPRAS]
    TELF1,         -- Telephone no. [TLFNR]
    TELFX,         -- Fax Number [TELFX]
    TELTX,         -- Teletex [TELTX]
    TELX1,         -- Telex [TELX1]
    INDUST,        -- CFOP Category [J_1BINDUS1]
    STKZN,         -- Natural person [STKZN]
    CGC,           -- CNPJ Number [J_1BCGC]
    CPF,           -- CPF number [J_1BCPF]
    STAINS,        -- State Tax No. [J_1BSTAINS]
    MUNINS,        -- Munic. Tax No. [J_1BMUNINS]
    TXJCD,         -- Tax Jur. [TXJCD]
    HAUSN,         -- House number [HAUSN_BAS]
    STOCK,         -- Floor [STOCK]
    STREET,        -- Street [AD_STREET]
    HOUSE_NUM1,    -- House Number [AD_HSNM1]
    HOUSE_NUM2,    -- Supplement [AD_HSNM2]
    IND_IEDEST,    -- IE Indicator [J_1BNFE_IEDEST]
    FOREIGNID,     -- Foreign ID [J_1BNFE_FOREIGNID]
    SMTP_ADDR,     -- E-Mail Address [AD_SMTPADR]
    CTE_PARTNER,   -- CT-e Partner Doc. [J_1BCTE_TOMALI]
    PARTNER_ROLE,  -- Partner Place Type [J_1BNFE_PART_ROLE]
    PRIMARY KEY (MANDT, DOCNUM, PARVW)
);

Learn More