C_BSOrdProcFlwProdnOrd

DDL: C_BSORDPROCFLWPRODNORD Type: view CONSUMPTION Package: CRMS4_SOLUTION_ORDER_PROGRESS
6 Fields 1 Data Sources 1 Associations

MTO Production Order Attribute

C_BSOrdProcFlwProdnOrd is a Consumption CDS View that provides data about "MTO Production Order Attribute" in SAP S/4HANA. It reads from 1 data source (P_ProdnOrdStatusAttrbTxt) and exposes 6 fields with key field UI5NetworkGraphAttributeValue. It has 1 association to related views. Part of development package CRMS4_SOLUTION_ORDER_PROGRESS.

Data Sources (1)

SourceAliasJoin Type
P_ProdnOrdStatusAttrbTxt ProductionOrder from

Associations (1)

CardinalityTargetAliasCondition
[0..1] P_BusSolnOrdSubsqntDocTypeText _DocumentType _DocumentType.UI5NetworkGraphDescription = '10'

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName CPRODORDATTRIB 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
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
VDM.viewType #CONSUMPTION view
EndUserText.label MTO Production Order Attribute view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY UI5NetworkGraphAttributeValue P_ProdnOrdStatusAttrbTxt ManufacturingOrder Order
Material P_ProdnOrdStatusAttrbTxt Material Vehicle Model
UI5NetworkGraphStatus
UI5NetworkGraphStatusName _SystemStatusText SystemStatusName
ProductionPlant P_ProdnOrdStatusAttrbTxt ProductionPlant Prod plnt
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_BSOrdProcFlwProdnOrd.
-- 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_BSOrdProcFlwProdnOrd AS
SELECT
  ProductionOrder.ManufacturingOrder AS UI5NetworkGraphAttributeValue,
  ProductionOrder.Material AS Material,
  cast(right(ProductionOrder.StatusCode, 2) as crms4_solnorder_ng_status) AS UI5NetworkGraphStatus,
  _SystemStatusText.SystemStatusName AS UI5NetworkGraphStatusName,
  ProductionOrder.ProductionPlant AS ProductionPlant,
  _DocumentType[1: Language = $session.system_language].UI5NetworkGraphDescriptionName AS UI5NetworkGraphDescription
FROM P_ProdnOrdStatusAttrbTxt AS ProductionOrder
LEFT OUTER JOIN P_BusSolnOrdSubsqntDocTypeText AS _DocumentType ON _DocumentType.UI5NetworkGraphDescription = '10'  -- association [0..1]
;

Learn More