A_ChgRecdRefPlngScope

DDL: A_CHGRECDREFPLNGSCOPE Type: view_entity COMPOSITE
22 Fields 1 Data Sources

Change Record ref Planning Scope

A_ChgRecdRefPlngScope is a Composite CDS View that provides data about "Change Record ref Planning Scope" in SAP S/4HANA. It reads from 1 data source (I_ChgRecdRefPlngScpBsc) and exposes 22 fields with key field ChangeRecordReferenceUUID.

Data Sources (1)

SourceAliasJoin Type
I_ChgRecdRefPlngScpBsc reference_pls from

Annotations (8)

NameValueLevelField
VDM.viewType #COMPOSITE view
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
Metadata.ignorePropagatedAnnotations true view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
EndUserText.label Change Record ref Planning Scope view

Fields (22)

KeyFieldSource TableSource FieldDescription
KEY ChangeRecordReferenceUUID I_ChgRecdRefPlngScpBsc ChangeRecordReferenceUUID UUID
DocumentId PlanningScope DocumentId Routing slip doc. ID
SourceMaterialasmatnrendasSourceMaterial
PlanningScopeDescription PlanningScope PlanningScopeDescription
MBOMUsage PlanningScope MBOMUsage
IsVersionBillOfMaterial PlanningScope IsVersionBillOfMaterial Versioning Relevant
SourceBOMIsVersioned PlanningScope SourceBOMIsVersioned
TargetMaterial PlanningScope TargetMaterial
ProductionPlant PlanningScope Plant Valuation Area
ChangeRecordUUID I_ChgRecdRefPlngScpBsc ChangeRecordUUID NodeID
ChangeRecord I_ChgRecdRefPlngScpBsc ChangeRecord Char20
ChangeRecordReferenceType I_ChgRecdRefPlngScpBsc ChangeRecordReferenceType Object Type
ChangeRecordReferenceSubtype I_ChgRecdRefPlngScpBsc ChangeRecordReferenceSubtype Subtype
ParentChangeRecordRefUUID I_ChgRecdRefPlngScpBsc ParentChangeRecordRefUUID Node ID
CreatedByUser I_ChgRecdRefPlngScpBsc CreatedByUser User Name
CreationDateTime I_ChgRecdRefPlngScpBsc CreationDateTime Timestamp
LastChangeDateTime I_ChgRecdRefPlngScpBsc LastChangeDateTime Timestamp
LastChangedByUser I_ChgRecdRefPlngScpBsc LastChangedByUser User Name
ChangeRecordItemRelevance I_ChgRecdRefPlngScpBsc ChangeRecordItemRelevance Relevance
ChangeRecordVirtualRefInd I_ChgRecdRefPlngScpBsc ChangeRecordVirtualRefInd Virtual Reference
ChangeRecordItemProcgStatus I_ChgRecdRefPlngScpBsc ChangeRecordItemProcgStatus Processing Status
_ChangeRecord _ChangeRecord

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 A_ChgRecdRefPlngScope.
-- 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 A_ChgRecdRefPlngScope AS
SELECT
  reference_pls.ChangeRecordReferenceUUID AS ChangeRecordReferenceUUID,
  PlanningScope.DocumentId AS DocumentId,
  case when PlanningScope.SourceMaterial is null then cast(substring( reference_pls.ChangeRecordReference, 1, 40) as matnr) else cast(PlanningScope.SourceMaterial as matnr) end as SourceMaterial AS SourceMaterialasmatnrendasSourceMaterial,
  PlanningScope.PlanningScopeDescription AS PlanningScopeDescription,
  PlanningScope.MBOMUsage AS MBOMUsage,
  PlanningScope.IsVersionBillOfMaterial AS IsVersionBillOfMaterial,
  PlanningScope.SourceBOMIsVersioned AS SourceBOMIsVersioned,
  PlanningScope.TargetMaterial AS TargetMaterial,
  PlanningScope.Plant AS ProductionPlant,
  reference_pls.ChangeRecordUUID AS ChangeRecordUUID,
  reference_pls.ChangeRecord AS ChangeRecord,
  reference_pls.ChangeRecordReferenceType AS ChangeRecordReferenceType,
  reference_pls.ChangeRecordReferenceSubtype AS ChangeRecordReferenceSubtype,
  reference_pls.ParentChangeRecordRefUUID AS ParentChangeRecordRefUUID,
  reference_pls.CreatedByUser AS CreatedByUser,
  reference_pls.CreationDateTime AS CreationDateTime,
  reference_pls.LastChangeDateTime AS LastChangeDateTime,
  reference_pls.LastChangedByUser AS LastChangedByUser,
  reference_pls.ChangeRecordItemRelevance AS ChangeRecordItemRelevance,
  reference_pls.ChangeRecordVirtualRefInd AS ChangeRecordVirtualRefInd,
  reference_pls.ChangeRecordItemProcgStatus AS ChangeRecordItemProcgStatus
FROM I_ChgRecdRefPlngScpBsc AS reference_pls
;

Learn More