J_1IRG23D SAP (RG23D register for the depot) Table details

Dictionary Type: Table
Description: RG23D register for the depot




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




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

J_1IRG23D is a standard SAP Table which is used to store RG23D register for the depot data and is available within R/3 SAP systems depending on the version and release level.

The J_1IRG23D table consists of various fields, each holding specific information or linking keys about RG23D register for the depot data available in SAP. These include TRNTYP (Excise Transaction Type), DOCYR (Document year - GR for depot), DOCNO (Internal number - GR for delivery at depot), ZEILE (Item number - GR at depot).. 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: Can be enhanced (character-type or numeric)


SAP J_1IRG23D 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
TRNTYPExcise Transaction Type J_1ITRNTYPCHAR4J_1ITRANJ_1ITRNTYP
DOCYRDocument year - GR for depot J_1IDOCYR1NUMC4NUMC4
DOCNOInternal number - GR for delivery at depot J_1IDOCNO1NUMC10J_1IEXCHDRJ_1IDOCNO
ZEILEItem number - GR at depot J_1IZEILE1NUMC4NUMC4
VBELNDelivery VBELN_VLCHAR10VBUKALPHAVBELNVL
POSNRDelivery Item POSNR_VLNUMC6VBUPPOSNR
MBLNRNumber of Material Document MBLNRCHAR10ALPHABELNRMBN
MJAHRMaterial Document Year MJAHRNUMC4GJAHRGJAHRMJA
MZEILEItem in Material Document MBLPONUMC4MBLPOPOS
WERKSPlant WERKS_DCHAR4T001WWERKSWRKH_T001W_C
FOLIORegister Entry Serial Number J_1ISRLNO1NUMC10NUMC10
SERIALNOItem in Material Document MBLPONUMC4MBLPOPOS
EXGRPExcise Group J_1IEXCGRPCHAR2Assigned to domainJ_1IEXCGRPJ2I
EXNUMOfficial Excise Document Number J_1IEXCNUMCHAR10J_1IEXCNUMJ2F
EXYEARExcise Year J_1IEXYEARNUMC4GJAHRGJAHRGJR
SRGRPExcise Document Series Group J_1ISERGRPCHAR3Assigned to domainJ_1ISERGRPJ2H
DEPEXNUMOfficial Excise Document Number J_1IEXCNUMCHAR10J_1IEXCNUMJ2F
DEPEXYEARExcise Year J_1IEXYEARNUMC4GJAHRGJAHRGJR
REMTIMETime of Removal J_1IREMTIMTIMS6UZEIT
LIFNRVendor J_1ILIFNRCHAR10J_1ILIFNRLIF
SHIPFROMAccount Number of Vendor or Creditor LIFNRCHAR10Assigned to domainALPHALIFNRLIFKRED_C
MATNRMaterial Number MATNRCHAR18MARAMATN1MATNRMATS_MAT1
MAKTXMaterial Description (Short Text) MAKTXCHAR40TEXT40
CHAPIDChapter ID J_1ICHIDCHAR12CHAR12
MENGEQuantity MENGE_DQUAN13(3) MENG13
MEINSBase Unit of Measure MEINSUNIT3T006CUNITMEINS
EXCURCurrency J_1IEXCCURCUKY5TCURCWAERS
EXBASExcise Duty Base Amount J_1IEXCBASCURR13(2) WERT7
EXBEDBasic Excise Duty J_1IEXCBEDCURR13(2) WERT7
EXSEDSpecial Excise Duty J_1IEXCSEDCURR13(2) WERT7
EXAEDAdditional Excise Duty J_1IEXCAEDCURR13(2) WERT7
CESSCess amount J_1IEXCESSCURR13(2) WERT7
BEDRATBED percentage J_1IBEDRATDEC7(4) PRZ34
AEDRATAdditional Excise Duty % J_1IAEDRATDEC7(4) PRZ34
SEDRATSpecial Excise Duty % J_1ISEDRATDEC7(4) PRZ34
CESSRATECess percentage J_1ICESSDEC5(3) PRZ23
RG23ASERRG23A serial no. J_1I23ASERNUMC10NUMC10
RG23CSERRG23C serial no. J_1I23CSERNUMC10NUMC10
RGPLASERPLA serial no. J_1IPLASERNUMC10NUMC10
RDOCReference Document 1 J_1IRDOC1CHAR10CHAR10
RDATEPosting date in the reference document J_1IBUDATDATS8DATUM
DOWNLDownload indicator J_1IDOWNLCHAR1XFELD
STATUSExcise Document Status J_1ISTATUSCHAR1J_1ISTATUS
REF_FOLIORegister Entry Serial Number J_1ISRLNO1NUMC10NUMC10
REF_SERIALItem in Material Document MBLPONUMC4MBLPOPOS
USNAMCreated By J_1IUSNAMCHAR12CHAR12
CPUDTExcise Document Entry Date J_1ICPUDTDATS8DATUM
NCCDRATENCCD Rate in % J_1INCCDRATDEC7(4) PRZ34
NCCDNCCD Value J_1IEXNCCDCURR13(2) WERT7
ECSRATEECS rate in % J_1IECSRATDEC7(4) PRZ34
ECSECS Value J_1IEXECSCURR13(2) WERT7
EXADDTAX1Additional Tax1 value J_1IEXADDTAX1CURR13(2) WERT7
EXADDRATE1AT1 rate in % J_1IEXADDRAT1DEC7(4) PRZ34
EXADDTAX2Additional Tax2 value J_1IEXADDTAX2CURR13(2) WERT7
EXADDRATE2AT2 rate in % J_1IEXADDRAT2DEC7(4) PRZ34
EXADDTAX3Additional Tax3 value J_1IEXADDTAX3CURR13(2) WERT7
EXADDRATE3AT3 rate in % J_1IEXADDRAT3DEC7(4) PRZ34

Key field Non-key field



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

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

SELECT SINGLE *
FROM J_1IRG23D
INTO CORRESPONDING FIELDS OF WA_J_1IRG23D
WHERE...

How to access SAP table J_1IRG23D

Within an ECC or HANA version of SAP you can also view further information about J_1IRG23D 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!