_SERVICEDOCUMENT

_SERVICEDOCUMENT is an SAP database table in S/4HANA. It contains 61 fields.

Fields (61)

KeyField CDS FieldsUsed in Views
_DistributionChannel _DistributionChannel 2
_Division _Division 2
_RespEmployee _RespEmployee 1
_SalesGroup _SalesGroup 1
_SalesGroupOrgUnit _SalesGroupOrgUnit 1
_SalesGroupOrgUnit_2 _SalesGroupOrgUnit_2 1
_SalesOffice _SalesOffice 1
_SalesOfficeOrgUnit _SalesOfficeOrgUnit 1
_SalesOfficeOrgUnit_2 _SalesOfficeOrgUnit_2 1
_SalesOrganization _SalesOrganization 2
_SalesOrganizationOrgUnit _SalesOrganizationOrgUnit 1
_SalesOrganizationOrgUnit_2 _SalesOrganizationOrgUnit_2 1
_ServiceDocumentIsOpen _ServiceDocumentIsOpen 2
_ServiceDocumentPriority _ServiceDocumentPriority 2
_ServiceDocumentStatus _ServiceDocumentStatus 7
_ServiceDocumentType _ServiceDocumentType 1
_SoldToParty _SoldToParty 1
_SrvcDocLifecycleStatus _SrvcDocLifecycleStatus 7
_TransactionCurrency _TransactionCurrency 2
DistributionChannel DistributionChannel 4
Division Division 4
ParentServiceDocumentItemUUID ParentServiceDocumentItemUUID 1
PostingDate PostingDate 1
Product Product 1
Region Region 2
ResponsibleEmployee ResponsibleEmployee 2
SalesGroup SalesGroup 3
SalesGroupOrgUnitID SalesGroupOrgUnitID 1
SalesOffice SalesOffice 3
SalesOfficeOrgUnitID SalesOfficeOrgUnitID 1
SalesOrganization SalesOrganization 4
SalesOrganizationOrgUnitID SalesOrganizationOrgUnitID 1
ServiceContractEndDateTime ServiceContractEndDateTime 2
ServiceContractStartDateTime ServiceContractStartDateTime 2
ServiceDocItemQuantityUnit ServiceDocItemQuantityUnit 1
ServiceDocNetAmount ServiceDocNetAmount 1
ServiceDocument SubscriptionOrder 2
ServiceDocumentCharUUID ServiceDocumentCharUUID 3
ServiceDocumentCreatedByUser ServiceDocumentCreatedByUser 1
ServiceDocumentCreationDate ServiceDocumentCreationDate 2
ServiceDocumentDescription ServiceDocumentDescription 3
ServiceDocumentIsOpen ServiceDocumentIsOpen 3
ServiceDocumentIsQuotation ServiceDocumentIsQuotation 1
ServiceDocumentIsReleased ServiceDocumentIsReleased 1
ServiceDocumentItemDescription ServiceDocumentItemDescription 1
ServiceDocumentItemQuantity ServiceDocumentItemQuantity 1
ServiceDocumentPriority ServiceDocumentPriority 2
ServiceDocumentProblemCategory ServiceDocumentProblemCategory 2
ServiceDocumentStatus BusSolnOrdStatus,ServiceDocumentStatus 8
ServiceDocumentType ServiceDocumentType 4
ServiceDocumentUUID ServiceContractUUID,ServiceDocumentUUID,ServiceOrderUUID 3
ServiceOrganization ServiceOrganization 2
ServiceRisk ServiceRisk 2
SoldToParty SoldToParty 2
SoldToPartyCountry Country 2
SrvcDocBslnCostPostgStatus SrvcDocBslnCostPostgStatus 1
SrvcDocContinuousCostStatus SrvcDocContinuousCostStatus 1
SrvcDocIsMaintServiceOrder SrvcDocIsMaintServiceOrder 1
SrvcQuotationValidityStartDate SrvcQuotationValidityStartDate 1
SubscriptionContract SubscriptionContract 1
TransactionCurrency TransactionCurrency 3

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 _SERVICEDOCUMENT (
    _DISTRIBUTIONCHANNEL,
    _DIVISION,
    _RESPEMPLOYEE,
    _SALESGROUP,
    _SALESGROUPORGUNIT,
    _SALESGROUPORGUNIT_2,
    _SALESOFFICE,
    _SALESOFFICEORGUNIT,
    _SALESOFFICEORGUNIT_2,
    _SALESORGANIZATION,
    _SALESORGANIZATIONORGUNIT,
    _SALESORGANIZATIONORGUNIT_2,
    _SERVICEDOCUMENTISOPEN,
    _SERVICEDOCUMENTPRIORITY,
    _SERVICEDOCUMENTSTATUS,
    _SERVICEDOCUMENTTYPE,
    _SOLDTOPARTY,
    _SRVCDOCLIFECYCLESTATUS,
    _TRANSACTIONCURRENCY,
    DISTRIBUTIONCHANNEL,
    DIVISION,
    PARENTSERVICEDOCUMENTITEMUUID,
    POSTINGDATE,
    PRODUCT,
    REGION,
    RESPONSIBLEEMPLOYEE,
    SALESGROUP,
    SALESGROUPORGUNITID,
    SALESOFFICE,
    SALESOFFICEORGUNITID,
    SALESORGANIZATION,
    SALESORGANIZATIONORGUNITID,
    SERVICECONTRACTENDDATETIME,
    SERVICECONTRACTSTARTDATETIME,
    SERVICEDOCITEMQUANTITYUNIT,
    SERVICEDOCNETAMOUNT,
    SERVICEDOCUMENT,
    SERVICEDOCUMENTCHARUUID,
    SERVICEDOCUMENTCREATEDBYUSER,
    SERVICEDOCUMENTCREATIONDATE,
    SERVICEDOCUMENTDESCRIPTION,
    SERVICEDOCUMENTISOPEN,
    SERVICEDOCUMENTISQUOTATION,
    SERVICEDOCUMENTISRELEASED,
    SERVICEDOCUMENTITEMDESCRIPTION,
    SERVICEDOCUMENTITEMQUANTITY,
    SERVICEDOCUMENTPRIORITY,
    SERVICEDOCUMENTPROBLEMCATEGORY,
    SERVICEDOCUMENTSTATUS,
    SERVICEDOCUMENTTYPE,
    SERVICEDOCUMENTUUID,
    SERVICEORGANIZATION,
    SERVICERISK,
    SOLDTOPARTY,
    SOLDTOPARTYCOUNTRY,
    SRVCDOCBSLNCOSTPOSTGSTATUS,
    SRVCDOCCONTINUOUSCOSTSTATUS,
    SRVCDOCISMAINTSERVICEORDER,
    SRVCQUOTATIONVALIDITYSTARTDATE,
    SUBSCRIPTIONCONTRACT,
    TRANSACTIONCURRENCY
);