P_SbscrContrItmState

DDL: P_SBSCRCONTRITMSTATE Type: view_entity COMPOSITE
43 Fields 2 Data Sources

State of Subscription Contract Item

P_SbscrContrItmState is a Composite CDS View that provides data about "State of Subscription Contract Item" in SAP S/4HANA. It reads from 2 data sources (P_SubscriptionContractItem, P_SubscriptionContractItem) and exposes 43 fields with key fields SbscrContrStateID, SubscriptionContract, SubscriptionContractItem.

Data Sources (2)

SourceAliasJoin Type
P_SubscriptionContractItem SubscriptionContractItem from
P_SubscriptionContractItem SubscriptionContractState inner

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label State of Subscription Contract Item view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view
VDM.private true view

Fields (43)

KeyFieldSource TableSource FieldDescription
KEY SbscrContrStateID P_SubscriptionContractItem SubscriptionContractItem Item Number in Doc.
KEY SubscriptionContract P_SubscriptionContractItem SubscriptionContract Transaction ID
KEY SubscriptionContractItem P_SubscriptionContractItem SubscriptionContractItem Item Number in Doc.
SubscriptionContractExternalID P_SubscriptionContractItem SubscriptionContractExternalID Contract Number
ParentSubscrpnContractItemUUID P_SubscriptionContractItem ParentSubscrpnContractItemUUID UUID
SbscrContrTimeSliceStrtDteTme P_SubscriptionContractItem SbscrContrTimeSliceStrtDteTme Start of Contract TS
SbscrContrTimeSliceEndDteTme P_SubscriptionContractItem SbscrContrTimeSliceEndDteTme End of Contract TS
SubscrpnContractItemIsRejected P_SubscriptionContractItem SubscrpnContractItemIsRejected Cancellation Status
SubscrpnContrItmIsWithdrawn P_SubscriptionContractItem SubscrpnContrItmIsWithdrawn Withdrawal Status
SubscrpnContrItmIsCancelled P_SubscriptionContractItem SubscrpnContrItmIsCancelled
SubscrpnContrItmHasError P_SubscriptionContractItem SubscrpnContrItmHasError Error Status
SubscrpnContrActivationStatus P_SubscriptionContractItem SubscrpnContrActivationStatus Activation Status
Quantity P_SubscriptionContractItem Quantity Value
QuantityUnit P_SubscriptionContractItem QuantityUnit Unit of measure
TransactionCurrency P_SubscriptionContractItem TransactionCurrency Transaction Currency
SubscrpnContrItmNetAmount P_SubscriptionContractItem SubscrpnContrItmNetAmount Net Value
SubscrpnContrItmGrossAmount P_SubscriptionContractItem SubscrpnContrItmGrossAmount Gross Value
SubscrpnContrItmTaxAmount P_SubscriptionContractItem SubscrpnContrItmTaxAmount Tax amount
SrvcTransChangeProcess P_SubscriptionContractItem SrvcTransChangeProcess Process of Maint. FW
SrvcTransChangeProcessType P_SubscriptionContractItem SrvcTransChangeProcessType Process Type
BusSolutionQtnItemIsPhased P_SubscriptionContractItem BusSolutionQtnItemIsPhased Phase Indicator
SubscrpnContrTimeSliceStatus P_SubscriptionContractItem SubscrpnContrTimeSliceStatus Time Slice Status
Product P_SubscriptionContractItem Product Product Sold
SubscrpnOrdProdSelType P_SubscriptionContractItem SubscrpnOrdProdSelType Prod.Selection Type
BusSolnQtnItmPhasedPrdcssrItem P_SubscriptionContractItem BusSolnQtnItmPhasedPrdcssrItem Item Number in Doc.
SbscrContrItmIsFirst P_SubscriptionContractItem SbscrContrItmIsFirst
SbscrContrCurUTCDteTme
SalesOrganizationOrgUnitID P_SubscriptionContractItem SalesOrganizationOrgUnitID Sales Organization
SalesOfficeOrgUnitID P_SubscriptionContractItem SalesOfficeOrgUnitID Sales Office
SalesGroupOrgUnitID P_SubscriptionContractItem SalesGroupOrgUnitID Sales Group
ServiceOrganization P_SubscriptionContractItem ServiceOrganization Service Organization
SalesOrganization P_SubscriptionContractItem SalesOrganization Sales Organization
SalesOffice P_SubscriptionContractItem SalesOffice Sales Office
SalesGroup P_SubscriptionContractItem SalesGroup Sales Group
DistributionChannel P_SubscriptionContractItem DistributionChannel RefDistCh-Cust/Mat.
Division P_SubscriptionContractItem Division Internal Division ID
RespEmployeeBusinessPartnerId P_SubscriptionContractItem RespEmployeeBusinessPartnerId Employee Responsible
ServiceObjectType P_SubscriptionContractItem ServiceObjectType Object Type
ServiceDocumentType P_SubscriptionContractItem ServiceDocumentType Transaction Type
SbscrContrStateIsRejected P_SubscriptionContractItem SubscrpnContractItemIsRejected Cancellation Status
SbscrContrStateIsWithdrawn P_SubscriptionContractItem SubscrpnContrItmIsWithdrawn Withdrawal Status
SbscrContrStateIsCancelled P_SubscriptionContractItem SubscrpnContrItmIsCancelled
SbscrContrStateHasError P_SubscriptionContractItem SubscrpnContrItmHasError Error Status

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_SbscrContrItmState.
-- 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_SbscrContrItmState AS
SELECT
  SubscriptionContractState.SubscriptionContractItem AS SbscrContrStateID,
  SubscriptionContractItem.SubscriptionContract AS SubscriptionContract,
  SubscriptionContractItem.SubscriptionContractItem AS SubscriptionContractItem,
  SubscriptionContractState.SubscriptionContractExternalID AS SubscriptionContractExternalID,
  SubscriptionContractState.ParentSubscrpnContractItemUUID AS ParentSubscrpnContractItemUUID,
  SubscriptionContractState.SbscrContrTimeSliceStrtDteTme AS SbscrContrTimeSliceStrtDteTme,
  SubscriptionContractState.SbscrContrTimeSliceEndDteTme AS SbscrContrTimeSliceEndDteTme,
  SubscriptionContractItem.SubscrpnContractItemIsRejected AS SubscrpnContractItemIsRejected,
  SubscriptionContractItem.SubscrpnContrItmIsWithdrawn AS SubscrpnContrItmIsWithdrawn,
  SubscriptionContractItem.SubscrpnContrItmIsCancelled AS SubscrpnContrItmIsCancelled,
  SubscriptionContractItem.SubscrpnContrItmHasError AS SubscrpnContrItmHasError,
  SubscriptionContractState.SubscrpnContrActivationStatus AS SubscrpnContrActivationStatus,
  SubscriptionContractState.Quantity AS Quantity,
  SubscriptionContractState.QuantityUnit AS QuantityUnit,
  SubscriptionContractState.TransactionCurrency AS TransactionCurrency,
  SubscriptionContractState.SubscrpnContrItmNetAmount AS SubscrpnContrItmNetAmount,
  SubscriptionContractState.SubscrpnContrItmGrossAmount AS SubscrpnContrItmGrossAmount,
  SubscriptionContractState.SubscrpnContrItmTaxAmount AS SubscrpnContrItmTaxAmount,
  SubscriptionContractState.SrvcTransChangeProcess AS SrvcTransChangeProcess,
  SubscriptionContractState.SrvcTransChangeProcessType AS SrvcTransChangeProcessType,
  SubscriptionContractState.BusSolutionQtnItemIsPhased AS BusSolutionQtnItemIsPhased,
  SubscriptionContractState.SubscrpnContrTimeSliceStatus AS SubscrpnContrTimeSliceStatus,
  SubscriptionContractState.Product AS Product,
  SubscriptionContractState.SubscrpnOrdProdSelType AS SubscrpnOrdProdSelType,
  SubscriptionContractState.BusSolnQtnItmPhasedPrdcssrItem AS BusSolnQtnItmPhasedPrdcssrItem,
  SubscriptionContractState.SbscrContrItmIsFirst AS SbscrContrItmIsFirst,
  tstmp_current_utctimestamp() AS SbscrContrCurUTCDteTme,
  SubscriptionContractState.SalesOrganizationOrgUnitID AS SalesOrganizationOrgUnitID,
  SubscriptionContractState.SalesOfficeOrgUnitID AS SalesOfficeOrgUnitID,
  SubscriptionContractState.SalesGroupOrgUnitID AS SalesGroupOrgUnitID,
  SubscriptionContractState.ServiceOrganization AS ServiceOrganization,
  SubscriptionContractState.SalesOrganization AS SalesOrganization,
  SubscriptionContractState.SalesOffice AS SalesOffice,
  SubscriptionContractState.SalesGroup AS SalesGroup,
  SubscriptionContractState.DistributionChannel AS DistributionChannel,
  SubscriptionContractState.Division AS Division,
  SubscriptionContractState.RespEmployeeBusinessPartnerId AS RespEmployeeBusinessPartnerId,
  SubscriptionContractState.ServiceObjectType AS ServiceObjectType,
  SubscriptionContractState.ServiceDocumentType AS ServiceDocumentType,
  SubscriptionContractState.SubscrpnContractItemIsRejected AS SbscrContrStateIsRejected,
  SubscriptionContractState.SubscrpnContrItmIsWithdrawn AS SbscrContrStateIsWithdrawn,
  SubscriptionContractState.SubscrpnContrItmIsCancelled AS SbscrContrStateIsCancelled,
  SubscriptionContractState.SubscrpnContrItmHasError AS SbscrContrStateHasError
FROM P_SubscriptionContractItem AS SubscriptionContractItem
INNER JOIN P_SubscriptionContractItem AS SubscriptionContractState ON /* join condition not captured in parsed metadata */
;

Learn More