P_BusSolnOrdSrvcOrdFlwLvl2

DDL: P_BUSSOLNORDSRVCORDFLWLVL2 Type: view CONSUMPTION
10 Fields 4 Data Sources

Solution Order Service Order Flow: Level 2

P_BusSolnOrdSrvcOrdFlwLvl2 is a Consumption CDS View that provides data about "Solution Order Service Order Flow: Level 2" in SAP S/4HANA. It reads from 4 data sources (I_ServiceDocumentItemEnhcd, I_ServiceDocumentItemEnhcd, I_ServiceDocumentItemSuccssr_2, P_BusSolnOrdSrvcOrdFlwLvl1) and exposes 10 fields with key fields PrecedingDocument, PrecedingDocumentItem, PrecedingDocumentCategory, SubsequentDocument, SubsequentDocumentItem.

Data Sources (4)

SourceAliasJoin Type
I_ServiceDocumentItemEnhcd _ServiceConfirmation inner
I_ServiceDocumentItemEnhcd _ServiceOrder inner
I_ServiceDocumentItemSuccssr_2 _SrvcOrdItmToSrvcConfItm inner
P_BusSolnOrdSrvcOrdFlwLvl1 Level1 from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName PBSOSOFLWLVL2 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 Order Service Order Flow: Level 2 view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY PrecedingDocument P_BusSolnOrdSrvcOrdFlwLvl1 SubsequentDocument Transaction ID
KEY PrecedingDocumentItem P_BusSolnOrdSrvcOrdFlwLvl1 SubsequentDocumentItem Service Document
KEY PrecedingDocumentCategory P_BusSolnOrdSrvcOrdFlwLvl1 SubsequentDocumentCategory
KEY SubsequentDocument I_ServiceDocumentItemEnhcd ServiceDocument Transaction ID
KEY SubsequentDocumentItem I_ServiceDocumentItemEnhcd ServiceDocumentItem Service Document
KEY SubsequentDocumentCategory
ServiceObjectType P_BusSolnOrdSrvcOrdFlwLvl1 ServiceObjectType Object Type
BusinessSolutionOrder BusinessSolutionOrder Solution Order
ServiceOrder ServiceOrder Transaction ID
ServiceOrderItem ServiceOrderItem Item Number in Doc.

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_BusSolnOrdSrvcOrdFlwLvl2.
-- 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_BusSolnOrdSrvcOrdFlwLvl2 AS
SELECT
  Level1.SubsequentDocument AS PrecedingDocument,
  Level1.SubsequentDocumentItem AS PrecedingDocumentItem,
  Level1.SubsequentDocumentCategory AS PrecedingDocumentCategory,
  _ServiceConfirmation.ServiceDocument AS SubsequentDocument,
  _ServiceConfirmation.ServiceDocumentItem AS SubsequentDocumentItem,
  'CSCO' AS SubsequentDocumentCategory,
  Level1.ServiceObjectType AS ServiceObjectType,
  BusinessSolutionOrder,
  ServiceOrder,
  ServiceOrderItem
FROM P_BusSolnOrdSrvcOrdFlwLvl1 AS Level1
INNER JOIN I_ServiceDocumentItemEnhcd AS _ServiceOrder ON /* join condition not captured in parsed metadata */
INNER JOIN I_ServiceDocumentItemSuccssr_2 AS _SrvcOrdItmToSrvcConfItm ON /* join condition not captured in parsed metadata */
INNER JOIN I_ServiceDocumentItemEnhcd AS _ServiceConfirmation ON /* join condition not captured in parsed metadata */
;

Learn More