P_SUBSCRPNCONTREXTIDHIST

CDS View
10 Fields 1 CDS Views

Subscription Contract ExternalID History

P_SUBSCRPNCONTREXTIDHIST is a CDS View in S/4HANA. Subscription Contract ExternalID History. It contains 10 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_SubscrpnContrItmHist view_entity inner COMPOSITE Subscription Contract Item History

Fields (10)

KeyField CDS FieldsUsed in Views
KEY SubscriptionContractExternalID SubscriptionContractExternalID 1
KEY SubscrpnContrItmHistSqnc SubscrpnContrItmHistSqnc 1
Product Product 1
SrvcTransChangeProcess SrvcTransChangeProcess 1
SrvcTransChangeProcessGroup SrvcTransChangeProcessGroup 1
SrvcTransChangeProcessType SrvcTransChangeProcessType 1
SubscriptionChangeOrder SubscriptionChangeOrder 1
SubscriptionChangeOrderItem SubscriptionChangeOrderItem 1
SubscrpnChgOrdItmActvtnDteTme SubscrpnChgOrdItmActvtnDteTme 1
SubscrpnChgOrdItmSts SubscrpnChgOrdItmSts 1

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Subscription Contract ExternalID History
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE P_SUBSCRPNCONTREXTIDHIST (
    SUBSCRIPTIONCONTRACTEXTERNALID,
    SUBSCRPNCONTRITMHISTSQNC,
    PRODUCT,
    SRVCTRANSCHANGEPROCESS,
    SRVCTRANSCHANGEPROCESSGROUP,
    SRVCTRANSCHANGEPROCESSTYPE,
    SUBSCRIPTIONCHANGEORDER,
    SUBSCRIPTIONCHANGEORDERITEM,
    SUBSCRPNCHGORDITMACTVTNDTETME,
    SUBSCRPNCHGORDITMSTS,
    PRIMARY KEY (SUBSCRIPTIONCONTRACTEXTERNALID, SUBSCRPNCONTRITMHISTSQNC)
);

Learn More