I_SettlementUnitData

DDL: I_SETTLEMENTUNITDATA SQL: ISTLUNITDATA Type: view BASIC
14 Fields 1 Data Sources

ACM: Settlement Unit Data

I_SettlementUnitData is a Basic CDS View that provides data about "ACM: Settlement Unit Data" in SAP S/4HANA. It reads from 1 data source (I_SettlementUnitHeader) and exposes 14 fields with key field SettlementUnitUUID.

Data Sources (1)

SourceAliasJoin Type
I_SettlementUnitHeader SettlementHeader from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName ISTLUNITDATA view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.type #INHERITED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #BASIC view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
EndUserText.label ACM: Settlement Unit Data view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY SettlementUnitUUID I_SettlementUnitHeader SettlementUnitUUID
ContractApplicationUUID I_SettlementUnitHeader ContractApplicationUUID
ContractApplicationVersion I_SettlementUnitHeader ContractApplicationVersion
ContractNum _StlUnitItem ContractNum
ContractItem _StlUnitItem ContractItem Purchase Contract Item
SettlmtQuantity _StlUnitItem SettlmtQuantity SettlmtQuantity
SettlmtQuantityUnit _StlUnitItem SettlmtQuantityUnit Settlement Unit
SettlementCreatedOn I_SettlementUnitHeader SettlementCreatedOn
SettlmtCat I_SettlementUnitHeader SettlmtCat Settl. Category
SettlementStatusObject I_SettlementUnitHeader SettlementStatusObject
ContractQtyCancellationUUID I_SettlementUnitHeader ContractQtyCancellationUUID
SettlementType I_SettlementUnitHeader SettlementType Settlement Type
_StlUnitItem _StlUnitItem
StatusCode StatusCode Statuscode

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_SettlementUnitData.
-- 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: ISTLUNITDATA

CREATE VIEW I_SettlementUnitData AS
SELECT
  SettlementHeader.SettlementUnitUUID AS SettlementUnitUUID,
  SettlementHeader.ContractApplicationUUID AS ContractApplicationUUID,
  SettlementHeader.ContractApplicationVersion AS ContractApplicationVersion,
  _StlUnitItem.ContractNum AS ContractNum,
  _StlUnitItem.ContractItem AS ContractItem,
  _StlUnitItem.SettlmtQuantity AS SettlmtQuantity,
  _StlUnitItem.SettlmtQuantityUnit AS SettlmtQuantityUnit,
  SettlementHeader.SettlementCreatedOn AS SettlementCreatedOn,
  SettlementHeader.SettlmtCat AS SettlmtCat,
  SettlementHeader.SettlementStatusObject AS SettlementStatusObject,
  SettlementHeader.ContractQtyCancellationUUID AS ContractQtyCancellationUUID,
  SettlementHeader.SettlementType AS SettlementType,
  StatusCode
FROM I_SettlementUnitHeader AS SettlementHeader
;

Learn More