J_1IRAINDTL SAP (Article Inward Note Detail) Table details

Dictionary Type: Table
Description: Article Inward Note Detail




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




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

J_1IRAINDTL is a standard SAP Table which is used to store Article Inward Note Detail data and is available within R/3 SAP systems depending on the version and release level.

The J_1IRAINDTL table consists of various fields, each holding specific information or linking keys about Article Inward Note Detail data available in SAP. These include AINNO (Article Inward Note Number), AINYR (Article Inward Note Year), AINIT (Item Number), INSMK (Stock Type).. 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_1IRAINDTL 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 MANDTCLNT3Assigned to domainMANDT
AINNOArticle Inward Note Number J_1IRAINNOCHAR10ALPHABELNRAINNO
AINYRArticle Inward Note Year J_1IRAINYRNUMC4GJAHRGJAHRAINYR
AINITItem Number J_1IRZEILENUMC6Assigned to domainPOSNR
INSMKStock Type MB_INSMKCHAR1MB_INSMK
SOBKZSpecial Stock Indicator SOBKZCHAR1Assigned to domainSOBKZ
BWARTMovement Type (Inventory Management) BWARTCHAR3Assigned to domainBWARTBWA
MATNRMaterial Number MATNRCHAR18MARAMATN1MATNRMATS_MAT1
MATKLMaterial Group MATKLCHAR9T023MATKLMKLS_WBWG
TXZ01Short Text TXZ01CHAR40TEXT40
ERFMGQuantity in Unit of Entry ERFMGQUAN13(3) MENG13
ERFMEUnit of Entry ERFMEUNIT3T006CUNITMEINS
WERKSPlant WERKS_DCHAR4T001WWERKSWRKH_T001W_C
LGORTStorage Location LGORT_DCHAR4T001LLGORTLAG
EAN11International Article Number (EAN/UPC) EAN11CHAR18EAN11EAN11EAN
CHARGBatch Number CHARG_DCHAR10MCH1CHARGCHA
BWTARValuation Type BWTAR_DCHAR10Assigned to domainBWTARBWT
LIFNRVendor Account Number ELIFNCHAR10LFA1ALPHALIFNRLIFKRED_C
PMRPMRP Rate from PO at AIN creation J_1IRPMRPCURR11(2) WERTV6
IMRPMRP Rate from Invoice J_1IRIMRPCURR11(2) WERTV6
PCOSTCalculated Cost as per Invoiced MRP J_1IRPCOSTCURR11(2) WERTV6
ICOSTCost as per the Vendor Invoice J_1IRICOSTCURR11(2) WERTV6
TXVTAmount in Local Currency DMBTRCURR13(2) WERT7
TXRATERate (condition amount or percentage) KBETRCURR11(2) WERTV6
WAERSCurrency Key WAERSCUKY5TCURCWAERSFWS
STATUSStatus J_1IRSTATCHAR1J_1IRSTAT
MBLNRNumber of Material Document MBLNRCHAR10ALPHABELNRMBN
MJAHRMaterial Document Year MJAHRNUMC4GJAHRGJAHRMJA
ZEILEItem in Material Document MBLPONUMC4MBLPOPOS
EBELNPurchasing Document Number EBELNCHAR10EKKOALPHAEBELNBESMEKK_C
EBELPItem Number of Purchasing Document EBELPNUMC5EKPOEBELPBSP
BPMNGQuantity in Purchase Order Price Unit BPMNGQUAN13(3) MENG13
BPRMEOrder Price Unit (Purchasing) BPRMEUNIT3T006CUNITMEINS
MENGEQuantity MENGE_DQUAN13(3) MENG13
MEINSBase Unit of Measure MEINSUNIT3Assigned to domainCUNITMEINS
WEMPFGoods Recipient/Ship-To Party WEMPFCHAR12WEMPF
ABLADUnloading Point ABLADCHAR25TEXT25
SGTXTItem Text SGTXTCHAR50TEXT50
MIGO_ELIKZ'Delivery Completed' Indicator MIGO_ELIKZNUMC1MIGO_ELIKZ
MRPINDMax. Retail Price Relevant J_1IRMRPINDCHAR1J_1IRMRPIND
VBELNSales and Distribution Document Number VBELNCHAR10Assigned to domainALPHAVBELNAUN
VBELPSales document item VBELPNUMC6Assigned to domainPOSNR

Key field Non-key field



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

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

SELECT SINGLE *
FROM J_1IRAINDTL
INTO CORRESPONDING FIELDS OF WA_J_1IRAINDTL
WHERE...

How to access SAP table J_1IRAINDTL

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