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

SAP J_1BNFLIN (Nota Fiscal line items) Table & Fields

J_1BNFLIN is a SAP table coming under CRM module and BBPCRM component.View details, Fields & related tables of J_1BNFLIN.

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
A291Land/SteuKennz.
A292BR: ISS from SD: Ship-to-City
A293Land/StKla2-Kd
A341Land/StKla3-Kd
A342Land/StKla2-Mat
A343BR: Substituiçao Tributária from SD
A344BR: ICMS base reduction carrier: Land/St. Basis/Belegart
A346Land/Dyn.Schlüssel1/Dyn.Schlüssel2/Dyn.Schlüssel3/St.-Grp.
A347Land/SF/ST/Schlüssel1/Schlüssel2/Schlüssel3/St.-Grp.
A348Land/SF/ST/XSUBT/Schlüssel1/Schlüssel2/Schlüssel3/St.-Grp.
A349Land/ST/MATNR
A374Country/Sales org./Region/PlntRegion/TaxCl3Cust/TaxCl.3Mat
A382Land/Belegart/SF/ST/Schlüssel1/Schlüssel2/Schlüssel3/St.-Grp
A392Land
A393Land/Lieferant
A394Land/Empfänger
FIAPBRD_ISPBBrazil: Febraban Bank Identification at SPB (ISPB code)
IDSDTXNUMVISSD Document Screen Control for CPD Partner Tax Numbers
J1B_ERROR_DDAMaster Table for DDA_Brazil (Segment G)
J_1BAANota Fiscal type
Do you know this 11 Advantages of SAP Software?
Read Now
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.
©2021 sapstack.com