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.
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 | Data Element | Data Type | length (Dec) | Check table | Description | Conversion Routine | Domain Name | MemoryID | AppClass | SHLP | SHLP Field | ConvExit |
| CPROD | MATNR18 | CHAR | 18(0) | Material Number (18 Characters) | MATNR18 | MG | ||||||
| CEAN | EAN11 | CHAR | 18(0) | International Article Number (EAN/UPC) | EAN11 | EAN | MGW | |||||
| XPROD | CHAR | 120(0) | Material Text | |||||||||
| NCM | STEUC | CHAR | 16(0) | Control code for consumption taxes in foreign trade | STEUC | |||||||
| EXTIPI | CHAR | 3(0) | EXTIPI | |||||||||
| GENERO | CHAR | 2(0) | Firtst 2 digits of NCM code | |||||||||
| CFOP | J_1BCFOP | CHAR | 10(0) | CFOP Code and Extension | J_1BCFOP | |||||||
| UTRIB | MEINS | UNIT | 3(0) | Base Unit of Measure | MEINS | MG | ||||||
| UCOM | VRKME | UNIT | 3(0) | Sales unit | MEINS | V | ||||||
| QTRIB | MENGE_D | QUAN | 13(3) | Quantity | MENG13 | MG | ||||||
| QCOM | LFIMG | QUAN | 13(3) | Actual quantity delivered (in sales units) | MENG13 | VL | ||||||
| VPROD | J_1BNFTOT | CURR | 15(2) | Total value including all taxes | WERTV8 | |||||||
| VFRETE | J_1BNFFRE | CURR | 15(2) | Freight value including taxes | WERTV8 | |||||||
| VSEG | J_1BNFINS | CURR | 15(2) | Insurance value including taxes | WERTV8 | |||||||
| VDESC | J_1BNFDIS | CURR | 15(2) | Discount value including taxes | WERTV8 | |||||||
| VUNCOM | DEC | 15(4) | Commercial Unit Value | |||||||||
| CEANTRIB | CHAR | 14(0) | Global Trade Item Number | |||||||||
| VUNTRIB | DEC | 15(4) | Taxation Unit Value | |||||||||
| NDI | CHAR | 10(0) | Import declaration number DI/DSI/DA | |||||||||
| DDI | DATS | 8(0) | Registration date of the DI/DSI/DA | |||||||||
| XLOCDESEMB | CHAR | 60(0) | Location where goods are released | |||||||||
| UFDESEMB | CHAR | 2(0) | Region where the goods have been released | |||||||||
| DDESEMB | DATS | 8(0) | Date when goods have been released | |||||||||
| CEXPORTADOR | CHAR | 60(0) | Code of the Export Company | |||||||||
| NADICAO | NUMC | 3(0) | Number of the addition | |||||||||
| NSEQADIC | NUMC | 3(0) | Sequential number of the item in the addition | |||||||||
| CFABRICANTE | CHAR | 60(0) | Code of the foreign producer in the system | |||||||||
| VDESCDI | CURR | 15(2) | Discount value of the DI item - addition |