I_LOGLPRODASSGMTSUPLRTOSTORE

CDS View

Logistical Product Supplier Store Assgmt

I_LOGLPRODASSGMTSUPLRTOSTORE is a CDS View in S/4HANA. Logistical Product Supplier Store Assgmt. 3 CDS views read from this table.

Used by 3 CDS view(s)

CDS Views using this table (3)

ViewTypeJoinVDMDescription
C_LoglProdAssgmtSuplrToStore view from CONSUMPTION Logistical Product Supplier Store Assgmt
P_AssgblStoreForProcmtProdExt view left_outer CONSUMPTION
P_AssgblStoreForProcmtProdInt view left_outer CONSUMPTION 
@ObjectModel.usageType: {
  dataClass: #MIXED,
  serviceQuality: #C,
  sizeCategory: #M
}
@AbapCatalog: {
  sqlViewName: 'ILOGLPRODSUPLRST',
  compiler.compareFilter: true,
  preserveKey: true
}
@AccessControl: {
  authorizationCheck: #CHECK,
  personalData.blocking: #BLOCKED_DATA_EXCLUDED
}
@EndUserText.label: 'Logistical Product Supplier Store Assgmt'

@VDM:
  {
    viewType: #COMPOSITE
  }

@ClientHandling.algorithm: #SESSION_VARIABLE

define view I_LoglProdAssgmtSuplrToStore
  as select from    I_MPPurchasingSourceItem as SourceList

    join            I_Plant                            on  SourceList.Plant      = I_Plant.Plant
                                                       and I_Plant.PlantCategory = 'A' -- Store
    join            I_Supplier                         on SourceList.Supplier = I_Supplier.Supplier
    left outer join I_Plant                  as Plant2 on SourceList.Supplier = Plant2.PlantSupplier
    
                                                        
left outer join P_StoreGrpFromClfnStore( P_SAPClient : $session.client)        as _AssgdStoreGroup           on I_Plant.Plant = _AssgdStoreGroup.Store    

  association [0..1] to I_Supplier                as _Supplier                on $projection.Supplier = _Supplier.Supplier
  association [0..1] to I_Plant                   as _Store                   on $projection.Store = _Store.Plant
  association [1..1] to I_ActiveLogisticalProduct as _ActiveLogisticalProduct on $projection.Material = _ActiveLogisticalProduct.Product
{
  key SourceList.Material,

      @ObjectModel.foreignKey.association: '_Store'
  key cast(SourceList.Plant as store preserving type)                         as Store,

  key SourceList.SourceListRecord,

      @ObjectModel.foreignKey.association: '_Supplier'
      case I_Supplier.IsBusinessPurposeCompleted
        when 'X' then '*****'
        else SourceList.Supplier
      end                                                                     as Supplier,

      @ObjectModel.foreignKey.association: '_PurchasingOrganization'
      SourceList.PurchasingOrganization,

      cast(SourceList.ValidityStartDate as validitystartdate preserving type) as ValidityStartDate,

      cast(SourceList.ValidityEndDate as validityenddate preserving type)     as ValidityEndDate,

      SourceList.LastChangeDateTime,
      
      _AssgdStoreGroup.StoreGroupInternalID as StoreGroupInternalID,

      /*  Exposed associations  */
      _Supplier,
      _Store,
      _PurchasingOrganization,
      _ActiveLogisticalProduct
}
where
  Plant2.Plant is null
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_MPPURCHASINGSOURCEITEM",
"I_PLANT",
"I_SUPPLIER"
],
"ASSOCIATED":
[
"I_ACTIVELOGISTICALPRODUCT",
"I_PLANT",
"I_PURCHASINGORGANIZATION",
"I_SUPPLIER"
],
"BASE":
[
"I_MPPURCHASINGSOURCEITEM"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More