1. Home
  2. Resources
  3. SAP Tables
  4. IDNFBRJ_1BNFLIN - Change Document Structure; Generated by RSSCD000

SAP Table IDNFBRJ_1BNFLIN

Change Document Structure; Generated by RSSCD000

IDNFBRJ_1BNFLIN (Change Document Structure; Generated by RSSCD000) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link IDNFBRJ_1BNFLIN to other SAP tables.

IDNFBRJ_1BNFLIN table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
DOCNUM Document Number J_1BDOCNUM J_1BNFDOC NUMC 10 0
ITMNUM Document Item Number J_1BITMNUM NUMC 6 0
MATNR Material Number MATNR MARA CHAR 18 0
BWKEY Valuation Area BWKEY T001K CHAR 4 0
BWTAR Valuation Type BWTAR_D MBEW CHAR 10 0
CHARG Batch Number CHARG_D MCH1 CHAR 10 0
MATKL Material Group MATKL T023 CHAR 9 0
MAKTX Material Description (Short Text) MAKTX CHAR 40 0
DOCREF Reference to NF J_1BDOCREF J_1BNFDOC NUMC 10 0
ITMREF Reference to item number (Return) J_1BITMREF NUMC 6 0
CFOP CFOP Code and Extension J_1BCFOP J_1BAG CHAR 10 0
NBM Control code for consumption taxes in foreign trade STEUC T604F CHAR 16 0
MATORG Origin of the material J_1BMATORG CHAR 1 0
1 Foreign - imported directly
2 Foreign - acquired nationally
0 National - except indicated for codes 3, 4, 5 or 8
3 National - with import content over 40% and below/equal 70%
4 National - production with tax incentive
5 National - with import content less than or equal to 40%
6 Foreign - imp direct,no similar nat.,Res.CAMEX & nat.gas
7 Foreign - acquired nat.,no similar nat.,Res.CAMEX & nat.gas
8 National - with import content over 70%
TAXSIT Tax situation ICMS J_1BTAXSIT CHAR 1 0
0 Liable to ICMS
1 Liable to ICMS + substitui��o tribut�ria
2 Liable to ICMS (reduced tax base)
3 Exempt or nontaxable + substitui��o tribut�ria
4 Exempt
A Nontaxable
5 Suspended
B Deferred
6 ICMS already levied by substitui��o tribut�ria
7 Liable to ICMS (reduced tax base) + substitui��o tribut�ria
9 Other
TAXSI2 Tax situation IPI J_1BTAXSI2 J_1BAS NUMC 5 0
OWNPRO Produced in-house J_1BOWNPRO CHAR 1 0
X Yes
NULL No
MATUSE Usage of the material J_1BMATUSE CHAR 1 0
0 Resale
1 Industrialisation
2 Consumption
3 Asset
REFTYP Reference type J_1BREFTYP J_1BAB CHAR 2 0
REFKEY Reference to source document J_1BREFKEY CHAR 35 0
REFITM Reference item to source document J_1BREFITM NUMC 6 0
MENGE Quantity J_1BNETQTY QUAN 13 3
MEINS Base unit of measure J_1BNETUNT T006 UNIT 3 0
NETPR Net price J_1BNETPRI DEC 16 6
NETWR Net Value J_1BNETVAL CURR 15 2
TAXLW1 Tax law: ICMS J_1BTAXLW1 J_1BATL1 CHAR 3 0
TAXLW2 Tax law: IPI J_1BTAXLW2 J_1BATL2 CHAR 3 0
TMISS Service tax - no ICMS/IPI calculation J_1BTMISS CHAR 1 0
X Yes
NULL No
NETFRE Net freight value in document currency J_1BNETFRE CURR 15 2
NETINS Net insurance value in document currency J_1BNETINS CURR 15 2
NETOTH Net expenses in document currency J_1BNETOTH CURR 15 2
INDUS3 Material CFOP category J_1BINDUS3 CHAR 2 0
00 material
01 electricity
02 communication
03 transportation
04 animal
ITMTYP Nota Fiscal Item Type J_1BITMTYP J_1BITEMTYPES CHAR 2 0
NETDIS Net discount value in document currency J_1BNETDIS CURR 15 2
SPCSTO Nota Fiscal Special Case for CFOP Determination J_1BSPCSTO CHAR 2 0
NULL CFOP Determination Without Substituicao Tributaria
01 CFOP Determination with Substituicao Tributaria
02 CFOP for Services That Are Subject to ISS Tax
50 Use as Required
60 Use as Required
70 Use as Required
80 Use as Required
90 Use as Required
INCLTX Value and price including ICMS/ISS J_1BINCLTX CHAR 1 0
X Yes
NULL No
STATIT Indicator: Statistical item J_1BSTATIT CHAR 1 0
X Yes
NULL No
WERKS Plant WERKS_D T001W CHAR 4 0
DIRECT Direction of the movement J_1BDIRECT CHAR 1 0
1 Incoming
2 Outgoing
3 Outgoing Returns of Stock Transfers
4 Incoming Returns of Stock Transfers
DSTCAT Destination category J_1BDSTCAT CHAR 1 0
0 Same state
1 Different state
2 Different country
3 Same state - Free Trade Zone
4 Different state - Free Trade Zone
INDUS2 Business Place CFOP Category J_1BINDUS2 CHAR 2 0
00 industry (cooperative)
01 electric co.
02 communication co.
03 transport co.
04 service co.
05 consumer industry (cooperative)
06 rural
NFPRI Net Price Including Tax J_1BNFPRI DEC 16 6
NFNET Net Value including taxes J_1BNFNET CURR 15 2
NFDIS Discount value including taxes J_1BNFDIS CURR 15 2
NFFRE Freight value including taxes J_1BNFFRE CURR 15 2
NFINS Insurance value including taxes J_1BNFINS CURR 15 2
NFOTH Expenses including taxes J_1BNFOTH CURR 15 2
NETWRT Net value/Freight/Insurance/Expenses/Discount J_1BNFNETT CURR 15 2
NFNETT Net value/Freight/Insurance/Expenses/Discount J_1BNFNETT CURR 15 2
MWSKZ Tax on sales/purchases code MWSKZ CHAR 2 0
KALSM Procedure (Pricing, Output Control, Acct. Det., Costing,...) KALSM_D CHAR 6 0
ICMSAVR Average ICMS on Stock Transfers J_1BICMSAVR CURR 15 2
SUBTAVR Average Substitui��o Tribut�ria on Stock Transfers J_1BSUBTAVR CURR 15 2
LPPNET Last Purchase Price (Net) J_1BLPPNET CURR 15 2
LPPBRT Last Purchase Price (Gross) J_1BLPPBRT CURR 15 2
ICMSVALP ICMS on Last Purchase Price J_1BICMSVAL CURR 15 2
SUBTVALP Substitui��o Tribut�ria on Last Purchase Price J_1BSUBTVAL CURR 15 2
TAXLW3 ISS Tax Law J_1BTAXLW3 J_1BATL3 CHAR 3 0
SRVNR Activity Number ASNUM ASMD CHAR 18 0
TAXSI3 Tax Situation ISS J_1BTAXSI3 CHAR 2 0
TAXLW4 COFINS Tax Law J_1BTAXLW4 J_1BATL4A CHAR 3 0
TAXSI4 Tax Situation COFINS J_1BTAXSI4 CHAR 2 0
TAXLW5 PIS Tax Law J_1BTAXLW5 J_1BATL5 CHAR 3 0
TAXSI5 Tax Situation PIS J_1BTAXSI5 CHAR 2 0
REFTYP_PREV Previously linked NF-e - type of source document J_1BREFTYP_PREV CHAR 2 0
REFKEY_PREV Previously linked NF-e - key of source document J_1BREFKEY_PREV CHAR 35 0
REFITM_PREV Previously linked NF-e - item of source document J_1BREFITM_PREV NUMC 6 0
NBS Brazilian Nomenclature Services code J_1BNBS CHAR 20 0
CEAN International Article Number (EAN/UPC) EAN11 CHAR 18 0
XPED Purchase Order Number J_1B_PURCH_ORDER_EXT CHAR 15 0
NITEMPED Purchase Order Item J_1B_PURCH_ORD_ITEM_EXT CHAR 6 0
MODBC ICMS Tax Base Determination Modality J_1B_ICMS_BASE_DET CHAR 1 0
0 Added Value Margin (%)
1 Pauta (Value)
2 Maximum Tabled Price (Value)
3 Operation Value
MODBCST ICMS Sub Trib Tax Base Determination Modality J_1B_ICST_BASE_DET CHAR 1 0
0 Tabled Price or Suggested Maximum
1 Negative List (Value)
2 Positive List (Value)
3 Neutra List (Value)
4 Added Value Margin (%)
5 Pauta (Value)
MOTDESICMS ICMS Exemption Reason J_1B_ICMS_EXEM_REASON CHAR 1 0
1 Taxi
2 Physically Handicapped
3 Agricultural Producer
4 Fleet Owner/Rental
5 Diplomatic/Consular
6 SUVs and Motorcycles in the West Amazon and Free Comm. Zone
7 SUFRAMA
9 Others
CLENQ IPI Classification for Tobacco Products and Beverages J_1B_IPI_CLASS_TBC_BEV CHAR 5 0
CSELO IPI Control Seal Code J_1B_IPI_CONTR_SEAL_CODE CHAR 10 0
QSELO IPI Quantity of Control Seal J_1B_IPI_CONTR_SEAL_QUAN DEC 12 0
CENQ IPI Legal Classification Code J_1B_IPI_LEGAL_CLASS_CODE CHAR 3 0
NUM_ITEM External Item Number J_1B_EXT_ITEM_NUM NUMC 3 0
IND_MOV Physical Movement of Materials J_1B_PHYS_MOVE_MAT CHAR 1 0
0 Yes
1 No
COD_CTA G/L Account Number for Revenue/Expenses J_1B_GL_ACCOUNT CHAR 10 0
VTOTTRIB Approximate Total Tax Amount J_1BNF_VTOTTRIB CURR 15 2
NFCI FCI Control Number J_1BNFE_NFCI CHAR 36 0
KOSTL Cost Center J_1BKOSTL CHAR 10 0
AUFNR Order Number J_1BAUFNR CHAR 12 0
PRCTR Profit Centers J_1BPRCTR CHAR 10 0
PS_PSP_PNR Work Breakdown Structure Element (WBS Element) PS_PSP_PNR NUMC 8 0
KSTRG Cost Objects J_1BKSTRG CHAR 12 0
NPLNR Network Number for Account Assignment J_1BNPLNR CHAR 12 0
SEGMENT Segment for Segmental Reporting FB_SEGMENT CHAR 10 0
OIH_J1B_TAXVAL Tax value to be printed in add.field NF (Tax Brazil) OIH_J1B_TAXVAL CURR 15 2
OIH_J1B_TAXBASE Tax base to be printed in add.field NF (Tax Brazil) OIH_J1B_TAXBASE CURR 15 2
TRAN_TYPE Transaction type (sales, purchase, transf. in, transf. out) OIH_J1B_TRTYPE CHAR 2 0
SA Sales
PU Purchase
TO Transfer Outgoing
TI Transfer Incoming
GF GR consignment
GC GR future delivery
INT_OP Inter / intra operation type OIH_J1B_INT CHAR 1 0
1 Intrastate
2 Interstate
3 Export
CUSTYPE Customer type (end c./reseller/industry) OIH_J1B_CTYP CHAR 1 0
I Industry
R Reseller
E End customer
N N�o contribuinte
OIHCTXGR Customer tax group OIH_J1B_CTXGR CHAR 4 0
VEND_COD Vendor type (refinery/mill/other) (Brazil) OIH_J1B_VTYP CHAR 1 0
M Mill (for alcohol)
R Refinery only
O Other
NULL Distributor only
X Refinery and Distributor
OIHVTXGR Vendor group (refinery/mill/other) OIH_J1B_VTXGR CHAR 4 0
MAT_TAX_GR Material tax group OIH_J1B_MTXGR CHAR 4 0
TAXATION_ORIG Taxation at origin OIH_J1B_TAX_ORIG CHAR 1 0
X Yes
NULL No
TAXATION_DEST Taxation at destination OIH_J1B_TAX_DEST CHAR 1 0
X Yes
NULL No
OIHCV03 Convenio 03 OIH_CONV_03 CHAR 1 0
X Yes
NULL No
OIHCV80O Convenio 80 at origin OIH_CONV_80O CHAR 1 0
X Yes
NULL No
OIHCV80D Convenio 80 at destin. OIH_CONV_80D CHAR 1 0
X Yes
NULL No
PRICE_CONTROL Price controlled OIH_J1B_PR_CNTRL CHAR 1 0
X Yes
NULL No
TAX_CODE Tax on sales/purchases code MWSKZ CHAR 2 0
SUBTR_TYPE Type of sub. trib. (in-coming or backwards) OIH_SUBTR_TYPE CHAR 1 0
I Incoming
B Backwards
P Protocolo 19 (special backward, no posting)
N Protocolo 19 with postings
PRINT_ICMS Indicator where to print ICMS OIH_J1B_IPRINT CHAR 1 0
NULL Print tax in own field and post to tax account
A Print tax in additional field, do not post tax
X Print tax in additional field and post to tax acc.
B Print ONLY ICMS in add.field, does not affect other taxes
C Print tax in add.field and add to price
STPR_INTRA Sub.Trib. surcharge percentage rate intrastate OIH_J1BSTPR_INTRA DEC 6 2
STPR_INTER Sub.Trib. surcharge percentage rate interstate =gross margin OIH_J1BSTPR_INTER DEC 6 2
FACTOR1 Reduction factor alc.taxation OIH_J1B_REDFAC DEC 6 2
0
FACTOR2 Reduction factor alc.taxation OIH_J1B_REDFAC DEC 6 2
0
CREDIT_IPI IPI credit allowed OIH_J1B_TXCREDIP CHAR 1 0
X Yes
. No
NULL No
CREDIT_ICMS ICMS credit allowed (Brazil taxes) OIH_J1B_TXCREDIC CHAR 1 0
X Yes
NULL No
TAXTYPE Incoming taxation type (Brazil) OIH_J1B_TXITYP CHAR 1 0
I Incoming sub.trib.
B Backward sub.trib.
E Exception: ICMS deferred (no tax is calculated)
T Incoming sub.trib. on transfer
P Backward sub. trib. with Protocolo 19 (no posting)
N Protocolo 19 with postings
PERCENT Percentage of backward sub.trib. collected OIH_J1B_BCKRATE DEC 6 2
0
MIXPROD Product to be mixed with OIH_J1B_MATNR CHAR 18 0
FACPIS Factor for PIS ST calculation OIH_J1B_FACPIS DEC 6 2
FACCOF Factor for COFINS ST calculation OIH_J1B_FACCOF DEC 6 2
FORMULA Formula type for PIS/COFINS ST calculation OIH_J1B_PIS_FORM CHAR 1 0
A Formula A (NO calculation - exception)
B Formula B (value = item-value * factor * rate)
C Formula C (value = item-value * alc-mix * factor * rate)
D Formula D (value = item-value * alc-mix * factor * rate)
E Formula E (value = item-qty * 1-acq-px * alc-mix * fac * rt)
F Formula F (value = item-qty * acq-price * factor * rate)
G Formula G (value = item-qty * acq-price * factor * rate)
H Formula H like G
PRINT_IND Indicator for PIS/COFINS ST printing exceptions OIH_J1B_IPRINT_PIS CHAR 1 0
NULL Print tax in own field and post to tax account
A Print tax in additional field, do not post tax
X Print tax in additional field and post to tax acc.
B Print ONLY ICMS in add.field, does not affect other taxes
C Print tax in add.field and add to price
OS_TXLW1 Tax law: ICMS J_1BTAXLW1 CHAR 3 0
OS_TXLW2 Tax law: IPI J_1BTAXLW2 CHAR 3 0
TXLW4 Tax law: PIS/COFINS OIH_J1B_TAXLW4 CHAR 3 0
ZONA_FRANCA Flag indicating whether operation involves Zona Franca OIH_J1B_ZFR CHAR 1 0
X Yes
NULL No
OIHVTYPE Vendor type (refinery/mill/other) (Brazil) OIH_J1B_VTYP CHAR 1 0
M Mill (for alcohol)
R Refinery only
O Other
NULL Distributor only
X Refinery and Distributor
OIHNOCON Product with no contrib.(law 87) OIH_NO_CONTRIB CHAR 1 0
X Yes
NULL No
OIHREFST Brazil: Refinery ST applied to end customer OIH_REFST_END CHAR 1 0
NULL Entry not selected / not active / function switched off
X Intra sales to Non-reseller will be handled like reseller
1 Imported products with ST Refinery at customs clearance
LEG_CLAIM Indicator: customer is legal claimant for this case OIH_J1B_ICREF CHAR 1 0
X Yes
NULL No
NO_LBOOK Don't bring tax amount as tax credit to legal book OIH_J1B_NLBOOK CHAR 1 0
X Yes
NULL No
PUR_NOTAX Indicator: for this oper. no tax paid when purchasing OIH_J1B_PURNOTAX CHAR 1 0
X Yes
NULL No
PISCOF_EXC PIS/COFINS exception for reading OIH_J1B_PIS OIH_J1B_PICO_EXC CHAR 1 0
X Yes
NULL No
PMPF_USED_ORIGIN PMPF used indicator OIH_J1B_PMPF_USED CHAR 1 0
X Yes
NULL No
PMPF_USED_DESTIN PMPF used indicator OIH_J1B_PMPF_USED CHAR 1 0
X Yes
NULL No
OIHSURCHARGE Lubricants Sales � MVA Excluded OIH_J1B_SURCHARGE CHAR 1 0
X Yes
NULL No
DUMMY Dummy function in length 1 DUMMY CHAR 1 0
KZ Change Type (U, I, S, D) CDCHNGIND CHAR 1 0
U Update
I Insert
E Delete (Single Field Documentation)
D Delete
J Insert (Single Field Documentation)

IDNFBRJ_1BNFLIN foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
IDNFBRJ_1BNFLIN BWKEY IDNFBRJ_1BNFLIN BWKEY T001K Valuation area BWKEY
IDNFBRJ_1BNFLIN BWKEY IDNFBRJ_1BNFLIN MANDT T001K Valuation area MANDT
IDNFBRJ_1BNFLIN BWTAR IDNFBRJ_1BNFLIN BWTAR MBEW Material Valuation BWTAR
IDNFBRJ_1BNFLIN BWTAR IDNFBRJ_1BNFLIN MANDT MBEW Material Valuation MANDT
IDNFBRJ_1BNFLIN BWTAR IDNFBRJ_1BNFLIN MATNR MBEW Material Valuation MATNR
IDNFBRJ_1BNFLIN BWTAR IDNFBRJ_1BNFLIN WERKS MBEW Material Valuation BWKEY
IDNFBRJ_1BNFLIN CFOP IDNFBRJ_1BNFLIN MANDT J_1BAG CFOP MANDT
IDNFBRJ_1BNFLIN CFOP IDNFBRJ_1BNFLIN CFOP J_1BAG CFOP CFOP
IDNFBRJ_1BNFLIN CHARG IDNFBRJ_1BNFLIN MANDT MCH1 Batches (if Batch Management Cross-Plant) MANDT
IDNFBRJ_1BNFLIN CHARG IDNFBRJ_1BNFLIN MATNR MCH1 Batches (if Batch Management Cross-Plant) MATNR
IDNFBRJ_1BNFLIN CHARG IDNFBRJ_1BNFLIN CHARG MCH1 Batches (if Batch Management Cross-Plant) CHARG
IDNFBRJ_1BNFLIN DOCNUM IDNFBRJ_1BNFLIN MANDT J_1BNFDOC Nota Fiscal Header MANDT
IDNFBRJ_1BNFLIN DOCNUM IDNFBRJ_1BNFLIN DOCNUM J_1BNFDOC Nota Fiscal Header DOCNUM
IDNFBRJ_1BNFLIN DOCREF IDNFBRJ_1BNFLIN MANDT J_1BNFDOC Nota Fiscal Header MANDT
IDNFBRJ_1BNFLIN DOCREF IDNFBRJ_1BNFLIN DOCREF J_1BNFDOC Nota Fiscal Header DOCNUM
IDNFBRJ_1BNFLIN ITMTYP IDNFBRJ_1BNFLIN ITMTYP J_1BITEMTYPES Nota Fiscal Record Types ITMTYP
IDNFBRJ_1BNFLIN ITMTYP IDNFBRJ_1BNFLIN MANDT J_1BITEMTYPES Nota Fiscal Record Types MANDT
IDNFBRJ_1BNFLIN MANDT IDNFBRJ_1BNFLIN MANDT T000 Clients MANDT
IDNFBRJ_1BNFLIN MATKL IDNFBRJ_1BNFLIN MANDT T023 Material Groups MANDT
IDNFBRJ_1BNFLIN MATKL IDNFBRJ_1BNFLIN MATKL T023 Material Groups MATKL
IDNFBRJ_1BNFLIN MATNR IDNFBRJ_1BNFLIN MANDT MARA General Material Data MANDT
IDNFBRJ_1BNFLIN MATNR IDNFBRJ_1BNFLIN MATNR MARA General Material Data MATNR
IDNFBRJ_1BNFLIN MEINS IDNFBRJ_1BNFLIN MANDT T006 Units of Measurement MANDT
IDNFBRJ_1BNFLIN MEINS IDNFBRJ_1BNFLIN MEINS T006 Units of Measurement MSEHI
IDNFBRJ_1BNFLIN NBM IDNFBRJ_1BNFLIN MANDT T604F Import Processing: Control Code MANDT
IDNFBRJ_1BNFLIN NBM 'BR' T604F Import Processing: Control Code LAND1
IDNFBRJ_1BNFLIN NBM IDNFBRJ_1BNFLIN NBM T604F Import Processing: Control Code STEUC
IDNFBRJ_1BNFLIN REFTYP IDNFBRJ_1BNFLIN REFTYP J_1BAB Reference type REFTYP
IDNFBRJ_1BNFLIN SRVNR SYST MANDT ASMD Service Master: Basic Data MANDT
IDNFBRJ_1BNFLIN SRVNR IDNFBRJ_1BNFLIN SRVNR ASMD Service Master: Basic Data ASNUM
IDNFBRJ_1BNFLIN TAXLW1 IDNFBRJ_1BNFLIN MANDT J_1BATL1 Tax Law ICMS MANDT
IDNFBRJ_1BNFLIN TAXLW1 IDNFBRJ_1BNFLIN TAXLW1 J_1BATL1 Tax Law ICMS TAXLAW
IDNFBRJ_1BNFLIN TAXLW2 IDNFBRJ_1BNFLIN MANDT J_1BATL2 Tax Law IPI MANDT
IDNFBRJ_1BNFLIN TAXLW2 IDNFBRJ_1BNFLIN TAXLW2 J_1BATL2 Tax Law IPI TAXLAW
IDNFBRJ_1BNFLIN TAXLW3 IDNFBRJ_1BNFLIN TAXLW3 J_1BATL3 Tax Laws ISS TAXLAW
IDNFBRJ_1BNFLIN TAXLW3 IDNFBRJ_1BNFLIN MANDT J_1BATL3 Tax Laws ISS MANDT
IDNFBRJ_1BNFLIN TAXLW4 SYST MANDT J_1BATL4A Tax Laws COFINS MANDT
IDNFBRJ_1BNFLIN TAXLW4 IDNFBRJ_1BNFLIN TAXLW4 J_1BATL4A Tax Laws COFINS TAXLAW
IDNFBRJ_1BNFLIN TAXLW5 SYST MANDT J_1BATL5 Tax Laws PIS MANDT
IDNFBRJ_1BNFLIN TAXLW5 IDNFBRJ_1BNFLIN TAXLW5 J_1BATL5 Tax Laws PIS TAXLAW
IDNFBRJ_1BNFLIN TAXSI2 IDNFBRJ_1BNFLIN MANDT J_1BAS Tax situation IPI MANDT
IDNFBRJ_1BNFLIN TAXSI2 IDNFBRJ_1BNFLIN TAXSI2 J_1BAS Tax situation IPI TAXSIT
IDNFBRJ_1BNFLIN WERKS IDNFBRJ_1BNFLIN MANDT T001W Plants/Branches MANDT
IDNFBRJ_1BNFLIN WERKS IDNFBRJ_1BNFLIN WERKS T001W Plants/Branches WERKS