Home SAP Development ABAP Coding SAP Fiori SAP Training SAP Tables SAP Objects...

SAP J1B_NF_XML_H_OLD Table in S/4 HANA - NF-e Block H / Products and Services of the NF-e /Tag: det

Table Field Attributes
Data Element Attributes
Domain Attributes
SAP Tables
Best ABAP Books

J1B_NF_XML_H_OLD is a standard SAP Table which is used to store NF-e Block H / Products and Services of the NF-e /Tag: det data and is available within S/4 HANA SAP systems depending on the version and release level. Below is the technical details and the list of fields specifically relevant for an SAP S/4 HANA system

Even using an S/4 Hana system you can still view further information about the SAP J1B_NF_XML_H_OLD table and the data within it using standard SAP GUI transactions such as SE11, SE80 or SE16. Or you can use the ADT (ABAP development tools within eclipse).

Delivery Class:
Display/Maintenance via SM30: Display/Maintenance Allowed but with Restrictions
Enhancement category: Can Be Enhanced (Deep)
Dictionary Type: Structure
Database Table: J1B_NF_XML_H_OLD

J1B_NF_XML_H_OLD table structure field list

Below is the full J1B_NF_XML_H_OLD field list that makes up the SAP database table structure, including key fields, description, data type and other technical details of each field

Field	Description	Data Element	Data Type	length (Dec)	Check table	Conversion Routine	Domain Name	MemoryID	SHLP	SHLP Field
NITEM	Number of items		NUMC	3(0)
CPROD	Material Number (18 Characters)	MATNR18	CHAR	18(0)			MATNR18
CEAN	International Article Number (EAN/UPC)	EAN11	CHAR	18(0)		EAN11	EAN11	EAN
XPROD	Material Text		CHAR	120(0)
NCM	Control code for consumption taxes in foreign trade	STEUC	CHAR	16(0)			STEUC
EXTIPI	EXTIPI		CHAR	3(0)
GENERO	Firtst 2 digits of NCM code		CHAR	2(0)
CFOP	CFOP Code and Extension	J_1BCFOP	CHAR	10(0)	Assigned to domain	CFOBR	J_1BCFOP
UTRIB	Base Unit of Measure	MEINS	UNIT	3(0)	Assigned to domain	CUNIT	MEINS
UCOM	Sales unit	VRKME	UNIT	3(0)	Assigned to domain	CUNIT	MEINS
QTRIB	Quantity	MENGE_D	QUAN	13(3)			MENG13
QCOM	Actual quantity delivered (in sales units)	LFIMG	QUAN	13(3)			MENG13
VPROD	Total value including all taxes	J_1BNFTOT	CURR	15(2)			WERTV8
VFRETE	Freight value including taxes	J_1BNFFRE	CURR	15(2)			WERTV8
VSEG	Insurance value including taxes	J_1BNFINS	CURR	15(2)			WERTV8
VDESC	Discount value including taxes	J_1BNFDIS	CURR	15(2)			WERTV8
VUNCOM	Commercial Unit Value		DEC	15(4)
CEANTRIB	Global Trade Item Number		CHAR	14(0)
VUNTRIB	Taxation Unit Value		DEC	15(4)
NDI	Import declaration number DI/DSI/DA		CHAR	10(0)
DDI	Registration date of the DI/DSI/DA		DATS	8(0)
XLOCDESEMB	Location where goods are released		CHAR	60(0)
UFDESEMB	Region where the goods have been released		CHAR	2(0)
DDESEMB	Date when goods have been released		DATS	8(0)
CEXPORTADOR	Code of the Export Company		CHAR	60(0)
NADICAO	Number of the addition		NUMC	3(0)
NSEQADIC	Sequential number of the item in the addition		NUMC	3(0)
CFABRICANTE	Code of the foreign producer in the system		CHAR	60(0)
VDESCDI	Discount value of the DI item - addition		CURR	15(2)
I_TPOP	Type of Operation		NUMC	1(0)
I_CHASSI	Vehicle Chassis		CHAR	17(0)
I_COR	Code for Each Assembly Plant		CHAR	4(0)
I_XCOR	Color Description		CHAR	40(0)
I_POT	Engine Power		CHAR	4(0)
I_CM3	CM3 (Power)		CHAR	4(0)
I_PESOL	Net Weight		CHAR	9(0)
I_PESOB	Gross Weight		CHAR	9(0)
I_NSERIE	Serial (sÃ©rie)		CHAR	9(0)
I_TPCOMB	Type of Fuel		CHAR	8(0)
I_NMOTOR	Engine Number		CHAR	21(0)
I_CMKG	CMKG		CHAR	9(0)
I_DIST	Distance Between Axles		CHAR	4(0)
I_RENAVAM	RENAVAM		CHAR	9(0)
I_ANOMOD	Year of Manufacturing Model		NUMC	4(0)
I_ANOFAB	Production Year		NUMC	4(0)
I_TPPINT	Type of Painting		CHAR	1(0)
I_TPVEIC	Type of Vehicle		NUMC	2(0)
I_ESPVEIC	Sort of Vehicle		CHAR	1(0)
I_VIN	Condition of VIN		CHAR	1(0)
I_CONDVEIC	Condition of the Vehicle		NUMC	1(0)
I_CMOD	Code Brand Model		CHAR	6(0)
K_TPARMA	Indicator of Firearm Type		NUMC	1(0)
K_NSERIE	Gun Serial number		NUMC	9(0)
K_NCANO	Barrel Serial Number		NUMC	9(0)
K_DESCR	Full Description of the Gun		CHAR	256(0)
L1_ICMS	Tag ICMS		CHAR	1(0)
L1_00_ORIG	Origin of the material	J_1BMATORG	CHAR	1(0)			J_1BMATORG
L1_00_CST	Tax situation		NUMC	2(0)
L1_00_MODBC	Base Determination rule		NUMC	1(0)
L1_00_VBC	Base amount	J_1BBASE	CURR	15(2)			J_1BBASE
L1_00_PICMS	Tax Rate	J_1BTXRATE	DEC	6(2)			J_1BTXRATE
L1_00_VICMS	Tax value	J_1BTAXVAL	CURR	15(2)			J_1BTAXVAL
L1_10_ORIG	Origin of the material	J_1BMATORG	CHAR	1(0)			J_1BMATORG
L1_10_CST	Tax situation		NUMC	2(0)
L1_10_MODBC	Base Determination rule ICMS		NUMC	1(0)
L1_10_VBC	Base amount	J_1BBASE	CURR	15(2)			J_1BBASE
L1_10_PICMS	Tax Rate	J_1BTXRATE	DEC	6(2)			J_1BTXRATE
L1_10_VICMS	Tax value	J_1BTAXVAL	CURR	15(2)			J_1BTAXVAL
L1_10_MODBCST	Base Determination rule ICMSST		NUMC	1(0)
L1_10_PMVAST	Surcharge rate		DEC	5(2)
L1_10_PREDBCST	Base reduction rate		DEC	5(2)
L1_10_VBCST	Base amount	J_1BBASE	CURR	15(2)			J_1BBASE
L1_10_PICMSST	Tax Rate	J_1BTXRATE	DEC	6(2)			J_1BTXRATE
L1_10_VICMSST	Tax value	J_1BTAXVAL	CURR	15(2)			J_1BTAXVAL
L1_20_ORIG	Origin of the material	J_1BMATORG	CHAR	1(0)			J_1BMATORG
L1_20_CST	Tax situation		NUMC	2(0)
L1_20_MODBC	Base Determination rule		NUMC	1(0)
L1_20_PREDBC	Base reduction rate		DEC	5(2)
L1_20_VBC	Base amount	J_1BBASE	CURR	15(2)			J_1BBASE
L1_20_PICMS	Tax Rate	J_1BTXRATE	DEC	6(2)			J_1BTXRATE
L1_20_VICMS	Tax value	J_1BTAXVAL	CURR	15(2)			J_1BTAXVAL
L1_30_ORIG	Origin of the material	J_1BMATORG	CHAR	1(0)			J_1BMATORG
L1_30_CST	Tax situation		NUMC	2(0)
L1_30_MODBCST	Base Determination rule		NUMC	1(0)
L1_30_PMVAST	Surcharge rate		DEC	5(2)
L1_30_PREDBCST	Base reduction rate		DEC	5(2)
L1_30_VBCST	Base amount	J_1BBASE	CURR	15(2)			J_1BBASE
L1_30_PICMSST	Tax Rate	J_1BTXRATE	DEC	6(2)			J_1BTXRATE
L1_30_VICMSST	Tax value	J_1BTAXVAL	CURR	15(2)			J_1BTAXVAL
L1_40_ORIG	Origin of the material	J_1BMATORG	CHAR	1(0)			J_1BMATORG
L1_40_CST	Tax situation		NUMC	2(0)
L1_51_ORIG	Origin of the material	J_1BMATORG	CHAR	1(0)			J_1BMATORG
L1_51_CST	Tax situation		NUMC	2(0)
L1_51_MODBC	Base Determination rule		NUMC	1(0)
L1_51_PREDBC	Base reduction rate		DEC	5(2)
L1_51_VBC	Base amount	J_1BBASE	CURR	15(2)			J_1BBASE
L1_51_PICMS	Tax Rate	J_1BTXRATE	DEC	6(2)			J_1BTXRATE
L1_51_VICMS	Tax value	J_1BTAXVAL	CURR	15(2)			J_1BTAXVAL
L1_60_ORIG	Origin of the material	J_1BMATORG	CHAR	1(0)			J_1BMATORG
L1_60_CST	Tax situation		NUMC	2(0)
L1_60_VBCST	Base amount	J_1BBASE	CURR	15(2)			J_1BBASE
L1_60_VICMSST	Tax value	J_1BTAXVAL	CURR	15(2)			J_1BTAXVAL
L1_70_ORIG	Origin of the material	J_1BMATORG	CHAR	1(0)			J_1BMATORG
L1_70_CST	Tax situation		NUMC	2(0)
L1_70_MODBC	Base Determination rule ICMS		NUMC	1(0)
L1_70_PREDBC	Base reduction rate		DEC	5(2)
L1_70_VBC	Base amount	J_1BBASE	CURR	15(2)			J_1BBASE
L1_70_PICMS	Tax Rate	J_1BTXRATE	DEC	6(2)			J_1BTXRATE
L1_70_VICMS	Tax value	J_1BTAXVAL	CURR	15(2)			J_1BTAXVAL
L1_70_MODBCST	Base Determination rule ICMSST		NUMC	1(0)
L1_70_PMVAST	Surcharge rate		DEC	5(2)
L1_70_PREDBCST	Base reduction rate		DEC	5(2)
L1_70_VBCST	Base amount	J_1BBASE	CURR	15(2)			J_1BBASE
L1_70_PICMSST	Tax Rate	J_1BTXRATE	DEC	6(2)			J_1BTXRATE
L1_70_VICMSST	Tax value	J_1BTAXVAL	CURR	15(2)			J_1BTAXVAL
L1_90_ORIG	Origin of the material	J_1BMATORG	CHAR	1(0)			J_1BMATORG
L1_90_CST	Tax situation		NUMC	2(0)
L1_90_MODBC	Base Determination rule ICMS		NUMC	1(0)
L1_90_PREDBC	Base reduction rate		DEC	5(2)
L1_90_VBC	Base amount	J_1BBASE	CURR	15(2)			J_1BBASE
L1_90_PICMS	Tax Rate	J_1BTXRATE	DEC	6(2)			J_1BTXRATE
L1_90_VICMS	Tax value	J_1BTAXVAL	CURR	15(2)			J_1BTAXVAL
L1_90_MODBCST	Base Determination rule ICMSST		NUMC	1(0)
L1_90_PMVAST	Surcharge rate		DEC	5(2)
L1_90_PREDBCST	Base reduction rate		DEC	5(2)
L1_90_VBCST	Base amount	J_1BBASE	CURR	15(2)			J_1BBASE
L1_90_PICMSST	Tax Rate	J_1BTXRATE	DEC	6(2)			J_1BTXRATE
L1_90_VICMSST	Tax value	J_1BTAXVAL	CURR	15(2)			J_1BTAXVAL
N_IPI			CHAR	1(0)
N_CLENQ	IPI class		CHAR	5(0)
N_CNPJPROD	Tax Number 1	STCD1	CHAR	16(0)			STCD1
N_CSELO	IPI control code from selo		CHAR	60(0)
N_QSELO	Quantity from selo control		NUMC	12(0)
N_CENQ	Enquadramento code		CHAR	3(0)
N1_CST	Subtrib code for IPI		CHAR	2(0)
N1_VBC	Base amount	J_1BBASE	CURR	15(2)			J_1BBASE
N1_QUNID	Pauta quantity		DEC	15(4)
N1_VUNID	Pauta unit value		DEC	15(4)
N1_PIPI	Tax Rate	J_1BTXRATE	DEC	6(2)			J_1BTXRATE
N1_VIPI	Tax value	J_1BTAXVAL	CURR	15(2)			J_1BTAXVAL
N2_CST	Subtrib code for IPI		CHAR	2(0)
O_II	Tag II		CHAR	1(0)
O_VBC	Base amount	J_1BBASE	CURR	15(2)			J_1BBASE
O_VDESPADU	Customs Expenses Amount		DEC	15(2)
O_VII	Import Tax Amount		DEC	15(2)
O_VIOF	Tax on Financial Operations Amount		DEC	15(2)
P_PIS	Tag PIS		CHAR	1(0)
P1_CST	Subtrib code for PIS		NUMC	2(0)
P1_VBC	Base amount	J_1BBASE	CURR	15(2)			J_1BBASE
P1_PPIS	Tax Rate	J_1BTXRATE	DEC	6(2)			J_1BTXRATE
P1_VPIS	Tax value	J_1BTAXVAL	CURR	15(2)			J_1BTAXVAL
P2_CST	Subtrib code for PIS		NUMC	2(0)
P2_QBCPROD	Sold quantity		DEC	15(4)
P2_VALIQPROD	Pis rate in reais		DEC	15(4)
P2_VPIS	Tax value	J_1BTAXVAL	CURR	15(2)			J_1BTAXVAL
P3_CST	Subtrib code for PIS		NUMC	2(0)
P4_CST	Subtrib code for PIS		NUMC	2(0)
P4_VBC	Base amount	J_1BBASE	CURR	15(2)			J_1BBASE
P4_PPIS	Tax Rate	J_1BTXRATE	DEC	6(2)			J_1BTXRATE
P4_QBCPROD	Sold quantity		DEC	15(4)
P4_VALIQPROD	Pis rate in reais		DEC	15(4)
P4_VPIS	Tax value	J_1BTAXVAL	CURR	15(2)			J_1BTAXVAL
P5_VBC	Base amount	J_1BBASE	CURR	15(2)			J_1BBASE
P5_PPIS	Tax Rate	J_1BTXRATE	DEC	6(2)			J_1BTXRATE
P5_QBCPROD	Sold quantity		DEC	15(4)
P5_VALIQPROD	Pis rate in reais		DEC	15(4)
P5_VPIS	Tax value	J_1BTAXVAL	CURR	15(2)			J_1BTAXVAL
P5_CST			NUMC	2(0)
Q_COFINS	Tag Cofins		CHAR	1(0)
Q1_CST	Subtrib code for COFINS		NUMC	2(0)
Q1_VBC	Base amount	J_1BBASE	CURR	15(2)			J_1BBASE
Q1_PCOFINS	Tax Rate	J_1BTXRATE	DEC	6(2)			J_1BTXRATE
Q1_VCOFINS	Tax value	J_1BTAXVAL	CURR	15(2)			J_1BTAXVAL
Q2_CST	Subtrib code for COFINS		NUMC	2(0)
Q2_QBCPROD	Sold quantity		DEC	15(4)
Q2_VALIQPROD	COFINS rate in reais		DEC	15(4)
Q2_VCOFINS	Tax value	J_1BTAXVAL	CURR	15(2)			J_1BTAXVAL
Q3_CST	Subtrib code for COFINS		NUMC	2(0)
Q4_CST	Subtrib code for COFINS		NUMC	2(0)
Q4_VBC	Base amount	J_1BBASE	CURR	15(2)			J_1BBASE
Q4_PCOFINS	Tax Rate	J_1BTXRATE	DEC	6(2)			J_1BTXRATE
Q4_QBCPROD	Sold quantity		DEC	15(4)
Q4_VALIQPROD	COFINS rate in reais		DEC	15(4)
Q4_VCOFINS	Tax value	J_1BTAXVAL	CURR	15(2)			J_1BTAXVAL
Q5_VBC	Base amount	J_1BBASE	CURR	15(2)			J_1BBASE
Q5_PCOFINS	Tax Rate	J_1BTXRATE	DEC	6(2)			J_1BTXRATE
Q5_QBCPROD	Sold quantity		DEC	15(4)
Q5_VALIQPROD	COFINS rate in reais		DEC	15(4)
Q5_VCOFINS	Tax value	J_1BTAXVAL	CURR	15(2)			J_1BTAXVAL
Q5_CST			NUMC	2(0)
X_VBC	Base amount	J_1BBASE	CURR	15(2)			J_1BBASE
X_VALIQ	Tax Rate	J_1BTXRATE	DEC	6(2)			J_1BTXRATE
X_VISSQN	Tax value	J_1BTAXVAL	CURR	15(2)			J_1BTAXVAL
X_CMUNFG	Municipio Code		NUMC	7(0)
X_CLISTSERV	ISS service type code according to law LC 116/03		NUMC	4(0)
INFADPROD			STRG	0(0)

Search for further information about these or an SAP related objects

Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!