I_MaterialLedger

Material Ledger Interface | view: IMATERIALLEDGER | Extraction: Not supported | Component: Information System
Tables used: CKMLCR, ACDOCA, FMLT_PRICE, FINSC_LEDGER, FINSC_LEDGER_T, CKMLHD, FINSC_CURTYPE, FINSC_CURTYPET, FINSC_ACTVE_APPL, FINSC_LEDGER_REP, FMLC_TOGGLE, FMLT_CURTP_ML, FINSC_LD_CMP
Column Name Description
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
Column Name Description
💲 Company Code Currency (CompanyCodeCurrency):
AmountInCompanyCodeCurrency Amount in Company Code Currency
MaterialPriceInCoCodeCurrency null
💲 Global Currency (GroupCurrency):
AmountInGroupCurrency Amount in Global Currency
MaterialPriceInGroupCurrency null
💲 Freely Defined Currency 1 (AdditionalCurrency1):
AmountInAdditionalCurrency1 Amount in Freely Defined Currency 1
MaterialPriceInAddlCurrency1 null
💲 Freely Defined Currency 2 (AdditionalCurrency2):
AmountInAdditionalCurrency2 Amount in Freely Defined Currency 2
MaterialPriceInAddlCurrency2 null
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
LedgerValnCrcyRoleIsUsedInLogs Indicator: currency type is used in logistic reporting 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
CostEstimate Cost Estimate CK_KALNR
InvtryValnSpecialStockType Inventory Special Stock Type SOBKZ
MatPriceUnitInCoCodeCurrency null
MatPriceUnitInGroupCurrency null
MatPriceUnitInAddlCurrency1 null
MatPriceUnitInAddlCurrency2 null
MaterialPriceControl null
CurrencyRole External Currency Type and Valuation View FINS_CURTYPE
AdditionalCurrency1Role External Currency Type and Valuation View FINS_CURTYPE
AdditionalCurrency2Role External Currency Type and Valuation View FINS_CURTYPE
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
Master Data Relations Join Conditions
Journal Entry Type
  • Client
  • Journal Entry Type
  • I_MATERIALLEDGER.MANDT == T003.MANDT
  • I_MATERIALLEDGER.ACCOUNTINGDOCUMENTTYPE == T003.BLART
Freely Defined Currency 1
  • Freely Defined Currency 1
  • Client
  • I_MATERIALLEDGER.ADDITIONALCURRENCY1 == TCURC.WAERS
  • I_MATERIALLEDGER.MANDT == TCURC.MANDT
Freely Defined Currency 2
  • Freely Defined Currency 2
  • Client
  • I_MATERIALLEDGER.ADDITIONALCURRENCY2 == TCURC.WAERS
  • I_MATERIALLEDGER.MANDT == TCURC.MANDT
Cost Source Unit
  • Client
  • Cost Source Unit
  • I_MATERIALLEDGER.MANDT == T006.MANDT
  • I_MATERIALLEDGER.BASEUNIT == T006.MSEHI
Business Transaction Category
  • Business Transaction Category
  • Client
Chart of Accounts
  • Chart of Accounts
  • Client
  • I_MATERIALLEDGER.CHARTOFACCOUNTS == T004.KTOPL
  • I_MATERIALLEDGER.MANDT == T004.MANDT
Company Code
  • Company Code
  • Client
  • I_MATERIALLEDGER.COMPANYCODE == T001.BUKRS
  • I_MATERIALLEDGER.MANDT == T001.MANDT
Company Code Currency
  • Client
  • Company Code Currency
  • I_MATERIALLEDGER.MANDT == TCURC.MANDT
  • I_MATERIALLEDGER.COMPANYCODECURRENCY == TCURC.WAERS
Controlling Area
  • Controlling Area
  • Client
  • I_MATERIALLEDGER.CONTROLLINGAREA == TKA01.KOKRS
  • I_MATERIALLEDGER.MANDT == TKA01.MANDT
Cost Center
  • Controlling Area
  • ?
  • Client
  • Cost Center
  • I_MATERIALLEDGER.CONTROLLINGAREA == CSKS.KOKRS
  • I_MATERIALLEDGER.[column in domain "DATBI"] == CSKS.DATBI
  • I_MATERIALLEDGER.MANDT == CSKS.MANDT
  • I_MATERIALLEDGER.COSTCENTER == CSKS.KOSTL
Fiscal Year Variant
  • Fiscal Year Variant
  • Client
  • I_MATERIALLEDGER.FISCALYEARVARIANT == T009.PERIV
  • I_MATERIALLEDGER.MANDT == T009.MANDT
G/L Account
  • G/L Account
  • Company Code
  • Client
  • I_MATERIALLEDGER.GLACCOUNT == SKB1.SAKNR
  • I_MATERIALLEDGER.COMPANYCODE == SKB1.BUKRS
  • I_MATERIALLEDGER.MANDT == SKB1.MANDT
Global Currency
  • Global Currency
  • Client
  • I_MATERIALLEDGER.GROUPCURRENCY == TCURC.WAERS
  • I_MATERIALLEDGER.MANDT == TCURC.MANDT
Valuation Type
  • Valuation Type
  • Client
  • I_MATERIALLEDGER.INVENTORYVALUATIONTYPE == T149D.BWTAR
  • I_MATERIALLEDGER.MANDT == T149D.MANDT
Ledger
  • Ledger
  • Client
Material Number
  • Client
  • Material Number
  • I_MATERIALLEDGER.MANDT == MARA.MANDT
  • I_MATERIALLEDGER.MATERIAL == MARA.MATNR
Original Process Category I_MATERIALLEDGER.MATERIALLEDGERPROCESSTYPE == CKMLMV009.PTYP
Plant
  • Client
  • Plant
  • I_MATERIALLEDGER.MANDT == T001W.MANDT
  • I_MATERIALLEDGER.PLANT == T001W.WERKS
Order ID
  • Order ID
  • Client
  • I_MATERIALLEDGER.PRODUCTIONORDER == AUFK.AUFNR
  • I_MATERIALLEDGER.MANDT == AUFK.MANDT
Profit Center
  • Controlling Area
  • ?
  • Client
  • Profit Center
  • I_MATERIALLEDGER.CONTROLLINGAREA == CEPC.KOKRS
  • I_MATERIALLEDGER.[column in domain "DATBI"] == CEPC.DATBI
  • I_MATERIALLEDGER.MANDT == CEPC.MANDT
  • I_MATERIALLEDGER.PROFITCENTER == CEPC.PRCTR
Reference Document Type I_MATERIALLEDGER.REFERENCEDOCUMENTTYPE == TTYP.AWTYP
Segment for Segmental Reporting
  • Client
  • Segment for Segmental Reporting
Valuation area
  • Valuation area
  • Client
  • I_MATERIALLEDGER.VALUATIONAREA == T001K.BWKEY
  • I_MATERIALLEDGER.MANDT == T001K.MANDT