I_ChangeMasterObjTypeAssgmtTP
Change Number Object Type Assignment (Transactional Proc.)
I_ChangeMasterObjTypeAssgmtTP is a Transactional CDS View that provides data about "Change Number Object Type Assignment (Transactional Proc.)" in SAP S/4HANA. It reads from 1 data source (P_ChangeMasterObjTypeAssgmtTP) and exposes 15 fields with key fields ChangeNumber, ChangeNumberObjectType.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| P_ChangeMasterObjTypeAssgmtTP | P_ChangeMasterObjTypeAssgmtTP | from |
Annotations (7)
| Name | Value | Level | Field |
|---|---|---|---|
| AccessControl.authorizationCheck | #CHECK | view | |
| ObjectModel.usageType.sizeCategory | #L | view | |
| ObjectModel.usageType.serviceQuality | #A | view | |
| ObjectModel.usageType.dataClass | #MASTER | view | |
| VDM.viewType | #TRANSACTIONAL | view | |
| VDM.lifecycle.contract.type | #SAP_INTERNAL_API | view | |
| EndUserText.label | Change Number Object Type Assignment (Transactional Proc.) | view |
Fields (15)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | ChangeNumber | ChangeNumber | ||
| KEY | ChangeNumberObjectType | ChangeNumberObjectType | ||
| IsActiveForChangeNumber | IsActiveForChangeNumber | |||
| IsLockedForChanges | IsLockedForChanges | |||
| IsPartiallyDisplayed | IsPartiallyDisplayed | |||
| ObjMgmtRecdIsRequired | ObjMgmtRecdIsRequired | |||
| ObjMgmtRecdIsGenerated | ObjMgmtRecdIsGenerated | |||
| ObjMgmtRecdIsAutomlyCrted | ObjMgmtRecdIsAutomlyCrted | |||
| ObjMgmtRecdIsAutomlyCrtedByDlg | ObjMgmtRecdIsAutomlyCrtedByDlg | |||
| ObjectTypeCreationDate | ObjectTypeCreationDate | |||
| ObjectTypeCreatedByUser | ObjectTypeCreatedByUser | |||
| ObjectTypeLastChangedDate | ObjectTypeLastChangedDate | |||
| ObjectTypeLastChangedByUser | ObjectTypeLastChangedByUser | |||
| ChangeNumberLastChgdDateTime | _ChangeMaster | ChangeNumberLastChgdDateTime | ||
| _ChangeMaster | _ChangeMaster |
@AccessControl.authorizationCheck: #CHECK
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.dataClass: #MASTER
@VDM.viewType: #TRANSACTIONAL
@VDM.lifecycle.contract.type:#SAP_INTERNAL_API
@EndUserText.label: 'Change Number Object Type Assignment (Transactional Proc.)'
define view entity I_ChangeMasterObjTypeAssgmtTP
as select from P_ChangeMasterObjTypeAssgmtTP
association to parent I_ChangeMasterTP as _ChangeMaster on $projection.ChangeNumber = _ChangeMaster.ChangeNumber
{
key ChangeNumber,
key ChangeNumberObjectType as ChangeNumberObjectType,
key cast(
case ChangeNumberObjectType
when '02' then 'MaterialBOM'
when '31' then 'DocumentInfoRecord'
when '41' then 'Material'
when '51' then 'ClassificationCharacteristic'
when '52' then 'ClassificationClassCharcAssgmt'
when '53' then 'ClassificationValuation'
when '54' then 'VariantConfigurationObjDpndcy'
when '55' then 'VariantConfigurationProfile'
when '63' then 'VariantConfigurationVariantTbl'
when '83' then 'Recipe'
end as sbo_bo_type ) as SAPObjectType,
IsActiveForChangeNumber,
IsLockedForChanges,
IsPartiallyDisplayed,
ObjMgmtRecdIsRequired,
ObjMgmtRecdIsGenerated,
ObjMgmtRecdIsAutomlyCrted,
ObjMgmtRecdIsAutomlyCrtedByDlg,
ObjectTypeCreationDate,
ObjectTypeCreatedByUser,
ObjectTypeLastChangedDate,
ObjectTypeLastChangedByUser,
// for ETag handling
_ChangeMaster.ChangeNumberLastChgdDateTime,
_ChangeMaster
}
where
ChangeNumberObjectType = '02' // 'MaterialBOM'
or ChangeNumberObjectType = '31' // 'DocumentInfoRecord'
or ChangeNumberObjectType = '41' // 'Material'
or ChangeNumberObjectType = '51' // 'ClassificationCharacteristic'
or ChangeNumberObjectType = '52' // 'ClassificationClassCharcAssgmt'
or ChangeNumberObjectType = '53' // 'ClassificationValuation'
or ChangeNumberObjectType = '54' // 'VariantConfigurationObjDpndcy'
or ChangeNumberObjectType = '55' // 'VariantConfigurationProfile'
or ChangeNumberObjectType = '63' // 'VariantConfigurationVariantTbl'
or ChangeNumberObjectType = '83' // 'Recipe'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CHANGEMASTERTP",
"P_CHANGEMASTEROBJTYPEASSGMTTP"
],
"ASSOCIATED":
[
"I_CHANGEMASTERTP"
],
"BASE":
[],
"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