SAP table TCKMLPR_EB (Customizing for Bal. Sheet Valuation: Define Valuation Areas)

SAP table TCKMLPR_EB has 2 primary key fields being MANDT,PRKZG.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
PRKZG Price Name for Ending Inventory/Balance Sheet Valuation CHAR 3 0 CK_PRICE_KZG
PRCID Price Identified for Balance Sheet Valuation Procedure CHAR 2 0 MY_PROCID
F1 Price for FIFO valuation
L4 Price from LIFO valuation for single materials
L5 Price from LIFO valuation for pools
N0 Price from lowest value determination by market prices
N1 Price from devaluation by range of coverage
N2 Price from devaluation by rate of movement
N3 Price from loss-free valuation
N9 Balance sheet price
X1 Average receipt price
METHOD LIFO/FIFO Method CHAR 6 0 TMY02 MYMETHOD
MYVER LIFO Layer Version CHAR 1 0 TMY05 MYVER
FINAL Indicator for Final Result of Balance Sheet Valuation CHAR 1 0 CK_FINAL
Other: Not Relevant in Material Ledger
0 Relevant for Customer-Specific Requirements
B Relevant for Business Add-In for Ending Inventory Val. in ML
C Relevant for External Cumulated Valuation in Material Ledger
M Relevant for Multilevel FIFO Valuation in Material Ledger
X Relevant for External Ending Inventory Valuation in ML
LEDGER Ledger in General Ledger Accounting CHAR 2 0 FINSC_LEDGER FINS_LEDGER

TCKMLPR_EB foreign key relationships

Table Field Check Table Check Field
0 TCKMLPR_EB METHOD TMY02 Balance Sheet Valuation Method (LIFO/FIFO) MANDT
0 TCKMLPR_EB METHOD TMY02 Balance Sheet Valuation Method (LIFO/FIFO) METHOD
1 TCKMLPR_EB MYVER TMY05 Directory for Versions for LIFO Valuation MANDT
1 TCKMLPR_EB MYVER TMY05 Directory for Versions for LIFO Valuation MYKEY