CKMLPR_EB
Preise für Endbestands-/Bilanzbewertung
CKMLPR_EB is an SAP database table in S/4HANA. Preise für Endbestands-/Bilanzbewertung. It contains 18 fields. 1 CDS views read from this table.
CDS Views using this table (1)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| P_ValnPriceCategoryPrice | view | from | BASIC | Prices of Valuation Price Categories |
Fields (18)
| Key | Field | Data Element | Description | Domain | Type | Length |
|---|---|---|---|---|---|---|
| KEY | mandt | mandt | Client | |||
| KEY | kalnr | ck_kalnr | Cost EstimateNo | |||
| KEY | bdatj | bdatj | Year | |||
| KEY | poper | poper | Posting Period | |||
| KEY | untper | ck_untper | Value Type | |||
| KEY | prkzg | ck_price_kzg | Valuation Alt. | |||
| KEY | curtp | curtp | Crcy type/val. | |||
| waers | waers | Currency | ||||
| final | ck_final | Final Result | ||||
| salk3 | ck_salk3_1 | Inventory Value | ||||
| lbkum | lbkum | Total Stock | ||||
| meins | meins | Base Unit | ||||
| price | ck_eiprice | Price for Ending Inv | ||||
| peinh | peinh | Price unit | ||||
| prgid | my_progid | Program ID | ||||
| timel | tzntstmpll | Local TS | ||||
| salk3_inv | ck_salk3_1 | Inventory Value | ||||
| lbkum_inv | lbkum | Total Stock |
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.
-- Preise für Endbestands-/Bilanzbewertung
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE CKMLPR_EB (
MANDT, -- Client [mandt]
KALNR, -- Cost EstimateNo [ck_kalnr]
BDATJ, -- Year [bdatj]
POPER, -- Posting Period [poper]
UNTPER, -- Value Type [ck_untper]
PRKZG, -- Valuation Alt. [ck_price_kzg]
CURTP, -- Crcy type/val. [curtp]
WAERS, -- Currency [waers]
FINAL, -- Final Result [ck_final]
SALK3, -- Inventory Value [ck_salk3_1]
LBKUM, -- Total Stock [lbkum]
MEINS, -- Base Unit [meins]
PRICE, -- Price for Ending Inv [ck_eiprice]
PEINH, -- Price unit [peinh]
PRGID, -- Program ID [my_progid]
TIMEL, -- Local TS [tzntstmpll]
SALK3_INV, -- Inventory Value [ck_salk3_1]
LBKUM_INV, -- Total Stock [lbkum]
PRIMARY KEY (MANDT, KALNR, BDATJ, POPER, UNTPER, PRKZG, CURTP)
);
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