I_ProcmtAutomnRuleDefinitionTP

DDL: I_PROCMTAUTOMNRULEDEFINITIONTP SQL: IPRAUTRULEDEFTP Type: view TRANSACTIONAL Package: APPL_MM_PUR_BUS_PROC_AUTOMN
14 Fields 1 Data Sources 3 Associations

BO View Rule Definition for Automation

I_ProcmtAutomnRuleDefinitionTP is a Transactional CDS View that provides data about "BO View Rule Definition for Automation" in SAP S/4HANA. It reads from 1 data source (I_ProcmtAutomnRuleDefinition) and exposes 14 fields with key field ProcmtAutomnRuleID. It has 3 associations to related views. Part of development package APPL_MM_PUR_BUS_PROC_AUTOMN.

Data Sources (1)

SourceAliasJoin Type
I_ProcmtAutomnRuleDefinition I_ProcmtAutomnRuleDefinition from

Associations (3)

CardinalityTargetAliasCondition
[0..*] I_ProcmtAutomnRuleActivityTP _ProcmtAutomnRuleActivityTP _ProcmtAutomnRuleActivityTP.ProcmtAutomnRuleID = $projection.ProcmtAutomnRuleID
[0..*] I_ProcmtAutomnRuleConncdSystTP _ProcmtAutomnRuleConncdSystTP _ProcmtAutomnRuleConncdSystTP.ProcmtAutomnRuleID = $projection.ProcmtAutomnRuleID
[0..*] I_ProcmtAutomnRuleCriteriaTP _ProcmtAutomnRuleCriteriaTP _ProcmtAutomnRuleCriteriaTP.ProcmtAutomnRuleID = $projection.ProcmtAutomnRuleID

Annotations (19)

NameValueLevelField
AbapCatalog.sqlViewName IPRAUTRULEDEFTP view
ObjectModel.compositionRoot true view
AccessControl.personalData.blocking #REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label BO View Rule Definition for Automation view
ObjectModel.draftEnabled true view
ObjectModel.writeDraftPersistence PRAUTRULEDEFTP_D view
VDM.viewType #TRANSACTIONAL view
ObjectModel.transactionalProcessingEnabled true view
ObjectModel.createEnabled true view
ObjectModel.updateEnabled true view
ObjectModel.deleteEnabled true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.entityChangeStateId LastChangeDateTime view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY ProcmtAutomnRuleID ProcmtAutomnRuleID Rule ID
ProcmtAutomnRuleIDForEdit ProcmtAutomnRuleID Rule
ProcmtAutomnRuleName ProcmtAutomnRuleName Rule Name
SAPObjectType SAPObjectType SOT Name
ProcmtHubCreatedByUser ProcmtHubCreatedByUser Entered By
PrmtHbLastChangedByUser PrmtHbLastChangedByUser User Name
ProcmtHubCreationDate ProcmtHubCreationDate Created On
LastChangeDateTime LastChangeDateTime Timestamp
ValidityStartDate ValidityStartDate Validity Start Date
ValidityEndDate ValidityEndDate ValidTo
ProcmtAutomnIsRuleActive ProcmtAutomnIsRuleActive Active
_ProcmtAutomnRuleActivityTP _ProcmtAutomnRuleActivityTP
_ProcmtAutomnRuleConncdSystTP _ProcmtAutomnRuleConncdSystTP
_ProcmtAutomnRuleCriteriaTP _ProcmtAutomnRuleCriteriaTP

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_ProcmtAutomnRuleDefinitionTP.
-- 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: IPRAUTRULEDEFTP

CREATE VIEW I_ProcmtAutomnRuleDefinitionTP AS
SELECT
  ProcmtAutomnRuleID,
  ProcmtAutomnRuleID AS ProcmtAutomnRuleIDForEdit,
  ProcmtAutomnRuleName,
  SAPObjectType,
  ProcmtHubCreatedByUser,
  PrmtHbLastChangedByUser,
  ProcmtHubCreationDate,
  LastChangeDateTime,
  ValidityStartDate,
  ValidityEndDate,
  ProcmtAutomnIsRuleActive
FROM I_ProcmtAutomnRuleDefinition
LEFT OUTER JOIN I_ProcmtAutomnRuleActivityTP AS _ProcmtAutomnRuleActivityTP ON _ProcmtAutomnRuleActivityTP.ProcmtAutomnRuleID = ProcmtAutomnRuleID  -- association [0..*]
LEFT OUTER JOIN I_ProcmtAutomnRuleConncdSystTP AS _ProcmtAutomnRuleConncdSystTP ON _ProcmtAutomnRuleConncdSystTP.ProcmtAutomnRuleID = ProcmtAutomnRuleID  -- association [0..*]
LEFT OUTER JOIN I_ProcmtAutomnRuleCriteriaTP AS _ProcmtAutomnRuleCriteriaTP ON _ProcmtAutomnRuleCriteriaTP.ProcmtAutomnRuleID = ProcmtAutomnRuleID  -- association [0..*]
;

Learn More