1. Home
  2. Resources
  3. SAP Tables
  4. COIOB - Conversion of Object Number and Object Data

SAP Table COIOB

Conversion of Object Number and Object Data

COIOB (Conversion of Object Number and Object Data) 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 COIOB to other SAP tables.

Source: COIOB (Conversion of Object Number and Object Data)

COIOB table fields

Field Data element Checktable Datatype Length Decimals
OBJNR Object number J_OBJNR CHAR 22 0
DATBI Valid To Date DATBI DATS 8 0
OBART Object Type J_OBART CHAR 2 0
SCOPE Object Class SCOPE_CV CHAR 2 0
OC Overhead costs
IV Investment
PR Production
PA Profit analysis
AUFNR Order Number AUFNR CHAR 12 0
AFPOS Order Item Number CO_POSNR NUMC 4 0
AUTYP Order category AUFTYP NUMC 2 0
01 Internal Order (Controlling)
02 Accrual Calculation Order (Controlling)
03 Model Order (Controlling)
04 CO Production Order
05 Product Cost Collector
06 QM Order
10 PP Production Order
20 Network
30 Maintenance order
40 Process Order
50 Inspection Lot
60 Personnel Order
70 Shipping deadlines
KOKRS Controlling Area KOKRS CHAR 4 0
KOSTL Cost Center KOSTL CHAR 10 0
LSTAR Activity Type LSTAR CHAR 6 0
KSTRG Cost Object KSTRG CHAR 12 0
PSPNR Work Breakdown Structure Element (WBS Element) PS_PSP_PNR NUMC 8 0
POSID Work Breakdown Structure Element (WBS Element) PS_POSID CHAR 24 0
AUFPL Routing number of operations in the order CO_AUFPL NUMC 10 0
APLZL Internal counter CIM_COUNT NUMC 8 0
BUKRS Company Code BUKRS CHAR 4 0
GSBER Business Area GSBER CHAR 4 0
WERKS Plant WERKS_D CHAR 4 0
OWAER Currency Key OWAER CUKY 5 0
VNAME Joint Venture JV_NAME T8JV CHAR 6 0
RECID Recovery Indicator JV_RECIND T8JJ CHAR 2 0
EGRUP Equity group JV_EGROUP T8JF CHAR 3 0
PRCTR Profit Center PRCTR CHAR 10 0
ZPSPNR Work Breakdown Structure Element (WBS Element) PS_PSP_PNR NUMC 8 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)
VBELN Sales Document VBELN_VA CHAR 10 0
POSNR Sales Document Item POSNR_VA NUMC 6 0
PRZNR Business Process CO_PRZNR CHAR 12 0
HOART Type of origin object (EC-PCA) HOART NUMC 2 0
01 Profit Center
02 Cost Center
03 Overhead Cost Order
04 Production Order
05 Billing Document
06 Sales Order
07 WBS Element
08 Network
09 Network Activity
10 Profitability Segment in Account-Based CO-PA
11 Cost Object
12 Business Process
13 Fixed Asset
14 Material
15 Maintenance Order
16 Maintenance Plan
17 SOP Order
18 G/L Account
19 Material Stocks
20 Investment Order
21 Sales Order
22 Asset Portfolios
23 Work in Process
24 Receivables
25 Payables
26 Assets under Construction
27 Cash Discount
28 Credit Valuation Difference
29 Debit Valuation Difference
31 Net Cash Discounts
32 Tax
33 Planned Orders
34 Profitability Segment in Costing-Based CO-PA
35 Additional Balance Sheet Accounts and P&L Accounts
36 Order Items
38 Settlement Unit
39 Buildings
40 Management Contract
41 Real Estate
42 Rental Unit
43 Lease-Out
44 Business Entity
45 Reconciliation Object
88 Profit Center Costing
98 Reconciliation of Differences
99 Legacy Data from a 2.x Release
46 Real Estate General Contract
ERKRS Operating concern ERKRS CHAR 4 0
PAOBJNR Profitability Segment Number (CO-PA) RKEOBJNR NUMC 10 0
AUART Order Type AUFART CHAR 4 0
COPAR CO Partner Update COPAR CHAR 1 0
N Not active
NULL Semi-active
X Active
PLINT Indicator for Integrated Planning PLINT CHAR 1 0
X Yes
NULL No
XSTAT Statistical Object Indicator CO_XSTAT CHAR 1 0
X TRUE
NULL FALSE
LOGSYSTEM Logical system of object LOGSYSO CHAR 10 0
SWENR Site Number SWENR CHAR 8 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
SEMPSL Settlement Unit SEMPSL CHAR 5 0
SVWNR Management Contract Number VVSVWNR CHAR 13 0
IMKEY Internal Key for Real Estate Object IMKEY CHAR 8 0
DABRZ Reference Date for Settlement DABRBEZ DATS 8 0
RSNUM Number of Reservation/Dependent Requirement RSNUM NUMC 10 0
RSPOS Item Number of Reservation/Dependent Requirement RSPOS NUMC 4 0
RSART Record type RSART CHAR 1 0
RECNNR Real Estate Contract Number RECNNR CHAR 13 0

COIOB foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
COIOB EGRUP SYST MANDT T8JF Investment Group MANDT
COIOB EGRUP COIOB BUKRS T8JF Investment Group BUKRS
COIOB EGRUP COIOB VNAME T8JF Investment Group VNAME
COIOB EGRUP COIOB EGRUP T8JF Investment Group EGRUP
COIOB RECID SYST MANDT T8JJ Recovery Indicator MANDT
COIOB RECID COIOB BUKRS T8JJ Recovery Indicator BUKRS
COIOB RECID COIOB RECID T8JJ Recovery Indicator RECID
COIOB VNAME T000 MANDT T8JV Joint Venture MANDT
COIOB VNAME COIOB BUKRS T8JV Joint Venture BUKRS
COIOB VNAME COIOB VNAME T8JV Joint Venture VNAME