- Home
- Resources
- SAP Tables
- CKML2 - Material Ledger Header Record (Release 3.xx)
SAP Table CKML2
Material Ledger Header Record (Release 3.xx)
CKML2 (Material Ledger Header Record (Release 3.xx)) 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 CKML2 to other SAP tables.
Source: CKML2 (Material Ledger Header Record (Release 3.xx))
CKML2 table fields
| Field |
Data element |
Checktable |
Datatype |
Length |
Decimals |
|
| MANDT |
Client |
MANDT |
T000
|
CLNT |
|
3 |
0 |
|
| KALNR |
Cost Estimate Number for Cost Est. w/o Qty Structure |
CK_KALNR |
|
NUMC |
|
12 |
0 |
|
| MATLED |
Material ledger type |
CK_MATLED |
TCKM1
|
CHAR |
|
4 |
0 |
|
| BWKEY |
Valuation Area |
BWKEY |
T001K
|
CHAR |
|
4 |
0 |
|
| BWTAR |
Valuation Type |
BWTAR_D |
T149D
|
CHAR |
|
10 |
0 |
|
| MATNR |
Material Number |
MATNR |
MARA
|
CHAR |
|
18 |
0 |
|
| XABRECH |
Movements have Occurred Since the Last Price Determination |
CK_XABRECH |
|
CHAR |
|
1 |
0 |
Possible values
|
| ABRECHDAT |
Date of Last Successful Price Determination |
CK_ABRDAT |
|
DATS |
|
8 |
0 |
|
| XABRERR |
Indicates that error(s) occurred during last price determ. |
CK_XABRERR |
|
CHAR |
|
1 |
0 |
Possible values
| NULL |
No error |
| B |
Valuation inconsistent |
| I |
Error in RW interface |
| K |
Account not found |
| M |
Material not found |
| N |
Price will be negative |
| P |
Price change not allowed: too high |
| S |
Material is blocked |
| Z |
Other error |
|
| XSPRS |
ID: standard cost estimate marked |
CK_XSPRS |
|
CHAR |
|
1 |
0 |
Possible values
|
| SPRSDAT |
Date from which planned S-price is to be valid |
CK_SPRSDAT |
|
DATS |
|
8 |
0 |
|
| SPRSDAT_2 |
Date from which planned S-price is to be valid |
CK_SPRSDAT |
|
DATS |
|
8 |
0 |
|
| SPRSDAT_3 |
Date from which planned S-price is to be valid |
CK_SPRSDAT |
|
DATS |
|
8 |
0 |
|
| XZPRS |
Indicates that future price has been set |
CK_XZPRS |
|
CHAR |
|
1 |
0 |
Possible values
|
| ZPRSDAT |
Date from which a future valuation price is to be valid |
CK_ZPRSDAT |
|
DATS |
|
8 |
0 |
|
| ZPRSDAT_2 |
Date from which a future valuation price is to be valid |
CK_ZPRSDAT |
|
DATS |
|
8 |
0 |
|
| ZPRSDAT_3 |
Date from which a future valuation price is to be valid |
CK_ZPRSDAT |
|
DATS |
|
8 |
0 |
|
| ZPLPR_1 |
Future planned price |
DZPLPR |
|
CURR |
|
11 |
2 |
|
| ZPLPR_2 |
Future planned price |
DZPLPR |
|
CURR |
|
11 |
2 |
|
| ZPLPR_3 |
Future planned price |
DZPLPR |
|
CURR |
|
11 |
2 |
|
| ZKPRS_1 |
Future price |
DZKPRS |
|
CURR |
|
11 |
2 |
|
| ZKPRS_2 |
Future price |
DZKPRS |
|
CURR |
|
11 |
2 |
|
| ZKPRS_3 |
Future price |
DZKPRS |
|
CURR |
|
11 |
2 |
|
| ABRECHUHR |
Time of Last Sucessful Price Determination |
CK_ABRUHR |
|
TIMS |
|
6 |
0 |
|
CKML2 foreign key relationships
| Table |
Field |
Foreign key table |
Foreign key field |
Check table |
Check field |
| CKML2 |
BWKEY |
CKML2 |
MANDT |
T001K |
Valuation area |
MANDT |
| CKML2 |
BWKEY |
CKML2 |
BWKEY |
T001K |
Valuation area |
BWKEY |
| CKML2 |
BWTAR |
CKML2 |
MANDT |
T149D |
Global Valuation Types |
MANDT |
| CKML2 |
BWTAR |
CKML2 |
BWTAR |
T149D |
Global Valuation Types |
BWTAR |
| CKML2 |
MANDT |
CKML2 |
MANDT |
T000 |
Clients |
MANDT |
| CKML2 |
MATLED |
CKML2 |
MANDT |
TCKM1 |
Material Ledger Table |
MANDT |
| CKML2 |
MATLED |
CKML2 |
MATLED |
TCKM1 |
Material Ledger Table |
MATLED |
| CKML2 |
MATNR |
CKML2 |
MANDT |
MARA |
General Material Data |
MANDT |
| CKML2 |
MATNR |
CKML2 |
MATNR |
MARA |
General Material Data |
MATNR |
