C_SbsMssProcgElmContrDocProcd

DDL: C_SBSMSSPROCGELMCONTRDOCPROCD Type: view_entity CONSUMPTION
50 Fields 1 Data Sources

SMPE Document Change Processed

C_SbsMssProcgElmContrDocProcd is a Consumption CDS View that provides data about "SMPE Document Change Processed" in SAP S/4HANA. It reads from 1 data source (R_SbsMssProcgElmContrDocChgTP) and exposes 50 fields with key field SubscrpnMassProcgElmntUUID.

Data Sources (1)

SourceAliasJoin Type
R_SbsMssProcgElmContrDocChgTP R_SbsMssProcgElmContrDocChgTP projection

Annotations (10)

NameValueLevelField
EndUserText.label SMPE Document Change Processed view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
AccessControl.authorizationCheck #MANDATORY view
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions true view
AbapCatalog.extensibility.extensible true view
AbapCatalog.extensibility.elementSuffix MPX view

Fields (50)

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
SubscrpnMassProcgElmntStsTxtlocalized
SubscrpnMassProcgElmntLgHandle Handle
SubscriptionContract SubscriptionContract Transaction ID
SubscriptionChangeOrder SubscriptionChangeOrder Transaction ID
SbsMssProcgElmFllwUpDoc SbsMssProcgElmFllwUpDoc ID
SbsMssProcgElmntActvtnDteTme SbsMssProcgElmntActvtnDteTme Activation Timestamp
SbsMssProcgElmntSoldToParty SbsMssProcgElmntSoldToParty Customer
SbsMssProcgElmntSoldToPtyName _SoldToParty BusinessPartnerName Extracted Customer Name
SoldToParty _SubscriptionContract SoldToParty Sold-to Party
SoldToPartyName
PayerParty _SubscriptionContract PayerParty Payer
PayerPartyName
ShipToParty _SubscriptionContract ShipToParty Ship-To Party (obsolete)
ShipToPartyName
BillToParty _SubscriptionContract BillToParty Inv. Recipient
BillToPartyName
RespEmployeeBusinessPartnerId _SubscriptionContract RespEmployeeBusinessPartnerId
ResponsibleEmployeeName
ContactPersonBusinessPartnerId _SubscriptionContract ContactPersonBusinessPartnerId
ContactPersonName
SubscriptionContractPostingDte _SubscriptionContract SubscriptionContractPostingDte
SalesOrganization _SubscriptionContract SalesOrganization Sales Organization
SalesOrganizationNamelocalized
DistributionChannel _SubscriptionContract DistributionChannel RefDistCh-Cust/Mat.
DistributionChannelNamelocalized
Division _SubscriptionContract Division Internal Division ID
DivisionNamelocalized
SalesOffice _SubscriptionContract SalesOffice Sales Office
SalesOfficeNamelocalized
SalesGroup _SubscriptionContract SalesGroup Sales Group
SalesGroupNamelocalized
SbsMssProcgElmContractAccount SbsMssProcgElmContractAccount Contract Acct
ContractAccountName _ContractAccountPartner ContractAccountName Cont. acct name
SubscrpnContractDescription _SubscriptionContract SubscrpnContractDescription
SubscrpnMassProcgElmntSlsOrg SubscrpnMassProcgElmntSlsOrg Sales Org.
SbsMssProcgElmDistrChnl SbsMssProcgElmDistrChnl Distribution Channel
SubscrpnMassProcgElmntDivn SubscrpnMassProcgElmntDivn Division
SubscrpnMassProcgElmntSlsOffc SubscrpnMassProcgElmntSlsOffc Sales Office
SubscrpnMassProcgElmntSlsGrp SubscrpnMassProcgElmntSlsGrp Sales Group
SbsMssProcgElmSlsOrgUntID SbsMssProcgElmSlsOrgUntID Sales Org. ID
int1

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 C_SbsMssProcgElmContrDocProcd.
-- 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 C_SbsMssProcgElmContrDocProcd AS
SELECT
  SubscrpnMassProcgElmntUUID,
  CreatedByUser,
  CreationDateTime,
  LastChangedByUser,
  LocalLastChangeDateTime,
  SubscrpnMassProcgUUID,
  SubscrpnMassProcgID,
  SbsMssProcgElmntProcdAtDteTme,
  SubscrpnMassProcgElmntSts,
  _SubscrpnMassProcgElmntSts._Text.SubscrpnMassProcgElmntStsTxt : localized AS SubscrpnMassProcgElmntStsTxtlocalized,
  cast(SubscrpnMassProcgElmntLgHandle as char22 preserving type) AS SubscrpnMassProcgElmntLgHandle,
  SubscriptionContract,
  SubscriptionChangeOrder,
  SbsMssProcgElmFllwUpDoc,
  SbsMssProcgElmntActvtnDteTme,
  SbsMssProcgElmntSoldToParty,
  _SoldToParty.BusinessPartnerName AS SbsMssProcgElmntSoldToPtyName,
  _SubscriptionContract.SoldToParty AS SoldToParty,
  _SubscriptionContract._SoldToParty.BusinessPartnerName AS SoldToPartyName,
  _SubscriptionContract.PayerParty AS PayerParty,
  _SubscriptionContract._PayerParty.BusinessPartnerName AS PayerPartyName,
  _SubscriptionContract.ShipToParty AS ShipToParty,
  _SubscriptionContract._ShipToParty.BusinessPartnerName AS ShipToPartyName,
  _SubscriptionContract.BillToParty AS BillToParty,
  _SubscriptionContract._BillToParty.BusinessPartnerName AS BillToPartyName,
  _SubscriptionContract.RespEmployeeBusinessPartnerId AS RespEmployeeBusinessPartnerId,
  _SubscriptionContract._RespEmployee.BusinessPartnerName AS ResponsibleEmployeeName,
  _SubscriptionContract.ContactPersonBusinessPartnerId AS ContactPersonBusinessPartnerId,
  _SubscriptionContract._ContactPerson.BusinessPartnerName AS ContactPersonName,
  _SubscriptionContract.SubscriptionContractPostingDte AS SubscriptionContractPostingDte,
  _SubscriptionContract.SalesOrganization AS SalesOrganization,
  _SubscriptionContract._SalesOrganization._Text.SalesOrganizationName : localized AS SalesOrganizationNamelocalized,
  _SubscriptionContract.DistributionChannel AS DistributionChannel,
  _SubscriptionContract._DistributionChannel._Text.DistributionChannelName : localized AS DistributionChannelNamelocalized,
  _SubscriptionContract.Division AS Division,
  _SubscriptionContract._Division._Text.DivisionName : localized AS DivisionNamelocalized,
  _SubscriptionContract.SalesOffice AS SalesOffice,
  _SubscriptionContract._SalesOffice._Text.SalesOfficeName : localized AS SalesOfficeNamelocalized,
  _SubscriptionContract.SalesGroup AS SalesGroup,
  _SubscriptionContract._SalesGroup._Text.SalesGroupName : localized AS SalesGroupNamelocalized,
  SbsMssProcgElmContractAccount,
  _ContractAccountPartner.ContractAccountName AS ContractAccountName,
  _SubscriptionContract.SubscrpnContractDescription AS SubscrpnContractDescription,
  SubscrpnMassProcgElmntSlsOrg,
  SbsMssProcgElmDistrChnl,
  SubscrpnMassProcgElmntDivn,
  SubscrpnMassProcgElmntSlsOffc,
  SubscrpnMassProcgElmntSlsGrp,
  SbsMssProcgElmSlsOrgUntID,
  virtual SbsMssProcgElmStsCritlty : abap.int1 AS int1
FROM R_SbsMssProcgElmContrDocChgTP
;

Learn More