COEPL
CO Object: Line Items for Activity Types (by Period)
COEPL is an SAP database table in S/4HANA. CO Object: Line Items for Activity Types (by Period). It contains 28 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| R_EvtBsdMfgActlOutputQuantity | view_entity | from | BASIC | Event-Based Manufacturing Actual Output Quantity |
Fields (28)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | MANDT | Client | |||
| KEY | kokrs | KOKRS | CO Area | |||
| KEY | belnr | CO_BELNR | Document Number | |||
| KEY | buzei | CO_BUZEI | Posting Row | |||
| perio | CO_PERIO | Period | ||||
| meinh | CO_MEINH_L | Activity unit | ||||
| lstbtr | LSTXX | Activity Qty | ||||
| meinb | CO_MEINB_L | Posted Unit | ||||
| lsbbtr | LSBXX | Posted activity | ||||
| kapbtr | KAPXX | Capacity | ||||
| auseh | AUSEH | Output Unit | ||||
| ausbtr | AUSXX | Output | ||||
| aubeh | CO_MEINB_A | Pos.output unit | ||||
| aubbtr | AUBXX | Post.output qty | ||||
| disbtr | DISXX | Actvty scheduld | ||||
| lednr | LEDNR | Ledger | ||||
| objnr | J_OBJNR | Object number | ||||
| gjahr | GJAHR | Fiscal Year | ||||
| wrttp | CO_WRTTP | Value Type | ||||
| versn | VERSN | Version | ||||
| vrgng | CO_VORGANG | Bus.Transaction | ||||
| sgtxt | CO_SGTXT | Name | ||||
| refbz | CO_REFBZ | Posting Row | ||||
| zlenr | DZLENR | Item | ||||
| aeqbtr | AEQXX | Equivalence no. | ||||
| logsyso | LOGSYSO | Logical System | ||||
| bvaltnr | CKML_ALPROCNR | PrcrmntAlt/Proc | ||||
| pernr | PERNR_D | Personnel No. |
Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.
-- CO Object: Line Items for Activity Types (by Period)
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE COEPL (
MANDT, -- Client [MANDT]
KOKRS, -- CO Area [KOKRS]
BELNR, -- Document Number [CO_BELNR]
BUZEI, -- Posting Row [CO_BUZEI]
PERIO, -- Period [CO_PERIO]
MEINH, -- Activity unit [CO_MEINH_L]
LSTBTR, -- Activity Qty [LSTXX]
MEINB, -- Posted Unit [CO_MEINB_L]
LSBBTR, -- Posted activity [LSBXX]
KAPBTR, -- Capacity [KAPXX]
AUSEH, -- Output Unit [AUSEH]
AUSBTR, -- Output [AUSXX]
AUBEH, -- Pos.output unit [CO_MEINB_A]
AUBBTR, -- Post.output qty [AUBXX]
DISBTR, -- Actvty scheduld [DISXX]
LEDNR, -- Ledger [LEDNR]
OBJNR, -- Object number [J_OBJNR]
GJAHR, -- Fiscal Year [GJAHR]
WRTTP, -- Value Type [CO_WRTTP]
VERSN, -- Version [VERSN]
VRGNG, -- Bus.Transaction [CO_VORGANG]
SGTXT, -- Name [CO_SGTXT]
REFBZ, -- Posting Row [CO_REFBZ]
ZLENR, -- Item [DZLENR]
AEQBTR, -- Equivalence no. [AEQXX]
LOGSYSO, -- Logical System [LOGSYSO]
BVALTNR, -- PrcrmntAlt/Proc [CKML_ALPROCNR]
PERNR, -- Personnel No. [PERNR_D]
PRIMARY KEY (MANDT, KOKRS, BELNR, BUZEI)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA