I_SettlementHeaderUnit

DDL: I_SETTLEMENTHEADERUNIT SQL: ISTLHEADERUNIT Type: view BASIC
16 Fields 2 Data Sources

ACM: Settlement Unit Data

I_SettlementHeaderUnit is a Basic CDS View that provides data about "ACM: Settlement Unit Data" in SAP S/4HANA. It reads from 2 data sources (P_SettlementUnitHeader, I_ObjectStatus) and exposes 16 fields with key field SettlementUnitUUID.

Data Sources (2)

SourceAliasJoin Type
P_SettlementUnitHeader SettlementHeader from
I_ObjectStatus StatusObjectActiveStatus left_outer

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName ISTLHEADERUNIT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true 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 (16)

KeyFieldSource TableSource FieldDescription
KEY SettlementUnitUUID SettlementUnitUUID STL Hdr GUID
ContractApplicationUUID P_SettlementUnitHeader ContractApplicationUUID GUID (Hex) Specified by the Application
ContractApplicationVersion P_SettlementUnitHeader ContractApplicationVersion Application Version
ContractNum P_SettlementUnitHeader ContractNum Trading Contract
ContractItem P_SettlementUnitHeader ContractItem Purchase Contract Item
ContractCommodityItem P_SettlementUnitHeader ContractCommodityItem Com. item num.
SettlementCreatedOn P_SettlementUnitHeader SettlementCreatedOn Variant created on
SettlmtCat P_SettlementUnitHeader SettlmtCat Settl. Category
ContractApplicationDocument P_SettlementUnitHeader ContractApplicationDocument Appl. Document No.
ApplicationDocumentItem P_SettlementUnitHeader ApplicationDocumentItem Item No.
SettlementStatusObject
ContractQtyCancellationUUID P_SettlementUnitHeader ContractQtyCancellationUUID Contract GUID
SettlementType P_SettlementUnitHeader SettlementType Settlement Type
SettlmtDoc P_SettlementUnitHeader SettlmtDoc Settlement Doc.
SettlmtDocYear P_SettlementUnitHeader SettlmtDocYear Setl Unit Year
StatusCode I_ObjectStatus 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_SettlementHeaderUnit.
-- 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: ISTLHEADERUNIT

CREATE VIEW I_SettlementHeaderUnit AS
SELECT
  SettlementUnitUUID,
  SettlementHeader.ContractApplicationUUID AS ContractApplicationUUID,
  SettlementHeader.ContractApplicationVersion AS ContractApplicationVersion,
  SettlementHeader.ContractNum AS ContractNum,
  SettlementHeader.ContractItem AS ContractItem,
  SettlementHeader.ContractCommodityItem AS ContractCommodityItem,
  SettlementHeader.SettlementCreatedOn AS SettlementCreatedOn,
  SettlementHeader.SettlmtCat AS SettlmtCat,
  SettlementHeader.ContractApplicationDocument AS ContractApplicationDocument,
  SettlementHeader.ApplicationDocumentItem AS ApplicationDocumentItem,
  SettlementHeader.ContractQtyCancellationUUID AS ContractQtyCancellationUUID,
  SettlementHeader.SettlementType AS SettlementType,
  SettlementHeader.SettlmtDoc AS SettlmtDoc,
  SettlementHeader.SettlmtDocYear AS SettlmtDocYear,
  StatusObjectActiveStatus.StatusCode AS StatusCode
FROM P_SettlementUnitHeader AS SettlementHeader
LEFT OUTER JOIN I_ObjectStatus AS StatusObjectActiveStatus ON /* join condition not captured in parsed metadata */
;

Learn More