I_SrvcHierUnsettledDocument

DDL: I_SRVCHIERUNSETTLEDDOCUMENT Type: view_entity COMPOSITE
22 Fields 2 Data Sources

Unsettled docs under Service Hier

I_SrvcHierUnsettledDocument is a Composite CDS View that provides data about "Unsettled docs under Service Hier" in SAP S/4HANA. It reads from 2 data sources (I_SrvcSettlmtHierarchyDocument, I_SrvcSettlmtHierarchyRoot) and exposes 22 fields with key fields CompanyCode, Customer, ServiceDocument, ServiceDocumentItem.

Data Sources (2)

SourceAliasJoin Type
I_SrvcSettlmtHierarchyDocument _ServiceHierarchy from
I_SrvcSettlmtHierarchyRoot _ServiceRoot inner

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label Unsettled docs under Service Hier view
VDM.viewType #COMPOSITE view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MIXED view

Fields (22)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_SrvcSettlmtHierarchyDocument CompanyCode Receiver Company Code
KEY Customer I_SrvcSettlmtHierarchyDocument Customer Sold-to Party
KEY ServiceDocument I_SrvcSettlmtHierarchyDocument ServiceDocument Transaction ID
KEY ServiceDocumentItem I_SrvcSettlmtHierarchyDocument ServiceDocumentItem Service Document
ControllingArea I_SrvcSettlmtHierarchyDocument ControllingArea Controlling Area
ServiceDocumentType I_SrvcSettlmtHierarchyRoot ServiceDocumentType Transaction Type
ServiceDocumentTypeName I_SrvcSettlmtHierarchyRoot ServiceDocumentTypeName
ServiceRootControllingObject I_SrvcSettlmtHierarchyDocument ServiceRootControllingObject Object number
ResultAnalysisInternalID I_SrvcSettlmtHierarchyRoot ResultAnalysisInternalID Results Analysis Key
FunctionalArea I_SrvcSettlmtHierarchyRoot FunctionalArea Sendr Fctl Area
SalesOrganization I_SrvcSettlmtHierarchyRoot SalesOrganization Sales Organization
DistributionChannel I_SrvcSettlmtHierarchyRoot DistributionChannel RefDistCh-Cust/Mat.
Division I_SrvcSettlmtHierarchyRoot Division Internal Division ID
ServiceObjectType I_SrvcSettlmtHierarchyRoot ServiceObjectType Object Type
ServiceDocumentItemObjectType I_SrvcSettlmtHierarchyRoot ServiceDocumentItemObjectType
SettlementControl I_SrvcSettlmtHierarchyRoot SettlementControl
Ledger I_SrvcSettlmtHierarchyDocument Ledger Ledger
BalanceTransactionCurrency I_SrvcSettlmtHierarchyDocument BalanceTransactionCurrency Currency
AmountInBalanceTransacCrcy
ControllingAreaCurrency I_SrvcSettlmtHierarchyDocument ControllingAreaCurrency
TotalAmountInCtrlgAreaCrcy
UnsettledAmountInTransacCrcy

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_SrvcHierUnsettledDocument.
-- 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_SrvcHierUnsettledDocument AS
SELECT
  _ServiceHierarchy.CompanyCode AS CompanyCode,
  _ServiceHierarchy.Customer AS Customer,
  _ServiceHierarchy.ServiceDocument AS ServiceDocument,
  _ServiceHierarchy.ServiceDocumentItem AS ServiceDocumentItem,
  _ServiceHierarchy.ControllingArea AS ControllingArea,
  _ServiceRoot.ServiceDocumentType AS ServiceDocumentType,
  _ServiceRoot.ServiceDocumentTypeName AS ServiceDocumentTypeName,
  _ServiceHierarchy.ServiceRootControllingObject AS ServiceRootControllingObject,
  _ServiceRoot.ResultAnalysisInternalID AS ResultAnalysisInternalID,
  _ServiceRoot.FunctionalArea AS FunctionalArea,
  _ServiceRoot.SalesOrganization AS SalesOrganization,
  _ServiceRoot.DistributionChannel AS DistributionChannel,
  _ServiceRoot.Division AS Division,
  _ServiceRoot.ServiceObjectType AS ServiceObjectType,
  _ServiceRoot.ServiceDocumentItemObjectType AS ServiceDocumentItemObjectType,
  _ServiceRoot.SettlementControl AS SettlementControl,
  _ServiceHierarchy.Ledger AS Ledger,
  _ServiceHierarchy.BalanceTransactionCurrency AS BalanceTransactionCurrency,
  sum(_ServiceHierarchy.AmountInBalanceTransacCrcy) AS AmountInBalanceTransacCrcy,
  _ServiceHierarchy.ControllingAreaCurrency AS ControllingAreaCurrency,
  sum(_ServiceHierarchy.TotalAmountInCtrlgAreaCrcy) AS TotalAmountInCtrlgAreaCrcy,
  sum(_ServiceHierarchy.UnsettledAmountInTransacCrcy) AS UnsettledAmountInTransacCrcy
FROM I_SrvcSettlmtHierarchyDocument AS _ServiceHierarchy
INNER JOIN I_SrvcSettlmtHierarchyRoot AS _ServiceRoot ON /* join condition not captured in parsed metadata */
;

Learn More