1. Home
  2. Resources
  3. SAP Tables
  4. CKML_S_REORG_ALV_ITEM - ML Period Data Reorganization: Item Data for ALV Output

SAP Table CKML_S_REORG_ALV_ITEM

ML Period Data Reorganization: Item Data for ALV Output

CKML_S_REORG_ALV_ITEM (ML Period Data Reorganization: Item Data for ALV Output) 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 CKML_S_REORG_ALV_ITEM to other SAP tables.

CKML_S_REORG_ALV_ITEM table fields

Field Data element Checktable Datatype Length Decimals
TABNAME Table Name TABNAME CHAR 30 0
KALNR Cost Estimate Number for Cost Est. w/o Qty Structure CK_KALNR NUMC 12 0
BDATJ Posting Date YYYY BDATJ NUMC 4 0
POPER Posting period POPER NUMC 3 0
UNTPER Value Structure Type CK_UNTPER NUMC 3 0
KZ_ABGER Material price will no longer be determined in this period XABGER CHAR 1 0
X Closed
NULL Not Closed
XKONCHK Switch off consistency check CK_XKONCHK CHAR 1 0
NULL Always Check
1 Never Check
5 Invoices and Goods Movements Possible
STATUS Material ledger period status CK_MLSTAT NUMC 2 0
00 Undefined
01 New Objects
10 Period Opened
20 Price Change Completed
30 Quantities and Values Entered
31 Values Entered
40 Price Determined (Single-Level)
50 Price Determined (Multilevel)
60 Closing Entry Reversed
70 Closing Entry Completed
05 Period Without Stock Opened
MEINS Unit of Measure for Material Valuation CKML_MEINS UNIT 3 0
SAPRL Release of SAP System SYSAPRL CHAR 4 0
XERROR Indicates that error(s) occurred during last price determ. CK_XABRERR CHAR 1 0
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
CD_OK Summarization Record MLCD Created Correctly CKML_CD_OK CHAR 1 0
XNEWCCSNEXTMON Regenerate Cost Component Split for Next Period MLCCS_D_XNEWCCSNEXTMON CHAR 1 0
X TRUE
NULL FALSE
XMYMP Determine Receipt Values Status CKML_MYMP CHAR 1 0
X Yes
NULL No
LBKUM Total valuated stock CK_LBKUM QUAN 15 3
UMKUMO Quantity posted to previous period CK_UMKUM QUAN 15 3
ABKUMO Beginning Inventory: Quantity at Start of Period CK_ABKUM QUAN 15 3
ZUKUMO Total quantity of goods received in period CK_ZUKUM QUAN 15 3
SZKUMO Other receipts: quantity (from-value from VPKUMO) CK_SZKUM QUAN 15 3
VPKUMO Other Receipts/Issues: Quantity CK_VPKUM QUAN 15 3
VNKUMO Issues not affecting the price: quantity CK_VNKUM QUAN 15 3
EKKUMO Receipts: Quantity from Purchase Orders (From-Value) CK_EKKUM QUAN 15 3
PBKUMO Receipts: Quantity from Subsequent Adjustments (from value) CK_PBKUM QUAN 15 3
PBPOPO Receipts: Quantity from Sub.Adjustments in period CK_PBPOPO QUAN 15 3
VPPOPO Inputs: Quantity from Subsequent Adjustments (from Value) CK_VPPOPO QUAN 15 3
UMKUMA Amount in the period - posted to a prior period - settled CK_UMKUM_A QUAN 15 3
ZUKUMA Quantity of Goods Recieved in the Period (settled) CK_ZUKUM_A QUAN 15 3
EKKUMA Receipts: Quantity Settled from Purchase Orders (From-Value) CK_EKKUM_A QUAN 15 3
PBKUMA Receipts: Amount settled from subseq. adjustments (frm val.) CK_PBKUM_A QUAN 15 3
CURTP Currency Type and Valuation View CURTP CHAR 2 0
00 Document currency
10 Company code currency
11 Company code currency, group valuation
12 Company code currency, profit center valuation
20 Controlling area currency
30 Group currency
31 Group currency, group valuation
32 Group currency, profit center valuation
40 Hard currency
50 Index-based currency
60 Global company currency
70 Controlling object currency
71 Controlling object currency, group valuation
72 Controlling object currency, profit center valuation
80 Ledger currency
81 Ledger currency, group valuation
82 Ledger currency, profit center valuation
90 Profit center invoice currency
92 Profit center accounting currency, profit center valuation
A0 Financial management area currency
B0 Operating concern currency
B2 Operating concern currency, profit center valuation
C0 Consolidation unit currency
C1 Consolidation unit currency, group valuation
C2 Consolidation unit currency, profit center valuation
PEINH Price unit CK_PEINH_1 DEC 5 0
VPRSV Price control indicator VPRSV CHAR 1 0
S Standard price
V Moving average price/periodic unit price
STPRS Standard price CK_STPRS_1 CURR 11 2
PVPRS Periodic unit price CK_PVPRS_1 CURR 11 2
WAERS Currency Key WAERS CUKY 5 0
SALK3 Value of total valuated stock CK_SALK3_1 CURR 15 2
SALKV Value based on the periodic unit price (only with pr.ctrl S) CK_SALKV_1 CURR 15 2
ZUUMB_O Revaluation Amount CK_ZUUMB_1 CURR 15 2
ABPRD_O Beginning Inventory: Single-Level Price Differences CK_ABPRD CURR 15 2
ABKDM_O Beginning Inventory: Single-Level Exchange Rate Differences CK_ABKDM CURR 15 2
ZUPRD_O Receipts: Single-level price differences CK_ZUABW_1 CURR 15 2
ZUKDM_O Receipts: Single-level exchange rate differences CK_ZUKDM CURR 15 2
VPPRD_O Other receipts/issues: Single-level price differences CK_VPPRD CURR 15 2
VPKDM_O Other receipts/issues:Single-level exchange rate differences CK_VPKDM CURR 15 2
VPPBPRD_O Inputs: Price Differences from Subsequent Adjustments CK_VPPBPRD CURR 15 2
VPPBKDM_O Inputs: Exchange Rate Differences from Sub. Adjustments CK_VPPBKDM CURR 15 2
VNPRD_O 1-Level Price Differences from Issues not Affecting the Pric CK_VNPRD CURR 15 2
VNKDM_O Outward movement not affecting price: 1-lvl exch.rate diff. CK_VNKDM CURR 15 2
EKPRD_O Receipts: Price Differences from Purchase Orders (From-Val.) CK_EKPRD CURR 15 2
EKKDM_O Receipts: Exchange Rate Differences from POs (From-Value) CK_EKKDM CURR 15 2
PBPRD_O Receipts: Price differences from adjustments (from value) CK_PBPRD CURR 15 2
PBKDM_O Receipts: Exchange Rate Differences from Adjustments CK_PBKDM CURR 15 2
VNPRD_EA Single-level adjustment to consumption from price difference CK_VNPRDEA CURR 15 2
VNKDM_EA Single-level adjustment to consumption from ExRt differences CK_VNKDMEA CURR 15 2
EBPRD_EA Single-Level Adjustm. to End. Inv. Due to Price Differences CK_EBPRDEA CURR 15 2
EBKDM_EA Single-level Adjustment to Ending Inv. Due to Exch.Rate Diff CK_EBKDMEA CURR 15 2
ZUUMB_A Revaluation Amount (Not Allocated) CK_ZUUMB_A CURR 15 2
ZUPRD_A Receipts: Single-Level Price Differences (Not Allocated) CK_ZUABW_A CURR 15 2
ZUKDM_A Receipts: Single-Level Exch Rate Differences (Not Allocated) CK_ZUKDM_A CURR 15 2
EKPRD_A Receipts: Price Differences Settled from POs (From-Value) CK_EKPRD_A CURR 15 2
EKKDM_A Receipts: Settld Exch.Rate Differences from POs (From-Value) CK_EKKDM_A CURR 15 2
PBPRD_A Receipts: Pr. Diff. Settled from Sub. Adjust. (from value) CK_PBPRD_A CURR 15 2
PBKDM_A Receipts: ExRtDiff. settled frm sub.adjustments (from value) CK_PBKDM_A CURR 15 2
ABPRD_MO Beginning Inventory: Price Differences from Lower Levels CK_ABPRDMO CURR 15 2
ABKDM_MO Beginning Inventory: Exch.Rate Differences from Lower Levels CK_ABKDMMO CURR 15 2
ZUPRD_MO Receipts: Price Differences from Lower Levels CK_ZUPRDMO CURR 15 2
ZUKDM_MO Receipts: Exchange rate differences from lower level CK_ZUKDMMO CURR 15 2
VNPRD_MA Multilevel adjustment to consumption from price differences CK_VNPRDMA CURR 15 2
VNKDM_MA Multilevel adjustment to consumption from exch. rt. diff. CK_VNKDMMA CURR 15 2
EBPRD_MA Multilevel Adjustment to End. Inv. Due to Price Differences CK_EBPRDMA CURR 15 2
EBKDM_MA Multilevel Adjustment to Ending Inv. Due to Exch. Rate Diff. CK_EBKDMMA CURR 15 2
ABSALK3 Beginning Inventory Value at Time of Period Closing Program CKML_ABSALK3 CURR 15 2
ZUKDM_OST Receipts: Non-Inventory Relevant Exchange Rate Differences CK_ZUKDM_OST CURR 15 2
EKKDM_OST Receipts: Non Inv.-Rel.ERDs from Purchase Orders (Fr.Value) CK_EKKDM_OST CURR 15 2
PBKDM_OST Receipts: Non Inv-Rel. ERDs from Sub. Adjustment (Fr. Value) CK_PBKDM_OST CURR 15 2
VPKDM_OST Other Receipts/Withdrawals: Non Inventory-Rel. ERDs CK_VPKDM_OST CURR 15 2
VPPBKDM_OST Receipts: Non Inv-Rel. ERDs from Sub. Adjustment (Fr.Value) CK_VPPBKDM_OST CURR 15 2
VNKDM_OST Non Inventory-Relevant ERDs from non Price-Affecting Issues CK_VNKDM_OST CURR 15 2
MGTYP Quantity Structure Type CKML_MGTYP CHAR 5 0
GJAHR Fiscal Year GJAHR NUMC 4 0
PERIO Posting period POPER NUMC 3 0
KALNR_IN Procurement Process CKML_N_PROCNR NUMC 12 0
KALNR_BAL Procurement alternative CKML_N_BALTNR NUMC 12 0
KALNR_OUT Cost Estimate Number - Product Costing CK_KALNR1 NUMC 12 0
OTYP_IN Object Type CKML_OTYP CHAR 2 0
BA Procurement Alternative
PR Procurement Process
VA Consumption Alternative
ST Material (Summation Level)
MB Material (Valuation Level)
MK Material (Totals Record: Valuation Area)
LA Activity Type
EB Sales Order Stock
QB Project Stock
OB Vendor Stock
WM WIP Material
WL WIP Activity Type
OTYP_OUT Object Type CKML_OTYP CHAR 2 0
BA Procurement Alternative
PR Procurement Process
VA Consumption Alternative
ST Material (Summation Level)
MB Material (Valuation Level)
MK Material (Totals Record: Valuation Area)
LA Activity Type
EB Sales Order Stock
QB Project Stock
OB Vendor Stock
WM WIP Material
WL WIP Activity Type
MEINH Unit of Measure for Display MEINH UNIT 3 0
OUT_MENGE Quantity of goods received CKML_OUTMENGE QUAN 15 3
MISCH_VERH Mixing Ratio CK_CROSSR DEC 13 3
BWKEY Valuation Area BWKEY CHAR 4 0
WERKS Plant WERKS_D CHAR 4 0
MATNR Material Number MATNR CHAR 18 0
BWTAR Valuation Type BWTAR_D CHAR 10 0
LAST_PDAY Last day of period CKML_RUN_LAST_DAY_OF_PERIOD DATS 8 0
STLAN_PC BOM Usage STLAN CHAR 1 0
STLAL_PC Alternative BOM STALT CHAR 2 0
LOSGR_PC Lot Size for Product Costing CK_LOSGR QUAN 13 3
ALDAT_PC Quantity Structure Date for Costing CK_BRDAT DATS 8 0
MEINS_PC Unit of Measure for Display MEINH UNIT 3 0
BWVAR_PC Valuation Variant in Costing CK_BWVAR CHAR 3 0
BWDAT_PC Valuation Date of a Cost Estimate CK_BWDAT DATS 8 0
PLSCN_PC Planning Scenario of Long-Term Planning PLSCN NUMC 3 0
STATISTIC_PC Statistical Entry (Production Plan) CKML_FLG_STATISTIC_MIX CHAR 1 0
X TRUE
NULL FALSE
KALNR_INMAT Cost Estimate Number - Product Costing CK_KALNR1 NUMC 12 0
KALNR_PRZ Procurement Process CKML_N_PROCNR NUMC 12 0
OTYP_INMAT Object Type CKML_OTYP CHAR 2 0
BA Procurement Alternative
PR Procurement Process
VA Consumption Alternative
ST Material (Summation Level)
MB Material (Valuation Level)
MK Material (Totals Record: Valuation Area)
LA Activity Type
EB Sales Order Stock
QB Project Stock
OB Vendor Stock
WM WIP Material
WL WIP Activity Type
OTYP_PRZ Object Type CKML_OTYP CHAR 2 0
BA Procurement Alternative
PR Procurement Process
VA Consumption Alternative
ST Material (Summation Level)
MB Material (Valuation Level)
MK Material (Totals Record: Valuation Area)
LA Activity Type
EB Sales Order Stock
QB Project Stock
OB Vendor Stock
WM WIP Material
WL WIP Activity Type
IN_MENGE Withdrawal quantity CKML_INMENGE QUAN 15 3
IN_MENGE_FIX Fixed withdrawl quantity (planned quantity structure) CKML_MENGE_FIX QUAN 15 3
TOGBTR Basic Rate - Total CKML_PRICE CURR 11 2
TOFBTR Fixed Basic Rate CKML_PRICE_FIX CURR 11 2
TOGBTRD Price Variance for Each Unit of Measure TOGDELTA CURR 11 2
TOE Price Units in Object Currency TOEXXX NUMC 5 0
BWSTRAT Strategy for Determining an Allocation Price BWSTRAT CHAR 1 0
1 Plan price for the period
2 Plan price as average of all fiscal year periods
3 Plan price as average of remaining periods of fiscal year
4 Actual price of prior period
5 Most up-to-date actual price in the past
6 Most up-to-date plan price
7 Actual price for the period
8 External actual price
9 Frozen price (material ledger)
NO_SETTLE Ind.: Do Not Take Activity Type into Account Upon Pr. Determ CKML_NO_SETTLE CHAR 1 0
X Yes
NULL No
CATEG Category in Material Ledger Data Display CKML_CATEG CHAR 2 0
AB Beginning Inventory
PC Price Changes
ZU Receipts
VP Other Receipts/Consumption
VN Consumption
EB Ending Inventory
NV Not Distributed
KB Cumulative Inventory
NC Not Allocated
PTYP Process category for procurement alt. or consuption alt. CK_PTYP_BVALT CHAR 4 0
BVALT Procurement alternative/process CKML_ALPROCNR NUMC 12 0
ESTPRD Single-Level Price Differences CKML_ESTPRD CURR 15 2
ESTKDM Single-Level Exchange Rate Differences CKML_ESTKDM CURR 15 2
MSTPRD Multilevel Price Differences CKML_MSTPRD CURR 15 2
MSTKDM Multilevel Exchange Rate Differences CKML_MSTKDM CURR 15 2