C_BSOrdItmProcFlwRoot

DDL: C_BSORDITMPROCFLWROOT Type: view CONSUMPTION
11 Fields 1 Data Sources 2 Associations

BSOrd Item Attrib for BSOrd Prgrs

C_BSOrdItmProcFlwRoot is a Consumption CDS View that provides data about "BSOrd Item Attrib for BSOrd Prgrs" in SAP S/4HANA. It reads from 1 data source (I_ServiceDocumentItemEnhcd) and exposes 11 fields with key fields UI5NetworkGraphAttributeValue, ServiceDocumentItem. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_ServiceDocumentItemEnhcd SolnOrderItem from

Associations (2)

CardinalityTargetAliasCondition
[0..1] P_BusSolnOrdSubsqntDocTypeText _DocumentType _DocumentType.UI5NetworkGraphDescription = 'SOLOI'
[0..1] E_ServiceDocumentItem _Extension _Extension.ServiceCategory = 'BUS2000172' and _Extension.ServiceOrderItem = SolnOrderItem.ServiceDocument and _Extension.ServiceLineExternalID = SolnOrderItem.ServiceDocumentItem

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName CBSOITMATTRIB view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY 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
Metadata.allowExtensions true view
EndUserText.label BSOrd Item Attrib for BSOrd Prgrs view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY UI5NetworkGraphAttributeValue ServiceDocument Transaction ID
KEY ServiceDocumentItem ServiceDocumentItem Service Document
Product
ProductName ServiceDocumentItemDescription
ServiceDocumentItemQuantity ServiceDocumentItemQuantity
ServiceDocItemQuantityUnit ServiceDocItemQuantityUnit
UI5NetworkGraphStatus
NetAmount ServiceDocumentItemNetAmount
TransactionCurrency TransactionCurrency Transaction Currency
HasError ServiceDocumentItemHasError
UI5NetworkGraphDescription

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_BSOrdItmProcFlwRoot.
-- 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_BSOrdItmProcFlwRoot AS
SELECT
  ServiceDocument AS UI5NetworkGraphAttributeValue,
  ServiceDocumentItem,
  cast(OriginallyRequestedProduct as matnr) AS Product,
  ServiceDocumentItemDescription AS ProductName,
  ServiceDocumentItemQuantity,
  ServiceDocItemQuantityUnit,
  cast(ServiceDocumentItemStatus as fac_network_graph_status) AS UI5NetworkGraphStatus,
  ServiceDocumentItemNetAmount AS NetAmount,
  TransactionCurrency,
  ServiceDocumentItemHasError AS HasError,
  _DocumentType[1: Language = $session.system_language].UI5NetworkGraphDescriptionName AS UI5NetworkGraphDescription
FROM I_ServiceDocumentItemEnhcd AS SolnOrderItem
LEFT OUTER JOIN P_BusSolnOrdSubsqntDocTypeText AS _DocumentType ON _DocumentType.UI5NetworkGraphDescription = 'SOLOI'  -- association [0..1]
LEFT OUTER JOIN E_ServiceDocumentItem AS _Extension ON _Extension.ServiceCategory = 'BUS2000172' AND _Extension.ServiceOrderItem = SolnOrderItem.ServiceDocument AND _Extension.ServiceLineExternalID = SolnOrderItem.ServiceDocumentItem  -- association [0..1]
;

Learn More