P_SettlementGrpHeader

DDL: P_SETTLEMENTGRPHEADER Type: view_entity COMPOSITE
19 Fields 2 Data Sources

P_SettlementGrpHeader is a Composite CDS View in SAP S/4HANA. It reads from 2 data sources (I_ACMSettlmtDocCtnData, I_SettlementGroupHeader) and exposes 19 fields with key fields SettlementDocGroupUUID, SettlementGroupId, SettlementFiscalYear.

Data Sources (2)

SourceAliasJoin Type
I_ACMSettlmtDocCtnData _SettlementDocContainer inner
I_SettlementGroupHeader _SettlementGroupHeader from

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #COMPOSITE view
VDM.private true view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view
Metadata.ignorePropagatedAnnotations true view
AccessControl.personalData.blocking #NOT_REQUIRED view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY SettlementDocGroupUUID I_SettlementGroupHeader SettlementDocGroupUUID UUID 22 char.
KEY SettlementGroupId I_SettlementGroupHeader SettlementGroupId UUID
KEY SettlementFiscalYear I_SettlementGroupHeader SettlementFiscalYear Fiscal Year of Settlement
SettlementDocHeaderUUID I_ACMSettlmtDocCtnData SettlementDocHeaderUUID STL Hdr GUID
SettlementAmount I_SettlementGroupHeader SettlementAmount Tax-Exclusive Amount
SettlementAmountCurrency I_SettlementGroupHeader SettlementAmountCurrency Doc. Currency
ABDNumber I_SettlementGroupHeader ABDNumber Document Number
SettlementScenario I_SettlementGroupHeader SettlementScenario Settl Scenario
ThresholdPercentage I_SettlementGroupHeader ThresholdPercentage Threshold Percentage
DPQSinSettlementIndicator I_SettlementGroupHeader DPQSinSettlementIndicator Ignore DPQS
SettlmtDocCat I_SettlementGroupHeader SettlmtDocCat Settlement Document Category
Counterparty I_SettlementGroupHeader Counterparty Supplier
Side I_SettlementGroupHeader Side Side
CompanyCode I_SettlementGroupHeader CompanyCode Receiver Company Code
ContractPlant I_SettlementGroupHeader ContractPlant Receiving Plant
StopSettlementIsRelease I_SettlementGroupHeader StopSettlementIsRelease Stop Settlement
ReferenceVendor I_SettlementGroupHeader ReferenceVendor Vendor no.
CustomerNum I_SettlementGroupHeader CustomerNum Customer
ACMSettlementStatusObject I_SettlementGroupHeader ACMSettlementStatusObject Object number

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 P_SettlementGrpHeader.
-- 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.

CREATE VIEW P_SettlementGrpHeader AS
SELECT
  _SettlementGroupHeader.SettlementDocGroupUUID AS SettlementDocGroupUUID,
  _SettlementGroupHeader.SettlementGroupId AS SettlementGroupId,
  _SettlementGroupHeader.SettlementFiscalYear AS SettlementFiscalYear,
  _SettlementDocContainer.SettlementDocHeaderUUID AS SettlementDocHeaderUUID,
  _SettlementGroupHeader.SettlementAmount AS SettlementAmount,
  _SettlementGroupHeader.SettlementAmountCurrency AS SettlementAmountCurrency,
  _SettlementGroupHeader.ABDNumber AS ABDNumber,
  _SettlementGroupHeader.SettlementScenario AS SettlementScenario,
  _SettlementGroupHeader.ThresholdPercentage AS ThresholdPercentage,
  _SettlementGroupHeader.DPQSinSettlementIndicator AS DPQSinSettlementIndicator,
  _SettlementGroupHeader.SettlmtDocCat AS SettlmtDocCat,
  _SettlementGroupHeader.Counterparty AS Counterparty,
  _SettlementGroupHeader.Side AS Side,
  _SettlementGroupHeader.CompanyCode AS CompanyCode,
  _SettlementGroupHeader.ContractPlant AS ContractPlant,
  _SettlementGroupHeader.StopSettlementIsRelease AS StopSettlementIsRelease,
  _SettlementGroupHeader.ReferenceVendor AS ReferenceVendor,
  _SettlementGroupHeader.CustomerNum AS CustomerNum,
  _SettlementGroupHeader.ACMSettlementStatusObject AS ACMSettlementStatusObject
FROM I_SettlementGroupHeader AS _SettlementGroupHeader
INNER JOIN I_ACMSettlmtDocCtnData AS _SettlementDocContainer ON /* join condition not captured in parsed metadata */
;

Learn More