C_SrvcDocItemProcessFlow

DDL: C_SRVCDOCITEMPROCESSFLOW Type: view_entity CONSUMPTION
25 Fields 1 Data Sources 1 Associations

Service Document Item Process Flow Node

C_SrvcDocItemProcessFlow is a Consumption CDS View that provides data about "Service Document Item Process Flow Node" in SAP S/4HANA. It reads from 1 data source (I_ServiceDocumentItemEnhcd) and exposes 25 fields with key fields ServiceObjectType, ServiceDocument, ServiceDocumentItem. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_ServiceDocumentItemEnhcd I_ServiceDocumentItemEnhcd from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_SrvcMgmtObjectStatus _SrvcMgmtObjectStatus $projection.ServiceDocumentItemUUID = _SrvcMgmtObjectStatus.SrvcMgmtObjectUUID and _SrvcMgmtObjectStatus.SrvcMgmtObjectStatusIsInactive = '' and ( _SrvcMgmtObjectStatus.SrvcMgmtObjectStatus = 'I1002' or _SrvcMgmtObjectStatus.SrvcMgmtObjectStatus = 'I1003' or _SrvcMgmtObjectStatus.SrvcMgmtObjectStatus = 'I1004' or _SrvcMgmtObjectStatus.SrvcMgmtObjectStatus = 'I1005' )

Annotations (8)

NameValueLevelField
EndUserText.label Service Document Item Process Flow Node view
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #CHECK view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.representativeKey ServiceDocumentItem view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view

Fields (25)

KeyFieldSource TableSource FieldDescription
KEY ServiceObjectType ServiceObjectType Object Type
KEY ServiceDocument ServiceDocument Transaction ID
KEY ServiceDocumentItem ServiceDocumentItem Service Document
PostingDate PostingDate Posting Date for GR
ServiceDocumentUUID ServiceDocumentUUID Object GUID
ServiceDocumentItemStatus ServiceDocumentItemStatus
SrvcMgmtObjectStatus _SrvcMgmtObjectStatus SrvcMgmtObjectStatus
RequestedServiceStartDate RequestedServiceStartDate
SrvcQuotationValidityStartDate _ServiceDocument SrvcQuotationValidityStartDate
ServiceDocumentItemUUID ServiceDocumentItemUUID
ServiceDocumentType ServiceDocumentType Transaction Type
SalesOrganization SalesOrganization Sales Organization
SalesOffice SalesOffice Sales Office
SalesGroup SalesGroup Sales Group
DistributionChannel DistributionChannel RefDistCh-Cust/Mat.
Division Division Internal Division ID
ResponsibleEmployee Employee Resp.
SalesOrganizationOrgUnitID SalesOrganizationOrgUnitID
SalesOfficeOrgUnitID SalesOfficeOrgUnitID
SalesGroupOrgUnitID SalesGroupOrgUnitID
ServiceOrganization ServiceOrganization
_ServiceObjType _ServiceObjType
_ServiceDocItemStatus _ServiceDocItemStatus
_SrvcDocItmLifecycleStatus _SrvcDocItmLifecycleStatus
_ServiceDocument _ServiceDocument

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 C_SrvcDocItemProcessFlow.
-- 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 C_SrvcDocItemProcessFlow AS
SELECT
  ServiceObjectType,
  ServiceDocument,
  ServiceDocumentItem,
  PostingDate,
  ServiceDocumentUUID,
  ServiceDocumentItemStatus,
  _SrvcMgmtObjectStatus.SrvcMgmtObjectStatus AS SrvcMgmtObjectStatus,
  RequestedServiceStartDate,
  _ServiceDocument.SrvcQuotationValidityStartDate AS SrvcQuotationValidityStartDate,
  ServiceDocumentItemUUID,
  ServiceDocumentType,
  SalesOrganization,
  SalesOffice,
  SalesGroup,
  DistributionChannel,
  Division,
  cast(ResponsibleEmployee as resp_empl) AS ResponsibleEmployee,
  SalesOrganizationOrgUnitID,
  SalesOfficeOrgUnitID,
  SalesGroupOrgUnitID,
  ServiceOrganization
FROM I_ServiceDocumentItemEnhcd
LEFT OUTER JOIN I_SrvcMgmtObjectStatus AS _SrvcMgmtObjectStatus ON ServiceDocumentItemUUID = _SrvcMgmtObjectStatus.SrvcMgmtObjectUUID AND _SrvcMgmtObjectStatus.SrvcMgmtObjectStatusIsInactive = '' AND ( _SrvcMgmtObjectStatus.SrvcMgmtObjectStatus = 'I1002' OR _SrvcMgmtObjectStatus.SrvcMgmtObjectStatus = 'I1003' OR _SrvcMgmtObjectStatus.SrvcMgmtObjectStatus = 'I1004' OR _SrvcMgmtObjectStatus.SrvcMgmtObjectStatus = 'I1005' )  -- association [0..1]
;

Learn More