SAP S/4Hana table J1B_NF_XML_H1_OLD stores NF-e Block H1 / Products and Services of the NF-e /Tag: proddata


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_H1_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_H1_OLD dictionary attributes

Object Name: J1B_NF_XML_H1_OLD
Dictionary Type: Structure
Description: NF-e Block H1 / Products and Services of the NF-e /Tag: prod

Field list for J1B_NF_XML_H1_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
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
GENEROCHAR2(0) Firtst 2 digits of NCM code
CFOPJ_1BCFOPCHAR10(0) CFOP Code and ExtensionJ_1BCFOP
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

View list of all S4 Hana tables