I_SrvcContrItemSituationAnchor

DDL: I_SRVCCONTRITEMSITUATIONANCHOR SQL: ISRVCCONTRITMSI Type: view COMPOSITE
37 Fields 1 Data Sources 1 Associations

Service Contract Items Situation Anchor

I_SrvcContrItemSituationAnchor is a Composite CDS View that provides data about "Service Contract Items Situation Anchor" in SAP S/4HANA. It reads from 1 data source (I_ServiceDocumentItemEnhcd) and exposes 37 fields with key fields ServiceContract, ServiceObjectType, ServiceContractItem. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_ServiceDocumentItemEnhcd I_ServiceDocumentItemEnhcd from

Associations (1)

CardinalityTargetAliasCondition
[1] I_PersonWorkAgreement_1 _ResponsibleEmployee $projection.RespEmployeeBusinessPartnerId = _ResponsibleEmployee.Person

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName ISRVCCONTRITMSI view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
AccessControl.authorizationCheck #CHECK view
ObjectModel.representativeKey ServiceContractItem view
ObjectModel.uniqueIdField ServiceDocumentItemUUID view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XXL view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Service Contract Items Situation Anchor view

Fields (37)

KeyFieldSource TableSource FieldDescription
KEY ServiceContract ServiceDocument Transaction ID
KEY ServiceObjectType ServiceObjectType Object Type
KEY ServiceContractItem ServiceDocumentItem Service Document
ServiceDocumentType ServiceDocumentType Transaction Type
ServiceDocumentDescription ServiceDocumentDescription
ServiceContractItemStartDate ServiceContractItemStartDate Start Date
ServiceContractItemEndDate ServiceContractItemEndDate End Date
ServiceContractItemUUID ServiceDocumentItemUUID
ServiceDocumentItemIsReleased ServiceDocumentItemIsReleased
TransactionCurrency TransactionCurrency Transaction Currency
ServiceDocumentItemNetAmount ServiceDocumentItemNetAmount
RespEmployeeBusinessPartnerId ResponsibleEmployee Employee Resp.
ResponsibleEmployeeUserID
SalesOrganization SalesOrganization Sales Organization
DistributionChannel DistributionChannel RefDistCh-Cust/Mat.
Division Division Internal Division ID
SalesOffice SalesOffice Sales Office
SalesGroup SalesGroup Sales Group
SalesOrganizationOrgUnitID SalesOrganizationOrgUnitID
SalesOfficeOrgUnitID SalesOfficeOrgUnitID
SalesGroupOrgUnitID SalesGroupOrgUnitID
ServiceOrganization ServiceOrganization
_ResponsibleEmployee _ResponsibleEmployee
_ServiceDocument _ServiceDocument
_ServiceObjType _ServiceObjType
_ServiceDocumentType _ServiceDocumentType
_RespEmployee _RespEmployee
_SalesOrganization _SalesOrganization
_DistributionChannel _DistributionChannel
_Division _Division
_SalesOffice _SalesOffice
_SalesGroup _SalesGroup
_SalesOrganizationOrgUnit_2 _SalesOrganizationOrgUnit_2
_SalesOfficeOrgUnit_2 _SalesOfficeOrgUnit_2
_SalesGroupOrgUnit_2 _SalesGroupOrgUnit_2
_ServiceOrganizationOrgUnit_2 _ServiceOrganizationOrgUnit_2
_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 I_SrvcContrItemSituationAnchor.
-- 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.
-- SQL view name: ISRVCCONTRITMSI

CREATE VIEW I_SrvcContrItemSituationAnchor AS
SELECT
  ServiceDocument AS ServiceContract,
  ServiceObjectType,
  ServiceDocumentItem AS ServiceContractItem,
  ServiceDocumentType,
  ServiceDocumentDescription,
  ServiceContractItemStartDate,
  ServiceContractItemEndDate,
  ServiceDocumentItemUUID AS ServiceContractItemUUID,
  ServiceDocumentItemIsReleased,
  TransactionCurrency,
  ServiceDocumentItemNetAmount,
  ResponsibleEmployee AS RespEmployeeBusinessPartnerId,
  cast ( _ResponsibleEmployee._WorkforcePerson._BusinessUser.UserID as resp_empl_userid ) AS ResponsibleEmployeeUserID,
  SalesOrganization,
  DistributionChannel,
  Division,
  SalesOffice,
  SalesGroup,
  SalesOrganizationOrgUnitID,
  SalesOfficeOrgUnitID,
  SalesGroupOrgUnitID,
  ServiceOrganization
FROM I_ServiceDocumentItemEnhcd
LEFT OUTER JOIN I_PersonWorkAgreement_1 AS _ResponsibleEmployee ON RespEmployeeBusinessPartnerId = _ResponsibleEmployee.Person  -- association [1]
;

Learn More