R_ServiceContractItemTP

DDL: R_SERVICECONTRACTITEMTP Type: view_entity TRANSACTIONAL
121 Fields 1 Data Sources 26 Associations

Service Contract Item - TP

R_ServiceContractItemTP is a Transactional CDS View that provides data about "Service Contract Item - TP" in SAP S/4HANA. It reads from 1 data source (I_ServiceDocumentItemEnhcd) and exposes 121 fields with key fields ServiceContract, ServiceContractItem. It has 26 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_ServiceDocumentItemEnhcd I_ServiceDocumentItemEnhcd from

Associations (26)

CardinalityTargetAliasCondition
[0..1] I_StatusObjectUUIDStatus _SrvcOrdItmStatus $projection.ServiceContractItemUUID = _SrvcOrdItmStatus.StatusObjectUUID and ( _SrvcOrdItmStatus.StatusCode = 'I1002' or _SrvcOrdItmStatus.StatusCode = 'I1003' or _SrvcOrdItmStatus.StatusCode = 'I1004' or _SrvcOrdItmStatus.StatusCode = 'I1005' ) and _SrvcOrdItmStatus.StatusIsActive = 'X'
[0..1] I_CustMgmtExtRefID _ExtRefServiceContract _ExtRefServiceContract.CustMgmtObjectType = 'BUS2000112' and $projection.ServiceContract = _ExtRefServiceContract.CustMgmtDocument and _ExtRefServiceContract.CustMgmtExtRefIDType = '0003'
[0..1] I_CustMgmtExtRefID _ExtRefServiceContractItem _ExtRefServiceContractItem.CustMgmtObjectType = 'BUS2000112' and $projection.ServiceContract = _ExtRefServiceContractItem.CustMgmtDocument and $projection.ServiceContractItem = _ExtRefServiceContractItem.CustMgmtDocumentItem and _ExtRefServiceContractItem.CustMgmtExtRefIDType = '0004'
[0..1] I_CustMgmtExtRefID _ExtRefServiceQtan _ExtRefServiceQtan.CustMgmtObjectType = 'BUS2000112' and $projection.ServiceContract = _ExtRefServiceQtan.CustMgmtDocument and _ExtRefServiceQtan.CustMgmtExtRefIDType = '0009'
[0..1] I_CustMgmtExtRefID _ExtRefServiceQtanItem _ExtRefServiceQtanItem.CustMgmtObjectType = 'BUS2000112' and $projection.ServiceContract = _ExtRefServiceQtanItem.CustMgmtDocument and $projection.ServiceContractItem = _ExtRefServiceQtanItem.CustMgmtDocumentItem and _ExtRefServiceQtanItem.CustMgmtExtRefIDType = '0010'
[0..1] I_CustMgmtExtRefID _ExtRefLegalContract _ExtRefLegalContract.CustMgmtObjectType = 'BUS2000112' and $projection.ServiceContract = _ExtRefLegalContract.CustMgmtDocument and _ExtRefLegalContract.CustMgmtExtRefIDType = '0021'
[0..1] I_CustMgmtExtRefID _ExtRefLegalContractItem _ExtRefLegalContractItem.CustMgmtObjectType = 'BUS2000112' and $projection.ServiceContract = _ExtRefLegalContractItem.CustMgmtDocument and $projection.ServiceContractItem = _ExtRefLegalContractItem.CustMgmtDocumentItem and _ExtRefLegalContractItem.CustMgmtExtRefIDType = '0022'
[0..1] R_SrvcDocItemDocumentFlow _RefServiceTemplate $projection.ServiceContract = _RefServiceTemplate.ServiceDocument and $projection.ServiceContractItem = _RefServiceTemplate.ServiceDocumentItem and _RefServiceTemplate.PrdcssrSuccssrDocObjectType = 'BUS2000112' and _RefServiceTemplate.ServiceDocumentTemplateType is not initial and _RefServiceTemplate.ServiceObjectType = 'BUS2000112'
[0..1] I_CustMgmtDateRule _SettlementPeriodRule $projection.SettlementPeriodRuleUUID = _SettlementPeriodRule.CustMgmtDateRuleUUID
[0..1] I_CustMgmtDateRule _BillingPlanBillingDateRule $projection.BillingPlanBillingDateRuleUUID = _BillingPlanBillingDateRule.CustMgmtDateRuleUUID
[0..1] I_PaymentMethodInCountryVH _PaymentMethodVH $projection.PaymentMethod = _PaymentMethodVH.PaymentMethod and $projection.SoldToPartyCountry = _PaymentMethodVH.Country
[0..1] I_ServiceDocumentItemEnhcd _ServiceContractItemStartDate $projection.ServiceContractItemStartDate = _ServiceContractItemStartDate.ServiceContractItemStartDate
[0..1] I_ServiceDocumentItemEnhcd _ServiceContractItemEndDate $projection.ServiceContractItemEndDate = _ServiceContractItemEndDate.ServiceContractItemEndDate
[0..1] I_WBSElementBasicData _WBSElement _WBSElement.WBSElementInternalID = I_ServiceDocumentItemEnhcd.WBSElementInternalID
[0..1] E_ServiceDocumentItem _Extension $projection.ServiceObjectType = _Extension.ServiceCategory and $projection.ServiceContract = _Extension.ServiceOrderItem and $projection.ServiceContractItem = _Extension.ServiceLineExternalID
[0..*] R_SrvcContrItemPartnerTP _SrvcContrItmPartnerTP
[0..*] R_SrvcContrItemPriceElementTP _SrvcContrItmPriceElementTP
[0..*] R_SrvcContrItemUserStatusTP _SrvcContrItemUserStatusTP
[0..*] R_SrvcContrItmFUPBillgDocTP _SrvcContrItmFUPBillgDocTP
[0..*] R_SrvcContrItmFUPSrvcOrdTP _SrvcContrItmFUPSrvcOrdTP
[0..*] R_SrvcContrItemRefObjectTP _SrvcContrItemRefObjectTP
[0..*] R_SrvcContrItemProductTP _SrvcContrItemProductTP
[0..*] R_SrvcContrItmBillgReqItemTP _SrvcContrItmBillgReqItemTP
[0..*] R_SrvcContrItemDurationTP _SrvcContrItemDurationTP
[0..*] R_SrvcContrItemAppointmentTP _SrvcContrItemAppointmentTP
[0..*] R_SrvcContrItemLongTextTP _SrvcContrItemLongTextTP

Annotations (9)

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

Fields (121)

KeyFieldSource TableSource FieldDescription
KEY ServiceContract ServiceDocument Transaction ID
KEY ServiceContractItem Service Document
ServiceContractDescription ServiceDocumentDescription
ServiceObjectType ServiceObjectType Object Type
ParentServiceContractItem _ParentServiceDocItem_2 ServiceDocumentItem Service Document
ServiceContractItemCategory ServiceDocItemCategory
ServiceContractItemUUID ServiceDocumentItemUUID
ServiceContractItemDescription ServiceDocumentItemDescription
Language Language Report Text Language
ServiceDocItemCreationDateTime ServiceDocItemCreationDateTime
ServiceDocItemChangedDateTime ServiceDocItemChangedDateTime
ServiceDocItemCreatedByUser ServiceDocItemCreatedByUser
ServiceDocItemChangedByUser ServiceDocItemChangedByUser
Product Product Product Sold
Quantity ServiceDocumentItemQuantity
QuantityUnit ServiceDocItemQuantityUnit
SoldToParty SoldToParty Sold-to Party
ShipToParty ShipToParty Ship-To Party (obsolete)
BillToParty BillToParty Inv. Recipient
PayerParty PayerParty Payer
ContactPersonBusinessPartnerId ContactPerson Contact Person Key
RespEmployeeBusinessPartnerId ResponsibleEmployee Employee Resp.
SoldToPartyCountry SoldToPartyCountry
PaymentTerms PaymentTerms Pyt Terms
PaymentMethod PaymentMethod Pymt Meth.
SEPAMandate SEPAMandate SEPA Mandate
SrvcSEPAMandateRelevance SrvcSEPAMandateRelevance
SalesOrganization SalesOrganization Sales Organization
DistributionChannel DistributionChannel RefDistCh-Cust/Mat.
Division Division Internal Division ID
SalesOffice SalesOffice Sales Office
SalesGroup SalesGroup Sales Group
SalesOrganizationOrgUnitID SalesOrganizationOrgUnitID
ServiceContractItemStatus ServiceDocumentItemStatus
ServiceContrItemBillingStatus ServiceDocItemBillingStatus
ServiceContractItemIsRejected ServiceDocumentItemIsRejected
ServiceContractItemHasError ServiceDocumentItemHasError
SrvcDocItemTransferStatus SrvcDocItemTransferStatus
SrvcContrItemCreditStatus SrvcDocItemCreditStatus
SrvcDocItmGTSEmbargoStatus SrvcDocItmGTSEmbargoStatus
SrvcDocItmGTSScreeningStatus SrvcDocItmGTSScreeningStatus
SrvcDocItmGTSLglControlStatus SrvcDocItmGTSLglControlStatus
ServiceContrItemStartDateTime ServiceContrItemStartDateTime
ServiceContrItemEndDateTime ServiceContrItemEndDateTime
SrvcContrItemRnwlDuration SrvcContrItemRnwlDuration
SrvcContrItemRnwlDurationUnit SrvcContrItemRnwlDurationUnit
SrvcContrItemExtensionDuration SrvcContrItemExtensionDuration
SrvcContrItemExtnDurationUnit SrvcContrItemExtnDurationUnit
ResponseProfile ResponseProfile Response Prof.
ServiceProfile ServiceProfile Service Profile
ProfitCenter ProfitCenter Profit Center
ServiceDocItemGrossAmount ServiceDocItemGrossAmount
ServiceDocumentItemNetAmount ServiceDocumentItemNetAmount
ServiceDocumentItemTaxAmount ServiceDocumentItemTaxAmount
TransactionCurrency TransactionCurrency Transaction Currency
ServiceContractItemCanclnParty ServiceDocumentItemCanclnParty
ServiceContractItmCanclnReason ServiceDocumentItmCanclnReason
SettlementPeriodRuleUUID SettlementPeriodRuleUUID
SettlementPeriodRule _SettlementPeriodRule CustMgmtDateRuleName
BillingPlanBillingDateRuleUUID BillingPlanBillingDateRuleUUID
SrvcMgmtBillgPlanBillgDateRule _BillingPlanBillingDateRule CustMgmtDateRuleName
BillingBlockReason BillingBlockReason
BillingPlanPriceDateRule BillingPlanPriceDateRule
BillingPlanIsFinalized BillingPlanIsFinalized Bill.Plan Finalized
ContractAccount ContractAccount Contract Acct
SrvcContrExternalReference _ExtRefServiceContract CustMgmtExtRefID
SrvcContrItmExternalReference _ExtRefServiceContractItem CustMgmtExtRefID
ServiceQtanExtReference _ExtRefServiceQtan CustMgmtExtRefID
ServiceQtanItemExtReference _ExtRefServiceQtanItem CustMgmtExtRefID
LegalContractExtReference _ExtRefLegalContract CustMgmtExtRefID
LegalContractItemExtReference _ExtRefLegalContractItem CustMgmtExtRefID
RefServiceContractTemplate
RefServiceContractTemplateItem
SrvcDocItmPartReferenceItem SrvcDocItmPartReferenceItem
SrvcDocItmApptRefObjectUUID SrvcDocItmApptRefObjectUUID
WBSElementExternalID _WBSElement WBSElementExternalID WBS Element External ID
_ServiceDocument _ServiceDocument
_ServiceContractTP _ServiceContractTP
_SrvcContrItmPartnerTP _SrvcContrItmPartnerTP
_SrvcContrItmPriceElementTP _SrvcContrItmPriceElementTP
_SrvcContrItemUserStatusTP _SrvcContrItemUserStatusTP
_SrvcDocItmGTSEmbargoStatus _SrvcDocItmGTSEmbargoStatus
_SrvcDocItmGTSScreeningStatus _SrvcDocItmGTSScreeningStatus
_SrvcDocItmGTSLglControlStatus _SrvcDocItmGTSLglControlStatus
_ServiceObjType _ServiceObjType
_ExtRefServiceContract _ExtRefServiceContract
_ExtRefServiceContractItem _ExtRefServiceContractItem
_Product _Product
_ContactPerson _ContactPerson
_RespEmployee _RespEmployee
_PaymentTerms _PaymentTerms
_PaymentMethod _PaymentMethod
_PaymentMethodVH _PaymentMethodVH
_SrvcSEPAMandateRelevance _SrvcSEPAMandateRelevance
_SrvcContrItmFUPBillgDocTP _SrvcContrItmFUPBillgDocTP
_SrvcContrItmFUPSrvcOrdTP _SrvcContrItmFUPSrvcOrdTP
_SrvcContrItemRefObjectTP _SrvcContrItemRefObjectTP
_SrvcContrItemProductTP _SrvcContrItemProductTP
_SrvcContrItmBillgReqItemTP _SrvcContrItmBillgReqItemTP
_SrvcContrItemDurationTP _SrvcContrItemDurationTP
_SrvcContrItemAppointmentTP _SrvcContrItemAppointmentTP
_SrvcContrItemLongTextTP _SrvcContrItemLongTextTP
_BaseUnit _BaseUnit
_SrvcContrItemExtnDurationUnit _SrvcContrItemExtnDurationUnit
_SrvcContrItemRnwlDurationUnit _SrvcContrItemRnwlDurationUnit
_ServiceContractItemStartDate _ServiceContractItemStartDate
_ServiceContractItemEndDate _ServiceContractItemEndDate
_ServiceDocItemCategory _ServiceDocItemCategory
_SrvcDocItmLifecycleStatus _SrvcDocItmLifecycleStatus
_ServiceDocItemHasError _ServiceDocItemHasError
_SrvcDocItemCreditStatus _SrvcDocItemCreditStatus
_ServiceDocItemBillingStatus _ServiceDocItemBillingStatus
_SoldToParty _SoldToParty
_ShipToParty _ShipToParty
_BillToParty _BillToParty
_PayerParty _PayerParty
_SalesOrganization _SalesOrganization
_DistributionChannel _DistributionChannel
_Division _Division
_SalesOffice _SalesOffice
_SalesGroup _SalesGroup

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 R_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 R_ServiceContractItemTP AS
SELECT
  ServiceDocument AS ServiceContract,
  cast(ServiceDocumentItem as crms4_number_int preserving type) AS ServiceContractItem,
  ServiceDocumentDescription AS ServiceContractDescription,
  ServiceObjectType,
  _ParentServiceDocItem_2.ServiceDocumentItem AS ParentServiceContractItem,
  ServiceDocItemCategory AS ServiceContractItemCategory,
  ServiceDocumentItemUUID AS ServiceContractItemUUID,
  ServiceDocumentItemDescription AS ServiceContractItemDescription,
  Language,
  ServiceDocItemCreationDateTime,
  ServiceDocItemChangedDateTime,
  ServiceDocItemCreatedByUser,
  ServiceDocItemChangedByUser,
  Product,
  ServiceDocumentItemQuantity AS Quantity,
  ServiceDocItemQuantityUnit AS QuantityUnit,
  SoldToParty,
  ShipToParty,
  BillToParty,
  PayerParty,
  ContactPerson AS ContactPersonBusinessPartnerId,
  ResponsibleEmployee AS RespEmployeeBusinessPartnerId,
  SoldToPartyCountry,
  PaymentTerms,
  PaymentMethod,
  SEPAMandate,
  SrvcSEPAMandateRelevance,
  SalesOrganization,
  DistributionChannel,
  Division,
  SalesOffice,
  SalesGroup,
  SalesOrganizationOrgUnitID,
  ServiceDocumentItemStatus AS ServiceContractItemStatus,
  ServiceDocItemBillingStatus AS ServiceContrItemBillingStatus,
  ServiceDocumentItemIsRejected AS ServiceContractItemIsRejected,
  ServiceDocumentItemHasError AS ServiceContractItemHasError,
  SrvcDocItemTransferStatus,
  SrvcDocItemCreditStatus AS SrvcContrItemCreditStatus,
  SrvcDocItmGTSEmbargoStatus,
  SrvcDocItmGTSScreeningStatus,
  SrvcDocItmGTSLglControlStatus,
  ServiceContrItemStartDateTime,
  ServiceContrItemEndDateTime,
  SrvcContrItemRnwlDuration,
  SrvcContrItemRnwlDurationUnit,
  SrvcContrItemExtensionDuration,
  SrvcContrItemExtnDurationUnit,
  ResponseProfile,
  ServiceProfile,
  ProfitCenter,
  ServiceDocItemGrossAmount,
  ServiceDocumentItemNetAmount,
  ServiceDocumentItemTaxAmount,
  TransactionCurrency,
  ServiceDocumentItemCanclnParty AS ServiceContractItemCanclnParty,
  ServiceDocumentItmCanclnReason AS ServiceContractItmCanclnReason,
  SettlementPeriodRuleUUID,
  _SettlementPeriodRule.CustMgmtDateRuleName AS SettlementPeriodRule,
  BillingPlanBillingDateRuleUUID,
  _BillingPlanBillingDateRule.CustMgmtDateRuleName AS SrvcMgmtBillgPlanBillgDateRule,
  BillingBlockReason,
  BillingPlanPriceDateRule,
  BillingPlanIsFinalized,
  ContractAccount,
  _ExtRefServiceContract.CustMgmtExtRefID AS SrvcContrExternalReference,
  _ExtRefServiceContractItem.CustMgmtExtRefID AS SrvcContrItmExternalReference,
  _ExtRefServiceQtan.CustMgmtExtRefID AS ServiceQtanExtReference,
  _ExtRefServiceQtanItem.CustMgmtExtRefID AS ServiceQtanItemExtReference,
  _ExtRefLegalContract.CustMgmtExtRefID AS LegalContractExtReference,
  _ExtRefLegalContractItem.CustMgmtExtRefID AS LegalContractItemExtReference,
  cast( _RefServiceTemplate.CustMgmtPrdcssrTransactionKey as crmt_object_id_db ) AS RefServiceContractTemplate,
  cast( _RefServiceTemplate.BusinessTransactionDocItem as crms4_number_int ) AS RefServiceContractTemplateItem,
  SrvcDocItmPartReferenceItem,
  SrvcDocItmApptRefObjectUUID,
  _WBSElement.WBSElementExternalID AS WBSElementExternalID
FROM I_ServiceDocumentItemEnhcd
LEFT OUTER JOIN I_StatusObjectUUIDStatus AS _SrvcOrdItmStatus ON ServiceContractItemUUID = _SrvcOrdItmStatus.StatusObjectUUID AND ( _SrvcOrdItmStatus.StatusCode = 'I1002' OR _SrvcOrdItmStatus.StatusCode = 'I1003' OR _SrvcOrdItmStatus.StatusCode = 'I1004' OR _SrvcOrdItmStatus.StatusCode = 'I1005' ) AND _SrvcOrdItmStatus.StatusIsActive = 'X'  -- association [0..1]
LEFT OUTER JOIN I_CustMgmtExtRefID AS _ExtRefServiceContract ON _ExtRefServiceContract.CustMgmtObjectType = 'BUS2000112' AND ServiceContract = _ExtRefServiceContract.CustMgmtDocument AND _ExtRefServiceContract.CustMgmtExtRefIDType = '0003'  -- association [0..1]
LEFT OUTER JOIN I_CustMgmtExtRefID AS _ExtRefServiceContractItem ON _ExtRefServiceContractItem.CustMgmtObjectType = 'BUS2000112' AND ServiceContract = _ExtRefServiceContractItem.CustMgmtDocument AND ServiceContractItem = _ExtRefServiceContractItem.CustMgmtDocumentItem AND _ExtRefServiceContractItem.CustMgmtExtRefIDType = '0004'  -- association [0..1]
LEFT OUTER JOIN I_CustMgmtExtRefID AS _ExtRefServiceQtan ON _ExtRefServiceQtan.CustMgmtObjectType = 'BUS2000112' AND ServiceContract = _ExtRefServiceQtan.CustMgmtDocument AND _ExtRefServiceQtan.CustMgmtExtRefIDType = '0009'  -- association [0..1]
LEFT OUTER JOIN I_CustMgmtExtRefID AS _ExtRefServiceQtanItem ON _ExtRefServiceQtanItem.CustMgmtObjectType = 'BUS2000112' AND ServiceContract = _ExtRefServiceQtanItem.CustMgmtDocument AND ServiceContractItem = _ExtRefServiceQtanItem.CustMgmtDocumentItem AND _ExtRefServiceQtanItem.CustMgmtExtRefIDType = '0010'  -- association [0..1]
LEFT OUTER JOIN I_CustMgmtExtRefID AS _ExtRefLegalContract ON _ExtRefLegalContract.CustMgmtObjectType = 'BUS2000112' AND ServiceContract = _ExtRefLegalContract.CustMgmtDocument AND _ExtRefLegalContract.CustMgmtExtRefIDType = '0021'  -- association [0..1]
LEFT OUTER JOIN I_CustMgmtExtRefID AS _ExtRefLegalContractItem ON _ExtRefLegalContractItem.CustMgmtObjectType = 'BUS2000112' AND ServiceContract = _ExtRefLegalContractItem.CustMgmtDocument AND ServiceContractItem = _ExtRefLegalContractItem.CustMgmtDocumentItem AND _ExtRefLegalContractItem.CustMgmtExtRefIDType = '0022'  -- association [0..1]
LEFT OUTER JOIN R_SrvcDocItemDocumentFlow AS _RefServiceTemplate ON ServiceContract = _RefServiceTemplate.ServiceDocument AND ServiceContractItem = _RefServiceTemplate.ServiceDocumentItem AND _RefServiceTemplate.PrdcssrSuccssrDocObjectType = 'BUS2000112' AND _RefServiceTemplate.ServiceDocumentTemplateType is not initial AND _RefServiceTemplate.ServiceObjectType = 'BUS2000112'  -- association [0..1]
LEFT OUTER JOIN I_CustMgmtDateRule AS _SettlementPeriodRule ON SettlementPeriodRuleUUID = _SettlementPeriodRule.CustMgmtDateRuleUUID  -- association [0..1]
LEFT OUTER JOIN I_CustMgmtDateRule AS _BillingPlanBillingDateRule ON BillingPlanBillingDateRuleUUID = _BillingPlanBillingDateRule.CustMgmtDateRuleUUID  -- association [0..1]
LEFT OUTER JOIN I_PaymentMethodInCountryVH AS _PaymentMethodVH ON PaymentMethod = _PaymentMethodVH.PaymentMethod AND SoldToPartyCountry = _PaymentMethodVH.Country  -- association [0..1]
LEFT OUTER JOIN I_ServiceDocumentItemEnhcd AS _ServiceContractItemStartDate ON ServiceContractItemStartDate = _ServiceContractItemStartDate.ServiceContractItemStartDate  -- association [0..1]
LEFT OUTER JOIN I_ServiceDocumentItemEnhcd AS _ServiceContractItemEndDate ON ServiceContractItemEndDate = _ServiceContractItemEndDate.ServiceContractItemEndDate  -- association [0..1]
LEFT OUTER JOIN I_WBSElementBasicData AS _WBSElement ON _WBSElement.WBSElementInternalID = I_ServiceDocumentItemEnhcd.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN E_ServiceDocumentItem AS _Extension ON ServiceObjectType = _Extension.ServiceCategory AND ServiceContract = _Extension.ServiceOrderItem AND ServiceContractItem = _Extension.ServiceLineExternalID  -- association [0..1]
LEFT OUTER JOIN R_SrvcContrItemPartnerTP AS _SrvcContrItmPartnerTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_SrvcContrItemPriceElementTP AS _SrvcContrItmPriceElementTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_SrvcContrItemUserStatusTP AS _SrvcContrItemUserStatusTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_SrvcContrItmFUPBillgDocTP AS _SrvcContrItmFUPBillgDocTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_SrvcContrItmFUPSrvcOrdTP AS _SrvcContrItmFUPSrvcOrdTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_SrvcContrItemRefObjectTP AS _SrvcContrItemRefObjectTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_SrvcContrItemProductTP AS _SrvcContrItemProductTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_SrvcContrItmBillgReqItemTP AS _SrvcContrItmBillgReqItemTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_SrvcContrItemDurationTP AS _SrvcContrItemDurationTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_SrvcContrItemAppointmentTP AS _SrvcContrItemAppointmentTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN R_SrvcContrItemLongTextTP AS _SrvcContrItemLongTextTP ON /* condition not available in parsed metadata */  -- association [0..*]
;

Learn More