C_ProdnVersProdnLineVH

DDL: C_PRODNVERSPRODNLINEVH SQL: CPVPRODNLINEVH Type: view CONSUMPTION

Production Line

C_ProdnVersProdnLineVH is a Consumption CDS View that provides data about "Production Line" in SAP S/4HANA. It reads from 1 data source (I_WorkCenterBySemanticKey) and exposes 6 fields with key fields ProductionLine, Plant. It has 1 association to related views.

1 data source(s) 6 fields

Data Sources (1)

SourceAliasJoin Type
I_WorkCenterBySemanticKey I_WorkCenterBySemanticKey from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_WorkCenterCategoryText _WorkCenterCategoryText $projection.WorkCenterCategoryCode = _WorkCenterCategoryText.WorkCenterCategoryCode

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName CPVPRODNLINEVH view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
VDM.viewType #CONSUMPTION view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #CHECK view
Search.searchable true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
EndUserText.label Production Line view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY ProductionLine WorkCenter
KEY Plant Plant
WorkCenterCategoryCode WorkCenterCategoryCode
_Plant _Plant
_WorkCenterTextBySemanticKey _WorkCenterTextBySemanticKey
_WorkCenterCategoryText _WorkCenterCategoryText 
@AbapCatalog.sqlViewName: 'CPVPRODNLINEVH'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey:true
@VDM.viewType: #CONSUMPTION
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #CHECK
@Search.searchable: true
@ObjectModel.usageType: {serviceQuality: #C, sizeCategory: #L, dataClass: #TRANSACTIONAL}
@EndUserText.label: 'Production Line'
define view C_ProdnVersProdnLineVH as select from I_WorkCenterBySemanticKey
association [0..*] to I_WorkCenterCategoryText as _WorkCenterCategoryText on $projection.WorkCenterCategoryCode = _WorkCenterCategoryText.WorkCenterCategoryCode
{
      @ObjectModel.text.association: '_WorkCenterTextBySemanticKey'
      @Search: {defaultSearchElement: true, fuzzinessThreshold: 0.8}
  key WorkCenter as ProductionLine,    
      @ObjectModel.foreignKey.association: '_Plant'
  key Plant,
      @Consumption.filter.defaultValue: '0007'
      @ObjectModel.text.association: '_WorkCenterCategoryText'
      WorkCenterCategoryCode,

      // Associations

      _Plant,
      _WorkCenterTextBySemanticKey,
      _WorkCenterCategoryText

};

Learn More