I_ChmlCmplncInfoTP
Chemical Compliance Info
I_ChmlCmplncInfoTP is a Transactional CDS View that provides data about "Chemical Compliance Info" in SAP S/4HANA. It reads from 1 data source (I_ChmlCmplncInfo) and exposes 35 fields with key field ChmlCmplncInfoUUID. It has 8 associations to related views. Part of development package EHFND_BO_CCI.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| I_ChmlCmplncInfo | I_ChmlCmplncInfo | from |
Associations (8)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [0..1] | I_ChmlCmplncProdAssgmtTP | _ProductAssignment | $projection.ChmlCmplncInfoUUID = _ProductAssignment.ChmlCmplncInfoUUID |
| [0..*] | I_ChmlCmplncPrpsAssgmtTP | _PurposeAssignment | $projection.ChmlCmplncInfoUUID = _PurposeAssignment.ChmlCmplncInfoUUID |
| [0..*] | I_ChmlCmplncMktReqTP | _MarketRequest | $projection.ChmlCmplncInfoUUID = _MarketRequest.ChmlCmplncInfoUUID |
| [0..*] | I_ChmlCmplncMktCvrgTP | _MarketCoverage | $projection.ChmlCmplncInfoUUID = _MarketCoverage.ChmlCmplncInfoUUID |
| [0..*] | I_ChmlCmplncMatlAssgmtTP | _MaterialAssignment | $projection.ChmlCmplncInfoUUID = _MaterialAssignment.ChmlCmplncInfoUUID |
| [0..*] | I_ChmlCmplncApplAssgmtTP | _Application | $projection.ChmlCmplncInfoUUID = _Application.ChmlCmplncInfoUUID |
| [0..*] | I_ChmlCmplncSuplrMatlAssgmtTP | _SuplrMatlAssignment | $projection.ChmlCmplncInfoUUID = _SuplrMatlAssignment.ChmlCmplncInfoUUID |
| [0..1] | I_ChmlCmplncWasteDataTP | _WasteData | $projection.ChmlCmplncInfoUUID = _WasteData.ChmlCmplncInfoUUID |
Annotations (21)
| Name | Value | Level | Field |
|---|---|---|---|
| AbapCatalog.sqlViewName | ICCINFOTP | view | |
| AbapCatalog.compiler.compareFilter | true | view | |
| AccessControl.authorizationCheck | #CHECK | view | |
| ClientHandling.algorithm | #SESSION_VARIABLE | view | |
| VDM.viewType | #TRANSACTIONAL | view | |
| VDM.lifecycle.contract.type | #SAP_INTERNAL_API | view | |
| ObjectModel.modelCategory | #BUSINESS_OBJECT | view | |
| ObjectModel.compositionRoot | true | view | |
| ObjectModel.draftEnabled | true | view | |
| ObjectModel.transactionalProcessingEnabled | true | view | |
| ObjectModel.createEnabled | true | view | |
| ObjectModel.updateEnabled | EXTERNAL_CALCULATION | view | |
| ObjectModel.deleteEnabled | EXTERNAL_CALCULATION | view | |
| ObjectModel.writeDraftPersistence | ehfndw_cci | view | |
| ObjectModel.writeActivePersistence | ehfndv_cci | view | |
| ObjectModel.entityChangeStateId | LastChangeUTCDateTime | view | |
| ObjectModel.sapObjectNodeType.name | ChemicalComplianceInfo | view | |
| ObjectModel.usageType.dataClass | #MASTER | view | |
| ObjectModel.usageType.sizeCategory | #L | view | |
| ObjectModel.usageType.serviceQuality | #B | view | |
| EndUserText.label | Chemical Compliance Info | view |
Fields (35)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | ChmlCmplncInfoUUID | ChmlCmplncInfoUUID | ||
| ActiveChmlCmplncInfoUUID | ChmlCmplncInfoUUID | |||
| CreatedByUser | CreatedByUser | |||
| LastChangeUTCDateTime | LastChangeUTCDateTime | |||
| LastChangedByUser | LastChangedByUser | |||
| ProdStewardshipRespUnit | ProdStewardshipRespUnit | |||
| DngrsGdsRespUnit | DngrsGdsRespUnit | |||
| ChmlCmplncInfoType | ChmlCmplncInfoType | |||
| ChmlCmplncInternalName | ChmlCmplncInternalName | |||
| ChmlCmplncProdCatztnPhrsUUID | ChmlCmplncProdCatztnPhrsUUID | |||
| MaterialIsBaseProduct | MaterialIsBaseProduct | |||
| MaterialIsSold | MaterialIsSold | |||
| MaterialIsTransported | MaterialIsTransported | |||
| MaterialIsSourced | MaterialIsSourced | |||
| MaterialIsProduced | MaterialIsProduced | |||
| MaterialIsDisposed | MaterialIsDisposed | |||
| MaterialIsEmissionRelevant | MaterialIsEmissionRelevant | |||
| MatlIsMultiComponentProduct | MatlIsMultiComponentProduct | |||
| Specification | Specification | |||
| ChmlCmplncProdIsResearched | ChmlCmplncProdIsResearched | |||
| SpecificationInternalID | SpecificationInternalID | |||
| MatlIsNotProdMarketabilityRlvt | MatlIsNotProdMarketabilityRlvt | |||
| MatlIsNotProdSafetyRlvt | MatlIsNotProdSafetyRlvt | |||
| _MarketRequest | _MarketRequest | |||
| _MarketCoverage | _MarketCoverage | |||
| _MaterialAssignment | _MaterialAssignment | |||
| _ProductAssignment | _ProductAssignment | |||
| _PurposeAssignment | _PurposeAssignment | |||
| _Application | _Application | |||
| _SuplrMatlAssignment | _SuplrMatlAssignment | |||
| _WasteData | _WasteData | |||
| _CreatedByUser | _CreatedByUser | |||
| _LastChangedByUser | _LastChangedByUser | |||
| _RespUnitForDangerousGoods | _RespUnitForDangerousGoods | |||
| _RespUnitForProductStewardship | _RespUnitForProductStewardship |
@AbapCatalog:
{
sqlViewName: 'ICCINFOTP',
compiler.compareFilter: true
}
@AccessControl:
{
authorizationCheck: #CHECK,
privilegedAssociations: [ '_CreatedByUser', '_LastChangedByUser' ]
}
--Client Handling of the view
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #TRANSACTIONAL
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@ObjectModel:
{
modelCategory: #BUSINESS_OBJECT,
compositionRoot: true,
draftEnabled: true,
transactionalProcessingEnabled: true,
createEnabled: true,
updateEnabled: 'EXTERNAL_CALCULATION',
deleteEnabled: 'EXTERNAL_CALCULATION',
writeDraftPersistence: 'ehfndw_cci',
writeActivePersistence: 'ehfndv_cci',
entityChangeStateId: 'LastChangeUTCDateTime',
semanticKey: [ 'ChmlCmplncInfoUUID' ],
sapObjectNodeType.name: 'ChemicalComplianceInfo',
usageType:
{
dataClass: #MASTER,
sizeCategory: #L,
serviceQuality: #B
}
}
@EndUserText.label: 'Chemical Compliance Info'
define view I_ChmlCmplncInfoTP
as select from I_ChmlCmplncInfo
/*+[hideWarning] { "IDS" : [ "CARDINALITY_CHECK" ] }*/
// association returns data only for packaged products; it's the assigned unpackaged product for the packaged product
association [0..1] to I_ChmlCmplncProdAssgmtTP as _ProductAssignment on $projection.ChmlCmplncInfoUUID = _ProductAssignment.ChmlCmplncInfoUUID
association [0..*] to I_ChmlCmplncPrpsAssgmtTP as _PurposeAssignment on $projection.ChmlCmplncInfoUUID = _PurposeAssignment.ChmlCmplncInfoUUID
association [0..*] to I_ChmlCmplncMktReqTP as _MarketRequest on $projection.ChmlCmplncInfoUUID = _MarketRequest.ChmlCmplncInfoUUID
association [0..*] to I_ChmlCmplncMktCvrgTP as _MarketCoverage on $projection.ChmlCmplncInfoUUID = _MarketCoverage.ChmlCmplncInfoUUID
association [0..*] to I_ChmlCmplncMatlAssgmtTP as _MaterialAssignment on $projection.ChmlCmplncInfoUUID = _MaterialAssignment.ChmlCmplncInfoUUID
association [0..*] to I_ChmlCmplncApplAssgmtTP as _Application on $projection.ChmlCmplncInfoUUID = _Application.ChmlCmplncInfoUUID
// association [0..*] to I_ChmlCmplncApplicationTP as _Application on $projection.ChmlCmplncInfoUUID = _Application.ChmlCmplncInfoUUID
association [0..*] to I_ChmlCmplncSuplrMatlAssgmtTP as _SuplrMatlAssignment on $projection.ChmlCmplncInfoUUID = _SuplrMatlAssignment.ChmlCmplncInfoUUID
/*+[hideWarning] { "IDS" : [ "CARDINALITY_CHECK" ] }*/
association [0..1] to I_ChmlCmplncWasteDataTP as _WasteData on $projection.ChmlCmplncInfoUUID = _WasteData.ChmlCmplncInfoUUID
{
@ObjectModel.mandatory: true
key ChmlCmplncInfoUUID,
@ObjectModel.readOnly: true
ChmlCmplncInfoUUID as ActiveChmlCmplncInfoUUID, --Active UUID of Chemical Compliance Information
@ObjectModel.readOnly: true
CreationUTCDateTime,
@ObjectModel.readOnly: true
CreatedByUser,
@ObjectModel.readOnly: true
LastChangeUTCDateTime,
@ObjectModel.readOnly: true
LastChangedByUser,
@ObjectModel.mandatory: true
ProdStewardshipRespUnit,
DngrsGdsRespUnit,
@ObjectModel.mandatory: true
ChmlCmplncInfoType,
@ObjectModel.mandatory: true
ChmlCmplncInternalName,
@ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
ChmlCmplncProdCatztnPhrsUUID,
MaterialIsBaseProduct,
MaterialIsSold,
MaterialIsTransported,
MaterialIsSourced,
MaterialIsProduced,
MaterialIsDisposed,
MaterialIsEmissionRelevant,
MatlIsMultiComponentProduct,
// @ObjectModel.mandatory: true
Specification,
@ObjectModel.readOnly: 'EXTERNAL_CALCULATION'
ChmlCmplncProdIsResearched,
SpecificationInternalID,
-- indicators to disable essential checks
MatlIsNotDngrsGdsRlvt,
MatlIsNotProdMarketabilityRlvt,
MatlIsNotProdSafetyRlvt,
/* Associations */
@ObjectModel.association.type: [ #TO_COMPOSITION_CHILD ]
_MarketRequest,
@ObjectModel.association.type: [ #TO_COMPOSITION_CHILD ]
_MarketCoverage,
@ObjectModel.association.type: [ #TO_COMPOSITION_CHILD ]
_MaterialAssignment,
@ObjectModel.association.type: [ #TO_COMPOSITION_CHILD ]
_ProductAssignment,
@ObjectModel.association.type: [ #TO_COMPOSITION_CHILD ]
_PurposeAssignment,
@ObjectModel.association.type: [ #TO_COMPOSITION_CHILD ]
_Application,
@ObjectModel.association.type: [ #TO_COMPOSITION_CHILD ]
_SuplrMatlAssignment,
@ObjectModel.association.type: [ #TO_COMPOSITION_CHILD ]
_WasteData,
_CreatedByUser,
_LastChangedByUser,
_RespUnitForDangerousGoods,
_RespUnitForProductStewardship
}
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