P_SrvcOpenOrderWorkList

DDL: P_SRVCOPENORDERWORKLIST Type: view_entity COMPOSITE
27 Fields 3 Data Sources

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.

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 Transaction ID
KEY ServiceDocumentItem I_ServiceDocumentItemEnhcd ServiceDocumentItem Service Document
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 Employee Resp.
ServiceOrderStatus I_ServiceOrderEnhcd ServiceOrderStatus
SrvcConfGrossAmount I_ServiceOrderEnhcd SrvcConfGrossAmount
ServiceDocGrossAmount I_ServiceOrderEnhcd ServiceDocGrossAmount
TransactionCurrency I_ServiceOrderEnhcd TransactionCurrency Transaction Currency
SalesOrganization I_ServiceDocumentItemEnhcd SalesOrganization Sales Organization
DistributionChannel I_ServiceDocumentItemEnhcd DistributionChannel RefDistCh-Cust/Mat.
Division I_ServiceDocumentItemEnhcd Division Internal Division ID
SalesOffice I_ServiceDocumentItemEnhcd SalesOffice Sales Office
SalesGroup I_ServiceDocumentItemEnhcd SalesGroup Sales Group
ServiceObjectType I_ServiceDocumentItemEnhcd ServiceObjectType Object Type
ServiceDocumentUUID I_ServiceDocumentItemEnhcd ServiceDocumentUUID Object GUID
ServiceDocumentType I_ServiceDocumentItemEnhcd ServiceDocumentType Transaction Type
SalesOrganizationOrgUnitID I_ServiceDocumentItemEnhcd SalesOrganizationOrgUnitID
SalesOfficeOrgUnitID I_ServiceDocumentItemEnhcd SalesOfficeOrgUnitID
SalesGroupOrgUnitID I_ServiceDocumentItemEnhcd SalesGroupOrgUnitID
ServiceOrganization I_ServiceDocumentItemEnhcd ServiceOrganization
SoldToParty I_ServiceDocumentItemEnhcd SoldToParty Sold-to Party

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view P_SrvcOpenOrderWorkList.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW P_SrvcOpenOrderWorkList AS
SELECT
  I_ServiceDocumentItemEnhcd.ServiceDocument AS ServiceOrder,
  I_ServiceDocumentItemEnhcd.ServiceDocumentItem AS ServiceDocumentItem,
  I_ServiceDocumentItemEnhcd.ServiceDocumentDescription AS ServiceOrderDescription,
  _ServiceOrder._SoldToParty.BusinessPartnerName AS BusinessPartnerName,
  _ServiceOrder.ServiceOrderPriority AS ServiceOrderPriority,
  _ServiceOrder._ServiceDocumentPriority._ServiceDocumentPriorityText[1:Language = $session.system_language].ServiceDocumentPriorityName AS ServiceDocumentPriorityName,
  _ServiceOrder.RequestedServiceStartDate AS RequestedServiceStartDate,
  _ServiceOrder.RequestedServiceEndDate AS RequestedServiceEndDate,
  _ServiceOrder.ActualDurationInHours AS ActualDurationInHours,
  _ServiceOrder.ResponsibleEmployee AS ResponsibleEmployee,
  _ServiceOrder.ServiceOrderStatus AS ServiceOrderStatus,
  _ServiceOrder.SrvcConfGrossAmount AS SrvcConfGrossAmount,
  _ServiceOrder.ServiceDocGrossAmount AS ServiceDocGrossAmount,
  _ServiceOrder.TransactionCurrency AS TransactionCurrency,
  I_ServiceDocumentItemEnhcd.SalesOrganization AS SalesOrganization,
  I_ServiceDocumentItemEnhcd.DistributionChannel AS DistributionChannel,
  I_ServiceDocumentItemEnhcd.Division AS Division,
  I_ServiceDocumentItemEnhcd.SalesOffice AS SalesOffice,
  I_ServiceDocumentItemEnhcd.SalesGroup AS SalesGroup,
  I_ServiceDocumentItemEnhcd.ServiceObjectType AS ServiceObjectType,
  I_ServiceDocumentItemEnhcd.ServiceDocumentUUID AS ServiceDocumentUUID,
  I_ServiceDocumentItemEnhcd.ServiceDocumentType AS ServiceDocumentType,
  I_ServiceDocumentItemEnhcd.SalesOrganizationOrgUnitID AS SalesOrganizationOrgUnitID,
  I_ServiceDocumentItemEnhcd.SalesOfficeOrgUnitID AS SalesOfficeOrgUnitID,
  I_ServiceDocumentItemEnhcd.SalesGroupOrgUnitID AS SalesGroupOrgUnitID,
  I_ServiceDocumentItemEnhcd.ServiceOrganization AS ServiceOrganization,
  I_ServiceDocumentItemEnhcd.SoldToParty AS SoldToParty
FROM I_ServiceDocumentItemEnhcd
INNER JOIN I_SrvcEmployeeDetsByLoginUser AS _SrvcEmployeeDetsByLoginUser ON /* join condition not captured in parsed metadata */
INNER JOIN I_ServiceOrderEnhcd AS _ServiceOrder ON /* join condition not captured in parsed metadata */
;

Learn More