C_MlLineItem

Column Name Description
Column Name Description
AmountInCompanyCodeCurrency Amount in Company Code Currency
SlsPriceAmountInCoCodeCrcy Value at Sales Price in Local Currency
AmountInGroupCurrency Amount in Global Currency
AmountInFreeDefinedCurrency1 Amount in Freely Defined Currency 1
AmountInFreeDefinedCurrency2 Amount in Freely Defined Currency 2
AmountInFreeDefinedCurrency3 Amount in Freely Defined Currency 3
AmountInFreeDefinedCurrency4 Amount in Freely Defined Currency 4
AmountInFreeDefinedCurrency5 Amount in Freely Defined Currency 5
AmountInFreeDefinedCurrency6 Amount in Freely Defined Currency 6
AmountInFreeDefinedCurrency7 Amount in Freely Defined Currency 7
AmountInFreeDefinedCurrency8 Amount in Freely Defined Currency 8
Column Name Description
InventoryQty Inventory Quantity
Column Name Description
PostingDate Posting Date
DocumentDate Journal Entry Date
Column Name Description
MaterialLedgerCategory Category in Material Update Structure Show values
Column Name Description Domain name
MaterialGroup Product Group MATKL
AccountingDocument Journal Entry BELNR
FiscalPeriod Fiscal Period POPER
LedgerFiscalYear Ledger Fiscal Year GJAHR
FiscalYearPeriod Fiscal Year Period FIS_JAHRPER_CONV
LedgerGLLineItem Ledger Journal Entry Item DOCLN6
ReferenceDocument Reference document number AWREF
LastChangeDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
Master Data Relations Join Conditions
Journal Entry Type
  • Journal Entry Type
  • Client
  • C_MLLINEITEM.ACCOUNTINGDOCUMENTTYPE == T003.BLART
  • C_MLLINEITEM.MANDT == T003.MANDT
Business Transaction Category
  • Client
  • Business Transaction Category
Chart of Accounts
  • Chart of Accounts
  • Client
  • C_MLLINEITEM.CHARTOFACCOUNTS == T004.KTOPL
  • C_MLLINEITEM.MANDT == T004.MANDT
Company Code
  • Company Code
  • Client
  • C_MLLINEITEM.COMPANYCODE == T001.BUKRS
  • C_MLLINEITEM.MANDT == T001.MANDT
Cost Center
  • Cost Center
  • ?
  • ?
  • Client
  • C_MLLINEITEM.COSTCENTER == CSKS.KOSTL
  • C_MLLINEITEM.[column in domain "DATBI"] == CSKS.DATBI
  • C_MLLINEITEM.[column in domain "KOKRS"] == CSKS.KOKRS
  • C_MLLINEITEM.MANDT == CSKS.MANDT
G/L Account
  • G/L Account
  • Company Code
  • Client
  • C_MLLINEITEM.GLACCOUNT == SKB1.SAKNR
  • C_MLLINEITEM.COMPANYCODE == SKB1.BUKRS
  • C_MLLINEITEM.MANDT == SKB1.MANDT
Valuation area/valuation category
  • Client
  • Valuation Category
  • ?
  • C_MLLINEITEM.MANDT == T149.MANDT
  • C_MLLINEITEM.INVENTORYVALUATIONCATEGORY == T149.BWTTY
  • C_MLLINEITEM.[column in domain "BWKEY"] == T149.BWKEY
Valuation Type
  • Valuation Type
  • Client
  • C_MLLINEITEM.INVENTORYVALUATIONTYPE == T149D.BWTAR
  • C_MLLINEITEM.MANDT == T149D.MANDT
Ledger
  • Client
  • Ledger
Material Number
  • Material Number
  • Client
  • C_MLLINEITEM.MATERIAL == MARA.MATNR
  • C_MLLINEITEM.MANDT == MARA.MANDT
Original Process Category C_MLLINEITEM.MATERIALLEDGERPROCESSTYPE == CKMLMV009.PTYP
Valuation Class
  • Valuation Class
  • Client
  • C_MLLINEITEM.MATERIALVALUATIONCLASS == T025.BKLAS
  • C_MLLINEITEM.MANDT == T025.MANDT
Plant
  • Client
  • Plant
  • C_MLLINEITEM.MANDT == T001W.MANDT
  • C_MLLINEITEM.PLANT == T001W.WERKS
Order ID
  • Order ID
  • Client
  • C_MLLINEITEM.PRODUCTIONORDER == AUFK.AUFNR
  • C_MLLINEITEM.MANDT == AUFK.MANDT
Profit Center
  • ?
  • ?
  • Client
  • Profit Center
  • C_MLLINEITEM.[column in domain "DATBI"] == CEPC.DATBI
  • C_MLLINEITEM.[column in domain "KOKRS"] == CEPC.KOKRS
  • C_MLLINEITEM.MANDT == CEPC.MANDT
  • C_MLLINEITEM.PROFITCENTER == CEPC.PRCTR
Reference Document Type C_MLLINEITEM.REFERENCEDOCUMENTTYPE == TTYP.AWTYP
Segment for Segmental Reporting
  • Client
  • Segment for Segmental Reporting