C_AddlRsnCodeGrpForMfgActnTP

DDL: C_ADDLRSNCODEGRPFORMFGACTNTP Type: view_entity CONSUMPTION
10 Fields 1 Data Sources 2 Associations

Add Code Groups of an Action in a Plant

C_AddlRsnCodeGrpForMfgActnTP is a Consumption CDS View that provides data about "Add Code Groups of an Action in a Plant" in SAP S/4HANA. It reads from 1 data source (I_AddlRsnCodeGrpForMfgActnTP) and exposes 10 fields with key fields MfgProcgExecObjectType, MfgProcgExecAction, Plant, MfgActionReasonCodeGroup. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_AddlRsnCodeGrpForMfgActnTP AddlRsnCodeGrp from

Associations (2)

CardinalityTargetAliasCondition
[1..1] C_MfgActionSettingTP _Root $projection.MfgProcgExecObjectType = _Root.MfgObjectType and $projection.MfgProcgExecAction = _Root.MfgProcgExecAction and $projection.Plant = _Root.Plant
[0..1] C_MfgActnSttgCodeGroupVH _MfgActnSttgCodeGroupVH $projection.MfgActionReasonCodeGroup = _MfgActnSttgCodeGroupVH.MfgActionReasonCodeGroup and $projection.MfgActionReasonCodeGroupCtlg = _MfgActnSttgCodeGroupVH.MfgActionReasonCodeGroupCtlg

Annotations (12)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #CUSTOMIZING view
AccessControl.personalData.blocking #NOT_REQUIRED view
ObjectModel.transactionalProcessingDelegated true view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled true view
EndUserText.label Add Code Groups of an Action in a Plant view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY MfgProcgExecObjectType I_AddlRsnCodeGrpForMfgActnTP MfgProcgExecObjectType
KEY MfgProcgExecAction I_AddlRsnCodeGrpForMfgActnTP MfgProcgExecAction
KEY Plant I_AddlRsnCodeGrpForMfgActnTP Plant Valuation Area
KEY MfgActionReasonCodeGroup I_AddlRsnCodeGrpForMfgActnTP MfgActionReasonCodeGroup
MfgActionReasonCodeGrpForEdit I_AddlRsnCodeGrpForMfgActnTP MfgActionReasonCodeGrpForEdit
MfgObjectTypeName I_AddlRsnCodeGrpForMfgActnTP MfgObjectTypeName
MfgProcgExecActionName I_AddlRsnCodeGrpForMfgActnTP MfgProcgExecActionName
MfgActionReasonCodeGroupName
Associations_MfgActnSttgCodeGroupVH
torootnode_Root

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_AddlRsnCodeGrpForMfgActnTP.
-- 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_AddlRsnCodeGrpForMfgActnTP AS
SELECT
  AddlRsnCodeGrp.MfgProcgExecObjectType AS MfgProcgExecObjectType,
  AddlRsnCodeGrp.MfgProcgExecAction AS MfgProcgExecAction,
  AddlRsnCodeGrp.Plant AS Plant,
  AddlRsnCodeGrp.MfgActionReasonCodeGroup AS MfgActionReasonCodeGroup,
  AddlRsnCodeGrp.MfgActionReasonCodeGrpForEdit AS MfgActionReasonCodeGrpForEdit,
  AddlRsnCodeGrp.MfgObjectTypeName AS MfgObjectTypeName,
  AddlRsnCodeGrp.MfgProcgExecActionName AS MfgProcgExecActionName,
  AddlRsnCodeGrp._CodeGroupText.MfgActionReasonCodeGroupName AS MfgActionReasonCodeGroupName
FROM I_AddlRsnCodeGrpForMfgActnTP AS AddlRsnCodeGrp
LEFT OUTER JOIN C_MfgActionSettingTP AS _Root ON MfgProcgExecObjectType = _Root.MfgObjectType AND MfgProcgExecAction = _Root.MfgProcgExecAction AND Plant = _Root.Plant  -- association [1..1]
LEFT OUTER JOIN C_MfgActnSttgCodeGroupVH AS _MfgActnSttgCodeGroupVH ON MfgActionReasonCodeGroup = _MfgActnSttgCodeGroupVH.MfgActionReasonCodeGroup AND MfgActionReasonCodeGroupCtlg = _MfgActnSttgCodeGroupVH.MfgActionReasonCodeGroupCtlg  -- association [0..1]
;

Learn More