C_MDBusPartChgProcessTypeVH

DDL: C_MDBUSPARTCHGPROCESSTYPEVH SQL: CMDCHGPROCTYPVH Type: view CONSUMPTION
13 Fields 1 Data Sources 1 Associations

MD Change Process Type Value Help for Business Partner

C_MDBusPartChgProcessTypeVH is a Consumption CDS View that provides data about "MD Change Process Type Value Help for Business Partner" in SAP S/4HANA. It reads from 1 data source (I_MDChgProcessType) and exposes 13 fields with key field MDChgProcessTypeID. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_MDChgProcessType I_MDChgProcessType from

Associations (1)

CardinalityTargetAliasCondition
[0..1] C_MDBusPartChgProcessGoalVH _MDBusPartChgProcessGoalVH $projection.MDChgProcessGoal = _MDBusPartChgProcessGoalVH.MDChgProcessGoal

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName CMDCHGPROCTYPVH view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.representativeKey MDChgProcessTypeID view
VDM.viewType #CONSUMPTION view
Search.searchable true view
EndUserText.label MD Change Process Type Value Help for Business Partner view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY MDChgProcessTypeID MDChgProcessTypeID Process Template
MDChgProcessGoal MDChgProcessGoal Process Goal
MDChgProcessWorkflowTemplate MDChgProcessWorkflowTemplate Workflow Template
MDChgProcessDelSrceDataIsRqd MDChgProcessDelSrceDataIsRqd
MDChgProcTypeIsMassProcgDflt MDChgProcTypeIsMassProcgDflt
MDChgProcDplRecdStrategyCode MDChgProcDplRecdStrategyCode Strategy
_MDChgProcessTypeText _MDChgProcessTypeText
_MDBusPartChgProcessGoalVH _MDBusPartChgProcessGoalVH
_MDChangeProcGoalT _MDChangeProcGoalT
_DefaultTemplateIndicator _DefaultTemplateIndicator
_DeleteSourceIndicator _DeleteSourceIndicator
_DefaultTemplateIndicatorText _DefaultTemplateIndicatorText
_DeleteSourceIndicatorText _DeleteSourceIndicatorText

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_MDBusPartChgProcessTypeVH.
-- 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: CMDCHGPROCTYPVH

CREATE VIEW C_MDBusPartChgProcessTypeVH AS
SELECT
  MDChgProcessTypeID,
  MDChgProcessGoal,
  MDChgProcessWorkflowTemplate,
  MDChgProcessDelSrceDataIsRqd,
  MDChgProcTypeIsMassProcgDflt,
  MDChgProcDplRecdStrategyCode
FROM I_MDChgProcessType
LEFT OUTER JOIN C_MDBusPartChgProcessGoalVH AS _MDBusPartChgProcessGoalVH ON MDChgProcessGoal = _MDBusPartChgProcessGoalVH.MDChgProcessGoal  -- association [0..1]
;

Learn More