P_SrvcOpenOrderWorkList

DDL: P_SRVCOPENORDERWORKLIST Type: view_entity COMPOSITE

P_SrvcOpenOrderWorkList is a Composite CDS View in SAP S/4HANA. It reads from 3 data sources (I_ServiceOrderEnhcd, I_SrvcEmployeeDetsByLoginUser, I_ServiceDocumentItemEnhcd) and exposes 27 fields with key fields ServiceOrder, ServiceDocumentItem.

3 data source(s) 27 fields

Data Sources (3)

SourceAliasJoin Type
I_ServiceOrderEnhcd _ServiceOrder inner
I_SrvcEmployeeDetsByLoginUser _SrvcEmployeeDetsByLoginUser inner
I_ServiceDocumentItemEnhcd I_ServiceDocumentItemEnhcd from

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
VDM.private true view
VDM.viewType #COMPOSITE view

Fields (27)

KeyFieldSource TableSource FieldDescription
KEY ServiceOrder I_ServiceDocumentItemEnhcd ServiceDocument
KEY ServiceDocumentItem I_ServiceDocumentItemEnhcd ServiceDocumentItem
ServiceOrderDescription I_ServiceDocumentItemEnhcd ServiceDocumentDescription
BusinessPartnerName
ServiceOrderPriority I_ServiceOrderEnhcd ServiceOrderPriority
ServiceDocumentPriorityName
RequestedServiceStartDate I_ServiceOrderEnhcd RequestedServiceStartDate
RequestedServiceEndDate I_ServiceOrderEnhcd RequestedServiceEndDate
ActualDurationInHours I_ServiceOrderEnhcd ActualDurationInHours
ResponsibleEmployee I_ServiceOrderEnhcd ResponsibleEmployee
ServiceOrderStatus I_ServiceOrderEnhcd ServiceOrderStatus
SrvcConfGrossAmount I_ServiceOrderEnhcd SrvcConfGrossAmount
ServiceDocGrossAmount I_ServiceOrderEnhcd ServiceDocGrossAmount
TransactionCurrency I_ServiceOrderEnhcd TransactionCurrency
SalesOrganization I_ServiceDocumentItemEnhcd SalesOrganization
DistributionChannel I_ServiceDocumentItemEnhcd DistributionChannel
Division I_ServiceDocumentItemEnhcd Division
SalesOffice I_ServiceDocumentItemEnhcd SalesOffice
SalesGroup I_ServiceDocumentItemEnhcd SalesGroup
ServiceObjectType I_ServiceDocumentItemEnhcd ServiceObjectType
ServiceDocumentUUID I_ServiceDocumentItemEnhcd ServiceDocumentUUID
ServiceDocumentType I_ServiceDocumentItemEnhcd ServiceDocumentType
SalesOrganizationOrgUnitID I_ServiceDocumentItemEnhcd SalesOrganizationOrgUnitID
SalesOfficeOrgUnitID I_ServiceDocumentItemEnhcd SalesOfficeOrgUnitID
SalesGroupOrgUnitID I_ServiceDocumentItemEnhcd SalesGroupOrgUnitID
ServiceOrganization I_ServiceDocumentItemEnhcd ServiceOrganization
SoldToParty I_ServiceDocumentItemEnhcd SoldToParty 
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #NOT_REQUIRED
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType:{
    serviceQuality: #X,
    sizeCategory: #S,
    dataClass: #MIXED
}
@VDM.private:true
@VDM: {
  viewType: #COMPOSITE
}
define view entity P_SrvcOpenOrderWorkList
  as select from I_ServiceDocumentItemEnhcd
    inner join   I_SrvcEmployeeDetsByLoginUser as _SrvcEmployeeDetsByLoginUser on I_ServiceDocumentItemEnhcd.ServiceEmployee = _SrvcEmployeeDetsByLoginUser.BusinessPartner
  //association [1..1] to I_ServiceOrderEnhcd as _ServiceOrder on $projection.ServiceOrder = _ServiceOrder.ServiceOrder

    inner join   I_ServiceOrderEnhcd           as _ServiceOrder                on I_ServiceDocumentItemEnhcd.ServiceDocument = _ServiceOrder.ServiceOrder

{

  key   I_ServiceDocumentItemEnhcd.ServiceDocument            as ServiceOrder,

  key   I_ServiceDocumentItemEnhcd.ServiceDocumentItem,

        I_ServiceDocumentItemEnhcd.ServiceDocumentDescription as ServiceOrderDescription,


        //SoldToParty,

        _ServiceOrder._SoldToParty.BusinessPartnerName        as BusinessPartnerName,


        _ServiceOrder.ServiceOrderPriority,

        _ServiceOrder._ServiceDocumentPriority._ServiceDocumentPriorityText[1:Language = $session.system_language].ServiceDocumentPriorityName,

        _ServiceOrder.RequestedServiceStartDate,

        _ServiceOrder.RequestedServiceEndDate,

        _ServiceOrder.ActualDurationInHours,

        _ServiceOrder.ResponsibleEmployee,

        _ServiceOrder.ServiceOrderStatus,

        @Semantics.amount.currencyCode: 'TransactionCurrency'
        _ServiceOrder.SrvcConfGrossAmount,

        @Semantics.amount.currencyCode: 'TransactionCurrency'
        _ServiceOrder.ServiceDocGrossAmount,

        _ServiceOrder.TransactionCurrency,

        I_ServiceDocumentItemEnhcd.SalesOrganization,

        I_ServiceDocumentItemEnhcd.DistributionChannel,

        I_ServiceDocumentItemEnhcd.Division,

        I_ServiceDocumentItemEnhcd.SalesOffice,

        I_ServiceDocumentItemEnhcd.SalesGroup,

        I_ServiceDocumentItemEnhcd.ServiceObjectType,

        //Incident 2080126797

        //@Consumption.hidden: true

        @UI.hidden: true
        I_ServiceDocumentItemEnhcd.ServiceDocumentUUID,

        I_ServiceDocumentItemEnhcd.ServiceDocumentType,

        @Consumption.filter.hidden: true
        @UI.hidden: true
        I_ServiceDocumentItemEnhcd.SalesOrganizationOrgUnitID,
        @Consumption.filter.hidden: true
        @UI.hidden: true
        I_ServiceDocumentItemEnhcd.SalesOfficeOrgUnitID,
        @Consumption.filter.hidden: true
        @UI.hidden: true
        I_ServiceDocumentItemEnhcd.SalesGroupOrgUnitID,
        @Consumption.filter.hidden: true
        @UI.hidden: true
        I_ServiceDocumentItemEnhcd.ServiceOrganization,

        I_ServiceDocumentItemEnhcd.SoldToParty
        // _SoldToParty

}
where
  _ServiceOrder.ServiceDocumentIsOpen = 'X'

Learn More