I_ProcmtAutomnActionInputTP

DDL: I_PROCMTAUTOMNACTIONINPUTTP SQL: IPRMTACTINPUTTP Type: view TRANSACTIONAL Package: APPL_MM_PUR_BUS_PROC_AUTOMN
8 Fields 1 Data Sources 2 Associations

BO View for Action Inputs for Automation

I_ProcmtAutomnActionInputTP is a Transactional CDS View that provides data about "BO View for Action Inputs for Automation" in SAP S/4HANA. It reads from 1 data source (I_ProcmtAutomnActionInput) and exposes 8 fields with key fields ProcmtAutomnActionUniqueID, ProcmtAutomnActnInputUniqueID, ProcmtAutomnRuleID, ProcmtAutomnActivityID. It has 2 associations to related views. Part of development package APPL_MM_PUR_BUS_PROC_AUTOMN.

Data Sources (1)

SourceAliasJoin Type
I_ProcmtAutomnActionInput I_ProcmtAutomnActionInput from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_ProcmtAutomnRuleActionTP _ProcmtAutomnRuleActionTP _ProcmtAutomnRuleActionTP.ProcmtAutomnActionUniqueID = $projection.ProcmtAutomnActionUniqueID and _ProcmtAutomnRuleActionTP.ProcmtAutomnRuleID = $projection.ProcmtAutomnRuleID and _ProcmtAutomnRuleActionTP.ProcmtAutomnActivityID = $projection.ProcmtAutomnActivityID
[1..1] I_ProcmtAutomnRuleDefinitionTP _ProcmtAutomnRuleDefinitionTP _ProcmtAutomnRuleDefinitionTP.ProcmtAutomnRuleID = $projection.ProcmtAutomnRuleID

Annotations (16)

NameValueLevelField
AbapCatalog.sqlViewName IPRMTACTINPUTTP view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label BO View for Action Inputs for Automation view
AccessControl.personalData.blocking #REQUIRED view
ObjectModel.writeDraftPersistence PRMTACTINPUTTP_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

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY ProcmtAutomnActionUniqueID ProcmtAutomnActionUniqueID Action Unique ID
KEY ProcmtAutomnActnInputUniqueID ProcmtAutomnActnInputUniqueID Action Unique ID
KEY ProcmtAutomnRuleID ProcmtAutomnRuleID Rule ID
KEY ProcmtAutomnActivityID ProcmtAutomnActivityID Activity ID
ProcmtAutomnInputUnqIDForEdit ProcmtAutomnActnInputUniqueID Action Unique ID
ProcmtAutomnActionInputSet ProcmtAutomnActionInputSet Input Set
_ProcmtAutomnRuleActionTP _ProcmtAutomnRuleActionTP
_ProcmtAutomnRuleDefinitionTP _ProcmtAutomnRuleDefinitionTP

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_ProcmtAutomnActionInputTP.
-- 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: IPRMTACTINPUTTP

CREATE VIEW I_ProcmtAutomnActionInputTP AS
SELECT
  ProcmtAutomnActionUniqueID,
  ProcmtAutomnActnInputUniqueID,
  ProcmtAutomnRuleID,
  ProcmtAutomnActivityID,
  ProcmtAutomnActnInputUniqueID AS ProcmtAutomnInputUnqIDForEdit,
  ProcmtAutomnActionInputSet
FROM I_ProcmtAutomnActionInput
LEFT OUTER JOIN I_ProcmtAutomnRuleActionTP AS _ProcmtAutomnRuleActionTP ON _ProcmtAutomnRuleActionTP.ProcmtAutomnActionUniqueID = ProcmtAutomnActionUniqueID AND _ProcmtAutomnRuleActionTP.ProcmtAutomnRuleID = ProcmtAutomnRuleID AND _ProcmtAutomnRuleActionTP.ProcmtAutomnActivityID = ProcmtAutomnActivityID  -- association [1..1]
LEFT OUTER JOIN I_ProcmtAutomnRuleDefinitionTP AS _ProcmtAutomnRuleDefinitionTP ON _ProcmtAutomnRuleDefinitionTP.ProcmtAutomnRuleID = ProcmtAutomnRuleID  -- association [1..1]
;

Learn More