P_BusSolnOrdSrvcOrdFlwLvl0

DDL: P_BUSSOLNORDSRVCORDFLWLVL0 Type: view CONSUMPTION Package: CRMS4_SOLUTION_ORDER_PROGRESS
10 Fields 3 Data Sources

Solution OrderService Order Flow: Level 0

P_BusSolnOrdSrvcOrdFlwLvl0 is a Consumption CDS View that provides data about "Solution OrderService Order Flow: Level 0" in SAP S/4HANA. It reads from 3 data sources (I_ServiceDocumentItemEnhcd, I_ServiceDocumentItemEnhcd, I_ServiceDocumentItemSuccssr_2) and exposes 10 fields with key fields PrecedingDocument, PrecedingDocumentItem, PrecedingDocumentCategory, SubsequentDocument, SubsequentDocumentItem. Part of development package CRMS4_SOLUTION_ORDER_PROGRESS.

Data Sources (3)

SourceAliasJoin Type
I_ServiceDocumentItemEnhcd _ServiceContract inner
I_ServiceDocumentItemEnhcd _SolutionOrder inner
I_ServiceDocumentItemSuccssr_2 _SrvContToSolnOrd from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName PBSOSOFLWLVL0 view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
VDM.viewType #CONSUMPTION view
VDM.private true view
EndUserText.label Solution OrderService Order Flow: Level 0 view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY PrecedingDocument I_ServiceDocumentItemEnhcd ServiceDocument Transaction ID
KEY PrecedingDocumentItem I_ServiceDocumentItemEnhcd ServiceDocumentItem Service Document
KEY PrecedingDocumentCategory
KEY SubsequentDocument I_ServiceDocumentItemEnhcd ServiceDocument Transaction ID
KEY SubsequentDocumentItem I_ServiceDocumentItemEnhcd ServiceDocumentItem Service Document
KEY SubsequentDocumentCategory
ServiceObjectType I_ServiceDocumentItemEnhcd ServiceObjectType Object Type
BusinessSolutionOrder I_ServiceDocumentItemEnhcd ServiceDocument Transaction ID
ServiceOrder _SrvcOrd ServiceDocument Transaction ID
ServiceOrderItem I_ServiceDocumentItemEnhcd ServiceDocumentItem Service Document

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_BusSolnOrdSrvcOrdFlwLvl0.
-- 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_BusSolnOrdSrvcOrdFlwLvl0 AS
SELECT
  _ServiceContract.ServiceDocument AS PrecedingDocument,
  _ServiceContract.ServiceDocumentItem AS PrecedingDocumentItem,
  'SC' AS PrecedingDocumentCategory,
  _SolutionOrder.ServiceDocument AS SubsequentDocument,
  _SolutionOrder.ServiceDocumentItem AS SubsequentDocumentItem,
  'SOLO' AS SubsequentDocumentCategory,
  _SolutionOrder.ServiceObjectType AS ServiceObjectType,
  _SolutionOrder.ServiceDocument AS BusinessSolutionOrder,
  _SrvcOrd.ServiceDocument AS ServiceOrder,
  _SolutionOrder.ServiceDocumentItem AS ServiceOrderItem
FROM I_ServiceDocumentItemSuccssr_2 AS _SrvContToSolnOrd
INNER JOIN I_ServiceDocumentItemEnhcd AS _SolutionOrder ON /* join condition not captured in parsed metadata */
INNER JOIN I_ServiceDocumentItemEnhcd AS _ServiceContract ON /* join condition not captured in parsed metadata */
;

Learn More