SAP table IONRA (General Object Number and Object Keys)

SAP table IONRA has 4 primary key fields being OBJNR,BEDID,BEDZL,CANUM.

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