I_ACMActiveSettlmtUnitHeader

DDL: I_ACMACTIVESETTLMTUNITHEADER SQL: ACTIVESETLDATA Type: view BASIC
16 Fields 2 Data Sources

Active Settlement Header Data

I_ACMActiveSettlmtUnitHeader is a Basic CDS View that provides data about "Active Settlement Header 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 inner

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName ACTIVESETLDATA view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.type #INHERITED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #BASIC view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
EndUserText.label Active Settlement Header 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
TradingContractItem P_SettlementUnitHeader ContractItem Purchase Contract Item
ContractCommodityItem P_SettlementUnitHeader ContractCommodityItem Com. item num.
SettlementCreatedOn
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
ACMTrdgContrSettlementType 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_ACMActiveSettlmtUnitHeader.
-- 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: ACTIVESETLDATA

CREATE VIEW I_ACMActiveSettlmtUnitHeader AS
SELECT
  SettlementUnitUUID,
  SettlementHeader.ContractApplicationUUID AS ContractApplicationUUID,
  SettlementHeader.ContractApplicationVersion AS ContractApplicationVersion,
  SettlementHeader.ContractNum AS ContractNum,
  SettlementHeader.ContractItem AS TradingContractItem,
  SettlementHeader.ContractCommodityItem AS ContractCommodityItem,
  cast (SettlementHeader.SettlementCreatedOn as abap.dec(15,0)) AS SettlementCreatedOn,
  SettlementHeader.SettlmtCat AS SettlmtCat,
  SettlementHeader.ContractApplicationDocument AS ContractApplicationDocument,
  SettlementHeader.ApplicationDocumentItem AS ApplicationDocumentItem,
  SettlementHeader.ContractQtyCancellationUUID AS ContractQtyCancellationUUID,
  SettlementHeader.SettlementType AS ACMTrdgContrSettlementType,
  SettlementHeader.SettlmtDoc AS SettlmtDoc,
  SettlementHeader.SettlmtDocYear AS SettlmtDocYear,
  StatusObjectActiveStatus.StatusCode AS StatusCode
FROM P_SettlementUnitHeader AS SettlementHeader
INNER JOIN I_ObjectStatusSettlement AS StatusObjectActiveStatus ON /* join condition not captured in parsed metadata */
;

Learn More