I_SettlementHeaderUnitDetail

DDL: I_SETTLEMENTHEADERUNITDETAIL SQL: ISTLHEADUNITDET Type: view BASIC
15 Fields 1 Data Sources

Settlement Header Unit Details

I_SettlementHeaderUnitDetail is a Basic CDS View that provides data about "Settlement Header Unit Details" in SAP S/4HANA. It reads from 1 data source (P_SettlementUnitHeader) and exposes 15 fields with key field SettlementUnitUUID.

Data Sources (1)

SourceAliasJoin Type
P_SettlementUnitHeader SettlementHeader from

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName ISTLHEADUNITDET 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 Settlement Header Unit Details view

Fields (15)

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
ACMContractItemNumber P_SettlementUnitHeader ContractItem Purchase Contract Item
ContractCommodityItem P_SettlementUnitHeader ContractCommodityItem Com. item num.
QtyHistoryCreationDateTime
SettlmtCat P_SettlementUnitHeader SettlmtCat Settl. Category
ContractApplicationDocument P_SettlementUnitHeader ContractApplicationDocument Appl. Document No.
ApplicationDocumentItem P_SettlementUnitHeader ApplicationDocumentItem Item No.
SettlementStatusObject P_SettlementUnitHeader 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

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_SettlementHeaderUnitDetail.
-- 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: ISTLHEADUNITDET

CREATE VIEW I_SettlementHeaderUnitDetail AS
SELECT
  SettlementUnitUUID,
  SettlementHeader.ContractApplicationUUID AS ContractApplicationUUID,
  SettlementHeader.ContractApplicationVersion AS ContractApplicationVersion,
  SettlementHeader.ContractNum AS ContractNum,
  SettlementHeader.ContractItem AS ACMContractItemNumber,
  SettlementHeader.ContractCommodityItem AS ContractCommodityItem,
  cast(SettlementHeader.SettlementCreatedOn as /accgo/e_change_timestamp) AS QtyHistoryCreationDateTime,
  SettlementHeader.SettlmtCat AS SettlmtCat,
  SettlementHeader.ContractApplicationDocument AS ContractApplicationDocument,
  SettlementHeader.ApplicationDocumentItem AS ApplicationDocumentItem,
  SettlementHeader.SettlementStatusObject AS SettlementStatusObject,
  SettlementHeader.ContractQtyCancellationUUID AS ContractQtyCancellationUUID,
  SettlementHeader.SettlementType AS ACMTrdgContrSettlementType,
  SettlementHeader.SettlmtDoc AS SettlmtDoc,
  SettlementHeader.SettlmtDocYear AS SettlmtDocYear
FROM P_SettlementUnitHeader AS SettlementHeader
;

Learn More