P_Materialledger_Cube_Lit

Material Ledger Cube for line Items | view: PMLCUBELIT | Extraction: Not supported | Component: Information System
Tables used: CKMLCR, ACDOCA, ACDOCD, FMLT_PRICE, FINSC_LEDGER, FINSC_LEDGER_T, MARA, T023, CKMLHD, EBEW, MBEW, OBEW, QBEW, FINSC_CURTYPE, FINSC_CURTYPET, FINSC_LEDGER, FINSC_ACTVE_APPL, FINSC_LEDGER_REP, FINSC_LEDGER_REP, FINSC_LD_CMP, FINSC_FISC_DATE, FINSC_PERIOD, FMLC_TOGGLE, FMLT_CURTP_ML
Column Name Description
SourceLedger FK Source Ledger
CompanyCode FK Company Code
Ledger FK Ledger
GLAccount FK G/L Account
FiscalYear Fiscal Year
AccountingDocument Journal Entry
LedgerGLLineItem Ledger Journal Entry Item
Material FK Material Number
CostEstimate Cost Estimate
Column Name Description
💲 Company Code Currency (CompanyCodeCurrency):
AmountInCompanyCodeCurrency Amount in Company Code Currency
SlsPriceAmountInCoCodeCrcy Value at Sales Price in Local Currency
💲 Global Currency (GroupCurrency):
AmountInGroupCurrency Amount in Global Currency
💲 Freely Defined Currency 1 (FreeDefinedCurrency1):
AmountInFreeDefinedCurrency1 Amount in Freely Defined Currency 1
💲 Freely Defined Currency 2 (FreeDefinedCurrency2):
AmountInFreeDefinedCurrency2 Amount in Freely Defined Currency 2
💲 Freely Defined Currency 3 (FreeDefinedCurrency3):
AmountInFreeDefinedCurrency3 Amount in Freely Defined Currency 3
💲 Freely Defined Currency 4 (FreeDefinedCurrency4):
AmountInFreeDefinedCurrency4 Amount in Freely Defined Currency 4
💲 Freely Defined Currency 5 (FreeDefinedCurrency5):
AmountInFreeDefinedCurrency5 Amount in Freely Defined Currency 5
💲 Freely Defined Currency 6 (FreeDefinedCurrency6):
AmountInFreeDefinedCurrency6 Amount in Freely Defined Currency 6
💲 Freely Defined Currency 7 (FreeDefinedCurrency7):
AmountInFreeDefinedCurrency7 Amount in Freely Defined Currency 7
💲 Freely Defined Currency 8 (FreeDefinedCurrency8):
AmountInFreeDefinedCurrency8 Amount in Freely Defined Currency 8
Column Name Description
📏 Cost Source Unit (BaseUnit):
InventoryQty Inventory Quantity
Column Name Description
PostingDate Posting Date
MatlDocLatestPostgDate Posting Date
DocumentDate Journal Entry Date
Column Name Description
MaterialLedgerCategory Category in Material Update Structure Show values
IsSupplierStockValuation Vendor Stock Valuation Indicator Show values
InventorySpecialStockValnType Inventory Special Stock Valuation Type Show values
MaterialPriceControl Price control indicator Show values
Column Name Description Domain name
FiscalPeriod Fiscal Period POPER
LedgerFiscalYear Ledger Fiscal Year GJAHR
ReferenceDocument Reference document number AWREF
LastChangeDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
FiscalYearPeriod Fiscal Year Period FIS_JAHRPER_CONV
TransactionTypeDetermination Transaction Key CHAR3
MaterialGroup Product Group MATKL
InventorySpclStkSalesDocument Sales Document Number of Valuated Special Inventory VBELN
InventorySpclStkSalesDocItm Sales Document Item Number of Valuated Special Inventory POSNR
WBSElementInternalID WBS Element (internal) of Valuated Special Inventory PS_POSNR
InventorySpecialStockSupplier Supplier of Inventory Special Stock LIFNR
CompanyCodeCurrencyRole Currency Type of Currency 1 FINS_CURTYPE
CurrencyRole Currency Type of Currency 2 FINS_CURTYPE
FreeDefinedCurrency1Role Currency Type of Freely Defined Currency 1 FINS_CURTYPE
FreeDefinedCurrency2Role Currency Type of Freely Defined Currency 2 FINS_CURTYPE
FreeDefinedCurrency3Role Currency Type of Third Freely Defined Currency FINS_CURTYPE
FreeDefinedCurrency4Role Currency Type of Freely Defined Currency 4 FINS_CURTYPE
FreeDefinedCurrency5Role Currency Type of Freely Defined Currency 5 FINS_CURTYPE
FreeDefinedCurrency6Role Currency Type of Freely Defined Currency 6 FINS_CURTYPE
FreeDefinedCurrency7Role Currency Type of Freely Defined Currency 7 FINS_CURTYPE
FreeDefinedCurrency8Role Currency Type of Freely Defined Currency 8 FINS_CURTYPE
Master Data Relations Join Conditions
Journal Entry Type
  • Journal Entry Type
  • Client
  • P_MATERIALLEDGER_CUBE_LIT.ACCOUNTINGDOCUMENTTYPE == T003.BLART
  • P_MATERIALLEDGER_CUBE_LIT.MANDT == T003.MANDT
Cost Source Unit
  • Cost Source Unit
  • Client
  • P_MATERIALLEDGER_CUBE_LIT.BASEUNIT == T006.MSEHI
  • P_MATERIALLEDGER_CUBE_LIT.MANDT == T006.MANDT
Business Transaction Category
  • Business Transaction Category
  • Client
  • P_MATERIALLEDGER_CUBE_LIT.BUSINESSTRANSACTIONTYPE == FINSC_BTTYPE.BTTYPE
  • P_MATERIALLEDGER_CUBE_LIT.MANDT == FINSC_BTTYPE.MANDT
Chart of Accounts
  • Chart of Accounts
  • Client
  • P_MATERIALLEDGER_CUBE_LIT.CHARTOFACCOUNTS == T004.KTOPL
  • P_MATERIALLEDGER_CUBE_LIT.MANDT == T004.MANDT
Company Code
  • Company Code
  • Client
  • P_MATERIALLEDGER_CUBE_LIT.COMPANYCODE == T001.BUKRS
  • P_MATERIALLEDGER_CUBE_LIT.MANDT == T001.MANDT
Company Code Currency
  • Client
  • Company Code Currency
  • P_MATERIALLEDGER_CUBE_LIT.MANDT == TCURC.MANDT
  • P_MATERIALLEDGER_CUBE_LIT.COMPANYCODECURRENCY == TCURC.WAERS
Controlling Area
  • Controlling Area
  • Client
  • P_MATERIALLEDGER_CUBE_LIT.CONTROLLINGAREA == TKA01.KOKRS
  • P_MATERIALLEDGER_CUBE_LIT.MANDT == TKA01.MANDT
Cost Center
  • Cost Center
  • ?
  • Controlling Area
  • Client
  • P_MATERIALLEDGER_CUBE_LIT.COSTCENTER == CSKS.KOSTL
  • P_MATERIALLEDGER_CUBE_LIT.[column in domain "DATBI"] == CSKS.DATBI
  • P_MATERIALLEDGER_CUBE_LIT.CONTROLLINGAREA == CSKS.KOKRS
  • P_MATERIALLEDGER_CUBE_LIT.MANDT == CSKS.MANDT
Freely Defined Currency 1
  • Freely Defined Currency 1
  • Client
  • P_MATERIALLEDGER_CUBE_LIT.FREEDEFINEDCURRENCY1 == TCURC.WAERS
  • P_MATERIALLEDGER_CUBE_LIT.MANDT == TCURC.MANDT
Freely Defined Currency 2
  • Client
  • Freely Defined Currency 2
  • P_MATERIALLEDGER_CUBE_LIT.MANDT == TCURC.MANDT
  • P_MATERIALLEDGER_CUBE_LIT.FREEDEFINEDCURRENCY2 == TCURC.WAERS
Freely Defined Currency 3
  • Freely Defined Currency 3
  • Client
  • P_MATERIALLEDGER_CUBE_LIT.FREEDEFINEDCURRENCY3 == TCURC.WAERS
  • P_MATERIALLEDGER_CUBE_LIT.MANDT == TCURC.MANDT
Freely Defined Currency 4
  • Freely Defined Currency 4
  • Client
  • P_MATERIALLEDGER_CUBE_LIT.FREEDEFINEDCURRENCY4 == TCURC.WAERS
  • P_MATERIALLEDGER_CUBE_LIT.MANDT == TCURC.MANDT
Freely Defined Currency 5
  • Freely Defined Currency 5
  • Client
  • P_MATERIALLEDGER_CUBE_LIT.FREEDEFINEDCURRENCY5 == TCURC.WAERS
  • P_MATERIALLEDGER_CUBE_LIT.MANDT == TCURC.MANDT
Freely Defined Currency 6
  • Client
  • Freely Defined Currency 6
  • P_MATERIALLEDGER_CUBE_LIT.MANDT == TCURC.MANDT
  • P_MATERIALLEDGER_CUBE_LIT.FREEDEFINEDCURRENCY6 == TCURC.WAERS
Freely Defined Currency 7
  • Freely Defined Currency 7
  • Client
  • P_MATERIALLEDGER_CUBE_LIT.FREEDEFINEDCURRENCY7 == TCURC.WAERS
  • P_MATERIALLEDGER_CUBE_LIT.MANDT == TCURC.MANDT
Freely Defined Currency 8
  • Client
  • Freely Defined Currency 8
  • P_MATERIALLEDGER_CUBE_LIT.MANDT == TCURC.MANDT
  • P_MATERIALLEDGER_CUBE_LIT.FREEDEFINEDCURRENCY8 == TCURC.WAERS
G/L Account
  • G/L Account
  • Company Code
  • Client
  • P_MATERIALLEDGER_CUBE_LIT.GLACCOUNT == SKB1.SAKNR
  • P_MATERIALLEDGER_CUBE_LIT.COMPANYCODE == SKB1.BUKRS
  • P_MATERIALLEDGER_CUBE_LIT.MANDT == SKB1.MANDT
Global Currency
  • Global Currency
  • Client
  • P_MATERIALLEDGER_CUBE_LIT.GROUPCURRENCY == TCURC.WAERS
  • P_MATERIALLEDGER_CUBE_LIT.MANDT == TCURC.MANDT
Valuation area/valuation category
  • Valuation area
  • Valuation Category
  • Client
  • P_MATERIALLEDGER_CUBE_LIT.VALUATIONAREA == T149.BWKEY
  • P_MATERIALLEDGER_CUBE_LIT.INVENTORYVALUATIONCATEGORY == T149.BWTTY
  • P_MATERIALLEDGER_CUBE_LIT.MANDT == T149.MANDT
Valuation Type
  • Valuation Type
  • Client
  • P_MATERIALLEDGER_CUBE_LIT.INVENTORYVALUATIONTYPE == T149D.BWTAR
  • P_MATERIALLEDGER_CUBE_LIT.MANDT == T149D.MANDT
Ledger
  • Ledger
  • Source Ledger
  • Client
Material Number
  • Client
  • Material Number
  • P_MATERIALLEDGER_CUBE_LIT.MANDT == MARA.MANDT
  • P_MATERIALLEDGER_CUBE_LIT.MATERIAL == MARA.MATNR
Original Process Category P_MATERIALLEDGER_CUBE_LIT.MATERIALLEDGERPROCESSTYPE == CKMLMV009.PTYP
Valuation Class
  • Valuation Class
  • Client
  • P_MATERIALLEDGER_CUBE_LIT.MATERIALVALUATIONCLASS == T025.BKLAS
  • P_MATERIALLEDGER_CUBE_LIT.MANDT == T025.MANDT
Plant
  • Plant
  • Client
  • P_MATERIALLEDGER_CUBE_LIT.PLANT == T001W.WERKS
  • P_MATERIALLEDGER_CUBE_LIT.MANDT == T001W.MANDT
Order ID
  • Order ID
  • Client
  • P_MATERIALLEDGER_CUBE_LIT.PRODUCTIONORDER == AUFK.AUFNR
  • P_MATERIALLEDGER_CUBE_LIT.MANDT == AUFK.MANDT
Profit Center
  • Profit Center
  • ?
  • Controlling Area
  • Client
  • P_MATERIALLEDGER_CUBE_LIT.PROFITCENTER == CEPC.PRCTR
  • P_MATERIALLEDGER_CUBE_LIT.[column in domain "DATBI"] == CEPC.DATBI
  • P_MATERIALLEDGER_CUBE_LIT.CONTROLLINGAREA == CEPC.KOKRS
  • P_MATERIALLEDGER_CUBE_LIT.MANDT == CEPC.MANDT
Reference Document Type P_MATERIALLEDGER_CUBE_LIT.REFERENCEDOCUMENTTYPE == TTYP.AWTYP
Segment for Segmental Reporting
  • Client
  • Segment for Segmental Reporting
  • P_MATERIALLEDGER_CUBE_LIT.MANDT == FAGL_SEGM.MANDT
  • P_MATERIALLEDGER_CUBE_LIT.SEGMENT == FAGL_SEGM.SEGMENT
Source Ledger
  • Ledger
  • Source Ledger
  • Client
Valuation area
  • Valuation area
  • Client
  • P_MATERIALLEDGER_CUBE_LIT.VALUATIONAREA == T001K.BWKEY
  • P_MATERIALLEDGER_CUBE_LIT.MANDT == T001K.MANDT