I_SERVICEDOCUMENT

CDS View

Service Transaction

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

CDS Views using this table (84)

ViewTypeJoinVDMDescription
A_BusSolnOrdPartner view_entity inner COMPOSITE Solution Order Partner
A_BusSolnOrdPartnerAddress view_entity inner COMPOSITE Partner Address of Solution Order
A_BusSolnOrdUserStatus view inner COMPOSITE Header User Status
A_ServiceConfUserStatus view_entity inner COMPOSITE Service Confirmation User Status
A_ServiceOrderTmplText view_entity inner COMPOSITE Service Order Template Text
A_ServiceOrdUserStatus view_entity inner COMPOSITE Service Order User Status
A_ServiceQuotationText view_entity inner COMPOSITE Service Quotation Text
A_SrvcConfAppointment view_entity inner COMPOSITE Service Confirmation Appointment
A_SrvcConfDuration view_entity inner COMPOSITE Service Confirmation Duration
A_SrvcOrdAppointment view_entity inner COMPOSITE Service Order Appointment
A_SrvcOrdDuration view_entity inner COMPOSITE Service Order Duration
A_SrvcOrdPartner view_entity inner COMPOSITE Service Order Partner
A_SrvcOrdPartnerAddress view_entity inner COMPOSITE Partner Address of Service Order
A_SrvcOrdTmplAppointment view_entity inner COMPOSITE Service Order Template Appointment
A_SrvcOrdTmplDuration view_entity inner COMPOSITE Service Order Template Duration
A_SrvcOrdTmplPartner view_entity inner COMPOSITE Service Order Template Partner
A_SrvcOrdTmplPartnerAddress view_entity inner COMPOSITE Partner Address of Service Order Template
A_SrvcOrdTmplUserStatus view_entity inner COMPOSITE Service Order Template User Status
C_ARProcFlwAttribForSrvcConf view_entity from CONSUMPTION Service Confirmation Attributes
C_ARProcFlwAttribForSrvcOrder view_entity from CONSUMPTION Service Order Attributes
C_BusSolnOrdOutputParam view from CONSUMPTION Solution Order Output Parameter Determination
C_DspDocFlwServiceConfirmation view_entity from CONSUMPTION Service Confirmation Attributes
C_DspDocFlwServiceContract view_entity from CONSUMPTION Service Contract Attributes
C_DspDocFlwServiceOrder view_entity from CONSUMPTION Service Order Attributes
C_DspDocFlwSolutionOrder view_entity from CONSUMPTION Solution Order Attributes
C_DspDocFlwSolutionOrderVH view_entity from CONSUMPTION Solution Order
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
I_ARProcessFlowDocumentVH view union_all COMPOSITE Document Number
I_BusinessSolutionOrderStdVH view from COMPOSITE Solution Order Value Help
I_RU_Contract view union COMPOSITE Contracts in Russian Financials
I_ServiceContract view_entity from BASIC Service Contract
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_entity from BASIC 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_entity left_outer COMPOSITE View for Service Conf. Billing Items
I_SrvcDocByDocumentType view from BASIC Service Transaction by Transaction Type
I_SrvcDocItemPriceElement view_entity inner BASIC Service Transaction Item Pricing Element
I_SrvcOrdTransfStatusSituation view_entity from COMPOSITE Data Transfer Situations
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_ServiceOrderFulfillment view from COMPOSITE View for service order fulfillment monitor
P_SrvcTransWthSituation view_entity inner COMPOSITE service orders with situation instances
R_BusSolnOrdLongTextTP view_entity inner TRANSACTIONAL Business Solution Order Long Text - TP
R_BusSolnOrdPartnerAddressTP view_entity inner TRANSACTIONAL Business Soln Order Partner Address - 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_SrvcConfLongTextTP view_entity inner TRANSACTIONAL Long Text for Service Confirmation
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_SrvcContrPartnerAddressTP view_entity inner TRANSACTIONAL Partner Address in Service Contract - TP
R_SrvcContrPartnerTP view_entity inner TRANSACTIONAL Service Contract Partner - 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_SrvcOrdLongTextTP view_entity inner TRANSACTIONAL Long Text for Service Order
R_SrvcOrdPartnerAddressTP view_entity inner TRANSACTIONAL Partner Address For Service Order - TP
R_SrvcOrdPartnerTP view_entity inner TRANSACTIONAL Service Order Partner - TP
R_SrvcOrdReferenceObjectTP view_entity inner TRANSACTIONAL Service Order Reference Object - 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_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_SrvcQtanPartnerAddressTP view_entity inner TRANSACTIONAL Partner Address For Service Quotation-TP
R_SrvcQtanPartnerTP view_entity inner TRANSACTIONAL Service Quotation Partner - TP
R_SrvcQtanUserStatusTP view_entity inner TRANSACTIONAL Service Quotation User Status - TP

Fields (59)

KeyField CDS FieldsUsed in Views
KEY ServiceDocument BusinessSolutionOrder,ServiceConfirmation,ServiceContract,ServiceDocument,ServiceOrder,ServiceOrderTemplate,ServiceQuotation,SubscriptionOrder 30
KEY ServiceDocumentType ServiceDocumentType 3
KEY ServiceDocumentUUID BusinessSolutionOrderUUID,ServiceDocumentUUID 3
KEY ServiceObjectType ServiceObjectType 6
_DistributionChannel _DistributionChannel 2
_Division _Division 2
_RespEmployee _RespEmployee 1
_SalesGroup _SalesGroup 2
_SalesGroupOrgUnit _SalesGroupOrgUnit 1
_SalesGroupOrgUnit_2 _SalesGroupOrgUnit_2 2
_SalesOffice _SalesOffice 2
_SalesOfficeOrgUnit _SalesOfficeOrgUnit 1
_SalesOfficeOrgUnit_2 _SalesOfficeOrgUnit_2 2
_SalesOrganization _SalesOrganization 2
_SalesOrganizationOrgUnit _SalesOrganizationOrgUnit 1
_SalesOrganizationOrgUnit_2 _SalesOrganizationOrgUnit_2 2
_ServiceDocBillingStatus _ServiceDocBillingStatus 1
_ServiceDocHasError _ServiceDocHasError 1
_ServiceDocumentIsOpen _ServiceDocumentIsOpen 1
_ServiceDocumentStatus _ServiceDocumentStatus 2
_ServiceDocumentType _ServiceDocumentType 1
_ServiceObjType _ServiceObjType 2
_ServiceOrganizationOrgUnit _ServiceOrganizationOrgUnit 1
_ServiceOrganizationOrgUnit_2 _ServiceOrganizationOrgUnit_2 1
_SoldToParty _SoldToParty 1
_SoldToPartyCountry _SoldToPartyCountry 1
_SoldToPartyRegion _SoldToPartyRegion 1
_SrvcDocIsRelForBillgSts _SrvcDocIsRelForBillgSts 1
_SrvcDocLifecycleStatus _SrvcDocLifecycleStatus 2
DistributionChannel DistributionChannel 6
Division Division 6
PaymentTerms PaymentTerms 3
PurchaseOrderByCustomer PurchaseOrderByCustomer 3
ResponsibleEmployee RespEmployeeBusinessPartnerId,ResponsibleEmployee 2
SalesGroup SalesGroup 3
SalesGroupOrgUnitID SalesGroupOrgUnitID 3
SalesOffice SalesOffice 3
SalesOfficeOrgUnitID SalesOfficeOrgUnitID 3
SalesOrganization SalesOrganization 10
SalesOrganizationOrgUnitID SalesOrganizationOrgUnitID 3
ServiceDocBillingStatus ServiceDocBillingStatus 1
ServiceDocCreationDateTime ServiceDocCreationDateTime 3
ServiceDocGrossAmount ServiceDocGrossAmount 3
ServiceDocIsReleasedForBilling ServiceDocIsReleasedForBilling 1
ServiceDocNetAmount ServiceDocNetAmount 4
ServiceDocumentCreatedByUser ServiceDocumentCreatedByUser 4
ServiceDocumentDescription ServiceDocumentDescription 1
ServiceDocumentHasError ServiceDocumentHasError 1
ServiceDocumentIsOpen ServiceDocumentIsOpen 1
ServiceDocumentIsQuotation ServiceDocumentIsQuotation 1
ServiceDocumentIsRejected ServiceDocumentIsRejected 1
ServiceDocumentIsReleased ServiceDocumentIsReleased 1
ServiceDocumentStatus ServiceDocumentStatus 5
ServiceOrganization ServiceOrganization 2
SoldToParty SoldToParty 8
SoldToPartyCountry SoldToPartyCountry 1
SoldToPartyRegion SoldToPartyRegion 1
SrvcDocTransferStatus SrvcDocTransferStatus 1
TransactionCurrency TransactionCurrency 8

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 (
    SERVICEDOCUMENT,
    SERVICEDOCUMENTTYPE,
    SERVICEDOCUMENTUUID,
    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,
    PURCHASEORDERBYCUSTOMER,
    RESPONSIBLEEMPLOYEE,
    SALESGROUP,
    SALESGROUPORGUNITID,
    SALESOFFICE,
    SALESOFFICEORGUNITID,
    SALESORGANIZATION,
    SALESORGANIZATIONORGUNITID,
    SERVICEDOCBILLINGSTATUS,
    SERVICEDOCCREATIONDATETIME,
    SERVICEDOCGROSSAMOUNT,
    SERVICEDOCISRELEASEDFORBILLING,
    SERVICEDOCNETAMOUNT,
    SERVICEDOCUMENTCREATEDBYUSER,
    SERVICEDOCUMENTDESCRIPTION,
    SERVICEDOCUMENTHASERROR,
    SERVICEDOCUMENTISOPEN,
    SERVICEDOCUMENTISQUOTATION,
    SERVICEDOCUMENTISREJECTED,
    SERVICEDOCUMENTISRELEASED,
    SERVICEDOCUMENTSTATUS,
    SERVICEORGANIZATION,
    SOLDTOPARTY,
    SOLDTOPARTYCOUNTRY,
    SOLDTOPARTYREGION,
    SRVCDOCTRANSFERSTATUS,
    TRANSACTIONCURRENCY,
    PRIMARY KEY (SERVICEDOCUMENT, SERVICEDOCUMENTTYPE, SERVICEDOCUMENTUUID, SERVICEOBJECTTYPE)
);