I_CHANGEMASTERTP
Change Number (Transactional Processsing)
I_CHANGEMASTERTP is a CDS View in S/4HANA. Change Number (Transactional Processsing). 2 CDS views read from this table.
CDS Views using this table (2)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| A_ChangeMaster_1 | view_entity | from | CONSUMPTION | Change Number |
| I_ChangeMasterTP_2 | view_entity | projection | TRANSACTIONAL | Change Number Transactional Processing |
@AccessControl.authorizationCheck: #MANDATORY
@ObjectModel.representativeKey: 'ChangeNumber'
@ObjectModel.sapObjectNodeType.name: 'ChangeMaster'
@ObjectModel.semanticKey: [ 'ChangeNumber' ]
@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 (Transactional Processsing)'
define root view entity I_ChangeMasterTP
as select from I_ChangeMaster
composition [1..*] of I_ChangeMasterAltDateTP as _AlternativeDate
composition [1..*] of I_ChangeMasterObjTypeAssgmtTP as _ObjTypeAssignment
composition [1..*] of I_ChangeMstrObjectMgmtRecordTP as _ChangeMstrObjectMgmtRecord
composition [1..*] of I_ChangeMstrObMgReMaterialTP as _ChangeMstrObMgReMaterial
composition [1..*] of I_ChangeMstrObMgReMatlBOMTP as _ChangeMstrObMgReMatlBOM
composition [1..*] of I_ChgMstrObMgReDocInfoRecdTP as _ChangeMstrObMgReDocInfoRecd
{
key ChangeNumber,
ChangeNumberStatus,
AuthorizationGroup,
ChangeNumberFunction,
IsTechnicallyReleased,
ChangeNumberReleaseKey,
ReasonForChangeText,
ChangeNumberDescription,
ChangeNumberValidFromDate,
ChangeNumberCreationDate,
ChangeNumberCreatedByUser,
ChangeNumberLastChangedDate,
ChangeNumberLastChangedByUser,
IsUsedForDataDefinition,
ChangeNumberIsMrkdForDeletion,
case
when ChangeNumberLastChgdDateTime = fltp_to_dec( 0.0 as timestampl )
then fltp_to_dec( 19720401000000.0 as timestampl )
else ChangeNumberLastChgdDateTime
end as ChangeNumberLastChgdDateTime,
_ChangeNumberStatus,
_AlternativeDate,
_ObjTypeAssignment,
_ChangeMstrObjectMgmtRecord,
_ChangeMstrObMgReMaterial,
_ChangeMstrObMgReMatlBOM,
_ChangeMstrObMgReDocInfoRecd,
// Access Control Management non C1 released, not used in DCL anymore
@Consumption.hidden:true
_LogAccMObjectTypeActive,
@Consumption.hidden:true
_LogAccMObjectUserAuthzn,
@Consumption.hidden:true
_LogAccMObjSecureIDAssgmt,
// Access Control Management C1 released, used in DCL
@Consumption.hidden:true
_ChangeMasterLogAccMActive,
@Consumption.hidden:true
_ChgMstrLogAccMSecureIDAssgmt,
@Consumption.hidden:true
_ChangeMstrLogAccMUserAuthzn
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CHANGEMASTER"
],
"ASSOCIATED":
[
"I_CHANGEMASTERALTDATETP",
"I_CHANGEMASTERLOGACCMACTIVE",
"I_CHANGEMASTEROBJTYPEASSGMTTP",
"I_CHANGEMASTERSTATUS",
"I_CHANGEMSTRLOGACCMUSERAUTHZN",
"I_CHANGEMSTROBJECTMGMTRECORDTP",
"I_CHANGEMSTROBMGREMATERIALTP",
"I_CHANGEMSTROBMGREMATLBOMTP",
"I_CHGMSTRLOGACCMSECUREIDASSGMT",
"I_CHGMSTROBMGREDOCINFORECDTP",
"I_LOGACCMOBJECTTYPEACTIVE",
"I_LOGACCMOBJECTUSERAUTHZN",
"I_LOGACCMOBJSECUREIDASSGMT"
],
"BASE":
[
"I_CHANGEMASTER"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/