Which tables does I_LoglProductAssgmtDCToStore use?

I_LoglProductAssgmtDCToStore reads from 2 data source(s): P_StoreGrpFromClfnStore, I_MPPurchasingSourceItem.

How many fields does I_LoglProductAssgmtDCToStore have?

I_LoglProductAssgmtDCToStore has 14 fields. Key fields: Material, Store, SourceListRecord.

I_LoglProductAssgmtDCToStore

DDL: I_LOGLPRODUCTASSGMTDCTOSTORE Type: view COMPOSITE

Logistical Product DC Store Assignment

I_LoglProductAssgmtDCToStore is a Composite CDS View that provides data about "Logistical Product DC Store Assignment" in SAP S/4HANA. It reads from 2 data sources (P_StoreGrpFromClfnStore, I_MPPurchasingSourceItem) and exposes 14 fields with key fields Material, Store, SourceListRecord. It has 3 associations to related views.

Data Sources (2)

Source	Alias	Join Type
P_StoreGrpFromClfnStore	P_StoreGrpFromClfnStore	left_outer
I_MPPurchasingSourceItem	SourceList	from

Associations (3)

Cardinality	Target	Alias	Condition
[0..1]	I_Plant	_Store	`$projection.Store = _Store.Plant`
[0..1]	I_Plant	_DistributionCenter	`$projection.DistributionCenter = _DistributionCenter.Plant`
[1..1]	I_ActiveLogisticalProduct	_ActiveLogisticalProduct	`$projection.Material = _ActiveLogisticalProduct.Product`

Annotations (11)

Name	Value	Level
ObjectModel.usageType.dataClass	#MIXED	view
ObjectModel.usageType.serviceQuality	#C	view
ObjectModel.usageType.sizeCategory	#S	view
AbapCatalog.sqlViewName	ILOGLPRODASSDCST	view
AbapCatalog.compiler.compareFilter	true	view
AbapCatalog.preserveKey	true	view
AccessControl.authorizationCheck	#CHECK	view
AccessControl.personalData.blocking	#BLOCKED_DATA_EXCLUDED	view
EndUserText.label	Logistical Product DC Store Assignment	view
VDM.viewType	#COMPOSITE	view
ClientHandling.algorithm	#SESSION_VARIABLE	view

Fields (14)

Key	Field	Source Table	Source Field
KEY	Material	I_MPPurchasingSourceItem	Material
KEY	Store
KEY	SourceListRecord	I_MPPurchasingSourceItem	SourceListRecord
	SupplierendasSupplier
	DistributionCenter
	PurchasingOrganization	I_MPPurchasingSourceItem	PurchasingOrganization
	ValidityStartDate
	ValidityEndDate
	LastChangeDateTime	I_MPPurchasingSourceItem	LastChangeDateTime
	StoreGroupInternalID	_AssgdStoreGroup	StoreGroupInternalID
	_Store		_Store
	_DistributionCenter		_DistributionCenter
	_PurchasingOrganization		_PurchasingOrganization
	_ActiveLogisticalProduct		_ActiveLogisticalProduct

@ObjectModel.usageType: {
  dataClass: #MIXED,
  serviceQuality: #C,
  sizeCategory: #S
}
@AbapCatalog: {
  sqlViewName: 'ILOGLPRODASSDCST',
  compiler.compareFilter: true,
  preserveKey: true
}
@AccessControl: {
  authorizationCheck: #CHECK,
  personalData.blocking: #BLOCKED_DATA_EXCLUDED
}
@EndUserText.label: 'Logistical Product DC Store Assignment'

@VDM:
  {
    viewType: #COMPOSITE
  }

@ClientHandling.algorithm: #SESSION_VARIABLE

define view I_LoglProductAssgmtDCToStore
  as select from I_MPPurchasingSourceItem as SourceList
    join         I_Supplier                         on SourceList.Supplier = I_Supplier.Supplier
    join         I_Plant                            on  I_Supplier.Supplier   = I_Plant.PlantSupplier
                                                    and I_Plant.PlantCategory = 'B' -- Distribution Center
    join         I_Plant                  as Plant2 on  SourceList.Plant     = Plant2.Plant
                                                    and Plant2.PlantCategory = 'A' -- Store
                                                    
left outer join P_StoreGrpFromClfnStore( P_SAPClient : $session.client)        as _AssgdStoreGroup           on Plant2.Plant = _AssgdStoreGroup.Store       

  association [0..1] to I_Plant                   as _Store                   on $projection.Store = _Store.Plant
  association [0..1] to I_Plant                   as _DistributionCenter      on $projection.DistributionCenter = _DistributionCenter.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)                                         as Store,

  key SourceList.SourceListRecord,


      case I_Supplier.IsBusinessPurposeCompleted
        when 'X' then '*****'
        else SourceList.Supplier
      end                                                                     as Supplier,

      @ObjectModel.foreignKey.association: '_DistributionCenter'
      cast(I_Plant.Plant as distributioncenter)                               as DistributionCenter,

      @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  */
      _Store,
      _DistributionCenter,
      _PurchasingOrganization,
      _ActiveLogisticalProduct
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_MPPURCHASINGSOURCEITEM",
"I_PLANT",
"I_SUPPLIER"
],
"ASSOCIATED":
[
"I_ACTIVELOGISTICALPRODUCT",
"I_PLANT",
"I_PURCHASINGORGANIZATION"
],
"BASE":
[
"I_MPPURCHASINGSOURCEITEM"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Depth:

I_LoglProductAssgmtDCToStore view