C_AssgblDCForStore

DDL: C_ASSGBLDCFORSTORE SQL: CASNDCFORSTORE Type: view CONSUMPTION

Assignable DC for Store Value Help

C_AssgblDCForStore is a Consumption CDS View that provides data about "Assignable DC for Store Value Help" in SAP S/4HANA. It reads from 1 data source (P_AssgblDCForStore) and exposes 4 fields with key fields Product, DistributionCenter.

1 data source(s) 4 fields

Data Sources (1)

SourceAliasJoin Type
P_AssgblDCForStore P_AssgblDCForStore from

Parameters (2)

NameTypeDefault
P_ValidityStartDate datum
P_ValidityEndDate datum

Annotations (12)

NameValueLevelField
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName CASNDCFORSTORE view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
VDM.viewType #CONSUMPTION view
EndUserText.label Assignable DC for Store Value Help view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY Product Material
KEY DistributionCenter DistributionCenter
_ActiveLogisticalProduct _ActiveLogisticalProduct
_DistributionCenter _DistributionCenter 
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.sqlViewName: 'CASNDCFORSTORE'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl: {
  authorizationCheck: #CHECK,
  personalData.blocking: #NOT_REQUIRED
}
@ObjectModel.dataCategory: #VALUE_HELP
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #M
@VDM.viewType: #CONSUMPTION

@EndUserText.label: 'Assignable DC for Store Value Help'

define view C_AssgblDCForStore

  with parameters
    P_ValidityStartDate : datum,
    P_ValidityEndDate   : datum

  as select from P_AssgblDCForStore (P_ValidityStartDate : $parameters.P_ValidityStartDate, P_ValidityEndDate : $parameters.P_ValidityEndDate)
{
      @ObjectModel.foreignKey.association: '_ActiveLogisticalProduct'
  key Material as Product,

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

      /*  Exposed associations  */
      _ActiveLogisticalProduct,
      _DistributionCenter
}

Learn More