I_SbsMssProcgElmContrDocChgTP

DDL: I_SBSMSSPROCGELMCONTRDOCCHGTP Type: view_entity TRANSACTIONAL
15 Fields 1 Data Sources

SMP Element Document Change - TP

I_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 (R_SbsMssProcgElmContrDocChgTP) and exposes 15 fields with key field SubscrpnMassProcgElmntUUID.

Data Sources (1)

SourceAliasJoin Type
R_SbsMssProcgElmContrDocChgTP R_SbsMssProcgElmContrDocChgTP projection

Annotations (12)

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

Fields (15)

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
SbsMssProcgElmntActvtnDteTme SbsMssProcgElmntActvtnDteTme Activation Timestamp
SbsMssProcgElmntSoldToParty SbsMssProcgElmntSoldToParty Customer
SbsMssProcgElmContractAccount SbsMssProcgElmContractAccount Contract Acct

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_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 I_SbsMssProcgElmContrDocChgTP AS
SELECT
  SubscrpnMassProcgElmntUUID,
  CreatedByUser,
  CreationDateTime,
  LastChangedByUser,
  LocalLastChangeDateTime,
  SubscrpnMassProcgUUID,
  SubscrpnMassProcgID,
  SbsMssProcgElmntProcdAtDteTme,
  SubscrpnMassProcgElmntSts,
  SubscrpnMassProcgElmntLgHandle,
  SubscriptionContract,
  SubscriptionChangeOrder,
  SbsMssProcgElmntActvtnDteTme,
  SbsMssProcgElmntSoldToParty,
  SbsMssProcgElmContractAccount
FROM R_SbsMssProcgElmContrDocChgTP
;

Learn More