A_ChangeRecord

DDL: A_CHANGERECORD Type: view_entity COMPOSITE

Change Record Header Data

A_ChangeRecord is a Composite CDS View that provides data about "Change Record Header Data" in SAP S/4HANA. It reads from 1 data source (I_ChangeRecordTP_2) and exposes 48 fields with key field ChangeRecordUUID. It has 34 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_ChangeRecordTP_2 I_ChangeRecordTP_2 from

Associations (34)

CardinalityTargetAliasCondition
[0..1] E_ChangeRecordBsc _HeaderExtension $projection.ChangeRecordUUID = _HeaderExtension.ChangeRecordUUID
[0..1] A_ChgRecdBusinessPartner _ChangeRecordBusinessPartner $projection.Partner = _ChangeRecordBusinessPartner.Partner
[0..1] A_ChangeRecordLifeCycleStatus _ChangeRecordLifeCycleStatus $projection.ChangeRecordLifecycleStatus = _ChangeRecordLifeCycleStatus.ChangeRecordLifecycleStatus
[0..1] A_ChgRecordUserStatus _ChangeRecordUserStatus $projection.ChangeRecordStatus = _ChangeRecordUserStatus.ChangeRecordStatus
[0..*] A_ChangeRecordReferenceMat _RefMat
[0..*] A_ChangeRecordReferenceBOM _RefBOM
[0..*] A_ChangeRecordReferenceDoc _RefDoc
[0..*] A_ChangeRecordReferenceBit _RefBit
[0..*] A_ChangeRecordReferencePSV _RefPSV
[0..*] A_ChangeRecordRefInspPlan _ChangeRecordRefInspPlan
[0..*] A_ChangeRecordRefRecipe _ChangeRecordRefRecipe
[0..*] A_ChangeRecordRefMasterRecipe _ChangeRecordRefMasterRecipe
[0..*] A_ChangeRecordRefLabelSet _ChangeRecordRefLabelSet
[0..*] A_ChangeRecordRefSpecification _ChangeRecordRefSpecification
[0..*] A_ChangeRecordRefProdnRouting _ChangeRecordRefProdnRouting
[0..*] A_ChangeRecordRefTmplRouting _ChangeRecordRefTmplRouting
[0..*] A_ChangeRecordRefClass _ChangeRecordRefClass
[0..*] A_ChangeRecordRefCharc _ChangeRecordRefCharc
[0..*] A_ChgRecdRefEquipTskList _ChangeRecordRefEquipTskList
[0..*] A_ChgRecdFuncLocTskList _ChangeRecordFuncLocTskList
[0..*] A_ChgRecdRefOpSetTskList _ChangeRecordRefOpSetTskList
[0..*] A_ChgRecdRateRtgTskList _ChangeRecordRateRtgTskList
[0..*] A_ChgRecdRefRateRtgTskList _ChgRecdRefRateRtgTskList
[0..*] A_ChgRecdRefCutPlngPrflTskList _ChgRecdRefCutPlngPrflTskList
[0..*] A_ChgRecdWBSElmntBOM _ChgRecdWBSElmntBOM
[0..*] A_ChgRecdEquipBOM _ChgRecdEquipBOM
[0..*] A_ChgRecdFuncLocBOM _ChgRecdFuncLocBOM
[0..*] A_ChgRecdObjPgMaintTskList _ChgRecdRefMaintTskList
[0..*] A_ChgRecdRefStdBOM _ChangeRecordRefStdBOM
[0..*] A_ChgRecdRefVarBOM _ChangeRecordRefVarBOM
[0..*] A_ChgRecdRefEngBOM _ChgRecdRefEngBOM
[0..*] A_ChgRecdRefPlngScope _ChgRecdRefPlngScp
[0..*] A_ChgRecdRefMfgBOM _ChgRecdRefMfgBOM
[0..*] A_ChgRecdPLMEPDCollabn _ChgRecdCollaboration

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
OData.entitySet.name A_ChangeRecord view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #MIXED view
EndUserText.label Change Record Header Data view

Fields (48)

KeyFieldSource TableSource FieldDescription
KEY ChangeRecordUUID ChangeRecordUUID
ChangeRecord ChangeRecord
ChangeRecordType ChangeRecordType
ChangeRecordStatus ChangeRecordStatus
ChangeRecordStatusDescription
ChangeNumber ChangeNumber
CreatedByUser CreatedByUser
CreationDateTime CreationDateTime
LastChangedByUser LastChangedByUser
ChangeRecordLifecycleStatus ChangeRecordLifecycleStatus
ChangeRecordLifecycleStatusTxt _ChangeRecordLifeCycleStatus ChangeRecordLifecycleStatusTxt
Partner Partner
ChgRecordDescriptionText ChgRecordDescriptionText
ChangeRecordDetailDescription ChangeRecordDetailDescription
ChgRecdExpectedCompletionDate ChgRecdExpectedCompletionDate
_RefMat _RefMat
_RefBOM _RefBOM
_RefDoc _RefDoc
_RefBit _RefBit
_RefPSV _RefPSV
_ChangeRecordRefInspPlan _ChangeRecordRefInspPlan
_ChangeRecordRefRecipe _ChangeRecordRefRecipe
_ChangeRecordRefMasterRecipe _ChangeRecordRefMasterRecipe
_ChangeRecordRefLabelSet _ChangeRecordRefLabelSet
_ChangeRecordRefSpecification _ChangeRecordRefSpecification
_ChangeRecordRefProdnRouting _ChangeRecordRefProdnRouting
_ChangeRecordRefTmplRouting _ChangeRecordRefTmplRouting
_ChangeRecordRefClass _ChangeRecordRefClass
_ChangeRecordRefCharc _ChangeRecordRefCharc
_ChangeRecordRefEquipTskList _ChangeRecordRefEquipTskList
_ChangeRecordFuncLocTskList _ChangeRecordFuncLocTskList
_ChangeRecordRefOpSetTskList _ChangeRecordRefOpSetTskList
_ChangeRecordRateRtgTskList _ChangeRecordRateRtgTskList
_ChgRecdRefRateRtgTskList _ChgRecdRefRateRtgTskList
_ChgRecdRefCutPlngPrflTskList _ChgRecdRefCutPlngPrflTskList
_ChgRecdWBSElmntBOM _ChgRecdWBSElmntBOM
_ChgRecdEquipBOM _ChgRecdEquipBOM
_ChgRecdFuncLocBOM _ChgRecdFuncLocBOM
_ChgRecdRefMaintTskList _ChgRecdRefMaintTskList
_ChangeRecordRefStdBOM _ChangeRecordRefStdBOM
_ChangeRecordRefVarBOM _ChangeRecordRefVarBOM
_ChangeRecordBusinessPartner _ChangeRecordBusinessPartner
_ChgRecdRefEngBOM _ChgRecdRefEngBOM
_ChgRecdRefPlngScp _ChgRecdRefPlngScp
_ChgRecdRefMfgBOM _ChgRecdRefMfgBOM
_ChgRecdCollaboration _ChgRecdCollaboration
_ChangeRecordLifeCycleStatus _ChangeRecordLifeCycleStatus
_ChangeRecordUserStatus _ChangeRecordUserStatus
@AccessControl.authorizationCheck: #CHECK
@OData.entitySet.name : 'A_ChangeRecord'
@VDM.viewType: #COMPOSITE
@VDM.lifecycle.contract.type: #PUBLIC_REMOTE_API
@Metadata.ignorePropagatedAnnotations: true
//@ObjectModel.transactionalProcessingDelegated: true

@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.dataClass: #MIXED
//@ObjectModel: {

//  compositionRoot: true,

//  // representativeKey: 'ChangeRecord',

////   createEnabled: true,  // opened for test

//   usageType: {

//     dataClass:      #TRANSACTIONAL,

//     serviceQuality: #D,

//     sizeCategory:   #L

//   }

//}

//@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED

//@ObjectModel.updateEnabled: true

//@ObjectModel.deleteEnabled: true

//@ObjectModel.writeActiveImplementedBy: 'ABAP:ZCL_RAP_PLMI_CR'

@EndUserText.label: 'Change Record Header Data'
define root view entity A_ChangeRecord
  as select from I_ChangeRecordTP_2
  association [0..1] to E_ChangeRecordBsc              as _HeaderExtension             on $projection.ChangeRecordUUID = _HeaderExtension.ChangeRecordUUID
  association [0..1] to A_ChgRecdBusinessPartner       as _ChangeRecordBusinessPartner on $projection.Partner = _ChangeRecordBusinessPartner.Partner

  association [0..1] to A_ChangeRecordLifeCycleStatus  as _ChangeRecordLifeCycleStatus on $projection.ChangeRecordLifecycleStatus = _ChangeRecordLifeCycleStatus.ChangeRecordLifecycleStatus
  association [0..1] to A_ChgRecordUserStatus          as _ChangeRecordUserStatus      on $projection.ChangeRecordStatus = _ChangeRecordUserStatus.ChangeRecordStatus

  composition [0..*] of A_ChangeRecordReferenceMat     as _RefMat
  composition [0..*] of A_ChangeRecordReferenceBOM     as _RefBOM
  composition [0..*] of A_ChangeRecordReferenceDoc     as _RefDoc
  composition [0..*] of A_ChangeRecordReferenceBit     as _RefBit
  composition [0..*] of A_ChangeRecordReferencePSV     as _RefPSV
  composition [0..*] of A_ChangeRecordRefInspPlan      as _ChangeRecordRefInspPlan
  composition [0..*] of A_ChangeRecordRefRecipe        as _ChangeRecordRefRecipe
  composition [0..*] of A_ChangeRecordRefMasterRecipe  as _ChangeRecordRefMasterRecipe
  composition [0..*] of A_ChangeRecordRefLabelSet      as _ChangeRecordRefLabelSet
  composition [0..*] of A_ChangeRecordRefSpecification as _ChangeRecordRefSpecification
  composition [0..*] of A_ChangeRecordRefProdnRouting  as _ChangeRecordRefProdnRouting
  composition [0..*] of A_ChangeRecordRefTmplRouting   as _ChangeRecordRefTmplRouting
  composition [0..*] of A_ChangeRecordRefClass         as _ChangeRecordRefClass
  composition [0..*] of A_ChangeRecordRefCharc         as _ChangeRecordRefCharc
  composition [0..*] of A_ChgRecdRefEquipTskList       as _ChangeRecordRefEquipTskList
  composition [0..*] of A_ChgRecdFuncLocTskList        as _ChangeRecordFuncLocTskList
  composition [0..*] of A_ChgRecdRefOpSetTskList       as _ChangeRecordRefOpSetTskList
  composition [0..*] of A_ChgRecdRateRtgTskList        as _ChangeRecordRateRtgTskList
  composition [0..*] of A_ChgRecdRefRateRtgTskList     as _ChgRecdRefRateRtgTskList
  composition [0..*] of A_ChgRecdRefCutPlngPrflTskList as _ChgRecdRefCutPlngPrflTskList
  composition [0..*] of A_ChgRecdWBSElmntBOM           as _ChgRecdWBSElmntBOM
  composition [0..*] of A_ChgRecdEquipBOM              as _ChgRecdEquipBOM
  composition [0..*] of A_ChgRecdFuncLocBOM            as _ChgRecdFuncLocBOM
  composition [0..*] of A_ChgRecdObjPgMaintTskList     as _ChgRecdRefMaintTskList
  composition [0..*] of A_ChgRecdRefStdBOM             as _ChangeRecordRefStdBOM
  composition [0..*] of A_ChgRecdRefVarBOM             as _ChangeRecordRefVarBOM
  composition [0..*] of A_ChgRecdRefEngBOM             as _ChgRecdRefEngBOM
  composition [0..*] of A_ChgRecdRefPlngScope          as _ChgRecdRefPlngScp
  composition [0..*] of A_ChgRecdRefMfgBOM             as _ChgRecdRefMfgBOM
  composition [0..*] of A_ChgRecdPLMEPDCollabn         as _ChgRecdCollaboration

{
  key    ChangeRecordUUID,
         ChangeRecord,
         ChangeRecordType,
         ChangeRecordStatus,
         I_ChangeRecordTP_2._ChangeRecordUserStatus._Text[1: Language = $session.system_language ].ChangeRecordStatusDescription as ChangeRecordStatusDescription,
         ChangeNumber,
         CreatedByUser,
         CreationDateTime,
         LastChangedByUser,
         case
            when LastChangeDateTime = fltp_to_dec( 0.00 as timestampl )
            then fltp_to_dec( 19720401000000.00 as timestampl )
            else LastChangeDateTime
         end                                                                                                                     as LastChangeDateTime,

         ChangeRecordLifecycleStatus,
         _ChangeRecordLifeCycleStatus.ChangeRecordLifecycleStatusTxt                                                             as ChangeRecordLifecycleStatusTxt,
         Partner,
         ChgRecordDescriptionText,
         ChangeRecordDetailDescription,
         ChgRecdExpectedCompletionDate,
         _RefMat,
         _RefBOM,
         _RefDoc,
         _RefBit,
         _RefPSV,
         _ChangeRecordRefInspPlan,
         _ChangeRecordRefRecipe,
         _ChangeRecordRefMasterRecipe,
         _ChangeRecordRefLabelSet,
         _ChangeRecordRefSpecification,
         _ChangeRecordRefProdnRouting,
         _ChangeRecordRefTmplRouting,
         _ChangeRecordRefClass,
         _ChangeRecordRefCharc,
         _ChangeRecordRefEquipTskList,
         _ChangeRecordFuncLocTskList,
         _ChangeRecordRefOpSetTskList,
         _ChangeRecordRateRtgTskList,
         _ChgRecdRefRateRtgTskList,
         _ChgRecdRefCutPlngPrflTskList,
         _ChgRecdWBSElmntBOM,
         _ChgRecdEquipBOM,
         _ChgRecdFuncLocBOM,
         _ChgRecdRefMaintTskList,
         _ChangeRecordRefStdBOM,
         _ChangeRecordRefVarBOM,
         _ChangeRecordBusinessPartner,
         _ChgRecdRefEngBOM,
         _ChgRecdRefPlngScp,
         _ChgRecdRefMfgBOM,
         _ChgRecdCollaboration,
         _ChangeRecordLifeCycleStatus,
         _ChangeRecordUserStatus

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"A_CHANGERECORDLIFECYCLESTATUS",
"I_CHANGERECORDTP_2",
"I_CHGRECORDUSERSTATUS",
"I_CHGRECORDUSERSTATUSTEXT"
],
"ASSOCIATED":
[
"A_CHANGERECORDLIFECYCLESTATUS",
"A_CHANGERECORDREFCHARC",
"A_CHANGERECORDREFCLASS",
"A_CHANGERECORDREFERENCEBIT",
"A_CHANGERECORDREFERENCEBOM",
"A_CHANGERECORDREFERENCEDOC",
"A_CHANGERECORDREFERENCEMAT",
"A_CHANGERECORDREFERENCEPSV",
"A_CHANGERECORDREFINSPPLAN",
"A_CHANGERECORDREFLABELSET",
"A_CHANGERECORDREFMASTERRECIPE",
"A_CHANGERECORDREFPRODNROUTING",
"A_CHANGERECORDREFRECIPE",
"A_CHANGERECORDREFSPECIFICATION",
"A_CHANGERECORDREFTMPLROUTING",
"A_CHGRECDBUSINESSPARTNER",
"A_CHGRECDEQUIPBOM",
"A_CHGRECDFUNCLOCBOM",
"A_CHGRECDFUNCLOCTSKLIST",
"A_CHGRECDOBJPGMAINTTSKLIST",
"A_CHGRECDPLMEPDCOLLABN",
"A_CHGRECDRATERTGTSKLIST",
"A_CHGRECDREFCUTPLNGPRFLTSKLIST",
"A_CHGRECDREFENGBOM",
"A_CHGRECDREFEQUIPTSKLIST",
"A_CHGRECDREFMFGBOM",
"A_CHGRECDREFOPSETTSKLIST",
"A_CHGRECDREFPLNGSCOPE",
"A_CHGRECDREFRATERTGTSKLIST",
"A_CHGRECDREFSTDBOM",
"A_CHGRECDREFVARBOM",
"A_CHGRECDWBSELMNTBOM",
"A_CHGRECORDUSERSTATUS"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/