J_1IPART1 SAP (Excise part I detials) Table details

Dictionary Type: Table
Description: Excise part I detials




ABAP Code to SELECT data from J_1IPART1
Related tables to J_1IPART1
Access table J_1IPART1




Table field list including key, data, relationships and ABAP select examples

J_1IPART1 is a standard SAP Table which is used to store Excise part I detials data and is available within R/3 SAP systems depending on the version and release level.

The J_1IPART1 table consists of various fields, each holding specific information or linking keys about Excise part I detials data available in SAP. These include EXGRP (Excise Group), REGTYP (Excise Register Type), SYEAR (Year of Register Entry), SERIALNO (Register Entry Serial Number).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Cannot Be Enhanced


SAP J_1IPART1 table fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3T000MANDT
EXGRPExcise Group J_1IEXCGRPCHAR2J_1IEXGRPSJ_1IEXCGRPJ2I
REGTYPExcise Register Type J_1IREGTYPCHAR1J_1IREGTYP
SYEARYear of Register Entry J_1IYEARNUMC4NUMC4
SERIALNORegister Entry Serial Number J_1ISRLNO1NUMC10NUMC10
MBLNRNumber of Material Document MBLNRCHAR10ALPHABELNRMBN
MJAHRMaterial Document Year MJAHRNUMC4GJAHRGJAHRMJA
ZEILEItem in Material Document MBLPONUMC4MBLPOPOS
BWARTMovement Type (Inventory Management) BWARTCHAR3T156BWARTBWA
RISINDGoods Movement Direction J_1IRISINDCHAR1J_1IRISIND
RCPTISSRSNRcpt/Issu classification codes J_2IRIINDICHAR3J_2IRIINDI
TRNTYPExcise Transaction Type J_1ITRNTYPCHAR4J_1ITRANJ_1ITRNTYP
DOCNOInternal Excise Document Number J_1IDOCNONUMC10J_1IEXCHDRJ_1IDOCNOJ2G
DOCYRYear J_1IDOCUYRNUMC4J_1IDOCUYRGJR
ACTTYPActivity type for external tax system J_1IACTTYPCHAR4CHAR4
MATNRMaterial Number MATNRCHAR18MARAMATN1MATNRMATS_MAT1
MAKTXMaterial Description (Short Text) MAKTXCHAR40TEXT40
MENGEExcise Invoice Quantity J_1IEXMENGEQUAN13(3) MENG13
MEINSUnit of Measure J_1IMEINSUNIT3T006CUNITMEINS
DOWNLDownload indicator J_1IDOWNLCHAR1XFELD
DECLRDItem declared for Excise J_1IDECLRDCHAR1CHAR1
STATUSRegister Entry Status J_1IRGSTATCHAR1J_1IRGSTAT
USNAMUser name USNAMCHAR12Assigned to domainXUBNAMEUSR
CPUDTExcise Document Entry Date J_1ICPUDTDATS8DATUM
CPUTMTime of Entry CPUTMTIMS6UZEIT
AENAMChanged by the user J_1IUSNAMCCHAR12CHAR12
AEDATChanged on date J_1IAEDATDATS8J_1IAEDAT

Key field Non-key field



How do I retrieve data from SAP table J_1IPART1 using ABAP code

The following ABAP code Example will allow you to do a basic selection on J_1IPART1 to SELECT all data from the table
DATA: WA_J_1IPART1 TYPE J_1IPART1.

SELECT SINGLE *
FROM J_1IPART1
INTO CORRESPONDING FIELDS OF WA_J_1IPART1
WHERE...

How to access SAP table J_1IPART1

Within an ECC or HANA version of SAP you can also view further information about J_1IPART1 and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


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!