C_ProdnRtgVersWrkflwInbox

DDL: C_PRODNRTGVERSWRKFLWINBOX SQL: CPRODRTGVERINBOX Type: view CONSUMPTION
16 Fields 1 Data Sources 1 Associations

Production Routing Workflow MyInbox

C_ProdnRtgVersWrkflwInbox is a Consumption CDS View that provides data about "Production Routing Workflow MyInbox" in SAP S/4HANA. It reads from 1 data source (I_ProductionRoutingVersion) and exposes 16 fields with key field BillOfOperationsKey. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_ProductionRoutingVersion I_ProductionRoutingVersion from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_BOOVersionStatusText _BOOVersionStatusText $projection.BillOfOperationsVersionStatus = _BOOVersionStatusText.BillOfOperationsVersionStatus

Annotations (16)

NameValueLevelField
AbapCatalog.sqlViewName CPRODRTGVERINBOX view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Production Routing Workflow MyInbox view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
ClientHandling.algorithm #SESSION_VARIABLE view
UI.headerInfo.typeName BillOfOperationsGroup view
UI.headerInfo.typeNamePlural BillOfOperationsGroup view
UI.headerInfo.title.type #STANDARD view
UI.headerInfo.title.label Routing Group view
UI.headerInfo.title.value BillOfOperationsGroup view
UI.headerInfo.description.type #STANDARD view
UI.headerInfo.description.value BillOfOperationsDesc view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY BillOfOperationsKey
BillOfOperations
BillOfOperationsGroup BillOfOperationsGroup Group
BillOfOperationsVersion BillOfOperationsVersion Routing Version
BillOfOperationsVariant BillOfOperationsVariant Group Counter
BillOfOperationsType BillOfOperationsType Task List Type
BillOfOperationsStatus BillOfOperationsStatus
BillOfOperationsUsage BillOfOperationsUsage
BillOfOperationsDesc BillOfOperationsDesc
BillOfOperationsVersionStatus BillOfOperationsVersionStatus
Plant Plant Valuation Area
CreationDateTime CreationDateTime Timestamp
CreatedByUser CreatedByUser User Name
LastChangeDateTime LastChangeDateTime Timestamp
LastChangedByUser LastChangedByUser User Name
_BOOVersionStatusText _BOOVersionStatusText

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_ProdnRtgVersWrkflwInbox.
-- 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.
-- SQL view name: CPRODRTGVERINBOX

CREATE VIEW C_ProdnRtgVersWrkflwInbox AS
SELECT
  concat(concat(BillOfOperationsType, BillOfOperationsGroup), concat(BillOfOperationsVariant, BillOfOperationsVersion)) AS BillOfOperationsKey,
  concat(concat(BillOfOperationsGroup, ('-')), concat(BillOfOperationsVariant, concat(('-'), BillOfOperationsVersion))) AS BillOfOperations,
  BillOfOperationsGroup,
  BillOfOperationsVersion,
  BillOfOperationsVariant,
  BillOfOperationsType,
  BillOfOperationsStatus,
  BillOfOperationsUsage,
  BillOfOperationsDesc,
  BillOfOperationsVersionStatus,
  Plant,
  CreationDateTime,
  CreatedByUser,
  LastChangeDateTime,
  LastChangedByUser
FROM I_ProductionRoutingVersion
LEFT OUTER JOIN I_BOOVersionStatusText AS _BOOVersionStatusText ON BillOfOperationsVersionStatus = _BOOVersionStatusText.BillOfOperationsVersionStatus  -- association [0..*]
;

Learn More