P_CtrlgSettlmtLastDoc

DDL: P_CTRLGSETTLMTLASTDOC SQL: PSETTLMTLASTDOC Type: view CONSUMPTION Package: ODATA_SETTLEMENT
13 Fields 2 Data Sources

Possible senders for settled object

P_CtrlgSettlmtLastDoc is a Consumption CDS View that provides data about "Possible senders for settled object" in SAP S/4HANA. It reads from 2 data sources (I_CtrlgSettlementDocument, P_CtrlgSettlmtLastDocNumber) and exposes 13 fields with key field ControllingSettlementDocument. Part of development package ODATA_SETTLEMENT.

Data Sources (2)

SourceAliasJoin Type
I_CtrlgSettlementDocument _CtrlgSettlementDocument inner
P_CtrlgSettlmtLastDocNumber _CtrlgSettlmtLastDocNumber from

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName PSETTLMTLASTDOC view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #CONSUMPTION view
VDM.private true view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY ControllingSettlementDocument I_CtrlgSettlementDocument ControllingSettlementDocument SD Document
ControllingArea I_CtrlgSettlementDocument ControllingArea Controlling Area
PostingDate I_CtrlgSettlementDocument PostingDate Posting Date for GR
AssetValueDate I_CtrlgSettlementDocument AssetValueDate Reference date
CreationDate
ValueDate I_CtrlgSettlementDocument ValueDate Value Date
FiscalYear I_CtrlgSettlementDocument FiscalYear G/L Fiscal Year
SettlementPeriod I_CtrlgSettlementDocument SettlementPeriod Time unit
ControllingObject I_CtrlgSettlementDocument ControllingObject Object number
PostingPeriod I_CtrlgSettlementDocument PostingPeriod Posting Period
CreationDateTime I_CtrlgSettlementDocument CreationDateTime Timestamp
DocumentDate I_CtrlgSettlementDocument DocumentDate Journal Entry Date
IsReversed I_CtrlgSettlementDocument IsReversed Reversed?

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_CtrlgSettlmtLastDoc.
-- 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: PSETTLMTLASTDOC

CREATE VIEW P_CtrlgSettlmtLastDoc AS
SELECT
  _CtrlgSettlementDocument.ControllingSettlementDocument AS ControllingSettlementDocument,
  _CtrlgSettlementDocument.ControllingArea AS ControllingArea,
  _CtrlgSettlementDocument.PostingDate AS PostingDate,
  _CtrlgSettlementDocument.AssetValueDate AS AssetValueDate,
  cast( _CtrlgSettlementDocument.CreationDate as fco_settlmt_last_settled_on) AS CreationDate,
  _CtrlgSettlementDocument.ValueDate AS ValueDate,
  _CtrlgSettlementDocument.FiscalYear AS FiscalYear,
  _CtrlgSettlementDocument.SettlementPeriod AS SettlementPeriod,
  _CtrlgSettlementDocument.ControllingObject AS ControllingObject,
  _CtrlgSettlementDocument.PostingPeriod AS PostingPeriod,
  _CtrlgSettlementDocument.CreationDateTime AS CreationDateTime,
  _CtrlgSettlementDocument.DocumentDate AS DocumentDate,
  _CtrlgSettlementDocument.IsReversed AS IsReversed
FROM P_CtrlgSettlmtLastDocNumber AS _CtrlgSettlmtLastDocNumber
INNER JOIN I_CtrlgSettlementDocument AS _CtrlgSettlementDocument ON /* join condition not captured in parsed metadata */
;

Learn More