J_1BNFCPD

Transparent Table Application Table
32 Fields 1 CDS Views

Nota Fiscal one-time accounts

J_1BNFCPD is an SAP database table in S/4HANA. Nota Fiscal one-time accounts. It contains 32 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_BR_OneTimePartner view from BASIC Brazil Nota Fiscal One Time Partner

Fields (32)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY docnum j_1bdocnum Document Number
KEY parvw j_1bparvw NF partn.funct.
name1 name1_gp Name
name2 name2_gp Name 2
name3 name3_gp Name 3
name4 name4_gp Name 4
pstlz pstlz Postal Code
ort01 ort01_gp City
land1 land1_gp Country/Region Key
stras stras_gp Street
pfach pfach PO Box
pstl2 pstl2 PO Box PCode
pskto pskto Curr.Acct or Ref.No.
bankn bankn Bank Account
bankl bankk Bank Key
banks banks Bank Ctry/Reg.
stcd1 stcd1 Tax Number 1
stcd2 stcd2 Tax Number 2
stkzu stkzu Liable for VAT
stkza stkza Equalizatn tax
regio regio Region
bkont bkont Control Key
dtaws dtaws Instruction Key
dtams dtams DME Rec. Code
xcpdk xcpdk One-time acct
empfg empfg Pmnt Recipient
spras spras Language
tel_number ad_tlnmbr1 Telephone
tel_extens ad_tlxtns1 Extension
fax_number ad_fxnmbr1 Fax
fax_extens ad_fxxtns1 Extension

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 one-time accounts
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE J_1BNFCPD (
    MANDT,       -- Client [mandt]
    DOCNUM,      -- Document Number [j_1bdocnum]
    PARVW,       -- NF partn.funct. [j_1bparvw]
    NAME1,       -- Name [name1_gp]
    NAME2,       -- Name 2 [name2_gp]
    NAME3,       -- Name 3 [name3_gp]
    NAME4,       -- Name 4 [name4_gp]
    PSTLZ,       -- Postal Code [pstlz]
    ORT01,       -- City [ort01_gp]
    LAND1,       -- Country/Region Key [land1_gp]
    STRAS,       -- Street [stras_gp]
    PFACH,       -- PO Box [pfach]
    PSTL2,       -- PO Box PCode [pstl2]
    PSKTO,       -- Curr.Acct or Ref.No. [pskto]
    BANKN,       -- Bank Account [bankn]
    BANKL,       -- Bank Key [bankk]
    BANKS,       -- Bank Ctry/Reg. [banks]
    STCD1,       -- Tax Number 1 [stcd1]
    STCD2,       -- Tax Number 2 [stcd2]
    STKZU,       -- Liable for VAT [stkzu]
    STKZA,       -- Equalizatn tax [stkza]
    REGIO,       -- Region [regio]
    BKONT,       -- Control Key [bkont]
    DTAWS,       -- Instruction Key [dtaws]
    DTAMS,       -- DME Rec. Code [dtams]
    XCPDK,       -- One-time acct [xcpdk]
    EMPFG,       -- Pmnt Recipient [empfg]
    SPRAS,       -- Language [spras]
    TEL_NUMBER,  -- Telephone [ad_tlnmbr1]
    TEL_EXTENS,  -- Extension [ad_tlxtns1]
    FAX_NUMBER,  -- Fax [ad_fxnmbr1]
    FAX_EXTENS,  -- Extension [ad_fxxtns1]
    PRIMARY KEY (MANDT, DOCNUM, PARVW)
);

Learn More