_SUBSCRIPTIONCONTR

28 Fields

_SUBSCRIPTIONCONTR is an SAP database table in S/4HANA. It contains 28 fields.

Fields (28)

KeyField CDS FieldsUsed in Views
BillToParty BillToParty 1
CreatedByUser CreatedByUser 1
CreationDateTime CreationDateTime 1
DistributionChannel DistributionChannel 1
Division Division 1
OriginallyRequestedProduct Product 1
PayerParty PayerParty 1
PostingDate PostingDate 1
PurchaseOrderByCustomer PurchaseOrderByCustomer 1
SalesGroupOrgUnitID SalesGroupOrgUnitID 1
SalesOfficeOrgUnitID SalesOfficeOrgUnitID 1
SalesOrganizationOrgUnitID SalesOrganizationOrgUnitID 1
ServiceContrItemEndDateTime ServiceContrItemEndDateTime 1
ServiceContrItemStartDateTime ServiceContrItemStartDateTime 1
ServiceDocItemCreatedByUser CreatedByUser 1
ServiceDocItemCreationDateTime CreationDateTime 1
ServiceDocument ServiceDocument 1
ServiceDocumentItem ServiceDocumentItem 1
ServiceDocumentItemDescription ServiceDocumentItemDescription 1
SharingContractID SharingContractID 1
ShipToParty ShipToParty 1
SoldToParty SoldToParty 2
SubscriptionContract SubscriptionContract 2
SubscrpnContractDescription SubscrpnContractDescription 1
SubscrpnContractIsCompleted SubscrpnContractIsCompleted 1
SubscrpnContrActivationStatus SubscrpnContrActivationStatus 1
SubscrpnContrTimeSliceStatus SubscrpnContrTimeSliceStatus 1
SubscrpnOrdProdSelType SubscrpnOrdProdSelType 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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE _SUBSCRIPTIONCONTR (
    BILLTOPARTY,
    CREATEDBYUSER,
    CREATIONDATETIME,
    DISTRIBUTIONCHANNEL,
    DIVISION,
    ORIGINALLYREQUESTEDPRODUCT,
    PAYERPARTY,
    POSTINGDATE,
    PURCHASEORDERBYCUSTOMER,
    SALESGROUPORGUNITID,
    SALESOFFICEORGUNITID,
    SALESORGANIZATIONORGUNITID,
    SERVICECONTRITEMENDDATETIME,
    SERVICECONTRITEMSTARTDATETIME,
    SERVICEDOCITEMCREATEDBYUSER,
    SERVICEDOCITEMCREATIONDATETIME,
    SERVICEDOCUMENT,
    SERVICEDOCUMENTITEM,
    SERVICEDOCUMENTITEMDESCRIPTION,
    SHARINGCONTRACTID,
    SHIPTOPARTY,
    SOLDTOPARTY,
    SUBSCRIPTIONCONTRACT,
    SUBSCRPNCONTRACTDESCRIPTION,
    SUBSCRPNCONTRACTISCOMPLETED,
    SUBSCRPNCONTRACTIVATIONSTATUS,
    SUBSCRPNCONTRTIMESLICESTATUS,
    SUBSCRPNORDPRODSELTYPE
);

Learn More