I_SERVICEDOCUMENT
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)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| 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)
| Key | Field | CDS Fields | Used 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)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA