P_BusSolnOrdSlsOrdFlwLvl1

DDL: P_BUSSOLNORDSLSORDFLWLVL1 Type: view CONSUMPTION Package: CRMS4_SOLUTION_ORDER_PROGRESS
11 Fields 3 Data Sources

Solution Order Sales Order Flow Level 1

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

Data Sources (3)

SourceAliasJoin Type
I_ServiceDocumentSuccessor _SalesOrder inner
I_ServiceDocumentItemSuccssr_2 _SalesOrdItm inner
I_ServiceDocumentItemEnhcd _SolutionOrder inner

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName PBSOSLSOFLWLVL1 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 Sales Order Flow Level 1 view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY PrecedingDocument Level0 PrecedingDocument SD Document
KEY PrecedingDocumentItem Level0 PrecedingDocumentItem Item
KEY PrecedingDocumentCategory Level0 PrecedingDocumentCategory
KEY SubsequentDocument
KEY SubsequentDocumentItem
KEY SubsequentDocumentCategory
BusinessSolutionOrder Level0 BusinessSolutionOrder Solution Order
BusinessSolutionOrderItem Level0 BusinessSolutionOrderItem Solution Order Item
ServiceObjectType Level0 ServiceObjectType Object Type
SalesOrder
SalesOrderItem

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_BusSolnOrdSlsOrdFlwLvl1.
-- 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_BusSolnOrdSlsOrdFlwLvl1 AS
SELECT
  Level0.PrecedingDocument AS PrecedingDocument,
  Level0.PrecedingDocumentItem AS PrecedingDocumentItem,
  Level0.PrecedingDocumentCategory AS PrecedingDocumentCategory,
  cast( _SalesOrder.ServiceDocSuccessor as subsequ_doc ) AS SubsequentDocument,
  left(_SalesOrdItm .ServiceDocItmSuccssrCharUUID,6) AS SubsequentDocumentItem,
  'C' AS SubsequentDocumentCategory,
  Level0.BusinessSolutionOrder AS BusinessSolutionOrder,
  Level0.BusinessSolutionOrderItem AS BusinessSolutionOrderItem,
  Level0.ServiceObjectType AS ServiceObjectType,
  cast( _SalesOrder.ServiceDocSuccessor as vdm_sales_order ) AS SalesOrder,
  left(_SalesOrdItm.ServiceDocItmSuccssrCharUUID,6) AS SalesOrderItem
INNER JOIN I_ServiceDocumentItemEnhcd AS _SolutionOrder ON /* join condition not captured in parsed metadata */
INNER JOIN I_ServiceDocumentItemSuccssr_2 AS _SalesOrdItm ON /* join condition not captured in parsed metadata */
INNER JOIN I_ServiceDocumentSuccessor AS _SalesOrder ON /* join condition not captured in parsed metadata */
;

Learn More