R_SbsMssProcgElmCoItPrElmDrft

DDL: R_SBSMSSPROCGELMCOITPRELMDRFT Type: view_entity BASIC
22 Fields 1 Data Sources 2 Associations

Mass Process Item Price Element - Draft

R_SbsMssProcgElmCoItPrElmDrft is a Basic CDS View that provides data about "Mass Process Item Price Element - Draft" in SAP S/4HANA. It reads from 1 data source (crms4d_som_mpecd) and exposes 22 fields with key field SbsMssProcgElmPrcCndnUUID. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
crms4d_som_mpecd crms4d_som_mpecd from

Associations (2)

CardinalityTargetAliasCondition
[1..1] R_SubscrpnMassProcessingDraft _SubscrpnMassProcessingDraft $projection.SubscrpnMassProcgUUID = _SubscrpnMassProcessingDraft.SubscrpnMassProcgUUID
[0..1] E_SbsMssProcgElmCoItPrElmDrft _Extension $projection.SbsMssProcgElmPrcCndnUUID = _Extension.SbsMssProcgElmPrcCndnUUID

Annotations (12)

NameValueLevelField
EndUserText.label Mass Process Item Price Element - Draft view
Metadata.ignorePropagatedAnnotations true 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
ObjectModel.sapObjectNodeType.name SbsMssProcgElmConItmPrcElm view
AbapCatalog.extensibility.extensible true view
AbapCatalog.extensibility.elementSuffix MPY view

Fields (22)

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
DraftEntityCreationDateTime draftentitycreationdatetime Draft Created On
DraftEntityLastChangeDateTime draftentitylastchangedatetime Draft Last Changed On
DraftAdministrativeDataUUID draftadministrativedatauuid UUID
DraftEntityOperationCode draftentityoperationcode Draft - Operation Code
HasActiveEntity hasactiveentity TRUE
DraftFieldChanges draftfieldchanges Field Changes
_SbsMssProcgElmConItmChgDraft _SbsMssProcgElmConItmChgDraft
_SubscrpnMassProcessingDraft _SubscrpnMassProcessingDraft

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_SbsMssProcgElmCoItPrElmDrft.
-- 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_SbsMssProcgElmCoItPrElmDrft AS
SELECT
  SbsMssProcgElmPrcCndnUUID,
  CreatedByUser,
  CreationDateTime,
  LastChangedByUser,
  LocalLastChangeDateTime,
  SubscrpnMassProcgUUID,
  SubscrpnMassProcgElmntUUID,
  ConditionType,
  ConditionRateAmount,
  ConditionCurrency,
  ConditionQuantity,
  ConditionQuantityUnit,
  ConditionRateRatio,
  ConditionRateRatioUnit,
  DraftEntityCreationDateTime,
  DraftEntityLastChangeDateTime,
  DraftAdministrativeDataUUID,
  DraftEntityOperationCode,
  HasActiveEntity,
  DraftFieldChanges
FROM crms4d_som_mpecd
LEFT OUTER JOIN R_SubscrpnMassProcessingDraft AS _SubscrpnMassProcessingDraft ON SubscrpnMassProcgUUID = _SubscrpnMassProcessingDraft.SubscrpnMassProcgUUID  -- association [1..1]
LEFT OUTER JOIN E_SbsMssProcgElmCoItPrElmDrft AS _Extension ON SbsMssProcgElmPrcCndnUUID = _Extension.SbsMssProcgElmPrcCndnUUID  -- association [0..1]
;

Learn More