The COOI_PI table in SAP ERP or S/4HANA stores BW CO-OM: Commitment Management: Deleted Line Items data. There are total 51 fields in COOI_PI table. The BW CO-OM: Commitment Management: Deleted Line Items table is available in all major SAP S/4HANA versions, is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of COOI_PI table. It is in CO-OM-IS: BW Extractors AddOn 1.2Bff (KBWOM) ABAP package and is part of the Information System, iViews (CO-OM-IS) module.
SAP COOI_PI Table Fields
Following is the list of fields that are available in SAP COOI_PI table. The primary key fields of the table are MANDT (Client), REFBT (Reference Document Category (Conversion Exit), REFBN (Reference Document Number), RFPOS (Item Number of Reference Document), RFKNT (Account Assignment Number of Reference Document), RFTRM (Deadline Item of Reference Document), RFART (Reference Document Type), LIFNR (Account Number of Vendor or Creditor), LEDNR (Ledger for Controlling Objects), OBJNR (Object number), HRKFT (CO key subnumber), RFORG (Reference Organizational Units), RFTYP (Reference procedure), RFSYS (Logical system of source document).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT (3) |
| REFBT | Reference Document Category (Conversion Exit | CO_REFBTYP | NUMC (3) | |
| REFBN | Reference Document Number | CO_REFBN | CHAR (10) | |
| RFPOS | Item Number of Reference Document | CC_RFPOS | NUMC (5) | |
| RFKNT | Account Assignment Number of Reference Document | CC_RFKNT | NUMC (5) | |
| RFTRM | Deadline Item of Reference Document | CC_RFTRM | NUMC (5) | |
| RFART | Reference Document Type | CC_RFART | CHAR (1) | |
| LIFNR | Account Number of Vendor or Creditor | LIFNR | CHAR (10) | |
| LEDNR | Ledger for Controlling Objects | LEDNR | CHAR (2) | |
| OBJNR | Object number | J_OBJNR | CHAR (22) | |
| HRKFT | CO key subnumber | CO_SUBKEY | CHAR (14) | |
| RFORG | Reference Organizational Units | AWORG | CHAR (10) | |
| RFTYP | Reference procedure | AWTYP | CHAR (5) | |
| RFSYS | Logical system of source document | AWSYS | CHAR (10) | |
| VRGNG | CO Business Transaction | CO_VORGANG | CHAR (4) | |
| GJAHR | Fiscal Year | GJAHR | NUMC (4) | |
| WRTTP | Value Type | CO_WRTTP | CHAR (2) | |
| VERSN | Version | VERSN | CHAR (3) | |
| SAKTO | Cost element | SAKTO | CHAR (10) | |
| VBUND | Company ID of Trading Partner | RASSC | CHAR (6) | |
| PARGB | Trading partner’s business area | PARGB | CHAR (4) | |
| BEKNZ | Debit/credit indicator | BEKNZ | CHAR (1) | |
| TWAER | Transaction Currency | TWAER | CUKY (5) | |
| UNAME | User Name | UNAME | CHAR (12) | |
| BLDAT | Document Date | CO_BLDAT | DATS (8) | |
| BUDAT | Expected Debit Date | CO_PODAT | DATS (8) | |
| PERIO | Period | CO_PERIO | NUMC (3) | |
| BUKRS | Company Code | BUKRS | CHAR (4) | |
| KOKRS | Controlling Area | KOKRS | CHAR (4) | |
| MATNR | Material Number | MATNR | CHAR (40) | |
| MATKL | Material Group | MATKL | CHAR (9) | |
| SGTXT | Segment text | CO_SGTXT | CHAR (50) | |
| GESMNG | Planned Quantity | MENGE1 | QUAN (15) | |
| MEINH | Unit of Measure | CO_MEINH | UNIT (3) | |
| MEGBTR | Total Quantity | MEGXXX | QUAN (15) | |
| MBGBTR | Total quantity entered | MBGXXX | QUAN (15) | |
| MEINB | Posted Unit of Measure | MEINB | UNIT (3) | |
| WKURS | Exchange Rate | WKURS | DEC (9) | |
| ORGWTH | Planned Value in Local Currency | WERTH1 | CURR (23) | |
| WHGBTR | Total Value in Local Currency | WHGXXX | CURR (23) | |
| ORGWTK | Planned Value in Controlling Area Currency | WERTK1 | CURR (23) | |
| WKGBTR | Total Value in Controlling Area Currency | WKGXXX | CURR (23) | |
| ORGWTT | Planned Value in Transaction Currency | WERTT1 | CURR (23) | |
| WTGBTR | Total Value in Transaction Currency | WTGXXX | CURR (23) | |
| ORGWTO | Planned Value in Object Currency | WERTO1 | CURR (23) | |
| WOGBTR | Total Value in Object Currency | WOGXXX | CURR (23) | |
| ORGWTL | Planned Value in Ledger Currency | WERTL1 | CURR (23) | |
| WLGBTR | Total value in ledger currency | WLGXXX | CURR (23) | |
| LOEKZ | Deletion indicator in purchasing document | ELOEK | CHAR (1) | |
| DABRZ | Reference date for settlement | DABRBEZ | DATS (8) | |
| TIMESTMP | Seconds since 1.1.1990,0:00 GMT * 10000 | RKE_TSTMP | DEC (16) |
