SAP StackSAP FICOSAP HRSAP MMSAP SDSAP PMSAP PSSAP ABAPSAP NetWeaverSAP TablesSAP Tcodes ☰MENU

J_1BNFLIN Table in SAP | Nota Fiscal line items Table & Fields List

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
J_1BNFLIN table in SAP

Here is some free PDF files that you can download free for your reference.
Download Now

Search For SAP Tables

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

FieldNoteData ElementDomain
MANDTClientMANDTMANDT
DOCNUMDocument NumberJ_1BDOCNUMJ_1BDOCNUM
ITMNUMDocument Item NumberJ_1BITMNUMJ_1BITMNUM
MATNRMaterial NumberMATNRMATNR
BWKEYValuation areaBWKEYBWKEY
BWTARValuation typeBWTAR_DBWTAR
CHARGBatch NumberCHARG_DCHARG
MATKLMaterial GroupMATKLMATKL
MAKTXMaterial descriptionMAKTXTEXT40
DOCREFReference to NFJ_1BDOCREFJ_1BDOCNUM
ITMREFReference to item number (Return)J_1BITMREFJ_1BITMNUM
CFOPCFOP code and extensionJ_1BCFOPJ_1BCFOP
NBMControl code for consumption taxes in foreign tradeSTEUCSTEUC
MATORGOrigin of the materialJ_1BMATORGJ_1BMATORG
TAXSITTax situation ICMSJ_1BTAXSITJ_1BTAXSIT
TAXSI2Tax situation IPIJ_1BTAXSI2J_1BTAXSI2
OWNPROProduced in-houseJ_1BOWNPROXFELD
MATUSEUsage of the materialJ_1BMATUSEJ_1BMATUSE
REFTYPReference typeJ_1BREFTYPJ_1BREFTYP
REFKEYReference to source documentJ_1BREFKEYJ_1BREFKEY
REFITMReference item to source documentJ_1BREFITMJ_1BREFITM
MENGEQuantityJ_1BNETQTYMENG13
MEINSBase unit of measureJ_1BNETUNTMEINS
NETPRNet priceJ_1BNETPRIJ_1BNFPRI
NETWRNet ValueJ_1BNETVALWERTV8
TAXLW1Tax law: ICMSJ_1BTAXLW1J_1BTAXLW1
TAXLW2Tax law: IPIJ_1BTAXLW2J_1BTAXLW2
TMISSService tax - no ICMS/IPI calculationJ_1BTMISSXFELD
NETFRENet freight value in document currencyJ_1BNETFREWERTV8
NETINSNet insurance value in document currencyJ_1BNETINSWERTV8
NETOTHNet expenses in document currencyJ_1BNETOTHWERTV8
INDUS3Material CFOP categoryJ_1BINDUS3J_1BINDUS3
ITMTYPNota Fiscal Item TypeJ_1BITMTYPJ_1BITMTYP
NETDISNet discount value in document currencyJ_1BNETDISWERTV8
SPCSTONota Fiscal Special Case for CFOP DeterminationJ_1BSPCSTOJ_1BSPCSTO
INCLTXValue and price including ICMS/ISSJ_1BINCLTXXFELD
STATITIndicator: Statistical itemJ_1BSTATITXFELD
WERKSPlantWERKS_DWERKS
DIRECTDirection of the movementJ_1BDIRECTJ_1BDIRECT
DSTCATDestination categoryJ_1BDSTCATJ_1BDSTCAT
INDUS2Business Place CFOP CategoryJ_1BINDUS2J_1BINDUS2
NFPRINet Price Including TaxJ_1BNFPRIJ_1BNFPRI
NFNETNet Value including taxesJ_1BNFNETWERTV8
NFDISDiscount value including taxesJ_1BNFDISWERTV8
NFFREFreight value including taxesJ_1BNFFREWERTV8
NFINSInsurance value including taxesJ_1BNFINSWERTV8
NFOTHExpenses including taxesJ_1BNFOTHWERTV8
NETWRTNet value/Freight/Insurance/Expenses/DiscountJ_1BNFNETTWERTV8
NFNETTNet value/Freight/Insurance/Expenses/DiscountJ_1BNFNETTWERTV8
MWSKZTax on sales/purchases codeMWSKZMWSKZ
KALSMProcedure (Pricing, Output Control, Acct. Det., Costing,...)KALSM_DKALSM
ICMSAVRAverage ICMS on Stock TransfersJ_1BICMSAVRJ_1BTAXVAL
SUBTAVRAverage Substituição Tributária on Stock TransfersJ_1BSUBTAVRJ_1BTAXVAL
LPPNETLast Purchase Price (Net)J_1BLPPNETWERTV8
LPPBRTLast Purchase Price (Gross)J_1BLPPBRTWERTV8
ICMSVALPICMS on Last Purchase PriceJ_1BICMSVALJ_1BTAXVAL
SUBTVALPSubstituição Tributária on Last Purchase PriceJ_1BSUBTVALJ_1BTAXVAL
TAXLW3Tax law: ISSJ_1BTAXLW3J_1BTAXLW3
SRVNRActivity NumberASNUMASNUM
.INCLUDETaxlaws and situation for Pis, Cofins & ISS    
TAXSI3Tax Situation ISSJ_1BTAXSI3J_1BTAXSI3
TAXLW4COFINS Tax LawJ_1BTAXLW4J_1BTAXLW4
TAXSI4Tax Situation COFINSJ_1BTAXSI4J_1BTAXSI4
TAXLW5PIS Tax LawJ_1BTAXLW5J_1BTAXLW5
TAXSI5Tax Situation PISJ_1BTAXSI5J_1BTAXSI5
REFTYP_PREVPreviously linked NF-e - type of source documentJ_1BREFTYP_PREVJ_1BREFTYP
REFKEY_PREVPreviously linked NF-e - key of source documentJ_1BREFKEY_PREVJ_1BREFKEY
REFITM_PREVPreviously linked NF-e - item of source documentJ_1BREFITM_PREVJ_1BREFITM
NBSBrazilian Nomenclature Services codeJ_1BNBSJ_1BNBS
.INCLUDENota Fiscal Item Additional Fields    
CEANInternational Article Number (EAN/UPC)EAN11EAN11
XPEDPurchase Order NumberJ_1B_PURCH_ORDER_EXTCHAR15
NITEMPEDPurchase Order ItemJ_1B_PURCH_ORD_ITEM_EXTCHAR6
MODBCICMS Tax Base Determination ModalityJ_1B_ICMS_BASE_DETJ_1B_ICMS_BASE_DET
MODBCSTICMS Sub Trib Tax Base Determination ModalityJ_1B_ICST_BASE_DETJ_1B_ICST_BASE_DET
MOTDESICMSICMS Exemption ReasonJ_1B_ICMS_EXEM_REASONJ_1B_ICMS_EXEM_REASON
CLENQIPI Classification for Tobacco Products and BeveragesJ_1B_IPI_CLASS_TBC_BEVCHAR5
CSELOIPI Control Seal CodeJ_1B_IPI_CONTR_SEAL_CODECHAR10
QSELOIPI Quantity of Control SealJ_1B_IPI_CONTR_SEAL_QUANDEC12
CENQIPI Legal Classification CodeJ_1B_IPI_LEGAL_CLASS_CODECHAR3
NUM_ITEMExternal Item NumberJ_1B_EXT_ITEM_NUMNUMC3
IND_MOVPhysical Movement of MaterialsJ_1B_PHYS_MOVE_MATJ_1B_PHYS_MOVE_MAT
COD_CTAG/L Account Number for Revenue/ExpensesJ_1B_GL_ACCOUNTSAKNR
VTOTTRIBApproximate Total Tax AmountJ_1BNF_VTOTTRIBWERTV8
NFCIFCI NumberJ_1BNFE_NFCI  
.INCLUDENota fiscal writer cost information of posting    
KOSTLCost CenterJ_1BKOSTLKOSTL
AUFNROrder NumberJ_1BAUFNRAUFNR
PRCTRProfit CentersJ_1BPRCTRPRCTR
PS_PSP_PNRWork Breakdown Structure Element (WBS Element)PS_PSP_PNRPS_POSNR
KSTRGCost ObjectsJ_1BKSTRGKSTRG
NPLNRNetwork Number for Account AssignmentJ_1BNPLNRAUFNR
SEGMENTSegment for Segmental ReportingFB_SEGMENTFB_SEGMENT

J_1BNFLIN related tables

TableNote
J_1BNFLINNota Fiscal line items
B120Condition tables for Output Nota Fiscal
BBP_NFNota Fiscal Types
BBP_NFTNota Fiscal Type Description
CDBC_NF_VALMAPAssignment Nota Fiscal Values to Princing Condition Types
CIAP_D_NFCIAP Nota Fiscal/Record relationship
COMC_NFITMTYPEntity table for Nota Fiscal Item types
COMC_NFITMTYPTText table table for Nota Fiscal Item types
COMC_NF_TAXMAPAssignment Nota Fiscal Tax Types to pricing condition types
COMC_NF_VALMAPAssignment Nota Fiscal Values to Princing Condition Types
COMC_TAXTYP_BREntity Table for Nota Fiscal Tax Type
COMC_TAXTYP_BRTNota Fiscal Tax Type: Texts
COMC_TTE_NFMAPAssignment TTE Tax Type to Nota Fiscal Tax Type
CRM_NF_ITEM_TYPENota Fiscal Record Types
CRM_NF_ITEM_TYPTDescription of Nota Fiscal Record Types
SAP ALECRMSCMSRMSAP SolutionsSAP ReferencesSAP BasicsPP ModuleWMSAP Partners
HomeContact & Privacy PolicyTwitter
All of the product names here are trademarks of their respective companies. The site sapstack.com is not affiliated with SAP AG.
©2024 sapstack.com