I_ACMSettlementGroupHeaderDet

DDL: I_ACMSETTLEMENTGROUPHEADERDET SQL: ISETTLGRPHEADDET Type: view COMPOSITE
16 Fields 2 Data Sources

ACM Settlement Group Header Details

I_ACMSettlementGroupHeaderDet is a Composite CDS View that provides data about "ACM Settlement Group Header Details" in SAP S/4HANA. It reads from 2 data sources (I_ACMSettlmtLienDocContainer, I_ACMSettlementGroupHeaderData) and exposes 16 fields with key fields SettlementGroupId, SettlementGroupYear.

Data Sources (2)

SourceAliasJoin Type
I_ACMSettlmtLienDocContainer _SettlementDocContainer inner
I_ACMSettlementGroupHeaderData _SettlementGroupHeader from

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName ISETTLGRPHEADDET view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.type #INHERITED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label ACM Settlement Group Header Details view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY SettlementGroupId I_ACMSettlementGroupHeaderData SettlementGroupId UUID
KEY SettlementGroupYear I_ACMSettlementGroupHeaderData SettlementGroupYear Grp Yr
SettlementDocGroupUUID I_ACMSettlementGroupHeaderData SettlementDocGroupUUID UUID 22 char.
ACMSettlmtDocPaytSpltCreatedBy I_ACMSettlementGroupHeaderData ACMSettlmtDocPaytSpltCreatedBy Version Created By
ACMSettlmtDocCreatedByName CreatedByName UserDescription Full Name
SettlementAmountCurrency I_ACMSettlementGroupHeaderData SettlementAmountCurrency Doc. Currency
SettlementAmount I_ACMSettlementGroupHeaderData SettlementAmount Tax-Exclusive Amount
Counterparty I_ACMSettlementGroupHeaderData Counterparty Supplier
ACMSettlementDocCategory I_ACMSettlementGroupHeaderData ACMSettlementDocCategory Document Category
PrmtHbPaymentMethod I_ACMSettlementGroupHeaderData PrmtHbPaymentMethod Pymt Meth.
SettlementGroupPaymentTerms I_ACMSettlementGroupHeaderData SettlementGroupPaymentTerms Payment Term
AlternatePaymentTerm I_ACMSettlementGroupHeaderData AlternatePaymentTerm Alt. Payment Type
PaymentDate I_ACMSettlementGroupHeaderData PaymentDate Payment Date
SettlementCreatedOn I_ACMSettlementGroupHeaderData SettlementCreatedOn
ACMSettlementReasonType ACMSettlementReasonCode ACMSettlementReasonType
ACMSettlementApprovalDate ACMSettlementReasonCode SettlementCreatedOn

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_ACMSettlementGroupHeaderDet.
-- 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: ISETTLGRPHEADDET

CREATE VIEW I_ACMSettlementGroupHeaderDet AS
SELECT
  _SettlementGroupHeader.SettlementGroupId AS SettlementGroupId,
  _SettlementGroupHeader.SettlementGroupYear AS SettlementGroupYear,
  _SettlementGroupHeader.SettlementDocGroupUUID AS SettlementDocGroupUUID,
  _SettlementGroupHeader.ACMSettlmtDocPaytSpltCreatedBy AS ACMSettlmtDocPaytSpltCreatedBy,
  CreatedByName.UserDescription AS ACMSettlmtDocCreatedByName,
  _SettlementGroupHeader.SettlementAmountCurrency AS SettlementAmountCurrency,
  _SettlementGroupHeader.SettlementAmount AS SettlementAmount,
  _SettlementGroupHeader.Counterparty AS Counterparty,
  _SettlementGroupHeader.ACMSettlementDocCategory AS ACMSettlementDocCategory,
  _SettlementGroupHeader.PrmtHbPaymentMethod AS PrmtHbPaymentMethod,
  _SettlementGroupHeader.SettlementGroupPaymentTerms AS SettlementGroupPaymentTerms,
  _SettlementGroupHeader.AlternatePaymentTerm AS AlternatePaymentTerm,
  _SettlementGroupHeader.PaymentDate AS PaymentDate,
  _SettlementGroupHeader.SettlementCreatedOn AS SettlementCreatedOn,
  ACMSettlementReasonCode.ACMSettlementReasonType AS ACMSettlementReasonType,
  ACMSettlementReasonCode.SettlementCreatedOn AS ACMSettlementApprovalDate
FROM I_ACMSettlementGroupHeaderData AS _SettlementGroupHeader
INNER JOIN I_ACMSettlmtLienDocContainer AS _SettlementDocContainer ON /* join condition not captured in parsed metadata */
;

Learn More