C_ProcmtAutomnRuleConncdSystTP

DDL: C_PROCMTAUTOMNRULECONNCDSYSTTP SQL: CPRAUTRULSYSTP Type: view CONSUMPTION Package: ODATA_MM_PUR_BUS_PROC_AUTOMN
5 Fields 1 Data Sources 2 Associations 1 OData Services

Consumption View for Rule Connected Systems

C_ProcmtAutomnRuleConncdSystTP is a Consumption CDS View that provides data about "Consumption View for Rule Connected Systems" in SAP S/4HANA. It reads from 1 data source (I_ProcmtAutomnRuleConncdSystTP) and exposes 5 fields with key fields ProcmtAutomnRuleID, ExtSourceSystem. It has 2 associations to related views. It is exposed through 1 OData service (ASQL_F4042). Part of development package ODATA_MM_PUR_BUS_PROC_AUTOMN.

Data Sources (1)

SourceAliasJoin Type
I_ProcmtAutomnRuleConncdSystTP I_ProcmtAutomnRuleConncdSystTP from

Associations (2)

CardinalityTargetAliasCondition
[1..1] C_ProcmtAutomnRuleDefinitionTP _ProcmtAutomnRuleDefinitionTP _ProcmtAutomnRuleDefinitionTP.ProcmtAutomnRuleID = $projection.ProcmtAutomnRuleID
[0..1] C_ProcmtHubBackendSrceSystemVH _ProcmtHubBackendSrceSystemVH _ProcmtHubBackendSrceSystemVH.ProcurementHubSourceSystem = $projection.ExtSourceSystemForEdit

Annotations (19)

NameValueLevelField
AbapCatalog.sqlViewName CPRAUTRULSYSTP 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 Connected System view
UI.headerInfo.typeNamePlural Automation Connected Systems 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 Connected Systems view

OData Services (1)

ServiceBindingVersionContractRelease
ASQL_F4042 ASQL_F4042 C2 NOT_RELEASED

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY ProcmtAutomnRuleID ProcmtAutomnRuleID Rule
KEY ExtSourceSystem ExtSourceSystem Connected System ID
ExtSourceSystemForEdit ExtSourceSystemForEdit System
_ProcmtAutomnRuleDefinitionTP _ProcmtAutomnRuleDefinitionTP
_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_ProcmtAutomnRuleConncdSystTP.
-- 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: CPRAUTRULSYSTP

CREATE VIEW C_ProcmtAutomnRuleConncdSystTP AS
SELECT
  ProcmtAutomnRuleID,
  ExtSourceSystem,
  ExtSourceSystemForEdit
FROM I_ProcmtAutomnRuleConncdSystTP
LEFT OUTER JOIN C_ProcmtAutomnRuleDefinitionTP AS _ProcmtAutomnRuleDefinitionTP ON _ProcmtAutomnRuleDefinitionTP.ProcmtAutomnRuleID = ProcmtAutomnRuleID  -- association [1..1]
LEFT OUTER JOIN C_ProcmtHubBackendSrceSystemVH AS _ProcmtHubBackendSrceSystemVH ON _ProcmtHubBackendSrceSystemVH.ProcurementHubSourceSystem = ExtSourceSystemForEdit  -- association [0..1]
;

Learn More