C_SbsMssProcgElmContrDoc

DDL: C_SBSMSSPROCGELMCONTRDOC Type: view_entity CONSUMPTION
55 Fields 1 Data Sources 1 Associations

Mass Processing Element Document

C_SbsMssProcgElmContrDoc is a Consumption CDS View that provides data about "Mass Processing Element Document" in SAP S/4HANA. It reads from 1 data source (R_SubscriptionContractTP) and exposes 55 fields with key field SubscriptionContract. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
R_SubscriptionContractTP R_SubscriptionContractTP projection

Associations (1)

CardinalityTargetAliasCondition
[0..*] C_SubscriptionContractItemTP _Item $projection.SubscriptionContract = _Item.SubscriptionContract

Annotations (9)

NameValueLevelField
EndUserText.label Mass Processing Element Document 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
Search.searchable false view

Fields (55)

KeyFieldSource TableSource FieldDescription
KEY SubscriptionContract SubscriptionContract Transaction ID
SubscriptionContractType SubscriptionContractType
SubscrpnContractDescription SubscrpnContractDescription
SubscriptionContractUUID SubscriptionContractUUID Object GUID
ServiceObjectType ServiceObjectType Object Type
Language Language Report Text Language
SubscriptionContractPostingDte SubscriptionContractPostingDte
SubscriptionContractStatus SubscriptionContractStatus
SubscrpnContractIsCompleted SubscrpnContractIsCompleted
SubscriptionContractHasError SubscriptionContractHasError
SbsConItmGTSEmbargoStatus SbsConGTSEmbargoStatus
SbsConItmGTSScreeningStatus SbsConGTSScreeningStatus
SbsConItmGTSLglControlStatus SbsConGTSLglControlStatus
ServiceDocumentType ServiceDocumentType Transaction Type
SoldToParty SoldToParty Sold-to Party
SoldToPartyName _SoldToParty BusinessPartnerName Extracted Customer Name
ShipToParty ShipToParty Ship-To Party (obsolete)
ShipToPartyName _ShipToParty BusinessPartnerName Extracted Customer Name
BillToParty BillToParty Inv. Recipient
BillToPartyName _BillToParty BusinessPartnerFullName Broker Name
PayerParty PayerParty Payer
PayerPartyName _PayerParty BusinessPartnerFullName Broker Name
RespEmployeeBusinessPartnerId RespEmployeeBusinessPartnerId
ResponsibleEmployeeName _RespEmployee BusinessPartnerName Extracted Customer Name
ContactPersonBusinessPartnerId ContactPersonBusinessPartnerId
ContactPersonName _ContactPerson BusinessPartnerName Extracted Customer Name
SalesOrganization SalesOrganization Sales Organization
SalesOrganizationNamelocalized
DistributionChannel DistributionChannel RefDistCh-Cust/Mat.
DistributionChannelNamelocalized
Division Division Internal Division ID
DivisionNamelocalized
SalesOffice SalesOffice Sales Office
SalesOfficeNamelocalized
SalesGroup SalesGroup Sales Group
SalesGroupNamelocalized
SalesOrganizationOrgUnitID SalesOrganizationOrgUnitID
SalesOfficeOrgUnitID SalesOfficeOrgUnitID
SalesGroupOrgUnitID SalesGroupOrgUnitID
ServiceOrganization ServiceOrganization
PurchaseOrderByCustomer PurchaseOrderByCustomer Purchase Order Number
CreatedByUser CreatedByUser User Name
CreationDateTime CreationDateTime Timestamp
LastChangedByUser LastChangedByUser User Name
LastChangeDateTime LastChangeDateTime Timestamp
SubscrpnMassProcgElmntSts _SbsMssProcgElmContrDocChg SubscrpnMassProcgElmntSts Status
SubscrpnMassProcgElmntStsTxtlocalized
SubscrpnMassProcgID _SbsMssProcgElmContrDocChg SubscrpnMassProcgID Mass Processing ID
virtualProductproductnumber
virtualProductNameproductdescription
int1
_Item _Item
_SrvcDocGTSLglControlStatus _SrvcDocGTSLglControlStatus
_SrvcDocGTSScreeningStatus _SrvcDocGTSScreeningStatus
_SrvcDocGTSEmbargoStatus _SrvcDocGTSEmbargoStatus

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_SbsMssProcgElmContrDoc.
-- 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_SbsMssProcgElmContrDoc AS
SELECT
  SubscriptionContract,
  SubscriptionContractType,
  SubscrpnContractDescription,
  SubscriptionContractUUID,
  ServiceObjectType,
  Language,
  SubscriptionContractPostingDte,
  SubscriptionContractStatus,
  SubscrpnContractIsCompleted,
  SubscriptionContractHasError,
  SbsConGTSEmbargoStatus AS SbsConItmGTSEmbargoStatus,
  SbsConGTSScreeningStatus AS SbsConItmGTSScreeningStatus,
  SbsConGTSLglControlStatus AS SbsConItmGTSLglControlStatus,
  ServiceDocumentType,
  SoldToParty,
  _SoldToParty.BusinessPartnerName AS SoldToPartyName,
  ShipToParty,
  _ShipToParty.BusinessPartnerName AS ShipToPartyName,
  BillToParty,
  _BillToParty.BusinessPartnerFullName AS BillToPartyName,
  PayerParty,
  _PayerParty.BusinessPartnerFullName AS PayerPartyName,
  RespEmployeeBusinessPartnerId,
  _RespEmployee.BusinessPartnerName AS ResponsibleEmployeeName,
  ContactPersonBusinessPartnerId,
  _ContactPerson.BusinessPartnerName AS ContactPersonName,
  SalesOrganization,
  _SalesOrganization._Text.SalesOrganizationName : localized AS SalesOrganizationNamelocalized,
  DistributionChannel,
  _DistributionChannel._Text.DistributionChannelName : localized AS DistributionChannelNamelocalized,
  Division,
  _Division._Text.DivisionName : localized AS DivisionNamelocalized,
  SalesOffice,
  _SalesOffice._Text.SalesOfficeName : localized AS SalesOfficeNamelocalized,
  SalesGroup,
  _SalesGroup._Text.SalesGroupName : localized AS SalesGroupNamelocalized,
  SalesOrganizationOrgUnitID,
  SalesOfficeOrgUnitID,
  SalesGroupOrgUnitID,
  ServiceOrganization,
  PurchaseOrderByCustomer,
  CreatedByUser,
  CreationDateTime,
  LastChangedByUser,
  LastChangeDateTime,
  _SbsMssProcgElmContrDocChg.SubscrpnMassProcgElmntSts AS SubscrpnMassProcgElmntSts,
  _SbsMssProcgElmContrDocChg._SubscrpnMassProcgElmntSts._Text.SubscrpnMassProcgElmntStsTxt : localized AS SubscrpnMassProcgElmntStsTxtlocalized,
  _SbsMssProcgElmContrDocChg.SubscrpnMassProcgID AS SubscrpnMassProcgID,
  virtual Product : productnumber AS virtualProductproductnumber,
  virtual ProductName : productdescription AS virtualProductNameproductdescription,
  virtual SbsMssProcgElmStsCritlty : abap.int1 AS int1
FROM R_SubscriptionContractTP
LEFT OUTER JOIN C_SubscriptionContractItemTP AS _Item ON SubscriptionContract = _Item.SubscriptionContract  -- association [0..*]
;

Learn More