P_ChmlCmplncMktCvrg

DDL: P_CHMLCMPLNCMKTCVRG Type: view CONSUMPTION

P_ChmlCmplncMktCvrg is a Consumption CDS View in SAP S/4HANA. It reads from 1 data source (I_ChmlCmplncMktCvrg) and exposes 6 fields with key field ChmlCmplncMktCvrgUUID. It has 1 association to related views.

1 data source(s) 6 fields

Data Sources (1)

SourceAliasJoin Type
I_ChmlCmplncMktCvrg I_ChmlCmplncMktCvrg from

Associations (1)

CardinalityTargetAliasCondition
[0..1] C_ChmlCmplncPrimMatl _MaterialDataPrimary _MaterialDataPrimary.ChmlCmplncInfoUUID = $projection.ChmlCmplncInfoUUID

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName PCCMKTCVRG view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #CONSUMPTION view
VDM.private true view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY ChmlCmplncMktCvrgUUID ChmlCmplncMktCvrgUUID
ChmlCmplncInfoUUID ChmlCmplncInfoUUID
Country Country
ChmlCmplncInfoCntryProdName
_Country _Country
_MaterialDataPrimary _MaterialDataPrimary 
@AbapCatalog:
{
  sqlViewName: 'PCCMKTCVRG',
  compiler.compareFilter: true
}

--Access Control: Authorizations Checks
@AccessControl:
{
  authorizationCheck: #NOT_REQUIRED
}

--Client Handling of the view
@ClientHandling.algorithm: #SESSION_VARIABLE

--VDM view type
@VDM.viewType: #CONSUMPTION
@VDM.private: true


define view P_ChmlCmplncMktCvrg
  as select from I_ChmlCmplncMktCvrg
  
  association [0..1] to C_ChmlCmplncPrimMatl as _MaterialDataPrimary   on _MaterialDataPrimary.ChmlCmplncInfoUUID = $projection.ChmlCmplncInfoUUID
  
  {

      @ObjectModel.readOnly: true
  key ChmlCmplncMktCvrgUUID,

      @ObjectModel.readOnly: true
      ChmlCmplncInfoUUID,

      @ObjectModel.readOnly: true
      Country,

      @ObjectModel.readOnly: true
      concat_with_space( concat_with_space( _Country._Text[1: Language = $session.system_language ].CountryName, '-', 1), _MaterialDataPrimary.ChmlCmplncInfoCombinedName, 1 ) as ChmlCmplncInfoCntryProdName,

      _Country,
      _MaterialDataPrimary
     
}  
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"C_CHMLCMPLNCPRIMMATL",
"I_CHMLCMPLNCMKTCVRG",
"I_COUNTRY",
"I_COUNTRYTEXT"
],
"ASSOCIATED":
[
"C_CHMLCMPLNCPRIMMATL",
"I_COUNTRY"
],
"BASE":
[
"I_CHMLCMPLNCMKTCVRG"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More