I_ProcmtAutomnRuleCriteria

DDL: I_PROCMTAUTOMNRULECRITERIA SQL: IPRMTRULCRT Type: view BASIC
8 Fields 1 Data Sources

Base view for Rule critera

I_ProcmtAutomnRuleCriteria is a Basic CDS View that provides data about "Base view for Rule critera" in SAP S/4HANA. It reads from 1 data source (mmpur_rul_crtria) and exposes 8 fields with key fields ProcmtAutomnRuleID, ExtSourceSystem, SAPObjectNodeType, BusinessObjectFieldName, ItemCounter.

Data Sources (1)

SourceAliasJoin Type
mmpur_rul_crtria mmpur_rul_crtria from

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName IPRMTRULCRT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #BASIC view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
EndUserText.label Base view for Rule critera view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY ProcmtAutomnRuleID procmtautomnruleid Rule ID
KEY ExtSourceSystem extsourcesystem Connected System ID
KEY SAPObjectNodeType sapobjectnodetype SONT Name
KEY BusinessObjectFieldName businessobjectfieldname Field Name
KEY ItemCounter itemcounter Sequence
Operator operator Type of OPTION component in row type of a Ranges type
BusinessObjectKeyFieldValue1 businessobjectkeyfieldvalue1 Value High
BusinessObjectKeyFieldValue2 businessobjectkeyfieldvalue2 Value Low

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_ProcmtAutomnRuleCriteria.
-- 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: IPRMTRULCRT

CREATE VIEW I_ProcmtAutomnRuleCriteria AS
SELECT
  ProcmtAutomnRuleID,
  ExtSourceSystem,
  SAPObjectNodeType,
  BusinessObjectFieldName,
  ItemCounter,
  Operator,
  BusinessObjectKeyFieldValue1,
  BusinessObjectKeyFieldValue2
FROM mmpur_rul_crtria
;

Learn More