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 |