I_SUBSCRPNPRODSPEC

CDS View
18 Fields 2 CDS Views

Subscription Product Specification

I_SUBSCRPNPRODSPEC is a CDS View in S/4HANA. Subscription Product Specification. It contains 18 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
I_SubscrpnProdSpecTP view from TRANSACTIONAL Transactional view for Subscription Product Specification
I_SubscrpnProdSpecVH view from COMPOSITE Value help view for Subscription Product Specification

Fields (18)

KeyField CDS FieldsUsed in Views
KEY Product Product 2
KEY SubscrpnProdSpecUUID SubscrpnProdSpecUUID 2
AuthorizationGroup AuthorizationGroup 2
BaseUnit BaseUnit 1
CABillgCycle CABillgCycle 1
ContractAutoRenewalType ContractAutoRenewalType 1
CreatedByUser CreatedByUser 1
CreationDateTime CreationDateTime 1
LastChangeDateTime LastChangeDateTime 1
LastChangedByUser LastChangedByUser 1
ProductGroup ProductGroup 2
ProductIsConfigurable ProductIsConfigurable 1
ProductType ProductType 2
ProductUUID ProductUUID 1
SubscriptionProductPurpose SubscriptionProductPurpose 2
SubscrpnProdBillgCycDetn SubscrpnProdBillgCycDetn 1
SubscrpnProdTechRsceIsActive SubscrpnProdTechRsceIsActive 1
SubscrpnProdTechRsceSchema SubscrpnProdTechRsceSchema 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 Product Specification
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_SUBSCRPNPRODSPEC (
    PRODUCT,
    SUBSCRPNPRODSPECUUID,
    AUTHORIZATIONGROUP,
    BASEUNIT,
    CABILLGCYCLE,
    CONTRACTAUTORENEWALTYPE,
    CREATEDBYUSER,
    CREATIONDATETIME,
    LASTCHANGEDATETIME,
    LASTCHANGEDBYUSER,
    PRODUCTGROUP,
    PRODUCTISCONFIGURABLE,
    PRODUCTTYPE,
    PRODUCTUUID,
    SUBSCRIPTIONPRODUCTPURPOSE,
    SUBSCRPNPRODBILLGCYCDETN,
    SUBSCRPNPRODTECHRSCEISACTIVE,
    SUBSCRPNPRODTECHRSCESCHEMA,
    PRIMARY KEY (PRODUCT, SUBSCRPNPRODSPECUUID)
);

Learn More