_SUBSCRIPTIONCONTRACT

_SUBSCRIPTIONCONTRACT is an SAP database table in S/4HANA. It contains 15 fields.

Fields (15)

KeyField CDS FieldsUsed in Views
KEY SubscriptionContract SubscriptionContract 2
BillToParty BillToParty 2
ContactPersonBusinessPartnerId ContactPersonBusinessPartnerId 2
DistributionChannel DistributionChannel 2
Division Division 2
PayerParty PayerParty 2
RespEmployeeBusinessPartnerId RespEmployeeBusinessPartnerId 2
SalesGroup SalesGroup 2
SalesOffice SalesOffice 2
SalesOrganization SalesOrganization 2
ShipToParty ShipToParty 2
SoldToParty SoldToParty 2
SubscriptionContractPostingDte SubscriptionContractPostingDte 2
SubscriptionContractUUID SubscriptionContractUUID 1
SubscrpnContractDescription SubscrpnContractDescription 2

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 _SUBSCRIPTIONCONTRACT (
    SUBSCRIPTIONCONTRACT,
    BILLTOPARTY,
    CONTACTPERSONBUSINESSPARTNERID,
    DISTRIBUTIONCHANNEL,
    DIVISION,
    PAYERPARTY,
    RESPEMPLOYEEBUSINESSPARTNERID,
    SALESGROUP,
    SALESOFFICE,
    SALESORGANIZATION,
    SHIPTOPARTY,
    SOLDTOPARTY,
    SUBSCRIPTIONCONTRACTPOSTINGDTE,
    SUBSCRIPTIONCONTRACTUUID,
    SUBSCRPNCONTRACTDESCRIPTION,
    PRIMARY KEY (SUBSCRIPTIONCONTRACT)
);