P_CharcCtlgVCCharcMatlAssgmt

DDL: P_CHARCCTLGVCCHARCMATLASSGMT Type: view_entity COMPOSITE Package: PROD_ALLOC_CHARC_CATALOG

Variant Configuration: Assignment of Charact. to Materials

P_CharcCtlgVCCharcMatlAssgmt is a Composite CDS View that provides data about "Variant Configuration: Assignment of Charact. to Materials" in SAP S/4HANA. It reads from 1 data source (I_ClfnObjectCharc) and exposes 4 fields with key fields ClfnCharacteristicUseType, Material, ClassInternalID, CharcInternalID. Part of development package PROD_ALLOC_CHARC_CATALOG.

1 data source(s) 4 fields

Data Sources (1)

SourceAliasJoin Type
I_ClfnObjectCharc CharcMatAssgnmt from

Parameters (1)

NameTypeDefault
P_KeyDate sydate

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.private true view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #P view
ObjectModel.usageType.dataClass #MASTER view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY ClfnCharacteristicUseType
KEY Material
KEY ClassInternalID I_ClfnObjectCharc ClassInternalID
KEY CharcInternalID I_ClfnObjectCharc CharcInternalID 
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.private: true
@VDM.viewType: #COMPOSITE
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.serviceQuality: #P
@ObjectModel.usageType.dataClass:#MASTER
define view entity P_CharcCtlgVCCharcMatlAssgmt
  with parameters
    @Consumption.hidden: true
    @Environment.systemField: #SYSTEM_DATE
    P_KeyDate : sydate
  as select from I_ClfnObjectCharc                                           as CharcMatAssgnmt
    join         P_CharcCtlgVarConfClass( P_KeyDate: $parameters.P_KeyDate ) as Class on CharcMatAssgnmt.ClassInternalID = Class.ClassInternalID
{
  key cast('VC' as clfncharacteristicusetype)     as ClfnCharacteristicUseType,
  key cast(CharcMatAssgnmt.ClfnObjectID as matnr) as Material,
  key CharcMatAssgnmt.ClassInternalID,
  key CharcMatAssgnmt.CharcInternalID
}
where
      CharcMatAssgnmt.ClfnObjectTable = 'MARA'
  and CharcMatAssgnmt.ClfnObjectType  = 'O'
  and CharcMatAssgnmt.ValidityEndDate >= $session.system_date

Learn More