C_MfgActionReasonCodeToGroupTP

DDL: C_MFGACTIONREASONCODETOGROUPTP SQL: CMPEMFGARCGCATP Type: view CONSUMPTION
18 Fields 1 Data Sources 1 Associations

Assignment of Reason Code to Group

C_MfgActionReasonCodeToGroupTP is a Consumption CDS View that provides data about "Assignment of Reason Code to Group" in SAP S/4HANA. It reads from 1 data source (I_MfgActionReasonCodeToGroupTP) and exposes 18 fields with key fields MfgActionReasonCodeGroupCtlg, ManufacturingActionReasonCode, MfgActionReasonCodeGroup, Version. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_MfgActionReasonCodeToGroupTP assgmt from

Associations (1)

CardinalityTargetAliasCondition
[1..1] C_MfgActionReasonCodeGroupTP _Root $projection.MfgActionReasonCodeGroupCtlg = _Root.MfgActionReasonCodeGroupCtlg and $projection.MfgActionReasonCodeGroup = _Root.MfgActionReasonCodeGroup

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName CMPEMFGARCGCATP view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #CONSUMPTION view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.createEnabled false view
ObjectModel.updateEnabled false view
ObjectModel.deleteEnabled false view
EndUserText.label Assignment of Reason Code to Group view

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY MfgActionReasonCodeGroupCtlg I_MfgActionReasonCodeToGroupTP MfgActionReasonCodeGroupCtlg
KEY ManufacturingActionReasonCode I_MfgActionReasonCodeToGroupTP ManufacturingActionReasonCode
KEY MfgActionReasonCodeGroup I_MfgActionReasonCodeToGroupTP MfgActionReasonCodeGroup
KEY Version I_MfgActionReasonCodeToGroupTP Version XML Vers.
CodeIsInactive I_MfgActionReasonCodeToGroupTP CodeIsInactive Inactive Indicator
CodeGroupStatus I_MfgActionReasonCodeToGroupTP CodeGroupStatus
MfgActionReasonCodeName I_MfgActionReasonCodeToGroupTP MfgActionReasonCodeName
InspSpecAdditionalCatalogText I_MfgActionReasonCodeToGroupTP InspSpecAdditionalCatalogText
CreatedByUser I_MfgActionReasonCodeToGroupTP CreatedByUser User Name
CreationDateTime I_MfgActionReasonCodeToGroupTP CreationDateTime Timestamp
LastChangedByUser I_MfgActionReasonCodeToGroupTP LastChangedByUser User Name
LastChangeDateTime I_MfgActionReasonCodeToGroupTP LastChangeDateTime Timestamp
Associations_Group
_Catalog I_MfgActionReasonCodeToGroupTP _Catalog
_Text _Text
_CreatedByUser _CreatedByUser
_LastChangedByUser _LastChangedByUser
_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 C_MfgActionReasonCodeToGroupTP.
-- 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: CMPEMFGARCGCATP

CREATE VIEW C_MfgActionReasonCodeToGroupTP AS
SELECT
  assgmt.MfgActionReasonCodeGroupCtlg AS MfgActionReasonCodeGroupCtlg,
  assgmt.ManufacturingActionReasonCode AS ManufacturingActionReasonCode,
  assgmt.MfgActionReasonCodeGroup AS MfgActionReasonCodeGroup,
  assgmt.Version AS Version,
  assgmt.CodeIsInactive AS CodeIsInactive,
  assgmt.CodeGroupStatus AS CodeGroupStatus,
  assgmt.MfgActionReasonCodeName AS MfgActionReasonCodeName,
  assgmt.InspSpecAdditionalCatalogText AS InspSpecAdditionalCatalogText,
  assgmt.CreatedByUser AS CreatedByUser,
  assgmt.CreationDateTime AS CreationDateTime,
  assgmt.LastChangedByUser AS LastChangedByUser,
  assgmt.LastChangeDateTime AS LastChangeDateTime,
  assgmt._Catalog AS _Catalog
FROM I_MfgActionReasonCodeToGroupTP AS assgmt
LEFT OUTER JOIN C_MfgActionReasonCodeGroupTP AS _Root ON MfgActionReasonCodeGroupCtlg = _Root.MfgActionReasonCodeGroupCtlg AND MfgActionReasonCodeGroup = _Root.MfgActionReasonCodeGroup  -- association [1..1]
;

Learn More