I_AddlRsnCodeGrpForMfgActnTP

DDL: I_ADDLRSNCODEGRPFORMFGACTNTP Type: view_entity TRANSACTIONAL
16 Fields 1 Data Sources 5 Associations

Code Groups of an Action in a Plant - TP

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

Data Sources (1)

SourceAliasJoin Type
I_MfgActnSttgAddlRsnGrpCtlg AddlRsnGrpCtlg from

Associations (5)

CardinalityTargetAliasCondition
[1..1] I_MfgActionSettingTP _Root $projection.MfgProcgExecObjectType = _Root.MfgObjectType and $projection.MfgProcgExecAction = _Root.MfgProcgExecAction and $projection.Plant = _Root.Plant -- text associations
[0..1] I_SystemObjectTypeText _ObjectTypeText $projection.MfgProcgExecObjectType = _ObjectTypeText.MfgObjectType and _ObjectTypeText.Language = $session.system_language
[0..1] I_ManufacturingActionText _ManufacturingActionText $projection.MfgProcgExecAction = _ManufacturingActionText.MfgProcgExecAction and _ManufacturingActionText.Language = $session.system_language
[0..1] I_SASActionText _SASActionText $projection.MfgProcgExecAction = _SASActionText.StatusAndActionSchemaAction and _SASActionText.Language = $session.system_language
[0..1] I_MfgActionReasonCodeGroupText _CodeGroupText $projection.MfgActionReasonCodeGroupCtlg = _CodeGroupText.MfgActionReasonCodeGroupCtlg and $projection.MfgActionReasonCodeGroup = _CodeGroupText.MfgActionReasonCodeGroup and _CodeGroupText.Language = $session.system_language

Annotations (13)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #CUSTOMIZING view
AccessControl.personalData.blocking #NOT_REQUIRED view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled true view
ObjectModel.writeDraftPersistence IMPEADDRSNCDGRP view
EndUserText.label Code Groups of an Action in a Plant - TP view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY MfgProcgExecObjectType I_MfgActnSttgAddlRsnGrpCtlg MfgProcgExecObjectType Type
KEY MfgProcgExecAction I_MfgActnSttgAddlRsnGrpCtlg MfgProcgExecAction Action
KEY Plant I_MfgActnSttgAddlRsnGrpCtlg Plant Valuation Area
KEY MfgActionReasonCodeGroup I_MfgActnSttgAddlRsnGrpCtlg MfgActionReasonCodeGroup Code Group
MfgObjectTypeName _ObjectTypeText MfgObjectTypeName
MfgActionReasonCodeGroupCtlg _Root MfgActionReasonCodeGroupCtlg
MfgActionReasonCodeGrpForEdit I_MfgActnSttgAddlRsnGrpCtlg MfgActionReasonCodeGroup Code Group
_ObjectType
_MfgProcgExecAction I_MfgActnSttgAddlRsnGrpCtlg _MfgProcgExecAction
_Plant I_MfgActnSttgAddlRsnGrpCtlg _Plant
_MfgActionReasonCodeGroup I_MfgActnSttgAddlRsnGrpCtlg _MfgActionReasonCodeGroup
_ObjectTypeText _ObjectTypeText
_ManufacturingActionText _ManufacturingActionText
_SASActionText _SASActionText
_CodeGroupText _CodeGroupText
_Root _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 I_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 I_AddlRsnCodeGrpForMfgActnTP AS
SELECT
  AddlRsnGrpCtlg.MfgProcgExecObjectType AS MfgProcgExecObjectType,
  AddlRsnGrpCtlg.MfgProcgExecAction AS MfgProcgExecAction,
  AddlRsnGrpCtlg.Plant AS Plant,
  AddlRsnGrpCtlg.MfgActionReasonCodeGroup AS MfgActionReasonCodeGroup,
  _ObjectTypeText.MfgObjectTypeName AS MfgObjectTypeName,
  _Root.MfgActionReasonCodeGroupCtlg AS MfgActionReasonCodeGroupCtlg,
  AddlRsnGrpCtlg.MfgActionReasonCodeGroup AS MfgActionReasonCodeGrpForEdit,
  AddlRsnGrpCtlg._MfgProcgExecAction AS _MfgProcgExecAction,
  AddlRsnGrpCtlg._Plant AS _Plant,
  AddlRsnGrpCtlg._MfgActionReasonCodeGroup AS _MfgActionReasonCodeGroup
FROM I_MfgActnSttgAddlRsnGrpCtlg AS AddlRsnGrpCtlg
LEFT OUTER JOIN I_MfgActionSettingTP AS _Root ON MfgProcgExecObjectType = _Root.MfgObjectType AND MfgProcgExecAction = _Root.MfgProcgExecAction AND Plant = _Root.Plant  -- association [1..1]
LEFT OUTER JOIN I_SystemObjectTypeText AS _ObjectTypeText ON MfgProcgExecObjectType = _ObjectTypeText.MfgObjectType AND _ObjectTypeText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_ManufacturingActionText AS _ManufacturingActionText ON MfgProcgExecAction = _ManufacturingActionText.MfgProcgExecAction AND _ManufacturingActionText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_SASActionText AS _SASActionText ON MfgProcgExecAction = _SASActionText.StatusAndActionSchemaAction AND _SASActionText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_MfgActionReasonCodeGroupText AS _CodeGroupText ON MfgActionReasonCodeGroupCtlg = _CodeGroupText.MfgActionReasonCodeGroupCtlg AND MfgActionReasonCodeGroup = _CodeGroupText.MfgActionReasonCodeGroup AND _CodeGroupText.Language = $session.system_language  -- association [0..1]
;

Learn More