I_MDGovWrkflwOrg

DDL: I_MDGOVWRKFLWORG SQL: ICRWFORG Type: view BASIC
6 Fields 1 Data Sources

MDG Change Req Wrkflw Procsr Org Details

I_MDGovWrkflwOrg is a Basic CDS View that provides data about "MDG Change Req Wrkflw Procsr Org Details" in SAP S/4HANA. It reads from 1 data source (hrp1000) and exposes 6 fields with key fields WorkflowOrglObjectType, WorkflowOrglObject, Language, AssignmentValidityStartDate, AssignmentValidityEndDate.

Data Sources (1)

SourceAliasJoin Type
hrp1000 HRP1000 from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName ICRWFORG view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.representativeKey WorkflowOrglObject view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #C view
VDM.viewType #BASIC view
EndUserText.label MDG Change Req Wrkflw Procsr Org Details view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY WorkflowOrglObjectType
KEY WorkflowOrglObject
KEY Language hrp1000 langu Primary lang.
KEY AssignmentValidityStartDate begda Valid From
KEY AssignmentValidityEndDate endda Valid To
MDGovWrkflwTskProcessorName hrp1000 stext Text

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_MDGovWrkflwOrg.
-- 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: ICRWFORG

CREATE VIEW I_MDGovWrkflwOrg AS
SELECT
  cast( HRP1000.otype as otype) AS WorkflowOrglObjectType,
  cast( HRP1000.objid as actorid) AS WorkflowOrglObject,
  HRP1000.langu AS Language,
  begda AS AssignmentValidityStartDate,
  endda AS AssignmentValidityEndDate,
  HRP1000.stext AS MDGovWrkflwTskProcessorName
FROM hrp1000 AS HRP1000
;

Learn More