R_CollsInvoicePrioznStrategyTP

DDL: R_COLLSINVOICEPRIOZNSTRATEGYTP Type: view_entity TRANSACTIONAL Package: UDM_STRATEGY
8 Fields 1 Data Sources 3 Associations

Invoice Prioritization Strategy

R_CollsInvoicePrioznStrategyTP is a Transactional CDS View that provides data about "Invoice Prioritization Strategy" in SAP S/4HANA. It reads from 1 data source (I_CollsInvoicePrioznStrategy) and exposes 8 fields with key field RootObjectUUID. It has 3 associations to related views. Part of development package UDM_STRATEGY.

Data Sources (1)

SourceAliasJoin Type
I_CollsInvoicePrioznStrategy I_CollsInvoicePrioznStrategy from

Associations (3)

CardinalityTargetAliasCondition
[0..1] I_CollectionsStrategy _CollectionsStrategy $projection.CollectionStrategy = _CollectionsStrategy.CollectionStrategy
[0..*] R_CollsInvcPrioznRuleAssgmtTP _CollsInvcPrioznRuleAssgmtTP
[0..*] R_CollsInvcPrioznCriticalityTP _CollsInvcPrioznCriticalityTP

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Invoice Prioritization Strategy 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 RootObjectUUID view
ObjectModel.sapObjectNodeType.name CollectionsStrategy view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY RootObjectUUID RootObjectUUID Entity GUID
CollectionStrategy CollectionStrategy Strategy
CollStrgyMaxValuation CollStrgyMaxValuation Valuation View
CollStrgyAutoValuation CollStrgyAutoValuation Automatic Valuation
LastChangeDateTime LastChangeDateTime Timestamp
_CollectionsStrategy _CollectionsStrategy
_CollsInvcPrioznRuleAssgmtTP _CollsInvcPrioznRuleAssgmtTP
_CollsInvcPrioznCriticalityTP _CollsInvcPrioznCriticalityTP

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_CollsInvoicePrioznStrategyTP.
-- 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_CollsInvoicePrioznStrategyTP AS
SELECT
  RootObjectUUID,
  CollectionStrategy,
  CollStrgyMaxValuation,
  CollStrgyAutoValuation,
  LastChangeDateTime
FROM I_CollsInvoicePrioznStrategy
LEFT OUTER JOIN I_CollectionsStrategy AS _CollectionsStrategy ON CollectionStrategy = _CollectionsStrategy.CollectionStrategy  -- association [0..1]
LEFT OUTER JOIN R_CollsInvcPrioznRuleAssgmtTP AS _CollsInvcPrioznRuleAssgmtTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_CollsInvcPrioznCriticalityTP AS _CollsInvcPrioznCriticalityTP ON /* condition not available in parsed metadata */  -- association [0..*]
;

Learn More