I_CollsInvoicePrioznRule

DDL: I_COLLSINVOICEPRIOZNRULE Type: view BASIC
9 Fields 1 Data Sources

Invoice Prioritization Rule

I_CollsInvoicePrioznRule is a Basic CDS View that provides data about "Invoice Prioritization Rule" in SAP S/4HANA. It reads from 1 data source (udm_inv_pr_sl) and exposes 9 fields with key fields RootObjectUUID, ParentObjectUUID, MyObjectUUID.

Data Sources (1)

SourceAliasJoin Type
udm_inv_pr_sl udm_inv_pr_sl from

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName ICLINVPRRL view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Invoice Prioritization Rule view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.representativeKey MyObjectUUID view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY RootObjectUUID root_guid UUID
KEY ParentObjectUUID parent_guid UUID
KEY MyObjectUUID guid UUID 22 char.
CollBasicRuleStruc basis_rule_str Bas. Rule Stru.
CollBasicRuleFieldName fieldname UI Group FieldName
SetRangeSign sign Type of SIGN component in row type of a Ranges type
SetRangeOption sel_option Select Option
SetRangeFromValue low Value from
SetRangeToValue high Value up to

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_CollsInvoicePrioznRule.
-- 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 I_CollsInvoicePrioznRule AS
SELECT
  root_guid AS RootObjectUUID,
  parent_guid AS ParentObjectUUID,
  guid AS MyObjectUUID,
  basis_rule_str AS CollBasicRuleStruc,
  fieldname AS CollBasicRuleFieldName,
  sign AS SetRangeSign,
  sel_option AS SetRangeOption,
  low AS SetRangeFromValue,
  high AS SetRangeToValue
FROM udm_inv_pr_sl
;

Learn More