1. Home
  2. Resources
  3. SAP Tables
  4. MLXXV - Generated Table for View

SAP Table MLXXV

Generated Table for View

MLXXV (Generated Table for View) 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 MLXXV to other SAP tables.

MLXXV table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
BELNR Number of a Material Ledger Document/Price Change Document CK_BELNR CHAR 10 0
KJAHR Material Ledger Document/Price Change Document: Storage Year CK_KJAHR NUMC 4 0
POSNR Item in Material Ledger Document CK_MLPOS NUMC 6 0
BDATJ Posting Date YYYY BDATJ NUMC 4 0
POPER Posting period POPER NUMC 3 0
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
VGART Material ledger: transaction type CK_VGART CHAR 2 0
CL Material Ledger Settlement
UP Material Ledger Update
PC Price Change
DC Debit/Credit Material
ST Single-Level Price Determination
MS Multilevel Price Determination
MI Input Material (Multilevel Price Determination)
MO Output Material (Multilevel Price Determination)
MB Beginning Inventory (Multilevel Price Determination)
MC Input Material: Currency Types Of Outputs (Multilvl Pr.Det.)
RE Material Ledger Repair
AT ML Update - Activity Consumption
AC Input-Activity Type/ABC Process (Multilevel Pr. Determ.)
CC Alternatice Valuation Run Closing
RC Revaluation of Consumption
RO Revaluation of Consumption to Original Account Assignment
RS Revaluation of Consumption to Collective Account Assignment
MA Manual Change of Actual Cost Component Splits
OC New Valuation Logical Inventory (Only IS-Oil)
WC WIP: Input Material: Currency Type Output
WI WIP: Input Material (Multilevel Price Determination)
WL WIP: Input Activity Type/ABC Process (Multilevel)
WP WIP Revaluation
WQ WIP Quantity Document (WIP Determination)
W1 Material (Total WIP Revaluation)
W2 Material (Process WIP Revaluation)
W3 Activity Type (Total WIP Revaluation)
W4 Activity Type (Process WIP Revaluation)
AL Activity Type/ABC Process Closing
MY Delta Posting Balance Sheet Valuation
UMBEW The materials should be revaluated CK_UMBEWERTEN CHAR 1 0
X Yes
NULL No
MATNR Material Number MATNR MARA CHAR 18 0
BWTAR Valuation Type BWTAR_D T149D CHAR 10 0
BWKEY Valuation Area BWKEY T001K CHAR 4 0
VBELN Sales and Distribution Document Number VBELN CHAR 10 0
VBELP Item number of the SD document POSNR NUMC 6 0
PSPNR Work Breakdown Structure Element (WBS Element) PS_PSP_PNR NUMC 8 0
LIFNR Account Number of Vendor or Creditor LIFNR CHAR 10 0
KALNR Cost Estimate Number for Cost Est. w/o Qty Structure CK_KALNR NUMC 12 0
LBKUM Quantity by which the total valuated inventory has changed CK_LBKUMD QUAN 15 3
MEINS Unit of Measure for Material Valuation CKML_MEINS T006 UNIT 3 0
PSART Item type in material ledger document CK_PSART CHAR 2 0
CL Material Ledger Settlement
UP Material Ledger Update
PC Price Change
DC Debit/Credit Material
ST Single-Level Price Determination
MS Multilevel Price Determination
MI Input Material (Multilevel Price Determination)
MO Output Material (Multilevel Price Determination)
MB Beginning Inventory (Multilevel Price Determination)
MC Input Material: Currency Types Of Outputs (Multilvl Pr.Det.)
RE Material Ledger Repair
AT ML Update - Activity Consumption
AC Input-Activity Type/ABC Process (Multilevel Pr. Determ.)
CC Alternatice Valuation Run Closing
RC Revaluation of Consumption
RO Revaluation of Consumption to Original Account Assignment
RS Revaluation of Consumption to Collective Account Assignment
MA Manual Change of Actual Cost Component Splits
OC New Valuation Logical Inventory (Only IS-Oil)
WC WIP: Input Material: Currency Type Output
WI WIP: Input Material (Multilevel Price Determination)
WL WIP: Input Activity Type/ABC Process (Multilevel)
WP WIP Revaluation
WQ WIP Quantity Document (WIP Determination)
W1 Material (Total WIP Revaluation)
W2 Material (Process WIP Revaluation)
W3 Activity Type (Total WIP Revaluation)
W4 Activity Type (Process WIP Revaluation)
AL Activity Type/ABC Process Closing
MY Delta Posting Balance Sheet Valuation
SALK3 Amount by which the total valuated inventory changes CK_SALK3D CURR 15 2
WAERS Currency Key WAERS TCURC CUKY 5 0
CPUDT Day On Which Accounting Document Was Entered CPUDT DATS 8 0
CPUTM Time of Entry CPUTM TIMS 6 0
USNAM User name USNAM CHAR 12 0
STORNO Indicator: material ledger reversal document CK_STORNO CHAR 1 0
X Yes
NULL No
MLAST Material Price Determination: Control CK_ML_ABST CHAR 1 0
2 Transaction-Based
3 Single-/Multilevel
BUDAT Posting Date in the Document BUDAT DATS 8 0
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
XABRERR 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
SOBKZ Special Stock Indicator SOBKZ CHAR 1 0

MLXXV foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
MLXXV BWKEY MLXXV BWKEY T001K Valuation area BWKEY
MLXXV BWKEY MLXXV MANDT T001K Valuation area MANDT
MLXXV BWTAR MLXXV MANDT T149D Global Valuation Types MANDT
MLXXV BWTAR MLXXV BWTAR T149D Global Valuation Types BWTAR
MLXXV MANDT MLXXV MANDT T000 Clients MANDT
MLXXV MATNR MLXXV MANDT MARA General Material Data MANDT
MLXXV MATNR MLXXV MATNR MARA General Material Data MATNR
MLXXV MEINS MLXXV MANDT T006 Units of Measurement MANDT
MLXXV MEINS MLXXV MEINS T006 Units of Measurement MSEHI
MLXXV WAERS MLXXV WAERS TCURC Currency Codes WAERS
MLXXV WAERS MLXXV MANDT TCURC Currency Codes MANDT