I_MfgActionReasonCodeTP

DDL: I_MFGACTIONREASONCODETP SQL: IMPEMFGARCTP Type: view TRANSACTIONAL Package: MPE_CORE
27 Fields 1 Data Sources

MPE Manufacturing Action Reason Code

I_MfgActionReasonCodeTP is a Transactional CDS View that provides data about "MPE Manufacturing Action Reason Code" in SAP S/4HANA. It reads from 1 data source (I_MfgActionReasonCode) and exposes 27 fields with key fields MfgActionReasonCodeGroupCtlg, MfgActionReasonCodeGroup, ManufacturingActionReasonCode, Version. Part of development package MPE_CORE.

Data Sources (1)

SourceAliasJoin Type
I_MfgActionReasonCode code from

Annotations (16)

NameValueLevelField
AbapCatalog.sqlViewName IMPEMFGARCTP view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #TRANSACTIONAL view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.compositionRoot true view
ObjectModel.transactionalProcessingEnabled true view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled true view
ObjectModel.draftEnabled true view
ObjectModel.writeDraftPersistence IMFGARCTPDRAFT view
EndUserText.label MPE Manufacturing Action Reason Code view

Fields (27)

KeyFieldSource TableSource FieldDescription
KEY MfgActionReasonCodeGroupCtlg I_MfgActionReasonCode MfgActionReasonCodeGroupCtlg Catalog
KEY MfgActionReasonCodeGroup I_MfgActionReasonCode MfgActionReasonCodeGroup Code Group
KEY ManufacturingActionReasonCode I_MfgActionReasonCode ManufacturingActionReasonCode Water Hazard Cl.
KEY Version I_MfgActionReasonCode Version XML Vers.
MfgActnRsnCodeGroupCtlgForEdit I_MfgActionReasonCode MfgActionReasonCodeGroupCtlg Catalog
MfgActnReasonCodeGroupForEdit I_MfgActionReasonCode MfgActionReasonCodeGroup Code Group
MfgActionReasonCodeForEdit I_MfgActionReasonCode ManufacturingActionReasonCode Water Hazard Cl.
MfgActionReasonCodeName
MfgActionReasonCodeGroupName
InspSpecAdditionalCatalogText
CodeGroupStatus I_MfgActionReasonCode CodeGroupStatus
DefectClass I_MfgActionReasonCode DefectClass Defect Class
Action I_MfgActionReasonCode Action User action
IsDeleted I_MfgActionReasonCode IsDeleted TRUE
ValidityStartDate I_MfgActionReasonCode ValidityStartDate Validity Start Date
MfgActionReasonCodeIsUsed I_MfgActionReasonCode MfgActionReasonCodeIsUsed Record Used
CreatedByUserDescription _CreatedByUser UserDescription Full Name
LastChangedByUserDescription _LastChangedByUser UserDescription Full Name
CreatedByUser I_MfgActionReasonCode CreatedByUser User Name
CreationDateTime
LastChangedByUser I_MfgActionReasonCode LastChangedByUser User Name
LastChangeDateTime
_Text _Text
_Group _Group
_Catalog _Catalog
_CreatedByUser _CreatedByUser
_LastChangedByUser _LastChangedByUser

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_MfgActionReasonCodeTP.
-- 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: IMPEMFGARCTP

CREATE VIEW I_MfgActionReasonCodeTP AS
SELECT
  code.MfgActionReasonCodeGroupCtlg AS MfgActionReasonCodeGroupCtlg,
  code.MfgActionReasonCodeGroup AS MfgActionReasonCodeGroup,
  code.ManufacturingActionReasonCode AS ManufacturingActionReasonCode,
  code.Version AS Version,
  code.MfgActionReasonCodeGroupCtlg AS MfgActnRsnCodeGroupCtlgForEdit,
  code.MfgActionReasonCodeGroup AS MfgActnReasonCodeGroupForEdit,
  code.ManufacturingActionReasonCode AS MfgActionReasonCodeForEdit,
  cast(_Text[1: Language=$session.system_language].MfgActionReasonCodeName as mpe_reason_code_description preserving type) AS MfgActionReasonCodeName,
  _Group._Text[1: Language=$session.system_language].MfgActionReasonCodeGroupName AS MfgActionReasonCodeGroupName,
  _Catalog._InspectionCatalogText[1: Language=$session.system_language].InspSpecAdditionalCatalogText AS InspSpecAdditionalCatalogText,
  code.CodeGroupStatus AS CodeGroupStatus,
  code.DefectClass AS DefectClass,
  code.Action AS Action,
  code.IsDeleted AS IsDeleted,
  code.ValidityStartDate AS ValidityStartDate,
  code.MfgActionReasonCodeIsUsed AS MfgActionReasonCodeIsUsed,
  _CreatedByUser.UserDescription AS CreatedByUserDescription,
  _LastChangedByUser.UserDescription AS LastChangedByUserDescription,
  code.CreatedByUser AS CreatedByUser,
  cast(code.CreationDateTime as mpe_create_date preserving type) AS CreationDateTime,
  code.LastChangedByUser AS LastChangedByUser,
  cast(code.LastChangeDateTime as mpe_lchange_date preserving type) AS LastChangeDateTime
FROM I_MfgActionReasonCode AS code
;

Learn More