J_1BNFNAD SAP (Nota Fiscal partners) Table details

Dictionary Type: Table
Description: Nota Fiscal partners




ABAP Code to SELECT data from J_1BNFNAD
Related tables to J_1BNFNAD
Access table J_1BNFNAD




Table field list including key, data, relationships and ABAP select examples

J_1BNFNAD is a standard SAP Table which is used to store Nota Fiscal partners data and is available within R/3 SAP systems depending on the version and release level.

The J_1BNFNAD table consists of various fields, each holding specific information or linking keys about Nota Fiscal partners data available in SAP. These include DOCNUM (Document Number), PARVW (Nota Fiscal Partner Function), PARID (Partner ID (Customer, Vendor, Business Place)), PARTYP (Nota Fiscal Partner Type).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP J_1BNFNAD table fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3T000MANDT
DOCNUMDocument Number J_1BDOCNUMNUMC10J_1BNFDOCJ_1BDOCNUMJEF
PARVWNota Fiscal Partner Function J_1BPARVWCHAR2J_1BADJ_1BPARVWPAR
PARIDPartner ID (Customer, Vendor, Business Place) J_1BPARIDCHAR10ALPHAJ_1BPARIDDEBI_KRED
PARTYPNota Fiscal Partner Type J_1BPARTYPCHAR1J_1BPARTYP
XCPDKIndicator: Is the account a one-time account? XCPDKCHAR1XFELD
ANREDTitle ANREDCHAR15TEXT15
NAME1Name 1 NAME1_GPCHAR35NAME
NAME2Name 2 NAME2_GPCHAR35NAME
NAME3Name 3 NAME3_GPCHAR35NAME
NAME4Name 4 NAME4_GPCHAR35NAME
STRASHouse number and street STRAS_GPCHAR35TEXT35
ORT01City ORT01_GPCHAR35TEXT35
ORT02District ORT02_GPCHAR35TEXT35
REGIOSTATE (State, Province, County) REGIOCHAR3T005SREGIO
LAND1Country Key LAND1_GPCHAR3T005LAND1C_LAND1
PSTLZPostal Code PSTLZCHAR10PSTLZ
PFACHPO Box PFACHCHAR10PFACH
PSTL2P.O. Box Postal Code PSTL2CHAR10PSTLZ
SORTLSort field SORTLCHAR10CHAR10
SPRASLanguage Key SPRASLANG1T002ISOLASPRASSPRH_T002
TELF1Addresses: telephone no. TLFNRCHAR30TEXT30
TELFXFax Number TELFXCHAR31TEXT31
TELTXTeletex number TELTXCHAR30TEXT30
TELX1Telex number TELX1CHAR30TEXT30
INDUSTCustomer's CFOP category J_1BINDUS1CHAR2ALPHAJ_1BINDUS1
STKZNNatural Person STKZNCHAR1STKZN
CGCCNPJ Number J_1BCGCNUMC14CGCBRJ_1BCGC
CPFCPF number J_1BCPFNUMC11CPFBRJ_1BCPF
STAINSState Tax Number J_1BSTAINSCHAR18J_1BSTAINS
MUNINSMunicipal Tax Number J_1BMUNINSCHAR20J_1BMUNINS
TXJCDTax Jurisdiction TXJCDCHAR15TTXJTXJCDTXJ
HAUSNHouse number HAUSN_BASCHAR6CHAR6
STOCKFloor STOCKCHAR6STOCK
STREETStreet AD_STREETCHAR60TEXT60CLSTRTNAME
HOUSE_NUM1House Number AD_HSNM1CHAR10TEXT10
HOUSE_NUM2House number supplement AD_HSNM2CHAR10TEXT10
CTE_PARTNERCT-e Partner in Fiscal Document J_1BCTE_TOMALICHAR1J_1BCTE_TOMALI

Key field Non-key field



How do I retrieve data from SAP table J_1BNFNAD using ABAP code

The following ABAP code Example will allow you to do a basic selection on J_1BNFNAD to SELECT all data from the table
DATA: WA_J_1BNFNAD TYPE J_1BNFNAD.

SELECT SINGLE *
FROM J_1BNFNAD
INTO CORRESPONDING FIELDS OF WA_J_1BNFNAD
WHERE...

How to access SAP table J_1BNFNAD

Within an ECC or HANA version of SAP you can also view further information about J_1BNFNAD and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!