I_SbsMssProcgElmConItmPrcElm

DDL: I_SBSMSSPROCGELMCONITMPRCELM Type: view_entity BASIC
15 Fields 1 Data Sources 1 Associations

Mass Processing Item Price Elements

I_SbsMssProcgElmConItmPrcElm is a Basic CDS View that provides data about "Mass Processing Item Price Elements" in SAP S/4HANA. It reads from 1 data source (crms4d_som_mpec) and exposes 15 fields with key field SbsMssProcgElmPrcCndnUUID. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
crms4d_som_mpec crms4d_som_mpec from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_ConditionType _ConditionType $projection.ConditionType = _ConditionType.ConditionType and _ConditionType.ConditionUsage = 'A' and _ConditionType.ConditionApplication = 'V'

Annotations (10)

NameValueLevelField
EndUserText.label Mass Processing Item Price Elements view
Metadata.ignorePropagatedAnnotations true view
Analytics.technicalName ISBSMSSPROCGELMCONITMPRCELM view
ObjectModel.representativeKey SbsMssProcgElmPrcCndnUUID view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
AccessControl.authorizationCheck #MANDATORY view
VDM.viewType #BASIC view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY SbsMssProcgElmPrcCndnUUID sbsmssprocgelmprccndnuuid MP Price Cond UUID
CreatedByUser createdbyuser User Name
CreationDateTime creationdatetime Timestamp
LastChangedByUser lastchangedbyuser User Name
LocalLastChangeDateTime locallastchangedatetime Time Stamp
SubscrpnMassProcgUUID subscrpnmassprocguuid Mass Processing UUID
SubscrpnMassProcgElmntUUID subscrpnmassprocgelmntuuid UUID
ConditionType conditiontype Condition type
ConditionRateAmount conditionrateamount Condition Amount
ConditionCurrency conditioncurrency Currency
ConditionQuantity conditionquantity Pricing Unit
ConditionQuantityUnit conditionquantityunit Unit of Measure
ConditionRateRatio conditionrateratio Ratio
ConditionRateRatioUnit conditionrateratiounit Unit of Measure
_ConditionType _ConditionType

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_SbsMssProcgElmConItmPrcElm.
-- 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_SbsMssProcgElmConItmPrcElm AS
SELECT
  SbsMssProcgElmPrcCndnUUID,
  CreatedByUser,
  CreationDateTime,
  LastChangedByUser,
  LocalLastChangeDateTime,
  SubscrpnMassProcgUUID,
  SubscrpnMassProcgElmntUUID,
  ConditionType,
  ConditionRateAmount,
  ConditionCurrency,
  ConditionQuantity,
  ConditionQuantityUnit,
  ConditionRateRatio,
  ConditionRateRatioUnit
FROM crms4d_som_mpec
LEFT OUTER JOIN I_ConditionType AS _ConditionType ON ConditionType = _ConditionType.ConditionType AND _ConditionType.ConditionUsage = 'A' AND _ConditionType.ConditionApplication = 'V'  -- association [1..1]
;

Learn More