J_1BNFDOC SAP (Nota Fiscal Header) Table details
Dictionary Type: Table
Description: Nota Fiscal Header
Description: Nota Fiscal Header
Table field list including key, data, relationships and ABAP select examples
J_1BNFDOC is a standard SAP Table which is used to store Nota Fiscal Header data and is available within R/3 SAP systems depending on the version and release level.
The J_1BNFDOC table consists of various fields, each holding specific information or linking keys about Nota Fiscal Header data available in SAP. These include DOCNUM (Document Number), NFTYPE (Nota Fiscal Type), DOCTYP (Document type), DIRECT (Direction of the movement).. 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_1BNFDOC 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 |
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
DOCNUM | Document Number | J_1BDOCNUM | NUMC | 10 | J_1BDOCNUM | JEF | |||
NFTYPE | Nota Fiscal Type | J_1BNFTYPE | CHAR | 2 | J_1BAA | J_1BNFTYPE | |||
DOCTYP | Document type | J_1BDOCTYP | CHAR | 1 | J_1BDOCTYPES | J_1BDOCTYP | |||
DIRECT | Direction of the movement | J_1BDIRECT | CHAR | 1 | J_1BDIRECT | ||||
DOCDAT | Document date | J_1BDOCDAT | DATS | 8 | DATUM | ||||
PSTDAT | Posting date | J_1BPSTDAT | DATS | 8 | DATUM | ||||
CREDAT | Create date | J_1BCREDAT | DATS | 8 | DATUM | ||||
CRETIM | Creation time | J_1BCRETIM | TIMS | 6 | UZEIT | ||||
CRENAM | Name of the user | J_1BCRENAM | CHAR | 12 | USNAM | ||||
CHADAT | Change date | J_1BCHADAT | DATS | 8 | DATUM | ||||
CHATIM | Change time | J_1BCHATIM | TIMS | 6 | UZEIT | ||||
CHANAM | Name of the user | J_1BCHANAM | CHAR | 12 | USNAM | ||||
FORM | Form of Nota Fiscal | J_1BFORM | CHAR | 4 | J_1BAQ | J_1BFORM | |||
MODEL | Model of Nota Fiscal | J_1BMODEL | NUMC | 2 | J_1BMODEL | ||||
SERIES | Series | J_1BSERIES | CHAR | 3 | J_1BSERIES | ||||
SUBSER | Sub series | J_1BSUBSER | CHAR | 2 | J_1BSUBSER | ||||
NFNUM | Nota Fiscal Number | J_1BNFNUMB | NUMC | 6 | J_1BNFNUMB | ||||
ENTRAD | Nota Fiscal Entrada | J_1BENTRAD | CHAR | 1 | J_1BENTRAD | ||||
FATURA | Fatura | J_1BFATURA | CHAR | 1 | XFELD | ||||
ZTERM | Terms of Payment Key | DZTERM | CHAR | 4 | ZTERM | ||||
PRINTD | Printed | J_1BPRINTD | CHAR | 1 | XFELD | ||||
MANUAL | Created manually | J_1BMANUAL | CHAR | 1 | J_1BMANUAL | ||||
FOLLOW | Follow up activity made | J_1BFOLLOW | CHAR | 1 | XFELD | ||||
WAERK | SD Document Currency | WAERK | CUKY | 5 | TCURC | WAERS | FWS | ||
BELNR | Accounting Document Number | BELNR_D | CHAR | 10 | ALPHA | BELNR | BLN | ||
GJAHR | Fiscal Year | GJAHR | NUMC | 4 | GJAHR | GJAHR | GJR | ||
BUKRS | Company Code | BUKRS | CHAR | 4 | T001 | BUKRS | BUK | C_T001 | |
BRANCH | Business Place | J_1BBRANC_ | CHAR | 4 | J_1BBRANCH | J_1BBRANCH | |||
PARVW | Nota Fiscal Partner Function | J_1BPARVW | CHAR | 2 | J_1BAD | J_1BPARVW | PAR | ||
PARID | Partner ID (Customer, Vendor, Business Place) | J_1BPARID | CHAR | 10 | ALPHA | J_1BPARID | DEBI_KRED | ||
PARXCPDK | Indicator: Is the account a one-time account? | XCPDK | CHAR | 1 | XFELD | ||||
PARTYP | Nota Fiscal Partner Type | J_1BPARTYP | CHAR | 1 | J_1BPARTYP | ||||
CANCEL | Canceled | J_1BCANCEL | CHAR | 1 | XFELD | ||||
CANDAT | Cancellation Date | J_1BCANDAT | DATS | 8 | DATUM | ||||
SUBSEQ | Follow-On Document Exists | J_1BSUBSEQ | CHAR | 1 | XFELD | ||||
DOCREF | Reference to NF | J_1BDOCREF | NUMC | 10 | J_1BNFDOC | J_1BDOCNUM | |||
TRATY | Means-of-Transport Type | TRATY | CHAR | 4 | TVTY | TRATY | |||
TRAID | Means of Transport ID | TRAID | CHAR | 20 | TRAID | ||||
INCO1 | Incoterms (Part 1) | INCO1 | CHAR | 3 | TINC | INCO1 | |||
INCO2 | Incoterms (Part 2) | INCO2 | CHAR | 28 | INCO2 | ||||
SHPUNT | Shipping unit (especie) | J_1BSHPUNT | UNIT | 3 | T006 | CUNIT | MEINS | ||
ANZPK | Total number of packages in delivery | ANZPK | NUMC | 5 | ANZPK | ||||
SHPMRK | Mark of the shipping unit | J_1BSHPMRK | CHAR | 20 | TEXT20 | ||||
SHPNUM | Number of the shipping unit | J_1BSHPNUM | CHAR | 20 | TEXT20 | ||||
BRGEW | Gross weight | BRGEW_15 | QUAN | 15(3) | MENG15 | ||||
NTGEW | Net weight | NTGEW_15 | QUAN | 15(3) | MENG15 | ||||
GEWEI | Weight Unit | GEWEI | UNIT | 3 | T006 | CUNIT | MEINS | ||
ZFBDT | Baseline Date for Due Date Calculation | DZFBDT | DATS | 8 | DATUM | ||||
WITHA | Total withholding amount of Nota Fiscal | J_1BWITHAM | CURR | 15(2) | WERT8 | ||||
OBSERVAT | Legal Books Mod. 1 + 2: Header text for observations column | J_1BLBOBS | CHAR | 50 | J_1BLBOBS | ||||
VSTEL | Shipping Point/Receiving Point | VSTEL | CHAR | 4 | TVST | VSTEL | VST | ||
NFDEC | Decimal Places in Price Inclusive of ICMS | J_1BNFDEC | NUMC | 1 | J_1BNFDEC | ||||
NFTOT | Total value including all taxes | J_1BNFTOT | CURR | 15(2) | WERTV8 | ||||
AWSYS | Logical System | LOGSYSTEM | CHAR | 10 | Assigned to domain | ALPHA | LOGSYS | ||
PREFNO | Service NF-e Number Provided by Prefecture | J_1BPREFNO | CHAR | 20 | J_1BPREFNO | ||||
CHECOD | Verification Code of Service NF-e | J_1BCHECOD | CHAR | 20 | J_1BCHECOD | ||||
NFE | Electronic Fiscal Document | J_1BNFE | CHAR | 1 | XFELD | ||||
NFENUM | Nine-Digit Document Number | J_1BNFNUM9 | CHAR | 9 | J_1BNFNUM9 | ||||
NFESRV | Service NF/NF-e | J_1BNFESRV | CHAR | 1 | XFELD | ||||
CONTING | Document Posted under Contingency | J_1BCONTINGENCY | CHAR | 1 | XFELD | ||||
AUTHCOD | Protocol Number | J_1BNFEAUTHCODE | CHAR | 15 | J_1BNFEAUTHCODE | ||||
DOCSTAT | Document Status | J_1BNFEDOCSTATUS | CHAR | 1 | J_1BNFEDOCSTATUS | ||||
XMLVERS | XML Version | J_1BNFEXMLVERSION | DEC | 4(2) | J_1BNFEXMLVERSION | ||||
NFENRNR | Number range number | NRNR | CHAR | 2 | CHAR2 | ||||
CODE | Official Status Code | J_1BSTATUSCODE | CHAR | 3 | Assigned to domain | ALPHA | J_1BSTATUSCODE | ||
ANRED | Title | ANRED | CHAR | 15 | TEXT15 | ||||
NAME1 | Name 1 | NAME1_GP | CHAR | 35 | NAME | ||||
NAME2 | Name 2 | NAME2_GP | CHAR | 35 | NAME | ||||
NAME3 | Name 3 | NAME3_GP | CHAR | 35 | NAME | ||||
NAME4 | Name 4 | NAME4_GP | CHAR | 35 | NAME | ||||
STRAS | House number and street | STRAS_GP | CHAR | 35 | TEXT35 | ||||
ORT01 | City | ORT01_GP | CHAR | 35 | TEXT35 | ||||
ORT02 | District | ORT02_GP | CHAR | 35 | TEXT35 | ||||
REGIO | STATE (State, Province, County) | REGIO | CHAR | 3 | T005S | REGIO | |||
LAND1 | Country Key | LAND1_GP | CHAR | 3 | T005 | LAND1 | C_LAND1 | ||
PSTLZ | Postal Code | PSTLZ | CHAR | 10 | PSTLZ | ||||
PFACH | PO Box | PFACH | CHAR | 10 | PFACH | ||||
PSTL2 | P.O. Box Postal Code | PSTL2 | CHAR | 10 | PSTLZ | ||||
SORTL | Sort field | SORTL | CHAR | 10 | CHAR10 | ||||
SPRAS | Language Key | SPRAS | LANG | 1 | T002 | ISOLA | SPRAS | SPR | H_T002 |
TELF1 | Addresses: telephone no. | TLFNR | CHAR | 30 | TEXT30 | ||||
TELFX | Fax Number | TELFX | CHAR | 31 | TEXT31 | ||||
TELTX | Teletex number | TELTX | CHAR | 30 | TEXT30 | ||||
TELX1 | Telex number | TELX1 | CHAR | 30 | TEXT30 | ||||
INDUST | Customer's CFOP category | J_1BINDUS1 | CHAR | 2 | ALPHA | J_1BINDUS1 | |||
STKZN | Natural Person | STKZN | CHAR | 1 | STKZN | ||||
CGC | CNPJ Number | J_1BCGC | NUMC | 14 | CGCBR | J_1BCGC | |||
CPF | CPF number | J_1BCPF | NUMC | 11 | CPFBR | J_1BCPF | |||
STAINS | State Tax Number | J_1BSTAINS | CHAR | 18 | J_1BSTAINS | ||||
MUNINS | Municipal Tax Number | J_1BMUNINS | CHAR | 20 | J_1BMUNINS | ||||
TXJCD | Tax Jurisdiction | TXJCD | CHAR | 15 | TTXJ | TXJCD | TXJ | ||
HAUSN | House number | HAUSN_BAS | CHAR | 6 | CHAR6 | ||||
STOCK | Floor | STOCK | CHAR | 6 | STOCK | ||||
STREET | Street | AD_STREET | CHAR | 60 | TEXT60 | CLSTRTNAME | |||
HOUSE_NUM1 | House Number | AD_HSNM1 | CHAR | 10 | TEXT10 | ||||
HOUSE_NUM2 | House number supplement | AD_HSNM2 | CHAR | 10 | TEXT10 | ||||
AUTHDATE | Processing Timestamp - Date | J_1BAUTHDATE | DATS | 8 | DATUM | ||||
AUTHTIME | Processing Timestamp - Time | J_1BAUTHTIME | TIMS | 6 | UZEIT | ||||
BAPI_FLAG | Nota Fiscal Created via BAPI | J_1BBAPI | CHAR | 1 | XFELD | ||||
SERV_TP | Service Type Indicator | J_1BCTE_SERV_TP | CHAR | 1 | J_1BCTE_SERV_TP | ||||
CTE_STRT_LCT | Jurisdiction Code of the Point of Origin | J_1BCTE_SJCD | CHAR | 15 | J_1BTXJUR | J_1BTXJCD | |||
CTE_END_LCT | Jurisdiction Code of the Final Destination | J_1BCTE_EJCD | CHAR | 15 | J_1BTXJUR | J_1BTXJCD | |||
MAIN_PRODUCT | Main Product Transported | J_1BCTE_MAIN_PROD | CHAR | 60 | CHAR60 | ||||
RCVR_WDW | Receiver Collection Indicator | J_1BCTE_RCVR_WDW | CHAR | 1 | XFELD | ||||
PLN_DT_DLV | Estimated Delivery Date | J_1BCTE_PLN_DT_DLV | DATS | 8 | DATUM | ||||
FTL_IND | Full Truck Load Indicator | J_1BCTE_FTL_IND | CHAR | 1 | XFELD | ||||
VOL_TRANSP | Transported Volume | J_1BCTE_VOL_TRANSP | DEC | 13(3) | |||||
VOL_UNIT | Volume Measure Unit | J_1BCTE_VOL_UNIT | UNIT | 3 | Assigned to domain | CUNIT | MEINS | ||
TOTAL_REF_AMT | Total Amount of Goods | J_1BCTE_REF_TOT_VAL | CURR | 15(2) | WERT8 | ||||
TRANSP_MODE | Mode of Transportation | J_1BCTE_TRANSPTN_MODE | CHAR | 1 | J_1BCTE_TRANSPTN_MODE | ||||
CRE_TIMESTAMP | Fiscal Document: UTC Time Stamp of Creation (Short Form) | J_1BCRE_TIMESTAMP | DEC | 15 | TZNTSTMPS | ||||
CTE_PARTNER | CT-e Partner in Fiscal Document | J_1BCTE_TOMALI | CHAR | 1 | J_1BCTE_TOMALI | ||||
CTE_SERV_TAKER | CT-e Partner as Service Taker | J_1BCTE_SERVICE_TAKER | CHAR | 1 | J_1BCTE_SERVICE_TAKER | ||||
CTE_TYPE | CT-e Type | J_1BCTTYPE | CHAR | 1 | J_1BCTTYPE | ||||
AUTOM_INCOMING | Indicator for price elements coming from XML | J_1B_POSTED_WITH_XML_VALUES | CHAR | 1 | FLAG | ||||
DOCNUM_NEXT | New Document Number when electronic fiscal doc. is copied | J_1BDOCNUM_NEXT | NUMC | 10 | Assigned to domain | J_1BDOCNUM | |||
DOCNUM_PREV | Previous Document Number when electronic fis. doc. is copied | J_1BDOCNUM_PREV | NUMC | 10 | Assigned to domain | J_1BDOCNUM | |||
MUNICIPAL | Municipal Fiscal Document | J_1BMUNICIPAL | CHAR | 1 | XFELD | ||||
NATOP | Operation Nature Description | J_1B_OP_NATURE_DESC | CHAR | 60 | TEXT60 | ||||
INDPAG | Payment Form Indicator | J_1B_PAY_FORM_IND | CHAR | 1 | J_1B_PAY_FORM_IND | ||||
DSAIENT | Goods Departure or Arrival Date | J_1B_DEP_ARR_DATE | DATS | 8 | DATUM | ||||
HSAIENT | Goods Departure or Arrival Time | J_1B_DEP_ARR_TIME | TIMS | 6 | UZEIT | ||||
CNPJ_BUPLA | CNPJ Number of Business Place | J_1B_CNPJ_BUPLA | NUMC | 14 | CGCBR | J_1BCGC | |||
IE_BUPLA | State Tax Number (IE) of Business Place | J_1B_STAINS_BUPLA | CHAR | 18 | J_1BSTAINS | ||||
IEST_BUPLA | State Tax Number (IE) of Business Place (SubTrib) | J_1B_STAIST_BUPLA | CHAR | 18 | J_1BSTAINS | ||||
IEST_PARTNER | State Tax Number of Partner (SubTrib) | J_1B_STAIST_PARTNER | CHAR | 18 | J_1BSTAINS | ||||
IM_BUPLA | Municipal tax code | J_1B_MUNINS_BUPLA | CHAR | 20 | J_1BMUNINS | ||||
CNAE_BUPLA | CNAE Code of Business Place | J_1B_CNAE_BUPLA | CHAR | 7 | CHAR7 | ||||
CNAE_PARTNER | CNAE Code of Partner | J_1B_CNAE_PARTNER | CHAR | 7 | CHAR7 | ||||
CRT_BUPLA | Tax Regimen Code (CRT) of Business Place | J_1B_CRT_BUPLA | CHAR | 1 | J_1BCRTN | ||||
CRT_PARTNER | Tax Regimen Code (CRT) of Partner | J_1B_CRT_PARTNER | CHAR | 1 | J_1BCRTN | ||||
ISUF | SUFRAMA Subscription of Partner | J_1B_SUFRAMA_CODE | CHAR | 9 | J_1BSUFRAMA | ||||
MODFRETE | Freight Mode | J_1B_FREIGHT_MODE | CHAR | 1 | J_1B_FREIGHT_MODE | ||||
PLACA | Vehicle License Plate | J_1B_VEHICLE_LIC_PL | CHAR | 7 | CHAR7 | ||||
UF1 | Region of Vehicle | J_1B_VEHICLE_UF | CHAR | 3 | T005S | REGIO | |||
RNTC | National Cargo Carrier Registration (RNTRC) | J_1B_NAT_CARGO_CARRIER | CHAR | 20 | CHAR20 | ||||
VAGAO | Wagon Identification | J_1B_WAGON_ID | CHAR | 20 | CHAR20 | ||||
BALSA | Ferryboat Identification | J_1B_FERRYBOAD_ID | CHAR | 20 | CHAR20 | ||||
NFAT | Invoice Number | J_1B_BILLING_NUMBER | CHAR | 20 | CHAR20 | ||||
VORIG | Invoice Original Value | J_1B_BILLING_ORG_VALUE | CURR | 15(2) | WERT15 | ||||
VDESC | Invoice Discount Value | J_1B_DISCOUNT_VALUE | CURR | 15(2) | WERT15 | ||||
VLIQ | Invoice Net Value | J_1B_BILLING_NET_VALUE | CURR | 15(2) | WERT15 | ||||
UFEMBARQ | Region of Shipment Place (Export) | J_1B_SHIPMENT_PLACE_UF | CHAR | 3 | T005S | REGIO | |||
XLOCEMBARQ | Shipment Place (Export) | J_1B_SHIPMENT_PLACE | CHAR | 60 | CHAR60 | ||||
XNEMP | Commitment Note | J_1B_COMMITMENT_NOTE | CHAR | 22 | CHAR22 | ||||
SPRAS_BUPLA | Language of Business Place | J_1B_SPRAS_BUPLA | CHAR | 1 | CHAR1 | ||||
IND_EMIT | Indicator of Fiscal Document's Issuer | J_1B_FISC_DOC_ISSUER | CHAR | 1 | J_1B_FISC_DOC_ISSUER | ||||
COD_SIT | Status Code of Fiscal Document | J_1B_STATUS_FISC_DOC | CHAR | 2 | J_1B_STATUS_FISC_DOC | ||||
SAFRA | Harvest Identification | J_1B_HARVEST_ID | CHAR | 9 | CHAR9 | ||||
REF_MONTH_YEAR | Reference Month and Year | J_1B_REF_MONTH_YEAR | CHAR | 7 | CHAR7 | ||||
QTOTMES | Sugar Cane: Month Quantity | J_1B_SUGAR_QUAN_MONTH | DEC | 21(10) | |||||
QTOTANT | Sugar Cane: Previous Quantity | J_1B_SUGAR_QUAN_PREV | DEC | 21(10) | |||||
QTOTGER | Sugar Cane: Total Quantity | J_1B_SUGAR_QUAN_TOT | DEC | 21(10) | |||||
VFOR | Sugar Cane: Supply Amount | J_1B_SUPPLIES_VALUE | CURR | 15(2) | WERT15 | ||||
VTOTDED | Sugar Cane: Total Deduction Amount | J_1B_TOTAL_DEDUCT_VALUE | CURR | 15(2) | WERT15 | ||||
VLIQFOR | Sugar Cane: Supply Net Amount | J_1B_SUPPLIES_NET_VALUE | CURR | 15(2) | WERT15 |
Key field | Non-key field |
How do I retrieve data from SAP table J_1BNFDOC using ABAP code
The following ABAP code Example will allow you to do a basic selection on J_1BNFDOC to SELECT all data from the tableDATA: WA_J_1BNFDOC TYPE J_1BNFDOC.
SELECT SINGLE *
FROM J_1BNFDOC
INTO CORRESPONDING FIELDS OF WA_J_1BNFDOC
WHERE...
How to access SAP table J_1BNFDOC
Within an ECC or HANA version of SAP you can also view further information about J_1BNFDOC and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects