v_ml_mig_mlpack_view

DDL: FML_ML_PACK SQL: FMLV_MLPACK Type: view

Migration: Material Ledger - Packages

v_ml_mig_mlpack_view is a CDS View that provides data about "Migration: Material Ledger - Packages" in SAP S/4HANA. It reads from 2 data sources (ckmlhd, t001k).

2 data source(s)

Data Sources (2)

SourceAliasJoin Type
ckmlhd hd inner
t001k t inner

Annotations (2)

NameValueLevelField
AbapCatalog.sqlViewName FMLV_MLPACK view
EndUserText.label Migration: Material Ledger - Packages view 
@AbapCatalog.sqlViewName: 'FMLV_MLPACK'
@EndUserText.label: 'Migration: Material Ledger - Packages'
define view v_ml_mig_mlpack_view as
    select key ml.mandt,
           key ml.bdatj    as gjahr,
--           key ml.poper    as perio,
           key t.bukrs     as bukrs

    from        ckmlpp     as ml
    inner join  ckmlhd     as hd   on hd.mandt = ml.mandt
                                  and hd.kalnr = ml.kalnr
    inner join  t001k      as t    on  t.mandt = hd.mandt
                                  and  t.bwkey = hd.bwkey
    group by ml.mandt,
             ml.bdatj,
--             ml.poper,
             t.bukrs
    ;
           
  
  
  
 /*+[internal] {
"BASEINFO":
{
"FROM":
[
"CKMLHD",
"CKMLPP",
"T001K"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More