I_MDEffctvConfignActivationTP

DDL: I_MDEFFCTVCONFIGNACTIVATIONTP SQL: IMDEFCCONFACTTP Type: view TRANSACTIONAL
30 Fields 1 Data Sources

MD Effective Configuration Activation

I_MDEffctvConfignActivationTP is a Transactional CDS View that provides data about "MD Effective Configuration Activation" in SAP S/4HANA. It reads from 1 data source (I_MDEffctvConfignActivation) and exposes 30 fields with key field MDChgProcessStepUUID.

Data Sources (1)

SourceAliasJoin Type
I_MDEffctvConfignActivation I_MDEffctvConfignActivation from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IMDEFCCONFACTTP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label MD Effective Configuration Activation view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #TRANSACTIONAL view

Fields (30)

KeyFieldSource TableSource FieldDescription
KEY MDChgProcessStepUUID MDChgProcessStepUUID
MDChgProcessStepAdapterConfign MDChgProcessStepAdapterConfign Configuration ID
MDChgProcActvtConfign MDChgProcActvtConfign
MDChgProcessStpOwnConfignIsRqd MDChgProcessStpOwnConfignIsRqd
MDChgProcActvtTargetNew MDChgProcActvtTargetNew New Records
MDChgProcActvtChgReqTypeNew MDChgProcActvtChgReqTypeNew Type of Chg. Request
MDChgProcActvtNmbrOfRecdNew MDChgProcActvtNmbrOfRecdNew Max. Records
MDChgProcActvtTargetNewErr MDChgProcActvtTargetNewErr New Records (Errors)
MDChgProcActvtChgReqNewErr MDChgProcActvtChgReqNewErr Type of Chg. Request
MDChgProcActvtNmbrOfRecdNewErr MDChgProcActvtNmbrOfRecdNewErr Max. Records
MDChgProcActvtTargetUpdt MDChgProcActvtTargetUpdt Updated Records
MDChgProcActvtChgReqUpdt MDChgProcActvtChgReqUpdt Type of Chg. Request
MDChgProcActvtMaxNmbrRecdUpdt MDChgProcActvtMaxNmbrRecdUpdt Max. Records
MDChgProcActvtTargetUpdtErr MDChgProcActvtTargetUpdtErr Upd Records (Errors)
MDChgProcActvtChgReqUpdtErr MDChgProcActvtChgReqUpdtErr Type of Chg. Request
MDChgProcActvtNmbrRecdUpdtErr MDChgProcActvtNmbrRecdUpdtErr Max. Records
MDChgProcActvtTargetGrp MDChgProcActvtTargetGrp Match Groups
MDChgProcActvtChgReqGrp MDChgProcActvtChgReqGrp Type of Chg. Request
MDChgProcActvtNmbrOfRecdGrp MDChgProcActvtNmbrOfRecdGrp Max. Records
MDChgProcActvtTgtGrpErr MDChgProcActvtTgtGrpErr Match Grps (Errors)
MDChgProcActvtChgReqGrpErr MDChgProcActvtChgReqGrpErr Type of Chg. Request
MDChgProcActvtNmbrRecdGrpErr MDChgProcActvtNmbrRecdGrpErr Max. Records
MDChgProcActvtIsDataRplctnRqd MDChgProcActvtIsDataRplctnRqd Call DRF
MDChgProcActvtIsMDGovValdtnRqd MDChgProcActvtIsMDGovValdtnRqd MDG Checks
MDChgProcActvtIsBRFPlusChkRqd MDChgProcActvtIsBRFPlusChkRqd BRF+ Checks
MDChgProcQltyRuleChkIsRqd MDChgProcQltyRuleChkIsRqd Apply Valid. Rules
MDChgProcActvtRetentionTmeMins MDChgProcActvtRetentionTmeMins Ret. Time (Minutes)
MDChgProcActvtRetentionTmeDays MDChgProcActvtRetentionTmeDays Retention Days
MDChgProcActvtRetentionTmeHrs MDChgProcActvtRetentionTmeHrs
_StepConfiguration _StepConfiguration

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_MDEffctvConfignActivationTP.
-- 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: IMDEFCCONFACTTP

CREATE VIEW I_MDEffctvConfignActivationTP AS
SELECT
  MDChgProcessStepUUID,
  MDChgProcessStepAdapterConfign,
  MDChgProcActvtConfign,
  MDChgProcessStpOwnConfignIsRqd,
  MDChgProcActvtTargetNew,
  MDChgProcActvtChgReqTypeNew,
  MDChgProcActvtNmbrOfRecdNew,
  MDChgProcActvtTargetNewErr,
  MDChgProcActvtChgReqNewErr,
  MDChgProcActvtNmbrOfRecdNewErr,
  MDChgProcActvtTargetUpdt,
  MDChgProcActvtChgReqUpdt,
  MDChgProcActvtMaxNmbrRecdUpdt,
  MDChgProcActvtTargetUpdtErr,
  MDChgProcActvtChgReqUpdtErr,
  MDChgProcActvtNmbrRecdUpdtErr,
  MDChgProcActvtTargetGrp,
  MDChgProcActvtChgReqGrp,
  MDChgProcActvtNmbrOfRecdGrp,
  MDChgProcActvtTgtGrpErr,
  MDChgProcActvtChgReqGrpErr,
  MDChgProcActvtNmbrRecdGrpErr,
  MDChgProcActvtIsDataRplctnRqd,
  MDChgProcActvtIsMDGovValdtnRqd,
  MDChgProcActvtIsBRFPlusChkRqd,
  MDChgProcQltyRuleChkIsRqd,
  MDChgProcActvtRetentionTmeMins,
  MDChgProcActvtRetentionTmeDays,
  MDChgProcActvtRetentionTmeHrs
FROM I_MDEffctvConfignActivation
;

Learn More