I_ChmlCmplncPckgdProduct

DDL: I_CHMLCMPLNCPCKGDPRODUCT SQL: ICCIPCKGDPROD Type: view BASIC

Pckgd Products assigned to Unpckgd Prod

I_ChmlCmplncPckgdProduct is a Basic CDS View that provides data about "Pckgd Products assigned to Unpckgd Prod" in SAP S/4HANA. It reads from 1 data source (I_ChmlCmplncProdAssgmt) and exposes 4 fields with key field ChmlCmplncProdAssgmtUUID. It has 1 association to related views.

1 data source(s) 4 fields

Data Sources (1)

SourceAliasJoin Type
I_ChmlCmplncProdAssgmt PackagedProdAssgmt from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_ChmlCmplncInfo _ChmlCmplncInfo _ChmlCmplncInfo.ChmlCmplncInfoUUID = PackagedProdAssgmt.ChmlCmplncInfoUUID

Annotations (11)

NameValueLevelField
EndUserText.label Pckgd Products assigned to Unpckgd Prod view
AbapCatalog.sqlViewName ICCIPCKGDPROD view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
VDM.viewType #BASIC view
Search.searchable true view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY ChmlCmplncProdAssgmtUUID ChmlCmplncProdAssgmtUUID
ChmlCmplncProdUUID I_ChmlCmplncProdAssgmt ChmlCmplncProdUUID
ChmlCmplncInfoUUID I_ChmlCmplncProdAssgmt ChmlCmplncInfoUUID
Material 
@EndUserText.label: 'Pckgd Products assigned to Unpckgd Prod'
@AbapCatalog.sqlViewName: 'ICCIPCKGDPROD'
@AbapCatalog.compiler.compareFilter: true

@AccessControl: {
  // authorization is checked but with dummy DCL. Display is done via main view which uses correct DCL 

  authorizationCheck: #MANDATORY,
  // no blocking of personal data not required 

  // (no personal data fields exposed for material (MARA))

  personalData.blocking: #NOT_REQUIRED
}

@ClientHandling.algorithm: #SESSION_VARIABLE

@ObjectModel: {
  usageType: {
    dataClass: #MIXED,
    serviceQuality: #C,
    sizeCategory:  #L
  }
}

@VDM.viewType: #BASIC
@Search.searchable : true

// View is used to search for packaged product. If used for displaying data, it can modify the cardinality

define view I_ChmlCmplncPckgdProduct
  as select from I_ChmlCmplncProdAssgmt as PackagedProdAssgmt

  // packaged product

  association [1..1] to I_ChmlCmplncInfo as _ChmlCmplncInfo on _ChmlCmplncInfo.ChmlCmplncInfoUUID = PackagedProdAssgmt.ChmlCmplncInfoUUID
{
  key ChmlCmplncProdAssgmtUUID,

      // UUID of unpackaged product

      PackagedProdAssgmt.ChmlCmplncProdUUID,

      // UUID of packaged product

      PackagedProdAssgmt.ChmlCmplncInfoUUID,

      _ChmlCmplncInfo._MaterialAssignment.Material,

//      @Search:

//      {

//        defaultSearchElement : true,

//        fuzzinessThreshold: 0.7,

//        ranking: #HIGH

//      }

      cast( _ChmlCmplncInfo._MaterialAssignment._Product.Product
      as ehdgm_packaged_product )           as ChmlCmplncInfoPckgdProd,

      --Material name of packaged product
      @UI.hidden: true
      @ObjectModel.readOnly: true
      @Search:
      {
        defaultSearchElement : true,
        fuzzinessThreshold: 0.7,
        ranking: #HIGH
      }
      cast( _ChmlCmplncInfo._MaterialAssignment._Product._Text[1: Language = $session.system_language ].ProductName
      as ehfnd_csm_ematnr preserving type ) as ChmlCmplncInfoPckgdProdName

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CHMLCMPLNCINFO",
"I_CHMLCMPLNCMATLASSGMT",
"I_CHMLCMPLNCPRODASSGMT",
"I_PRODUCT",
"I_PRODUCTTEXT"
],
"ASSOCIATED":
[
"I_CHMLCMPLNCINFO"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More