A_ChgRecdRefPlngScope

DDL: A_CHGRECDREFPLNGSCOPE Type: view_entity COMPOSITE

Change Record ref Planning Scope

A_ChgRecdRefPlngScope is a Composite CDS View that provides data about "Change Record ref Planning Scope" in SAP S/4HANA. It reads from 1 data source (I_ChgRecdRefPlngScpBsc) and exposes 22 fields with key field ChangeRecordReferenceUUID.

1 data source(s) 22 fields

Data Sources (1)

SourceAliasJoin Type
I_ChgRecdRefPlngScpBsc reference_pls from

Annotations (9)

NameValueLevelField
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
Metadata.ignorePropagatedAnnotations true view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
Feature BF:API_FULLSCOPE view
EndUserText.label Change Record ref Planning Scope view

Fields (22)

KeyFieldSource TableSource FieldDescription
KEY ChangeRecordReferenceUUID I_ChgRecdRefPlngScpBsc ChangeRecordReferenceUUID
DocumentId PlanningScope DocumentId
SourceMaterialasmatnrendasSourceMaterial
PlanningScopeDescription PlanningScope PlanningScopeDescription
MBOMUsage PlanningScope MBOMUsage
IsVersionBillOfMaterial PlanningScope IsVersionBillOfMaterial
SourceBOMIsVersioned PlanningScope SourceBOMIsVersioned
TargetMaterial PlanningScope TargetMaterial
ProductionPlant PlanningScope Plant
ChangeRecordUUID I_ChgRecdRefPlngScpBsc ChangeRecordUUID
ChangeRecord I_ChgRecdRefPlngScpBsc ChangeRecord
ChangeRecordReferenceType I_ChgRecdRefPlngScpBsc ChangeRecordReferenceType
ChangeRecordReferenceSubtype I_ChgRecdRefPlngScpBsc ChangeRecordReferenceSubtype
ParentChangeRecordRefUUID I_ChgRecdRefPlngScpBsc ParentChangeRecordRefUUID
CreatedByUser I_ChgRecdRefPlngScpBsc CreatedByUser
CreationDateTime I_ChgRecdRefPlngScpBsc CreationDateTime
LastChangeDateTime I_ChgRecdRefPlngScpBsc LastChangeDateTime
LastChangedByUser I_ChgRecdRefPlngScpBsc LastChangedByUser
ChangeRecordItemRelevance I_ChgRecdRefPlngScpBsc ChangeRecordItemRelevance
ChangeRecordVirtualRefInd I_ChgRecdRefPlngScpBsc ChangeRecordVirtualRefInd
ChangeRecordItemProcgStatus I_ChgRecdRefPlngScpBsc ChangeRecordItemProcgStatus
_ChangeRecord _ChangeRecord 
@VDM.viewType: #COMPOSITE
@AccessControl.authorizationCheck: #MANDATORY
@ObjectModel: {
//   createEnabled: true,

   usageType: {
     dataClass:      #TRANSACTIONAL,
     serviceQuality: #D,
     sizeCategory:   #L
   }
}

@Metadata: {
  ignorePropagatedAnnotations: true
}
@VDM.lifecycle.contract.type: #PUBLIC_REMOTE_API

@Feature: 'BF:API_FULLSCOPE'
@EndUserText.label: 'Change Record ref Planning Scope'
define view entity A_ChgRecdRefPlngScope
  as select from    I_ChgRecdRefPlngScpBsc as reference_pls
    left outer to one join I_PlngScpHdr           as PlanningScope on  reference_pls.ChgRecRefInternalKey1 = PlanningScope.DocumentId
                                                            and reference_pls.ChgRecRefInternalKey2 = PlanningScope.PlanningScopeAlternative
  association        to parent A_ChangeRecord     as _ChangeRecord on $projection.ChangeRecordUUID = _ChangeRecord.ChangeRecordUUID

{
  key   reference_pls.ChangeRecordReferenceUUID,

        PlanningScope.DocumentId,
        case when PlanningScope.SourceMaterial is null then cast(substring( reference_pls.ChangeRecordReference, 1, 40) as matnr)
           else cast(PlanningScope.SourceMaterial as matnr)
           end                       as SourceMaterial,
        case when PlanningScope.SourcePlant is null then cast(substring( reference_pls.ChangeRecordReference, 41, 4) as vmp_source_plant)
        else cast(PlanningScope.SourcePlant as vmp_source_plant)
        end                          as SourcePlant,

        case when PlanningScope.SourceBOMUsage is null then cast(substring( reference_pls.ChangeRecordReference, 45, 1) as vmp_source_stlan)
            else cast(PlanningScope.SourceBOMUsage as vmp_source_stlan)
            end                      as SourceBOMUsage,


        case when PlanningScope.SourceBOMAlternative is null then cast(substring( reference_pls.ChangeRecordReference, 46, 2) as vmp_source_stalt)
        else cast(PlanningScope.SourceBOMAlternative as vmp_source_stalt)
        end                          as SourceBOMAlternative,

        case when PlanningScope.PlanningScopeAlternative is null then cast(substring( reference_pls.ChangeRecordReference, 48, 4) as vmp_plnscp_alt)
        else cast(PlanningScope.PlanningScopeAlternative as vmp_plnscp_alt)
        end                          as PlanningScopeAlternative,

        PlanningScope.PlanningScopeDescription,
        PlanningScope.MBOMUsage,
        PlanningScope.IsVersionBillOfMaterial,
        PlanningScope.SourceBOMIsVersioned,
        PlanningScope.TargetMaterial,
        PlanningScope.Plant           as ProductionPlant,
        reference_pls.ChangeRecordUUID,
        reference_pls.ChangeRecord,
        reference_pls.ChangeRecordReferenceType,
        reference_pls.ChangeRecordReferenceSubtype,
        reference_pls.ParentChangeRecordRefUUID,
        reference_pls.CreatedByUser,
        reference_pls.CreationDateTime,
        reference_pls.LastChangeDateTime,
        reference_pls.LastChangedByUser,
        reference_pls.ChangeRecordItemRelevance,
        reference_pls.ChangeRecordVirtualRefInd,
        reference_pls.ChangeRecordItemProcgStatus,

        //Association //

        _ChangeRecord

}

Learn More