SAP S/4Hana table J1B_NF_XML_ITEM_OLD stores Nota Fiscal Eletronica / NF-e Data - Item (1:n)data

  

So we all know that S/4Hana is the latest version and the future of SAP but what about the tables we are familiar with, are they still available and what do tables like J1B_NF_XML_ITEM_OLD look like in an S4Hana SAP system. If you havent seen or logged into an S/4Hana system you might be surprise how similar it looks to the previous ERP/ECC version. Infact when using using the gui it is difficult to tell the difference, and for many of database tables the same is true.

Infact even for tables that have been replaced in hana, SAP have purposfully created versions of the old/original tables for backward compatability. This means your existing ABAP code will still work while you implement changes that take advantage of the new functionality and Hana in-memory tables.


S4 Hana J1B_NF_XML_ITEM_OLD dictionary attributes

Object Name: J1B_NF_XML_ITEM_OLD
Dictionary Type: Structure
Description: Nota Fiscal Eletronica / NF-e Data - Item (1:n)


Field list for J1B_NF_XML_ITEM_OLD table on an S/4 SAP system

Field Data Element Data Type length (Dec) Check table Description Conversion Routine Domain Name MemoryID AppClass SHLP SHLP Field ConvExit
DOCNUMJ_1BDOCNUMNUMC10(0) Document NumberJ_1BDOCNUMJEF
ITMNUMJ_1BITMNUMNUMC6(0) Document Item NumberJ_1BITMNUMJ_1BITMNUM
NITEMNUMC3(0) Number of items
CPRODMATNR18CHAR18(0) Material Number (18 Characters)MATNR18MG
CEANEAN11CHAR18(0) International Article Number (EAN/UPC)EAN11EANMGW
XPRODCHAR120(0) Material Text
NCMSTEUCCHAR16(0) Control code for consumption taxes in foreign tradeSTEUC
EXTIPICHAR3(0) EXTIPI
GENEROCHAR2(0) Firtst 2 digits of NCM code
CFOPJ_1BCFOPCHAR10(0) *CFOP Code and ExtensionJ_1BCFOP
UTRIBMEINSUNIT3(0) *Base Unit of MeasureMEINSMG
UCOMVRKMEUNIT3(0) *Sales unitMEINSV
QTRIBMENGE_DQUAN13(3) QuantityMENG13MG
QCOMLFIMGQUAN13(3) Actual quantity delivered (in sales units)MENG13VL
VPRODJ_1BNFTOTCURR15(2) Total value including all taxesWERTV8
VFRETEJ_1BNFFRECURR15(2) Freight value including taxesWERTV8
VSEGJ_1BNFINSCURR15(2) Insurance value including taxesWERTV8
VDESCJ_1BNFDISCURR15(2) Discount value including taxesWERTV8
VUNCOMDEC15(4) Commercial Unit Value
CEANTRIBCHAR14(0) Global Trade Item Number
VUNTRIBDEC15(4) Taxation Unit Value
NDICHAR10(0) Import declaration number DI/DSI/DA
DDIDATS8(0) Registration date of the DI/DSI/DA
XLOCDESEMBCHAR60(0) Location where goods are released
UFDESEMBCHAR2(0) Region where the goods have been released
DDESEMBDATS8(0) Date when goods have been released
CEXPORTADORCHAR60(0) Code of the Export Company
NADICAONUMC3(0) Number of the addition
NSEQADICNUMC3(0) Sequential number of the item in the addition
CFABRICANTECHAR60(0) Code of the foreign producer in the system
VDESCDICURR15(2) Discount value of the DI item - addition
I_TPOPNUMC1(0) Type of Operation
I_CHASSICHAR17(0) Vehicle Chassis
I_CORCHAR4(0) Code for Each Assembly Plant
I_XCORCHAR40(0) Color Description
I_POTCHAR4(0) Engine Power
I_CM3CHAR4(0) CM3 (Power)
I_PESOLCHAR9(0) Net Weight
I_PESOBCHAR9(0) Gross Weight
I_NSERIECHAR9(0) Serial (série)
I_TPCOMBCHAR8(0) Type of Fuel
I_NMOTORCHAR21(0) Engine Number
I_CMKGCHAR9(0) CMKG
I_DISTCHAR4(0) Distance Between Axles
I_RENAVAMCHAR9(0) RENAVAM
I_ANOMODNUMC4(0) Year of Manufacturing Model
I_ANOFABNUMC4(0) Production Year
I_TPPINTCHAR1(0) Type of Painting
I_TPVEICNUMC2(0) Type of Vehicle
I_ESPVEICCHAR1(0) Sort of Vehicle
I_VINCHAR1(0) Condition of VIN
I_CONDVEICNUMC1(0) Condition of the Vehicle
I_CMODCHAR6(0) Code Brand Model
K_TPARMANUMC1(0) Indicator of Firearm Type
K_NSERIENUMC9(0) Gun Serial number
K_NCANONUMC9(0) Barrel Serial Number
K_DESCRCHAR256(0) Full Description of the Gun
L1_ICMSCHAR1(0) Tag ICMS
L1_00_ORIGJ_1BMATORGCHAR1(0) Origin of the materialJ_1BMATORG
L1_00_CSTNUMC2(0) Tax situation
L1_00_MODBCNUMC1(0) Base Determination rule
L1_00_VBCJ_1BBASECURR15(2) Base amountJ_1BBASE
L1_00_PICMSJ_1BTXRATEDEC6(2) Tax RateJ_1BTXRATE
L1_00_VICMSJ_1BTAXVALCURR15(2) Tax valueJ_1BTAXVAL
L1_10_ORIGJ_1BMATORGCHAR1(0) Origin of the materialJ_1BMATORG
L1_10_CSTNUMC2(0) Tax situation
L1_10_MODBCNUMC1(0) Base Determination rule ICMS
L1_10_VBCJ_1BBASECURR15(2) Base amountJ_1BBASE
L1_10_PICMSJ_1BTXRATEDEC6(2) Tax RateJ_1BTXRATE
L1_10_VICMSJ_1BTAXVALCURR15(2) Tax valueJ_1BTAXVAL
L1_10_MODBCSTNUMC1(0) Base Determination rule ICMSST
L1_10_PMVASTDEC5(2) Surcharge rate
L1_10_PREDBCSTDEC5(2) Base reduction rate
L1_10_VBCSTJ_1BBASECURR15(2) Base amountJ_1BBASE
L1_10_PICMSSTJ_1BTXRATEDEC6(2) Tax RateJ_1BTXRATE
L1_10_VICMSSTJ_1BTAXVALCURR15(2) Tax valueJ_1BTAXVAL
L1_20_ORIGJ_1BMATORGCHAR1(0) Origin of the materialJ_1BMATORG
L1_20_CSTNUMC2(0) Tax situation
L1_20_MODBCNUMC1(0) Base Determination rule
L1_20_PREDBCDEC5(2) Base reduction rate
L1_20_VBCJ_1BBASECURR15(2) Base amountJ_1BBASE
L1_20_PICMSJ_1BTXRATEDEC6(2) Tax RateJ_1BTXRATE
L1_20_VICMSJ_1BTAXVALCURR15(2) Tax valueJ_1BTAXVAL
L1_30_ORIGJ_1BMATORGCHAR1(0) Origin of the materialJ_1BMATORG
L1_30_CSTNUMC2(0) Tax situation
L1_30_MODBCSTNUMC1(0) Base Determination rule
L1_30_PMVASTDEC5(2) Surcharge rate
L1_30_PREDBCSTDEC5(2) Base reduction rate
L1_30_VBCSTJ_1BBASECURR15(2) Base amountJ_1BBASE
L1_30_PICMSSTJ_1BTXRATEDEC6(2) Tax RateJ_1BTXRATE
L1_30_VICMSSTJ_1BTAXVALCURR15(2) Tax valueJ_1BTAXVAL
L1_40_ORIGJ_1BMATORGCHAR1(0) Origin of the materialJ_1BMATORG
L1_40_CSTNUMC2(0) Tax situation
L1_51_ORIGJ_1BMATORGCHAR1(0) Origin of the materialJ_1BMATORG
L1_51_CSTNUMC2(0) Tax situation
L1_51_MODBCNUMC1(0) Base Determination rule
L1_51_PREDBCDEC5(2) Base reduction rate
L1_51_VBCJ_1BBASECURR15(2) Base amountJ_1BBASE
L1_51_PICMSJ_1BTXRATEDEC6(2) Tax RateJ_1BTXRATE
L1_51_VICMSJ_1BTAXVALCURR15(2) Tax valueJ_1BTAXVAL
L1_60_ORIGJ_1BMATORGCHAR1(0) Origin of the materialJ_1BMATORG
L1_60_CSTNUMC2(0) Tax situation
L1_60_VBCSTJ_1BBASECURR15(2) Base amountJ_1BBASE
L1_60_VICMSSTJ_1BTAXVALCURR15(2) Tax valueJ_1BTAXVAL
L1_70_ORIGJ_1BMATORGCHAR1(0) Origin of the materialJ_1BMATORG
L1_70_CSTNUMC2(0) Tax situation
L1_70_MODBCNUMC1(0) Base Determination rule ICMS
L1_70_PREDBCDEC5(2) Base reduction rate
L1_70_VBCJ_1BBASECURR15(2) Base amountJ_1BBASE
L1_70_PICMSJ_1BTXRATEDEC6(2) Tax RateJ_1BTXRATE
L1_70_VICMSJ_1BTAXVALCURR15(2) Tax valueJ_1BTAXVAL
L1_70_MODBCSTNUMC1(0) Base Determination rule ICMSST
L1_70_PMVASTDEC5(2) Surcharge rate
L1_70_PREDBCSTDEC5(2) Base reduction rate
L1_70_VBCSTJ_1BBASECURR15(2) Base amountJ_1BBASE
L1_70_PICMSSTJ_1BTXRATEDEC6(2) Tax RateJ_1BTXRATE
L1_70_VICMSSTJ_1BTAXVALCURR15(2) Tax valueJ_1BTAXVAL
L1_90_ORIGJ_1BMATORGCHAR1(0) Origin of the materialJ_1BMATORG
L1_90_CSTNUMC2(0) Tax situation
L1_90_MODBCNUMC1(0) Base Determination rule ICMS
L1_90_PREDBCDEC5(2) Base reduction rate
L1_90_VBCJ_1BBASECURR15(2) Base amountJ_1BBASE
L1_90_PICMSJ_1BTXRATEDEC6(2) Tax RateJ_1BTXRATE
L1_90_VICMSJ_1BTAXVALCURR15(2) Tax valueJ_1BTAXVAL
L1_90_MODBCSTNUMC1(0) Base Determination rule ICMSST
L1_90_PMVASTDEC5(2) Surcharge rate
L1_90_PREDBCSTDEC5(2) Base reduction rate
L1_90_VBCSTJ_1BBASECURR15(2) Base amountJ_1BBASE
L1_90_PICMSSTJ_1BTXRATEDEC6(2) Tax RateJ_1BTXRATE
L1_90_VICMSSTJ_1BTAXVALCURR15(2) Tax valueJ_1BTAXVAL
N_IPICHAR1(0)
N_CLENQCHAR5(0) IPI class
N_CNPJPRODSTCD1CHAR16(0) Tax Number 1STCD1FB
N_CSELOCHAR60(0) IPI control code from selo
N_QSELONUMC12(0) Quantity from selo control
N_CENQCHAR3(0) Enquadramento code
N1_CSTCHAR2(0) Subtrib code for IPI
N1_VBCJ_1BBASECURR15(2) Base amountJ_1BBASE
N1_QUNIDDEC15(4) Pauta quantity
N1_VUNIDDEC15(4) Pauta unit value
N1_PIPIJ_1BTXRATEDEC6(2) Tax RateJ_1BTXRATE
N1_VIPIJ_1BTAXVALCURR15(2) Tax valueJ_1BTAXVAL
N2_CSTCHAR2(0) Subtrib code for IPI
O_IICHAR1(0) Tag II
O_VBCJ_1BBASECURR15(2) Base amountJ_1BBASE
O_VDESPADUDEC15(2) Customs Expenses Amount
O_VIIDEC15(2) Import Tax Amount
O_VIOFDEC15(2) Tax on Financial Operations Amount
P_PISCHAR1(0) Tag PIS
P1_CSTNUMC2(0) Subtrib code for PIS
P1_VBCJ_1BBASECURR15(2) Base amountJ_1BBASE
P1_PPISJ_1BTXRATEDEC6(2) Tax RateJ_1BTXRATE
P1_VPISJ_1BTAXVALCURR15(2) Tax valueJ_1BTAXVAL
P2_CSTNUMC2(0) Subtrib code for PIS
P2_QBCPRODDEC15(4) Sold quantity
P2_VALIQPRODDEC15(4) Pis rate in reais
P2_VPISJ_1BTAXVALCURR15(2) Tax valueJ_1BTAXVAL
P3_CSTNUMC2(0) Subtrib code for PIS
P4_CSTNUMC2(0) Subtrib code for PIS
P4_VBCJ_1BBASECURR15(2) Base amountJ_1BBASE
P4_PPISJ_1BTXRATEDEC6(2) Tax RateJ_1BTXRATE
P4_QBCPRODDEC15(4) Sold quantity
P4_VALIQPRODDEC15(4) Pis rate in reais
P4_VPISJ_1BTAXVALCURR15(2) Tax valueJ_1BTAXVAL
P5_VBCJ_1BBASECURR15(2) Base amountJ_1BBASE
P5_PPISJ_1BTXRATEDEC6(2) Tax RateJ_1BTXRATE
P5_QBCPRODDEC15(4) Sold quantity
P5_VALIQPRODDEC15(4) Pis rate in reais
P5_VPISJ_1BTAXVALCURR15(2) Tax valueJ_1BTAXVAL
P5_CSTNUMC2(0)
Q_COFINSCHAR1(0) Tag Cofins
Q1_CSTNUMC2(0) Subtrib code for COFINS
Q1_VBCJ_1BBASECURR15(2) Base amountJ_1BBASE
Q1_PCOFINSJ_1BTXRATEDEC6(2) Tax RateJ_1BTXRATE
Q1_VCOFINSJ_1BTAXVALCURR15(2) Tax valueJ_1BTAXVAL
Q2_CSTNUMC2(0) Subtrib code for COFINS
Q2_QBCPRODDEC15(4) Sold quantity
Q2_VALIQPRODDEC15(4) COFINS rate in reais
Q2_VCOFINSJ_1BTAXVALCURR15(2) Tax valueJ_1BTAXVAL
Q3_CSTNUMC2(0) Subtrib code for COFINS
Q4_CSTNUMC2(0) Subtrib code for COFINS
Q4_VBCJ_1BBASECURR15(2) Base amountJ_1BBASE
Q4_PCOFINSJ_1BTXRATEDEC6(2) Tax RateJ_1BTXRATE
Q4_QBCPRODDEC15(4) Sold quantity
Q4_VALIQPRODDEC15(4) COFINS rate in reais
Q4_VCOFINSJ_1BTAXVALCURR15(2) Tax valueJ_1BTAXVAL
Q5_VBCJ_1BBASECURR15(2) Base amountJ_1BBASE
Q5_PCOFINSJ_1BTXRATEDEC6(2) Tax RateJ_1BTXRATE
Q5_QBCPRODDEC15(4) Sold quantity
Q5_VALIQPRODDEC15(4) COFINS rate in reais
Q5_VCOFINSJ_1BTAXVALCURR15(2) Tax valueJ_1BTAXVAL
Q5_CSTNUMC2(0)
X_VBCJ_1BBASECURR15(2) Base amountJ_1BBASE
X_VALIQJ_1BTXRATEDEC6(2) Tax RateJ_1BTXRATE
X_VISSQNJ_1BTAXVALCURR15(2) Tax valueJ_1BTAXVAL
X_CMUNFGNUMC7(0) Municipio Code
X_CLISTSERVNUMC4(0) ISS service type code according to law LC 116/03
INFADPRODSTRG0(0)
OIL_CPRODANPNUMC9(0) Product Code
OIL_CODIFNUMC21(0) Registration/Authorization Code
OIL_GTEMPDEC16(4) Quantity of fuel at Room temperature
OIL_QBCPRODDEC12(4) CIDE Calculation Base
OIL_VALIGPRODDEC11(4) Invoiced at Room temperature
OIL_VCIDEDEC13(2) CIDE Value
OIL_VBCICMSDEC13(2) ICMS Base
OIL_VICMSDEC13(2) ICMS Value
OIL_VBCICMSSTDEC13(2) Subtrib. Base
OIL_VCICMSSTDEC13(2) Subtrib. Value
OIL_VBCICMSSTDESTDEC13(2) Subtrib. Base Destination
OIL_VICMSSTDESTDEC13(2) Subtrib. value Destination
OIL_VBCICMSSTCONSDEC13(2) Subtrib. Base Consumption
OIL_VICMSSTCONSDEC13(2) Subtrib. value Consumption
OIL_UFCONSCHAR2(0) Region of the consumption
H1_VOUTRODEC15(2) Other accessory costs
INDTOTNUMC1(0) Indic. of whether item value is accounted in the NF-e total
XPEDCHAR15(0) Purchase Order number
NITEMPEDNUMC6(0) Purchase Order item number
CCORDENNUMC2(0) Color code
LOTANUMC3(0) Maximum capacity
TPRESTNUMC1(0) Restriction
L1_40_VICMSJ_1BTAXVALCURR15(2) Tax valueJ_1BTAXVAL
L1_40_MOTDESICMSNUMC1(0) ICMS exemption reason
X_CSITTRIBCHAR1(0) ISSQN taxation code
QCOM_V20J1B_NF_XML_QUANTITYQUAN15(4) Quantity in XML Layout
VUNCOM_V20DEC21(10) Comercialized Unitary Value
QTRIB_V20J1B_NF_XML_QUANTITYQUAN15(4) Quantity in XML Layout
VUNTRIB_V20DEC21(10) Taxable Unitary Value
L1_2R_ORIGJ_1BMATORGCHAR1(0) Origin of the materialJ_1BMATORG
L1_2R_CSTNUMC2(0) Tax situation
L1_2R_MODBCNUMC1(0) Base Determination rule ICMS
L1_2R_VBCJ_1BBASECURR15(2) Base amountJ_1BBASE
L1_2R_PREDBCDEC5(2) Base reduction rate
L1_2R_PICMSJ_1BTXRATEDEC6(2) Tax RateJ_1BTXRATE
L1_2R_VICMSJ_1BTAXVALCURR15(2) Tax valueJ_1BTAXVAL
L1_2R_MODBCSTNUMC1(0) Base Determination rule ICMSST
L1_2R_PMVASTDEC5(2) Surcharge rate
L1_2R_PREDBCSTDEC5(2) Base reduction rate
L1_2R_VBCSTJ_1BBASECURR15(2) Base amountJ_1BBASE
L1_2R_PICMSSTJ_1BTXRATEDEC6(2) Tax RateJ_1BTXRATE
L1_2R_VICMSSTJ_1BTAXVALCURR15(2) Tax valueJ_1BTAXVAL
L1_2R_PBCOPDEC5(2) Own operation tax base
L1_2R_UFSTREGIOCHAR3(0) *Region (State, Province, County)REGIOFB
ORIGJ_1BMATORGCHAR1(0) Origin of the materialJ_1BMATORG
CSTNUMC2(0) Tax situation
VBCSTRETJ_1BBASECURR15(2) Base amountJ_1BBASE
VICMSSTRETJ_1BTAXVALCURR15(2) Tax valueJ_1BTAXVAL
VBCSTDESTJ_1BBASECURR15(2) Base amountJ_1BBASE
VICMSSTDESTJ_1BTAXVALCURR15(2) Tax valueJ_1BTAXVAL
VTOTTRIBJ_1BNFE_VTOTTRIBDEC15(2) Total Tax Value
NFCIJ_1BNFE_NFCICHAR36(0) FCI Number


View list of all S4 Hana tables