I_SERVICEDOCUMENT
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)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| 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)
| Key | Field | CDS Fields | Used 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)
);
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