R_CollsInvcPrioznRuleAssgmtTP

DDL: R_COLLSINVCPRIOZNRULEASSGMTTP Type: view_entity TRANSACTIONAL
8 Fields 1 Data Sources 2 Associations

Invoice Prioritization Rule Assignment

R_CollsInvcPrioznRuleAssgmtTP is a Transactional CDS View that provides data about "Invoice Prioritization Rule Assignment" in SAP S/4HANA. It reads from 1 data source (I_CollsInvcPrioznRuleAssgmt) and exposes 8 fields with key fields ParentObjectUUID, MyObjectUUID. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_CollsInvcPrioznRuleAssgmt I_CollsInvcPrioznRuleAssgmt from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_CollectionsBasisRule _CollectionsBasisRule $projection.CollectionBasicRule = _CollectionsBasisRule.CollectionBasicRule
[0..*] R_CollsInvoicePrioznRuleTP _CollsInvoicePrioznRuleTP

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Invoice Prioritization Rule Assignment 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 (8)

KeyFieldSource TableSource FieldDescription
KEY ParentObjectUUID ParentObjectUUID UUID Parent GO
KEY MyObjectUUID MyObjectUUID UUID 22 char.
CollectionBasicRule CollectionBasicRule Basic Rule
CollsBasicRuleValuationValue CollsBasicRuleValuationValue Valuation View
CollRuleIsExitRule CollRuleIsExitRule Exit Rule
_CollectionsBasisRule _CollectionsBasisRule
_CollsInvoicePrioznStrategyTP _CollsInvoicePrioznStrategyTP
_CollsInvoicePrioznRuleTP _CollsInvoicePrioznRuleTP

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_CollsInvcPrioznRuleAssgmtTP.
-- 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_CollsInvcPrioznRuleAssgmtTP AS
SELECT
  ParentObjectUUID,
  MyObjectUUID,
  CollectionBasicRule,
  CollsBasicRuleValuationValue,
  CollRuleIsExitRule
FROM I_CollsInvcPrioznRuleAssgmt
LEFT OUTER JOIN I_CollectionsBasisRule AS _CollectionsBasisRule ON CollectionBasicRule = _CollectionsBasisRule.CollectionBasicRule  -- association [0..1]
LEFT OUTER JOIN R_CollsInvoicePrioznRuleTP AS _CollsInvoicePrioznRuleTP ON /* condition not available in parsed metadata */  -- association [0..*]
;

Learn More