I_ServiceContractItemTP

DDL: I_SERVICECONTRACTITEMTP Type: view_entity TRANSACTIONAL Package: CRMS4_SERVICE_CONTRACT_RAP
73 Fields 1 Data Sources

Service Contract Item - TP

I_ServiceContractItemTP is a Transactional CDS View that provides data about "Service Contract Item - TP" in SAP S/4HANA. It reads from 1 data source (R_ServiceContractItemTP) and exposes 73 fields with key fields ServiceContract, ServiceContractItem. Part of development package CRMS4_SERVICE_CONTRACT_RAP.

Data Sources (1)

SourceAliasJoin Type
R_ServiceContractItemTP R_ServiceContractItemTP projection

Annotations (10)

NameValueLevelField
EndUserText.label Service Contract Item - TP view
AccessControl.authorizationCheck #CHECK view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
VDM.viewType #TRANSACTIONAL view
ObjectModel.modelingPattern #TRANSACTIONAL_PROJECTED_ENTITY view
ObjectModel.sapObjectNodeType.name ServiceContractItem view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
Metadata.ignorePropagatedAnnotations true view

Fields (73)

KeyFieldSource TableSource FieldDescription
KEY ServiceContract ServiceContract Transaction ID
KEY ServiceContractItem ServiceContractItem Item Number in Doc.
ServiceObjectType ServiceObjectType Object Type
ServiceContractItemCategory ServiceContractItemCategory
ServiceContractItemUUID ServiceContractItemUUID
ServiceContractItemDescription ServiceContractItemDescription
Language Language Report Text Language
ServiceDocItemCreationDateTime ServiceDocItemCreationDateTime
ServiceDocItemChangedDateTime ServiceDocItemChangedDateTime
ServiceDocItemCreatedByUser ServiceDocItemCreatedByUser
ServiceDocItemChangedByUser ServiceDocItemChangedByUser
Product Product Product Sold
Quantity Quantity Value
QuantityUnit QuantityUnit Unit of measure
SoldToParty SoldToParty Sold-to Party
ShipToParty ShipToParty Ship-To Party (obsolete)
BillToParty BillToParty Inv. Recipient
PayerParty PayerParty Payer
ContactPersonBusinessPartnerId ContactPersonBusinessPartnerId Contact Person Key
RespEmployeeBusinessPartnerId RespEmployeeBusinessPartnerId Employee Resp.
ServiceContractItemIsNew ServiceContractItemIsNew
ServiceContractItemIsInProcess ServiceContractItemIsInProcess
ServiceContractItemIsReleased ServiceContractItemIsReleased
ServiceContractItemIsCompleted ServiceContractItemIsCompleted
ServiceContractItemStatus ServiceContractItemStatus
ServiceContrItemBillingStatus ServiceContrItemBillingStatus
ServiceContractItemIsRejected ServiceContractItemIsRejected
ServiceContractItemHasError ServiceContractItemHasError
SrvcDocItemTransferStatus SrvcDocItemTransferStatus
ServiceContrItemStartDateTime ServiceContrItemStartDateTime
ServiceContrItemEndDateTime ServiceContrItemEndDateTime
SrvcContrItemRnwlDuration SrvcContrItemRnwlDuration
SrvcContrItemRnwlDurationUnit SrvcContrItemRnwlDurationUnit
SrvcContrItemExtensionDuration SrvcContrItemExtensionDuration
SrvcContrItemExtnDurationUnit SrvcContrItemExtnDurationUnit
ServiceDocItemGrossAmount ServiceDocItemGrossAmount
ServiceDocumentItemNetAmount ServiceDocumentItemNetAmount
ServiceDocumentItemTaxAmount ServiceDocumentItemTaxAmount
TransactionCurrency TransactionCurrency Transaction Currency
ServiceContractItemCanclnParty ServiceContractItemCanclnParty
ServiceContractItmCanclnReason ServiceContractItmCanclnReason
SettlementPeriodRuleUUID SettlementPeriodRuleUUID
SettlementPeriodRule SettlementPeriodRule
BillingPlanBillingDateRuleUUID BillingPlanBillingDateRuleUUID
SrvcMgmtBillgPlanBillgDateRule SrvcMgmtBillgPlanBillgDateRule
BillingBlockReason BillingBlockReason
PaymentTerms PaymentTerms Pyt Terms
PaymentMethod PaymentMethod Pymt Meth.
SrvcContrExternalReference SrvcContrExternalReference
SrvcContrItmExternalReference SrvcContrItmExternalReference
ServiceQtanExtReference ServiceQtanExtReference
ServiceQtanItemExtReference ServiceQtanItemExtReference
PurchaseOrderByCustomer PurchaseOrderByCustomer Purchase Order Number
_ServiceDocument _ServiceDocument
_ServiceObjType _ServiceObjType
_Product _Product
_RespEmployee _RespEmployee
_ContactPerson _ContactPerson
_ExtRefServiceContract _ExtRefServiceContract
_ExtRefServiceContractItem _ExtRefServiceContractItem
_SrvcDocLifecycleStatusText _SrvcDocLifecycleStatusText
_ServiceDocBillingStatusText _ServiceDocBillingStatusText
_SrvcDocTransferStatusText _SrvcDocTransferStatusText
_SrvcDocRejectionStatusText _SrvcDocRejectionStatusText
_BillingBlockReasonText _BillingBlockReasonText
_PaymentTermsText _PaymentTermsText
_ServiceDocItemCategoryText _ServiceDocItemCategoryText
_UnitOfMeasureText _UnitOfMeasureText
_CurrencyText _CurrencyText
_SrvcMgmtDateRuleText _SrvcMgmtDateRuleText
_SettlementPeriodRuleText _SettlementPeriodRuleText
_ServiceCancellationPartyText _ServiceCancellationPartyText
_ServiceCanclnReasonText _ServiceCanclnReasonText

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 I_ServiceContractItemTP.
-- 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 I_ServiceContractItemTP AS
SELECT
  ServiceContract,
  ServiceContractItem,
  ServiceObjectType,
  ServiceContractItemCategory,
  ServiceContractItemUUID,
  ServiceContractItemDescription,
  Language,
  ServiceDocItemCreationDateTime,
  ServiceDocItemChangedDateTime,
  ServiceDocItemCreatedByUser,
  ServiceDocItemChangedByUser,
  Product,
  Quantity,
  QuantityUnit,
  SoldToParty,
  ShipToParty,
  BillToParty,
  PayerParty,
  ContactPersonBusinessPartnerId,
  RespEmployeeBusinessPartnerId,
  ServiceContractItemIsNew,
  ServiceContractItemIsInProcess,
  ServiceContractItemIsReleased,
  ServiceContractItemIsCompleted,
  ServiceContractItemStatus,
  ServiceContrItemBillingStatus,
  ServiceContractItemIsRejected,
  ServiceContractItemHasError,
  SrvcDocItemTransferStatus,
  ServiceContrItemStartDateTime,
  ServiceContrItemEndDateTime,
  SrvcContrItemRnwlDuration,
  SrvcContrItemRnwlDurationUnit,
  SrvcContrItemExtensionDuration,
  SrvcContrItemExtnDurationUnit,
  ServiceDocItemGrossAmount,
  ServiceDocumentItemNetAmount,
  ServiceDocumentItemTaxAmount,
  TransactionCurrency,
  ServiceContractItemCanclnParty,
  ServiceContractItmCanclnReason,
  SettlementPeriodRuleUUID,
  SettlementPeriodRule,
  BillingPlanBillingDateRuleUUID,
  SrvcMgmtBillgPlanBillgDateRule,
  BillingBlockReason,
  PaymentTerms,
  PaymentMethod,
  SrvcContrExternalReference,
  SrvcContrItmExternalReference,
  ServiceQtanExtReference,
  ServiceQtanItemExtReference,
  PurchaseOrderByCustomer
FROM R_ServiceContractItemTP
;

Learn More