_SUBSCRIPTIONCONTRACTITEM

_SUBSCRIPTIONCONTRACTITEM is an SAP database table in S/4HANA. It contains 45 fields.

Fields (45)

KeyField CDS FieldsUsed in Views
BillToParty BillToParty 2
CABillgCycle CABillgCycle 2
ContactPersonBusinessPartnerId ContactPersonBusinessPartnerId 2
ContractAccount ContractAccount 2
CrsCatalogMappingVersionNumber CrsCatalogMappingVersionNumber 2
DistributionChannel DistributionChannel 1
Division Division 1
OriginallyRequestedProduct OriginallyRequestedProduct,Product 3
PayerParty PayerParty 2
Product Product 2
Quantity Quantity 2
QuantityUnit QuantityUnit 2
RespEmployeeBusinessPartnerId RespEmployeeBusinessPartnerId 2
ResponsibleEmployee ResponsibleEmployee 1
SalesGroup SalesGroup 1
SalesGroupOrgUnitID SalesGroupOrgUnitID 1
SalesOffice SalesOffice 1
SalesOfficeOrgUnitID SalesOfficeOrgUnitID 1
SalesOrganization SalesOrganization 1
SalesOrganizationOrgUnitID SalesOrganizationOrgUnitID 1
ServiceContrItemEndDateTime SubscrpnContrItmEndDateTime 1
ServiceContrItemStartDateTime SubscrpnContrItmStartDateTime 1
ServiceDocItemQuantityUnit ServiceDocItemQuantityUnit 2
ServiceDocumentDescription ServiceDocumentDescription 1
ServiceDocumentItemCharUUID ServiceDocumentItemUUID 2
ServiceDocumentItemDescription ProductName,ServiceContractItemDescription 3
ServiceDocumentItemNetAmount ItemNetAmount,ServiceDocumentItemNetAmount 3
ServiceDocumentItemQuantity ServiceDocumentItemQuantity 1
ServiceDocumentType ServiceDocumentType 1
ServiceObjectType ServiceObjectType 1
ServiceOrganization ServiceOrganization 1
ShipToParty ShipToParty 2
SoldToParty SoldToParty 3
SubscriptionContract SubscriptionContractExternalID 1
SubscriptionContractUUID SubscriptionContractUUID 1
SubscriptionContrItmDesc SubscriptionContrItmDesc 2
SubscrpnContractItemIsActive SubscrpnContractItemIsActive 2
SubscrpnContrAutoRnwlIsActv SubscrpnContrAutoRnwlIsActv 2
SubscrpnContrItmEndDateTime SubscrpnContrItmEndDateTime 2
SubscrpnContrItmHasConfign SubscrpnContrItmHasConfign 2
SubscrpnContrItmIsCancelled SubscrpnContrItmIsCancelled 2
SubscrpnContrItmIsWithdrawn SubscrpnContrItmIsWithdrawn 2
SubscrpnContrItmStartDateTime SubscrpnContrItmStartDateTime 2
TransactionCurrency TransactionCurrency 4
WBSElementExternalID WBSElementExternalID 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 _SUBSCRIPTIONCONTRACTITEM (
    BILLTOPARTY,
    CABILLGCYCLE,
    CONTACTPERSONBUSINESSPARTNERID,
    CONTRACTACCOUNT,
    CRSCATALOGMAPPINGVERSIONNUMBER,
    DISTRIBUTIONCHANNEL,
    DIVISION,
    ORIGINALLYREQUESTEDPRODUCT,
    PAYERPARTY,
    PRODUCT,
    QUANTITY,
    QUANTITYUNIT,
    RESPEMPLOYEEBUSINESSPARTNERID,
    RESPONSIBLEEMPLOYEE,
    SALESGROUP,
    SALESGROUPORGUNITID,
    SALESOFFICE,
    SALESOFFICEORGUNITID,
    SALESORGANIZATION,
    SALESORGANIZATIONORGUNITID,
    SERVICECONTRITEMENDDATETIME,
    SERVICECONTRITEMSTARTDATETIME,
    SERVICEDOCITEMQUANTITYUNIT,
    SERVICEDOCUMENTDESCRIPTION,
    SERVICEDOCUMENTITEMCHARUUID,
    SERVICEDOCUMENTITEMDESCRIPTION,
    SERVICEDOCUMENTITEMNETAMOUNT,
    SERVICEDOCUMENTITEMQUANTITY,
    SERVICEDOCUMENTTYPE,
    SERVICEOBJECTTYPE,
    SERVICEORGANIZATION,
    SHIPTOPARTY,
    SOLDTOPARTY,
    SUBSCRIPTIONCONTRACT,
    SUBSCRIPTIONCONTRACTUUID,
    SUBSCRIPTIONCONTRITMDESC,
    SUBSCRPNCONTRACTITEMISACTIVE,
    SUBSCRPNCONTRAUTORNWLISACTV,
    SUBSCRPNCONTRITMENDDATETIME,
    SUBSCRPNCONTRITMHASCONFIGN,
    SUBSCRPNCONTRITMISCANCELLED,
    SUBSCRPNCONTRITMISWITHDRAWN,
    SUBSCRPNCONTRITMSTARTDATETIME,
    TRANSACTIONCURRENCY,
    WBSELEMENTEXTERNALID
);