I_SettlementUnitHeader

DDL: I_SETTLEMENTUNITHEADER SQL: ISTLUNITHEADER Type: view BASIC
16 Fields 2 Data Sources

ACM: Settlement Unit Data

I_SettlementUnitHeader 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_ObjectStatusSettlement) and exposes 16 fields with key field SettlementUnitUUID.

Data Sources (2)

SourceAliasJoin Type
P_SettlementUnitHeader SettlementHeader from
I_ObjectStatusSettlement StatusObjectActiveStatus left_outer

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName ISTLUNITHEADER 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_ObjectStatusSettlement 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_SettlementUnitHeader.
-- 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: ISTLUNITHEADER

CREATE VIEW I_SettlementUnitHeader 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_ObjectStatusSettlement AS StatusObjectActiveStatus ON /* join condition not captured in parsed metadata */
;

Learn More