R_SbsMssProcgElmContrDocChgTP

DDL: R_SBSMSSPROCGELMCONTRDOCCHGTP Type: view_entity TRANSACTIONAL
33 Fields 1 Data Sources 1 Associations

SMP Element Document Change - TP

R_SbsMssProcgElmContrDocChgTP is a Transactional CDS View that provides data about "SMP Element Document Change - TP" in SAP S/4HANA. It reads from 1 data source (I_SbsMssProcgElmContrDocChg) and exposes 33 fields with key field SubscrpnMassProcgElmntUUID. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_SbsMssProcgElmContrDocChg SbsMssProcgElmContrDocChg from

Associations (1)

CardinalityTargetAliasCondition
[0..1] E_SbsMssProcgElmContrDocChg _Extension $projection.SubscrpnMassProcgElmntUUID = _Extension.SubscrpnMassProcgElmntUUID

Annotations (12)

NameValueLevelField
EndUserText.label SMP Element Document Change - TP view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.representativeKey SubscrpnMassProcgElmntUUID view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
AccessControl.authorizationCheck #MANDATORY view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.sapObjectNodeType.name SbsMssProcgElmContrDocChg view
AbapCatalog.extensibility.extensible true view
AbapCatalog.extensibility.elementSuffix MPX view

Fields (33)

KeyFieldSource TableSource FieldDescription
KEY SubscrpnMassProcgElmntUUID SubscrpnMassProcgElmntUUID UUID
CreatedByUser CreatedByUser User Name
CreationDateTime CreationDateTime Timestamp
LastChangedByUser LastChangedByUser User Name
LocalLastChangeDateTime LocalLastChangeDateTime Time Stamp
SubscrpnMassProcgUUID SubscrpnMassProcgUUID Mass Processing UUID
SubscrpnMassProcgID SubscrpnMassProcgID Mass Processing ID
SbsMssProcgElmntProcdAtDteTme SbsMssProcgElmntProcdAtDteTme Processed At
SubscrpnMassProcgElmntSts SubscrpnMassProcgElmntSts Status
SubscrpnMassProcgElmntLgHandle SubscrpnMassProcgElmntLgHandle Handle
SubscriptionContract SubscriptionContract Transaction ID
SubscriptionChangeOrder SubscriptionChangeOrder Transaction ID
SbsMssProcgElmFllwUpDoc SbsMssProcgElmFllwUpDoc ID
SbsMssProcgElmntActvtnDteTme SbsMssProcgElmntActvtnDteTme Activation Timestamp
SbsMssProcgElmntSoldToParty SbsMssProcgElmntSoldToParty Customer
SbsMssProcgElmContractAccount SbsMssProcgElmContractAccount Contract Acct
SubscrpnMassProcgElmntSlsOrg SubscrpnMassProcgElmntSlsOrg Sales Org.
SbsMssProcgElmDistrChnl SbsMssProcgElmDistrChnl Distribution Channel
SubscrpnMassProcgElmntDivn SubscrpnMassProcgElmntDivn Division
SubscrpnMassProcgElmntSlsOffc SubscrpnMassProcgElmntSlsOffc Sales Office
SubscrpnMassProcgElmntSlsGrp SubscrpnMassProcgElmntSlsGrp Sales Group
SbsMssProcgElmSlsOrgUntID SbsMssProcgElmSlsOrgUntID Sales Org. ID
_SubscriptionContract _SubscriptionContract
_SubscrpnMassProcgElmntSts _SubscrpnMassProcgElmntSts
_ContractAccountPartner _ContractAccountPartner
_SoldToParty _SoldToParty
_SalesOrganization _SalesOrganization
_SalesOffice _SalesOffice
_SalesGroup _SalesGroup
_Division _Division
_DistributionChannel _DistributionChannel
_SalesOrganizationUnit _SalesOrganizationUnit
_SubscriptionMassProcessing _SubscriptionMassProcessing

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_SbsMssProcgElmContrDocChgTP.
-- 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_SbsMssProcgElmContrDocChgTP AS
SELECT
  SubscrpnMassProcgElmntUUID,
  CreatedByUser,
  CreationDateTime,
  LastChangedByUser,
  LocalLastChangeDateTime,
  SubscrpnMassProcgUUID,
  SubscrpnMassProcgID,
  SbsMssProcgElmntProcdAtDteTme,
  SubscrpnMassProcgElmntSts,
  SubscrpnMassProcgElmntLgHandle,
  SubscriptionContract,
  SubscriptionChangeOrder,
  SbsMssProcgElmFllwUpDoc,
  SbsMssProcgElmntActvtnDteTme,
  SbsMssProcgElmntSoldToParty,
  SbsMssProcgElmContractAccount,
  SubscrpnMassProcgElmntSlsOrg,
  SbsMssProcgElmDistrChnl,
  SubscrpnMassProcgElmntDivn,
  SubscrpnMassProcgElmntSlsOffc,
  SubscrpnMassProcgElmntSlsGrp,
  SbsMssProcgElmSlsOrgUntID
FROM I_SbsMssProcgElmContrDocChg AS SbsMssProcgElmContrDocChg
LEFT OUTER JOIN E_SbsMssProcgElmContrDocChg AS _Extension ON SubscrpnMassProcgElmntUUID = _Extension.SubscrpnMassProcgElmntUUID  -- association [0..1]
;

Learn More