R_CollsInvoicePrioznRuleTP

DDL: R_COLLSINVOICEPRIOZNRULETP Type: view_entity TRANSACTIONAL
11 Fields 1 Data Sources 1 Associations

Invoice Prioritization Rule

R_CollsInvoicePrioznRuleTP is a Transactional CDS View that provides data about "Invoice Prioritization Rule" in SAP S/4HANA. It reads from 1 data source (I_CollsInvoicePrioznRule) and exposes 11 fields with key fields RootObjectUUID, ParentObjectUUID, MyObjectUUID. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_CollsInvoicePrioznRule I_CollsInvoicePrioznRule from

Associations (1)

CardinalityTargetAliasCondition
[0..1] R_CollsInvoicePrioznStrategyTP _CollsInvoicePrioznStrategyTP $projection.RootObjectUUID = _CollsInvoicePrioznStrategyTP.RootObjectUUID

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Invoice Prioritization Rule view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.representativeKey MyObjectUUID view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY RootObjectUUID RootObjectUUID Entity GUID
KEY ParentObjectUUID ParentObjectUUID UUID Parent GO
KEY MyObjectUUID MyObjectUUID UUID 22 char.
CollBasicRuleStruc CollBasicRuleStruc Bas. Rule Stru.
CollBasicRuleFieldName CollBasicRuleFieldName UI Group FieldName
SetRangeSign SetRangeSign Type of SIGN component in row type of a Ranges type
SetRangeOption SetRangeOption Select Option
SetRangeFromValue SetRangeFromValue Value from
SetRangeToValue SetRangeToValue Value up to
_CollsInvcPrioznRuleAssgmtTP _CollsInvcPrioznRuleAssgmtTP
_CollsInvoicePrioznStrategyTP _CollsInvoicePrioznStrategyTP

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 R_CollsInvoicePrioznRuleTP.
-- 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.

CREATE VIEW R_CollsInvoicePrioznRuleTP AS
SELECT
  RootObjectUUID,
  ParentObjectUUID,
  MyObjectUUID,
  CollBasicRuleStruc,
  CollBasicRuleFieldName,
  SetRangeSign,
  SetRangeOption,
  SetRangeFromValue,
  SetRangeToValue
FROM I_CollsInvoicePrioznRule
LEFT OUTER JOIN R_CollsInvoicePrioznStrategyTP AS _CollsInvoicePrioznStrategyTP ON RootObjectUUID = _CollsInvoicePrioznStrategyTP.RootObjectUUID  -- association [0..1]
;

Learn More