C_ChmlCmplncMktProdAssgmt

DDL: C_CHMLCMPLNCMKTPRODASSGMT Type: view CONSUMPTION

Packaged Product Assignment

C_ChmlCmplncMktProdAssgmt is a Consumption CDS View that provides data about "Packaged Product Assignment" in SAP S/4HANA. It reads from 1 data source (I_ChmlCmplncProdAssgmt) and exposes 10 fields with key field ChmlCmplncProdAssgmtUUID. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_ChmlCmplncProdAssgmt I_ChmlCmplncProdAssgmt from

Associations (3)

CardinalityTargetAliasCondition
[1..1] C_ChmlCmplncMktTP _ChmlCmplncMktTP _ChmlCmplncMktTP.ChmlCmplncInfoUUID = $projection.ChmlCmplncProdUUID
[1..1] I_ChmlCmplncInfoTP _ChmlCmplncInfoTP _ChmlCmplncInfoTP.ChmlCmplncInfoUUID = $projection.ChmlCmplncInfoUUID
[1..1] I_ChmlCmplncMktReq _ChmlCmplncMktReq _ChmlCmplncMktReq.ChmlCmplncInfoUUID = $projection.ChmlCmplncInfoUUID

Annotations (14)

NameValueLevelField
EndUserText.label Packaged Product Assignment view
AbapCatalog.sqlViewName CCCMKTPRODASSGMT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view
UI.headerInfo.typeName Packaged Products view
UI.headerInfo.typeNamePlural Packaged Products view
UI.headerInfo.title.value ProductName view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY ChmlCmplncProdAssgmtUUID ChmlCmplncProdAssgmtUUID
ChmlCmplncInfoUUID ChmlCmplncInfoUUID
ChmlCmplncProdUUID ChmlCmplncProdUUID
ActiveChmlCmplncInfoUUID _ChmlCmplncInfoTP ActiveChmlCmplncInfoUUID
MaterialasMaterial
Applicationnotneededatthemoment
_ChmlCmplncMktTP _ChmlCmplncMktTP
_ChmlCmplncInfoTP _ChmlCmplncInfoTP
_ChmlCmplncInfoProduct _ChmlCmplncInfoProduct
_ChmlCmplncMktReq _ChmlCmplncMktReq
@EndUserText.label: 'Packaged Product Assignment'

@AbapCatalog:
{
  sqlViewName: 'CCCMKTPRODASSGMT',
  compiler.compareFilter: true,
  preserveKey: true
}

@AccessControl:
{
  authorizationCheck: #CHECK,
  // blocking of personal data not required (no personal data fields exposed for material; user can not be blocked)

  personalData.blocking: #NOT_REQUIRED
}

@ClientHandling.algorithm: #SESSION_VARIABLE

@VDM.viewType: #CONSUMPTION

@ObjectModel:
{
  semanticKey:  [ 'ProductName' ],
  usageType:
  {
    dataClass: #MASTER,
    sizeCategory: #L,
    serviceQuality: #C
  }
}

@UI : {
  headerInfo : {
    typeName: 'Packaged Products',
    typeNamePlural: 'Packaged Products',
    title.value: 'ProductName'  --> CoPilot
  },
  presentationVariant: [{ sortOrder: [{ by: 'ProductName', direction: #ASC }] }]
}

define view C_ChmlCmplncMktProdAssgmt
  as select from I_ChmlCmplncProdAssgmt
  association [1..1] to C_ChmlCmplncMktTP  as _ChmlCmplncMktTP  on _ChmlCmplncMktTP.ChmlCmplncInfoUUID = $projection.ChmlCmplncProdUUID
  association [1..1] to I_ChmlCmplncInfoTP as _ChmlCmplncInfoTP on _ChmlCmplncInfoTP.ChmlCmplncInfoUUID = $projection.ChmlCmplncInfoUUID
  association [1..1] to I_ChmlCmplncMktReq as _ChmlCmplncMktReq on _ChmlCmplncMktReq.ChmlCmplncInfoUUID = $projection.ChmlCmplncInfoUUID
{

      @UI:
        {
          -- Facet Annotations
          facet:
          [
            -- Facet 'Market Coverage'
            {
              label: 'Packaged Products',
              id: 'CCCMKTPRODASSGMT_PP',
              type: #COLLECTION,
              position: 10
            },
              -- Facet 'Market Coverage' - Identification
              {
                label: 'Packaged Products',
                id: 'CCCMKTPRODASSGMT_PPLI',
                parentId: 'CCCMKTPRODASSGMT_PP',
                position: 10,
                type: #IDENTIFICATION_REFERENCE
              }
          ]
        }

      @UI.hidden: true
      @ObjectModel.readOnly: true
  key ChmlCmplncProdAssgmtUUID,

      // key of packaged produc

      @UI.hidden: true
      @ObjectModel.readOnly: true
      ChmlCmplncInfoUUID,

      // Key of unpackaged product

      //--[ GENERATED:012:GlBfhyFV7jY4i}8L6{LzUW

      @Consumption.valueHelpDefinition: [
        { entity:  { name:    'I_ChmlCmplncInfoStdVH',
                     element: 'ChmlCmplncInfoUUID' }
        }]
      // ]--GENERATED

      @UI.hidden: true
      @ObjectModel.readOnly: true
      ChmlCmplncProdUUID,

      @UI.hidden: true
      @ObjectModel.readOnly: true
      _ChmlCmplncInfoTP.ActiveChmlCmplncInfoUUID                                                                                                                      as ActiveChmlCmplncInfoUUID,


      --Material name
      @UI:
      {
        lineItem:
        {
          position: 10
        }
      }
      @ObjectModel.readOnly: true
      cast(_ChmlCmplncInfo._MaterialAssignment[1: Material = Material]._Product._Text[1: Language = $session.system_language ].ProductName as ehfnd_cci_product_name) as ProductName,



      --Material/Product number
      @UI:
      {
        lineItem:
        {
          position: 20
        }
      }
      @ObjectModel:{
        readOnly: true
      }
      @Consumption.filter.hidden: true
      _ChmlCmplncInfo._MaterialAssignment[1: Material = Material].Material                                                                                            as Material,

      --Application not needed at the moment, but kept here if it will be needed in the future
      //      @UI:

      //      {

      //        lineItem:

      //        {

      //          position: 30,

      //          importance: #LOW

      //        },

      //        multiLineText: true

      //      }

      @ObjectModel.virtualElement
      @ObjectModel.virtualElementCalculatedBy: 'ABAP:CL_EHPMA_MKT_CALC_EXIT2'
      @ObjectModel.readOnly: true
      cast( '' as ehpma_application_long )                                                                                                                            as ChmlCmplncApplication,

      _ChmlCmplncMktTP,
      _ChmlCmplncInfoTP,
      _ChmlCmplncInfoProduct,
      _ChmlCmplncMktReq
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CHMLCMPLNCINFO",
"I_CHMLCMPLNCINFOTP",
"I_CHMLCMPLNCMATLASSGMT",
"I_CHMLCMPLNCPRODASSGMT",
"I_PRODUCT",
"I_PRODUCTTEXT"
],
"ASSOCIATED":
[
"C_CHMLCMPLNCMKTTP",
"I_CHMLCMPLNCINFO",
"I_CHMLCMPLNCINFOTP",
"I_CHMLCMPLNCMKTREQ"
],
"BASE":
[
"I_CHMLCMPLNCPRODASSGMT"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/