I_SERVICEDOCUMENT

CDS View

Service Transaction

I_SERVICEDOCUMENT is a CDS View in S/4HANA. Service Transaction. It contains 75 fields. 80 CDS views read from this table.

CDS Views using this table (80)

ViewTypeJoinVDMDescription
A_BusSolnOrdUserStatus view inner COMPOSITE Header User Status
A_ServiceConfUserStatus view inner COMPOSITE Service Confirmation User Status
A_ServiceOrdUserStatus view inner COMPOSITE Service Order User Status
A_SrvcConfAppointment view inner COMPOSITE Service Confirmation Appointment
A_SrvcConfDuration view inner COMPOSITE Service Confirmation Duration
A_SrvcOrdAppointment view inner COMPOSITE Service Order Appointment
A_SrvcOrdDuration view inner COMPOSITE Service Order Duration
A_SrvcOrdPartner view inner COMPOSITE Service Order Partner
A_SrvcOrdPartnerAddress view_entity inner COMPOSITE Partner Address of Service Order
A_SrvcOrdTmplAppointment view inner COMPOSITE Service Order Template Appointment
A_SrvcOrdTmplDuration view inner COMPOSITE Service Order Template Duration
A_SrvcOrdTmplPartner view inner COMPOSITE Service Order Template Partner
A_SrvcOrdTmplPartnerAddress view_entity inner COMPOSITE Partner Address of Service Order Template
A_SrvcOrdTmplUserStatus view inner COMPOSITE Service Order Template User Status
C_BSQPMBusSolnQtan view_entity from CONSUMPTION BSQPM Solution Quotation Attribute
C_BusSolnOrdOutputParam view from CONSUMPTION Solution Order Output Parameter Determination
C_BusSolnQtanVH view_entity from CONSUMPTION Business Solution Quotation
C_DspDocFlwServiceContract view_entity from CONSUMPTION Service Contract Attributes
C_SrvcContrOutputParam view from CONSUMPTION Service Contract Output Parameter Determination
C_SrvcOrderOutputParam view from CONSUMPTION Service Order Output Parameter Determination
C_SrvcQtanOutputParam view from CONSUMPTION Service Quotation Output Parameter Determination
C_SrvcQtanProcFlowInformation view from CONSUMPTION Srvc Quotation Info for Transaction History
CRMS4_IU_I_USO view_entity from Utilities Service Order
CRMS4_IU_I_USR view_entity from Utilities Service Request
I_ARProcessFlowDocumentVH view union_all COMPOSITE Document Number
I_BusinessSolutionOrderStdVH view from COMPOSITE Solution Order Value Help
I_ProjectServiceContract view_entity from BASIC Project Service Contract
I_ProjectServiceOrder view_entity from BASIC Project Service Order
I_RU_Contract view union COMPOSITE Contracts in Russian Financials
I_ServiceContractStdVH view from COMPOSITE Service Contract Value Help
I_ServiceDocumentEnhcd view from COMPOSITE Service Transaction Enhanced
I_ServiceDocumentFixedPrice view from BASIC Service Document Fixed Price
I_ServiceOrderConfStdVH view from COMPOSITE Service Confirmation Value Help
I_ServiceOrderStdVH view from BASIC Service Order Value Help
I_ServiceOrderTemplateStdVH view from COMPOSITE Service Order Template Value Help
I_SrvcConfRelBillgListRpt view left_outer COMPOSITE View for Service Conf. Billing Items
I_SrvcDocByDocumentType view from BASIC Service Transaction by Transaction Type
I_SrvcOrdTransfStatusSituation view from COMPOSITE Data Transfer Situations
I_SrvcSettlmtHierarchyDocument view_entity inner COMPOSITE Settlement docs in Servc Hier
I_SubscriptionContractStdVH view from COMPOSITE Subscription Contract Value Help
I_SubscriptionOrderPartner view_entity inner COMPOSITE Subscription Order Partner
I_SubscriptionOrderUserStatus view_entity inner COMPOSITE Subscription Order UStatus
P_ARProcessFlowServiceContract view_entity from COMPOSITE Service Contract Attributes
P_BSQPMSolnQtanProcFlw view_entity from COMPOSITE
P_ServiceOrderFulfillment view from COMPOSITE
P_SrvcTransWthSituation view inner COMPOSITE
R_BusSolnOrdLongTextTP view_entity inner TRANSACTIONAL Business Solution Order Long Text - TP
R_BusSolnOrdUserStatusTP view_entity inner TRANSACTIONAL Business Solution Order User Status - TP
R_SrvcConfAppointmentTP view_entity inner TRANSACTIONAL Service Confirmation Appointment - TP
R_SrvcConfDurationTP view_entity inner TRANSACTIONAL Service Confirmation Duration - TP
R_SrvcConfItmTransHistory view_entity inner COMPOSITE Transaction History in SRVC Item
R_SrvcConfLongTextTP view_entity inner TRANSACTIONAL Long Text for Service Confirmation
R_SrvcConfTransHistory view_entity inner COMPOSITE Transaction History in SRVC Header
R_SrvcConfUserStatusTP view_entity inner TRANSACTIONAL Service Confirmation User Status - TP
R_SrvcContrAppointmentTP view_entity inner TRANSACTIONAL Service Contract Appointment - TP
R_SrvcContrDurationTP view_entity inner TRANSACTIONAL Service Contract Duration - TP
R_SrvcContrLongTextTP view_entity inner TRANSACTIONAL Service Contract Long Text - TP
R_SrvcContrTmplDurationTP view_entity inner TRANSACTIONAL Service Contract Template Duration - TP
R_SrvcContrTmplLongTextTP view_entity inner TRANSACTIONAL Service Contract Template Text - TP
R_SrvcContrUserStatusTP view_entity inner TRANSACTIONAL Service Contract User Status - TP
R_SrvcOrdAppointmentTP view_entity inner TRANSACTIONAL Service Order Appointment - TP
R_SrvcOrdDurationTP view_entity inner TRANSACTIONAL Service Order Duration - TP
R_SrvcOrdItmTransHistory view_entity inner COMPOSITE Transaction History in SRVO Item
R_SrvcOrdLongTextTP view_entity inner TRANSACTIONAL Long Text for Service Order
R_SrvcOrdPartnerTP view_entity inner TRANSACTIONAL Service Order Partner - TP
R_SrvcOrdQualificationTP view_entity inner TRANSACTIONAL Service Order Qualification - TP
R_SrvcOrdTmplAppointmentTP view_entity inner TRANSACTIONAL Service Order Template Appointment - TP
R_SrvcOrdTmplDurationTP view_entity inner TRANSACTIONAL Service Order Template Duration - TP
R_SrvcOrdTmplLongTextTP view_entity inner TRANSACTIONAL Service Order Template Long Text - TP
R_SrvcOrdTmplPartnerAddressTP view_entity inner TRANSACTIONAL Partner Address For Srvc Ord Tmpl - TP
R_SrvcOrdTmplPartnerTP view_entity inner TRANSACTIONAL Service Order Template Partner - TP
R_SrvcOrdTmplRefObjectTP view_entity inner TRANSACTIONAL Service Order Template Ref Object - TP
R_SrvcOrdTmplUserStatusTP view_entity inner TRANSACTIONAL Service Order Template User Status - TP
R_SrvcOrdTransHistory view_entity inner COMPOSITE Transaction History in SRVO Header
R_SrvcOrdUserStatusTP view_entity inner TRANSACTIONAL Service Order User Status - TP
R_SrvcQtanAppointmentTP view_entity inner TRANSACTIONAL Service Quotation Appointment - TP
R_SrvcQtanDurationTP view_entity inner TRANSACTIONAL Service Quotation Duration - TP
R_SrvcQtanLongTextTP view_entity inner TRANSACTIONAL Long Text for Service Quotation
R_SrvcQtanUserStatusTP view_entity inner TRANSACTIONAL Service Quotation User Status - TP
R_SubscrpnContrLongTextTP view_entity inner TRANSACTIONAL Subscription Contract Text - TP

Fields (75)

KeyField CDS FieldsUsed in Views
KEY CustMgmtObjectType BusinessObjectType 1
KEY ServiceDocument BusinessSolutionOrder,BusinessSolutionQuotation,ServiceConfirmation,ServiceContract,ServiceDocument,ServiceOrder,ServiceOrderTemplate,ServiceQuotation,SubscriptionOrder 27
KEY ServiceObjectType BusinessObjectType,ServiceObjectType 7
_DistributionChannel _DistributionChannel 1
_Division _Division 1
_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 1
_SalesOrganizationOrgUnit _SalesOrganizationOrgUnit 1
_SalesOrganizationOrgUnit_2 _SalesOrganizationOrgUnit_2 1
_ServiceDocBillingStatus _ServiceDocBillingStatus 1
_ServiceDocHasError _ServiceDocHasError 1
_ServiceDocumentIsOpen _ServiceDocumentIsOpen 1
_ServiceDocumentStatus _ServiceDocumentStatus 1
_ServiceDocumentType _ServiceDocumentType 1
_ServiceObjType _ServiceObjType 1
_ServiceOrganizationOrgUnit _ServiceOrganizationOrgUnit 1
_ServiceOrganizationOrgUnit_2 _ServiceOrganizationOrgUnit_2 1
_SoldToParty _SoldToParty 1
_SoldToPartyCountry _SoldToPartyCountry 1
_SoldToPartyRegion _SoldToPartyRegion 1
_SrvcDocIsRelForBillgSts _SrvcDocIsRelForBillgSts 1
_SrvcDocLifecycleStatus _SrvcDocLifecycleStatus 1
DistributionChannel DistributionChannel 5
Division Division 5
PaymentTerms PaymentTerms 1
PostingDate PostingDate 2
PurchaseOrderByCustomer PurchaseOrderByCustomer 1
RequestedServiceEndDateTime RequestedServiceEndDateTime 2
RequestedServiceStartDateTime RequestedServiceStartDateTime 2
ResponsibleEmployee RespEmployeeBusinessPartnerId,ResponsibleEmployee 4
SalesGroup SalesGroup 4
SalesGroupOrgUnitID SalesGroupOrgUnitID 4
SalesOffice SalesOffice 4
SalesOfficeOrgUnitID SalesOfficeOrgUnitID 4
SalesOrganization SalesOrganization 6
SalesOrganizationOrgUnitID SalesOrganizationOrgUnitID 4
ServiceDefectCategory ServiceDefectCategory 2
ServiceDefectSchema ServiceDefectSchema 2
ServiceDocBillingStatus ServiceDocBillingStatus 1
ServiceDocCreationDateTime ServiceDocCreationDateTime 1
ServiceDocGrossAmount ServiceDocGrossAmount 2
ServiceDocIsReleasedForBilling ServiceDocIsReleasedForBilling 1
ServiceDocNetAmount ServiceDocNetAmount 3
ServiceDocumentCreatedByUser ServiceDocumentCreatedByUser 1
ServiceDocumentDescription BusSolnQtanDescription,ServiceDocumentDescription 4
ServiceDocumentHasError ServiceDocumentHasError 1
ServiceDocumentImpact ServiceDocumentImpact 1
ServiceDocumentIsOpen ServiceDocumentIsOpen 1
ServiceDocumentIsQuotation ServiceDocumentIsQuotation 2
ServiceDocumentIsRejected ServiceDocumentIsRejected 1
ServiceDocumentIsReleased ServiceDocumentIsReleased 1
ServiceDocumentPriority ServiceDocumentPriority 2
ServiceDocumentProblemCategory ServiceDocumentProblemCategory 1
ServiceDocumentStatus ServiceDocumentStatus 4
ServiceDocumentType ServiceDocumentType 4
ServiceDocumentUrgency ServiceDocumentUrgency 1
ServiceDocumentUUID ServiceDocumentUUID 3
ServiceDueByDateTime ServiceDueByDateTime 1
ServiceEscalationLevel ServiceEscalationLevel 1
ServiceOrganization ServiceOrganization 4
ServiceReasonCategory ServiceReasonCategory 2
ServiceRisk ServiceRisk 1
SoldToParty SoldToParty 6
SoldToPartyCountry SoldToPartyCountry 1
SoldToPartyRegion SoldToPartyRegion 1
SrvcDocIsMaintServiceOrder SrvcDocIsMaintServiceOrder 1
SrvcQtanValidityEndDateTime SrvcQtanValidityEndDateTime 1
SrvcQtanValidityStartDateTime SrvcQtanValidityStartDateTime 1
TransactionCurrency TransactionCurrency 4

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.

-- Service Transaction
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE I_SERVICEDOCUMENT (
    CUSTMGMTOBJECTTYPE,
    SERVICEDOCUMENT,
    SERVICEOBJECTTYPE,
    _DISTRIBUTIONCHANNEL,
    _DIVISION,
    _RESPEMPLOYEE,
    _SALESGROUP,
    _SALESGROUPORGUNIT,
    _SALESGROUPORGUNIT_2,
    _SALESOFFICE,
    _SALESOFFICEORGUNIT,
    _SALESOFFICEORGUNIT_2,
    _SALESORGANIZATION,
    _SALESORGANIZATIONORGUNIT,
    _SALESORGANIZATIONORGUNIT_2,
    _SERVICEDOCBILLINGSTATUS,
    _SERVICEDOCHASERROR,
    _SERVICEDOCUMENTISOPEN,
    _SERVICEDOCUMENTSTATUS,
    _SERVICEDOCUMENTTYPE,
    _SERVICEOBJTYPE,
    _SERVICEORGANIZATIONORGUNIT,
    _SERVICEORGANIZATIONORGUNIT_2,
    _SOLDTOPARTY,
    _SOLDTOPARTYCOUNTRY,
    _SOLDTOPARTYREGION,
    _SRVCDOCISRELFORBILLGSTS,
    _SRVCDOCLIFECYCLESTATUS,
    DISTRIBUTIONCHANNEL,
    DIVISION,
    PAYMENTTERMS,
    POSTINGDATE,
    PURCHASEORDERBYCUSTOMER,
    REQUESTEDSERVICEENDDATETIME,
    REQUESTEDSERVICESTARTDATETIME,
    RESPONSIBLEEMPLOYEE,
    SALESGROUP,
    SALESGROUPORGUNITID,
    SALESOFFICE,
    SALESOFFICEORGUNITID,
    SALESORGANIZATION,
    SALESORGANIZATIONORGUNITID,
    SERVICEDEFECTCATEGORY,
    SERVICEDEFECTSCHEMA,
    SERVICEDOCBILLINGSTATUS,
    SERVICEDOCCREATIONDATETIME,
    SERVICEDOCGROSSAMOUNT,
    SERVICEDOCISRELEASEDFORBILLING,
    SERVICEDOCNETAMOUNT,
    SERVICEDOCUMENTCREATEDBYUSER,
    SERVICEDOCUMENTDESCRIPTION,
    SERVICEDOCUMENTHASERROR,
    SERVICEDOCUMENTIMPACT,
    SERVICEDOCUMENTISOPEN,
    SERVICEDOCUMENTISQUOTATION,
    SERVICEDOCUMENTISREJECTED,
    SERVICEDOCUMENTISRELEASED,
    SERVICEDOCUMENTPRIORITY,
    SERVICEDOCUMENTPROBLEMCATEGORY,
    SERVICEDOCUMENTSTATUS,
    SERVICEDOCUMENTTYPE,
    SERVICEDOCUMENTURGENCY,
    SERVICEDOCUMENTUUID,
    SERVICEDUEBYDATETIME,
    SERVICEESCALATIONLEVEL,
    SERVICEORGANIZATION,
    SERVICEREASONCATEGORY,
    SERVICERISK,
    SOLDTOPARTY,
    SOLDTOPARTYCOUNTRY,
    SOLDTOPARTYREGION,
    SRVCDOCISMAINTSERVICEORDER,
    SRVCQTANVALIDITYENDDATETIME,
    SRVCQTANVALIDITYSTARTDATETIME,
    TRANSACTIONCURRENCY,
    PRIMARY KEY (CUSTMGMTOBJECTTYPE, SERVICEDOCUMENT, SERVICEOBJECTTYPE)
);