I_MDOSubscriptionDistribution

DDL: I_MDOSUBSCRIPTIONDISTRIBUTION Type: view_entity
24 Fields 1 Data Sources 9 Associations

Distribution Model

I_MDOSubscriptionDistribution is a CDS View that provides data about "Distribution Model" in SAP S/4HANA. It reads from 1 data source (mdo_subscription) and exposes 24 fields with key field id. It has 9 associations to related views.

Data Sources (1)

SourceAliasJoin Type
mdo_subscription mdo_subscription from

Associations (9)

CardinalityTargetAliasCondition
[0..1] I_MDODescription _LocalizedDescription $projection.id = _LocalizedDescription.parentid and _LocalizedDescription.SapLanguageCode = $session.system_language
[0..1] I_MDOBusinessObjectType _ObjectType _ObjectType.ObjectTypeCode = $projection.businessobjecttype
[0..*] I_MDODescription _Description
[0..*] I_MDOApplicationScope _ApplicationScope
[0..*] I_MDOApplicationScopeGroup _ApplicationScopeGroup
[0..*] I_MDOConsumerApplication _ConsumerApplication
[0..*] I_MDODistributionScope _DistributionScope
[0..*] I_MDOKeyMappingFilter _KeyMappingFilter
[0..*] I_MDOProviderApplDestination _ProviderApplDestination

Annotations (2)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Distribution Model view

Fields (24)

KeyFieldSource TableSource FieldDescription
KEY id id WorklistID
isactive isactive Object active?
model model Vehicle Model
frequency frequency Reporting Frequency
calltype calltype Mode
islocalmodel islocalmodel Is Local Model
confirmation confirmation FSD Conf Status
packagesize packagesize Pkg Size
recurrence recurrence Recurrence Pattern
creationdate creationdate Time Stamp
cutoffdate cutoffdate Date
tenantid tenantid Tenant ID
subaccountid subaccountid Subaccount ID
mdohostname mdohostname Host Name
mdouiurl mdouiurl Application URL
_Description _Description
_ApplicationScopeGroup _ApplicationScopeGroup
_ApplicationScope _ApplicationScope
_ConsumerApplication _ConsumerApplication
_DistributionScope _DistributionScope
_KeyMappingFilter _KeyMappingFilter
_ProviderApplDestination _ProviderApplDestination
_LocalizedDescription _LocalizedDescription
_ObjectType _ObjectType

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_MDOSubscriptionDistribution.
-- 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_MDOSubscriptionDistribution AS
SELECT
  id,
  isactive,
  model,
  frequency,
  calltype,
  islocalmodel,
  confirmation,
  packagesize,
  recurrence,
  creationdate,
  cutoffdate,
  tenantid,
  subaccountid,
  mdohostname,
  mdouiurl
FROM mdo_subscription
LEFT OUTER JOIN I_MDODescription AS _LocalizedDescription ON id = _LocalizedDescription.parentid AND _LocalizedDescription.SapLanguageCode = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_MDOBusinessObjectType AS _ObjectType ON _ObjectType.ObjectTypeCode = businessobjecttype  -- association [0..1]
LEFT OUTER JOIN I_MDODescription AS _Description ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_MDOApplicationScope AS _ApplicationScope ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_MDOApplicationScopeGroup AS _ApplicationScopeGroup ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_MDOConsumerApplication AS _ConsumerApplication ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_MDODistributionScope AS _DistributionScope ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_MDOKeyMappingFilter AS _KeyMappingFilter ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_MDOProviderApplDestination AS _ProviderApplDestination ON /* condition not available in parsed metadata */  -- association [0..*]
;

Learn More