P_SbscrContrMainItm

DDL: P_SBSCRCONTRMAINITM Type: view_entity BASIC
37 Fields 1 Data Sources

Subscription Contract Main Item

P_SbscrContrMainItm is a Basic CDS View that provides data about "Subscription Contract Main Item" in SAP S/4HANA. It reads from 1 data source (P_SubscriptionContractItem) and exposes 37 fields with key fields SubscriptionContract, SubscriptionContractItem.

Data Sources (1)

SourceAliasJoin Type
P_SubscriptionContractItem P_SubscriptionContractItem from

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Subscription Contract Main Item view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #BASIC view
VDM.private true view

Fields (37)

KeyFieldSource TableSource FieldDescription
KEY SubscriptionContract SubscriptionContract Transaction ID
KEY SubscriptionContractItem SubscriptionContractItem Item Number in Doc.
SubscriptionContractExternalID SubscriptionContractExternalID Contract Number
SubscriptionContractItemUUID SubscriptionContractItemUUID Push ItemGU
SubscrpnContrItmCharUUID SubscrpnContrItmCharUUID Object GUID
ParentSubscrpnContractItemUUID ParentSubscrpnContractItemUUID UUID
SubscrpnContrItmStartDateTime SubscrpnContrItmStartDateTime Contract Start Date
SubscrpnContrItmEndDateTime SubscrpnContrItmEndDateTime Contract End Date
SbscrContrTimeSliceStrtDteTme SbscrContrTimeSliceStrtDteTme Start of Contract TS
SbscrContrTimeSliceEndDteTme SbscrContrTimeSliceEndDteTme End of Contract TS
SubscrpnContrActivationStatus SubscrpnContrActivationStatus Activation Status
SubscrpnContractItemIsRejected SubscrpnContractItemIsRejected Cancellation Status
Quantity Quantity Value
QuantityUnit QuantityUnit Unit of measure
SrvcTransChangeProcess SrvcTransChangeProcess Process of Maint. FW
SrvcTransChangeProcessType SrvcTransChangeProcessType Process Type
BusSolutionQtnItemIsPhased BusSolutionQtnItemIsPhased Phase Indicator
BusSolnQtnItmPhasedPrdcssrItem BusSolnQtnItmPhasedPrdcssrItem Item Number in Doc.
Product Product Product Sold
SbscrContrItmIsFirst SbscrContrItmIsFirst
SubscrpnContrTimeSliceStatus SubscrpnContrTimeSliceStatus Time Slice Status
SubscrpnOrdProdSelType SubscrpnOrdProdSelType Prod.Selection Type
SalesOrganizationOrgUnitID SalesOrganizationOrgUnitID Sales Organization
SalesOfficeOrgUnitID SalesOfficeOrgUnitID Sales Office
SalesGroupOrgUnitID SalesGroupOrgUnitID Sales Group
DistributionChannel DistributionChannel RefDistCh-Cust/Mat.
Division Division Internal Division ID
ServiceOrganization ServiceOrganization Service Organization
SalesOrganization SalesOrganization Sales Organization
SalesOffice SalesOffice Sales Office
SalesGroup SalesGroup Sales Group
RespEmployeeBusinessPartnerId RespEmployeeBusinessPartnerId Employee Responsible
ServiceObjectType ServiceObjectType Object Type
ServiceDocumentItemObjectType ServiceDocumentItemObjectType Object Type
ServiceDocumentType ServiceDocumentType Transaction Type
SubscrpnContrItmIsWithdrawn SubscrpnContrItmIsWithdrawn Withdrawal Status
SubscrpnContrItmIsCancelled SubscrpnContrItmIsCancelled

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 P_SbscrContrMainItm.
-- 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 P_SbscrContrMainItm AS
SELECT
  SubscriptionContract,
  SubscriptionContractItem,
  SubscriptionContractExternalID,
  SubscriptionContractItemUUID,
  SubscrpnContrItmCharUUID,
  ParentSubscrpnContractItemUUID,
  SubscrpnContrItmStartDateTime,
  SubscrpnContrItmEndDateTime,
  SbscrContrTimeSliceStrtDteTme,
  SbscrContrTimeSliceEndDteTme,
  SubscrpnContrActivationStatus,
  SubscrpnContractItemIsRejected,
  Quantity,
  QuantityUnit,
  SrvcTransChangeProcess,
  SrvcTransChangeProcessType,
  BusSolutionQtnItemIsPhased,
  BusSolnQtnItmPhasedPrdcssrItem,
  Product,
  SbscrContrItmIsFirst,
  SubscrpnContrTimeSliceStatus,
  SubscrpnOrdProdSelType,
  SalesOrganizationOrgUnitID,
  SalesOfficeOrgUnitID,
  SalesGroupOrgUnitID,
  DistributionChannel,
  Division,
  ServiceOrganization,
  SalesOrganization,
  SalesOffice,
  SalesGroup,
  RespEmployeeBusinessPartnerId,
  ServiceObjectType,
  ServiceDocumentItemObjectType,
  ServiceDocumentType,
  SubscrpnContrItmIsWithdrawn,
  SubscrpnContrItmIsCancelled
FROM P_SubscriptionContractItem
;

Learn More