C_LoglProductAssgmtDCToStore

DDL: C_LOGLPRODUCTASSGMTDCTOSTORE SQL: CLOGLPRODDCSTORE Type: view CONSUMPTION

Logistical Product DC Store Assignment

C_LoglProductAssgmtDCToStore is a Consumption CDS View that provides data about "Logistical Product DC Store Assignment" in SAP S/4HANA. It reads from 1 data source (I_LoglProductAssgmtDCToStore) and exposes 14 fields with key fields Product, Store, SourceListRecord.

1 data source(s) 14 fields

Data Sources (1)

SourceAliasJoin Type
I_LoglProductAssgmtDCToStore I_LoglProductAssgmtDCToStore from

Annotations (12)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
AbapCatalog.sqlViewName CLOGLPRODDCSTORE view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label Logistical Product DC Store Assignment view
VDM.viewType #CONSUMPTION view
Metadata.allowExtensions true view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY Product Material
KEY Store Store
KEY SourceListRecord SourceListRecord
Supplier Supplier
DistributionCenter DistributionCenter
PurchasingOrganization PurchasingOrganization
ValidityStartDate ValidityStartDate
ValidityEndDate ValidityEndDate
LastChangeDateTime
StoreGroupInternalID StoreGroupInternalID
_Store _Store
_DistributionCenter _DistributionCenter
_PurchasingOrganization _PurchasingOrganization
_ActiveLogisticalProduct _ActiveLogisticalProduct 
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #S
@AbapCatalog.sqlViewName: 'CLOGLPRODDCSTORE'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl: {
  authorizationCheck: #CHECK,
  personalData.blocking: #NOT_REQUIRED
}
@EndUserText.label: 'Logistical Product DC Store Assignment'
@VDM.viewType: #CONSUMPTION
@Metadata.allowExtensions: true

define view C_LoglProductAssgmtDCToStore
  as select from I_LoglProductAssgmtDCToStore

{
  key  Material                                    as Product,

       @ObjectModel.foreignKey.association: '_Store'
  key  Store,

  key  SourceListRecord,

       Supplier,

       @ObjectModel.foreignKey.association: '_DistributionCenter'
       DistributionCenter,

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

       ValidityStartDate,

       ValidityEndDate,

       cast( LastChangeDateTime as abap.char(23) ) as LastChangeDateTime,
       
       StoreGroupInternalID,

       _Store,
       _DistributionCenter,
       _PurchasingOrganization,
       _ActiveLogisticalProduct
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_LOGLPRODUCTASSGMTDCTOSTORE"
],
"ASSOCIATED":
[
"I_ACTIVELOGISTICALPRODUCT",
"I_PLANT",
"I_PURCHASINGORGANIZATION"
],
"BASE":
[
"I_LOGLPRODUCTASSGMTDCTOSTORE"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More