I_SrvcDocItmGTSStatusAnchor

DDL: I_SRVCDOCITMGTSSTATUSANCHOR Type: view_entity COMPOSITE
11 Fields 1 Data Sources 1 Associations

Anchor for GTS Item Status Situation

I_SrvcDocItmGTSStatusAnchor is a Composite CDS View that provides data about "Anchor for GTS Item Status Situation" in SAP S/4HANA. It reads from 1 data source (I_ServiceDocumentItem) and exposes 11 fields with key fields ServiceObjectType, ServiceOrder, ServiceDocumentUUID, ServiceDocumentItem, ServiceDocumentItemUUID. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_ServiceDocumentItem ServOrdItem from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_ServiceDocumentTypeText _ServiceDocumentTypeText $projection.ServiceDocumentType = _ServiceDocumentTypeText.ServiceDocumentType and _ServiceDocumentTypeText.Language = $session.system_language

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.uniqueIdField ServiceDocumentItemUUID view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
EndUserText.label Anchor for GTS Item Status Situation view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY ServiceObjectType I_ServiceDocumentItem ServiceObjectType Object Type
KEY ServiceOrder I_ServiceDocumentItem ServiceDocument Transaction ID
KEY ServiceDocumentUUID I_ServiceDocumentItem ServiceDocumentUUID Object GUID
KEY ServiceDocumentItem I_ServiceDocumentItem ServiceDocumentItem Service Document
KEY ServiceDocumentItemUUID I_ServiceDocumentItem ServiceDocumentItemUUID Push ItemGU
SalesOrganization I_ServiceDocumentItem SalesOrganization Sales Organization
DistributionChannel I_ServiceDocumentItem DistributionChannel RefDistCh-Cust/Mat.
ServiceOrganization I_ServiceDocumentItem ServiceOrganization
ServiceDocumentType I_ServiceDocumentItem ServiceDocumentType Transaction Type
ServiceDocumentTypeName _ServiceDocumentTypeText ServiceDocumentTypeName
ResponsibleEmployeeUserID RespUser UserID User Name

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_SrvcDocItmGTSStatusAnchor.
-- 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_SrvcDocItmGTSStatusAnchor AS
SELECT
  ServOrdItem.ServiceObjectType AS ServiceObjectType,
  ServOrdItem.ServiceDocument AS ServiceOrder,
  ServOrdItem.ServiceDocumentUUID AS ServiceDocumentUUID,
  ServOrdItem.ServiceDocumentItem AS ServiceDocumentItem,
  ServOrdItem.ServiceDocumentItemUUID AS ServiceDocumentItemUUID,
  ServOrdItem.SalesOrganization AS SalesOrganization,
  ServOrdItem.DistributionChannel AS DistributionChannel,
  ServOrdItem.ServiceOrganization AS ServiceOrganization,
  ServOrdItem.ServiceDocumentType AS ServiceDocumentType,
  _ServiceDocumentTypeText.ServiceDocumentTypeName AS ServiceDocumentTypeName,
  RespUser.UserID AS ResponsibleEmployeeUserID
FROM I_ServiceDocumentItem AS ServOrdItem
LEFT OUTER JOIN I_ServiceDocumentTypeText AS _ServiceDocumentTypeText ON ServiceDocumentType = _ServiceDocumentTypeText.ServiceDocumentType AND _ServiceDocumentTypeText.Language = $session.system_language  -- association [1..1]
;

Learn More