A_ProdSpecPrptyCharcAssignment

DDL: A_PRODSPECPRPTYCHARCASSIGNMENT SQL: APRODSPCPROPCHAS Type: view COMPOSITE

Prod Spec Property Charc Assignment

A_ProdSpecPrptyCharcAssignment is a Composite CDS View that provides data about "Prod Spec Property Charc Assignment" in SAP S/4HANA. It reads from 3 data sources (I_ClfnCharcTimeIndep, I_SpecCstmPropertyDefinition, I_SpecCstmPropertyCharcAssgmt) and exposes 5 fields with key fields ProdSpecPrptyDefID, CharcInternalID. It has 1 association to related views.

3 data source(s) 5 fields

Data Sources (3)

SourceAliasJoin Type
I_ClfnCharcTimeIndep clf_nonhist inner
I_SpecCstmPropertyDefinition prop_def inner
I_SpecCstmPropertyCharcAssgmt prop_def_char from

Associations (1)

CardinalityTargetAliasCondition
[1..1] A_ProdSpecPrptyDefinition _ProdSpecPrptyDefinition $projection.ProdSpecPrptyDefID = _ProdSpecPrptyDefinition.ProdSpecPrptyDefID

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName APRODSPCPROPCHAS view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #S view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
VDM.viewType #COMPOSITE view
EndUserText.label Prod Spec Property Charc Assignment view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY ProdSpecPrptyDefID I_SpecCstmPropertyCharcAssgmt ProdSpecPrptyDefID
KEY CharcInternalID
SpecPhraseSet
_CharcBasic I_ClfnCharcTimeIndep _CharcBasic
_ProdSpecPrptyDefinition _ProdSpecPrptyDefinition 
@AbapCatalog.sqlViewName: 'APRODSPCPROPCHAS'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true

@AccessControl.authorizationCheck: #CHECK

@ClientHandling.algorithm: #SESSION_VARIABLE

@Metadata.ignorePropagatedAnnotations: true

@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.sizeCategory: #S

@VDM.lifecycle.contract.type: #PUBLIC_REMOTE_API
@VDM.viewType: #COMPOSITE
@EndUserText.label: 'Prod Spec Property Charc Assignment'

define view A_ProdSpecPrptyCharcAssignment
  as select from           I_SpecCstmPropertyCharcAssgmt  as prop_def_char
    inner join             I_SpecCstmPropertyDefinition   as prop_def         on prop_def.ProdSpecPrptyDefID = prop_def_char.ProdSpecPrptyDefID
    inner join             I_ClfnCharcTimeIndep           as clf_nonhist      on clf_nonhist.CharcInternalID = prop_def_char.CharcInternalID
    left outer to one join I_SpecValAssgmtTypeCharcToPhrs as vat_to_phraseset on  vat_to_phraseset.SpecValAssgmtType = prop_def.ProdSpecPrptyDefValAssgmtType
                                                                              and vat_to_phraseset.Characteristic    = clf_nonhist.Characteristic

  association [1..1] to A_ProdSpecPrptyDefinition as _ProdSpecPrptyDefinition on $projection.ProdSpecPrptyDefID = _ProdSpecPrptyDefinition.ProdSpecPrptyDefID
{
  key prop_def_char.ProdSpecPrptyDefID,
  key cast(clf_nonhist.CharcInternalID as atinn_no_conv preserving type ) as CharcInternalID,

      vat_to_phraseset._SpecificationPhrsSetNonHist.SpecPhraseSet,

      @Consumption.hidden: true
      clf_nonhist._CharcBasic,

      _ProdSpecPrptyDefinition
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CLFNCHARCTIMEINDEP",
"I_SPECCSTMPROPERTYCHARCASSGMT",
"I_SPECCSTMPROPERTYDEFINITION",
"I_SPECIFICATIONPHRSSETNONHIST",
"I_SPECVALASSGMTTYPECHARCTOPHRS"
],
"ASSOCIATED":
[
"A_PRODSPECPRPTYDEFINITION",
"I_CLFNCHARCBASIC"
],
"BASE":
[
"I_CLFNCHARCTIMEINDEP"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More