C_ServiceConfirmationItemDEX
Data Extraction for Service Confirmation
C_ServiceConfirmationItemDEX is a Consumption CDS View (Fact) that provides data about "Data Extraction for Service Confirmation" in SAP S/4HANA. It reads from 1 data source (I_ServiceDocumentItemEnhcd) and exposes 114 fields with key fields ServiceObjectType, ServiceDocument, ServiceDocumentItem. It has 2 associations to related views.
SAP Help Documentation
| Category | Data Extraction |
|---|---|
| Data Category | Fact |
| Status | Released |
| Data Extraction Type | Both types of data extraction are possible: Full (physical deletions are possible in source tables) Delta (delta-enabled with change data capture) |
| Corresponding DataSource | CSRVCCONFITMDEX |
Purpose
This CDS view is app independent, and is available for all external consumers who want to extract service confirmation item and header data, including custom field data, to SAP Business Warehouse (SAP BW) or other external systems. In addition, you can extract reference object information at item level. Using ILM notifications, this view also informs external systems about service confirmations that have been archived or destroyed in the application system.
Prerequisites
To enable an SAP BW/4HANA system to extract data from your SAP S/4HANA system, you need to create a communication user and set up a communication arrangement for that user. For details, see Extracting Data Through CDS Views to SAP BW/4HANA . Authorizations Users who want to use this CDS view must have the following authorization objects assigned: Authorization Object Description CRM_CON_SE Authorization Object CRM Order – Bus.Ob.Service Confirmation CRM_SEO Authorization Object CRM Order – Business Object Service Order CRM_ORD_PR Authorization Object CRM Order – Business Transaction Type CRMS4_SLSO Sales Organizational Units of Service Transactions CRM_ORD_OE Authorization Object CRM Order – Allowed Organ. Units
Structure
Object Types This view relates to the following SAP object type: ServiceConfirmation . Attributes The following are some important attributes in this CDS view: Object type of a service transaction ID of a service transaction Transaction item number Life cycle status of a service transaction External reference number of a sold-to party Billing status of a service transaction Requested service end data Priority of a service transaction item Note If you use service order as a preceding transaction, and your service order only includes service order items, the C_ServiceConfirmationItemDEX view will provide service item data of the service order as a predecessor object of the service confirmation. If in addition to service order items, your service order also includes sales items, and you would like to define a BW query with KPIs that are based on the preceding transaction of service confirmation items, the data extraction can lead to incorrect results. This is because the extractor might provide the sales item data instead of the service item data in the item extractor structure of the C_ServiceConfirmationItemDEX view. That's why, to extract and analyze the data for modeling such KPIs, we strongly recommend that you use the extractors based on the views Preceding Service Transaction ( I_ServiceDocumentPredecessor ) and Preceding Transaction of Srvc Trans Item ( I_ServiceDocumentItemPrdcssr_2 ). After you extract this data, you have to combine it with the data that you extract using the C_ServiceOrderItemDEX view on the SAP BW side.
Related Basic Views
This CDS view uses the following basic views: I_AdditionalCustomerGroup1Text I_AdditionalCustomerGroup2Text I_AdditionalCustomerGroup3Text I_AdditionalCustomerGroup4Text I_AdditionalCustomerGroup5Text I_BillableControlText I_BillingBlockReasonText I_ControllingArea I_CurrencyText I_CustMgmtBusObjType I_CustMgmtBusObjTypeText I_CustMgmtItmBusObjTypeText I_CustomerGroupText I_DistributionChannelText I_DivisionText I_ProfitCenterText I_SalesGroupText I_SalesOfficeText I_SalesOrganizationText I_SalesOrganizationUnitText I_ServiceDocBillingStatusText I_ServiceDocOpenStatusText I_ServiceDocErrorStatusText I_ServiceDocItemCategoryText I_ServiceDocumentPriorityText I_ServiceDocumentStatusText I_ServiceDocumentTypeText I_SrvcDocRelForBillgStsText I_UnitOfMeasure
SAP Business Warehouse (SAP BW) Extraction
Note The corresponding DataSource (Extractor) and this CDS view may have different functionalities. If you are interested in the details of the DataSource, see the related documentation on the SAP Help Portal at https://help.sap.com/viewer/p/BI_CONTENT_757 under Use SAP Library BI Content . For more information about data extraction, see Extracting Data Through CDS Views to SAP BW/4HANA .
This CDS view is app independent, and is available for all external consumers who want to extract service confirmation item and header data, including custom field data, to SAP Business Warehouse (SAP BW) or other external systems. In addition, you can extract reference object information at item level. Using ILM notifications, this view also informs external systems about service confirmations that have been archived or destroyed in the application system.
Prerequisites
To enable an SAP BW/4HANA system to extract data from your SAP S/4HANA system, you need to create a communication user and set up a communication arrangement for that user. For details, see Extracting Data Through CDS Views to SAP BW/4HANA . Authorizations Users who want to use this CDS view must have the following authorization objects assigned: Authorization Object Description CRM_CON_SE Authorization Object CRM Order – Bus.Ob.Service Confirmation CRM_SEO Authorization Object CRM Order – Business Object Service Order CRM_ORD_PR Authorization Object CRM Order – Business Transaction Type CRMS4_SLSO Sales Organizational Units of Service Transactions CRM_ORD_OE Authorization Object CRM Order – Allowed Organ. Units
Structure
Object Types This view relates to the following SAP object type: ServiceConfirmation . Attributes The following are some important attributes in this CDS view: Object type of a service transaction ID of a service transaction Transaction item number Life cycle status of a service transaction External reference number of a sold-to party Billing status of a service transaction Requested service end data Priority of a service transaction item Note If you use service order as a preceding transaction, and your service order only includes service order items, the C_ServiceConfirmationItemDEX view will provide service item data of the service order as a predecessor object of the service confirmation. If in addition to service order items, your service order also includes sales items, and you would like to define a BW query with KPIs that are based on the preceding transaction of service confirmation items, the data extraction can lead to incorrect results. This is because the extractor might provide the sales item data instead of the service item data in the item extractor structure of the C_ServiceConfirmationItemDEX view. That's why, to extract and analyze the data for modeling such KPIs, we strongly recommend that you use the extractors based on the views Preceding Service Transaction ( I_ServiceDocumentPredecessor ) and Preceding Transaction of Srvc Trans Item ( I_ServiceDocumentItemPrdcssr_2 ). After you extract this data, you have to combine it with the data that you extract using the C_ServiceOrderItemDEX view on the SAP BW side.
Related Basic Views
This CDS view uses the following basic views: I_AdditionalCustomerGroup1Text I_AdditionalCustomerGroup2Text I_AdditionalCustomerGroup3Text I_AdditionalCustomerGroup4Text I_AdditionalCustomerGroup5Text I_BillableControlText I_BillingBlockReasonText I_ControllingArea I_CurrencyText I_CustMgmtBusObjType I_CustMgmtBusObjTypeText I_CustMgmtItmBusObjTypeText I_CustomerGroupText I_DistributionChannelText I_DivisionText I_ProfitCenterText I_SalesGroupText I_SalesOfficeText I_SalesOrganizationText I_SalesOrganizationUnitText I_ServiceDocBillingStatusText I_ServiceDocOpenStatusText I_ServiceDocErrorStatusText I_ServiceDocItemCategoryText I_ServiceDocumentPriorityText I_ServiceDocumentStatusText I_ServiceDocumentTypeText I_SrvcDocRelForBillgStsText I_UnitOfMeasure
SAP Business Warehouse (SAP BW) Extraction
Note The corresponding DataSource (Extractor) and this CDS view may have different functionalities. If you are interested in the details of the DataSource, see the related documentation on the SAP Help Portal at https://help.sap.com/viewer/p/BI_CONTENT_757 under Use SAP Library BI Content . For more information about data extraction, see Extracting Data Through CDS Views to SAP BW/4HANA .
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| I_ServiceDocumentItemEnhcd | ServiceOrderItem | from |
Associations (2)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [0..1] | E_ServiceDocumentItem | _ServiceDocItemExt | $projection.ServiceObjectType = _ServiceDocItemExt.ServiceCategory and $projection.ServiceDocument = _ServiceDocItemExt.ServiceOrderItem and $projection.ServiceDocumentItem = _ServiceDocItemExt.ServiceLineExternalID |
| [0..1] | E_ServiceDocument | _ServiceDocumentExt | $projection.ServiceObjectType = _ServiceDocumentExt.ServiceCategory and $projection.ServiceDocument = _ServiceDocumentExt.ServiceOrder |
Annotations (16)
| Name | Value | Level | Field |
|---|---|---|---|
| EndUserText.label | Data Extraction for Service Confirmation | view | |
| ClientHandling.algorithm | #SESSION_VARIABLE | view | |
| AbapCatalog.sqlViewName | CSRVCCONFITMDEX | view | |
| AbapCatalog.compiler.compareFilter | true | view | |
| AbapCatalog.preserveKey | true | view | |
| VDM.viewType | #CONSUMPTION | view | |
| VDM.lifecycle.contract.type | #PUBLIC_LOCAL_API | view | |
| Analytics.dataCategory | #FACT | view | |
| Analytics.dataExtraction.enabled | true | view | |
| AccessControl.authorizationCheck | #CHECK | view | |
| ObjectModel.representativeKey | ServiceDocumentItem | view | |
| ObjectModel.usageType.dataClass | #TRANSACTIONAL | view | |
| ObjectModel.usageType.serviceQuality | #D | view | |
| ObjectModel.usageType.sizeCategory | #XL | view | |
| ObjectModel.sapObjectNodeType.name | ServiceConfirmationItem | view | |
| Metadata.ignorePropagatedAnnotations | true | view |
Fields (114)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | ServiceObjectType | I_ServiceDocumentItemEnhcd | ServiceObjectType | Object Type |
| KEY | ServiceDocument | I_ServiceDocumentItemEnhcd | ServiceDocument | Transaction ID |
| KEY | ServiceDocumentItem | I_ServiceDocumentItemEnhcd | ServiceDocumentItem | Service Document |
| ServiceDocumentUUID | ServiceOrder | ServiceDocumentUUID | Object GUID | |
| ServiceDocumentCharUUID | ServiceOrder | ServiceDocumentCharUUID | ||
| ServiceDocumentDescription | ServiceOrder | ServiceDocumentDescription | ||
| ServiceDocNetAmount | ServiceOrder | ServiceDocNetAmount | ||
| PurchaseOrderByCustomer | ServiceOrder | PurchaseOrderByCustomer | Purchase Order Number | |
| ServiceDocumentStatus | ServiceOrder | ServiceDocumentStatus | ||
| ServiceDocumentHasError | ServiceOrder | ServiceDocumentHasError | ||
| ServiceDocIsReleasedForBilling | ServiceOrder | ServiceDocIsReleasedForBilling | ||
| ServiceDocBillingStatus | ServiceOrder | ServiceDocBillingStatus | ||
| ServiceDocumentIsOpen | ServiceOrder | ServiceDocumentIsOpen | ||
| BusinessActivityCategory | ServiceOrder | BusinessActivityCategory | ||
| ServiceDocChangedDateTime | ServiceOrder | ServiceDocChangedDateTime | ||
| ServiceDocCreationDateTime | ServiceOrder | ServiceDocCreationDateTime | ||
| RequestedServiceStartDate | ServiceOrder | RequestedServiceStartDate | ||
| RequestedServiceEndDate | ServiceOrder | RequestedServiceEndDate | ||
| ServiceDocumentItemPriority | I_ServiceDocumentItemEnhcd | ServiceDocumentItemPriority | ||
| ServiceDocumentType | I_ServiceDocumentItemEnhcd | ServiceDocumentType | Transaction Type | |
| ServiceDocumentItemUUID | I_ServiceDocumentItemEnhcd | ServiceDocumentItemUUID | ||
| ServiceDocumentItemObjectType | I_ServiceDocumentItemEnhcd | ServiceDocumentItemObjectType | ||
| ParentServiceDocumentItemUUID | I_ServiceDocumentItemEnhcd | ParentServiceDocumentItemUUID | ||
| PostingDate | I_ServiceDocumentItemEnhcd | PostingDate | Posting Date for GR | |
| ProfitCenter | I_ServiceDocumentItemEnhcd | ProfitCenter | Profit Center | |
| ControllingArea | I_ServiceDocumentItemEnhcd | ControllingArea | Controlling Area | |
| ProfitCenterDeterminationDate | I_ServiceDocumentItemEnhcd | ProfitCenterDeterminationDate | ||
| ServiceDocItemCategory | I_ServiceDocumentItemEnhcd | ServiceDocItemCategory | ||
| OriginallyRequestedProduct | I_ServiceDocumentItemEnhcd | OriginallyRequestedProduct | ||
| Product | I_ServiceDocumentItemEnhcd | Product | Product Sold | |
| ActualServiceStartDateTime | I_ServiceDocumentItemEnhcd | ActualServiceStartDateTime | ||
| ActualServiceEndDateTime | I_ServiceDocumentItemEnhcd | ActualServiceEndDateTime | ||
| ActualServiceDuration | I_ServiceDocumentItemEnhcd | ActualServiceDuration | ||
| ActualServiceDurationUnit | I_ServiceDocumentItemEnhcd | ActualServiceDurationUnit | ||
| TimeSheetOvertimeCategory | I_ServiceDocumentItemEnhcd | TimeSheetOvertimeCategory | ||
| InvoiceAmountInInvoiceDocCrcy | I_ServiceDocumentItemEnhcd | InvoiceAmountInInvoiceDocCrcy | ||
| SrvcDocItmRequestedQuantity | I_ServiceDocumentItemEnhcd | SrvcDocItmRequestedQuantity | ||
| InvoiceQuantity | I_ServiceDocumentItemEnhcd | InvoiceQuantity | ||
| SrvcDocItmDeliveredQuantity | I_ServiceDocumentItemEnhcd | SrvcDocItmDeliveredQuantity | ||
| SrvcDocItmOrdToBaseQtyNmrtr | I_ServiceDocumentItemEnhcd | SrvcDocItmOrdToBaseQtyNmrtr | ||
| SrvcDocItmOrdToBaseQtyDnmntr | I_ServiceDocumentItemEnhcd | SrvcDocItmOrdToBaseQtyDnmntr | ||
| OrderToBaseQuantityExponent | I_ServiceDocumentItemEnhcd | OrderToBaseQuantityExponent | ||
| ServiceDocItemQuantityUnit | I_ServiceDocumentItemEnhcd | ServiceDocItemQuantityUnit | ||
| SrvcDocItemBaseQuantityUnit | I_ServiceDocumentItemEnhcd | SrvcDocItemBaseQuantityUnit | ||
| ServiceTeam | I_ServiceDocumentItemEnhcd | ServiceTeam | ||
| SoldToParty | I_ServiceDocumentItemEnhcd | SoldToParty | Sold-to Party | |
| SoldToPartyCountry | I_ServiceDocumentItemEnhcd | SoldToPartyCountry | ||
| SoldToPartyRegion | I_ServiceDocumentItemEnhcd | SoldToPartyRegion | ||
| ResponsibleEmployee | I_ServiceDocumentItemEnhcd | ResponsibleEmployee | Employee Resp. | |
| ContactPerson | I_ServiceDocumentItemEnhcd | ContactPerson | Contact Person Key | |
| ServiceEmployee | I_ServiceDocumentItemEnhcd | ServiceEmployee | ||
| TransactionCurrency | I_ServiceDocumentItemEnhcd | TransactionCurrency | Transaction Currency | |
| StatisticsCurrency | I_ServiceDocumentItemEnhcd | StatisticsCurrency | ||
| ExchangeRateType | I_ServiceDocumentItemEnhcd | ExchangeRateType | Exch. Rate Type | |
| ExchangeRateDate | I_ServiceDocumentItemEnhcd | ExchangeRateDate | Translatn Date | |
| AccountingExchangeRate | I_ServiceDocumentItemEnhcd | AccountingExchangeRate | Exch.Rate Acct. | |
| CustomerGroup | I_ServiceDocumentItemEnhcd | CustomerGroup | Customer Group | |
| BillableControl | I_ServiceDocumentItemEnhcd | BillableControl | Billable Control | |
| BillingBlockReason | I_ServiceDocumentItemEnhcd | BillingBlockReason | ||
| AdditionalCustomerGroup1 | I_ServiceDocumentItemEnhcd | AdditionalCustomerGroup1 | Customer Grp 1 | |
| AdditionalCustomerGroup2 | I_ServiceDocumentItemEnhcd | AdditionalCustomerGroup2 | Customer Grp 2 | |
| AdditionalCustomerGroup3 | I_ServiceDocumentItemEnhcd | AdditionalCustomerGroup3 | Customer Grp 3 | |
| AdditionalCustomerGroup4 | I_ServiceDocumentItemEnhcd | AdditionalCustomerGroup4 | Customer Grp 4 | |
| AdditionalCustomerGroup5 | I_ServiceDocumentItemEnhcd | AdditionalCustomerGroup5 | Customer Grp 5 | |
| SalesOrganizationOrgUnitID | I_ServiceDocumentItemEnhcd | SalesOrganizationOrgUnitID | ||
| SalesOfficeOrgUnitID | I_ServiceDocumentItemEnhcd | SalesOfficeOrgUnitID | ||
| SalesGroupOrgUnitID | I_ServiceDocumentItemEnhcd | SalesGroupOrgUnitID | ||
| DistributionChannel | I_ServiceDocumentItemEnhcd | DistributionChannel | RefDistCh-Cust/Mat. | |
| Division | I_ServiceDocumentItemEnhcd | Division | Internal Division ID | |
| ServiceOrganization | I_ServiceDocumentItemEnhcd | ServiceOrganization | ||
| ResponsibleSalesOrganization | I_ServiceDocumentItemEnhcd | ResponsibleSalesOrganization | ||
| ResponsibleServiceOrganization | I_ServiceDocumentItemEnhcd | ResponsibleServiceOrganization | Organizational Unit (Service) | |
| SalesOrganization | I_ServiceDocumentItemEnhcd | SalesOrganization | Sales Organization | |
| SalesOffice | I_ServiceDocumentItemEnhcd | SalesOffice | Sales Office | |
| SalesGroup | I_ServiceDocumentItemEnhcd | SalesGroup | Sales Group | |
| ServiceDocumentItemStatus | I_ServiceDocumentItemEnhcd | ServiceDocumentItemStatus | ||
| ServiceDocumentItemHasError | I_ServiceDocumentItemEnhcd | ServiceDocumentItemHasError | ||
| ServiceDocItemBillingStatus | I_ServiceDocumentItemEnhcd | ServiceDocItemBillingStatus | ||
| SrvcDocItmIsReleasedForBilling | I_ServiceDocumentItemEnhcd | SrvcDocItmIsReleasedForBilling | ||
| ServiceDocumentItemIsRejected | I_ServiceDocumentItemEnhcd | ServiceDocumentItemIsRejected | ||
| ServiceDocumentItemIsOpen | I_ServiceDocumentItemEnhcd | ServiceDocumentItemIsOpen | ||
| ServiceDocumentItemNetAmount | I_ServiceDocumentItemEnhcd | ServiceDocumentItemNetAmount | ||
| ServiceDocItemGrossAmount | I_ServiceDocumentItemEnhcd | ServiceDocItemGrossAmount | ||
| ProductGroup | I_ServiceDocumentItemEnhcd | ProductGroup | Product Sold Group | |
| SrvcMaterialPricingGroup | I_ServiceDocumentItemEnhcd | ProductGroup | Product Sold Group | |
| ProductGroup1 | I_ServiceDocumentItemEnhcd | ProductGroup1 | ||
| ProductGroup2 | I_ServiceDocumentItemEnhcd | ProductGroup2 | ||
| ProductGroup3 | I_ServiceDocumentItemEnhcd | ProductGroup3 | ||
| ProductGroup4 | I_ServiceDocumentItemEnhcd | ProductGroup4 | ||
| ProductGroup5 | I_ServiceDocumentItemEnhcd | ProductGroup5 | ||
| ProductHierarchy | I_ServiceDocumentItemEnhcd | ProductHierarchy | Prod.hierarchy | |
| SrvcTransactionValuationType | I_ServiceDocumentItemEnhcd | SrvcTransactionValuationType | ||
| ServiceTransactionChargeType | I_ServiceDocumentItemEnhcd | ServiceTransactionChargeType | ||
| ServiceRefObjectSequenceNumber | ServiceOrdItemRefObj | ServiceRefObjectSequenceNumber | ||
| ServiceReferenceObjectType | ServiceOrdItemRefObj | ServiceReferenceObjectType | ||
| ServiceReferenceObjectUUID | ServiceOrdItemRefObj | ServiceReferenceObjectUUID | ||
| ProductID | ServiceOrdItemRefObj | ProductID | Product ID | |
| ProductUUID | ServiceOrdItemRefObj | ProductUUID | UUID | |
| SerialNumber | ServiceOrdItemRefObj | SerialNumber | Serial Number | |
| Equipment | ServiceOrdItemRefObj | Equipment | Equipment check | |
| FunctionalLocation | ServiceOrdItemRefObj | FunctionalLocation | Object ID | |
| ServiceDocumentRelationUUID | ServiceDocumentPredecessor | ServiceDocumentRelationUUID | ||
| ServiceDocRltnSequenceNumber | ServiceDocumentPredecessor | ServiceDocRltnSequenceNumber | Seq Number | |
| SrvcOrdPredecessorUUID | ServiceDocumentPredecessor | ServiceDocumentPredecessorUUID | ||
| SrvcOrdPrdcssrBusObjType | ServiceDocumentPredecessor | ServiceDocPrdcssrBusObjType | ||
| ServiceDocumentItmRelationUUID | ServiceDocumentItemPrdcssr | ServiceDocumentItmRelationUUID | ||
| ServiceDocItmRltnSqncNumber | ServiceDocumentItemPrdcssr | ServiceDocItmRltnSqncNumber | ||
| SrvcOrdItmPrdcssrCharUUID | ServiceDocumentItemPrdcssr | ServiceDocItmPrdcssrCharUUID | ||
| SrvcOrdItmPrdcssrBusObjType | ServiceDocumentItemPrdcssr | ServiceDocItmPrdcssrBusObjType | ||
| _ServiceObjType | _ServiceObjType | |||
| _ServiceDocument | _ServiceDocument | |||
| _BaseUnit_2 | _BaseUnit_2 | |||
| _SalesUnit | _SalesUnit | |||
| _TransactionCurrency | _TransactionCurrency |
Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.
-- Derived SQL interpretation of CDS view C_ServiceConfirmationItemDEX.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
CREATE VIEW C_ServiceConfirmationItemDEX AS
SELECT
ServiceOrderItem.ServiceObjectType AS ServiceObjectType,
ServiceOrderItem.ServiceDocument AS ServiceDocument,
ServiceOrderItem.ServiceDocumentItem AS ServiceDocumentItem,
ServiceOrder.ServiceDocumentUUID AS ServiceDocumentUUID,
ServiceOrder.ServiceDocumentCharUUID AS ServiceDocumentCharUUID,
ServiceOrder.ServiceDocumentDescription AS ServiceDocumentDescription,
ServiceOrder.ServiceDocNetAmount AS ServiceDocNetAmount,
ServiceOrder.PurchaseOrderByCustomer AS PurchaseOrderByCustomer,
ServiceOrder.ServiceDocumentStatus AS ServiceDocumentStatus,
ServiceOrder.ServiceDocumentHasError AS ServiceDocumentHasError,
ServiceOrder.ServiceDocIsReleasedForBilling AS ServiceDocIsReleasedForBilling,
ServiceOrder.ServiceDocBillingStatus AS ServiceDocBillingStatus,
ServiceOrder.ServiceDocumentIsOpen AS ServiceDocumentIsOpen,
ServiceOrder.BusinessActivityCategory AS BusinessActivityCategory,
ServiceOrder.ServiceDocChangedDateTime AS ServiceDocChangedDateTime,
ServiceOrder.ServiceDocCreationDateTime AS ServiceDocCreationDateTime,
ServiceOrder.RequestedServiceStartDate AS RequestedServiceStartDate,
ServiceOrder.RequestedServiceEndDate AS RequestedServiceEndDate,
ServiceOrderItem.ServiceDocumentItemPriority AS ServiceDocumentItemPriority,
ServiceOrderItem.ServiceDocumentType AS ServiceDocumentType,
ServiceOrderItem.ServiceDocumentItemUUID AS ServiceDocumentItemUUID,
ServiceOrderItem.ServiceDocumentItemObjectType AS ServiceDocumentItemObjectType,
ServiceOrderItem.ParentServiceDocumentItemUUID AS ParentServiceDocumentItemUUID,
ServiceOrderItem.PostingDate AS PostingDate,
ServiceOrderItem.ProfitCenter AS ProfitCenter,
ServiceOrderItem.ControllingArea AS ControllingArea,
ServiceOrderItem.ProfitCenterDeterminationDate AS ProfitCenterDeterminationDate,
ServiceOrderItem.ServiceDocItemCategory AS ServiceDocItemCategory,
ServiceOrderItem.OriginallyRequestedProduct AS OriginallyRequestedProduct,
ServiceOrderItem.Product AS Product,
ServiceOrderItem.ActualServiceStartDateTime AS ActualServiceStartDateTime,
ServiceOrderItem.ActualServiceEndDateTime AS ActualServiceEndDateTime,
ServiceOrderItem.ActualServiceDuration AS ActualServiceDuration,
ServiceOrderItem.ActualServiceDurationUnit AS ActualServiceDurationUnit,
ServiceOrderItem.TimeSheetOvertimeCategory AS TimeSheetOvertimeCategory,
ServiceOrderItem.InvoiceAmountInInvoiceDocCrcy AS InvoiceAmountInInvoiceDocCrcy,
ServiceOrderItem.SrvcDocItmRequestedQuantity AS SrvcDocItmRequestedQuantity,
ServiceOrderItem.InvoiceQuantity AS InvoiceQuantity,
ServiceOrderItem.SrvcDocItmDeliveredQuantity AS SrvcDocItmDeliveredQuantity,
ServiceOrderItem.SrvcDocItmOrdToBaseQtyNmrtr AS SrvcDocItmOrdToBaseQtyNmrtr,
ServiceOrderItem.SrvcDocItmOrdToBaseQtyDnmntr AS SrvcDocItmOrdToBaseQtyDnmntr,
ServiceOrderItem.OrderToBaseQuantityExponent AS OrderToBaseQuantityExponent,
ServiceOrderItem.ServiceDocItemQuantityUnit AS ServiceDocItemQuantityUnit,
ServiceOrderItem.SrvcDocItemBaseQuantityUnit AS SrvcDocItemBaseQuantityUnit,
ServiceOrderItem.ServiceTeam AS ServiceTeam,
ServiceOrderItem.SoldToParty AS SoldToParty,
ServiceOrderItem.SoldToPartyCountry AS SoldToPartyCountry,
ServiceOrderItem.SoldToPartyRegion AS SoldToPartyRegion,
ServiceOrderItem.ResponsibleEmployee AS ResponsibleEmployee,
ServiceOrderItem.ContactPerson AS ContactPerson,
ServiceOrderItem.ServiceEmployee AS ServiceEmployee,
ServiceOrderItem.TransactionCurrency AS TransactionCurrency,
ServiceOrderItem.StatisticsCurrency AS StatisticsCurrency,
ServiceOrderItem.ExchangeRateType AS ExchangeRateType,
ServiceOrderItem.ExchangeRateDate AS ExchangeRateDate,
ServiceOrderItem.AccountingExchangeRate AS AccountingExchangeRate,
ServiceOrderItem.CustomerGroup AS CustomerGroup,
ServiceOrderItem.BillableControl AS BillableControl,
ServiceOrderItem.BillingBlockReason AS BillingBlockReason,
ServiceOrderItem.AdditionalCustomerGroup1 AS AdditionalCustomerGroup1,
ServiceOrderItem.AdditionalCustomerGroup2 AS AdditionalCustomerGroup2,
ServiceOrderItem.AdditionalCustomerGroup3 AS AdditionalCustomerGroup3,
ServiceOrderItem.AdditionalCustomerGroup4 AS AdditionalCustomerGroup4,
ServiceOrderItem.AdditionalCustomerGroup5 AS AdditionalCustomerGroup5,
ServiceOrderItem.SalesOrganizationOrgUnitID AS SalesOrganizationOrgUnitID,
ServiceOrderItem.SalesOfficeOrgUnitID AS SalesOfficeOrgUnitID,
ServiceOrderItem.SalesGroupOrgUnitID AS SalesGroupOrgUnitID,
ServiceOrderItem.DistributionChannel AS DistributionChannel,
ServiceOrderItem.Division AS Division,
ServiceOrderItem.ServiceOrganization AS ServiceOrganization,
ServiceOrderItem.ResponsibleSalesOrganization AS ResponsibleSalesOrganization,
ServiceOrderItem.ResponsibleServiceOrganization AS ResponsibleServiceOrganization,
ServiceOrderItem.SalesOrganization AS SalesOrganization,
ServiceOrderItem.SalesOffice AS SalesOffice,
ServiceOrderItem.SalesGroup AS SalesGroup,
ServiceOrderItem.ServiceDocumentItemStatus AS ServiceDocumentItemStatus,
ServiceOrderItem.ServiceDocumentItemHasError AS ServiceDocumentItemHasError,
ServiceOrderItem.ServiceDocItemBillingStatus AS ServiceDocItemBillingStatus,
ServiceOrderItem.SrvcDocItmIsReleasedForBilling AS SrvcDocItmIsReleasedForBilling,
ServiceOrderItem.ServiceDocumentItemIsRejected AS ServiceDocumentItemIsRejected,
ServiceOrderItem.ServiceDocumentItemIsOpen AS ServiceDocumentItemIsOpen,
ServiceOrderItem.ServiceDocumentItemNetAmount AS ServiceDocumentItemNetAmount,
ServiceOrderItem.ServiceDocItemGrossAmount AS ServiceDocItemGrossAmount,
ServiceOrderItem.ProductGroup AS ProductGroup,
ServiceOrderItem.ProductGroup AS SrvcMaterialPricingGroup,
ServiceOrderItem.ProductGroup1 AS ProductGroup1,
ServiceOrderItem.ProductGroup2 AS ProductGroup2,
ServiceOrderItem.ProductGroup3 AS ProductGroup3,
ServiceOrderItem.ProductGroup4 AS ProductGroup4,
ServiceOrderItem.ProductGroup5 AS ProductGroup5,
ServiceOrderItem.ProductHierarchy AS ProductHierarchy,
ServiceOrderItem.SrvcTransactionValuationType AS SrvcTransactionValuationType,
ServiceOrderItem.ServiceTransactionChargeType AS ServiceTransactionChargeType,
ServiceOrdItemRefObj.ServiceRefObjectSequenceNumber AS ServiceRefObjectSequenceNumber,
ServiceOrdItemRefObj.ServiceReferenceObjectType AS ServiceReferenceObjectType,
ServiceOrdItemRefObj.ServiceReferenceObjectUUID AS ServiceReferenceObjectUUID,
ServiceOrdItemRefObj.ProductID AS ProductID,
ServiceOrdItemRefObj.ProductUUID AS ProductUUID,
ServiceOrdItemRefObj.SerialNumber AS SerialNumber,
ServiceOrdItemRefObj.Equipment AS Equipment,
ServiceOrdItemRefObj.FunctionalLocation AS FunctionalLocation,
ServiceDocumentPredecessor.ServiceDocumentRelationUUID AS ServiceDocumentRelationUUID,
ServiceDocumentPredecessor.ServiceDocRltnSequenceNumber AS ServiceDocRltnSequenceNumber,
ServiceDocumentPredecessor.ServiceDocumentPredecessorUUID AS SrvcOrdPredecessorUUID,
ServiceDocumentPredecessor.ServiceDocPrdcssrBusObjType AS SrvcOrdPrdcssrBusObjType,
ServiceDocumentItemPrdcssr.ServiceDocumentItmRelationUUID AS ServiceDocumentItmRelationUUID,
ServiceDocumentItemPrdcssr.ServiceDocItmRltnSqncNumber AS ServiceDocItmRltnSqncNumber,
ServiceDocumentItemPrdcssr.ServiceDocItmPrdcssrCharUUID AS SrvcOrdItmPrdcssrCharUUID,
ServiceDocumentItemPrdcssr.ServiceDocItmPrdcssrBusObjType AS SrvcOrdItmPrdcssrBusObjType
FROM I_ServiceDocumentItemEnhcd AS ServiceOrderItem
LEFT OUTER JOIN E_ServiceDocumentItem AS _ServiceDocItemExt ON ServiceObjectType = _ServiceDocItemExt.ServiceCategory AND ServiceDocument = _ServiceDocItemExt.ServiceOrderItem AND ServiceDocumentItem = _ServiceDocItemExt.ServiceLineExternalID -- association [0..1]
LEFT OUTER JOIN E_ServiceDocument AS _ServiceDocumentExt ON ServiceObjectType = _ServiceDocumentExt.ServiceCategory AND ServiceDocument = _ServiceDocumentExt.ServiceOrder -- association [0..1]
;Learn More
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- CDS View Annotations — A Complete Guide
- What Is a CDS View in SAP S/4HANA?
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA
- 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
- BW Extractor to CDS View Migration Guide
- S/4HANA CDS View Deprecation: What You Need to Know
- ABAP CDS View Tutorial — From Basics to Real-World Examples
- RAP and CDS Views — Building Transactional Apps in SAP S/4HANA
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA