I_ML_Balance

Balance Summary for Material Ledger | view: IMLBALANCE | TRAN | Extraction: Not supported | Component: Information System
Tables used: FAGL_CARRY_FORW, ACDOCA, MARA, FINSC_CUSTBTTYPE, FINSC_CUSTBTTYPT, FINSC_LEDGER, FINSC_LEDGER_T, MARA, T023, EBEW, MBEW, OBEW, QBEW, MARA, FINSC_CURTYPE, FINSC_CURTYPET, FINSC_LEDGER, FINSC_ACTVE_APPL, FINSC_LEDGER_REP, FINSC_LD_CMP, FINSC_FISC_DATE, FINSC_PERIOD, FMLC_TOGGLE, FMLT_CURTP_ML, TCURM
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
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
Column Name Description Domain name
FiscalPeriod null
LedgerFiscalYear Ledger Fiscal Year GJAHR
ReferenceDocument Reference document number AWREF
BusinessTransactionTypeName Business Transaction Type Description TEXT30
LastChangeDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
FiscalYearPeriod Fiscal Year Period FIS_JAHRPER_CONV
TransactionTypeDetermination Transaction Key CHAR3
MaterialGroup Product Group MATKL
Plant Plant WERKS
Master Data Relations Join Conditions
Journal Entry Type
  • Journal Entry Type
  • Client
  • I_ML_BALANCE.ACCOUNTINGDOCUMENTTYPE == T003.BLART
  • I_ML_BALANCE.MANDT == T003.MANDT
Cost Source Unit
  • Client
  • Cost Source Unit
  • I_ML_BALANCE.MANDT == T006.MANDT
  • I_ML_BALANCE.BASEUNIT == T006.MSEHI
Business Transaction Category
  • Client
  • Business Transaction Category
Chart of Accounts
  • Client
  • Chart of Accounts
  • I_ML_BALANCE.MANDT == T004.MANDT
  • I_ML_BALANCE.CHARTOFACCOUNTS == T004.KTOPL
Company Code
  • Client
  • Company Code
  • I_ML_BALANCE.MANDT == T001.MANDT
  • I_ML_BALANCE.COMPANYCODE == T001.BUKRS
Company Code Currency
  • Client
  • Company Code Currency
  • I_ML_BALANCE.MANDT == TCURC.MANDT
  • I_ML_BALANCE.COMPANYCODECURRENCY == TCURC.WAERS
Controlling Area
  • Client
  • Controlling Area
  • I_ML_BALANCE.MANDT == TKA01.MANDT
  • I_ML_BALANCE.CONTROLLINGAREA == TKA01.KOKRS
Cost Center
  • Client
  • Controlling Area
  • Cost Center
  • ?
  • I_ML_BALANCE.MANDT == CSKS.MANDT
  • I_ML_BALANCE.CONTROLLINGAREA == CSKS.KOKRS
  • I_ML_BALANCE.COSTCENTER == CSKS.KOSTL
  • I_ML_BALANCE.[column in domain "DATBI"] == CSKS.DATBI
Freely Defined Currency 1
  • Client
  • Freely Defined Currency 1
  • I_ML_BALANCE.MANDT == TCURC.MANDT
  • I_ML_BALANCE.FREEDEFINEDCURRENCY1 == TCURC.WAERS
Freely Defined Currency 2
  • Client
  • Freely Defined Currency 2
  • I_ML_BALANCE.MANDT == TCURC.MANDT
  • I_ML_BALANCE.FREEDEFINEDCURRENCY2 == TCURC.WAERS
Freely Defined Currency 3
  • Client
  • Freely Defined Currency 3
  • I_ML_BALANCE.MANDT == TCURC.MANDT
  • I_ML_BALANCE.FREEDEFINEDCURRENCY3 == TCURC.WAERS
Freely Defined Currency 4
  • Client
  • Freely Defined Currency 4
  • I_ML_BALANCE.MANDT == TCURC.MANDT
  • I_ML_BALANCE.FREEDEFINEDCURRENCY4 == TCURC.WAERS
Freely Defined Currency 5
  • Client
  • Freely Defined Currency 5
  • I_ML_BALANCE.MANDT == TCURC.MANDT
  • I_ML_BALANCE.FREEDEFINEDCURRENCY5 == TCURC.WAERS
Freely Defined Currency 6
  • Client
  • Freely Defined Currency 6
  • I_ML_BALANCE.MANDT == TCURC.MANDT
  • I_ML_BALANCE.FREEDEFINEDCURRENCY6 == TCURC.WAERS
Freely Defined Currency 7
  • Client
  • Freely Defined Currency 7
  • I_ML_BALANCE.MANDT == TCURC.MANDT
  • I_ML_BALANCE.FREEDEFINEDCURRENCY7 == TCURC.WAERS
Freely Defined Currency 8
  • Client
  • Freely Defined Currency 8
  • I_ML_BALANCE.MANDT == TCURC.MANDT
  • I_ML_BALANCE.FREEDEFINEDCURRENCY8 == TCURC.WAERS
G/L Account
  • Client
  • G/L Account
  • Company Code
  • I_ML_BALANCE.MANDT == SKB1.MANDT
  • I_ML_BALANCE.GLACCOUNT == SKB1.SAKNR
  • I_ML_BALANCE.COMPANYCODE == SKB1.BUKRS
Global Currency
  • Client
  • Global Currency
  • I_ML_BALANCE.MANDT == TCURC.MANDT
  • I_ML_BALANCE.GROUPCURRENCY == TCURC.WAERS
Valuation area/valuation category
  • Valuation area
  • Client
  • Valuation Category
  • I_ML_BALANCE.VALUATIONAREA == T149.BWKEY
  • I_ML_BALANCE.MANDT == T149.MANDT
  • I_ML_BALANCE.INVENTORYVALUATIONCATEGORY == T149.BWTTY
Valuation Type
  • Client
  • Valuation Type
  • I_ML_BALANCE.MANDT == T149D.MANDT
  • I_ML_BALANCE.INVENTORYVALUATIONTYPE == T149D.BWTAR
Ledger
  • Client
  • Ledger
Material Number
  • Client
  • Material Number
  • I_ML_BALANCE.MANDT == MARA.MANDT
  • I_ML_BALANCE.MATERIAL == MARA.MATNR
Original Process Category I_ML_BALANCE.MATERIALLEDGERPROCESSTYPE == CKMLMV009.PTYP
Valuation Class
  • Valuation Class
  • Client
  • I_ML_BALANCE.MATERIALVALUATIONCLASS == T025.BKLAS
  • I_ML_BALANCE.MANDT == T025.MANDT
Product Hierarchy
  • Product hierarchy
  • Client
  • I_ML_BALANCE.PRODUCTHIERARCHY == T179.PRODH
  • I_ML_BALANCE.MANDT == T179.MANDT
Order ID
  • Client
  • Order ID
  • I_ML_BALANCE.MANDT == AUFK.MANDT
  • I_ML_BALANCE.PRODUCTIONORDER == AUFK.AUFNR
Profit Center
  • Client
  • Controlling Area
  • Profit Center
  • ?
  • I_ML_BALANCE.MANDT == CEPC.MANDT
  • I_ML_BALANCE.CONTROLLINGAREA == CEPC.KOKRS
  • I_ML_BALANCE.PROFITCENTER == CEPC.PRCTR
  • I_ML_BALANCE.[column in domain "DATBI"] == CEPC.DATBI
Reference Document Type I_ML_BALANCE.REFERENCEDOCUMENTTYPE == TTYP.AWTYP
Segment for Segmental Reporting
  • Client
  • Segment for Segmental Reporting
Valuation area
  • Valuation area
  • Client
  • I_ML_BALANCE.VALUATIONAREA == T001K.BWKEY
  • I_ML_BALANCE.MANDT == T001K.MANDT