J_1BNFLIN is a SAP table coming under CRM module and BBPCRM component.View details, Fields & related tables of J_1BNFLIN in SAP.
- Table description : Nota Fiscal line items
- Module : CRM-LOC-BR
- Parent Module : CRM
- Package : J1BA
- Software Component : BBPCRM
Here is some free PDF files that you can download free for your reference.
Download Now
Definitions
What is SAP ?SAP is the short form of Systems, Applications & Products in Data Processing. It is one of the largest business process related software. This software focused on business processes on ERP & CRM.
What is table in SAP ?Like most other software, SAP also using database tables to store the data. In SAP thousands of tables are there to store different data. A table contains several fields and some of the fields will be key fields.
SAP J_1BNFLIN Table Fields structure
Field | Note | Data Element | Domain |
---|---|---|---|
MANDT | Client | MANDT | MANDT |
DOCNUM | Document Number | J_1BDOCNUM | J_1BDOCNUM |
ITMNUM | Document Item Number | J_1BITMNUM | J_1BITMNUM |
MATNR | Material Number | MATNR | MATNR |
BWKEY | Valuation area | BWKEY | BWKEY |
BWTAR | Valuation type | BWTAR_D | BWTAR |
CHARG | Batch Number | CHARG_D | CHARG |
MATKL | Material Group | MATKL | MATKL |
MAKTX | Material description | MAKTX | TEXT40 |
DOCREF | Reference to NF | J_1BDOCREF | J_1BDOCNUM |
ITMREF | Reference to item number (Return) | J_1BITMREF | J_1BITMNUM |
CFOP | CFOP code and extension | J_1BCFOP | J_1BCFOP |
NBM | Control code for consumption taxes in foreign trade | STEUC | STEUC |
MATORG | Origin of the material | J_1BMATORG | J_1BMATORG |
TAXSIT | Tax situation ICMS | J_1BTAXSIT | J_1BTAXSIT |
TAXSI2 | Tax situation IPI | J_1BTAXSI2 | J_1BTAXSI2 |
OWNPRO | Produced in-house | J_1BOWNPRO | XFELD |
MATUSE | Usage of the material | J_1BMATUSE | J_1BMATUSE |
REFTYP | Reference type | J_1BREFTYP | J_1BREFTYP |
REFKEY | Reference to source document | J_1BREFKEY | J_1BREFKEY |
REFITM | Reference item to source document | J_1BREFITM | J_1BREFITM |
MENGE | Quantity | J_1BNETQTY | MENG13 |
MEINS | Base unit of measure | J_1BNETUNT | MEINS |
NETPR | Net price | J_1BNETPRI | J_1BNFPRI |
NETWR | Net Value | J_1BNETVAL | WERTV8 |
TAXLW1 | Tax law: ICMS | J_1BTAXLW1 | J_1BTAXLW1 |
TAXLW2 | Tax law: IPI | J_1BTAXLW2 | J_1BTAXLW2 |
TMISS | Service tax - no ICMS/IPI calculation | J_1BTMISS | XFELD |
NETFRE | Net freight value in document currency | J_1BNETFRE | WERTV8 |
NETINS | Net insurance value in document currency | J_1BNETINS | WERTV8 |
NETOTH | Net expenses in document currency | J_1BNETOTH | WERTV8 |
INDUS3 | Material CFOP category | J_1BINDUS3 | J_1BINDUS3 |
ITMTYP | Nota Fiscal Item Type | J_1BITMTYP | J_1BITMTYP |
NETDIS | Net discount value in document currency | J_1BNETDIS | WERTV8 |
SPCSTO | Nota Fiscal Special Case for CFOP Determination | J_1BSPCSTO | J_1BSPCSTO |
INCLTX | Value and price including ICMS/ISS | J_1BINCLTX | XFELD |
STATIT | Indicator: Statistical item | J_1BSTATIT | XFELD |
WERKS | Plant | WERKS_D | WERKS |
DIRECT | Direction of the movement | J_1BDIRECT | J_1BDIRECT |
DSTCAT | Destination category | J_1BDSTCAT | J_1BDSTCAT |
INDUS2 | Business Place CFOP Category | J_1BINDUS2 | J_1BINDUS2 |
NFPRI | Net Price Including Tax | J_1BNFPRI | J_1BNFPRI |
NFNET | Net Value including taxes | J_1BNFNET | WERTV8 |
NFDIS | Discount value including taxes | J_1BNFDIS | WERTV8 |
NFFRE | Freight value including taxes | J_1BNFFRE | WERTV8 |
NFINS | Insurance value including taxes | J_1BNFINS | WERTV8 |
NFOTH | Expenses including taxes | J_1BNFOTH | WERTV8 |
NETWRT | Net value/Freight/Insurance/Expenses/Discount | J_1BNFNETT | WERTV8 |
NFNETT | Net value/Freight/Insurance/Expenses/Discount | J_1BNFNETT | WERTV8 |
MWSKZ | Tax on sales/purchases code | MWSKZ | MWSKZ |
KALSM | Procedure (Pricing, Output Control, Acct. Det., Costing,...) | KALSM_D | KALSM |
ICMSAVR | Average ICMS on Stock Transfers | J_1BICMSAVR | J_1BTAXVAL |
SUBTAVR | Average Substituição Tributária on Stock Transfers | J_1BSUBTAVR | J_1BTAXVAL |
LPPNET | Last Purchase Price (Net) | J_1BLPPNET | WERTV8 |
LPPBRT | Last Purchase Price (Gross) | J_1BLPPBRT | WERTV8 |
ICMSVALP | ICMS on Last Purchase Price | J_1BICMSVAL | J_1BTAXVAL |
SUBTVALP | Substituição Tributária on Last Purchase Price | J_1BSUBTVAL | J_1BTAXVAL |
TAXLW3 | Tax law: ISS | J_1BTAXLW3 | J_1BTAXLW3 |
SRVNR | Activity Number | ASNUM | ASNUM |
.INCLUDE | Taxlaws and situation for Pis, Cofins & ISS | ||
TAXSI3 | Tax Situation ISS | J_1BTAXSI3 | J_1BTAXSI3 |
TAXLW4 | COFINS Tax Law | J_1BTAXLW4 | J_1BTAXLW4 |
TAXSI4 | Tax Situation COFINS | J_1BTAXSI4 | J_1BTAXSI4 |
TAXLW5 | PIS Tax Law | J_1BTAXLW5 | J_1BTAXLW5 |
TAXSI5 | Tax Situation PIS | J_1BTAXSI5 | J_1BTAXSI5 |
REFTYP_PREV | Previously linked NF-e - type of source document | J_1BREFTYP_PREV | J_1BREFTYP |
REFKEY_PREV | Previously linked NF-e - key of source document | J_1BREFKEY_PREV | J_1BREFKEY |
REFITM_PREV | Previously linked NF-e - item of source document | J_1BREFITM_PREV | J_1BREFITM |
NBS | Brazilian Nomenclature Services code | J_1BNBS | J_1BNBS |
.INCLUDE | Nota Fiscal Item Additional Fields | ||
CEAN | International Article Number (EAN/UPC) | EAN11 | EAN11 |
XPED | Purchase Order Number | J_1B_PURCH_ORDER_EXT | CHAR15 |
NITEMPED | Purchase Order Item | J_1B_PURCH_ORD_ITEM_EXT | CHAR6 |
MODBC | ICMS Tax Base Determination Modality | J_1B_ICMS_BASE_DET | J_1B_ICMS_BASE_DET |
MODBCST | ICMS Sub Trib Tax Base Determination Modality | J_1B_ICST_BASE_DET | J_1B_ICST_BASE_DET |
MOTDESICMS | ICMS Exemption Reason | J_1B_ICMS_EXEM_REASON | J_1B_ICMS_EXEM_REASON |
CLENQ | IPI Classification for Tobacco Products and Beverages | J_1B_IPI_CLASS_TBC_BEV | CHAR5 |
CSELO | IPI Control Seal Code | J_1B_IPI_CONTR_SEAL_CODE | CHAR10 |
QSELO | IPI Quantity of Control Seal | J_1B_IPI_CONTR_SEAL_QUAN | DEC12 |
CENQ | IPI Legal Classification Code | J_1B_IPI_LEGAL_CLASS_CODE | CHAR3 |
NUM_ITEM | External Item Number | J_1B_EXT_ITEM_NUM | NUMC3 |
IND_MOV | Physical Movement of Materials | J_1B_PHYS_MOVE_MAT | J_1B_PHYS_MOVE_MAT |
COD_CTA | G/L Account Number for Revenue/Expenses | J_1B_GL_ACCOUNT | SAKNR |
VTOTTRIB | Approximate Total Tax Amount | J_1BNF_VTOTTRIB | WERTV8 |
NFCI | FCI Number | J_1BNFE_NFCI | |
.INCLUDE | Nota fiscal writer cost information of posting | ||
KOSTL | Cost Center | J_1BKOSTL | KOSTL |
AUFNR | Order Number | J_1BAUFNR | AUFNR |
PRCTR | Profit Centers | J_1BPRCTR | PRCTR |
PS_PSP_PNR | Work Breakdown Structure Element (WBS Element) | PS_PSP_PNR | PS_POSNR |
KSTRG | Cost Objects | J_1BKSTRG | KSTRG |
NPLNR | Network Number for Account Assignment | J_1BNPLNR | AUFNR |
SEGMENT | Segment for Segmental Reporting | FB_SEGMENT | FB_SEGMENT |
J_1BNFLIN related tables
Table | Note |
---|---|
J_1BNFLIN | Nota Fiscal line items |
B120 | Condition tables for Output Nota Fiscal |
BBP_NF | Nota Fiscal Types |
BBP_NFT | Nota Fiscal Type Description |
CDBC_NF_VALMAP | Assignment Nota Fiscal Values to Princing Condition Types |
CIAP_D_NF | CIAP Nota Fiscal/Record relationship |
COMC_NFITMTYP | Entity table for Nota Fiscal Item types |
COMC_NFITMTYPT | Text table table for Nota Fiscal Item types |
COMC_NF_TAXMAP | Assignment Nota Fiscal Tax Types to pricing condition types |
COMC_NF_VALMAP | Assignment Nota Fiscal Values to Princing Condition Types |
COMC_TAXTYP_BR | Entity Table for Nota Fiscal Tax Type |
COMC_TAXTYP_BRT | Nota Fiscal Tax Type: Texts |
COMC_TTE_NFMAP | Assignment TTE Tax Type to Nota Fiscal Tax Type |
CRM_NF_ITEM_TYPE | Nota Fiscal Record Types |
CRM_NF_ITEM_TYPT | Description of Nota Fiscal Record Types |
Latest Table Searches
Sap handling unit packaging material table in SAPHow to open handling unit table in SAP
What is the use of handling unit table in SAP
Configuration of handling unit table in SAP
How to print preview handling unit output table in SAP
Handling unit in outbound delivery sap table in SAP
Sap display handling unit output table in SAP
Popular Table Searches
Hdfc bank ltd company code for zinghr table in SAPLink between sales order and production order f table in SAP
Teleperformance company code for zinghr table in SAP
Users list snc table in SAP
Business partner table in SAP
Country codes table in SAP
Shipping point table in SAP