C_ProcmtAutomnRuleCriteriaTP

DDL: C_PROCMTAUTOMNRULECRITERIATP SQL: CPRAUTRULCRTTP Type: view CONSUMPTION
18 Fields 1 Data Sources 5 Associations

Consumption View for Rule Criteria

C_ProcmtAutomnRuleCriteriaTP is a Consumption CDS View that provides data about "Consumption View for Rule Criteria" in SAP S/4HANA. It reads from 1 data source (I_ProcmtAutomnRuleCriteriaTP) and exposes 18 fields with key fields ProcmtAutomnRuleID, ExtSourceSystem, SAPObjectNodeType, BusinessObjectFieldName, ItemCounter. It has 5 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_ProcmtAutomnRuleCriteriaTP I_ProcmtAutomnRuleCriteriaTP from

Associations (5)

CardinalityTargetAliasCondition
[1..1] C_ProcmtAutomnRuleDefinitionTP _ProcmtAutomnRuleDefinitionTP _ProcmtAutomnRuleDefinitionTP.ProcmtAutomnRuleID = $projection.ProcmtAutomnRuleID
[0..1] C_ProcmtAutomnSAPObjNodeTypeVH _ProcmtAutomnSAPObjNodeTypeVH _ProcmtAutomnSAPObjNodeTypeVH.SAPObjectType = $projection.SAPObjectType and _ProcmtAutomnSAPObjNodeTypeVH.SAPObjectNodeType = $projection.SAPObjectNodeTypeForEdit
[0..1] C_ProcmtAutomnSAPObjFieldVH _ProcmtAutomnSAPObjFieldVH _ProcmtAutomnSAPObjFieldVH.BusinessObjectFieldName = $projection.BusinessObjectFieldNameForEdit and _ProcmtAutomnSAPObjFieldVH.SAPObjectNodeType = $projection.SAPObjectNodeTypeForEdit
[1..1] C_ProcmtAutomnRuleCritraOptrVH _ProcmtAutomnRuleCritraOptrVH _ProcmtAutomnRuleCritraOptrVH.DomainValue = $projection.Operator
[0..1] C_ProcmtHubBackendSrceSystemVH _ProcmtHubBackendSrceSystemVH _ProcmtHubBackendSrceSystemVH.ProcurementHubSourceSystem = $projection.ExtSourceSystemForEdit

Annotations (19)

NameValueLevelField
AbapCatalog.sqlViewName CPRAUTRULCRTTP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #CONSUMPTION view
ObjectModel.createEnabled true view
ObjectModel.deleteEnabled true view
ObjectModel.updateEnabled true view
UI.headerInfo.typeName Automation Rule Criteria view
UI.headerInfo.typeNamePlural Automation Rule Criterias view
UI.headerInfo.title.value ExtSourceSystemForEdit view
UI.headerInfo.title.label System view
UI.headerInfo.description.value ExtSourceSystemForEdit view
ObjectModel.transactionalProcessingDelegated true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
EndUserText.label Consumption View for Rule Criteria view

Fields (18)

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
ExtSourceSystemForEdit ExtSourceSystemForEdit Connected System ID
SAPObjectNodeTypeForEdit SAPObjectNodeTypeForEdit Node Type
BusinessObjectFieldNameForEdit BusinessObjectFieldNameForEdit Field Name
ItemCounterForEdit ItemCounterForEdit Sequence
Operator Operator Operator
BusinessObjectKeyFieldValue1 BusinessObjectKeyFieldValue1 Value from
BusinessObjectKeyFieldValue2 BusinessObjectKeyFieldValue2 Value To
SAPObjectType _ProcmtAutomnRuleDefinitionTP SAPObjectType SOT Name
_ProcmtAutomnRuleDefinitionTP _ProcmtAutomnRuleDefinitionTP
_ProcmtAutomnSAPObjNodeTypeVH _ProcmtAutomnSAPObjNodeTypeVH
_ProcmtAutomnSAPObjFieldVH _ProcmtAutomnSAPObjFieldVH
_ProcmtAutomnRuleCritraOptrVH _ProcmtAutomnRuleCritraOptrVH
_ProcmtHubBackendSrceSystemVH _ProcmtHubBackendSrceSystemVH

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 C_ProcmtAutomnRuleCriteriaTP.
-- 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: CPRAUTRULCRTTP

CREATE VIEW C_ProcmtAutomnRuleCriteriaTP AS
SELECT
  ProcmtAutomnRuleID,
  ExtSourceSystem,
  SAPObjectNodeType,
  BusinessObjectFieldName,
  ItemCounter,
  ExtSourceSystemForEdit,
  SAPObjectNodeTypeForEdit,
  BusinessObjectFieldNameForEdit,
  ItemCounterForEdit,
  Operator,
  BusinessObjectKeyFieldValue1,
  BusinessObjectKeyFieldValue2,
  _ProcmtAutomnRuleDefinitionTP.SAPObjectType AS SAPObjectType
FROM I_ProcmtAutomnRuleCriteriaTP
LEFT OUTER JOIN C_ProcmtAutomnRuleDefinitionTP AS _ProcmtAutomnRuleDefinitionTP ON _ProcmtAutomnRuleDefinitionTP.ProcmtAutomnRuleID = ProcmtAutomnRuleID  -- association [1..1]
LEFT OUTER JOIN C_ProcmtAutomnSAPObjNodeTypeVH AS _ProcmtAutomnSAPObjNodeTypeVH ON _ProcmtAutomnSAPObjNodeTypeVH.SAPObjectType = SAPObjectType AND _ProcmtAutomnSAPObjNodeTypeVH.SAPObjectNodeType = SAPObjectNodeTypeForEdit  -- association [0..1]
LEFT OUTER JOIN C_ProcmtAutomnSAPObjFieldVH AS _ProcmtAutomnSAPObjFieldVH ON _ProcmtAutomnSAPObjFieldVH.BusinessObjectFieldName = BusinessObjectFieldNameForEdit AND _ProcmtAutomnSAPObjFieldVH.SAPObjectNodeType = SAPObjectNodeTypeForEdit  -- association [0..1]
LEFT OUTER JOIN C_ProcmtAutomnRuleCritraOptrVH AS _ProcmtAutomnRuleCritraOptrVH ON _ProcmtAutomnRuleCritraOptrVH.DomainValue = Operator  -- association [1..1]
LEFT OUTER JOIN C_ProcmtHubBackendSrceSystemVH AS _ProcmtHubBackendSrceSystemVH ON _ProcmtHubBackendSrceSystemVH.ProcurementHubSourceSystem = ExtSourceSystemForEdit  -- association [0..1]
;

Learn More