SAP Table IONRA

General Object Number and Object Keys

IONRA (General Object Number and Object Keys) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link IONRA to other SAP tables.

Source: IONRA (General Object Number and Object Keys)

IONRA table fields

Field Data element Checktable Datatype Length Decimals
OBJNR Object number J_OBJNR CHAR 22 0
OBART Object Type J_OBART CHAR 2 0
RCODE Return code J_RCODE NUMC 1 0
1
ACNUM_INT CHAR 10 0
ACTN Sequential Number of the Change State ESEACTN NUMC 20 0
AENNR Change Number AENNR CHAR 12 0
AETYP Object Category AETYP NUMC 2 0
ANLN1 Main Asset Number ANLN1 CHAR 12 0
ANLN2 Asset Subnumber ANLN2 CHAR 4 0
AOBAR Type of relationship AOBAR CHAR 2 0
AOTYP Reconciliation Object AOTYP CHAR 2 0
01 Profitability Analysis
02 Sales and Operations Planning (obsolete)
03 Long-Term Planning (obsolete)
04 Financial Data (CO) (obsolete)
05 Sales and Operations Planning (KSPP)
06 Long-Term Planning (KSPP)
07 Sales and Operations Planning (KSOP)
08 Long-Term Planning (KSOP)
APLZL General counter for order CO_APLZL NUMC 8 0
APLZL_VOR Internal counter CIM_COUNT NUMC 8 0
APLZL_NCH Internal counter CIM_COUNT NUMC 8 0
AUFNR Order Number AUFNR CHAR 12 0
AUFPL Routing number of operations in the order CO_AUFPL NUMC 10 0
AUFPL_VOR No. identifying the network to which the predecessor belongs AUFPL_VOR NUMC 10 0
AUFPL_NCH No. identifying the network to which the successor belongs AUFPL_NCH NUMC 10 0
BEDID ID of the capacity requirements record BEDID NUMC 12 0
BEDZL Internal counter CIM_COUNT NUMC 8 0
BKKRS CHAR 4 0
BUKRS Company Code BUKRS CHAR 4 0
BWVAR Valuation Variant in Costing CK_BWVAR CHAR 3 0
BZOBJ Reference Object CK_OBJ CHAR 1 0
CANUM Counters for cap. rqmts. records (various caps. + indiv.caps CY_COUNT NUMC 4 0
CLINT Internal Class Number CLINT NUMC 10 0
CO_POSNR Order Item Number CO_POSNR NUMC 4 0
CTYP Certificate Type QZGTYP CHAR 4 0
DOKAR Document Type DOKAR CHAR 3 0
DOKNR Document number DOKNR CHAR 25 0
DOKVR Document Version DOKVR CHAR 2 0
DOKTL Document Part DOKTL_D CHAR 3 0
DPERBEG Start of settlement period VVDPERBEG DATS 8 0
EBELN Purchasing Document Number EBELN CHAR 10 0
EBELP Item Number of Purchasing Document EBELP NUMC 5 0
EBRID Batch record number EBRID CHAR 15 0
EB_VERSION Version of a Batch Record EBR_VERS NUMC 4 0
EINRI CHAR 4 0
EQUNR Equipment Number EQUNR CHAR 18 0
ERKRS Operating concern ERKRS CHAR 4 0
FALNR CHAR 10 0
FICTR Funds Center FM_FICTR CHAR 16 0
FIKRS Financial Management Area FIKRS CHAR 4 0
GSBER Business Area GSBER CHAR 4 0
IBASE IBase: Number of the Installed Base/IBase IB_IBASE NUMC 18 0
INSTANCE IB: Component (instance) IB_INSTANCE NUMC 18 0
IM_GJAHR Approval year of the investment program IM_GNJHR NUMC 4 0
IM_PRNAM Investment program name IM_PRNAM CHAR 8 0
IM_POSNR Position number IM_POSNR NUMC 8 0
IMA_POSNR Internal number for appropriation request IMA_POSNR CHAR 12 0
IMA_VARNT Variant of Appropriation Request IMA_VARNT CHAR 4 0
ISLNR SDB: Solution Number ISLNR CHAR 12 0
ISMNR SDB: Symptom Number ISMNR CHAR 12 0
KADKY Costing Date (Key) CK_KADKY DATS 8 0
KALKA Costing Type CK_KALKA CHAR 2 0
KALN1 Cost Estimate Number - Product Costing CK_KALNR1 NUMC 12 0
KALNR Cost Estimate Number - Product Costing CK_KALNR1 NUMC 12 0
KANTE Number of the link between two technical objects KANTE CHAR 18 0
KKZMA Costs Entered Manually in Additive or Automatic Cost Est. CK_KKZMA CHAR 1 0
X Yes
NULL No
KOKRS Controlling Area KOKRS CHAR 4 0
KOSTL Cost Center KOSTL CHAR 10 0
KSTRG Cost Object KSTRG CHAR 12 0
LSTAR Activity Type LSTAR CHAR 6 0
MANUM Sequence Number LFNDR NUMC 4 0
MATNR Material Number MATNR CHAR 18 0
MIMAX Indicates whether maximum time interval will be considered DAUMIMAX CHAR 1 0
X Yes
NULL No
NORDER Eight-digit numeric value NUM8 NUMC 8 0
NPERSOND Special period to post follow-up costs VVNPERSOND NUMC 2 0
OBJKT Identification of object to be changed AEOBJEKT CHAR 40 0
PAOBJNR Profitability Segment Number (CO-PA) RKEOBJNR NUMC 10 0
PBLNR CHAR 10 0
PHYNR Physical Sample Number QPHYSPRNR CHAR 12 0
POSID Work Breakdown Structure Element (WBS Element) PS_POSID CHAR 24 0
POSNR Sales Document Item POSNR_VA NUMC 6 0
PRCTR Profit Center PRCTR CHAR 10 0
PRUEFLOS Inspection Lot Number QPLOS NUMC 12 0
PRZNR Business Process CO_PRZNR CHAR 12 0
PSPID Project Definition PS_PSPID CHAR 24 0
PSPNR WBS Element PS_POSNR NUMC 8 0
PZLFH Item counter for production resources/tools PZLFH NUMC 8 0
QMNUM Notification No QMNUM CHAR 12 0
RANL Contract Number RANL CHAR 13 0
RBESTO Character Field Length = 10 CHAR10 CHAR 10 0
RBKONT Field of length 16 CHAR16 CHAR 16 0
RECN Sequential Number of Data Record ESERECN NUMC 20 0
RECN32 CHAR 32 0
RECNNR Real Estate Contract Number RECNNR CHAR 13 0
RFHA Character field 13 digits CHAR13 CHAR 13 0
RIDXRT CHAR 20 0
RIDRTEXT CHAR 20 0
RIDBSTD CHAR 20 0
RMZHL Confirmation counter CO_RMZHL NUMC 8 0
ROBJNR CHAR 14 0
RSART Record type RSART CHAR 1 0
RSERVI Character Field Length = 10 CHAR10 CHAR 10 0
RSNUM Number of Reservation/Dependent Requirement RSNUM NUMC 10 0
RSPOS Item Number of Reservation/Dependent Requirement RSPOS NUMC 4 0
RUBEST Character Field Length = 10 CHAR10 CHAR 10 0
RUECK Completion confirmation number for the operation CO_RUECK NUMC 10 0
SAKNR G/L Account Number SAKNR CHAR 10 0
SEMPSL Settlement Unit SEMPSL CHAR 5 0
SGENR Building Number SGENR CHAR 8 0
SGRNR Property Number for BE SGRNR CHAR 8 0
SMENR Number of Rental Unit SMENR CHAR 8 0
SMIVE Lease-Out Number SMIVE CHAR 13 0
SNKSL Service Charge Key SNKSL CHAR 4 0
SOBJART CHAR 2 0
SPEC_NO Number of a Set of Model Service Specifications SPEC_NO CHAR 10 0
SVWNR Management Contract Number VVSVWNR CHAR 13 0
SWENR Site Number SWENR CHAR 8 0
TEILLOS Partial lot number QTLOS NUMC 6 0
TL_PLNTY Task List Type PLNTY CHAR 1 0
TL_PLNNR Key for Task List Group PLNNR CHAR 8 0
TL_PLNAL Group Counter PLNAL CHAR 2 0
TL_ZAEHL Internal counter CIM_COUNT NUMC 8 0
TPLNR Functional Location TPLNR CHAR 30 0
TRPNR Reference functional location TRPNR CHAR 30 0
TVERS Costing Version CK_TVERS NUMC 2 0
VBELN Sales Document VBELN_VA CHAR 10 0
VORLNR Certificate Profile Number QVORLNR CHAR 12 0
VERID Production Version VERID CHAR 4 0
VERSION Version Number of Certificate Profile QCVERSION CHAR 6 0
VSNMR Number or description of a version VSNMR CHAR 12 0
VTNUM_INT CHAR 16 0
WAPOS Maintenance item WAPOS CHAR 16 0
WARPL Maintenance Plan WARPL CHAR 12 0
WERKS Plant WERKS_D CHAR 4 0
WP_RANL Security ID Number VVRANLW CHAR 13 0
ZAEHL Internal Counter for DB Objects Q_COUNT NUMC 6 0
ZEKKN Sequential Number of Account Assignment DZEKKN NUMC 2 0
OBJNR_IW Business entity object number OBJNR_IW CHAR 22 0
OBJNR_IG Property object number OBJNR_IG CHAR 22 0
OBJNR_IB Building object number OBJNR_IB CHAR 22 0
OBJNR_IM Rental unit object number OBJNR_IM CHAR 22 0
OBJNR_IV Lease-Out Object Number OBJNR_IV CHAR 22 0
OBJNR_IC Management contract object number OBJNR_IC CHAR 22 0
OBJNR_IA Object number: settlement unit/cost collector OBJNR_IA CHAR 22 0
OBJNR_IS General RE contract object number OBJNR_IS CHAR 22 0
CU_ID CU: Compatible Unit ID /CUM/CU_ID CHAR 18 0
CMNUM CU: Construction Measure Number /CUM/CMNUM CHAR 12 0
CUGUID GUID in 'CHAR' Format in Uppercase GUID_32 CHAR 32 0
DESGUID GUID in 'CHAR' Format in Uppercase GUID_32 CHAR 32 0
WAPNR Work Approval WCEWAPNR CHAR 12 0
WAPINR Application WCEWAPINR CHAR 12 0
WCNR Work Clearance Document WCEWCNR CHAR 12 0
WCITM Item WCEITM NUMC 6 0
WCTYP Type of WCM Object WCETYP CHAR 1 0
O Operational WCD
T WCD Template
1 WC Application
Z Application (Reference)
2 User-Defined