P_SrvcContrItmWithCloudCheck
P_SrvcContrItmWithCloudCheck is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (I_ServiceDocumentItemEnhcd) and exposes 108 fields with key fields ServiceObjectType, ServiceDocument, ServiceDocumentItem.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| I_ServiceDocumentItemEnhcd | _Item | from |
Annotations (7)
| Name | Value | Level | Field |
|---|---|---|---|
| AbapCatalog.sqlViewName | PSRVCONTRITEMENH | view | |
| AbapCatalog.compiler.compareFilter | true | view | |
| AbapCatalog.preserveKey | true | view | |
| AccessControl.authorizationCheck | #NOT_REQUIRED | view | |
| ClientHandling.algorithm | #SESSION_VARIABLE | view | |
| VDM.viewType | #COMPOSITE | view | |
| VDM.private | true | view |
Fields (108)
| 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 |
| ServiceDocumentDescription | I_ServiceDocumentItemEnhcd | ServiceDocumentDescription | ||
| ServiceDocumentType | I_ServiceDocumentItemEnhcd | ServiceDocumentType | Transaction Type | |
| ServiceDocumentItemPriority | I_ServiceDocumentItemEnhcd | ServiceDocumentItemPriority | ||
| PostingDate | I_ServiceDocumentItemEnhcd | PostingDate | Posting Date for GR | |
| SrvcDocItmPostingDateTime | I_ServiceDocumentItemEnhcd | SrvcDocItmPostingDateTime | ||
| SrvcDocItmValdtyStartDateTime | I_ServiceDocumentItemEnhcd | SrvcDocItmValdtyStartDateTime | ||
| SrvcDocItmValdtyEndDateTime | I_ServiceDocumentItemEnhcd | SrvcDocItmValdtyEndDateTime | ||
| ServiceDocumentItemUUID | I_ServiceDocumentItemEnhcd | ServiceDocumentItemUUID | ||
| ServiceDocumentItemCharUUID | I_ServiceDocumentItemEnhcd | ServiceDocumentItemCharUUID | ||
| ServiceDocumentItemObjectType | I_ServiceDocumentItemEnhcd | ServiceDocumentItemObjectType | ||
| ServiceDocumentUUID | I_ServiceDocumentItemEnhcd | ServiceDocumentUUID | Object GUID | |
| ParentServiceDocumentItemUUID | I_ServiceDocumentItemEnhcd | ParentServiceDocumentItemUUID | ||
| ServiceDocumentItemDescription | I_ServiceDocumentItemEnhcd | ServiceDocumentItemDescription | ||
| Language | I_ServiceDocumentItemEnhcd | Language | Report Text Language | |
| ServiceDocumentTemplateType | I_ServiceDocumentItemEnhcd | ServiceDocumentTemplateType | ||
| ServiceDocItemCreationDateTime | I_ServiceDocumentItemEnhcd | ServiceDocItemCreationDateTime | ||
| ServiceDocItemChangedDateTime | I_ServiceDocumentItemEnhcd | ServiceDocItemChangedDateTime | ||
| ServiceDocItemCreatedByUser | I_ServiceDocumentItemEnhcd | ServiceDocItemCreatedByUser | ||
| ServiceDocItemChangedByUser | I_ServiceDocumentItemEnhcd | ServiceDocItemChangedByUser | ||
| OriginallyRequestedProduct | I_ServiceDocumentItemEnhcd | OriginallyRequestedProduct | ||
| Product | I_ServiceDocumentItemEnhcd | Product | Product Sold | |
| ServiceDocItemCategory | I_ServiceDocumentItemEnhcd | ServiceDocItemCategory | ||
| RefBusinessSolutionOrder | I_ServiceDocumentItemEnhcd | RefBusinessSolutionOrder | ||
| RefBusinessSolutionOrderItem | I_ServiceDocumentItemEnhcd | RefBusinessSolutionOrderItem | ||
| SoldToPartyCountry | I_ServiceDocumentItemEnhcd | SoldToPartyCountry | ||
| SoldToPartyRegion | I_ServiceDocumentItemEnhcd | SoldToPartyRegion | ||
| SoldToParty | I_ServiceDocumentItemEnhcd | SoldToParty | Sold-to Party | |
| ServiceTeam | I_ServiceDocumentItemEnhcd | ServiceTeam | ||
| ResponsibleEmployee | I_ServiceDocumentItemEnhcd | ResponsibleEmployee | Employee Resp. | |
| ServiceEmployee | I_ServiceDocumentItemEnhcd | ServiceEmployee | ||
| ContactPerson | I_ServiceDocumentItemEnhcd | ContactPerson | Contact Person Key | |
| PayerParty | I_ServiceDocumentItemEnhcd | PayerParty | Payer | |
| BillToParty | I_ServiceDocumentItemEnhcd | BillToParty | Inv. Recipient | |
| ShipToParty | I_ServiceDocumentItemEnhcd | ShipToParty | Ship-To Party (obsolete) | |
| ServiceDocumentItemStatus | I_ServiceDocumentItemEnhcd | ServiceDocumentItemStatus | ||
| ServiceDocumentItemHasError | I_ServiceDocumentItemEnhcd | ServiceDocumentItemHasError | ||
| SrvcDocItmIsReleasedForBilling | I_ServiceDocumentItemEnhcd | SrvcDocItmIsReleasedForBilling | ||
| ServiceDocItemBillingStatus | I_ServiceDocumentItemEnhcd | ServiceDocItemBillingStatus | ||
| ServiceDocumentItemIsOpen | I_ServiceDocumentItemEnhcd | ServiceDocumentItemIsOpen | ||
| SrvcDocItmDeliveryStatus | I_ServiceDocumentItemEnhcd | SrvcDocItmDeliveryStatus | ||
| SrvcDocItmGoodsIssueStatus | I_ServiceDocumentItemEnhcd | SrvcDocItmGoodsIssueStatus | ||
| ServiceDocumentItemIsReleased | I_ServiceDocumentItemEnhcd | ServiceDocumentItemIsReleased | ||
| ServiceDocumentItemIsRejected | I_ServiceDocumentItemEnhcd | ServiceDocumentItemIsRejected | ||
| ServiceDocumentItemIsQuotation | I_ServiceDocumentItemEnhcd | ServiceDocumentItemIsQuotation | ||
| 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. | |
| PaymentTerms | I_ServiceDocumentItemEnhcd | PaymentTerms | Pyt Terms | |
| BillableControl | I_ServiceDocumentItemEnhcd | BillableControl | Billable Control | |
| ServiceDocumentItemNetAmount | I_ServiceDocumentItemEnhcd | ServiceDocumentItemNetAmount | ||
| 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 | |
| ResponsibleSalesOrganization | I_ServiceDocumentItemEnhcd | ResponsibleSalesOrganization | ||
| ServiceOrganization | I_ServiceDocumentItemEnhcd | ServiceOrganization | ||
| ResponsibleServiceOrganization | I_ServiceDocumentItemEnhcd | ResponsibleServiceOrganization | ||
| SalesOrganization | I_ServiceDocumentItemEnhcd | SalesOrganization | Sales Organization | |
| SalesOffice | I_ServiceDocumentItemEnhcd | SalesOffice | Sales Office | |
| SalesGroup | I_ServiceDocumentItemEnhcd | SalesGroup | Sales Group | |
| ServiceDocumentItemCanclnParty | I_ServiceDocumentItemEnhcd | ServiceDocumentItemCanclnParty | ||
| ServiceDocumentItmCanclnReason | I_ServiceDocumentItemEnhcd | ServiceDocumentItmCanclnReason | ||
| SrvcDocItmCanclnProcedure | I_ServiceDocumentItemEnhcd | SrvcDocItmCanclnProcedure | ||
| _ServiceObjType | I_ServiceDocumentItemEnhcd | _ServiceObjType | ||
| _ServiceDocument | I_ServiceDocumentItemEnhcd | _ServiceDocument | ||
| _ServiceDocumentType | I_ServiceDocumentItemEnhcd | _ServiceDocumentType | ||
| _ServiceDocItemPriority | I_ServiceDocumentItemEnhcd | _ServiceDocItemPriority | ||
| _ServiceDocItemCategory | I_ServiceDocumentItemEnhcd | _ServiceDocItemCategory | ||
| _SoldToParty | I_ServiceDocumentItemEnhcd | _SoldToParty | ||
| _RespEmployee | I_ServiceDocumentItemEnhcd | _RespEmployee | ||
| _ServiceTeam | I_ServiceDocumentItemEnhcd | _ServiceTeam | ||
| _ServiceEmployee | I_ServiceDocumentItemEnhcd | _ServiceEmployee | ||
| _ContactPerson | I_ServiceDocumentItemEnhcd | _ContactPerson | ||
| _PayerParty | I_ServiceDocumentItemEnhcd | _PayerParty | ||
| _BillToParty | I_ServiceDocumentItemEnhcd | _BillToParty | ||
| _ShipToParty | I_ServiceDocumentItemEnhcd | _ShipToParty | ||
| _ServiceDocItemStatus | I_ServiceDocumentItemEnhcd | _ServiceDocItemStatus | ||
| _SrvcDocItmLifecycleStatus | I_ServiceDocumentItemEnhcd | _SrvcDocItmLifecycleStatus | ||
| _ServiceDocItemHasError | I_ServiceDocumentItemEnhcd | _ServiceDocItemHasError | ||
| _ServiceDocItemBillingStatus | I_ServiceDocumentItemEnhcd | _ServiceDocItemBillingStatus | ||
| _SrvcDocItemIsRelForBillgSts | ||||
| _ServiceDocumentIsOpen | I_ServiceDocumentItemEnhcd | _ServiceDocumentIsOpen | ||
| _TransactionCurrency | I_ServiceDocumentItemEnhcd | _TransactionCurrency | ||
| _PaymentTerms | I_ServiceDocumentItemEnhcd | _PaymentTerms | ||
| _SalesOrganizationOrgUnit | I_ServiceDocumentItemEnhcd | _SalesOrganizationOrgUnit | ||
| _SalesOfficeOrgUnit | I_ServiceDocumentItemEnhcd | _SalesOfficeOrgUnit | ||
| _SalesGroupOrgUnit | I_ServiceDocumentItemEnhcd | _SalesGroupOrgUnit | ||
| _ServiceOrganizationOrgUnit | I_ServiceDocumentItemEnhcd | _ServiceOrganizationOrgUnit | ||
| _RespSrvcOrganizationOrgUnit | I_ServiceDocumentItemEnhcd | _RespSrvcOrganizationOrgUnit | ||
| _SalesOrganizationOrgUnit_2 | I_ServiceDocumentItemEnhcd | _SalesOrganizationOrgUnit_2 | ||
| _SalesOfficeOrgUnit_2 | I_ServiceDocumentItemEnhcd | _SalesOfficeOrgUnit_2 | ||
| _SalesGroupOrgUnit_2 | I_ServiceDocumentItemEnhcd | _SalesGroupOrgUnit_2 | ||
| _ServiceOrganizationOrgUnit_2 | I_ServiceDocumentItemEnhcd | _ServiceOrganizationOrgUnit_2 | ||
| _RespSrvcOrganizationOrgUnit_2 | I_ServiceDocumentItemEnhcd | _RespSrvcOrganizationOrgUnit_2 | ||
| _SalesOrganization | I_ServiceDocumentItemEnhcd | _SalesOrganization | ||
| _SalesOffice | I_ServiceDocumentItemEnhcd | _SalesOffice | ||
| _SalesGroup | I_ServiceDocumentItemEnhcd | _SalesGroup | ||
| _Division | I_ServiceDocumentItemEnhcd | _Division | ||
| _DistributionChannel | I_ServiceDocumentItemEnhcd | _DistributionChannel | ||
| _SoldToPartyRegion | I_ServiceDocumentItemEnhcd | _SoldToPartyRegion | ||
| _SoldToPartyCountry | I_ServiceDocumentItemEnhcd | _SoldToPartyCountry | ||
| _BillableControl | _BillableControl |
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 P_SrvcContrItmWithCloudCheck.
-- 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 P_SrvcContrItmWithCloudCheck AS
SELECT
_Item.ServiceObjectType AS ServiceObjectType,
_Item.ServiceDocument AS ServiceDocument,
_Item.ServiceDocumentItem AS ServiceDocumentItem,
_Item.ServiceDocumentDescription AS ServiceDocumentDescription,
_Item.ServiceDocumentType AS ServiceDocumentType,
_Item.ServiceDocumentItemPriority AS ServiceDocumentItemPriority,
_Item.PostingDate AS PostingDate,
_Item.SrvcDocItmPostingDateTime AS SrvcDocItmPostingDateTime,
_Item.SrvcDocItmValdtyStartDateTime AS SrvcDocItmValdtyStartDateTime,
_Item.SrvcDocItmValdtyEndDateTime AS SrvcDocItmValdtyEndDateTime,
_Item.ServiceDocumentItemUUID AS ServiceDocumentItemUUID,
_Item.ServiceDocumentItemCharUUID AS ServiceDocumentItemCharUUID,
_Item.ServiceDocumentItemObjectType AS ServiceDocumentItemObjectType,
_Item.ServiceDocumentUUID AS ServiceDocumentUUID,
_Item.ParentServiceDocumentItemUUID AS ParentServiceDocumentItemUUID,
_Item.ServiceDocumentItemDescription AS ServiceDocumentItemDescription,
_Item.Language AS Language,
_Item.ServiceDocumentTemplateType AS ServiceDocumentTemplateType,
_Item.ServiceDocItemCreationDateTime AS ServiceDocItemCreationDateTime,
_Item.ServiceDocItemChangedDateTime AS ServiceDocItemChangedDateTime,
_Item.ServiceDocItemCreatedByUser AS ServiceDocItemCreatedByUser,
_Item.ServiceDocItemChangedByUser AS ServiceDocItemChangedByUser,
_Item.OriginallyRequestedProduct AS OriginallyRequestedProduct,
_Item.Product AS Product,
_Item.ServiceDocItemCategory AS ServiceDocItemCategory,
_Item.RefBusinessSolutionOrder AS RefBusinessSolutionOrder,
_Item.RefBusinessSolutionOrderItem AS RefBusinessSolutionOrderItem,
_Item.SoldToPartyCountry AS SoldToPartyCountry,
_Item.SoldToPartyRegion AS SoldToPartyRegion,
_Item.SoldToParty AS SoldToParty,
_Item.ServiceTeam AS ServiceTeam,
_Item.ResponsibleEmployee AS ResponsibleEmployee,
_Item.ServiceEmployee AS ServiceEmployee,
_Item.ContactPerson AS ContactPerson,
_Item.PayerParty AS PayerParty,
_Item.BillToParty AS BillToParty,
_Item.ShipToParty AS ShipToParty,
_Item.ServiceDocumentItemStatus AS ServiceDocumentItemStatus,
_Item.ServiceDocumentItemHasError AS ServiceDocumentItemHasError,
_Item.SrvcDocItmIsReleasedForBilling AS SrvcDocItmIsReleasedForBilling,
_Item.ServiceDocItemBillingStatus AS ServiceDocItemBillingStatus,
_Item.ServiceDocumentItemIsOpen AS ServiceDocumentItemIsOpen,
_Item.SrvcDocItmDeliveryStatus AS SrvcDocItmDeliveryStatus,
_Item.SrvcDocItmGoodsIssueStatus AS SrvcDocItmGoodsIssueStatus,
_Item.ServiceDocumentItemIsReleased AS ServiceDocumentItemIsReleased,
_Item.ServiceDocumentItemIsRejected AS ServiceDocumentItemIsRejected,
_Item.ServiceDocumentItemIsQuotation AS ServiceDocumentItemIsQuotation,
_Item.TransactionCurrency AS TransactionCurrency,
_Item.StatisticsCurrency AS StatisticsCurrency,
_Item.ExchangeRateType AS ExchangeRateType,
_Item.ExchangeRateDate AS ExchangeRateDate,
_Item.AccountingExchangeRate AS AccountingExchangeRate,
_Item.PaymentTerms AS PaymentTerms,
_Item.BillableControl AS BillableControl,
_Item.ServiceDocumentItemNetAmount AS ServiceDocumentItemNetAmount,
_Item.SalesOrganizationOrgUnitID AS SalesOrganizationOrgUnitID,
_Item.SalesOfficeOrgUnitID AS SalesOfficeOrgUnitID,
_Item.SalesGroupOrgUnitID AS SalesGroupOrgUnitID,
_Item.DistributionChannel AS DistributionChannel,
_Item.Division AS Division,
_Item.ResponsibleSalesOrganization AS ResponsibleSalesOrganization,
_Item.ServiceOrganization AS ServiceOrganization,
_Item.ResponsibleServiceOrganization AS ResponsibleServiceOrganization,
_Item.SalesOrganization AS SalesOrganization,
_Item.SalesOffice AS SalesOffice,
_Item.SalesGroup AS SalesGroup,
_Item.ServiceDocumentItemCanclnParty AS ServiceDocumentItemCanclnParty,
_Item.ServiceDocumentItmCanclnReason AS ServiceDocumentItmCanclnReason,
_Item.SrvcDocItmCanclnProcedure AS SrvcDocItmCanclnProcedure,
_Item._ServiceObjType AS _ServiceObjType,
_Item._ServiceDocument AS _ServiceDocument,
_Item._ServiceDocumentType AS _ServiceDocumentType,
_Item._ServiceDocItemPriority AS _ServiceDocItemPriority,
_Item._ServiceDocItemCategory AS _ServiceDocItemCategory,
_Item._SoldToParty AS _SoldToParty,
_Item._RespEmployee AS _RespEmployee,
_Item._ServiceTeam AS _ServiceTeam,
_Item._ServiceEmployee AS _ServiceEmployee,
_Item._ContactPerson AS _ContactPerson,
_Item._PayerParty AS _PayerParty,
_Item._BillToParty AS _BillToParty,
_Item._ShipToParty AS _ShipToParty,
_Item._ServiceDocItemStatus AS _ServiceDocItemStatus,
_Item._SrvcDocItmLifecycleStatus AS _SrvcDocItmLifecycleStatus,
_Item._ServiceDocItemHasError AS _ServiceDocItemHasError,
_Item._ServiceDocItemBillingStatus AS _ServiceDocItemBillingStatus,
_Item. _SrvcDocItemIsRelForBillgSts AS _SrvcDocItemIsRelForBillgSts,
_Item._ServiceDocumentIsOpen AS _ServiceDocumentIsOpen,
_Item._TransactionCurrency AS _TransactionCurrency,
_Item._PaymentTerms AS _PaymentTerms,
_Item._SalesOrganizationOrgUnit AS _SalesOrganizationOrgUnit,
_Item._SalesOfficeOrgUnit AS _SalesOfficeOrgUnit,
_Item._SalesGroupOrgUnit AS _SalesGroupOrgUnit,
_Item._ServiceOrganizationOrgUnit AS _ServiceOrganizationOrgUnit,
_Item._RespSrvcOrganizationOrgUnit AS _RespSrvcOrganizationOrgUnit,
_Item._SalesOrganizationOrgUnit_2 AS _SalesOrganizationOrgUnit_2,
_Item._SalesOfficeOrgUnit_2 AS _SalesOfficeOrgUnit_2,
_Item._SalesGroupOrgUnit_2 AS _SalesGroupOrgUnit_2,
_Item._ServiceOrganizationOrgUnit_2 AS _ServiceOrganizationOrgUnit_2,
_Item._RespSrvcOrganizationOrgUnit_2 AS _RespSrvcOrganizationOrgUnit_2,
_Item._SalesOrganization AS _SalesOrganization,
_Item._SalesOffice AS _SalesOffice,
_Item._SalesGroup AS _SalesGroup,
_Item._Division AS _Division,
_Item._DistributionChannel AS _DistributionChannel,
_Item._SoldToPartyRegion AS _SoldToPartyRegion,
_Item._SoldToPartyCountry AS _SoldToPartyCountry
FROM I_ServiceDocumentItemEnhcd AS _Item
;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