C_LoglProdAssgmtSuplrToStore

DDL: C_LOGLPRODASSGMTSUPLRTOSTORE SQL: CLOGLPRODSUPLRST Type: view CONSUMPTION Package: RFM_ASSG_PROCMT_PROD

Logistical Product Supplier Store Assgmt

C_LoglProdAssgmtSuplrToStore is a Consumption CDS View that provides data about "Logistical Product Supplier Store Assgmt" in SAP S/4HANA. It reads from 1 data source (I_LoglProdAssgmtSuplrToStore) and exposes 13 fields with key fields Product, Store, SourceListRecord. Part of development package RFM_ASSG_PROCMT_PROD.

Data Sources (1)

SourceAliasJoin Type
I_LoglProdAssgmtSuplrToStore I_LoglProdAssgmtSuplrToStore from

Annotations (12)

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

Fields (13)

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

define view C_LoglProdAssgmtSuplrToStore
  as select from I_LoglProdAssgmtSuplrToStore

{
  key Material                                    as Product,

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

  key SourceListRecord,

      @ObjectModel.foreignKey.association: '_Supplier'
      Supplier,

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

      ValidityStartDate,

      ValidityEndDate,

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

      _Supplier,
      _Store,
      _PurchasingOrganization,
      _ActiveLogisticalProduct
}