I_EngSnpshtOpnChgRecdProdnPlnt

DDL: I_ENGSNPSHTOPNCHGRECDPRODNPLNT SQL: IENGSNPOPNCRPP Type: view COMPOSITE

Engineering Snapshot open CR with produnction plant

I_EngSnpshtOpnChgRecdProdnPlnt is a Composite CDS View that provides data about "Engineering Snapshot open CR with produnction plant" in SAP S/4HANA. It reads from 1 data source (I_ChgRecdRefEngSnpshtBsc) and exposes 15 fields with key fields ChangeRecordUUID, ChangeRecordReferenceUUID, EngSnapshotID, EngSnpshtRevisionNumber.

1 data source(s) 15 fields

Data Sources (1)

SourceAliasJoin Type
I_ChgRecdRefEngSnpshtBsc ChgRecdEngSnpsht from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IENGSNPOPNCRPP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Engineering Snapshot open CR with produnction plant view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY ChangeRecordUUID I_ChgRecdRefEngSnpshtBsc ChangeRecordUUID
KEY ChangeRecordReferenceUUID I_ChgRecdRefEngSnpshtBsc ChangeRecordReferenceUUID
KEY EngSnapshotID
KEY EngSnpshtRevisionNumber I_ChgRecdRefEngSnpshtBsc ChgRecRefInternalKey2
ChangeRecord I_ChgRecdRefEngSnpshtBsc ChangeRecord
ChgRecordDescriptionText
ChangeRecordType
Partner
SourceMaterial ChgRecdPlngScpProdnPlant SourceMaterial
SourcePlant ChgRecdPlngScpProdnPlant SourcePlant
SourceBOMUsage ChgRecdPlngScpProdnPlant SourceBOMUsage
SourceBOMAlternative ChgRecdPlngScpProdnPlant SourceBOMAlternative
ProductionPlant ChgRecdPlngScpProdnPlant ProductionPlant
MBOMUsage ChgRecdPlngScpProdnPlant MBOMUsage
ChgRecdMfgEffectiveDate 
@AbapCatalog.sqlViewName: 'IENGSNPOPNCRPP'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType: {serviceQuality: #C, sizeCategory: #L, dataClass: #TRANSACTIONAL}
@VDM.viewType: #COMPOSITE
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Engineering Snapshot open CR with produnction plant'
define view I_EngSnpshtOpnChgRecdProdnPlnt as select from I_ChgRecdRefEngSnpshtBsc as ChgRecdEngSnpsht
       left outer to many join P_EngSnpshtChgRecdPlngScp as ChgRecdPlngScpProdnPlant on ChgRecdPlngScpProdnPlant.ChangeRecordUUID = ChgRecdEngSnpsht.ChangeRecordUUID  
{
  key  ChgRecdEngSnpsht.ChangeRecordUUID,
  key  ChgRecdEngSnpsht.ChangeRecordReferenceUUID,
  key  cast(SUBSTRING( ChgRecdEngSnpsht.ChgRecRefInternalKey1, 1, 20 ) as mpe_eng_snpsht_id ) as EngSnapshotID,
  key  ChgRecdEngSnpsht.ChgRecRefInternalKey2 as EngSnpshtRevisionNumber,
       ChgRecdEngSnpsht.ChangeRecord,
       ChgRecdEngSnpsht._ChangeRecordBsc.ChgRecordDescriptionText,
       ChgRecdEngSnpsht._ChangeRecordBsc.ChangeRecordType,
       ChgRecdEngSnpsht._ChangeRecordBsc.Partner,
       ChgRecdPlngScpProdnPlant.SourceMaterial,
       ChgRecdPlngScpProdnPlant.SourcePlant,
       ChgRecdPlngScpProdnPlant.SourceBOMUsage,
       ChgRecdPlngScpProdnPlant.SourceBOMAlternative,
       ChgRecdPlngScpProdnPlant.ProductionPlant,
       ChgRecdPlngScpProdnPlant.MBOMUsage,
       ChgRecdEngSnpsht._ChangeRecordBsc.ChgRecdMfgEffectiveDate
}  where  ChgRecdEngSnpsht._ChangeRecordBsc.ChangeRecordLifecycleStatus != '09'  
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CHANGERECORDBSC",
"I_CHGRECDREFENGSNPSHTBSC",
"P_ENGSNPSHTCHGRECDPLNGSCP"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More