1. Home
  2. Resources
  3. SAP Tables
  4. COIOP - Object + partner object + object data

SAP Table COIOP

Object + partner object + object data

COIOP (Object + partner object + 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 COIOP to other SAP tables.

COIOP table fields

Field Data element Checktable Datatype Length Decimals
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
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
AUFNR Order Number AUFNR CHAR 12 0
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
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
IMKEY Internal Key for Real Estate Object IMKEY CHAR 8 0
DABRZ Reference Date for Settlement DABRBEZ DATS 8 0
KWAER Controlling area currency KWAER CUKY 5 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
LOGSYSTEM Logical system of object LOGSYSO CHAR 10 0
XSTAT Statistical Object Indicator CO_XSTAT CHAR 1 0
X TRUE
NULL FALSE
POBART Object Type J_OBART CHAR 2 0
PSCOPE Partner object class PSCOPE_CV CHAR 2 0
OC Overhead costs
IV Investment
PR Production
PA Profit analysis
PAUTYP 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
PAUFNR Order Number AUFNR CHAR 12 0
PKOKRS Controlling Area KOKRS CHAR 4 0
PKOSTL Cost Center KOSTL CHAR 10 0
PLSTAR Activity Type LSTAR CHAR 6 0
PKSTRG Cost Object KSTRG CHAR 12 0
PPSPNR Work Breakdown Structure Element (WBS Element) PS_PSP_PNR NUMC 8 0
PAUFPL Routing number of operations in the order CO_AUFPL NUMC 10 0
PAPLZL Internal counter CIM_COUNT NUMC 8 0
PBUKRS Company Code BUKRS CHAR 4 0
PGSBER Business Area GSBER CHAR 4 0
PWERKS Plant WERKS_D CHAR 4 0
PVNAME Joint Venture JV_NAME T8JV CHAR 6 0
PRECID Recovery Indicator JV_RECIND T8JJ CHAR 2 0
PEGRUP Equity group JV_EGROUP T8JF CHAR 3 0
PPRCTR Profit Center PRCTR CHAR 10 0
PZPSPNR Work Breakdown Structure Element (WBS Element) PS_PSP_PNR NUMC 8 0
PAOTYP 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)
PVBELN Sales Document VBELN_VA CHAR 10 0
PPOSNR Sales Document Item POSNR_VA NUMC 6 0
PPRZNR Business Process CO_PRZNR CHAR 12 0
PHOART 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
PERKRS Operating concern ERKRS CHAR 4 0
PPAOBJNR Profitability Segment Number (CO-PA) RKEOBJNR NUMC 10 0
PLOGSYSTEM Logical system of partner object LOGSYSP CHAR 10 0
PXSTAT Statistical Object Indicator CO_XSTAT CHAR 1 0
X TRUE
NULL FALSE
PIMKEY Internal Key for Real Estate Object IMKEY CHAR 8 0

COIOP foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
COIOP EGRUP COIOP EGRUP T8JF Investment Group EGRUP
COIOP EGRUP SYST MANDT T8JF Investment Group MANDT
COIOP EGRUP COIOP BUKRS T8JF Investment Group BUKRS
COIOP EGRUP COIOP VNAME T8JF Investment Group VNAME
COIOP PEGRUP SYST MANDT T8JF Investment Group MANDT
COIOP PEGRUP COIOP PBUKRS T8JF Investment Group BUKRS
COIOP PEGRUP COIOP PVNAME T8JF Investment Group VNAME
COIOP PEGRUP COIOP PEGRUP T8JF Investment Group EGRUP
COIOP PRECID SYST MANDT T8JJ Recovery Indicator MANDT
COIOP PRECID COIOP PBUKRS T8JJ Recovery Indicator BUKRS
COIOP PRECID COIOP PRECID T8JJ Recovery Indicator RECID
COIOP PVNAME SYST MANDT T8JV Joint Venture MANDT
COIOP PVNAME COIOP PBUKRS T8JV Joint Venture BUKRS
COIOP PVNAME COIOP PVNAME T8JV Joint Venture VNAME
COIOP RECID SYST MANDT T8JJ Recovery Indicator MANDT
COIOP RECID COIOP BUKRS T8JJ Recovery Indicator BUKRS
COIOP RECID COIOP RECID T8JJ Recovery Indicator RECID
COIOP VNAME COIOP VNAME T8JV Joint Venture VNAME
COIOP VNAME SYST MANDT T8JV Joint Venture MANDT
COIOP VNAME COIOP BUKRS T8JV Joint Venture BUKRS