C_ChangeRecordPlngRtgVH

DDL: C_CHANGERECORDPLNGRTGVH SQL: CPLNGRTGVH Type: view CONSUMPTION
7 Fields 1 Data Sources 1 Associations

Planning Routing Value Help

C_ChangeRecordPlngRtgVH is a Consumption CDS View that provides data about "Planning Routing Value Help" in SAP S/4HANA. It reads from 1 data source (I_BillOfOperations) and exposes 7 fields with key fields Material, Plant, BillOfOperationsGroup, BillOfOperationsVariant, BillOfOperationsType. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_BillOfOperations _BillOfOperations from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_BOOMaterialAssgmtChangeState _BOOMaterialAssgmtChangeState $projection.BillOfOperationsType = _BOOMaterialAssgmtChangeState.BillOfOperationsType and $projection.BillOfOperationsGroup = _BOOMaterialAssgmtChangeState.BillOfOperationsGroup and $projection.BillOfOperationsVariant = _BOOMaterialAssgmtChangeState.BillOfOperationsVariant and _BOOMaterialAssgmtChangeState.IsDeleted = ''

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName CPLNGRTGVH view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #S view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.preserveKey true view
Search.searchable true view
EndUserText.label Planning Routing Value Help view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY Material _BOOMaterialAssgmtChangeState Material Vehicle Model
KEY Plant _BOOMaterialAssgmtChangeState Plant Valuation Area
KEY BillOfOperationsGroup BillOfOperationsGroup Group
KEY BillOfOperationsVariant BillOfOperationsVariant Group Counter
KEY BillOfOperationsType BillOfOperationsType Task List Type
BillOfOperationsUsage
BillOfOperationsStatus

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_ChangeRecordPlngRtgVH.
-- 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: CPLNGRTGVH

CREATE VIEW C_ChangeRecordPlngRtgVH AS
SELECT
  _BOOMaterialAssgmtChangeState.Material AS Material,
  _BOOMaterialAssgmtChangeState.Plant AS Plant,
  BillOfOperationsGroup,
  BillOfOperationsVariant,
  BillOfOperationsType,
  _BillOfOperations._BillOfOperationsChangeState[1: ValidityStartDate <= $session.system_date and ValidityEndDate >= $session.system_date].BillOfOperationsUsage AS BillOfOperationsUsage,
  _BillOfOperations._BillOfOperationsChangeState[1: ValidityStartDate <= $session.system_date and ValidityEndDate >= $session.system_date].BillOfOperationsStatus AS BillOfOperationsStatus
FROM I_BillOfOperations AS _BillOfOperations
LEFT OUTER JOIN I_BOOMaterialAssgmtChangeState AS _BOOMaterialAssgmtChangeState ON BillOfOperationsType = _BOOMaterialAssgmtChangeState.BillOfOperationsType AND BillOfOperationsGroup = _BOOMaterialAssgmtChangeState.BillOfOperationsGroup AND BillOfOperationsVariant = _BOOMaterialAssgmtChangeState.BillOfOperationsVariant AND _BOOMaterialAssgmtChangeState.IsDeleted = ''  -- association [0..*]
;

Learn More