P_SubscrpnContrItmHist

DDL: P_SUBSCRPNCONTRITMHIST Type: view_entity COMPOSITE
25 Fields 2 Data Sources

Subscription Contract Item History

P_SubscrpnContrItmHist is a Composite CDS View that provides data about "Subscription Contract Item History" in SAP S/4HANA. It reads from 2 data sources (P_SubscriptionContractItem, P_SubscrpnContrExtIDHist) and exposes 25 fields with key fields SubscrpnContrItmHistSqnc, SubscriptionContractExternalID, SubscriptionContract, SubscriptionContractItem.

Data Sources (2)

SourceAliasJoin Type
P_SubscriptionContractItem SubscriptionContractItem from
P_SubscrpnContrExtIDHist SubscrpnContrExtIDHist inner

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Subscription Contract Item History 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 (25)

KeyFieldSource TableSource FieldDescription
KEY SubscrpnContrItmHistSqnc P_SubscrpnContrExtIDHist SubscrpnContrItmHistSqnc Version
KEY SubscriptionContractExternalID P_SubscrpnContrExtIDHist SubscriptionContractExternalID Contract Number
KEY SubscriptionContract P_SubscriptionContractItem SubscriptionContract Transaction ID
KEY SubscriptionContractItem P_SubscriptionContractItem SubscriptionContractItem Item Number in Doc.
SubscriptionChangeOrder P_SubscrpnContrExtIDHist SubscriptionChangeOrder Transaction ID
SubscriptionChangeOrderItem P_SubscrpnContrExtIDHist SubscriptionChangeOrderItem Item Number in Doc.
SubscrpnChgOrdItmSts P_SubscrpnContrExtIDHist SubscrpnChgOrdItmSts Status
Product P_SubscrpnContrExtIDHist Product Product Sold
SrvcTransChangeProcess P_SubscrpnContrExtIDHist SrvcTransChangeProcess Process of Maint. FW
SrvcTransChangeProcessType P_SubscrpnContrExtIDHist SrvcTransChangeProcessType Process Type
SubscrpnChgOrdItmActvtnDteTme P_SubscrpnContrExtIDHist SubscrpnChgOrdItmActvtnDteTme
SrvcTransChangeProcessGroup P_SubscrpnContrExtIDHist SrvcTransChangeProcessGroup BTMF Process Group
SubscrpnContractItemIsRejected P_SubscriptionContractItem SubscrpnContractItemIsRejected Cancellation Status
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

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_SubscrpnContrItmHist.
-- 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_SubscrpnContrItmHist AS
SELECT
  SubscrpnContrExtIDHist.SubscrpnContrItmHistSqnc AS SubscrpnContrItmHistSqnc,
  SubscrpnContrExtIDHist.SubscriptionContractExternalID AS SubscriptionContractExternalID,
  SubscriptionContractItem.SubscriptionContract AS SubscriptionContract,
  SubscriptionContractItem.SubscriptionContractItem AS SubscriptionContractItem,
  SubscrpnContrExtIDHist.SubscriptionChangeOrder AS SubscriptionChangeOrder,
  SubscrpnContrExtIDHist.SubscriptionChangeOrderItem AS SubscriptionChangeOrderItem,
  SubscrpnContrExtIDHist.SubscrpnChgOrdItmSts AS SubscrpnChgOrdItmSts,
  SubscrpnContrExtIDHist.Product AS Product,
  SubscrpnContrExtIDHist.SrvcTransChangeProcess AS SrvcTransChangeProcess,
  SubscrpnContrExtIDHist.SrvcTransChangeProcessType AS SrvcTransChangeProcessType,
  SubscrpnContrExtIDHist.SubscrpnChgOrdItmActvtnDteTme AS SubscrpnChgOrdItmActvtnDteTme,
  SubscrpnContrExtIDHist.SrvcTransChangeProcessGroup AS SrvcTransChangeProcessGroup,
  SubscriptionContractItem.SubscrpnContractItemIsRejected AS SubscrpnContractItemIsRejected,
  SubscriptionContractItem.SalesOrganizationOrgUnitID AS SalesOrganizationOrgUnitID,
  SubscriptionContractItem.SalesOfficeOrgUnitID AS SalesOfficeOrgUnitID,
  SubscriptionContractItem.SalesGroupOrgUnitID AS SalesGroupOrgUnitID,
  SubscriptionContractItem.ServiceOrganization AS ServiceOrganization,
  SubscriptionContractItem.SalesOrganization AS SalesOrganization,
  SubscriptionContractItem.SalesOffice AS SalesOffice,
  SubscriptionContractItem.SalesGroup AS SalesGroup,
  SubscriptionContractItem.DistributionChannel AS DistributionChannel,
  SubscriptionContractItem.Division AS Division,
  SubscriptionContractItem.RespEmployeeBusinessPartnerId AS RespEmployeeBusinessPartnerId,
  SubscriptionContractItem.ServiceObjectType AS ServiceObjectType,
  SubscriptionContractItem.ServiceDocumentType AS ServiceDocumentType
FROM P_SubscriptionContractItem AS SubscriptionContractItem
INNER JOIN P_SubscrpnContrExtIDHist AS SubscrpnContrExtIDHist ON /* join condition not captured in parsed metadata */
;

Learn More