I_MaterialLedgerInventory

DDL: I_MATERIALLEDGERINVENTORY SQL: ICKMLHD Type: view BASIC

select data from CKMLHD

I_MaterialLedgerInventory is a Basic CDS View that provides data about "select data from CKMLHD" in SAP S/4HANA. It reads from 3 data sources (ckmlhd, t001, t001k) and exposes 4 fields.

3 data source(s) 4 fields

Data Sources (3)

SourceAliasJoin Type
ckmlhd hd from
t001 t1 inner
t001k tk inner

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName ICKMLHD view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
AbapCatalog.preserveKey true view
ObjectModel.usageType.dataClass #MIXED view
EndUserText.label select data from CKMLHD view

Fields (4)

KeyFieldSource TableSource FieldDescription
CostEstimate kalnr
ValuationArea ckmlhd bwkey
CompanyCode t001 bukrs
FiscalYearVariant periv 
@AbapCatalog.sqlViewName: 'ICKMLHD'
@AbapCatalog.compiler.compareFilter: true
@VDM.viewType: #BASIC
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #M
@AbapCatalog.preserveKey:true
@ObjectModel.usageType.dataClass: #MIXED
@EndUserText.label: 'select data from CKMLHD'

define view I_MaterialLedgerInventory
  as

  select from  ckmlhd as hd
    inner join t001k  as tk on tk.bwkey = hd.bwkey
    inner join t001   as t1 on t1.bukrs = tk.bukrs

{
  kalnr    as CostEstimate,
  hd.bwkey as ValuationArea,
  t1.bukrs as CompanyCode,
  periv    as FiscalYearVariant
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"CKMLHD",
"T001",
"T001K"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More