C_ChmlCmplncMktProdAssgmt
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)
| Source | Alias | Join Type |
|---|---|---|
| I_ChmlCmplncProdAssgmt | I_ChmlCmplncProdAssgmt | from |
Associations (3)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [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)
| Name | Value | Level | Field |
|---|---|---|---|
| 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)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| 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":""
}
}*/
Learn More
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Annotations — A Complete Guide
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA