I_SrvcSettlmtHierarchyDocument

DDL: I_SRVCSETTLMTHIERARCHYDOCUMENT Type: view_entity COMPOSITE
12 Fields 3 Data Sources 1 Associations

Settlement docs in Servc Hier

I_SrvcSettlmtHierarchyDocument is a Composite CDS View that provides data about "Settlement docs in Servc Hier" in SAP S/4HANA. It reads from 3 data sources (I_ServiceDocument, I_ServiceDocumentItem, I_SrvcSettlmtHierSrvcDocument) and exposes 12 fields with key fields CompanyCode, Customer, ServiceDocument, ServiceDocumentItem. It has 1 association to related views.

Data Sources (3)

SourceAliasJoin Type
I_ServiceDocument _ServiceHeader inner
I_ServiceDocumentItem _ServiceItem inner
I_SrvcSettlmtHierSrvcDocument _ServiceRoot from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_CtrlgSettlmtDocumentTotal _Settlement _ServiceRoot.ServiceRootControllingObject = _Settlement.ControllingObject and _Actual.ControllingKeySubNumber = _Settlement.ControllingKeySubNumber

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label Settlement docs in Servc 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 (12)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_SrvcSettlmtHierSrvcDocument CompanyCode Receiver Company Code
KEY Customer I_SrvcSettlmtHierSrvcDocument Customer Sold-to Party
KEY ServiceDocument I_SrvcSettlmtHierSrvcDocument ServiceDocument Transaction ID
KEY ServiceDocumentItem I_SrvcSettlmtHierSrvcDocument ServiceDocumentItem Service Document
ControllingArea I_SrvcSettlmtHierSrvcDocument ControllingArea Controlling Area
ServiceRootControllingObject I_SrvcSettlmtHierSrvcDocument ServiceRootControllingObject
Ledger _Actual SourceLedger Source Ledger
ControllingKeySubNumber _Actual ControllingKeySubNumber
BalanceTransactionCurrency _Actual BalanceTransactionCurrency Currency
curr232endasAmountInBalanceTransacCrcy
ControllingAreaCurrency _Settlement ControllingAreaCurrency
TotalAmountInCtrlgAreaCrcy _Settlement TotalAmountInCtrlgAreaCrcy

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_SrvcSettlmtHierarchyDocument.
-- 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_SrvcSettlmtHierarchyDocument AS
SELECT
  _ServiceRoot.CompanyCode AS CompanyCode,
  _ServiceRoot.Customer AS Customer,
  _ServiceRoot.ServiceDocument AS ServiceDocument,
  _ServiceRoot.ServiceDocumentItem AS ServiceDocumentItem,
  _ServiceRoot.ControllingArea AS ControllingArea,
  _ServiceRoot.ServiceRootControllingObject AS ServiceRootControllingObject,
  _Actual.SourceLedger AS Ledger,
  _Actual.ControllingKeySubNumber AS ControllingKeySubNumber,
  _Actual.BalanceTransactionCurrency AS BalanceTransactionCurrency,
  sum (case when _CoVer.CtrlgCrcyTotAmtUnivJrnlFld = 'HSL' then _Actual.AmountInCompanyCodeCurrency when _CoVer.CtrlgCrcyTotAmtUnivJrnlFld = 'OSL' then _Actual.AmountInFreeDefinedCurrency1 when _CoVer.CtrlgCrcyTotAmtUnivJrnlFld = 'KSL' then _Actual.AmountInGlobalCurrency when _CoVer.CtrlgCrcyTotAmtUnivJrnlFld = 'VSL' then _Actual.AmountInFreeDefinedCurrency2 when _CoVer.CtrlgCrcyTotAmtUnivJrnlFld = 'BSL' then _Actual.AmountInFreeDefinedCurrency3 when _CoVer.CtrlgCrcyTotAmtUnivJrnlFld = 'CSL' then _Actual.AmountInFreeDefinedCurrency4 when _CoVer.CtrlgCrcyTotAmtUnivJrnlFld = 'DSL' then _Actual.AmountInFreeDefinedCurrency5 when _CoVer.CtrlgCrcyTotAmtUnivJrnlFld = 'ESL' then _Actual.AmountInFreeDefinedCurrency6 when _CoVer.CtrlgCrcyTotAmtUnivJrnlFld = 'FSL' then _Actual.AmountInFreeDefinedCurrency7 when _CoVer.CtrlgCrcyTotAmtUnivJrnlFld = 'GSL' then _Actual.AmountInFreeDefinedCurrency8 else cast( 0 as abap.curr( 23, 2 ) ) end ) as AmountInBalanceTransacCrcy AS curr232endasAmountInBalanceTransacCrcy,
  _Settlement.ControllingAreaCurrency AS ControllingAreaCurrency,
  _Settlement.TotalAmountInCtrlgAreaCrcy AS TotalAmountInCtrlgAreaCrcy
FROM I_SrvcSettlmtHierSrvcDocument AS _ServiceRoot
INNER JOIN I_ServiceDocument AS _ServiceHeader ON /* join condition not captured in parsed metadata */
INNER JOIN I_ServiceDocumentItem AS _ServiceItem ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_CtrlgSettlmtDocumentTotal AS _Settlement ON _ServiceRoot.ServiceRootControllingObject = _Settlement.ControllingObject AND _Actual.ControllingKeySubNumber = _Settlement.ControllingKeySubNumber  -- association [0..*]
;

Learn More