- Accounting - General (AC)
- Application Platform (AP)
- Basis Components (BC)
- Business Mobile (MOB)
- Business Network Solutions (BNS)
- Business intelligence solutions (BI)
- Collaborative Cross Applications (XAP)
- Controlling (CO)
- Cross-Application Components (CA)
- Cross-Application Components (CA)
- Customer Relationship Management (CRM)
- Customer Service (CS)
- Discrete Industries (DI)
- Enterprise Contract Management (CM)
- Enterprise Controlling (EC)
- Enterprise Performance Management (EPM)
- Enterprise Portal (EP)
- Enterprise Portal (EP)
- Enterprise information management solutions (EIM)
- Environment, Health, and Safety / Product Compliance (EHS)
- Financial Accounting (FI)
- Accounts Payable (FI-AP)
- Accounts Receivable (FI-AR)
- Additional Functions (FI-AF)
- Asset Accounting (FI-AA)
- Bank Accounting (FI-BL)
- Business Accounting (FIN-BAC)
- Business Analytics (FIN-BA)
- Central Finance (FI-CF)
- Consolidation (FI-LC)
- Contract Accounts Receivable and Payable (FI-CA)
- Convergent Contract Accounting (FI-CAC)
- Corporate Governance (FIN-CGV)
- Financial Shared Service Center (FIN-SSC)
- Financial Supply Chain Management (FIN-FSCM)
- Financials Basis (FIN-FB)
- Fiori UI for Financial Accounting (FI-FIO)
- Fiori UI for Financials (FIN-FIO)
- Funds Management (FI-FM)
- General Ledger Accounting (FI-GL)
- Generic Contract Accounts Receivable and Payable (FI-CAX)
- Lease Accounting (FI-LA)
- Localization (FI-LOC)
- ACR Activities (FI-LOC-VAT)
- Audit Reporting (FI-LOC-AUR)
- Cash Budgeting (FI-LOC-CB)
- Cash Management (FI-LOC-CM)
- Certification (FI-LOC-CER)
- Contract Accounts Receivable and Payable (FI-LOC-CA)
- Corporate Income Tax Framework (FI-LOC-CIT)
- Financials - UIs Localization (FI-LOC-UX)
- Globalization Service: Business Place (FI-LOC-BUP)
- Golden Audit Interface (FI-LOC-GAI)
- Golden Tax Interface (China) (FI-LOC-GTI)
- Localization Asset Accounting (FI-LOC-AA)
- Localization E-Payment Integration (FI-LOC-EPI)
- Localization Financials (FI-LOC-FI)
- Localization Financials (generic parts) (FI-LOC-GEN)
- Localization Financials Reporting Framework (FI-LOC-FRW)
- Localization Funds Management (FI-LOC-FM)
- Localization Logistics (FI-LOC-LO)
- Logistics Argentinia (FI-LOC-LO-AR)
- Logistics Brazil (FI-LOC-LO-BR)
- Logistics Bulgaria (FI-LOC-LO-BG)
- Logistics Croatia (FI-LOC-LO-HR)
- Logistics Greece (FI-LOC-LO-GR)
- Logistics India (FI-LOC-LO-IN)
- Logistics Israel (FI-LOC-LO-IL)
- Logistics Japan (FI-LOC-LO-JP)
- Logistics Latvia (FI-LOC-LO-LV)
- Logistics Netherlands (FI-LOC-LO-NL)
- Logistics Portugal (FI-LOC-LO-PT)
- Logistics Romania (FI-LOC-LO-RO)
- Logistics Russia (FI-LOC-LO-RU)
- Logistics Serbia (FI-LOC-LO-RS)
- Localization Public Sector (FI-LOC-PS)
- Localization Tax Service (FI-LOC-TXS)
- Localization Travel Management (FI-LOC-TV)
- Localization for Sales and Distribution (FI-LOC-SD)
- Localization for Treasury (FI-LOC-TRM)
- Localization for Utilities Industry (FI-LOC-UT)
- Online Validation Framework (FI-LOC-OVF)
- Payment Receipt (FI-LOC-PR)
- SAF-T Reporting (Generic Part) (FI-LOC-SAF)
- Statutory Reporting (FI-LOC-IS)
- Statutory Reporting Framework (FI-LOC-SRF)
- Tax Invoice Management (FI-LOC-TIM)
- VAT Pro Rata (FI-LOC-RAT)
- Predictive Accounting (FI-PRA)
- Real-Time Consolidation (FIN-RTC)
- Revenue Accounting (FI-RA)
- S4H Best Practices - Content and Content Activation (FI-CNT)
- S4HANA Financial Consolidation[Cloud] (FIN-CS)
- SAP Simple Finance data migration (FIN-MIG)
- Special Purpose Ledger (FI-SL)
- Strategic Enterprise Management (FIN-SEM)
- Tax Management Framework (FIN-TMF)
- Tax Subledger (FI-TXL)
- Travel Management (FI-TV)
- Financial Services (FS)
- Financials (FIN)
- Global Trade Services (SLL)
- Governance, Risk and Compliance (GRC)
- Incentive and Commission Management (ICM) (ICM)
- Investment Management (IM)
- Knowledge Management (KM)
- LOD Components (LOD)
- Logistics - General (LO)
- Logistics Execution (LE)
- Materials Management (MM)
- Obsolete Product: mySAP.com Workplace (WP)
- Occasional Platform User (OPU)
- Payroll (PY)
- Personnel Management (PA)
- Personnel Time Management (PT)
- Plant Maintenance (PM)
- Portfolio and Project Management (PPM)
- Product Lifecycle Management (PLM)
- Production Planning and Control (PP)
- Project System (PS)
- Public Sector Management (PSM)
- Purchasing SAP Cloud (PUR)
- Quality Management (QM)
- Real Estate Management (RE)
- SAP Business Warehouse (BW)
- SAP HANA (HAN)
- SAP NetWeaver Master Data Management (MDM)
- SAP Supplier Lifecycle Management (SLC)
- Sales and Distribution (SD)
- Service (SV)
- Supply Chain Management (SCM)
- Sustainability management (SUS)
- Training and Event Management (PE)
- Transportation Management (TM)
- Treasury (TR)
- Web Channel (WEC)
J_1BNFDOC
- 🔑 Keys (2)
- 💰 Amounts (10)
- ∑ Quantities (2)
- 📅 Dates (16)
- ☰ Categorical (45)
- Other (85)
- 🔗 Relations (21)
| Column Name | Description | |
|---|---|---|
| MANDT FK | Client | |
| DOCNUM | Document Number |
| Column Name | Description | |
|---|---|---|
| 💲 SD Document Currency (WAERK): | ||
| WITHA | Total withholding amount of Nota Fiscal | |
| NFTOT | Total value including all taxes | |
| TOTAL_REF_AMT | Total Amount of Goods | |
| VORIG | Invoice Original Value | |
| VDESC | Invoice Discount Value | |
| VLIQ | Invoice Net Value | |
| V_TROCO | Change Value | |
| VFOR | Sugar Cane: Supply Amount | |
| VTOTDED | Sugar Cane: Total Deduction Amount | |
| VLIQFOR | Sugar Cane: Supply Net Amount | |
| Column Name | Description | |
|---|---|---|
| 📏 Weight Unit (GEWEI): | ||
| BRGEW | Gross weight | |
| NTGEW | Net weight | |
| Column Name | Description | |
|---|---|---|
| DOCDAT | Document date | |
| PSTDAT | Posting date | |
| CREDAT | Create date | |
| CRETIM | Creation time | |
| CHADAT | Change date | |
| CHATIM | Change time | |
| CANDAT | Cancellation Date | |
| ZFBDT | Baseline Date for Due Date Calculation | |
| AUTHDATE | Processing Timestamp - Date | |
| AUTHTIME | Processing Timestamp - Time | |
| PLN_DT_DLV | Estimated Delivery Date | |
| DSAIENT | Goods Departure or Arrival Date | |
| HSAIENT | Goods Departure or Arrival Time | |
| DCOMPET | Service Delivery Date | |
| HEMI | NF-e Issuing Time | |
| ITMF_REPDAT | TMF Reporting Date |
| Column Name | Description | |
|---|---|---|
| DIRECT | Direction of the movement | Show values |
| MODEL | Model of Nota Fiscal | Show values |
| ENTRAD | Nota Fiscal Entrada | Show values |
| FATURA | Fatura | Show values |
| PRINTD | Printed | Show values |
| MANUAL | Created manually | Show values |
| FOLLOW | Follow up activity made | Show values |
| PARXCPDK | Indicator: Is the account a one-time account? | Show values |
| PARTYP | Nota Fiscal Partner Type | Show values |
| CANCEL | Canceled | Show values |
| SUBSEQ | Follow-On Document Exists | Show values |
| NFDEC | Decimal Places in Price Inclusive of ICMS | Show values |
| NFE | Electronic Fiscal Document | Show values |
| NFESRV | Service NF/NF-e | Show values |
| CONTING | Document Posted under Contingency | Show values |
| DOCSTAT | Document Status | Show values |
| INDUST | Customer's CFOP category | Show values |
| STKZN | Natural Person | Show values |
| IND_IEDEST | NF-e State Tax Number Indicator | Show values |
| BAPI_FLAG | Nota Fiscal Created via BAPI | Show values |
| SERV_TP | Service Type Indicator | Show values |
| RCVR_WDW | Receiver Collection Indicator | Show values |
| FTL_IND | Full Truck Load Indicator | Show values |
| TRANSP_MODE | Mode of Transportation | Show values |
| CTE_PARTNER | CT-e Partner in Fiscal Document | Show values |
| CTE_SERV_TAKER | CT-e Partner as Service Taker | Show values |
| CTE_TYPE | CT-e Type | Show values |
| AUTOM_INCOMING | Indicator for price elements coming from XML | Show values |
| MUNICIPAL | Municipal Fiscal Document | Show values |
| INDPAG | [OBSOLETE] Payment Form Indicator | Show values |
| CRT_BUPLA | Tax Regimen Code (CRT) of Business Place | Show values |
| CRT_PARTNER | Tax Regimen Code (CRT) of Partner | Show values |
| MODFRETE | Freight Mode | Show values |
| IND_EMIT | Indicator of Fiscal Document's Issuer | Show values |
| COD_SIT | Status Code of Fiscal Document | Show values |
| IND_FINAL | NF-e Final Consumer Identification | Show values |
| IND_PRES | NF-e Customer Presence | Show values |
| IND_BADI_CTRL | Flag that determines if BAdI ADD_DATA was used | Show values |
| ID_DEST | NF-e Identifier of Destination Place | Show values |
| MOD | Fiscal Coupon Document Model | Show values |
| INDINTERMED | Intermediator Indicator | Show values |
| ITMF_PCO_CATEGORY | Tax Category | Show values |
| PARTNER_ROLE | NF Partner Place Type | Show values |
| API | Created by API | Show values |
| TAX_SERVICES_CALC | Tax calculation from tax service | Show values |
| Column Name | Description | Domain name | |
|---|---|---|---|
| CRENAM | Name of the user | USNAM | |
| CHANAM | Name of the user | USNAM | |
| SERIES | Series | J_1BSERIES | |
| SUBSER | Sub series | J_1BSUBSER | |
| NFNUM | Nota Fiscal Number | J_1BNFNUMB | |
| ZTERM | Terms of payment key | ZTERM | |
| BELNR | Document Number of an Accounting Document | BELNR | |
| GJAHR | Fiscal Year | GJAHR | |
| PARID | Partner ID (Customer, Vendor, Business Place) | J_1BPARID | |
| TRAID | Means of Transport ID | TRAID | |
| INCO2 | Incoterms (Part 2) | INCO2 | |
| ANZPK | Total Number of Packages in Delivery | ANZPK | |
| SHPMRK | Mark of the shipping unit | TEXT20 | |
| SHPNUM | Number of the shipping unit | TEXT20 | |
| OBSERVAT | Legal Books Mod. 1 + 2: Header text for observations column | J_1BLBOBS | |
| AWSYS | Logical System | LOGSYS | |
| PREFNO | Service NF-e Number | J_1BPREFNO | |
| CHECOD | Verification Code of Service NF-e | J_1BCHECOD | |
| NFENUM | Electronic Nota Fiscal Number | J_1BNFNUM9 | |
| AUTHCOD | Protocol Number | J_1BNFEAUTHCODE | |
| XMLVERS | XML Version | J_1BNFEXMLVERSION | |
| NFENRNR | Number range number | CHAR2 | |
| CODE | Official Status Code | J_1BSTATUSCODE | |
| ANRED | Title | TEXT15 | |
| NAME1 | Name 1 | NAME | |
| NAME2 | Name 2 | NAME | |
| NAME3 | Name 3 | NAME | |
| NAME4 | Name 4 | NAME | |
| STRAS | Street and House Number | TEXT35 | |
| ORT01 | City | TEXT35 | |
| ORT02 | District | TEXT35 | |
| PSTLZ | Postal Code | PSTLZ | |
| PFACH | PO Box | PFACH | |
| PSTL2 | P.O. Box Postal Code | PSTLZ | |
| SORTL | Sort field | CHAR10 | |
| TELF1 | Addresses: telephone no. | TEXT30 | |
| TELFX | Fax Number | TEXT31 | |
| TELTX | Teletex number | TEXT30 | |
| TELX1 | Telex number | TEXT30 | |
| CGC | CNPJ Number | J_1BCGC | |
| CPF | CPF number | J_1BCPF | |
| STAINS | State Tax Number | J_1BSTAINS | |
| MUNINS | Municipal Tax Number | J_1BMUNINS | |
| HAUSN | House number | CHAR6 | |
| STOCK | Floor | STOCK | |
| STREET | Street | TEXT60 | |
| HOUSE_NUM1 | House Number | TEXT10 | |
| HOUSE_NUM2 | House number supplement | TEXT10 | |
| FOREIGNID | NF-e Partner Foreign ID | J_1BNFE_FOREIGNID | |
| SMTP_ADDR | E-Mail Address | AD_SMTPADR | |
| MAIN_PRODUCT | Main Product Transported | CHAR60 | |
| VOL_TRANSP | Transported Volume | ||
| CRE_TIMESTAMP | Fiscal Document: UTC Time Stamp of Creation (Short Form) | TZNTSTMPS | |
| DOCNUM_NEXT | New Document Number when electronic fiscal doc. is copied | J_1BDOCNUM | |
| DOCNUM_PREV | Previous Document Number when electronic fis. doc. is copied | J_1BDOCNUM | |
| NATOP | Operation Nature Description | TEXT60 | |
| CNPJ_BUPLA | CNPJ Number of Business Place | J_1BCGC | |
| IE_BUPLA | State Tax Number (IE) of Business Place | J_1BSTAINS | |
| IEST_BUPLA | State Tax Number (IE) of Business Place (SubTrib) | J_1BSTAINS | |
| IEST_PARTNER | State Tax Number of Partner (SubTrib) | J_1BSTAINS | |
| IM_BUPLA | Municipal tax code | J_1BMUNINS | |
| ISUF | SUFRAMA Subscription of Partner | J_1BSUFRAMA | |
| PLACA | Vehicle License Plate | CHAR7 | |
| RNTC | National Cargo Carrier Registration (RNTRC) | CHAR20 | |
| VAGAO | Wagon Identification | CHAR20 | |
| BALSA | Ferryboat Identification | CHAR20 | |
| NFAT | Invoice Number | CHAR20 | |
| XLOCEMBARQ | Shipment Place (Export) | CHAR60 | |
| XNEMP | Commitment Note | CHAR22 | |
| SPRAS_BUPLA | Language of Business Place | CHAR1 | |
| XLOCDESPACHO | Dispatch | J_1BNFE_DISPATCH | |
| CREGTRIB | Special Tax Regime Code | ||
| RETTRANSP_CFOP | CFOP of ICMS Withholding for Transportation | J_1BCFOP | |
| RETTRANSP_CMUNFG | City Code | ||
| NCOO | Operation Order Counter Number | J_1BNFE_NCOO | |
| IDCADINTTRAN | Intermediator Identification Registry | CHAR60 | |
| CNPJINTERMED | CNPJ of the Intermediator | J_1BCGC | |
| SAFRA | Harvest Identification | CHAR9 | |
| REF_MONTH_YEAR | Reference Month and Year | CHAR7 | |
| QTOTMES | Sugar Cane: Month Quantity | ||
| QTOTANT | Sugar Cane: Previous Quantity | ||
| QTOTGER | Sugar Cane: Total Quantity | ||
| PARTR | ICMS Partilha Tax Rate | ||
| NFNUM_UTILITIES | Nota Fiscal Number for Utilities | J_1BNFNUM_UTILITIES | |
| COD_CTA_HEADER | G/L Account Number for Revenue/Expenses | SAKNR |
| Master Data Relations | Join Conditions |
|---|---|
| Company Code | |
Jurisdiction Code of the Final Destination
| |
Jurisdiction Code of the Point of Origin
| |
Document type
|
|
| Form of Electronic Fiscal Document | |
| Weight Unit | |
Incoterms (Part 1)
| |
Country/Region Key
| |
| Client | J_1BNFDOC.MANDT == T000.MANDT |
Nota Fiscal Type
| |
| Nota Fiscal Partner Function | |
Region (State, Province, County)
| |
| Shipping unit (especie) | |
| Language Key | J_1BNFDOC.SPRAS == T002.SPRAS |
| Means-of-Transport Type | |
Tax Jurisdiction
| |
Region of Vehicle
| |
Region of Shipment Place (Export)
| |
| Foreign Key for Shipping Point | |
| SD Document Currency |