A_ServiceContractItem_2

DDL: A_SERVICECONTRACTITEM_2 Type: view_entity CONSUMPTION
74 Fields 1 Data Sources

Service Contract Item

A_ServiceContractItem_2 is a Consumption CDS View that provides data about "Service Contract Item" in SAP S/4HANA. It reads from 1 data source (R_ServiceContractItemTP) and exposes 74 fields with key fields ServiceContract, ServiceContractItem.

Data Sources (1)

SourceAliasJoin Type
R_ServiceContractItemTP R_ServiceContractItemTP projection

Annotations (9)

NameValueLevelField
EndUserText.label Service Contract Item view
VDM.viewType #CONSUMPTION view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
Metadata.ignorePropagatedAnnotations true view
OData.entityType.name ServiceContractItem_Type view

Fields (74)

KeyFieldSource TableSource FieldDescription
KEY ServiceContract ServiceContract Transaction ID
KEY ServiceContractItem ServiceContractItem Item Number in Doc.
ServiceContractItemCategory ServiceContractItemCategory
ServiceContractItemDescription ServiceContractItemDescription
ParentServiceContractItem ParentServiceContractItem Service Document
Language Language Report Text Language
ServiceDocItemCreationDateTime ServiceDocItemCreationDateTime
ServiceDocItemChangedDateTime ServiceDocItemChangedDateTime
ServiceDocItemCreatedByUser ServiceDocItemCreatedByUser
ServiceDocItemChangedByUser ServiceDocItemChangedByUser
Product Product Product Sold
ServiceContractItemQuantity Quantity Value
SrvcContrItemQtyUnitSAPCode QuantityUnit Unit of measure
SrvcContrItemQtyUnitISOCode _BaseUnit UnitOfMeasureISOCode
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.
PaymentTerms PaymentTerms Pyt Terms
PaymentMethod PaymentMethod Pymt Meth.
SEPAMandate SEPAMandate SEPA Mandate
SrvcSEPAMandateRelevance SrvcSEPAMandateRelevance
ServiceContractItemIsNew ServiceContractItemIsNew
ServiceContractItemIsInProcess ServiceContractItemIsInProcess
ServiceContractItemIsReleased ServiceContractItemIsReleased
ServiceContractItemIsCompleted ServiceContractItemIsCompleted
ServiceContractItemStatus ServiceContractItemStatus
ServiceContrItemBillingStatus ServiceContrItemBillingStatus
ServiceContractItemIsRejected ServiceContractItemIsRejected
ServiceContractItemHasError ServiceContractItemHasError
SrvcDocItemTransferStatus SrvcDocItemTransferStatus
SrvcDocItmGTSEmbargoStatus SrvcDocItmGTSEmbargoStatus
SrvcDocItmGTSScreeningStatus SrvcDocItmGTSScreeningStatus
SrvcDocItmGTSLglControlStatus SrvcDocItmGTSLglControlStatus
ServiceContrItemStartDateTime ServiceContrItemStartDateTime
ServiceContrItemEndDateTime ServiceContrItemEndDateTime
SrvcContrItemRnwlDuration SrvcContrItemRnwlDuration
SrvcContrItmRnwlDurnUntSAPCode SrvcContrItemRnwlDurationUnit
SrvcContrItmRnwlDurnUntISOCode _SrvcContrItemRnwlDurationUnit UnitOfMeasureISOCode
SrvcContrItemExtensionDuration SrvcContrItemExtensionDuration
SrvcContrItmExtnDurnUntSAPCode SrvcContrItemExtnDurationUnit
SrvcContrItmExtnDurnUntISOCode _SrvcContrItemExtnDurationUnit UnitOfMeasureISOCode
ResponseProfile ResponseProfile Response Prof.
ServiceProfile ServiceProfile Service Profile
ProfitCenter ProfitCenter Profit Center
ServiceDocItemGrossAmount ServiceDocItemGrossAmount
ServiceDocumentItemNetAmount ServiceDocumentItemNetAmount
ServiceDocumentItemTaxAmount ServiceDocumentItemTaxAmount
TransactionCurrency TransactionCurrency Transaction Currency
ServiceContractItemCanclnParty ServiceContractItemCanclnParty
ServiceContractItmCanclnReason ServiceContractItmCanclnReason
SrvcContrItemCanclnDateTime SrvcContrItemCanclnDateTime
SettlementPeriodRule SettlementPeriodRule
SrvcMgmtBillgPlanBillgDateRule SrvcMgmtBillgPlanBillgDateRule
BillingPlanPriceDateRule BillingPlanPriceDateRule
BillingBlockReason BillingBlockReason
BillingPlanIsFinalized BillingPlanIsFinalized Bill.Plan Finalized
ContractAccount ContractAccount Contract Acct
SrvcContrExternalReference SrvcContrExternalReference
SrvcContrItmExternalReference SrvcContrItmExternalReference
ServiceQtanExtReference ServiceQtanExtReference
ServiceQtanItemExtReference ServiceQtanItemExtReference
LegalContractExtReference LegalContractExtReference
LegalContractItemExtReference LegalContractItemExtReference
RefServiceContractTemplate RefServiceContractTemplate
RefServiceContractTemplateItem RefServiceContractTemplateItem
SalesOrganization SalesOrganization Sales Organization
DistributionChannel DistributionChannel RefDistCh-Cust/Mat.
Division Division Internal Division ID
SalesOffice SalesOffice Sales Office
SalesGroup SalesGroup Sales Group
WBSElementExternalID WBSElementExternalID WBS Element External ID

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 A_ServiceContractItem_2.
-- 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 A_ServiceContractItem_2 AS
SELECT
  ServiceContract,
  ServiceContractItem,
  ServiceContractItemCategory,
  ServiceContractItemDescription,
  ParentServiceContractItem,
  Language,
  ServiceDocItemCreationDateTime,
  ServiceDocItemChangedDateTime,
  ServiceDocItemCreatedByUser,
  ServiceDocItemChangedByUser,
  Product,
  Quantity AS ServiceContractItemQuantity,
  QuantityUnit AS SrvcContrItemQtyUnitSAPCode,
  _BaseUnit.UnitOfMeasureISOCode AS SrvcContrItemQtyUnitISOCode,
  SoldToParty,
  ShipToParty,
  BillToParty,
  PayerParty,
  ContactPersonBusinessPartnerId,
  RespEmployeeBusinessPartnerId,
  PaymentTerms,
  PaymentMethod,
  SEPAMandate,
  SrvcSEPAMandateRelevance,
  ServiceContractItemIsNew,
  ServiceContractItemIsInProcess,
  ServiceContractItemIsReleased,
  ServiceContractItemIsCompleted,
  ServiceContractItemStatus,
  ServiceContrItemBillingStatus,
  ServiceContractItemIsRejected,
  ServiceContractItemHasError,
  SrvcDocItemTransferStatus,
  SrvcDocItmGTSEmbargoStatus,
  SrvcDocItmGTSScreeningStatus,
  SrvcDocItmGTSLglControlStatus,
  ServiceContrItemStartDateTime,
  ServiceContrItemEndDateTime,
  SrvcContrItemRnwlDuration,
  SrvcContrItemRnwlDurationUnit AS SrvcContrItmRnwlDurnUntSAPCode,
  _SrvcContrItemRnwlDurationUnit.UnitOfMeasureISOCode AS SrvcContrItmRnwlDurnUntISOCode,
  SrvcContrItemExtensionDuration,
  SrvcContrItemExtnDurationUnit AS SrvcContrItmExtnDurnUntSAPCode,
  _SrvcContrItemExtnDurationUnit.UnitOfMeasureISOCode AS SrvcContrItmExtnDurnUntISOCode,
  ResponseProfile,
  ServiceProfile,
  ProfitCenter,
  ServiceDocItemGrossAmount,
  ServiceDocumentItemNetAmount,
  ServiceDocumentItemTaxAmount,
  TransactionCurrency,
  ServiceContractItemCanclnParty,
  ServiceContractItmCanclnReason,
  SrvcContrItemCanclnDateTime,
  SettlementPeriodRule,
  SrvcMgmtBillgPlanBillgDateRule,
  BillingPlanPriceDateRule,
  BillingBlockReason,
  BillingPlanIsFinalized,
  ContractAccount,
  SrvcContrExternalReference,
  SrvcContrItmExternalReference,
  ServiceQtanExtReference,
  ServiceQtanItemExtReference,
  LegalContractExtReference,
  LegalContractItemExtReference,
  RefServiceContractTemplate,
  RefServiceContractTemplateItem,
  SalesOrganization,
  DistributionChannel,
  Division,
  SalesOffice,
  SalesGroup,
  WBSElementExternalID
FROM R_ServiceContractItemTP
;

Learn More